MACRECADJ – Receipt Adjustment
- System
- Matching (MA)
- Prefix
MRJ- Primary key
COMPANY,REC-REF-NBR,DOC-TYPE,LINE-NBR- Fields
- 64
- Updated by
- 2 programs
- Referenced by
- 0 programs
MACRECADJ is the Receipt Adjustment table in Lawson Matching (prefix MRJ). It is indexed by COMPANY, REC-REF-NBR, DOC-TYPE, LINE-NBR (MRJSET1); alternate indexes: MRJSET2. It is updated by MA53.2 and MA531. The table has 64 fields, 2 indexes and 0 documented relations.
About MACRECADJ
No description in the Lawson data dictionary.
Fields (64)
Column = COBOL field name without the MRJ- 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 |
|---|---|---|---|
#MRJ-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.2, MA531 |
#MRJ-DOC-NBR-NUMDOC_NBR_NUM | Numeric 10 | — | — |
#MRJ-DOC-TYPE PKDOC_TYPE | Alpha 2 | This field contains the type of transaction.
| MA53.2, MA531 |
#MRJ-REC-REF-NBR PKREC_REF_NBR | Alpha 25 (Right Justified) | — | MA53.2, MA531 |
#MRJ-ADJ-REF-NBRADJ_REF_NBR | Alpha 25 (Right Justified) | — | MA53.2, MA531 |
#MRJ-REFERENCE-NOREFERENCE_NO | Alpha 25 (Right Justified) | — | MA53.2, MA531 |
#MRJ-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | MA53.2, MA531 |
#MRJ-REC-NUMBERREC_NUMBER | Numeric 10 | The receiver number. Assigned when this receiving information was added. | MA531 |
#MRJ-ORIG-REF-NOORIG_REF_NO | Alpha 25 (Right Justified) | — | MA53.2 |
#MRJ-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | MA53.2, MA531 |
#MRJ-PO-RELEASEPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | MA53.2, MA531 |
#MRJ-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | MA53.2, MA531 |
#MRJ-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | MA53.2, MA531 |
#MRJ-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | MA53.2, MA531 |
#MRJ-ELEMENT-01ELEMENT_01 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-02ELEMENT_02 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-03ELEMENT_03 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-04ELEMENT_04 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-05ELEMENT_05 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-06ELEMENT_06 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-07ELEMENT_07 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-08ELEMENT_08 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-09ELEMENT_09 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-ELEMENT-10ELEMENT_10 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-VEN-ITEMVEN_ITEM | Alpha 32 | This field contains the item identifier. | MA53.2, MA531 |
#MRJ-ITEM-TYPEITEM_TYPE | Alpha 1 | This field identifies the line item type. | MA53.2, MA531 |
#MRJ-OPER-IDOPER_ID | Alpha 10 | This field is used to store the login id of the person who entered the record. | MA531 |
#MRJ-TRANS-DATETRANS_DATE | Numeric 8 (yyyymmdd) | The date of the transaction. | MA53.2, MA531 |
#MRJ-ADJ-QTYADJ_QTY | Signed 13.4 | This field contains the desired quantity. | MA53.2, MA531 |
#MRJ-ORIG-UNIT-CSTORIG_UNIT_CST | Signed 18.5 | — | MA53.2, MA531 |
#MRJ-ENT-REC-UOMENT_REC_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA53.2, MA531 |
#MRJ-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 |
#MRJ-CATCH-WT-QTYCATCH_WT_QTY | Signed 13.4 | This field contains the desired quantity. | MA531 |
#MRJ-BINBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | MA531 |
#MRJ-REC-COMMENTSREC_COMMENTS | Alpha 100 (Lower Case) | — | MA531 |
#MRJ-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction. | MA531 |
#MRJ-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | MA531 |
#MRJ-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | MA531 |
#MRJ-ACTUAL-TIMEACTUAL_TIME | Numeric 4 | This field contains the actual time the receiver was entered into the system. This filed defaults to the system date if an actual time was not entered. | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-01NEW_ELEMENT_01 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-02NEW_ELEMENT_02 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-03NEW_ELEMENT_03 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-04NEW_ELEMENT_04 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-05NEW_ELEMENT_05 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-06NEW_ELEMENT_06 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-07NEW_ELEMENT_07 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-08NEW_ELEMENT_08 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-09NEW_ELEMENT_09 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-NEW-ELEMENT-10NEW_ELEMENT_10 | Alpha 32 | — | MA53.2, MA531 |
#MRJ-VPRI-QUANTITYVPRI_QUANTITY | Signed 13.4 | This field contains the desired quantity. | MA531 |
#MRJ-VPRI-UOMVPRI_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA531 |
#MRJ-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. | MA531 |
#MRJ-VBUY-UOMVBUY_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | MA531 |
#MRJ-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 |
#MRJ-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | MA53.2, MA531 |
#MRJ-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. | MA531 |
#MRJ-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.2, MA531 |
#MRJ-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.2, MA531 |
#MRJ-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.2, MA531 |
#MRJ-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.2, MA531 |
#MRJ-RECORD-ERROR SET2RECORD_ERROR | Alpha 1 | —
| MA53.2, MA531 |
#MRJ-BIN-GLNBIN_GLN | Alpha 13 | — | — |
#MRJ-GLBL-DOC-TYPEGLBL_DOC_TYPE | Alpha 10 | — | MA53.2 |
#MRJ-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | MA53.2 |
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 |
|---|---|---|---|---|
MRJSET1 |
| Primary | MA53.2, MA53.7, MA531 | |
MRJSET2 |
| KeyChange | MA531 |