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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAI-RUN-GROUP Alpha 15 MA54.1
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
Company Required. The company number.
MAI-VENDOR Alpha 9 (Right Justified) MA54.1
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
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
Invoice Number Required. Used to identify the invoice.
MAI-SUFFIX Numeric 3 MA54.1
Invoice Suffix This is the suffix for the invoice.
Zeroes will be entered.
MAI-BATCH-NUM Numeric 6 MA54.1
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
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
Authority Code A user-defined code representing a
person or department responsible for
approving a registered invoice.
MAI-PROC-LEVEL Alpha 5 MA54.1
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
Invoice Type Identifies the type of invoice. Valid
values are:
" " = Invoice
D = Debit Memo
C = Credit Memo
MAI-INV-CURRENCY Alpha 5 MA54.1
Invoice Currency 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 Numeric 8 (yyyymmdd) MA54.1
Invoice Date Required. The date assigned to the
invoice. Used when updating the vendor's
purchase balance.
MAI-DISTRIB-DATE Numeric 8 (yyyymmdd)
Distribution Date The date used for posting the
transactions to the general ledger.
MAI-PURCH-FR-LOC Alpha 4 MA54.1
Purchase From The vendor's purchase from location.
Location Code
MAI-PO-CODE Alpha 4 MA54.1
Purchase Order Code Purchase order number code. Used to
keep purchase orders unique. Can be used
for reporting purposes.
MAI-PO-NUMBER Alpha 14 (Right Justified) MA54.1
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
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
MAI-DESCRIPTION Alpha 30 (Lower Case) MA54.1
Description This field displays the description.
MAI-TRAN-INV-AMT Signed 15.2 MA54.1
Invoice Amount The amount of the invoice in the
currency of the invoice.
MAI-TRAN-ALOW-AMT Signed 15.2 MA54.1
Allowable Amount 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 15.2 MA54.1
Taxable Amount The taxable amount of the invoice in
the currency of the invoice.
MAI-TRAN-TAX-AMT Signed 15.2 MA54.1
Tax Amount 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 15.2 MA54.1
Discount Amount 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 12.6 MA54.1
Exchange Rate Represents the currency exchange rate
the transaction was created with.
MAI-DISCOUNT-RT Percent 5.3 (Percent) MA54.1
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
Discount 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
Due Date The transaction due date.
MAI-REMIT-TO-CODE Alpha 4 MA54.1
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
MAI-RETAIL-AMT Signed 15.2 MA54.1
Retail Amount The retail amount of the invoice.
MAI-RCPT-INV-DATE Numeric 8 (yyyymmdd) MA54.1
Invoice Receipt Date The date the invoice was received.
MAI-REASON-CODE Alpha 4 MA54.1
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MAI-MATCH-REF-NBR Alpha 22 MA54.1
Matching Reference Matching reference number.
Number
MAI-HANDLING-CODE Alpha 4 MA54.1
Handling Code Invoice handling code. The invoice
handling code contains processing rules
for invoice matching.
MAI-OPERATOR Alpha 10 MA54.1
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
Terms Code A user-defined code representing a
method of determining invoice due and
discount dates.
MAI-TAX-CODE Alpha 10 MA54.1
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
Tax Adjustment Code 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
MAI-LOCATION Alpha 5 MA54.1
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
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
Print Chargebacks Print 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
Invoice User Field 1 Invoice user-defined field number 1.
MAI-INV-USR-FLD-02 Alpha 20 MA54.1
Invoice User Field 2 Invoice user-defined field number 2.
MAI-INV-USR-FLD-03 Alpha 20 MA54.1
Invoice User Field 3 Invoice user-defined field number 3.
MAI-INV-USR-FLD-04 Alpha 20 MA54.1
Invoice User Field 4 Invoice user-defined field number 4.
MAI-INV-USR-FLD-05 Alpha 20 MA54.1
Invoice User Field 5 Invoice user-defined field number 5.
MAI-RETURN-NUMBER Numeric 10 MA54.1
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
Journal Book The journal book assigned to the
transaction.
MAI-SEGMENT-BLOCK Alpha 103 MA54.1
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
Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
MAI-STAT-PROC Alpha 6 MA54.1
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
Ship Via Description
MAI-UNLOADING-PORT Alpha 5 MA54.1
Unloading Port The prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
MAI-INTRASTAT-NBR Numeric 12
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
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
Shipping Term Code The user defined Free On Board Code.
MACINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAISET1 COMPANY MA54.1 MA54.2
VENDOR MA54.3 MA54.8
EDI-NBR
INVOICE
SUFFIX
MAISET2 RUN-GROUP KeyChange MA54.1
RECORD-ERROR
COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
MAISET4 RUN-GROUP KeyChange
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 (MCISET1)
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
|
