|
|
MACINVOICE FILE
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 Alpha 15 MA54.1 MA540
Element: Run Group 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 Numeric 4 MA54.1 MA540
Element: Company Required. The company number.
MAI-VENDOR Alpha 9 (Right Justified) MA54.1 MA540
Element: Vendor ID The vendor's identification code.
Note: Either the vendor ID or the EDI
number is required.
MAI-EDI-NBR Alpha 15 MA54.1 MA540
Element: EDI Number 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 Alpha 22 MA54.1 MA540
Element: Invoice NumberRequired. Used to identify the invoice.
MAI-SUFFIX Numeric 3 MA54.1 MA540
Element: Invoice SuffixThis is the suffix for the invoice.
Zeroes will be entered.
MAI-BATCH-NUM Numeric 6 MA54.1 MA540
Element: Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
MAI-VOUCHER-NBR Alpha 10 MA54.1 MA540
Element: Voucher The voucher number assigned to the
invoice. Used only if the company has
Yes selected in the Invoice Registration
Option field.
MAI-AUTH-CODE Alpha 3 MA54.1 MA540
Element: Authority CodeA user-defined code representing a
person or department responsible for
approving a registered invoice.
MAI-PROC-LEVEL Alpha 5 MA54.1 MA540
Element: Process Level 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 Alpha 1 MA54.1 MA540
Element: Invoice Type Identifies the type of invoice. Valid
values are:
" " = Invoice
D = Debit Memo
C = Credit Memo
MAI-INV-CURRENCY Alpha 5 MA54.1 MA540
To Company Base The currency of the invoice. Must be a
Currency valid record in the Currency Code file.
If left blank, the vendor currency
defaults.
MAI-INVOICE-DTE Numeric 8 (yyyymmdd) MA54.1 MA540
Element: Invoice Date Required. The date assigned to the
invoice. Used when updating the vendor's
purchase balance.
MAI-DISTRIB-DATE Numeric 8 (yyyymmdd) MA54.1 MA540
Element: Date The date used for posting the
transactions to the general ledger.
MAI-PURCH-FR-LOC Alpha 4 MA54.1 MA540
Purchase From The vendor's purchase from location.
Location Code
MAI-PO-CODE Alpha 4 MA54.1 MA540
Element: Purchase OrderPurchase order number code. Used to
keep purchase orders unique. Can be used
for reporting purposes.
MAI-PO-NUMBER Alpha 14 (Right Justified) MA54.1 MA540
Element: PO Number 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 Numeric 4 MA54.1 MA540
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
MAI-DESCRIPTION Alpha 30 (Lower Case) MA54.1 MA540
Element: Description This field displays the description.
MAI-TRAN-INV-AMT Signed 18.2 MA54.1 MA540
Element: Intl Amt The amount of the invoice in the
currency of the invoice.
MAI-TRAN-ALOW-AMT Signed 18.2 MA54.1 MA540
Element: Intl Amt 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 Signed 18.2 MA54.1 MA540
Element: Intl Amt The taxable amount of the invoice in
the currency of the invoice.
MAI-TRAN-TAX-AMT Signed 18.2 MA54.1 MA540
Element: Intl Amt The amount to be posted to the general
ledger for the tax distribution. The
transaction amount less the tax amount
will be posted to the selected general
ledger account.
MAI-TRAN-DISC-AMT Signed 18.2 MA54.1 MA540
Element: Intl Amt 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 Signed 14.7 MA54.1 MA540
Element: Account Rate Represents the currency exchange rate
the transaction was created with.
MAI-DISCOUNT-RT Percent 5.3 (Percent) MA54.1 MA540
Element: Discount Rate 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 Numeric 8 (yyyymmdd) MA54.1 MA540
Element: Date The discount date assigned to the
invoice. Used by AP150 (Cash
Requirements) 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 Numeric 8 (yyyymmdd) MA54.1 MA540
Element: Due Date The transaction due date.
MAI-REMIT-TO-CODE Alpha 4 MA54.1 MA540
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
MAI-RETAIL-AMT Signed 18.2 MA54.1 MA540
Element: Retail Amount The retail amount of the invoice.
MAI-RCPT-INV-DATE Numeric 8 (yyyymmdd) MA54.1 MA540
Element: Invoice ReceipThe date the invoice was received.
MAI-REASON-CODE Alpha 4 MA54.1 MA540
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MAI-MATCH-REF-NBR Alpha 22 MA54.1 MA540
Matching Reference Matching reference number.
Number
MAI-HANDLING-CODE Alpha 4 MA54.1 MA540
Element: Handling Code Invoice handling code. The invoice
handling code contains processing rules
for invoice matching.
MAI-OPERATOR Alpha 10 MA54.1 MA540
Element: Operator Code This field is used to store the login
id of the person who entered the record.
MAI-TERM-CODE Alpha 5 MA54.1 MA540
Element: Terms Code A user-defined code representing a
method of determining invoice due and
discount dates.
MAI-TAX-CODE Alpha 10 MA54.1 MA540
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MAI-TAX-CODE-CNTL Alpha 1 MA54.1 MA540
Element: Tax AdjustmentThis 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 Alpha 5 MA54.1 MA540
Element: Location Code This field contains a valid stocking
location within the company inventory
system.
Note: Required if pool option for
vendor/company = 3.
MAI-RECORD-ERROR Alpha 1 MA54.1 MA540
Element: Record Error 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 Alpha 1 MA54.1 MA540
Element: Print ChargebaPrint chargebacks flag. Indicates
whether to generate chargebacks.
N = No
Y = Yes
MAI-INVC-REF-TYPE Alpha 2 MA54.1
Invoice Reference Indicates the type of number the vendor
Type is providing to reference the invoice.
MAI-INV-USR-FLD-01 Alpha 20 MA54.1 MA540
Element: Invoice User FInvoice user-defined field number 1.
MAI-INV-USR-FLD-02 Alpha 20 MA54.1 MA540
Element: Invoice User FInvoice user-defined field number 2.
MAI-INV-USR-FLD-03 Alpha 20 MA54.1 MA540
Element: Invoice User FInvoice user-defined field number 3.
MAI-INV-USR-FLD-04 Alpha 20 MA54.1 MA540
Element: Invoice User FInvoice user-defined field number 4.
MAI-INV-USR-FLD-05 Alpha 20 MA54.1 MA540
Element: Invoice User FInvoice user-defined field number 5.
MAI-RETURN-NUMBER Numeric 10 MA54.1 MA540
Element: Return Number 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 Alpha 12 MA54.1
Element: Journal Book The journal book assigned to the
transaction.
MAI-SEGMENT-BLOCK Alpha 103 MA54.1 MA540
Element: User Analysis 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 Alpha 2 MA54.1 MA540
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
MAI-STAT-PROC Alpha 6 MA54.1 MA540
Element: Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
MAI-SHIP-VIA Alpha 12 (Lower Case) MA54.1 MA540
Element: Ship Via Description
MAI-UNLOADING-PORT Alpha 5 MA54.1 MA540
Element: Unloading PortThe prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
MAI-INTRASTAT-NBR Numeric 12
Element: Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
MAI-DROPSHIP-FL Alpha 1 MA54.1 MA540
Element: Dropship Flag 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 Alpha 3 MA54.1 MA540
Element: Shipping Term The user defined Free On Board Code.
MAI-PAY-IMM-FLAG Alpha 1 MA54.1 MA540
Element: All Flag
MAI-DIVERSE-CODE Alpha 5 MA54.1 MA540
Element: Diverse Code Diversity Code for Account Payable
Vendors
MAI-MTCH-PREPAY-FL Alpha 1 MA54.1
Element: Mtch Prepay FlFlag that notes if the invoice will be
prepaid. This is for match invoices.
MAI-MTCH-PREPAY-MT Numeric 1 MA54.1
Element: Mtch Prepay MtFlag denotes the method of match
prepayment.
0 = NO
1 = prepay from Invoice
2 = Eligible for Prepayment
MAI-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
MAI-PRPY-DISC-CODE Alpha 10
Element: Prpy Disc Code
MAI-PRPY-REF-NBR Alpha 22
Element: Prpy Ref Nbr
MAI-PRPY-RTL-AMT Signed 18.2
Element: Intl Amt
MAI-PRPY-AMT Signed 18.2
Element: Intl Amt
MAI-PRPY-AOC-AMT Signed 18.2
Element: Intl Amt
MAI-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt
MAI-PRPY-SERV-AMT Signed 18.2
Element: Intl Amt
MAI-FLEX-FLAG Alpha 1 MA54.1
Element: Flex DeductionNotes terms has been overriden
MAI-RULE-GROUP Alpha 10 MA54.1 MA540
Element: Match Rule
MACINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAISET1 COMPANY MA54.1 MA54.2
VENDOR MA54.3 MA54.8
EDI-NBR MA540
INVOICE
SUFFIX
MAISET2 RUN-GROUP KeyChange MA54.1 MA540
RECORD-ERROR
COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
MAISET4 RUN-GROUP KeyChange MA540
COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
MACINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
