|
|
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: Invc Prefix Invoice or credit memo prefix must be
entered here for every invoice/credit
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.
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 Daily Shipment
Journal (OE129) the invoice number is
automatically assigned by the system.
OIZ-LINE-NBR Numeric 6 BL98.2
Element: Line Nbr 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,
non-stock, or special item.
OIZ-ITEM Alpha 32 BL98.2
Element: Item 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: Uom This 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, Billing Interface (BL520)
will price items that are inventoried or
non-stock. 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 Fl No 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 Cd This value indicates whether the line
item is tax exempt or not.
E = Exempt
T = Taxable
OIZ-ORD-DISC-FL Alpha 1 BL98.2
Element: Ord Disc Fl This flag determines whether the order
line is eligible for an allocated
discount.
OIZ-LOCATION Alpha 5 BL98.2
Element: Location This field contains a valid stock
location within the company inventory.
OIZ-SLS-ACCT-UNIT Alpha 15 BL98.2
Element: Acct Unit Sales 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: Sub Acct Sales subaccount to be credited or
debited for this line.
OIZ-OFF-ACCT-UNIT Alpha 15 BL98.2
Element: Acct Unit This 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: Sub Acct 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: Acct Unit The 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: Sub Acct 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: Acct Category In 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: Acct Category In 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 Nbr 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: Uom Indicates 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: Territory The 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 overridden online when
adding an invoice.
OIZ-SALESMAN Numeric 4 BL98.2
Element: Salesman The 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 overridden 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 overridden when placing the order
or entering the invoice.
OIZ-SALESMAN-2 Numeric 4 BL98.2
Element: Salesman The 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
Element: Comm Split The portion of the invoice line to
which the second sales representative's
commission percent is applied. The
first sales representative's commission
percent is applied to the remaining
amount. Defaults from the Customer
Master file.
OIZ-USER-FLD1 Alpha 2 BL98.2
Element: Po User Fld 2 This is the first user-defined field on
the invoice line. These user-defined
field values, if entered, and the line
is a create PO=Yes, will interface into
Purchase Order and appear on the
purchase order user-defined fields.
OIZ-USER-FLD2 Alpha 30 (Lower Case) BL98.2
Element: User Fld2 The second user-defined field on the
invoice line. These user-defined field
values, if entered and the line creates
a purchase order, will interface onto
Purchase Order and appear on the
purchase order-defined fields.
OIZ-USER-FLD3 Alpha 15 (Lower Case) BL98.2
Element: User Fld3 The 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
Purchase Order and appear on the
purchase 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
|
