MACRECLINE – MA Record Line

System: Matching (MA)
Prefix: MRL
Primary key: COMPANY, REFERENCE-NO, LINE-NBR, SEQ-NBR
Fields: 55
Updated by: 2 programs
Referenced by: 0 programs

MACRECLINE is the MA Record Line table in Lawson Matching (prefix MRL). It is indexed by COMPANY, REFERENCE-NO, LINE-NBR, SEQ-NBR (MRLSET1). It is updated by MA53.1 and MA531. The table has 55 fields, 1 index and 0 documented relations.

About MACRECLINE

No description in the Lawson data dictionary.

Fields (55)

Column = COBOL field name without the MRL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MRL-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.1, MA531
`MRL-REFERENCE-NO` PK REFERENCE_NO	Alpha 25 (Right Justified)	—	MA53.1, MA531
`MRL-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	MA53.1, MA531
`MRL-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	MA53.1
`MRL-REC-NUMBER` REC_NUMBER	Numeric 10	The receiver number. Assigned when this receiving information was added.	MA531
`MRL-ITEM` ITEM	Alpha 32	This field contains the item identifier.	MA53.1, MA531
`MRL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	MA53.1, MA531
`MRL-ITEM-TYPE` ITEM_TYPE	Alpha 1	This field identifies the line item type.	MA53.1, MA531
`MRL-VEN-ITEM` VEN_ITEM	Alpha 32	This field contains the item identifier.	MA53.1, MA531
`MRL-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	MA53.1, MA531
`MRL-ENT-REC-QTY` ENT_REC_QTY	Signed 13.4	This field contains the desired quantity.	MA53.1, MA531
`MRL-ENT-REC-UOM` ENT_REC_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	MA53.1, MA531
`MRL-ENT-RUOM-MULT` ENT_RUOM_MULT	Signed 13.7	This field contains the multiplier for converting this unit of measure to the stock unit of measure.	MA531
`MRL-CATCH-WT-QTY` CATCH_WT_QTY	Signed 13.4	This field contains the desired quantity.	MA53.1, MA531
`MRL-ORIG-UNIT-CST` ORIG_UNIT_CST	Signed 18.5	—	MA53.1, MA531
`MRL-BIN` BIN	Alpha 7	This field contains a storage area for an item or any number of items.	MA531
`MRL-CANCEL-BO-FL` CANCEL_BO_FL	Alpha 1	—	MA53.1, MA531
`MRL-REC-COMMENTS` REC_COMMENTS	Alpha 100 (Lower Case)	—	MA53.1
`MRL-STATUS` STATUS	Numeric 1	This field displays the status of the transaction.	MA53.1, MA531
`MRL-UPDATE-DATE` UPDATE_DATE	Numeric 8 (yyyymmdd)	This field contains the date the record was updated.	MA53.1, MA531
`MRL-UPDATE-TIME` UPDATE_TIME	Numeric 6	This field contains the system time when the record was updated.	MA53.1, MA531
`MRL-ELEMENT-01` ELEMENT_01	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-02` ELEMENT_02	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-03` ELEMENT_03	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-04` ELEMENT_04	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-05` ELEMENT_05	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-06` ELEMENT_06	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-07` ELEMENT_07	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-08` ELEMENT_08	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-09` ELEMENT_09	Alpha 32	—	MA53.1, MA531
`MRL-ELEMENT-10` ELEMENT_10	Alpha 32	—	MA53.1, MA531
`MRL-VPRI-QUANTITY` VPRI_QUANTITY	Signed 13.4	This field contains the desired quantity.	MA531
`MRL-VPRI-UOM` VPRI_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	MA53.1, MA531
`MRL-VPRI-UOM-MULT` VPRI_UOM_MULT	Signed 13.7	This field contains the multiplier for converting this unit of measure to the stock unit of measure.	MA53.1, MA531
`MRL-BUOM-QTY` BUOM_QTY	Signed 13.4	This field contains the desired quantity.	MA531
`MRL-VBUY-UOM` VBUY_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	MA531
`MRL-VBUY-UOM-MULT` VBUY_UOM_MULT	Signed 13.7	This field contains the multiplier for converting this unit of measure to the stock unit of measure.	MA531
`MRL-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	MA53.1, MA531
`MRL-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	MA53.1, MA531
`MRL-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	MA53.1, MA531
`MRL-SUB-ACCT` SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	MA53.1, MA531
`MRL-TAX-USAGE-CD` TAX_USAGE_CD	Alpha 10	The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.	MA53.1, MA531
`MRL-MSDS-FLAG` MSDS_FLAG	Alpha 1	—	MA53.1, MA531
`MRL-MSDS-VERSION` MSDS_VERSION	Alpha 4	The version number of the most recent MSDS that was received.	MA53.1, MA531
`MRL-MSDS-DOCUMENT` MSDS_DOCUMENT	Alpha 30	The document number from the most recent MSDS that was received.	MA53.1, MA531
`MRL-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	MA53.1, MA531
`MRL-CATCH-WGT-COST` CATCH_WGT_COST	Signed 18.5	—	—
`MRL-TAX-UNIT-CST` TAX_UNIT_CST	Signed 18.5	—	—
`MRL-INSP-REQ-FL` INSP_REQ_FL	Alpha 1	—	MA53.1
`MRL-COMMODITY-CODE` COMMODITY_CODE	Alpha 35	—	MA53.1
`MRL-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	—	MA531
`MRL-GTIN` GTIN	Numeric 14	—	MA53.1
`MRL-LOCATION-GLN` LOCATION_GLN	Alpha 13	—	—
`MRL-BIN-GLN` BIN_GLN	Alpha 13	—	—
`MRL-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	MA53.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MRLSET1`	`COMPANY`, `REFERENCE-NO`, `LINE-NBR`, `SEQ-NBR`	Primary		MA53.1, MA53.5, MA531

Programs

Updated by (2)

MA53.1 Receipt Interface
MA531 Receipt Interface