MACINVOICE – Invoice Conversion/Interface

System: Matching (MA)
Prefix: MAI
Primary key: COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX
Fields: 99
Updated by: 3 programs
Referenced by: 0 programs

MACINVOICE is the Invoice Conversion/Interface table in Lawson Matching (prefix MAI). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX (MAISET1); alternate indexes: MAISET2 and MAISET4. It is related 1:M to MACINVERR. It is updated by MA54.1, MA54.2 and MA540. The table has 99 fields, 3 indexes and 1 documented relation.

About MACINVOICE

No description in the Lawson data dictionary.

Fields (99)

Column = COBOL field name without the MAI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MAI-RUN-GROUP` RUN_GROUP	Alpha 15	Run group is used to group records so that data for multiple companies can be processed. NOTE Either the run group or the company is required.	MA54.1, MA540
`MAI-COMPANY` PK COMPANY	Numeric 4	Required. The company number.	MA54.1, MA540
`MAI-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	The vendor's identification code. NOTE Either the vendor ID or the EDI number is required.	MA54.1, MA540
`MAI-EDI-NBR` PK EDI_NBR	Alpha 15	The electronic data interchange (EDI) number assigned to the vendor. Used to retrieve the vendor ID. NOTE Either the EDI number or the vendor ID is required.	MA54.1, MA540
`MAI-INVOICE` PK INVOICE	Alpha 22	Required. Used to identify the invoice.	MA54.1, MA540
`MAI-SUFFIX` PK SUFFIX	Numeric 3	This is the suffix for the invoice. Zeroes will be entered.	MA54.1, MA540
`MAI-BATCH-NUM` BATCH_NUM	Numeric 6	This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	MA54.1, MA540
`MAI-VOUCHER-NBR` VOUCHER_NBR	Alpha 10	The voucher number assigned to the invoice. Used only if the company has Yes selected in the Invoice Registration Option field.	MA54.1, MA540
`MAI-AUTH-CODE` AUTH_CODE	Alpha 3	A user-defined code representing a person or department responsible for approving a registered invoice.	MA54.1, MA540
`MAI-PROC-LEVEL` PROC_LEVEL	Alpha 5	The process level represents a reporting level below company. If left blank, the AP default process level will default. If there is no AP default process level defined, this field is required.	MA54.1, MA540
`MAI-INVOICE-TYPE` INVOICE_TYPE	Alpha 1	Identifies the type of invoice. Valid values are: " " = Invoice `D` Debit Memo `C` Credit Memo	MA54.1, MA540
`MAI-INV-CURRENCY` INV_CURRENCY	Alpha 5	The currency of the invoice. Must be a valid record in the Currency Code file. If left blank, the vendor currency defaults.	MA54.1, MA540
`MAI-INVOICE-DTE` INVOICE_DTE	Numeric 8 (yyyymmdd)	Required. The date assigned to the invoice. Used when updating the vendor's purchase balance.	MA54.1, MA540
`MAI-DISTRIB-DATE` DISTRIB_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	MA54.1, MA540
`MAI-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	The vendor's purchase from location.	MA54.1, MA540
`MAI-PO-CODE` PO_CODE	Alpha 4	Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.	MA54.1, MA540
`MAI-PO-NUMBER` PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order. This field is required if the PO Required flag is set to "Yes" on the assigned invoice handling code.	MA54.1, MA540
`MAI-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	MA54.1, MA540
`MAI-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	MA54.1, MA540
`MAI-TRAN-INV-AMT` TRAN_INV_AMT	Signed 18.2	The amount of the invoice in the currency of the invoice.	MA54.1, MA540
`MAI-TRAN-ALOW-AMT` TRAN_ALOW_AMT	Signed 18.2	The amount of the invoice available for discount in the currency of the invoice. If left blank, the Invoice Amount defaults.	MA54.1, MA540
`MAI-TRAN-TXBL-AMT` TRAN_TXBL_AMT	Signed 18.2	The taxable amount of the invoice in the currency of the invoice.	MA54.1, MA540
`MAI-TRAN-TAX-AMT` TRAN_TAX_AMT	Signed 18.2	—	MA54.1, MA540
`MAI-TRAN-DISC-AMT` TRAN_DISC_AMT	Signed 18.2	The discount amount of the invoice in the currency of the invoice. If left blank, the terms code assigned to the invoice, alternate location (type P or B), or vendor, if assigned, will be used to calculate the discount amount.	MA54.1, MA540
`MAI-ORIG-CNV-RATE` ORIG_CNV_RATE	Signed 14.7	—	MA54.1, MA540
`MAI-DISCOUNT-RT` DISCOUNT_RT	Percent 5.3 (Percent)	The rate used to calculate the discount amount of the invoice. If left blank, the terms code assigned to the invoice, alternate location (type P or B), vendor, or vendor class, if assigned, will be used to calculate due date and discount information.	MA54.1, MA540
`MAI-DISC-DATE` DISC_DATE	Numeric 8 (yyyymmdd)	The discount date assigned to the invoice. Used by Cash Requirements (AP150) to determine whether a discount will be taken on the invoice. If left blank, the terms code assigned to the invoice, alternate location (type P or B), or vendor, if assigned, will be used to calculate due date and discount information.	MA54.1, MA540
`MAI-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	The transaction due date.	MA54.1, MA540
`MAI-REMIT-TO-CODE` REMIT_TO_CODE	Alpha 4	A user-defined code that represents a vendor's remittance address.	MA54.1, MA540
`MAI-RETAIL-AMT` RETAIL_AMT	Signed 18.2	The retail amount of the invoice.	MA54.1, MA540
`MAI-RCPT-INV-DATE` RCPT_INV_DATE	Numeric 8 (yyyymmdd)	The date the invoice was received.	MA54.1, MA540
`MAI-REASON-CODE` REASON_CODE	Alpha 4	This field contains the reason code, which indicates the cause for credit memos.	MA54.1, MA540
`MAI-MATCH-REF-NBR` MATCH_REF_NBR	Alpha 22	Matching reference number.	MA54.1, MA540
`MAI-HANDLING-CODE` HANDLING_CODE	Alpha 4	Invoice handling code. The invoice handling code contains processing rules for invoice matching.	MA54.1, MA540
`MAI-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	MA54.1, MA540
`MAI-TERM-CODE` TERM_CODE	Alpha 5	A user-defined code representing a method of determining invoice due and discount dates.	MA54.1, MA540
`MAI-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	MA54.1, MA540
`MAI-TAX-CODE-CNTL` TAX_CODE_CNTL	Alpha 1	This control field defines the tax code usage in invoicing and approving taxes. For PO Invoices, if set to O (Override) all lines approved for payment will use the tax code defined for the whole invoice. If set to I (Ignore) no PO lines approved for payment will be taxed. `1` Override `2` Ignore `3` Calculate `4` Override Product and AOC `5` Ignore product and AOC `6` Ignore tax tol ovr goods tax `7` Ignore tax tol ovr goods/aoc t	MA54.1, MA540
`MAI-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory system. NOTE Required if pool option for vendor/company = 3.	MA54.1, MA540
`MAI-RECORD-ERROR` RECORD_ERROR	Alpha 1	Indicates if an error was found during interface or conversion, and if the error has been corrected. Valid values are: `Y` Error found `N` No error found or error corrected	MA54.1, MA540
`MAI-CBPRINT-FL` CBPRINT_FL	Alpha 1	Print chargebacks flag. Indicates whether to generate chargebacks. `N` No `Y` Yes	MA54.1, MA540
`MAI-INVC-REF-TYPE` INVC_REF_TYPE	Alpha 2	Indicates the type of number the vendor is providing to reference the invoice.	MA54.1
`MAI-INV-USR-FLD-01` INV_USR_FLD_01	Alpha 20	Invoice user-defined field number 1.	MA54.1, MA540
`MAI-INV-USR-FLD-02` INV_USR_FLD_02	Alpha 20	Invoice user-defined field number 2.	MA54.1, MA540
`MAI-INV-USR-FLD-03` INV_USR_FLD_03	Alpha 20	Invoice user-defined field number 3.	MA54.1, MA540
`MAI-INV-USR-FLD-04` INV_USR_FLD_04	Alpha 20	Invoice user-defined field number 4.	MA54.1, MA540
`MAI-INV-USR-FLD-05` INV_USR_FLD_05	Alpha 20	Invoice user-defined field number 5.	MA54.1, MA540
`MAI-RETURN-NUMBER` RETURN_NUMBER	Numeric 10	This is the number assigned to the return for purposes of referencing the return internally and with the customer or vendor.	MA54.1, MA540
`MAI-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	MA54.1
`MAI-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, MA540
`MAI-NOTC` NOTC	Alpha 2	The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	MA54.1, MA540
`MAI-STAT-PROC` STAT_PROC	Alpha 6	The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).	MA54.1, MA540
`MAI-SHIP-VIA` SHIP_VIA	Alpha 12 (Lower Case)	—	MA54.1, MA540
`MAI-UNLOADING-PORT` UNLOADING_PORT	Alpha 5	The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)	MA54.1, MA540
`MAI-INTRASTAT-NBR` INTRASTAT_NBR	Numeric 12	The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.	—
`MAI-DROPSHIP-FL` DROPSHIP_FL	Alpha 1	This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.	MA54.1, MA540
`MAI-FOB-CODE` FOB_CODE	Alpha 3	The user defined Free On Board Code.	MA54.1, MA540
`MAI-PAY-IMM-FLAG` PAY_IMM_FLAG	Alpha 1	—	MA54.1, MA540
`MAI-DIVERSE-CODE` DIVERSE_CODE	Alpha 5	Diversity Code for Account Payable Vendors	MA54.1, MA540
`MAI-MTCH-PREPAY-FL` MTCH_PREPAY_FL	Alpha 1	Flag that notes if the invoice will be prepaid. This is for match invoices.	MA54.1
`MAI-MTCH-PREPAY-MT` MTCH_PREPAY_MT	Numeric 1	Flag denotes the method of match prepayment. `0` NO `1` prepay from Invoice `2` Eligible for Prepayment	MA54.1
`MAI-PREPAY-DATE` PREPAY_DATE	Numeric 8 (yyyymmdd)	—	—
`MAI-PRPY-DISC-CODE` PRPY_DISC_CODE	Alpha 10	—	—
`MAI-PRPY-REF-NBR` PRPY_REF_NBR	Alpha 22	—	—
`MAI-PRPY-RTL-AMT` PRPY_RTL_AMT	Signed 18.2	—	—
`MAI-PRPY-AMT` PRPY_AMT	Signed 18.2	—	—
`MAI-PRPY-AOC-AMT` PRPY_AOC_AMT	Signed 18.2	—	—
`MAI-PRPY-TAX-AMT` PRPY_TAX_AMT	Signed 18.2	—	—
`MAI-PRPY-SERV-AMT` PRPY_SERV_AMT	Signed 18.2	—	—
`MAI-FLEX-FLAG` FLEX_FLAG	Alpha 1	Notes terms has been overriden	MA54.1
`MAI-RULE-GROUP` RULE_GROUP	Alpha 10	—	MA54.1, MA540
`MAI-CONTRACT-GROUP` CONTRACT_GROUP	Alpha 4	—	MA54.1, MA540
`MAI-CM-CONTRACT` CM_CONTRACT	Numeric 15	—	MA54.1, MA540
`MAI-REBATE-TYPE` REBATE_TYPE	Alpha 25	—	MA54.1, MA540
`MAI-REBATE-DUE-DTE` REBATE_DUE_DTE	Numeric 8 (yyyymmdd)	—	MA54.1, MA540
`MAI-REF-INV-NBR` REF_INV_NBR	Alpha 22	—	MA54.1
`MAI-TAX-TYPE` TAX_TYPE	Alpha 1	— `I` Invoiced `A` Accrued	—
`MAI-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	MA54.1
`MAI-DISCOUNT-RT1` DISCOUNT_RT1	Percent 5.3 (Percent)	—	—
`MAI-DISCOUNT-RT2` DISCOUNT_RT2	Percent 5.3 (Percent)	—	MA54.1, MA540
`MAI-DISCOUNT-RT3` DISCOUNT_RT3	Percent 5.3 (Percent)	—	MA54.1, MA540
`MAI-BASE-DISC-AMT1` BASE_DISC_AMT1	Signed 18.2	—	—
`MAI-BASE-DISC-AMT2` BASE_DISC_AMT2	Signed 18.2	—	—
`MAI-BASE-DISC-AMT3` BASE_DISC_AMT3	Signed 18.2	—	—
`MAI-TRAN-DISC-AMT1` TRAN_DISC_AMT1	Signed 18.2	—	—
`MAI-TRAN-DISC-AMT2` TRAN_DISC_AMT2	Signed 18.2	—	MA54.1, MA540
`MAI-TRAN-DISC-AMT3` TRAN_DISC_AMT3	Signed 18.2	—	MA54.1, MA540
`MAI-DISC-DATE1` DISC_DATE1	Numeric 8 (yyyymmdd)	—	—
`MAI-DISC-DATE2` DISC_DATE2	Numeric 8 (yyyymmdd)	—	MA54.1, MA540
`MAI-DISC-DATE3` DISC_DATE3	Numeric 8 (yyyymmdd)	—	MA54.1, MA540
`MAI-FREIGHT-TOT` FREIGHT_TOT	Signed 18.2	—	—
`MAI-INSURANCE-TOT` INSURANCE_TOT	Signed 18.2	—	—
`MAI-CSTMS-TOT` CSTMS_TOT	Signed 18.2	—	—
`MAI-OTHER-AOC-TOT` OTHER_AOC_TOT	Signed 18.2	—	—
`MAI-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	MA54.1, MA540
`MAI-REF-TYPE` REF_TYPE	Alpha 1	—	MA54.1, MA540
`MAI-CUSTOMER-ID` CUSTOMER_ID	Alpha 27	—	MA54.1, MA540
`MAI-PMT-CAT-CODE` PMT_CAT_CODE	Alpha 6	—	MA54.1, MA540
`MAI-NO-PAY-CONCERN` NO_PAY_CONCERN	Alpha 60	—	—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`MAISET1`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	Primary	MA54.1, MA54.2, MA54.3, MA54.8, MA540
`MAISET2`	`RUN-GROUP`, `RECORD-ERROR`, `COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	KeyChange	MA54.1, MA540
`MAISET4`	`RUN-GROUP`, `COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	KeyChange	MA540

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Macinverr	MACINVERR			`MAI-COMPANY` → `MCI-COMPANY`, `MAI-VENDOR` → `MCI-VENDOR`, `MAI-EDI-NBR` → `MCI-EDI-NBR`, `MAI-INVOICE` → `MCI-INVOICE`, `MAI-SUFFIX` → `MCI-SUFFIX`, → `MCI-DIST-SEQ`, → `MCI-RECORD-TYPE`, → `MCI-SEQ-NBR`

Programs

Updated by (3)

MA54.1 Invoice
MA54.2 Distribution
MA540 Invoice Interface