|
|
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
AC115 BL520 BL966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OII-COMPANY Numeric 4 AC115 BL966
Company The company number represents an
established company and is entered on
all function codes.
OII-INVC-PREFIX Alpha 2 AC115 BL966
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 AC115 BL966
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 AC115 BL966
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 BL966
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) AC115 BL966
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 BL966
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-INVC-TYPE Alpha 4 AC115 BL966
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 AC115 BL966
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) AC115 BL966
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) AC115 BL966
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) BL966
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) BL966
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 AC115 BL966
Currency Code This field contains the company's base
currency code defined in the General
Ledger system.
OII-CURR-RATE Signed 13.6 BL966
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 BL966
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 AC115 BL966
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 BL966
Taxable Total This is the amount of the invoice that
is taxable.
OII-TERMS-CD Alpha 5 BL966
Terms Code This is the customer's payment terms
code that must be valid in the Terms
system.
OII-ORDER-NBR Numeric 8 BL966
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 BL966
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) BL966
Ship Date This field contains the ship date. If
left blank, the system date defaults.
OII-CHECK-NBR Numeric 8 BL966
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 BL966
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 BL966
Letter of Credit This field contains the letter of
credit.
OII-CC-TYPE Alpha 2 BL966
Credit Card Type This is the credit card type that was
used by the customer to pay for the
order or invoice.
OII-CC-NUMBER Alpha 17 BL966
Credit Card Number This is the credit card number that was
used by the customer to pay for the
invoice/order.
OII-CC-EXP-DATE Numeric 6 BL966
Credit Card This is the credit card expiration date.
Expiration Date
OII-TERRITORY Alpha 4 BL966
Sales Territory This is the sales territory to which
the customer being invoiced belongs.
OII-SALESMAN Numeric 4 BL966
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) BL966
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 BL966
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) BL966
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) BL966
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) AC115 BL966
Reference This is an available field to enter any
kind of reference information on the
order or invoice.
OII-CUST-PO-NBR Alpha 20 BL966
Customer P.O. Number This is the customer purchase order
number associated with this order or
invoice.
OII-AR-CODE Alpha 4 BL966
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 BL966
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 BL966
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 BL966
Frt Charge This is the total amount of freight
being charged on this invoice.
OII-STD-COMM Alpha 4 Occurs 6 Times BL966
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 BL966
Trans User 1 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 BL966
Trans User 2 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) BL966
Trans User 3 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 BL966
Trans User 4 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 BL966
Trans User 5 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 AC115 BL520
Invc Source Any user-defined value can be placed on BL966
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-BILL-TO Numeric 4 AC115
Bill-To Customer This field contains the bill-to
Number customer number.
OIINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIISET1 COMPANY AC115 BL199
INVC-PREFIX BL520 BL966
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
|