Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OIINVCLINE


                            OIINVCLINE FILE

                         Interface Invoice Line

This is an invoice line batch interface file that can be used (in conjunction
with the Invoice Interface file) to interface invoice line 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.

UPDATED BY

BL520     BL98.1    BL98.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIZ-COMPANY            Numeric 4                                 BL98.2
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.

OIZ-INVC-PREFIX        Alpha 2                                   BL98.2
Element: Invoice PrefixInvoice or credit memo prefix must be
                       entered here for every invoice/credit
                       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.

OIZ-INVC-NUMBER        Numeric 8                                 BL98.2
Element: Invc Number   Invoice/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.

OIZ-LINE-NBR           Numeric 6                                 BL98.2
Element: Line Number   This field displays the system-assigned
                       number of the invoice line.

OIZ-LINE-TYPE          Alpha 1                                   BL98.2
Element: Line Type     The line type indicates whether the
                       item on the line is an inventoried,
                       nonstock, or special item.

OIZ-ITEM               Alpha 32                                  BL98.2
Element: Item Number   This field contains the item
                       identifier.

OIZ-DESCRIPTION        Alpha 30  (Lower Case)                    BL98.2
Element: Description   The description of the item.

OIZ-QUANTITY           Signed 13.4                               BL98.2
Element: Quantity      This field shows the quantity of the
                       item that is being billed on this
                       invoice line.

OIZ-SELL-UOM           Alpha 4                                   BL98.2
Element: Unit of MeasurThis field contains the stock unit of
                       measure for the item.

OIZ-ENTERED-PRICE      Signed 18.5                               BL98.2
Element: Intl Cost     This is the price of the line item. If
                       left blank, BL520 (Billing Interface)
                       will price items that are inventoried or
                       nonstock. Special items must have the
                       price entered.

OIZ-UNIT-COST          Signed 18.5                               BL98.2
Element: Intl Cost     This field contains the unit cost of
                       the invoice line.

OIZ-NO-CHARGE-FL       Alpha 1                                   BL98.2
Element: No Charge FlagNo charge flag indicating if the line
                       is intentionally supposed to be no
                       charge.

OIZ-ENTERED-DISC       Signed 18.2                               BL98.2
Element: Intl Amt      This is the add-on discount that can be
                       entered when adding an invoice line.

OIZ-TAX-EXEMPT-CD      Alpha 1                                   BL98.2
Element: Tax Exempt CodThis value indicates whether the line
                       item is tax exempt or not.
                       E = Exempt
                       T = Taxable

OIZ-ORD-DISC-FL        Alpha 1                                   BL98.2
Element: Order DiscountThis flag determines whether the order
                       line is eligible for an allocated
                       discount.

OIZ-LOCATION           Alpha 5                                   BL98.2
Element: Location Code This field contains a valid stock
                       location within the company inventory.

OIZ-SLS-ACCT-UNIT      Alpha 15                                  BL98.2
Element: Accounting UniSales account unit to be credited or
                       debited for this line.

OIZ-SLS-ACCOUNT        Numeric 6                                 BL98.2
Element: Account       Sales account number to be credited or
                       debited for this line.

OIZ-SLS-SUB-ACCT       Numeric 4                                 BL98.2
Element: Subaccount    Sales subaccount to be credited or
                       debited for this line.

OIZ-OFF-ACCT-UNIT      Alpha 15                                  BL98.2
Element: Accounting UniThis cost of goods offset account unit
                       will be credited for invoices line items
                       that are nonstock or special items and
                       that have a cost associated with them.

OIZ-OFF-ACCOUNT        Numeric 6                                 BL98.2
Element: Account       This cost of goods offset account
                       number will be credited for nonstock and
                       special items on an invoice that have a
                       cost associated with them.

OIZ-OFF-SUB-ACCT       Numeric 4                                 BL98.2
Element: Subaccount    This cost of goods offset subaccount
                       Number will be credited for nonstock and
                       special items on an invoice that have
                       costs associated with them.

OIZ-CGS-ACCT-UNIT      Alpha 15                                  BL98.2
Element: Accounting UniThe cost of goods sold account unit is
                       debited for nonstock or special items on
                       an invoice.

OIZ-CGS-ACCOUNT        Numeric 6                                 BL98.2
Element: Account       The cost of goods sold account number
                       is debited for nonstock or special items
                       on an invoice.

OIZ-CGS-SUB-ACCT       Numeric 4                                 BL98.2
Element: Subaccount    The cost of goods sold subaccount
                       number is debited for nonstock or
                       special items on an invoice.

OIZ-ACTIVITY           Alpha 15                                  BL98.2
Element: Activity      In this file the Activity field is used
                       for revenue (sales) postings whereas the
                       Activity-C field is used for Cost (COGS)
                       postings.

                       Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

OIZ-ACCT-CATEGORY      Alpha 5                                   BL98.2
Element: Account CategoIn this file the Acct-Category field is
                       used for revenue (sales) postings
                       whereas the Acct-Categ-C field is used
                       for Cost (COGS) postings.

                       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.

OIZ-ACTIVITY-C         Alpha 15                                  BL98.2
Element: Activity      In this file the Activity-C field is
                       used for Cost (COGS) postings whereas
                       the Activity field is used for revenue
                       (sales) postings.

                       Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

OIZ-ACCT-CATEG-C       Alpha 5                                   BL98.2
Element: Account CategoIn this file the Acct-Categ-C field is
                       used for Cost (COGS) postings whereas
                       the Acct-Category field is used for
                       revenue (sales) postings.

                       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.

OIZ-TAX-CODE           Alpha 10                                  BL98.2
Element: Tax Code      This field contains a code representing
                       the tax authorities this ship-to pays
                       sales tax to. This must be valid in the
                       Tax Code file.

OIZ-ORDER-NBR          Numeric 8                                 BL98.2
Element: Order Number  If the invoice this invoice line was
                       created on is based on an order
                       shipment, this field will store the
                       order number related to the line.

OIZ-SPR-UOM            Alpha 4                                   BL98.2
Element: Unit of MeasurIndicates the selling price unit of
                       measure with which this line has been
                       priced.

OIZ-ADD-ON-DISC        Signed 18.2                               BL98.2
Element: Intl Amt      This is the add-on discount in the
                       company base currency.

OIZ-TERRITORY          Alpha 4                                   BL98.2
Element: Sales TerritorThe sales territory to which this line
                       belongs.  The territory is determined
                       based upon the customer and the sales
                       representative assigned to the customer.
                       Territory can be overidden online when
                       adding an invoice.

OIZ-SALESMAN           Numeric 4                                 BL98.2
Element: Salesman NumbeThe primary sales representative
                       responsible for this order and/or
                       invoice.  Defaults from the customer
                       ship-to for this order, or if the
                       ship-to is not entered, will default
                       from the customer master.  The sales
                       representative can be overrideen when
                       entering an order and/or invoice.

                       This is the sales representative to
                       which the invoice or order belongs. This
                       will default from the customer master or
                       can be overrideen when placing the order
                       or entering the invoice.

OIZ-SALESMAN-2         Numeric 4                                 BL98.2
Element: Salesman NumbeThe secondary sales representative
                       responsible for this order and/or
                       invoice.  Defaults from the customer
                       ship-to for this order, or if the
                       ship-to is not entered, will default
                       from the customer master

OIZ-COMM-RATE-1        Percent 7.5  (Percent)                    BL98.2
Element: Chrg Rate     Commission rate for sales representative
                       1.  Defaults from the sales
                       representative record.

OIZ-COMM-RATE-2        Percent 7.5  (Percent)                    BL98.2
Element: Chrg Rate     Commission rate for sales representative
                       2.  Defaults from the salesman record.

OIZ-COMM-SPLIT         Percent 5.3  (Percent)                    BL98.2
Commission Split       The portion of the invoice line to which
Percentage             the second sales representative's
                       commission percent is applied.  The
                       first sales representative's commission
                       percent is applied to the remaining
                       amount.  Defaults from teh Customer
                       Master file.

OIZ-USER-FLD1          Alpha 2                                   BL98.2
Purchase Order User    This is the first user-defined field on
Field 2                the invoice line.  These user-defined
                       field values, if entered, and the line
                       is a create PO=Yes, will interface into
                       the Purchase Order system and appear on
                       the purchase order user-defined fields.

OIZ-USER-FLD2          Alpha 30  (Lower Case)                    BL98.2
Element: User Defined FThe second user-defined field on the
                       invoice line.  Thse user-defined field
                       values, if enetered and the line creates
                       a puchase order, will interface onto the
                       Purchase Order system and appear on the
                       purchase order-defined fields.

OIZ-USER-FLD3          Alpha 15  (Lower Case)                    BL98.2
Element: User Defined FThe third user-defined field on the
                       invoice line.  These user defined field
                       values, if entered and the line creates
                       a purchase order, will interface into
                       the Purchase Order system and appear on
                       the puchase order line in the purchase
                       order user-defined fields.

OIZ-OIL-USR-FLD-01     Alpha 20                                  BL98.2
Element: Oil Usr Fld 01Interface invoice line user field 1.

OIZ-OIL-USR-FLD-02     Alpha 20                                  BL98.2
Element: Oil Usr Fld 02Interface invoice line user field 2.

OIZ-OIL-USR-FLD-03     Alpha 20                                  BL98.2
Element: Oil Usr Fld 03Interface invoice line user field 3.

OIZ-OIL-USR-FLD-04     Alpha 20                                  BL98.2
Element: Oil Usr Fld 04Interface invoice line user field 4.

OIZ-OIL-USR-FLD-05     Alpha 20                                  BL98.2
Element: Oil Usr Fld 05Interface invoice line user field 5.

                         OIINVCLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OIZSET1   COMPANY                                                BL520   BL98.1
          INVC-PREFIX                                            BL98.2
          INVC-NUMBER
          LINE-NBR

                         OIINVCLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Linecomm       OIINVCCOMM   Delete Cascades

                            OIZ-COMPANY        -> OIW-COMPANY
                            OIZ-INVC-PREFIX    -> OIW-INVC-PREFIX
                            OIZ-INVC-NUMBER    -> OIW-INVC-NUMBER
                            OIZ-LINE-NBR       -> OIW-LINE-NBR
                                                  OIW-SEQ

Linemisc       OIINVCMISC   Delete Cascades

                            OIZ-COMPANY        -> OIX-COMPANY
                            OIZ-INVC-PREFIX    -> OIX-INVC-PREFIX
                            OIZ-INVC-NUMBER    -> OIX-INVC-NUMBER
                            OIZ-LINE-NBR       -> OIX-LINE-NBR
                                                  OIX-SEQ