Invoice Conversion/Interface

The Invoice Conversion/Interface file contains invoice that have been converted or interfaced from an external source.
UPDATED BY

MA54.1

MA54.2

MA540

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MAI-RUN-GROUP Element: 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 Element: Company	Numeric 4 Required. The company number.	MA54.1 MA540
MAI-VENDOR Element: 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 Element: 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 Element: Invoice	Alpha 22 Required. Used to identify the invoice.	MA54.1 MA540
MAI-SUFFIX Element: Suffix	Numeric 3 This is the suffix for the invoice. Zeroes will be entered.	MA54.1 MA540
MAI-BATCH-NUM Element: Batch Nbr	Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	MA54.1 MA540
MAI-VOUCHER-NBR Element: 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 Element: 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 Element: Process 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 Element: 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 Element: To Base Curr	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 Element: 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 Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	MA54.1 MA540
MAI-PURCH-FR-LOC Element: Purch Fr Loc	Alpha 4 The vendor's purchase from location.	MA54.1 MA540
MAI-PO-CODE Element: Purchase Order 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 Element: 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 Element: Po Release	Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order).	MA54.1 MA540
MAI-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field displays the description.	MA54.1 MA540
MAI-TRAN-INV-AMT Element: Intl Amt	Signed 18.2 The amount of the invoice in the currency of the invoice.	MA54.1 MA540
MAI-TRAN-ALOW-AMT Element: Intl 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 Element: Intl Amt	Signed 18.2 The taxable amount of the invoice in the currency of the invoice.	MA54.1 MA540
MAI-TRAN-TAX-AMT Element: Intl Amt	Signed 18.2	MA54.1 MA540
MAI-TRAN-DISC-AMT Element: Intl 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 Element: Acct Rate	Signed 14.7	MA54.1 MA540
MAI-DISCOUNT-RT Element: 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 Element: 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 Element: Due Date	Numeric 8 (yyyymmdd) The transaction due date.	MA54.1 MA540
MAI-REMIT-TO-CODE Element: Remit To Code	Alpha 4 A user-defined code that represents a vendor's remittance address.	MA54.1 MA540
MAI-RETAIL-AMT Element: Retail Amount	Signed 18.2 The retail amount of the invoice.	MA54.1 MA540
MAI-RCPT-INV-DATE Element: Invoice Receipt Date	Numeric 8 (yyyymmdd) The date the invoice was received.	MA54.1 MA540
MAI-REASON-CODE Element: Reason Code	Alpha 4 This field contains the reason code, which indicates the cause for credit memos.	MA54.1 MA540
MAI-MATCH-REF-NBR Matching Reference Number	Alpha 22 Matching reference number.	MA54.1 MA540
MAI-HANDLING-CODE Element: Handling Code	Alpha 4 Invoice handling code. The invoice handling code contains processing rules for invoice matching.	MA54.1 MA540
MAI-OPERATOR Element: 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 Element: Term Code	Alpha 5 A user-defined code representing a method of determining invoice due and discount dates.	MA54.1 MA540
MAI-TAX-CODE Element: 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 Element: 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 Element: 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 Element: 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 Element: Print Chargebacks	Alpha 1 Print chargebacks flag. Indicates whether to generate chargebacks. N = No Y = Yes	MA54.1 MA540
MAI-INVC-REF-TYPE Element: 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 Element: Invoice User Field 1	Alpha 20 Invoice user-defined field number 1.	MA54.1 MA540
MAI-INV-USR-FLD-02 Element: Invoice User Field 2	Alpha 20 Invoice user-defined field number 2.	MA54.1 MA540
MAI-INV-USR-FLD-03 Element: Invoice User Field 3	Alpha 20 Invoice user-defined field number 3.	MA54.1 MA540
MAI-INV-USR-FLD-04 Element: Invoice User Field 4	Alpha 20 Invoice user-defined field number 4.	MA54.1 MA540
MAI-INV-USR-FLD-05 Element: Invoice User Field 5	Alpha 20 Invoice user-defined field number 5.	MA54.1 MA540
MAI-RETURN-NUMBER Element: 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 Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.	MA54.1
MAI-SEGMENT-BLOCK Element: 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 Element: 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 Element: 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 Element: Ship Via	Alpha 12 (Lower Case)	MA54.1 MA540
MAI-UNLOADING-PORT Element: 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 Element: 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 Element: 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 Element: Fob Code	Alpha 3 The user defined Free On Board Code.	MA54.1 MA540
MAI-PAY-IMM-FLAG Element: All Flag	Alpha 1	MA54.1 MA540
MAI-DIVERSE-CODE Element: Diverse Code	Alpha 5 Diversity Code for Account Payable Vendors	MA54.1 MA540
MAI-MTCH-PREPAY-FL Element: 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 Element: 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 Element: Prepay Date	Numeric 8 (yyyymmdd)
MAI-PRPY-DISC-CODE Element: Prpy Disc Code	Alpha 10
MAI-PRPY-REF-NBR Element: Prpy Ref Nbr	Alpha 22
MAI-PRPY-RTL-AMT Element: Intl Amt	Signed 18.2
MAI-PRPY-AMT Element: Intl Amt	Signed 18.2
MAI-PRPY-AOC-AMT Element: Intl Amt	Signed 18.2
MAI-PRPY-TAX-AMT Element: Intl Amt	Signed 18.2
MAI-PRPY-SERV-AMT Element: Intl Amt	Signed 18.2
MAI-FLEX-FLAG Element: Flex Flag	Alpha 1 Notes terms has been overriden	MA54.1
MAI-RULE-GROUP Element: Match Rule	Alpha 10	MA54.1 MA540
MAI-CONTRACT-GROUP Element: Enterprise Grp	Alpha 4	MA54.1 MA540
MAI-CM-CONTRACT Element: Cm Contract	Numeric 15	MA54.1 MA540
MAI-REBATE-TYPE Element: Rebate Type	Alpha 25	MA54.1 MA540
MAI-REBATE-DUE-DTE Element: Date	Numeric 8 (yyyymmdd)	MA54.1 MA540
MAI-REF-INV-NBR Element: Invoice	Alpha 22	MA54.1
MAI-TAX-TYPE Element: Tax Type	Alpha 1 I = Invoiced A = Accrued
MAI-FOR-ECON-CODE Element: Code	Alpha 10	MA54.1
MAI-DISCOUNT-RT1 Element: Discount Rt	Percent 5.3 (Percent)
MAI-DISCOUNT-RT2 Element: Discount Rt	Percent 5.3 (Percent)	MA54.1 MA540
MAI-DISCOUNT-RT3 Element: Discount Rt	Percent 5.3 (Percent)	MA54.1 MA540
MAI-BASE-DISC-AMT1 Element: Intl Amt	Signed 18.2
MAI-BASE-DISC-AMT2 Element: Intl Amt	Signed 18.2
MAI-BASE-DISC-AMT3 Element: Intl Amt	Signed 18.2
MAI-TRAN-DISC-AMT1 Element: Intl Amt	Signed 18.2
MAI-TRAN-DISC-AMT2 Element: Intl Amt	Signed 18.2	MA54.1 MA540
MAI-TRAN-DISC-AMT3 Element: Intl Amt	Signed 18.2	MA54.1 MA540
MAI-DISC-DATE1 Element: Date	Numeric 8 (yyyymmdd)
MAI-DISC-DATE2 Element: Date	Numeric 8 (yyyymmdd)	MA54.1 MA540
MAI-DISC-DATE3 Element: Date	Numeric 8 (yyyymmdd)	MA54.1 MA540
MAI-FREIGHT-TOT Element: Freight Total	Signed 18.2
MAI-INSURANCE-TOT Element: Insurance Tot	Signed 18.2
MAI-CSTMS-TOT Element: Cstms Total	Signed 18.2
MAI-OTHER-AOC-TOT Element: Other Aoc Tot	Signed 18.2
MAI-GLBL-DOC-TYPE Element: Glbl Doc Type	Alpha 10	MA54.1 MA540
MAI-REF-TYPE Element: Ref Type	Alpha 1	MA54.1 MA540
MAI-CUSTOMER-ID Element: Customer Id	Alpha 27	MA54.1 MA540
MAI-PMT-CAT-CODE Element: Pmt Cat Code	Alpha 6	MA54.1 MA540
MAI-NO-PAY-CONCERN Element: No Pay Concern	Alpha 60

MACINVOICE FILE INDEX

MACINVOICE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.