Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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