|
|
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
AC115 BL520 BL96A
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIZ-COMPANY Numeric 4 AC115 BL96A
Company The company number represents an
established company and is entered on
all function codes.
OIZ-INVC-PREFIX Alpha 2 AC115 BL96A
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 AC115 BL96A
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 AC115 BL96A
Line Number This field displays the system-assigned
number of the invoice line.
OIZ-LINE-TYPE Alpha 1 AC115 BL96A
Line Type The line type indicates whether the
item on the line is an inventoried,
nonstock, or special item.
OIZ-ITEM Alpha 32 AC115 BL96A
Item Number This field contains the item
identifier.
OIZ-DESCRIPTION Alpha 30 (Lower Case) AC115 BL96A
Description The description of the item.
OIZ-QUANTITY Signed 13.4 AC115 BL96A
Quantity This field shows the quantity of the
item that is being billed on this
invoice line.
OIZ-SELL-UOM Alpha 4 AC115 BL96A
Sell Unit of Measure This field contains the stock unit of
measure for the item.
OIZ-ENTERED-PRICE Signed 13.5 AC115 BL96A
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 BL96A
Unit Cost This field contains the unit cost of
the invoice line.
OIZ-NO-CHARGE-FL Alpha 1 AC115 BL96A
No Charge Flag No charge flag indicating if the line
is intentionally supposed to be no
charge.
OIZ-ENTERED-DISC Signed 15.2 BL96A
Entered Disc This is the add-on discount that can be
entered when adding an invoice line.
OIZ-TAX-EXEMPT-CD Alpha 1 AC115 BL96A
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 BL96A
Order Discount Flag This flag determines whether the order
line is eligible for an allocated
discount.
OIZ-LOCATION Alpha 5 BL96A
Location Code This field contains a valid stock
location within the company inventory.
OIZ-SLS-ACCT-UNIT Alpha 15 AC115 BL96A
Sales Accounting Sales account unit to be credited or
Unit debited for this line.
OIZ-SLS-ACCOUNT Numeric 6 AC115 BL96A
Sales Account Sales account number to be credited or
debited for this line.
OIZ-SLS-SUB-ACCT Numeric 4 AC115 BL96A
Sales Subaccount Sales subaccount to be credited or
debited for this line.
OIZ-OFF-ACCT-UNIT Alpha 15 BL96A
Offset Accounting This cost of goods offset account unit
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 BL96A
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 BL96A
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 BL96A
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 BL96A
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 BL96A
Cost Of Goods Sold The cost of goods sold subaccount
Subaccount number is debited for nonstock or
special items on an invoice.
OIZ-ACTIVITY Alpha 15 AC115 BL96A
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 AC115 BL96A
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-TAX-CODE Alpha 10 AC115 BL96A
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-ACTIVITY-C Alpha 15
Activity for Cst of In this file the Activity-C field is
Goods Sold 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
Acct Categ (Cst of In this file the Acct-Categ-C field is
Goods Sold) 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.
OIINVCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIZSET1 COMPANY AC115 BL520
INVC-PREFIX BL96A
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
|