Order Entry GL Distribution

This file stores all the records that will create the journal entries created when the orders are finally invoiced.
UPDATED BY

TX101

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ODI-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
ODI-GLT-OBJ-ID Element: Obj Id	Numeric 12 This is a subsystem General Ledger interface identification number. It is used for Drill Around purposes.
ODI-ATN-OBJ-ID Element: Obj Id	Numeric 12 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in 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.
ODI-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.
ODI-GL-DATE Element: Gl Date	Numeric 8 (yyyymmdd) The general ledger posting date for this particular journal entry.
ODI-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the accounting unit that will be debited or credited in general ledger when this journal entry distribution is interfaced into the General Ledger system.
ODI-ACCOUNT Element: Account	Numeric 6 This field indicates the general ledger account number that will be debited or credited when this journal entry distribution is interfaced into the General Ledger system.
ODI-SUB-ACCOUNT Element: Sub Acct	Numeric 4 This is the general ledger subaccount number that will be debited or credited when this journal entry distribution is interfaced into the General Ledger system.
ODI-INVC-PREFIX Element: Invc Prefix	Alpha 2 This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
ODI-INVC-NUMBER Element: Invc Number	Numeric 8 Invoice number associated with this journal entry distribution. Invoice numbers are assigned at the company or process level, depending on an invoice level option on the company file.
ODI-AUTH-NO Element: Auth No	Numeric 10 This is the returns authorization number associated with a distribution record that was created in relation to a return to stock credit memo added to the Order Entry system using the returns feature.
ODI-LINE-NBR Element: Line Nbr	Numeric 6 Identifies the line number on the invoice this distribution journal entry is associated with.
ODI-SEQ Element: Seq	Numeric 3 If this distribution record pertains to an add-on charge that was attached to a line on an invoice, this sequence number identifies which add-on charge tied to the line this is.
ODI-POSTING-TYPE Element: Posting Type	Alpha 2 This field indicates what type of account this distribution journal entry is debiting or crediting. AD = Add-on Discount (Db) AS = A/R Add-on Discount (Cr) CR = Cash In Advance (Cr) CA = Cash In Advance (Db) CI = Cost To Inventory (Cr) CC = Cost Of Goods Sold (Db) CV = Cost Variance (Db,Cr) D1 = Line Discount (Db) D2 = Line Discount (Db) D3 = Line Discount (Db) D4 = Line Discount (Cr) D5 = Line Discount (Cr) D6 = Line Discount (Cr) FF = Freight (Db) FA = Freight (Cr) MS = Miscellaneous Sales (Cr) MO = Miscellaneous Offset (Db) MC = Miscellaneous Cost (Db) MR = Miscellaneous A/R (Db) OD = Order Discount (Db) OS = Order Discount (Cr) PS = Product Sales (Cr) PA = Product A/R (Db) S1 = Line Sales Tax (Db) S2 = Line Sales Tax (Db) S3 = Line Sales Tax (Db) S4 = Line Sales Tax (Cr) S5 = Line Sales Tax (Db) S6 = Line Sales Tax (Cr) M1 = Miscellaneous Sales Tax (Db) M2 = Miscellaneous Sales Tax (Db) M3 = Miscellaneous Sales TAx (Db) M4 = Miscellaneous Sales Tax (Cr) M5 = Miscellaneous Sales Tax (Cr) M6 = Miscellaneous Sales Tax (Cr) AR = Accounts Receivable FR = Freight TX = Vertex Tax CP = Credit card payment
ODI-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.
ODI-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in 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.
ODI-ACCT-CATEGORY Element: Acct Category	Alpha 5 Account categories are groupings of 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.
ODI-AMOUNT-BASE Element: Intl Amt	Signed 18.2 Amount of distribution journal entry in company base currency.
ODI-AMOUNT-CURR Element: Intl Amt	Signed 18.2 Amount of distribution journal entry in original billing currency.
ODI-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company's base currency code established in the General Ledger system.
ODI-CURR-RATE Element: Curr Rate	Signed 14.7 The currency rate used to convert this distribution amount from original billing currency to company base currency.

OEDIST FILE INDEX

OEDIST FILE RELATIONS

ONE TO ONE RELATIONS

OEDIST FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.