|
|
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
BL520 BL98.1 BL98.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIX-COMPANY Numeric 4 BL98.1 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.
OIX-INVC-PREFIX Alpha 2 BL98.1 BL98.2
Element: Invc 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
Element: 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
Element: Line Nbr 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
Element: Seq 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
Element: Misc Enter the add-on charge code (set up on
Add-on Charge (BL09.1)) that identifies
which add-on charge this record will be.
OIX-TAX-EXEMPT-CD Alpha 1 BL98.1 BL98.2
Element: Tax Exempt Cd This value indicates whether the add-on
charge is tax exempt or not.
E = Exempt
T = Taxable
OIX-ENT-PRICE Signed 18.2 BL98.1 BL98.2
Element: Intl Amt This is the price of the add-on charge.
If left blank, Billing Interface (BL520)
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
Element: Cost Pct Price percent. This is the percent
applied to price to arrive at the add-on
charge.
OIX-COST Signed 18.5 BL98.1 BL98.2
Element: Intl 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 Billing.
OIX-COST-PCT Percent 5.3 (Percent) BL98.1 BL98.2
Element: 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
Element: Ord Disc Fl 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 (setup on BL09.1).
OIX-ACTIVITY Alpha 15 BL98.1 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 Project Accounting.
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
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 Project Accounting.
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 Account Assignment
(AC07.1).
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
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 Project Accounting.
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
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 Project Accounting.
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 Account Assignment
(AC07.1).
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 18.5 BL98.1 BL98.2
Element: Intl Cost Price of add-on charge in original
currency. Defaults from the add-on
charge set up on Add-on Charges
(BL09.1).
OIX-UNIT-COST Signed 18.5 BL98.1 BL98.2
Element: Intl 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 BL520 BL98.1
INVC-PREFIX BL98.2
INVC-NUMBER
LINE-NBR
SEQ
|
