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
BL98.1 BL98.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIZ-COMPANY Numeric 4 BL98.2
Company The company number represents an
established company and is entered on
all function codes.
OIZ-INVC-PREFIX Alpha 2 BL98.2
Invoice Prefix Invoice 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
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
Line Number This field displays the system-assigned
number of the invoice line.
OIZ-LINE-TYPE Alpha 1 BL98.2
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
Item Number This field contains the item
identifier.
OIZ-DESCRIPTION Alpha 30 (Lower Case) BL98.2
Description The description of the item.
OIZ-QUANTITY Signed 13.4 BL98.2
Quantity This field shows the quantity of the
item that is being billed on this
invoice line.
OIZ-SELL-UOM Alpha 4 BL98.2
Sell Unit of Measure This field contains the stock unit of
measure for the item.
OIZ-ENTERED-PRICE Signed 13.5 BL98.2
Entered Price 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 13.5 BL98.2
Unit Cost This field contains the unit cost of
the invoice line.
OIZ-NO-CHARGE-FL Alpha 1 BL98.2
No Charge Flag No charge flag indicating if the line
is intentionally supposed to be no
charge.
OIZ-ENTERED-DISC Signed 15.2 BL98.2
Entered Disc This is the add-on discount that can be
entered when adding an invoice line.
OIZ-TAX-EXEMPT-CD Alpha 1 BL98.2
Tax Exempt Code This value indicates whether the line
item is tax exempt or not.
E = Exempt
T = Taxable
OIZ-ORD-DISC-FL Alpha 1 BL98.2
Order Discount Flag This flag determines whether the order
line is eligible for an allocated
discount.
OIZ-LOCATION Alpha 5 BL98.2
Location Code This field contains a valid stock
location within the company inventory.
OIZ-SLS-ACCT-UNIT Alpha 15 BL98.2
Sales Accounting Sales account unit to be credited or
Unit debited for this line.
OIZ-SLS-ACCOUNT Numeric 6 BL98.2
Sales Account Sales account number to be credited or
debited for this line.
OIZ-SLS-SUB-ACCT Numeric 4 BL98.2
Sales Subaccount Sales subaccount to be credited or
debited for this line.
OIZ-OFF-ACCT-UNIT Alpha 15 BL98.2
Offset Account 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
Offset 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
Offset 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
Cost Of Goods Sold The cost of goods sold account unit is
Acct Unit debited for nonstock or special items on
an invoice.
OIZ-CGS-ACCOUNT Numeric 6 BL98.2
Cost Of Goods Sold The cost of goods sold account number
Account is debited for nonstock or special items
on an invoice.
OIZ-CGS-SUB-ACCT Numeric 4 BL98.2
Cost Of Goods Sold The cost of goods sold subaccount
Sub Account number is debited for nonstock or
special items on an invoice.
OIZ-ACTIVITY Alpha 15 BL98.2
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
Account 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
Activity C 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
Acct Categ C 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
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
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
Selling Price Unit Indicates the selling price unit of
of Measure measure with which this line has been
priced.
OIZ-ADD-ON-DISC Signed 15.2 BL98.2
Add On Discount This is the add-on discount in the
company base currency.
OIZ-TERRITORY Alpha 4 BL98.2
Sales 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 overidden online when
adding an invoice.
OIZ-SALESMAN Numeric 4 BL98.2
Salesman Number 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 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
Salesman Number 2 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
Commission Rate for Commission rate for sales representative
Slsmn 1 1. Defaults from the sales
representative record.
OIZ-COMM-RATE-2 Percent 7.5 (Percent) BL98.2
Commission Rate for Commission rate for sales representative
Slsmn 2 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
User Defined Field 1 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
the Purchase Order system and appear on
the purchase order user-defined fields.
OIZ-USER-FLD2 Alpha 30 (Lower Case) BL98.2
User Defined Field 2 The 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
User Defined Field 3 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
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
Oil Usr Fld 01 Interface invoice line user field 1.
OIZ-OIL-USR-FLD-02 Alpha 20
Oil Usr Fld 02 Interface invoice line user field 2.
OIZ-OIL-USR-FLD-03 Alpha 20
Oil Usr Fld 03 Interface invoice line user field 3.
OIZ-OIL-USR-FLD-04 Alpha 20
Oil Usr Fld 04 Interface invoice line user field 4.
OIZ-OIL-USR-FLD-05 Alpha 20
Oil Usr Fld 05 Interface invoice line user field 5.
OIINVCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIZSET1 COMPANY BL98.1 BL98.2
INVC-PREFIX
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
|
