OEINVCMISC FILE
Invoice Miscellaneous Charges
This file stores the add-on charges that are related to a specific invoice or
invoice line.
REFERENCED BY
BL121 BL122 BL123 BL220 BL232 BL290
BL80.1 OE294 SA100
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL320 BL520 BL720 BL820
BL92.1 BL940 BL96D OE114 OE129 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE330 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIM-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix Invoice prefix is assigned from either BL20.1 BL20.3
the company or process level depending BL21.2 BL21.5
on the invoice level option chosen when BL29.1 BL29.2
setting up the company in the Billing BL520 BL820
system. BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number Invoice number assigned by the system. BL20.1 BL20.3
Invoice numbers are assigned at the BL21.2 BL21.5
company or process level, depending on BL29.1 BL29.2
the option chosen when setting up the BL520 BL820
company in the Billing system. BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-LINE-NBR Numeric 6 BL120 BL130
Line Number This indicates the line of the invoice BL20.1 BL20.3
the add-on charge is tied to if anything BL21.2 BL21.5
is entered here. If blank, the add-on BL29.1 BL29.2
charge was added at the invoice header BL520 BL820
level. BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-SEQ Numeric 3 BL120 BL130
Sequence Number The sequence number identifying the BL20.1 BL20.3
last add-on charge record tied to the BL21.2 BL21.5
invoice line or the invoice itself. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-MISC Alpha 16 BL120 BL130
Miscellaneous The add-on charge code used. Define BL20.1 BL20.3
add-on charges using BL09.1 (Add-on BL21.2 BL21.5
Charges). BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-TAX-EXEMPT-CD Alpha 1 BL120 BL130
Tax Exempt Code Indicates whether or not the add-on BL20.1 BL20.3
charge is to be included in tax BL21.2 BL21.5
calculations. If any one of the BL29.1 BL29.2
following are tax exempt, the exempt BL520 BL820
flag will default onto this field: BL92.1 BL940
customer ship-to, customer master, or BL96D OE114
add-on charge code. OE129 OE30.1
E = Tax exempt. OE30.2 OE30.3
T = Taxable. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-TAX-CODE Alpha 10 BL120 BL130
Tax Code A user-defined code representing the BL20.1 BL20.3
tax authorities this ship-to pays sales BL21.2 BL21.5
tax to. Must be a valid tax code set up BL29.1 BL29.2
on TX01.1 (Tax Code Master). BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ENT-TAXABLE Signed 15.2 BL120 BL130
Entered Taxable The taxable amount of the add-on charge BL20.1 BL20.3
in original currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-TAXABLE-BSE Signed 15.2 BL120 BL130
Taxable Bse Taxable amount of the add-on charge in BL20.1 BL20.3
company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-TAX-AMT-CURR Signed 15.2 BL120 BL130
Tax Amount Currency Tax amount for the add-on charge in BL20.1 BL20.3
billing currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-TAX-AMT-BSE Signed 15.2 BL120 BL130
Tax Amount Base Tax amount for the add-on charge in BL20.1 BL20.3
company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-CHARGE-TYPE Numeric 1 BL120 BL130
Charge Type Indicates whether the add-on charge is BL20.1 BL20.3
calculated via lump sum, unit price, or BL21.2 BL21.5
percentage. BL29.1 BL29.2
1 = Lump Sum BL520 BL820
2 = Unit Price BL92.1 BL940
3 = Percentage BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ENT-UNIT-PRC Signed 13.5 BL120 BL130
Ent Unit Prc Price of add-on charge in original BL20.1 BL20.3
currency. Defaults from the add-on BL21.2 BL21.5
charge set up on BL09.1 (Add-on BL29.1 BL29.2
Charges). BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-UNIT-PRICE Signed 13.5 BL120 BL130
Unit Price Unit price as defaulting from BL09.1 BL20.1 BL20.3
(Add-on Charges) in company base BL21.2 BL21.5
currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-PRICE-PCT Percent 5.3 (Percent) BL120 BL130
Price Pct Price percent. This is the percent BL20.1 BL20.3
applied to price to arrive at the add-on BL21.2 BL21.5
charge if the add-on charge type is BL29.1 BL29.2
defined as a percentage pricing charge BL520 BL820
on BL09.1 (Add-on Charges). BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ENT-PRICE Signed 15.2 BL120 BL130
Ent Price Optionally enter the price of the BL20.1 BL20.3
add-on charge in original billing BL21.2 BL21.5
currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-PRICE Signed 15.2 BL120 BL130
Price Price of the add-on charge as BL20.1 BL20.3
defaulting from BL09.1 (Add-on Charges) BL21.2 BL21.5
in company base currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-UNIT-COST Signed 13.5 BL120 BL130
Unit Cost The unit cost of the add-on charge in BL20.1 BL20.3
base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-COST-PCT Percent 5.3 (Percent) BL120 BL130
Cost Pct The cost percent. The percent to apply BL20.1 BL20.3
to the line or invoice extended net BL21.2 BL21.5
amount to arrive at the add-on charge BL29.1 BL29.2
cost. BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-COST Signed 11.2 BL120 BL130
Cost The flat monetary amount of cost of the BL20.1 BL20.3
add-on charge as it defaults from BL09.1 BL21.2 BL21.5
(Add-on Charges) in company base BL29.1 BL29.2
currency. BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ALLOC-DISC Signed 15.2 BL120 BL130
Allocation Discount Amount of the order discount or add-on BL20.1 BL20.3
discount allocated to this add-on BL21.2 BL21.5
charge. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-UPD-SA-FL Alpha 1 BL120 BL130
Upd Sa-Fl This field identifies whether or not BL20.1 BL20.3
the Sales Analysis system is to be BL21.2 BL21.5
updated. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ORD-DISC-FL Alpha 1 BL120 BL130
Order Discount Flag Order discount flag indicates whether BL20.1 BL20.3
the charge is eligible to be included BL21.2 BL21.5
when the system calculates the BL29.1 BL29.2
order-level discount. BL520 BL820
N = not discountable BL92.1 BL940
Y = discountable BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-SLS-ACCT-UNIT Alpha 15 BL120 BL130
Sales Accounting Sales account unit to be credited or BL20.1 BL20.3
Unit debited for this add-on charge. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-SLS-ACCOUNT Numeric 6 BL120 BL130
Sales Account Sales account number to be debited or BL20.1 BL20.3
credited for this add-on charge. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-SLS-SUB-ACCT Numeric 4 BL120 BL130
Sales Subaccount Sales subaccount number to be debited BL20.1 BL20.3
or credited for this add-on charge. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-OFF-ACCT-UNIT Alpha 15 BL120 BL130
Offset Accounting This cost of goods offset account unit BL20.1 BL20.3
Unit will be credited for nonstock and BL21.2 BL21.5
special items ordered that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96D OE114
process level for special items. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-OFF-ACCOUNT Numeric 6 BL120 BL130
Offset Account This cost of goods offset account BL20.1 BL20.3
number will be credited for nonstock and BL21.2 BL21.5
special items that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96D OE114
process level for special items with OE129 OE30.1
associated costs. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-OFF-SUB-ACCT Numeric 4 BL120 BL130
Offset Subaccount This cost of goods offset subaccount BL20.1 BL20.3
will be credited for nonstock and BL21.2 BL21.5
special items ordered that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96D OE114
process level for special items with OE129 OE30.1
associated costs. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-CGS-ACCT-UNIT Alpha 15 BL120 BL130
Cost Of Goods Sold The cost of goods sold account unit is BL20.1 BL20.3
Acct Unit debited for nonstock or special items. BL21.2 BL21.5
Defaults from the process level for BL29.1 BL29.2
special orders and defaults from the BL520 BL820
sales class for nonstock items. BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-CGS-ACCOUNT Numeric 6 BL120 BL130
Cost Of Goods Sold The cost of goods sold account number BL20.1 BL20.3
Account is debited for nonstock or special BL21.2 BL21.5
items. This account defaults from the BL29.1 BL29.2
process level for special orders and BL520 BL820
defaults from the sales class for BL92.1 BL940
nonstock items. BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-CGS-SUB-ACCT Numeric 4 BL120 BL130
Cost Of Goods Sold The cost of goods sold subaccount BL20.1 BL20.3
Subaccount number is debited for nonstock and BL21.2 BL21.5
special items. This will default from BL29.1 BL29.2
the process level for special orders and BL520 BL820
defaults from the sales class for BL92.1 BL940
nonstock items. BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-ACTIVITY Alpha 15 BL120 BL130
Activity In this file the Activity field is used BL20.1 BL20.3
for revenue (sales) postings whereas the BL21.2 BL21.5
Activity-C field is used for Cost (COGS) BL29.1 BL29.2
postings. BL520 BL820
BL92.1 BL940
Activities are the processes or BL96D OE114
procedures that produce work. Cost OE129 OE30.1
objects (products, services, customers, OE30.2 OE30.3
and so on) are the reasons for OE30.4 OE30.5
performing the activity. Activities and OE30.6 OE30.7
cost object activities are used OE30.9 OE830
synonymously in the Activity Management OE950
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.
OIM-ACCT-CATEGORY Alpha 5 BL120 BL130
Account Category In this file the Acct-Category field is BL20.1 BL20.3
used for revenue (sales) postings BL21.2 BL21.5
whereas the Acct-Categ-C field is used BL29.1 BL29.2
for Cost (COGS) postings. BL520 BL820
BL92.1 BL940
Account categories are groupings of BL96D OE114
costs, revenues, or a combination of OE129 OE30.1
both used for reporting and inquiries OE30.2 OE30.3
for activities in the Activity OE30.4 OE30.5
Management system. All transactions are OE30.6 OE30.7
posted to an account category within an OE30.9 OE830
activity. You can assign a specific OE950
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.
OIM-ATN-OBJ-ID Numeric 12 BL120 BL130
AC System Object ID Represents Activity Management system BL20.1 BL20.3
(Sales) ID for the revenue (sales) Activity. BL21.2 BL21.5
BL29.1 BL29.2
Activities are the processes or BL520 BL820
procedures that produce work. Cost BL92.1 BL940
objects (products, services, customers, BL96D OE114
and so on) are the reasons for OE129 OE30.1
performing the activity. Activities and OE30.2 OE30.3
cost object activities are used OE30.4 OE30.5
synonymously in the Activity Management OE30.6 OE30.7
system. Direct costs are posted to OE30.9 OE830
activities, and indirect costs are OE950
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.
OIM-INVC-PCT-AMT Derived
Invc Pct Amt Amount billed to the customer if the
add-on charge is tied to the invoice
header and is a percentage type. In
company base currency.
OIM-LINE-PCT-AMT Derived
Line Pct Amt Amount billed to the customer if the
add-on charge is tied to the invoice
line and is a percentage type. In
company base currency.
OIM-UNIT-AMOUNT Derived
Unit Amount Amount to be charged per unit of the
item ordered at the line level. The
add-on charge amount will be the sum
total of the charges per unit.
OIM-CHARGE-AMT Derived
Charge Amt Final calculated amount of the add-on
charge.
OIM-CHARGE-CURR Signed 15.2 BL120 BL130
Charge Curr Final calculated amount of the add-on BL20.1 BL20.3
charge in billing currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-CHARGE-BASE Signed 15.2 BL120 BL130
Charge Base Final calculated amount of the add-on BL20.1 BL20.3
charge in company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96D OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIM-COST-BASE Signed 15.2 BL96D
Cost Base Final calculated cost amount of the
add-on charge in company base currency.
OIM-PER-UNIT-FL Derived
Per Unit Fl This field contains the per unit charge
type.
OIM-INVC-PCT-COST Derived
Invc Pct Cost This field contains the cost if the
charge type is a percentage.
OIM-LINE-PCT-COST Derived
Line Pct Cost This field contains the percentage that
is attached to the line.
OIM-LINE-UNIT-COST Derived
Line Unit Cost This field contains the per unit cost.
OIM-LINE-COST-AMT Derived
Line Cost Amt This field determines which cost to
display.
OIM-ACTIVITY-C Alpha 15 BL120 BL130
Activity for Cst of In this file the Activity-C field is BL20.1 BL20.3
Goods Sold used for Cost (COGS) postings whereas BL21.2 BL21.5
the Activity field is used for revenue BL29.1 BL29.2
(sales) postings. BL520 BL820
BL92.1 BL940
Activities are the processes or OE114 OE129
procedures that produce work. Cost OE30.1 OE30.2
objects (products, services, customers, OE30.3 OE30.4
and so on) are the reasons for OE30.5 OE30.6
performing the activity. Activities and OE30.7 OE30.9
cost object activities are used OE830 OE950
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.
OIM-ACCT-CATEG-C Alpha 5 BL120 BL130
Acct Categ (Cst of In this file the Acct-Categ-C field is BL20.1 BL20.3
Goods Sold) used for Cost (COGS) postings whereas BL21.2 BL21.5
the Acct-Category field is used for BL29.1 BL29.2
revenue (sales) postings. BL520 BL820
BL92.1 BL940
Account categories are groupings of OE114 OE129
costs, revenues, or a combination of OE30.1 OE30.2
both used for reporting and inquiries OE30.3 OE30.4
for activities in the Activity OE30.5 OE30.6
Management system. All transactions are OE30.7 OE30.9
posted to an account category within an OE830 OE950
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.
OIM-ATN-OBJ-ID-C Numeric 12 BL120 BL130
AC System Object ID The system defined object id BL20.1 BL20.3
(Cost) representing the Activity Management BL21.2 BL21.5
commitment for Cost (COGS). BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIM-PROD-TAX-CAT Alpha 15 BL120 BL130
Product Tax Category A classification of items for BL20.1 BL20.3
determining taxes using the VERTEX BL21.2 BL21.5
system in Lawson Order Entry system or BL29.1 BL29.2
the cash receipts programs in the Lawson BL520 BL720
Cash Ledger system. BL820 BL92.1
BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEINVCMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIMSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL123
INVC-NUMBER BL130 BL20.1
LINE-NBR BL20.3 BL21.2
SEQ BL21.5 BL220
BL232 BL29.1
BL29.2 BL290
BL320 BL520
BL720 BL80.1
BL820 BL92.1
BL940 BL96D
OE114 OE129
OE294 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
OIMSET2 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
OIMSET3 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
OIMSET4 COMPANY KeyChange BL120 BL122
INVC-PREFIX BL130 BL20.1
INVC-NUMBER BL20.3 BL21.2
TAX-CODE BL21.5 BL29.1
PROD-TAX-CAT BL29.2 BL520
LINE-NBR BL820 BL92.1
SEQ BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEINVCMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blricmisc BLRICMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BUM-COMPANY
OEI-RECUR-INVOICE -> BUM-RECUR-INVOICE
OEI-CUSTOMER -> BUM-CUSTOMER
OIM-LINE-NBR -> BUM-LINE-NBR
OIM-SEQ -> BUM-SEQ
Blricust BLRICUST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRC-COMPANY
OEI-RECUR-INVOICE -> BRC-RECUR-INVOICE
OEI-CUSTOMER -> BRC-CUSTOMER
Blrimast BLRIMAST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Blrimmisc BLRIMMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BMM-COMPANY
OEI-RECUR-INVOICE -> BMM-RECUR-INVOICE
BUM-MAST-LINE-NBR -> BMM-LINE-NBR
BUM-MAST-SEQ -> BMM-SEQ
Cogs Account GLMASTER Required
When OIM-CGS-ACCT-UNIT != Spaces
Or OIM-CGS-ACCOUNT != Zeroes
Or OIM-CGS-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-CGS-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-CGS-ACCOUNT -> GLM-ACCOUNT
OIM-CGS-SUB-ACCT -> GLM-SUB-ACCOUNT
Oecompany OECOMPANY Required
OIM-COMPANY -> OEC-COMPANY
Oecsmisc BLRICMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BUM-COMPANY
OEI-RECUR-INVOICE -> BUM-RECUR-INVOICE
OEI-CUSTOMER -> BUM-CUSTOMER
OIM-LINE-NBR -> BUM-LINE-NBR
OIM-SEQ -> BUM-SEQ
Oecustsrvc BLRICUST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRC-COMPANY
OEI-RECUR-INVOICE -> BRC-RECUR-INVOICE
OEI-CUSTOMER -> BRC-CUSTOMER
Oeinvcline OEINVCLINE Required
When OIM-LINE-NBR != Zeroes
OIM-COMPANY -> OIL-COMPANY
OIM-INVC-PREFIX -> OIL-INVC-PREFIX
OIM-INVC-NUMBER -> OIL-INVC-NUMBER
OIM-LINE-NBR -> OIL-LINE-NBR
Oeinvoice OEINVOICE Required
OIM-COMPANY -> OEI-COMPANY
OIM-INVC-PREFIX -> OEI-INVC-PREFIX
OIM-INVC-NUMBER -> OEI-INVC-NUMBER
Oeinvsgblk OEINVSGBLK Not Required
OIM-COMPANY -> OSB-COMPANY
OIM-INVC-PREFIX -> OSB-INVC-PREFIX
OIM-INVC-NUMBER -> OSB-INVC-NUMBER
OIM-LINE-NBR -> OSB-LINE-NBR
OIM-SEQ -> OSB-SEQ
Oemastsrvc BLRIMAST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemisc OEMISC Required
OIM-COMPANY -> OEM-COMPANY
OIM-MISC -> OEM-MISC
OEI-CURRENCY-CODE -> OEM-CURRENCY-CODE
Oemsmisc BLRIMMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BMM-COMPANY
OEI-RECUR-INVOICE -> BMM-RECUR-INVOICE
BUM-MAST-LINE-NBR -> BMM-LINE-NBR
OIM-SEQ -> BMM-SEQ
Offset Account GLMASTER Required
When OIM-OFF-ACCT-UNIT != Spaces
Or OIM-OFF-ACCOUNT != Zeroes
Or OIM-OFF-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-OFF-ACCOUNT -> GLM-ACCOUNT
OIM-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Sales Account GLMASTER Required
When OIM-SLS-ACCT-UNIT != Spaces
Or OIM-SLS-ACCOUNT != Zeroes
Or OIM-SLS-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-SLS-ACCOUNT -> GLM-ACCOUNT
OIM-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
OEINVCMISC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oedist OEDIST
Valid When OIM-STATUS = 9
OIM-COMPANY -> ODI-COMPANY
OIM-INVC-PREFIX -> ODI-INVC-PREFIX
OIM-INVC-NUMBER -> ODI-INVC-NUMBER
Zeroes -> ODI-AUTH-NO
OIM-LINE-NBR -> ODI-LINE-NBR
ODI-ACCT-UNIT
ODI-ACCOUNT
ODI-SUB-ACCOUNT
ODI-SEQ
ODI-POSTING-TYPE
Oeinvctax OEINVCTAX Required
OIM-COMPANY -> OIT-COMPANY
OIM-INVC-PREFIX -> OIT-INVC-PREFIX
OIM-INVC-NUMBER -> OIT-INVC-NUMBER
OIM-LINE-NBR -> OIT-LINE-NBR
OIM-SEQ -> OIT-SEQ
OIT-TAX-CODE
|