MACINVOICE

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.
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


MACINVOICE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAISET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
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


MACINVOICE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:20:17 2016

Home
Contact Us



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