MACRECPOT – MA Receipt Transaction

System: Matching (MA)
Prefix: MRP
Primary key: COMPANY, REFERENCE-NO, LINE-NBR, SEQ
Fields: 15
Updated by: 5 programs
Referenced by: 0 programs

MACRECPOT is the MA Receipt Transaction table in Lawson Matching (prefix MRP). It is indexed by COMPANY, REFERENCE-NO, LINE-NBR, SEQ (MRPSET1); alternate indexes: MRPSET2. It is updated by MA53.1, MA53.2, MA53.5, MA53.7 and MA531. The table has 15 fields, 2 indexes and 0 documented relations.

About MACRECPOT

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the MRP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`MRP-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	MA53.5, MA53.7, MA531
#`MRP-REFERENCE-NO` PK REFERENCE_NO	Alpha 25 (Right Justified)	—	MA53.5, MA53.7, MA531
#`MRP-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	MA53.5, MA53.7, MA531
#`MRP-SEQ` PK SEQ	Numeric 3	This field contains the record sequence number.	MA53.5, MA53.7, MA531
#`MRP-ADJ-REF-NBR` SET2 ADJ_REF_NBR	Alpha 25 (Right Justified)	—	MA53.7, MA531
#`MRP-LOT` LOT	Alpha 10	This field contains the identifier for the homogeneous quantity of material.	MA53.5, MA53.7, MA531
#`MRP-SUBLOT` SUBLOT	Alpha 6	This field contains the identifier for a detail breakdown of a lot number.	MA53.5, MA53.7, MA531
#`MRP-SERIAL` SERIAL	Alpha 16	—	MA53.5, MA53.7, MA531
#`MRP-BIN` BIN	Alpha 7	This field contains a storage area for an item or any number of items.	MA53.5, MA53.7, MA531
#`MRP-ITEM` ITEM	Alpha 32	This field contains the item identifier.	MA531
#`MRP-QUANTITY` QUANTITY	Signed 13.4	This field contains the desired quantity.	MA53.5, MA53.7, MA531
#`MRP-SECONDARY-QTY` SECONDARY_QTY	Signed 13.4	This field contains the secondary quantity, which is tracked if the item is a catch weight item. This quantity is a memo quantity only. It is not used for valuation.	MA53.5, MA53.7, MA531
#`MRP-HOLD-FLAG` HOLD_FLAG	Alpha 1	This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.	MA53.5, MA53.7, MA531
#`MRP-EXPIRE-DATE` EXPIRE_DATE	Numeric 8 (yyyymmdd)	This field contains the expiration date for an entire lot.	MA53.5, MA53.7, MA531
#`MRP-BIN-GLN` BIN_GLN	Alpha 13	—	—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MRPSET1`	`COMPANY` `REFERENCE-NO` `LINE-NBR` `SEQ`	Primary		MA53.1, MA53.2, MA53.5, MA53.7, MA531
`MRPSET2`	`COMPANY` `REFERENCE-NO` `ADJ-REF-NBR` `LINE-NBR` `SEQ`			MA531

Programs

Updated by (5)

MA53.1 Receipt Interface
MA53.2 Receipt Adjustment Interface
MA53.5 Additional Receiving Entry
MA53.7 Additional Receiving Adjustment Entry
MA531 Receipt Interface

MACRECPOT – MA Receipt Transaction

About MACRECPOT

Fields (15) Copy as SQL

Indexes (2)

Programs

Updated by (5)

Fields (15)