Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OIINVOICE


                             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

BL520     BL98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OII-COMPANY            Numeric 4                                 BL98.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OII-INVC-PREFIX        Alpha 2                                   BL98.1
Element: Invc Prefix   Invoice or credit memo prefix must be
                       entered here for every invoice or credit
                       memo interfaced into Billing. If this
                       were a record created online or by Daily
                       Shipment Journal (OE129), 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
Element: 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 Daily Shipment
                       Journal (OE129), the invoice number is
                       automatically assigned by the system.

OII-PROCESS-LEVEL      Alpha 5                                   BL98.1
Element: 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
Element: Location      This field contains a valid stock
                       location within the company inventory.
                       Can optionally be entered or if left
                       blank will default when Billing
                       Interface (BL520) adds the invoice to
                       the system.

OII-CUSTOMER           Alpha 9  (Right Justified)                BL98.1
Element: Customer      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
Element: Ship To       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
Element: Bill To       This field contains the bill-to
                       customer number.

OII-INVC-TYPE          Alpha 4                                   BL98.1
Element: Invc 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 Invoice Types (BL06.1).
                       Invoice type identifies the record being
                       entered as either an invoice or credit
                       memo.

OII-REASON-CODE        Alpha 4                                   BL98.1
Element: 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
Element: 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
                       Daily Shipment Journal (OE129) 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
Element: Gl 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
Element: 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)                     BL98.1
Element: 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
Element: Currency Code This field contains the company's base
                       currency code defined in General Ledger.

OII-CURR-RATE          Signed 14.7                               BL98.1
Element: Curr 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
Element: Revalue Fl    This revalue flag is used by Accounts
                       Receivable 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
Element: 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 18.2                               BL98.1
Element: Intl Amt      This is the amount of the invoice that
                       is taxable.

OII-TERMS-CD           Alpha 5                                   BL98.1
Element: Term Code     This is the customer's payment terms
                       code that must be valid in Terms.

OII-ORDER-NBR          Numeric 8                                 BL98.1
Element: Order Nbr     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
Element: Shipment Nbr  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
Element: Date          This field displays the system date
                       when this was created.

OII-CHECK-NBR          Numeric 8                                 BL98.1
Element: Check Nbr     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 18.2                               BL98.1
Element: Intl Amt      This is the amount of cash in advance
                       (down payment) that was entered when
                       placing the customer's order or invoice.

OII-LETTER-OF-CR       Alpha 20                                  BL98.1
Element: Letter Of Cr  This field contains the letter of
                       credit.

OII-TERRITORY          Alpha 4                                   BL98.1
Element: Territory     This is the sales territory to which
                       the customer being invoiced belongs.

OII-SALESMAN           Numeric 4                                 BL98.1
Element: Salesman      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
Element: Chrg Rate     Charge rate by month.

OII-SALESMAN-2         Numeric 4                                 BL98.1
Element: Salesman      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
Element: Chrg Rate     This field contains the commission rate
                       for the second sales representative.
                       This defaults from the sales
                       representative's file.

OII-COMM-SPLIT         Percent 5.3  (Percent)                    BL98.1
Element: Comm Split    Portion of the invoice or order the
                       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
Element: 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
Element: Cust Po Nbr   This is the customer purchase order
                       number associated with this order or
                       invoice.

OII-AR-CODE            Alpha 4                                   BL98.1
Element: Ar Code       This is the Accounts Receivable 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 18.2                               BL98.1
Element: Intl Amt      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
Element: 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 18.2                               BL98.1
Element: Intl Amt      This is the total amount of freight
                       being charged on this invoice.

OII-STD-COMM           Alpha 4 Occurs 6 Times                    BL98.1
Element: Std Comm      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
Element: Trans User1   This is the first user-defined field on
                       the invoice. This value will be passed
                       on the invoice into Accounts Receivable.

OII-TRANS-USER2        Alpha 15                                  BL98.1
Element: Agent         This is the second user-defined field
                       on the invoice. This value will be
                       passed on the invoice into Accounts
                       Receivable.

OII-TRANS-USER3        Numeric 8  (yyyymmdd)                     BL98.1
Element: Trans User3   This is the third user-defined field on
                       the invoice. This value will be passed
                       on the invoice into Accounts Receivable.

OII-TRANS-USER4        Numeric 9                                 BL98.1
Element: Trans User4   This is the fourth user-defined field
                       on the invoice. This value will be
                       passed on the invoice into Accounts
                       Receivable.

OII-TRANS-USER5        Signed 18.2                               BL98.1
Element: Intl Amt      This is the fifth user-defined field on
                       the invoice. This value will be passed
                       on the invoice into Accounts Receivable.

OII-INVC-SOURCE        Alpha 1                                   BL520   BL98.1
Element: Invc Source   Any user-defined value can be placed on
                       this field to serve as select criteria
                       when running Billing Interface (BL520).
                       Once the record has been added to
                       Billing, however, the Invoice Source
                       field will have an (I) on it, indicating
                       that it was interfaced.

OII-ORIG-INVC-PRE      Alpha 2                                   BL98.1
Element: Invc Prefix   This field contains the prefix of the
                       original invoice against which the
                       return is being made.

OII-ORIG-INVC-NBR      Numeric 8                                 BL98.1
Element: Invc Number   This field contains the number of the
                       original invoice against which the
                       return is being made.

OII-AUTO-APP-FL        Alpha 1                                   BL98.1
Element: Auto App Fl   Automatically applies this credit memo
                       to the original invoice.

OII-BANK-INST-CODE     Alpha 3                                   BL98.1
Element: Bank Inst CodeA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

OII-HOLD-CODE          Alpha 4                                   BL98.1
Element: Hold Code     This is the hold code that determines
                       why an invoice is on hold.  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
Element: Tax Exempt Cd Indicates whether the invoice is tax
                       exempt or not.

OII-OEI-USR-FLD-01     Alpha 20                                  BL98.1
Element: Oei Usr Fld 01Interface invoice user field 1.

OII-OEI-USR-FLD-02     Alpha 20                                  BL98.1
Element: Oei Usr Fld 02Interface invoice user field 2.

OII-OEI-USR-FLD-03     Alpha 20                                  BL98.1
Element: Oei Usr Fld 03Interface invoice user field 3.

OII-OEI-USR-FLD-04     Alpha 20                                  BL98.1
Element: Oei Usr Fld 04Interface invoice user field 4.

OII-OEI-USR-FLD-05     Alpha 20                                  BL98.1
Element: Oei Usr Fld 05Interface invoice user field 5.

OII-EP-TYPE            Alpha 5                                   BL98.1
Element: Ep Type

OII-EP-ACCOUNT         Alpha 32                                  BL98.1
Element: Ep Account

OII-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     BL98.1
Element: Ep Exp Date

OII-EP-MARGIN-MIN      Signed 7.2
Element: Ep Margin Min

OII-EP-MARGIN-PCT      Percent 8.5  (Percent)
Element: Ep Margin Pct

OII-ACTIVITY           Alpha 15                                  BL98.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


OII-ACCT-CATEGORY      Alpha 5                                   BL98.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

OII-ACTIVITY-C         Alpha 15                                  BL98.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


OII-ACCT-CATEG-C       Alpha 5                                   BL98.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

OII-OPR-CODE           Alpha 10  (Lower Case)                    BL98.1
Element: Opr Code      This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

                         OIINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OIISET1   COMPANY                                                BL520   BL98.1
          INVC-PREFIX                                            BL98.2
          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