|
|
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
|
