MACINVAOC – No description in the Lawson data dictionary
- System
- Matching (MA)
- Prefix
MAO- Primary key
COMPANY,VENDOR,EDI-NBR,INVOICE,SEQ-NBR,AOC-CODE- Fields
- 47
- Updated by
- 3 programs
- Referenced by
- 0 programs
MACINVAOC is a Lawson Matching table (prefix MAO); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SEQ-NBR, AOC-CODE (MAOSET1). It is updated by MA54.1, MA54.7 and MA540. The table has 47 fields, 1 index and 0 documented relations.
About MACINVAOC
No description in the Lawson data dictionary.
Fields (47)
Column = COBOL field name without the MAO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MAO-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. | MA54.1, MA54.7, MA540 |
MAO-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | MA54.1, MA54.7, MA540 |
MAO-EDI-NBR PKEDI_NBR | Alpha 15 | — | MA54.1, MA54.7, MA540 |
MAO-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | MA54.1, MA54.7, MA540 |
MAO-SUFFIXSUFFIX | Numeric 3 | This is the suffix for the invoice. | MA540 |
MAO-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | MA54.7, MA540 |
MAO-LINE-NBRLINE_NBR | Numeric 6 | This field contains the line number. | MA54.7, MA540 |
MAO-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | MA540 |
MAO-PO-RELEASEPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | MA540 |
MAO-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | MA540 |
MAO-AOC-CODE PKAOC_CODE | Alpha 2 | This field contains the identifier for the add on cost associated with this line item. | MA54.1, MA54.7, MA540 |
MAO-ENT-AOC-AMOUNTENT_AOC_AMOUNT | Signed 18.2 | — | MA54.1, MA54.7, MA540 |
MAO-DST-ACCT-UNITDST_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. | MA54.1, MA54.7, MA540 |
MAO-DST-ACCOUNTDST_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. | MA54.1, MA54.7, MA540 |
MAO-DST-SUB-ACCTDST_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. | MA54.1, MA54.7, MA540 |
MAO-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | MA54.1, MA54.7, MA540 |
MAO-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | MA54.1, MA54.7, MA540 |
MAO-BILL-CATEGORYBILL_CATEGORY | Alpha 32 | — | MA54.1, MA54.7, MA540 |
MAO-PURCH-FR-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | MA540 |
MAO-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | MA540 |
MAO-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. | MA540 |
MAO-ENTRYENTRY | Alpha 1 | Amount Entry Method. | MA540 |
MAO-QUANTITYQUANTITY | Signed 13.4 | This field contains the desired quantity. | MA54.7, MA540 |
MAO-UNIT-COSTUNIT_COST | Signed 18.5 | — | MA540 |
MAO-TOTAL-AOCTOTAL_AOC | Signed 18.2 | — | MA540 |
MAO-ELEMENT-VALELEMENT_VAL | Alpha 32 Occurs 10 Times ×10 | — | MA540 |
MAO-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | MA540 |
MAO-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Defines if Taxable.
| MA540 |
MAO-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. | MA540 |
MAO-LANDED-FLAGLANDED_FLAG | Numeric 1 | This field notes it the AOC is to be landed based on the AOC code. Landed would denote that the AOC will take on the attributes of the goods line, account, qty etc.
| MA540 |
MAO-LAND-UNIT-CSTLAND_UNIT_CST | Signed 18.5 | — | MA540 |
MAO-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. | MA540 |
MAO-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. | MA540 |
MAO-ZERO-COST-FLGZERO_COST_FLG | Alpha 1 | Defines if this tax record is allowed to have a zero unit cost. | MA540 |
MAO-CANCELLED-FLCANCELLED_FL | Alpha 1 | — | — |
MAO-CLOSED-FLCLOSED_FL | Alpha 1 | The Closed Flag. | — |
MAO-INV-SPRD-CRETINV_SPRD_CRET | Numeric 1 | Defines if record was created during PO invoice spread. | MA540 |
MAO-ACCR-TAX-AMTACCR_TAX_AMT | Signed 18.2 | — | MA540 |
MAO-EXT-TAX-AMTEXT_TAX_AMT | Signed 18.2 | — | MA540 |
MAO-BL-INVC-AMTBL_INVC_AMT | Signed 18.2 | — | MA540 |
MAO-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. | — |
MAO-MATCH-REF-NBRMATCH_REF_NBR | Alpha 22 | — | MA540 |
MAO-INV-TAX-AMOUNTINV_TAX_AMOUNT | Signed 18.2 | Tax amount on the invoice | MA540 |
MAO-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. | MA54.1, MA54.7, MA540 |
MAO-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
MAO-REC-CNV-RATEREC_CNV_RATE | Signed 14.7 | Currency conversion rate at Purchase Order entry time. | — |
MAO-TRACK-TYPETRACK_TYPE | Alpha 1 | " " = Other AOC
| — |
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 |
|---|---|---|---|---|
MAOSET1 | COMPANY, VENDOR, EDI-NBR, INVOICE, SEQ-NBR, AOC-CODE | Primary | MA54.1, MA54.7, MA540 |