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
TX101
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 BL820
BL92.1 WH20.7
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
WH20.7
OIM-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix Invoice 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
WH20.7
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
WH20.7
OIM-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr 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
WH20.7
OIM-SEQ Numeric 3 BL120 BL122
Element: Seq The 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
WH20.7
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
WH20.7
OIM-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt Cd Indicates 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 WH20.7
add-on charge code.
E = Tax exempt.
T = Taxable.
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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 WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OIM-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Ord Disc Fl Order 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 WH20.7
OIM-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit Sales 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
WH20.7
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
WH20.7
OIM-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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
WH20.7
OIM-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This 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 WH20.7
process level for special items.
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 WH20.7
process level for special items with
associated costs.
OIM-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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 WH20.7
process level for special items with
associated costs.
OIM-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit The 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
WH20.7
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. WH20.7
OIM-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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. WH20.7
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 WH20.7
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.
OIM-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Acct Category In 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 WH20.7
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.
OIM-ATN-OBJ-ID Numeric 12 BL120 BL122
Element: Obj Id Represents Activity Management system BL130 BL20.1
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, WH20.7
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.
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 WH20.7
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.
OIM-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Acct Category In 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 WH20.7
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.
OIM-ATN-OBJ-ID-C Numeric 12 BL120 BL122
Element: Obj Id The system defined object id BL130 BL20.1
representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OIM-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Prod Tax Cat A 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
WH20.7
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.4 BL20.5
BL21.2 BL21.5
BL220 BL232
BL29.1 BL29.2
BL290 BL320
BL520 BL80.1
BL820 BL92.1
TX101 WH20.7
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 WH20.7
OIMSET5 COMPANY BL120 BL122
INVC-PREFIX BL130 BL20.1
INVC-NUMBER BL20.3 BL21.2
SEQ BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
WH20.7
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
|