Lawson Insight Technical Documentation |
|
OEINVCMISC
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 BL123 BL220 BL232 BL290 BL80.1
OE294 SA100 TX101
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 BL820
BL92.1 OE114 OE129 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE330 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIM-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invoice PrefixInvoice prefix is assigned from either BL130 BL20.1
the company or process level depending BL20.3 BL21.2
on the invoice level option chosen when BL21.5 BL29.1
setting up the company in the Billing BL29.2 BL520
system. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-INVC-NUMBER Numeric 8 BL120 BL122
Element: Invc Number Invoice number assigned by the system. BL130 BL20.1
Invoice numbers are assigned at the BL20.3 BL21.2
company or process level, depending on BL21.5 BL29.1
the option chosen when setting up the BL29.2 BL520
company in the Billing system. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number This indicates the line of the invoice BL130 BL20.1
the add-on charge is tied to if anything BL20.3 BL21.2
is entered here. If blank, the add-on BL21.5 BL29.1
charge was added at the invoice header BL29.2 BL520
level. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThe sequence number identifying the BL130 BL20.1
last add-on charge record tied to the BL20.3 BL21.2
invoice line or the invoice itself. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-MISC Alpha 16 BL120 BL122
Element: Misc The add-on charge code used. Define BL130 BL20.1
add-on charges using BL09.1 (Add-on BL20.3 BL21.2
Charges). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt CodIndicates whether or not the add-on BL130 BL20.1
charge is to be included in tax BL20.3 BL21.2
calculations. If any one of the BL21.5 BL29.1
following are tax exempt, the exempt BL29.2 BL520
flag will default onto this field: BL820 BL92.1
customer ship-to, customer master, or OE114 OE129
add-on charge code. OE30.1 OE30.2
E = Tax exempt. OE30.3 OE30.4
T = Taxable. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code A user-defined code representing the BL130 BL20.1
tax authorities this ship-to pays sales BL20.3 BL21.2
tax to. Must be a valid tax code set up BL21.5 BL29.1
on TX01.1 (Tax Code Master). BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ENT-TAXABLE Signed 18.2 BL120 BL122
Element: Intl Amt The taxable amount of the add-on charge BL130 BL20.1
in original currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-TAXABLE-BSE Signed 18.2 BL120 BL122
Element: Intl Amt Taxable amount of the add-on charge in BL130 BL20.1
company base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-TAX-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt Tax amount for the add-on charge in BL130 BL20.1
billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-TAX-AMT-BSE Signed 18.2 BL120 BL122
Element: Intl Amt Tax amount for the add-on charge in BL130 BL20.1
company base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-CHARGE-TYPE Numeric 1 BL120 BL122
Element: Charge Type Indicates whether the add-on charge is BL130 BL20.1
calculated via lump sum, unit price, or BL20.3 BL21.2
percentage. BL21.5 BL29.1
1 = Lump Sum BL29.2 BL520
2 = Unit Price BL820 BL92.1
3 = Percentage OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ENT-UNIT-PRC Signed 18.5 BL120 BL122
Element: Intl Cost Price of add-on charge in original BL130 BL20.1
currency. Defaults from the add-on BL20.3 BL21.2
charge set up on BL09.1 (Add-on BL21.5 BL29.1
Charges). BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-UNIT-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost Unit price as defaulting from BL09.1 BL130 BL20.1
(Add-on Charges) in company base BL20.3 BL21.2
currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-PRICE-PCT Percent 5.3 (Percent) BL120 BL122
Element: Cost Pct Price percent. This is the percent BL130 BL20.1
applied to price to arrive at the add-on BL20.3 BL21.2
charge if the add-on charge type is BL21.5 BL29.1
defined as a percentage pricing charge BL29.2 BL520
on BL09.1 (Add-on Charges). BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ENT-PRICE Signed 18.2 BL120 BL122
Element: Intl Amt Optionally enter the price of the BL130 BL20.1
add-on charge in original billing BL20.3 BL21.2
currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-PRICE Signed 18.2 BL120 BL122
Element: Intl Amt Price of the add-on charge as BL130 BL20.1
defaulting from BL09.1 (Add-on Charges) BL20.3 BL21.2
in company base currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-UNIT-COST Signed 18.5 BL120 BL122
Element: Intl Cost The unit cost of the add-on charge in BL130 BL20.1
base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-COST-PCT Percent 5.3 (Percent) BL120 BL122
Element: Cost Pct The cost percent. The percent to apply BL130 BL20.1
to the line or invoice extended net BL20.3 BL21.2
amount to arrive at the add-on charge BL21.5 BL29.1
cost. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-COST Signed 18.5 BL120 BL122
Element: Intl Cost The flat monetary amount of cost of the BL130 BL20.1
add-on charge as it defaults from BL09.1 BL20.3 BL21.2
(Add-on Charges) in company base BL21.5 BL29.1
currency. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ALLOC-DISC Signed 18.2 BL120 BL122
Element: Intl Amt Amount of the order discount or add-on BL130 BL20.1
discount allocated to this add-on BL20.3 BL21.2
charge. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-UPD-SA-FL Alpha 1 BL120 BL122
Element: All Flag This field identifies whether or not BL130 BL20.1
the Sales Analysis system is to be BL20.3 BL21.2
updated. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Order DiscountOrder discount flag indicates whether BL130 BL20.1
the charge is eligible to be included BL20.3 BL21.2
when the system calculates the BL21.5 BL29.1
order-level discount. BL29.2 BL520
N = not discountable BL820 BL92.1
Y = discountable OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniSales account unit to be credited or BL130 BL20.1
debited for this add-on charge. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-SLS-ACCOUNT Numeric 6 BL120 BL122
Element: Account Sales account number to be debited or BL130 BL20.1
credited for this add-on charge. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount Sales subaccount number to be debited BL130 BL20.1
or credited for this add-on charge. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis cost of goods offset account unit BL130 BL20.1
will be credited for nonstock and BL20.3 BL21.2
special items ordered that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
nonstock items and will default from the OE114 OE129
process level for special items. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-OFF-ACCOUNT Numeric 6 BL120 BL122
Element: Account This cost of goods offset account BL130 BL20.1
number will be credited for nonstock and BL20.3 BL21.2
special items that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
nonstock items and will default from the OE114 OE129
process level for special items with OE30.1 OE30.2
associated costs. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This cost of goods offset subaccount BL130 BL20.1
will be credited for nonstock and BL20.3 BL21.2
special items ordered that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
nonstock items and will default from the OE114 OE129
process level for special items with OE30.1 OE30.2
associated costs. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThe cost of goods sold account unit is BL130 BL20.1
debited for nonstock or special items. BL20.3 BL21.2
Defaults from the process level for BL21.5 BL29.1
special orders and defaults from the BL29.2 BL520
sales class for nonstock items. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account The cost of goods sold account number BL130 BL20.1
is debited for nonstock or special BL20.3 BL21.2
items. This account defaults from the BL21.5 BL29.1
process level for special orders and BL29.2 BL520
defaults from the sales class for BL820 BL92.1
nonstock items. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount The cost of goods sold subaccount BL130 BL20.1
number is debited for nonstock and BL20.3 BL21.2
special items. This will default from BL21.5 BL29.1
the process level for special orders and BL29.2 BL520
defaults from the sales class for BL820 BL92.1
nonstock items. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for revenue (sales) postings whereas the BL20.3 BL21.2
Activity-C field is used for Cost (COGS) BL21.5 BL29.1
postings. BL29.2 BL520
BL820 BL92.1
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 OE530 OE830
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-CATEGORY Alpha 5 BL120 BL122
Element: Account CategoIn this file the Acct-Category field is BL130 BL20.1
used for revenue (sales) postings BL20.3 BL21.2
whereas the Acct-Categ-C field is used BL21.5 BL29.1
for Cost (COGS) postings. BL29.2 BL520
BL820 BL92.1
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 OE530 OE830
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 Numeric 12 BL120 BL122
Object Represents Activity Management system BL130 BL20.1
Identification ID for the revenue (sales) Activity. BL20.3 BL21.2
BL21.5 BL29.1
Activities are the processes or BL29.2 BL520
procedures that produce work. Cost BL820 BL92.1
objects (products, services, customers, OE114 OE129
and so on) are the reasons for OE30.1 OE30.2
performing the activity. Activities and OE30.3 OE30.4
cost object activities are used OE30.5 OE30.6
synonymously in the Activity Management OE30.7 OE30.9
system. Direct costs are posted to OE530 OE830
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-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Activity field is used for revenue BL21.5 BL29.1
(sales) postings. BL29.2 BL520
BL820 BL92.1
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 OE530 OE830
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 BL122
Element: Account CategoIn this file the Acct-Categ-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Acct-Category field is used for BL21.5 BL29.1
revenue (sales) postings. BL29.2 BL520
BL820 BL92.1
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 OE530 OE830
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 BL122
Object The system defined object id BL130 BL20.1
Identification representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-INVC-PCT-AMT Derived
Element: 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
Element: 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
Element: 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
Element: Charge Amt Final calculated amount of the add-on
charge.
OIM-CHARGE-CURR Signed 18.2 BL120 BL122
Element: Intl Amt Final calculated amount of the add-on BL130 BL20.1
charge in billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-CHARGE-BASE Signed 18.2 BL120 BL122
Element: Intl Amt Final calculated amount of the add-on BL130 BL20.1
charge in company base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-COST-BASE Signed 18.2 BL120 BL122
Element: Intl Amt Final calculated cost amount of the BL130 BL20.1
add-on charge in company base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Product Tax CaA classification of items for BL130 BL20.1
determining taxes using the VERTEX BL20.3 BL21.2
system in Lawson Order Entry system or BL21.5 BL29.1
the cash receipts programs in the Lawson BL29.2 BL520
Cash Ledger system. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIM-PER-UNIT-FL Derived
Element: Per Unit Fl This field contains the per unit charge
type.
OIM-INVC-PCT-COST Derived
Element: Invc Pct Cost This field contains the cost if the
charge type is a percentage.
OIM-LINE-PCT-COST Derived
Element: Line Pct Cost This field contains the percentage that
is attached to the line.
OIM-LINE-UNIT-COST Derived
Element: Line Unit CostThis field contains the per unit cost.
OIM-LINE-COST-AMT Derived
Element: Line Cost Amt This field determines which cost to
display.
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.2 BL20.3
SEQ BL20.5 BL21.2
BL21.5 BL220
BL232 BL29.1
BL29.2 BL290
BL320 BL520
BL80.1 BL820
BL92.1 OE114
OE129 OE294
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
...
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 OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIMSET5 COMPANY this index was created as a solution to BL120 BL122
INVC-PREFIX the Find Next/Prev Flag error. It is BL130 BL20.1
INVC-NUMBER only used where a modify must be done BL20.3 BL21.2
SEQ within a 850-FIND-NLT or 850-FIND-BEGRNG BL21.5 BL29.1
LINE-NBR loop. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEINVCMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blricmisc BLRICMISC Not Required
Valid When OEI-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 OEI-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRC-COMPANY
OEI-RECUR-INVOICE -> BRC-RECUR-INVOICE
OEI-CUSTOMER -> BRC-CUSTOMER
Blrimast BLRIMAST Not Required
Valid When OEI-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Blrimmisc BLRIMMISC Not Required
Valid When OEI-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 OEI-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 OEI-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 OEI-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 OEI-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 OEI-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
OIT-TAX-LEVEL
|