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 | MA54.3 | MA54.8 | 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. |
|
||
| MAI-COMPANY Element: Company | Numeric 4 Required. The company number. |
|
||
| MAI-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. NOTE Either the vendor ID or the EDI number is required. |
|
||
| 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. |
|
||
| MAI-INVOICE Element: Invoice | Alpha 22 Required. Used to identify the invoice. |
|
||
| MAI-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. Zeroes will be entered. |
|
||
| MAI-BATCH-NUM Element: Batch Nbr | Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of. |
|
||
| 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. |
|
||
| MAI-AUTH-CODE Element: Auth Code | Alpha 3 A user-defined code representing a person or department responsible for approving a registered invoice. |
|
||
| 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. |
|
||
| MAI-INVOICE-TYPE Element: Invoice Type | Alpha 1 Identifies the type of invoice. Valid values are: " " = Invoice D = Debit Memo C = Credit Memo |
|
||
| 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. |
|
||
| MAI-INVOICE-DTE Element: Invoice Dte | Numeric 8 (yyyymmdd) Required. The date assigned to the invoice. Used when updating the vendor's purchase balance. |
|
||
| MAI-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| MAI-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||
| 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. |
|
||
| 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. |
|
||
| MAI-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||
| MAI-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
| MAI-TRAN-INV-AMT Element: Intl Amt | Signed 18.2 The amount of the invoice in the currency of the invoice. |
|
||
| 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. |
|
||
| MAI-TRAN-TXBL-AMT Element: Intl Amt | Signed 18.2 The taxable amount of the invoice in the currency of the invoice. |
|
||
| MAI-TRAN-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
| 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. |
|
||
| MAI-ORIG-CNV-RATE Element: Acct Rate | Signed 14.7 |
|
||
| 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. |
|
||
| 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. |
|
||
| MAI-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) The transaction due date. |
|
||
| MAI-REMIT-TO-CODE Element: Remit To Code | Alpha 4 A user-defined code that represents a vendor's remittance address. |
|
||
| MAI-RETAIL-AMT Element: Retail Amount | Signed 18.2 The retail amount of the invoice. |
|
||
| MAI-RCPT-INV-DATE Element: Invoice Receipt Date | Numeric 8 (yyyymmdd) The date the invoice was received. |
|
||
| MAI-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||
| MAI-MATCH-REF-NBR Matching Reference Number | Alpha 22 Matching reference number. |
|
||
| MAI-HANDLING-CODE Element: Handling Code | Alpha 4 Invoice handling code. The invoice handling code contains processing rules for invoice matching. |
|
||
| MAI-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||
| MAI-TERM-CODE Element: Term Code | Alpha 5 A user-defined code representing a method of determining invoice due and discount dates. |
|
||
| MAI-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
| 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 |
|
||
| 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. |
|
||
| 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 |
|
||
| MAI-CBPRINT-FL Element: Print Chargebacks | Alpha 1 Print chargebacks flag. Indicates whether to generate chargebacks. N = No Y = Yes |
|
||
| MAI-INVC-REF-TYPE Element: Invc Ref Type | Alpha 2 Indicates the type of number the vendor is providing to reference the invoice. |
|
||
| MAI-INV-USR-FLD-01 Element: Invoice User Field 1 | Alpha 20 Invoice user-defined field number 1. |
|
||
| MAI-INV-USR-FLD-02 Element: Invoice User Field 2 | Alpha 20 Invoice user-defined field number 2. |
|
||
| MAI-INV-USR-FLD-03 Element: Invoice User Field 3 | Alpha 20 Invoice user-defined field number 3. |
|
||
| MAI-INV-USR-FLD-04 Element: Invoice User Field 4 | Alpha 20 Invoice user-defined field number 4. |
|
||
| MAI-INV-USR-FLD-05 Element: Invoice User Field 5 | Alpha 20 Invoice user-defined field number 5. |
|
||
| 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. |
|
||
| MAI-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||
| 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. |
|
||
| MAI-NOTC Element: Notc | Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance). |
|
||
| 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). |
|
||
| MAI-SHIP-VIA Element: Ship Via | Alpha 12 (Lower Case) |
|
||
| 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) |
|
||
| 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. |
|
||
| MAI-FOB-CODE Element: Fob Code | Alpha 3 The user defined Free On Board Code. |
|
||
| MAI-PAY-IMM-FLAG Element: All Flag | Alpha 1 |
|
||
| MAI-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||
| MAI-MTCH-PREPAY-FL Element: Mtch Prepay Fl | Alpha 1 Flag that notes if the invoice will be prepaid. This is for match invoices. |
|
||
| 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 |
|
||
| 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 |
|
||
| MAI-RULE-GROUP Element: Match Rule | Alpha 10 |
|
||
| MAI-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||
| MAI-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||
| MAI-REBATE-TYPE Element: Rebate Type | Alpha 25 |
|
||
| MAI-REBATE-DUE-DTE Element: Date | Numeric 8 (yyyymmdd) |
|
||
| MAI-REF-INV-NBR Element: Invoice | Alpha 22 |
|
||
| MAI-TAX-TYPE Element: Tax Type | Alpha 1 I = Invoiced A = Accrued |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MAISET1 |
COMPANY VENDOR EDI-NBR INVOICE SUFFIX |
|
| ||||||||||||
| MAISET2 |
RUN-GROUP RECORD-ERROR COMPANY VENDOR EDI-NBR INVOICE SUFFIX |
|
| ||||||||||||
| MAISET4 |
RUN-GROUP COMPANY VENDOR EDI-NBR INVOICE SUFFIX |
|
| ||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Macinverr | MACINVERR |
|
All trademarks and registered trademarks are the property of their
respective owners.