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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`MAO-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.	MA54.1, MA54.7, MA540
#`MAO-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	MA54.1, MA54.7, MA540
#`MAO-EDI-NBR` PK EDI_NBR	Alpha 15	—	MA54.1, MA54.7, MA540
#`MAO-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	MA54.1, MA54.7, MA540
#`MAO-SUFFIX` SUFFIX	Numeric 3	This is the suffix for the invoice.	MA540
#`MAO-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	MA54.7, MA540
#`MAO-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number.	MA54.7, MA540
#`MAO-PO-NUMBER` PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order.	MA540
#`MAO-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	MA540
#`MAO-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code.	MA540
#`MAO-AOC-CODE` PK AOC_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-AMOUNT` ENT_AOC_AMOUNT	Signed 18.2	—	MA54.1, MA54.7, MA540
#`MAO-DST-ACCT-UNIT` DST_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-ACCOUNT` DST_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-ACCT` DST_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-ACTIVITY` ACTIVITY	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-CATEGORY` ACCT_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-CATEGORY` BILL_CATEGORY	Alpha 32	—	MA54.1, MA54.7, MA540
#`MAO-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	The vendor's purchase from location.	MA540
#`MAO-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	MA540
#`MAO-AOC-RATE` AOC_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-ENTRY` ENTRY	Alpha 1	Amount Entry Method.	MA540
#`MAO-QUANTITY` QUANTITY	Signed 13.4	This field contains the desired quantity.	MA54.7, MA540
#`MAO-UNIT-COST` UNIT_COST	Signed 18.5	—	MA540
#`MAO-TOTAL-AOC` TOTAL_AOC	Signed 18.2	—	MA540
#`MAO-ELEMENT-VAL` ELEMENT_VAL	Alpha 32 Occurs 10 Times ×10	—	MA540
#`MAO-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	MA540
#`MAO-TAXABLE-FLAG` TAXABLE_FLAG	Alpha 1	Defines if Taxable. `Y` yES `N` No	MA540
#`MAO-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.	MA540
#`MAO-LANDED-FLAG` LANDED_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. `0` No `1` Landed	MA540
#`MAO-LAND-UNIT-CST` LAND_UNIT_CST	Signed 18.5	—	MA540
#`MAO-AOC-ON-PO` AOC_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-FLAG` SUMMARY_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-FLG` ZERO_COST_FLG	Alpha 1	Defines if this tax record is allowed to have a zero unit cost.	MA540
#`MAO-CANCELLED-FL` CANCELLED_FL	Alpha 1	—	—
#`MAO-CLOSED-FL` CLOSED_FL	Alpha 1	The Closed Flag.	—
#`MAO-INV-SPRD-CRET` INV_SPRD_CRET	Numeric 1	Defines if record was created during PO invoice spread.	MA540
#`MAO-ACCR-TAX-AMT` ACCR_TAX_AMT	Signed 18.2	—	MA540
#`MAO-EXT-TAX-AMT` EXT_TAX_AMT	Signed 18.2	—	MA540
#`MAO-BL-INVC-AMT` BL_INVC_AMT	Signed 18.2	—	MA540
#`MAO-XREF-VENDOR` XREF_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-NBR` MATCH_REF_NBR	Alpha 22	—	MA540
#`MAO-INV-TAX-AMOUNT` INV_TAX_AMOUNT	Signed 18.2	Tax amount on the invoice	MA540
#`MAO-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.	MA54.1, MA54.7, MA540
#`MAO-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
#`MAO-REC-CNV-RATE` REC_CNV_RATE	Signed 14.7	Currency conversion rate at Purchase Order entry time.	—
#`MAO-TRACK-TYPE` TRACK_TYPE	Alpha 1	" " = Other AOC `I` Insurance `F` Freight `C` Customs Charges	—

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
`MAOSET1`	`COMPANY` `VENDOR` `EDI-NBR` `INVOICE` `SEQ-NBR` `AOC-CODE`	Primary		MA54.1, MA54.7, MA540

Programs

Updated by (3)

MA54.1 Invoice
MA54.7 Add-on Charge Line Details
MA540 Invoice Interface

MACINVAOC – No description in the Lawson data dictionary

About MACINVAOC

Fields (47) Copy as SQL

Indexes (1)

Programs

Updated by (3)

Fields (47)