OIINVCMISC FILE
Interface Invoice AOC
This is an invoice add-on charge batch interface file that can be used (in
conjunction with the Invoice Interface file) to interface add-on charges tied
to invoices and invoice lines 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
OIX-COMPANY Numeric 4 BL98.1 BL98.2
Company The company number represents an
established company and is entered on
all function codes.
OIX-INVC-PREFIX Alpha 2 BL98.1 BL98.2
Invoice Prefix Invoice or credit memo prefix must be
entered here for every invoice or credit
memo interfaced into the Billing system.
If this were an invoice created online
or by running 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.
OIX-INVC-NUMBER Numeric 8 BL98.1 BL98.2
Invc Number Invoice/credit memo number must be
unique within your company and must be
entered on this field for every add-on
charge record interfaced into the
system. This value indicates what
invoice or credit memo the add-on charge
is attached to.
OIX-LINE-NBR Numeric 6 BL98.1 BL98.2
Line Number Displays the system-assigned number of
the line on the invoice to which the
add-on charge is attached if it is a
line add-on charge.
OIX-SEQ Numeric 3 BL98.1 BL98.2
Sequence Number This sequence number identifies the
number of the add-on charge this record
is among the rest of the add-on charges
attached to the invoice line or invoice.
OIX-MISC Alpha 16 BL98.1 BL98.2
Misc Enter the add-on charge code (set up on
BL09.1 (Add-on Charge)) that identifies
which add-on charge this record will be.
OIX-TAX-EXEMPT-CD Alpha 1 BL98.1 BL98.2
Tax Exempt Code This value indicates whether the add-on
charge is tax exempt or not.
E = Exempt
T = Taxable
OIX-ENT-PRICE Signed 15.2 BL98.1 BL98.2
Ent Price This is the price of the add-on charge.
If left blank, BL520 (Billing Interface)
will price the add-on charge based on
the parameters tied to the add-on charge
on BL09.1 (Add-on Charge).
OIX-PRICE-PCT Percent 5.3 (Percent) BL98.1 BL98.2
Price Pct Price percent. This is the percent
applied to price to arrive at the add-on
charge.
OIX-COST Signed 11.2 BL98.1 BL98.2
Cost Cost of the add-on charge as it is
entered on this field or defaulted onto
this field when the add-on charge record
is interfaced into the Billing system.
OIX-COST-PCT Percent 5.3 (Percent) BL98.1 BL98.2
Cost Pct The cost percent. The percent to apply
to the unit cost of the item to arrive
at the add-on charge cost.
OIX-ORD-DISC-FL Alpha 1 BL98.1 BL98.2
Order Discount Flag Flag indicating whether or not the
add-on charge is to be included in tax
calculations. If any one of the
following are tax exempt, the exempt
flag will default onto this field:
Customer Ship to, Customer Master, or
Add-on Charge Code (set up on BL09.1).
OIX-ACTIVITY Alpha 15 BL98.1 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.
OIX-ACCT-CATEGORY Alpha 5 BL98.1 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.
OIX-ACTIVITY-C Alpha 15 BL98.1 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.
OIX-ACCT-CATEG-C Alpha 5 BL98.1 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.
OIX-ENT-UNIT-PRC Signed 13.5 BL98.1 BL98.2
Ent Unit Prc Price of add-on charge in orginal
currency. Defaults from the add-on
charge set up on BL09.1 (Add-on Charges)
OIX-UNIT-COST Signed 13.5 BL98.1 BL98.2
Unit Cost The unit cost of the add-on charges in
base currency.
OIINVCMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIXSET1 COMPANY BL98.1 BL98.2
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SEQ
|
