OIINVOICE FILE
Interface Invoice
This is an invoice batch interface file that can be used to interface invoice
records from a source outside of the Lawson Order Entry and Billing systems.
Once the records have been loaded to this file, BL520 (Billing Interface) can
be run to load the records into the Lawson Billing system.
REFERENCED BY
BL199
UPDATED BY
BL98.1 BL98.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OII-COMPANY Numeric 4 BL98.1
Company The company number represents an
established company and is entered on
all function codes.
OII-INVC-PREFIX Alpha 2 BL98.1
Invoice Prefix Invoice or credit memo prefix must be
entered here for every invoice or credit
memo interfaced into the Billing system.
If this were a record created online or
by OE129 (Daily Shipment Journal), the
system would assign the prefix defined
at either the company or process level,
depending on the invoice level option
chosen.
OII-INVC-NUMBER Numeric 8 BL98.1
Invc Number Invoice or credit memo number must be
unique within your company and must be
entered on this field for every record
interfaced into the system. For invoices
created online or via OE129 (Daily
Shipment Journal), the invoice number is
automatically assigned by the system.
OII-PROCESS-LEVEL Alpha 5 BL98.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company. It must be entered on every
invoice or credit interfaced into the
system from this file.
OII-LOCATION Alpha 5 BL98.1
Location Code This field contains a valid stock
location within the company inventory.
Can optionally be entered or if left
blank will default when BL520 (Billing
Interface) adds the invoice to the
system.
OII-CUSTOMER Alpha 9 (Right Justified) BL98.1
Customer Number Customer number representing a unique
customer number. It must be entered on
every invoice or credit that is
interfaced into the system from this
file.
OII-SHIP-TO Numeric 4 BL98.1
Ship-to Code Customer's ship-to number. Can
optionally be entered on this field if
the invoice or credit pertains to an
order that was sent to a customer
ship-to location instead of the customer
bill-to location.
OII-BILL-TO Numeric 4 BL98.1
Bill To This field contains the bill-to
customer number.
OII-INVC-TYPE Alpha 4 BL98.1
Invoice Type Invoice type is maintained in this
field. This is a user-defined required
value that must be entered here and can
be set up on BL06.1 (Invoice Type).
Invoice type identifies the record being
entered as either an invoice or credit
memo.
OII-REASON-CODE Alpha 4 BL98.1
Reason Code Reason code is used to indicate the
cause for credit memos. It is allowed on
invoices also. If entered, it must be
valid in the Reason Code file.
OII-INVOICE-DATE Numeric 8 (yyyymmdd) BL98.1
Invoice Date This is the date that the invoice is
created. Basis date for the terms
discount and due date calculations. For
system-generated invoices, the invoice
date is the system date assigned when
OE129 (Daily Shipment Journal) is run.
For manual invoices, this date will
default to the system date and can be
overridden.
OII-GL-DATE Numeric 8 (yyyymmdd) BL98.1
General Ledger Date This field contains the general ledger
posting date. If left blank, the system
date will default onto this field.
OII-PRICE-DATE Numeric 8 (yyyymmdd) BL98.1
Price Date This is the date with which the price
will be determined. This will default to
the invoice date if left blank or can be
overridden when entering an invoice into
the system.
OII-TAX-DATE Numeric 8 (yyyymmdd)
Tax Date This is the date used by a third-party
taxing system to determine when the tax
should be assessed.
OII-CURRENCY-CODE Alpha 5 BL98.1
Currency Code This field contains the company's base
currency code defined in the General
Ledger system.
OII-CURR-RATE Signed 13.6 BL98.1
Currency Rate The currency rate. This can be left
blank or will default from the currency
file when the invoice is interfaced from
this file.
OII-REVALUE-FL Alpha 1 BL98.1
Revalue This revalue flag is used by the
Accounts Receivable system if
multicurrency processing is used. If the
invoice is interfaced with a non-base
currency code, this flag will default to
Yes.
OII-TAX-CODE Alpha 10 BL98.1
Tax Code This field contains a code representing
the tax authorities this ship-to pays
sales tax to. This must be a valid Tax
Code file.
OII-TAXABLE-TOTAL Signed 15.2 BL98.1
Taxable Total This is the amount of the invoice that
is taxable.
OII-TERMS-CD Alpha 5 BL98.1
Terms Code This is the customer's payment terms
code that must be valid in the Terms
system.
OII-ORDER-NBR Numeric 8 BL98.1
Order Number This is the order number that is
associated with the invoice. Optionally
can be entered on this record.
OII-SHIPMENT-NBR Numeric 10 BL98.1
Shipment Number This can optionally be entered as the
shipment number of the order to which
this invoice corresponds.
OII-SHIP-DATE Numeric 8 (yyyymmdd) BL98.1
Ship Date This field contains the ship date. If
left blank, the system date defaults.
OII-CHECK-NBR Numeric 8 BL98.1
Payment Number This is the payment number that was
submitted as a down payment or cash in
advance for the invoice or order
associated with this invoice.
OII-CIA-AMT Signed 15.2 BL98.1
Cash In Advance This is the amount of cash in advance
Amount (down payment) that was entered when
placing the customer's order or invoice.
OII-LETTER-OF-CR Alpha 20 BL98.1
Letter of Credit This field contains the letter of
credit.
OII-TERRITORY Alpha 4 BL98.1
Sales Territory This is the sales territory to which
the customer being invoiced belongs.
OII-SALESMAN Numeric 4 BL98.1
Salesman Number Primary sales representative
responsible for this order or invoice.
Defaults from the customer ship-to for
this invoice, or if ship-to is not
entered, will default from the customer
master.
OII-COMM-RATE-1 Percent 7.5 (Percent) BL98.1
Commission Rate for This field contains the commission rate
Slsmn 1 of the primary sales representative.
This defaults from the sales
representative's file.
OII-SALESMAN-2 Numeric 4 BL98.1
Salesman Number 2 This is the secondary sales
representative responsible for this
order or invoice. Defaults from the
customer ship-to for this order, or if
ship-to is not entered, will default
from the customer master file.
OII-COMM-RATE-2 Percent 7.5 (Percent) BL98.1
Commission Rate for This field contains the commission rate
Slsmn 2 for the second sales representative.
This defaults from the sales
representative's file.
OII-COMM-SPLIT Percent 5.3 (Percent) BL98.1
Commission Split Portion of the invoice or order the
Percentage second sales representative's commission
percent is applied to. The first sales
representative's commission percent is
applied to the remaining amount.
Defaults from the customer master file.
OII-REFERENCE Alpha 10 (Lower Case) BL98.1
Reference This is an available field to enter any
kind of reference information on the
order or invoice.
OII-CUST-PO-NBR Alpha 22 BL98.1
Customer P.O. Number This is the customer purchase order
number associated with this order or
invoice.
OII-AR-CODE Alpha 4 BL98.1
Accounts Receivable This is the Accounts Receivable code
Code (tied to the Accounts Receivable general
ledger account) that will be or has been
debited for this order or invoice.
OII-ENTERED-DISC Signed 15.2 BL98.1
Entered Disc This is the amount of the add-on
discount entered in invoice currency.
Note: a system invoice can have both an
entered discount as well as an order
discount.
OII-FREIGHT-CODE Alpha 2 BL98.1
Freight Code This field contains the freight code.
This is must be valid in the Order Entry
Freight Code file. This determines
whether carrier and charge are allowed
for the shipment.
OII-FRT-CHARGE Signed 15.2 BL98.1
Frt Charge This is the total amount of freight
being charged on this invoice.
OII-STD-COMM Alpha 4 Occurs 6 Times BL98.1
Standard Comment This is an optional standard comment
code that can be placed on this
interface record and will print on the
invoice.
OII-TRANS-USER1 Alpha 10 BL98.1
Trans User1 This is the first user-defined field on
the invoice. This value will be passed
on the invoice into the Accounts
Receivable system.
OII-TRANS-USER2 Alpha 15 BL98.1
Trans User2 This is the second user-defined field
on the invoice. This value will be
passed on the invoice into the Accounts
Receivable system.
OII-TRANS-USER3 Numeric 8 (yyyymmdd) BL98.1
Trans User3 This is the third user-defined field on
the invoice. This value will be passed
on the invoice into the Accounts
Receivable system.
OII-TRANS-USER4 Numeric 9 BL98.1
Trans User4 This is the fourth user-defined field
on the invoice. This value will be
passed on the invoice into the Accounts
Receivable system.
OII-TRANS-USER5 Signed 13.2 BL98.1
Trans User5 This is the fifth user-defined field on
the invoice. This value will be passed
on the invoice into the Accounts
Receivable system.
OII-INVC-SOURCE Alpha 1 BL98.1
Invc Source Any user-defined value can be placed on
this field to serve as select criteria
when running BL520 (Billing Interface).
Once the record has been added to the
Billing system, however, the Invoice
Source field will have an (I) on it,
indicating that it was interfaced.
OII-ORIG-INVC-PRE Alpha 2 BL98.1
Orig Invc Pre This field contains the prefix of the
original invoice against which the
return is being made.
OII-ORIG-INVC-NBR Numeric 8 BL98.1
Orig Invc Nbr This field contains the number of the
orginal invoice against which the return
is being made.
OII-AUTO-APP-FL Alpha 1 BL98.1
Auto App Fl Automatically applies this credit memo
to the original invoice.
OII-BANK-INST-CODE Alpha 3 BL98.1
Transaction Code A transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
OII-HOLD-CODE Alpha 4 BL98.1
Hold Code This is the hold code that determines
why an invoice is on hol. If there is a
value in this field, the invoice is on
hold and will be prevented from being
processed through the invoice printing
phase.
OII-TAX-EXEMPT-CD Alpha 1 BL98.1
Tax Exempt Code Indicates whether the invoice is tax
exempt or not.
OII-OEI-USR-FLD-01 Alpha 20
Oei Usr Fld 01 Interface invoice user field 1.
OII-OEI-USR-FLD-02 Alpha 20
Oei Usr Fld 02 Interface invoice user field 2.
OII-OEI-USR-FLD-03 Alpha 20
Oei Usr Fld 03 Interface invoice user field 3.
OII-OEI-USR-FLD-04 Alpha 20
Oei Usr Fld 04 Interface invoice user field 4.
OII-OEI-USR-FLD-05 Alpha 20
Oei Usr Fld 05 Interface invoice user field 5.
OII-EP-TYPE Alpha 5 BL98.1
Ep Type
OII-EP-ACCOUNT Alpha 32 BL98.1
Ep Account
OII-EP-EXP-DATE Numeric 8 (yyyymmdd) BL98.1
Ep Exp Date
OII-EP-MARGIN-MIN Signed 7.2
Ep Margin Min
OII-EP-MARGIN-PCT Percent 8.5 (Percent)
Ep Margin Pct
OIINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIISET1 COMPANY BL98.1 BL98.2
INVC-PREFIX
INVC-NUMBER
OIISET2 COMPANY BL199
GL-DATE
INVC-PREFIX
INVC-NUMBER
OIINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OII-COMPANY -> OEC-COMPANY
OIINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Invcmisc OIINVCMISC Delete Cascades
OII-COMPANY -> OIX-COMPANY
OII-INVC-PREFIX -> OIX-INVC-PREFIX
OII-INVC-NUMBER -> OIX-INVC-NUMBER
Zeroes -> OIX-LINE-NBR
OIX-SEQ
Oiinvcline OIINVCLINE Delete Cascades
OII-COMPANY -> OIZ-COMPANY
OII-INVC-PREFIX -> OIZ-INVC-PREFIX
OII-INVC-NUMBER -> OIZ-INVC-NUMBER
OIZ-LINE-NBR
|
