The Accounts Payable Invoice file contains accounts payable invoice records.
Each record has one or more associated records in the Invoice Payment File.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
API-COMPANY
Element: Company | Numeric 4
The company associated with the
invoice. Must be a valid record in the
Accounts Payable Company file.
|
|
API-VENDOR
Element: Vendor ID | Alpha 9 (Right Justified)
The invoiced vendor number. Must be a
valid record in the Vendor file.
|
|
API-INVOICE
Element: Invoice Number | Alpha 22
The invoice number. Must be a unique
invoice number for the vendor.
|
|
API-SUFFIX
Element: Invoice Suffix | Numeric 3
The invoice suffix number. Represents
the occurrence value of the invoice.
Used to identify the recurrence value of
a recurring invoice and for
system-generated credit memos created
for prepayments and employee advances.
|
|
API-CANCEL-SEQ
Element: Seq Nbr | Numeric 4
The sequence number assigned upon the
cancellation of a distributed invoice.
The first sequence assigned is 9999.
|
|
API-CANCEL-DATE
Element: Cancel Date | Numeric 8 (yyyymmdd)
The cancellation date assigned to a
canceled invoice.
|
|
API-BATCH-NUM
Element: Batch Nbr | Numeric 6
The batch number associated with the
invoice. Used only if the company has
Yes selected in the Batch Release Option
field.
|
|
API-BATCH-DATE
Element: Batch Date | Numeric 8 (yyyymmdd)
The batch date assigned to the batch
number. Must be a valid record in the
Batch file.
|
|
API-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.
|
|
API-AUTH-CODE
Element: Auth Code | Alpha 3
The authority code assigned to the
invoice. Represents the person or
department responsible for approving a
registered invoice and is required
before a registered invoice can be
released. Used only by a company that
has Yes selected in the Invoice Approval
field and No in the Batch Release field.
Must be a valid record in the Authority
Code file.
|
|
API-PROC-LEVEL
Element: Process Level | Alpha 5
The process level assigned to the
invoice. Must be a valid record in the
Accounts Payable Process Level file.
|
|
API-ACCR-CODE
Element: Invoice Accrual Code | Alpha 4
The invoice accrual code assigned to
the invoice. Used to default a general
ledger accrual account to the invoice.
Must be a valid record in the Invoice
Accrual Code file.
|
|
API-INVOICE-TYPE
Element: Invoice Type | Alpha 1
Identifies the type of invoice. Valid
values are:
Blank = Invoice. Increases the amount
owed to the vendor. If the invoice is
fully processed, the vendor's purchase
and payment balances will be increased.
C = Credit Memo. Reduces the amount
owed to the vendor. If the invoice is
fully processed, the vendor's purchase
and payment balances will be decreased.
D = Debit Memo. Processed just like an
invoice. Increase the vendor's purchase
and payment balances.
P = Prepayment. Processed just like an
invoice. Used to pay a vendor for goods
or services not yet received.
Y = Prepayment Credit Memo. Created by
AP170 (Payment Closing) to offset a
prepayment and are applied to the
vendor's invoice after it has been
received.
A = Employee Advance. Processed just
like an invoice. Used to pay an employee
for expenses not yet incurred.
M = Employee Advance Credit Memo.
Created by Payment Closing (AP170) to
offset an employee advance. Can be
applied to the employee's expense after
it has been received.
E = Employee Expense. Processed just
like an invoice.
R = Match Prepayment |
|
API-INV-CURRENCY
Element: Invoice Currency | Alpha 5
The currency of the invoice. Must be a
valid record in the Currency Code file.
If left blank, the vendor currency
defaults.
|
|
API-PAY-CURRENCY
Element: To Base Curr | Alpha 5
The currency used to pay the invoice.
Must be a valid record in the Currency
Code file.
|
|
API-INVOICE-DTE
Element: Invoice Date | Numeric 8 (yyyymmdd)
The date assigned to the invoice. Used
when updating the vendor's purchase
balance. If left blank, the system date
defaults.
|
|
API-PURCH-FR-LOC
Element: Purch Fr Loc | Alpha 4
The purchase-from location code
associated with the invoice. Must be a
valid record in the Vendor Location
file.
|
|
API-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
API-PO-RELEASE
Element: Po Release | Numeric 4
The purchase order release number
associated with the invoice. Used to
identify a purchase order release
created from a blanket or standing
order.
|
|
API-PO-CODE
Element: Purchase Order Code | Alpha 4
Purchase order number code. Used to
keep purchase orders unique. Can be used
for reporting purposes.
|
|
API-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
The invoice description.
|
|
API-BASE-INV-AMT
Element: Base Invoice Amount | Signed 18.2
The amount of the invoice in the
company base currency. This amount is
calculated based on the currency
exchange rate in effect when the invoice
was created or entered.
|
|
API-BASE-ACT-AMT
Revalued Base
Invoice Amount | Signed 18.2
The amount of the invoice in the
company base currency. For non-base
currency invoices, this amount is
updated when currency revaluation takes
place.
|
|
API-BASE-ND
Element: Base Nd | Numeric 1
The number of decimal places defined
for the company base currency.
|
|
API-TRAN-INV-AMT
Element: Intl Amt | Signed 18.2
The amount of the invoice in the
currency of the invoice.
|
|
API-TRAN-ALOW-AMT
Element: Intl Amt | Signed 18.2
The amount of the invoice available for
discount in the currency of the invoice.
Used to calculate the discount amount
based on the discount rate. If left
blank, the invoice amount defaults.
|
|
API-TRAN-TXBL-AMT
Element: Intl Amt | Signed 18.2
The taxable amount of the invoice in
the currency of the invoice.
|
|
API-TRAN-ND
Element: Acct Nd | Numeric 1
The number of decimal places defined
for the invoice currency.
|
|
API-TRAN-TAX-AMT
Element: Intl Amt | Signed 18.2
The tax amount of the invoice in the
currency of the invoice.
|
|
API-BASE-DISC-AMT
Element: Intl Amt | Signed 18.2
The discount amount of the invoice in
the company base currency.
|
|
API-TRAN-DISC-AMT
Element: Intl Amt | Signed 18.2
The discount amount of the invoice in
the currency of the invoice.
|
|
API-BASE-TOT-PMT
Base Total Payment
Amount | Signed 18.2
The total payment amount created for
the invoice in the company base
currency.
|
|
API-TRAN-TOT-PMT
Element: Intl Amt | Signed 18.2
The total payment amount created for
the invoice in the currency of the
invoice.
|
|
API-BASE-TOT-DIST
Base Total
Distribution Amount | Signed 18.2
The total distribution amount of the
invoice in the company base currency.
|
|
API-TRAN-TOT-DIST
Element: Intl Amt | Signed 18.2
The total distribution amount of the
invoice in the currency of the invoice.
|
|
API-TRAN-TOT-TAX
Element: Intl Amt | Signed 18.2
The total tax amount of the invoice in
the currency of the invoice.
|
|
API-TRAN-TOT-TXBL
Element: Intl Amt | Signed 18.2
|
|
API-TRAN-PAID-AMT
Element: Intl Amt | Signed 18.2
The total amount of the invoice paid to
date in the currency of the invoice.
|
|
API-ORIG-CNV-RATE
Element: Acct Rate | Signed 14.7
The currency exchange rate used to
convert the invoice amount to the
company base currency. This field may be
updated if the invoice is revalued to
account for exchange rate fluctuations.
|
|
API-ANTICIPATION
Element: Anticipation | Alpha 1
Indicates whether anticipation criteria
will be used to calculate the discount
amount of the invoice. Valid values are:
N = No.
Y = Yes.
|
|
API-DISCOUNT-RT
Element: Discount Rt | Percent 5.3 (Percent)
The discount rate used to calculate the
discount amount of the invoice.
|
|
API-DISC-DATE
Element: Date | Numeric 8 (yyyymmdd)
The discount date of the invoice. Used
to determine whether a discount will be
taken on an invoice.
|
|
API-DUE-DATE
Element: Due Date | Numeric 8 (yyyymmdd)
The invoice due date. Used to schedule
the invoice for payment.
|
|
API-NBR-SPLIT-PMT
Element: Nbr Of Invcs | Numeric 3
Used for split payment invoices to
indicate the total number of payments to
be made for the invoice.
|
|
API-SPLIT-PMT-SCH
Element: Split Pmt Sch | Alpha 1
Used for split payment invoices to
indicate the frequency of payments to be
made for the invoice. The invoice, due,
and discount dates are incremented
according the schedule selected. Valid
values are:
W = Weekly.
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
Blank = Not a split payment invoice.
|
|
API-NBR-RECUR-PMT
Element: Nbr Of Invcs | Numeric 3
Used for recurring invoices to indicate
the number of times the invoice will
recur.
|
|
API-RECUR-FREQ
Element: Recur Freq | Alpha 1
Used for recurring invoices to indicate
how often the invoice should recur.
Valid values are:
W = Weekly.
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
Blank = Not a recurring invoice.
E = End of Month |
|
API-REMIT-TO-CODE
Element: Remit To Code | Alpha 4
The remit-to location code associated
with the invoice. Must be a valid record
in the Vendor Location file.
|
|
API-CASH-CODE
Element: Cash Code | Alpha 4
The cash code assigned to the invoice.
Represents the bank account the invoice
is to be paid from. Must be a valid
record in the Cash Code file.
|
|
API-BANK-INST-CODE
Element: Payment Code | Alpha 3
The payment code assigned to the
invoice. Represents the type of cash
payment or bill of exchange payment used
to pay the invoice. Must be a valid cash
payment transaction code record in the
Bank Transaction Code file.
|
|
API-CURR-RECALC
Currency
Recalculation | Alpha 1
Used for non-base currency invoices to
indicate whether the invoice will be
revalued when it is scheduled for
payment to account for currency exchange
rate fluctuations. Valid values are:
N = No.
Y = Yes.
|
|
API-TAX-CODE
Element: Tax Code | Alpha 10
The tax code or tax table code applied
to the invoice. Used to calculate
invoice tax information. Must be a valid
record in the Tax Code file.
|
|
API-INCOME-CODE
Element: Income Code | Alpha 4
The income code associated with the
invoice. Used to track vendor income for
the invoice. Must be a valid record in
the Income Code file.
|
|
API-DIST-CODE
Element: Dist Code | Alpha 9
The distribution code assigned to the
invoice. Used during invoice entry to
automatically create distributions for
the invoice. Must be a valid record in
the Distribution Code file.
|
|
API-REC-STATUS
Element: Rec Status | Numeric 1
The status of the invoice record. Valid
values are:
0 = Unreleased. Not available for
payment.
1 = Released. Available for payment.
9 = Historical. Paid and closed.
|
|
API-CREATE-DATE
Element: Create Date | Numeric 8 (yyyymmdd)
The date the invoice was created in the
Lawson Accounts Payable system.
|
|
API-DISTRIB-DATE
Element: Post Date | Numeric 8 (yyyymmdd)
The date used for posting invoice
distributions to the general ledger.
|
|
API-OPERATOR
Element: Operator | Alpha 10
The operator associated with the
invoice.
|
|
API-CREATION-TIME
Element: Creation Time | Numeric 6 (hhmmss)
The time the invoice was created in the
Lawson Accounts Payable system.
|
|
API-VENDOR-GROUP
Element: Vendor Group | Alpha 4
The vendor group associated with the
invoice. Must be a valid record in the
Vendor Group file.
|
|
API-PAY-VENDOR
Element: Pay Vendor | Alpha 9 (Right Justified)
The pay vendor for the invoice.
Represents the vendor that receives
payment for the invoice. Must be a valid
record in the Vendor file.
|
|
API-PAY-GROUP
Element: Pay Group | Alpha 4
The pay group associated with the
invoice. A pay group is used for
processing accounts payable payments.
Must be a valid record in the Pay Group
file.
|
|
API-INVOICE-GROUP
Element: Invoice Group | Alpha 4
The invoice group assigned to the
invoice. An invoice group is a
user-defined character expression that
can be used to select invoices for
payment. The same invoice group can be
assigned to more than one invoice.
|
|
API-LAST-DIST-SEQ
Element: Dist Seq Nbr | Numeric 6
Used by the system to track the number
of the last distribution line created
for the invoice.
|
|
API-LAST-PMT-SEQ
Element: Seq Nbr | Numeric 4
Used by the system to track the last
payment record number used for the
invoice.
|
|
API-DISCOUNT-CODE
Element: Discount Code | Alpha 10
The discount code assigned to the
invoice. Represents a general ledger
discount account. Must be a valid record
in the Discount Code file.
|
|
API-INVOICE-SOURCE
Element: Invoice Source | Alpha 1
Indicates the source for creation of
the invoice. Valid values are:
Blank = Manual entry.
E = Electronic Data Interchange (EDI).
R = Evaluated Receipts Settlement (ERS).
P = Payroll
T = Tax
G = Garnishment
L = Lease
C = AR Transfer
S = Sub Contractor
X = Expense Interface
A = AP Automation |
|
API-INVC-REF-TYPE
Invoice Reference
Type | Alpha 2
Indicates the type of number the vendor
is providing to reference the invoice.
Valid values are:
BM = Bill of Lading.
IN = Invoice.
OW = Service Order.
PL = Packing List.
PO = Purchase Order Number.
VN = Vendor Order.
WO = Production Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
|
|
API-APPROVED-FLAG
Element: Approved Flag | Alpha 1
Indicates whether the invoice is
approved for payment. Valid values are:
Y = Yes.
N = No.
D = Disapproved
M = Message Exists
P = Message Pending Action
R = Match Prepayment |
|
API-APPRV-OPERATOR
Element: Operator | Alpha 10
If the invoice required approval, this
field contains the operator that
approved the invoice.
|
|
API-RETURN-NUMBER
Element: Return Number | Numeric 10
If the goods associated with the
invoice were returned, this field
contains the optional return number
assigned to the return.
|
|
API-JRNL-BOOK-NBR
Element: Jrnl Book Nbr | Alpha 12
The journal book assigned to the
transaction.
|
|
API-TAX-POINT
Element: Tax Point | Alpha 1
Indicates when the tax amount is
calculated for the invoice, if
applicable. Valid values are:
I = Invoice.
P = Payment.
G = GL Post Date |
|
API-OBJ-ID
Element: Object ID | Numeric 12
A subsystem object interface
identification number. Used to identify
the Invoice Distribution and Asset
Detail records that are associated with
the invoice. Also used for Drill Around
purposes.
|
|
API-RECON-DATE
Element: Recon Date | Numeric 8 (yyyymmdd)
Represents the date the transaction
cleared the bank or was voided.
|
|
API-POD-PRINTED
Proof of Delivery
Printed | Numeric 1
Indicates is a proof of delivery has
been printed for this invoice.
Valid values are:
Y = Yes
" " = No
|
|
API-MATCH-REF-NBR
Match Reference
Number | Alpha 22
Matching reference number. This is a
user defined number used for matching.
|
|
API-MATCH-FL
Element: Match Invoice Flag | Alpha 1
Indicates if the invoice is a match
invoice.
A = AOC Invoice
Y = PO Invoice
N = Exp Invoice |
|
API-TERMS-CD
Element: Term Code | Alpha 5
Invoice payment terms code.
|
|
API-RCPT-INV-DATE
Receipt of Invoice
Date | Numeric 8 (yyyymmdd)
The date the invoice was received. If
left blank, the system date defaults.
|
|
API-RETAIL-AMT
Element: Retail Amount | Signed 18.2
The retail amount of the item.
|
|
API-MATCH-STATUS
Element: Match Status | Numeric 1
Indicates the match status of the
invoice.
Valid values are:
0 = Unmatched
1 = Out of tolerance
2 = Matched
3 = Matched out of tolerance
4 = Matched in tolerance
5 = Matched with auto chargeback
6 = Approved No Receipt (MA61) |
|
API-REASON-CODE
Element: Reason Code | Alpha 4
This field contains the reason code,
which indicates the cause for credit
memos.
|
|
API-HANDLING-CODE
Invoice Handling
Code | Alpha 4
Invoice handling code. The invoice
handling code contains processing rules
for invoice matching.
|
|
API-MATCH-AMT
Element: Match Amount | Signed 18.2
Match amount. Represents the goods
amount on which the invoice will match
to a receipt.
|
|
API-AOC-ALLOW-AMT
Element: Add On Cost Amount | Signed 18.2
Add on cost amount.
|
|
API-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
API-MATCH-OBJ-ID
Element: Match Object ID | Numeric 12
A system generated matching object
identifier.
|
|
API-CBPRINT-FL
Element: Print Chargebacks | Alpha 1
Indicates whether to print chargebacks.
N = No
Y = Yes
" " = spaces |
|
API-MATCH-TABLE
Element: Match Table | Alpha 10
Match table. Contains matching and
match processing rules.
|
|
API-TAX-CODE-CNTL
Element: Tax Code Control | 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.
0 = No Tax
1 = Override Product Only
2 = Ignore Product Only
3 = Calculate
4 = Overide Product and AOC
5 = Ignore Product and AOC
8 = Override taxable PO Line
9 = Override taxable PO and AOC |
|
API-LAST-MATCH-LN
Element: Last Match Line | Numeric 4
Last matched line number.
|
|
API-MATCH-LEVEL
Element: Match Level | Alpha 3
Indicates whether the invoice was
matched at the invoice or detail level.
|
|
API-MATCH-DATE
Element: Match Date | Numeric 8 (yyyymmdd)
The date the invoice was matched.
|
|
API-PO-INV-TAX
Element: Invoiced Tax | Signed 18.2
The amount of invoiced tax that will be
generated on the invoice from taxable
add on costs and taxable purchase order
receipt lines assigned to the invoice.
The resulting value is then used to
compute the invoice match amount when no
tax code has been assigned to the
invoice.
|
|
API-BYPASS-MATCH
Element: All Flag | Alpha 1
|
|
API-SERVICE-FL
Element: Service Fl | Alpha 1
This field indicates a transaction is a
Service only transaction.
Y = Yes
N = No |
|
API-SERVICE-AMT
Element: Intl Amt | Signed 18.2
|
|
API-BUYER
Element: Buyer | Alpha 3
|
|
API-FINAL-DST-FLAG
Element: Final Dst Flag | Alpha 1
|
|
API-NOTC
Element: Notc | Alpha 2
The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
|
|
API-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).
|
|
API-SHIP-VIA
Element: Ship Via | Alpha 12 (Lower Case)
|
|
API-UNLOADING-PORT
Element: Unloading Port | Alpha 5
The prot where the goods are unloaded
if required. Must be defined in IN04.1
(Port Maintenance)
|
|
API-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.
|
|
API-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.
|
|
API-FOB-CODE
Element: Fob Code | Alpha 3
The user defined Free On Board Code.
|
|
API-NET-PAYABLE
Element: Net Apyable | Derived
The net payment amount in the currency
of the invoice.
|
|
API-JBK-SEQ-NBR
Element: Jbk Seq Nbr | Numeric 10
The journal book sequence number
assigned to a journal book transaction
when it is added or interfaced to the
Lawson system. Used only when Auto
Journal Book Seq Nbr is set to Yes in
GL10.1 (Company).
|
|
API-DIVERSE-CODE
Element: Diverse Code | Alpha 5
Diversity Code for Account Payable
Vendors
|
|
API-FLEX-FLAG
Element: Flex Flag | Alpha 1
|
|
API-RULE-GROUP
Element: Rule Group | Alpha 10
This is the rule group entered on the
AP20 invoice entry screen.
|
|
API-FLOAT-DAYS
Element: Float Days | Numeric 3
This is a number of days to add to best
terms calculation if the vendor will
allow a specific number of days for
payment to reach them and still receive
the discount.
|
|
API-MTCH-PREPAY-FL
Element: Mtch Prepay Fl | Alpha 1
Flag that notes if the invoice will be
prepaid. This is for match invoices.
" " = Blank
1 = Yes
2 = No |
|
API-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 |
|
API-PREPAY-DATE
Element: Prepay Date | Numeric 8 (yyyymmdd)
|
|
API-PRPY-DISC-CODE
Element: Prpy Disc Code | Alpha 10
|
|
API-PRPY-REF-NBR
Element: Prpy Ref Nbr | Alpha 22
|
|
API-PRPY-RTL-AMT
Element: Intl Amt | Signed 18.2
|
|
API-PRPY-AMT
Element: Intl Amt | Signed 18.2
|
|
API-PRPY-AOC-AMT
Element: Intl Amt | Signed 18.2
|
|
API-PRPY-TAX-AMT
Element: Intl Amt | Signed 18.2
|
|
API-PRPY-SERV-AMT
Element: Intl Amt | Signed 18.2
|
|
API-COCO-FL
Element: Coco Fl | Numeric 1
This is the flag when added to the
handling code denotes that the invoice
will be reviewed for match based on
header, line, and Cost components (AOC)
|
|
API-MATCH-AOC
Element: Intl Amt | Signed 18.2
This is the amount of the AOC that has
been matched.
|
|
API-HASH-QTY
Element: Hash Qty | Signed 15.4
This is the total qty of the goods on
the invoice. This field will be used to
match on quantity.
|
|
API-XREF-VENDOR
Element: Xref Vendor | Alpha 9 (Right Justified)
This is a vendor that is supported on a
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
|
|
API-MTCH-ERR-TYPE
Element: Mtch Err Type | Numeric 2
This is the reason the match was not
successful for Invoice Match.
01 = Match Invoice
02 = Cost error
03 = No receipt information
04 = Hash quantity error
05 = No AOC on purchase order
06 = No AOC cost
07 = Tax out of balance |
|
API-BT-AMT
Element: Intl Amt | Signed 18.2
This is the amount of the discount based
on best terms
|
|
API-DISC-POINT
Element: Disc Point | Numeric 1
This is the flag that will note if the
discounts will be applied to the cost of
the goods or the cost of the goods and
the AOC.
1 = Cost of goods
2 = Cost of Goods and AOC |
|
API-TAX-FLAG
Element: All Flag | Alpha 1
" " = Not interfaced
I = Interfaced |
|
API-TAX-OUT-BAL
Element: Tax Out Bal | Derived
The amount of the invoice that is
out-of-balance due to tax applications
made for the invoice.
|
|
API-TXB-OUT-BAL
Element: Txb Out Bal | Derived
Derived field to show difference between
header taxable input and total taxable
amount from distributions.
|
|
API-PMT-OUT-BAL
Element: Pmt Out Bal | Derived
The amount of the invoice that is
out-of-balance due to payment
applications made for the invoice.
|
|
API-DIST-OUT-BAL
Element: Dist Out Bal | Derived
The amount of the invoice that is
out-of-balance due to expense
distribution applications made for the
invoice.
|
|
API-OUT-BAL-FLAG
Out of Balance
Indicator | Derived
Indicates whether the invoice is
out-of-balance. Valid values are:
N = No.
Y = Yes.
|
|
API-INV-STATUS
Element: Inv Status | Derived
Indicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
|
|
API-REV-SIGN-AMT
Reversed Signed
Amount | Derived
The invoice amount * -1.
|
|
API-TYPE-SHORT-NME
Short Invoice Type
Name | Derived
The translation of the invoice type.
|
|
API-PO-RELEASE-3
Purchase Order
Release Number | Derived
The purchase order release number
associated with the invoice. Used to
identify a purchase order release
created from a blanket or standing
order.
|
|
API-CHARGEBACK-FL
Element: Chargeback Fl | Alpha 1
|
|
API-ORIGIN-COUNTRY
Element: Origin Country | Alpha 2
The country from which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance)
|
|
API-ORIGIN-REGION
Element: Origin Region | Alpha 2
The region of the country from which the
goods were shipped, if required. Must be
a valid region in IN02.1 (Region
Maintenance)
|
|
API-DEST-COUNTRY
Element: Dest Country | Alpha 2
The country to which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance).
|
|
API-DEST-REGION
Element: Dest Region | Alpha 2
The region of the country to which the
goods were shipped, if required. Must
be a valid region in IN02.1 (Region
Maintenance)
|
|
API-TRANSPORT-MODE
Element: Transport Mode | Alpha 1
The mode of transportation at the
border crossing. Code 7 is used for the
Channel Tunnel.
|
|
API-STATEMENT
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
API-CONTRACT-GROUP
Element: Enterprise Grp | Alpha 4
|
|
API-CM-CONTRACT
Element: Cm Contract | Numeric 15
|
|
API-REBATE-TYPE
Element: Rebate Type | Alpha 25
|
|
API-REBATE-DUE-DTE
Element: Date | Numeric 8 (yyyymmdd)
|
|
API-MTCH-PROC-TYPE
Element: Mtch Proc Type | Alpha 2
R = Receipt Match
S = Service
A = AOC only
D = Drop Ship
V = Vendor Agreement
E = Expense |
|
API-RET-ACCR-CODE
Element: Accr Code | Alpha 4
|
|
API-RET-TRAN-AMT
Element: Intl Amt | Signed 18.2
|
|
API-RET-BASE-AMT
Element: Intl Amt | Signed 18.2
|
|
API-RET-TRAN-PMT
Element: Intl Amt | Signed 18.2
|
|
API-RET-BASE-PMT
Element: Intl Amt | Signed 18.2
|
|
API-REF-INV-FL
Element: Flag | Alpha 1
Y = One or More Memos exist
" " = No Memos exist |
|
API-TAX-TYPE
Element: Tax Type | Alpha 1
I = Invoiced
A = Accrued |
|
API-SEC-WITHHOLD
Element: Sec Withhold | Alpha 1
Y = Yes
N = No |
|
API-CREATED-BY
Element: Operator | Alpha 10
|
|
API-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
API-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
API-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
API-FOR-ECON-CODE
Element: Code | Alpha 10
|
|
API-DISCOUNT-RT1
Element: Discount Rt | Percent 5.3 (Percent)
|
|
API-DISCOUNT-RT2
Element: Discount Rt | Percent 5.3 (Percent)
|
|
API-DISCOUNT-RT3
Element: Discount Rt | Percent 5.3 (Percent)
|
|
API-BASE-DISC-AMT1
Element: Intl Amt | Signed 18.2
|
|
API-BASE-DISC-AMT2
Element: Intl Amt | Signed 18.2
|
|
API-BASE-DISC-AMT3
Element: Intl Amt | Signed 18.2
|
|
API-TRAN-DISC-AMT1
Element: Intl Amt | Signed 18.2
|
|
API-TRAN-DISC-AMT2
Element: Intl Amt | Signed 18.2
|
|
API-TRAN-DISC-AMT3
Element: Intl Amt | Signed 18.2
|
|
API-DISC-DATE1
Element: Date | Numeric 8 (yyyymmdd)
|
|
API-DISC-DATE2
Element: Date | Numeric 8 (yyyymmdd)
|
|
API-DISC-DATE3
Element: Date | Numeric 8 (yyyymmdd)
|
|
API-FREIGHT-TOT
Element: Freight Total | Signed 18.2
|
|
API-INSURANCE-TOT
Element: Insurance Tot | Signed 18.2
|
|
API-CSTMS-TOT
Element: Cstms Total | Signed 18.2
|
|
API-OTHER-AOC-TOT
Element: Other Aoc Tot | Signed 18.2
|
|
API-GLBL-DOC-TYPE
Element: Glbl Doc Type | Alpha 10
|
|
API-REF-TYPE
Element: Ref Type | Alpha 1
|
|
API-CUSTOMER-ID
Element: Customer Id | Alpha 27
|
|
API-PMT-CAT-CODE
Element: Pmt Cat Code | Alpha 6
|
|
API-NO-PAY-CONCERN
Element: No Pay Concern | Alpha 60
|
|
API-REFERENCE-NO
Element: Upn2 Nbr | Alpha 25 (Right Justified)
|
|
