MACRECAOC – MA Record Add on Cost
- System
- Matching (MA)
- Prefix
MRA- Primary key
COMPANY,REFERENCE-NO,LINE-NBR,AOC-CODE,SEQ-NBR- Fields
- 44
- Updated by
- 3 programs
- Referenced by
- 0 programs
MACRECAOC is the MA Record Add on Cost table in Lawson Matching (prefix MRA). It is indexed by COMPANY, REFERENCE-NO, LINE-NBR, AOC-CODE, SEQ-NBR (MRASET1). It is updated by MA53.1, MA53.6 and MA531. The table has 44 fields, 1 index and 0 documented relations.
About MACRECAOC
No description in the Lawson data dictionary.
Fields (44)
Column = COBOL field name without the MRA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MRA-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, MA53.6, MA531 |
MRA-REFERENCE-NO PKREFERENCE_NO | Alpha 25 (Right Justified) | — | MA53.1, MA53.6, MA531 |
MRA-VENDORVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | MA53.1, MA53.6 |
MRA-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | MA53.1, MA53.6, MA531 |
MRA-AOC-CODE PKAOC_CODE | Alpha 2 | This field contains the identifier for the add on cost associated with this line item. | MA53.1, MA53.6, MA531 |
MRA-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | MA53.1 |
MRA-REC-TYPEREC_TYPE | Alpha 1 | The file record type. | — |
MRA-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | — |
MRA-PO-RELEASEPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | — |
MRA-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | — |
MRA-PURCH-FR-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | — |
MRA-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | — |
MRA-AOC-RATEAOC_RATE | Percent 7.3 (Percent) | Add On Cost Percentage Rate. If add on cost is spread by rate, this value times the line unit cost is the unit add on cost for the PO line. | — |
MRA-ENTRYENTRY | Alpha 1 | Amount Entry Method. | — |
MRA-QUANTITYQUANTITY | Signed 13.4 | This field contains the desired quantity. | MA53.6 |
MRA-ENT-UNIT-CSTENT_UNIT_CST | Signed 18.5 | — | — |
MRA-TOTAL-AOCTOTAL_AOC | Signed 18.2 | — | MA53.1, MA53.6, MA531 |
MRA-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | — |
MRA-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Defines if Taxable. | — |
MRA-AOC-ON-POAOC_ON_PO | Alpha 1 | Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor. | — |
MRA-SUMMARY-FLAGSUMMARY_FLAG | Alpha 1 | Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document. | — |
MRA-ZERO-COST-FLGZERO_COST_FLG | Alpha 1 | Defines if this tax record is allowed to have a zero unit cost. | — |
MRA-CLOSED-FLCLOSED_FL | Alpha 1 | The Closed Flag. | — |
MRA-ELEMENT-01ELEMENT_01 | Alpha 32 | — | — |
MRA-ELEMENT-02ELEMENT_02 | Alpha 32 | — | — |
MRA-ELEMENT-03ELEMENT_03 | Alpha 32 | — | — |
MRA-ELEMENT-04ELEMENT_04 | Alpha 32 | — | — |
MRA-ELEMENT-05ELEMENT_05 | Alpha 32 | — | — |
MRA-ELEMENT-06ELEMENT_06 | Alpha 32 | — | — |
MRA-ELEMENT-07ELEMENT_07 | Alpha 32 | — | — |
MRA-ELEMENT-08ELEMENT_08 | Alpha 32 | — | — |
MRA-ELEMENT-09ELEMENT_09 | Alpha 32 | — | — |
MRA-ELEMENT-10ELEMENT_10 | Alpha 32 | — | — |
MRA-LANDED-FLAGLANDED_FLAG | Numeric 1 | — | — |
MRA-FREIGHT-TERMSFREIGHT_TERMS | Alpha 1 | Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company. | — |
MRA-VENDOR-GROUPVENDOR_GROUP | Alpha 4 | A vendor group represents a group of vendors that can be shared by one or more companies. | — |
MRA-XREF-VENDORXREF_VENDOR | Alpha 9 (Right Justified) | This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application. | — |
MRA-MATCH-REF-NBRMATCH_REF_NBR | Alpha 22 | — | — |
MRA-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
MRA-REC-CNV-RATEREC_CNV_RATE | Signed 14.7 | Currency conversion rate at Purchase Order entry time. | — |
MRA-VENDOR-GLNVENDOR_GLN | Alpha 13 | — | — |
MRA-LOCATION-GLNLOCATION_GLN | Alpha 13 | — | — |
MRA-TRACK-TYPETRACK_TYPE | Alpha 1 | " " = Other AOC
| MA53.1, MA53.6, MA531 |
MRA-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | — |
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 |
|---|---|---|---|---|
MRASET1 | COMPANY, REFERENCE-NO, LINE-NBR, AOC-CODE, SEQ-NBR | Primary | MA53.1, MA53.6, MA531 |