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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MRL-COMPANY PKCOMPANY | 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 PKREFERENCE_NO | Alpha 25 (Right Justified) | — | MA53.1, MA531 |
#MRL-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | MA53.1, MA531 |
#MRL-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | MA53.1 |
#MRL-REC-NUMBERREC_NUMBER | Numeric 10 | The receiver number. Assigned when this receiving information was added. | MA531 |
#MRL-ITEMITEM | Alpha 32 | This field contains the item identifier. | MA53.1, MA531 |
#MRL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | MA53.1, MA531 |
#MRL-ITEM-TYPEITEM_TYPE | Alpha 1 | This field identifies the line item type. | MA53.1, MA531 |
#MRL-VEN-ITEMVEN_ITEM | Alpha 32 | This field contains the item identifier. | MA53.1, MA531 |
#MRL-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | MA53.1, MA531 |
#MRL-ENT-REC-QTYENT_REC_QTY | Signed 13.4 | This field contains the desired quantity. | MA53.1, MA531 |
#MRL-ENT-REC-UOMENT_REC_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA53.1, MA531 |
#MRL-ENT-RUOM-MULTENT_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-QTYCATCH_WT_QTY | Signed 13.4 | This field contains the desired quantity. | MA53.1, MA531 |
#MRL-ORIG-UNIT-CSTORIG_UNIT_CST | Signed 18.5 | — | MA53.1, MA531 |
#MRL-BINBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | MA531 |
#MRL-CANCEL-BO-FLCANCEL_BO_FL | Alpha 1 | — | MA53.1, MA531 |
#MRL-REC-COMMENTSREC_COMMENTS | Alpha 100 (Lower Case) | — | MA53.1 |
#MRL-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction. | MA53.1, MA531 |
#MRL-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | MA53.1, MA531 |
#MRL-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | MA53.1, MA531 |
#MRL-ELEMENT-01ELEMENT_01 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-02ELEMENT_02 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-03ELEMENT_03 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-04ELEMENT_04 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-05ELEMENT_05 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-06ELEMENT_06 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-07ELEMENT_07 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-08ELEMENT_08 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-09ELEMENT_09 | Alpha 32 | — | MA53.1, MA531 |
#MRL-ELEMENT-10ELEMENT_10 | Alpha 32 | — | MA53.1, MA531 |
#MRL-VPRI-QUANTITYVPRI_QUANTITY | Signed 13.4 | This field contains the desired quantity. | MA531 |
#MRL-VPRI-UOMVPRI_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA53.1, MA531 |
#MRL-VPRI-UOM-MULTVPRI_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-QTYBUOM_QTY | Signed 13.4 | This field contains the desired quantity. | MA531 |
#MRL-VBUY-UOMVBUY_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA531 |
#MRL-VBUY-UOM-MULTVBUY_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-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | MA53.1, MA531 |
#MRL-ACCT-UNITACCT_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-ACCOUNTACCOUNT | 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-ACCTSUB_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-CDTAX_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-FLAGMSDS_FLAG | Alpha 1 | — | MA53.1, MA531 |
#MRL-MSDS-VERSIONMSDS_VERSION | Alpha 4 | The version number of the most recent MSDS that was received. | MA53.1, MA531 |
#MRL-MSDS-DOCUMENTMSDS_DOCUMENT | Alpha 30 | The document number from the most recent MSDS that was received. | MA53.1, MA531 |
#MRL-SEGMENT-BLOCKSEGMENT_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-COSTCATCH_WGT_COST | Signed 18.5 | — | — |
#MRL-TAX-UNIT-CSTTAX_UNIT_CST | Signed 18.5 | — | — |
#MRL-INSP-REQ-FLINSP_REQ_FL | Alpha 1 | — | MA53.1 |
#MRL-COMMODITY-CODECOMMODITY_CODE | Alpha 35 | — | MA53.1 |
#MRL-PROD-TAX-CATPROD_TAX_CAT | Alpha 15 | — | MA531 |
#MRL-GTINGTIN | Numeric 14 | — | MA53.1 |
#MRL-LOCATION-GLNLOCATION_GLN | Alpha 13 | — | — |
#MRL-BIN-GLNBIN_GLN | Alpha 13 | — | — |
#MRL-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | MA53.1 |
Indexes (1)
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 |
|---|---|---|---|---|
MRLSET1 |
| Primary | MA53.1, MA53.5, MA531 |