|
OEDIST FILE
Order Entry GL Distribution
This file stores all the records that will create the journal entries created
when the orders are finally invoiced.
REFERENCED BY
BL293 TX101
UPDATED BY
BL123 BL199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODI-COMPANY Numeric 4 BL123
Element: Company 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 Numeric 12 BL123
Element: Obj Id This is a subsystem General Ledger
interface identification number. It is
used for Drill Around purposes.
ODI-ATN-OBJ-ID Numeric 12 BL123
Element: Obj Id 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 Alpha 5 BL123
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
ODI-GL-DATE Numeric 8 (yyyymmdd) BL123
Element: Gl Date The general ledger posting date for
this particular journal entry.
ODI-ACCT-UNIT Alpha 15 BL123
Element: Acct Unit 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 Numeric 6 BL123
Element: Account 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 Numeric 4 BL123
Element: Sub Acct 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 Alpha 2 BL123
Element: Invc Prefix 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 Numeric 8 BL123
Element: Invc Number 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 Numeric 10 BL123
Element: Auth No 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 Numeric 6 BL123
Element: Line Nbr Identifies the line number on the
invoice this distribution journal entry
is associated with.
ODI-SEQ Numeric 3 BL123
Element: Seq 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 Alpha 2 BL123
Element: Posting Type 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 Alpha 9 (Right Justified) BL123
Element: Customer This field contains the number that
represents a customer.
ODI-ACTIVITY Alpha 15 BL123
Element: Activity 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 Alpha 5 BL123
Element: Acct Category 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 Signed 18.2 BL123
Element: Intl Amt Amount of distribution journal entry in
company base currency.
ODI-AMOUNT-CURR Signed 18.2 BL123
Element: Intl Amt Amount of distribution journal entry in
original billing currency.
ODI-CURRENCY-CODE Alpha 5 BL123
Element: Currency Code This field contains the company's base
currency code established in the General
Ledger system.
ODI-CURR-RATE Signed 14.7 BL123
Element: Curr Rate The currency rate used to convert this
distribution amount from original
billing currency to company base
currency.
OEDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODISET1 COMPANY BL199 BL293
GL-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
INVC-PREFIX
INVC-NUMBER
AUTH-NO
LINE-NBR
SEQ
POSTING-TYPE
ODISET2 COMPANY TX101
INVC-PREFIX
INVC-NUMBER
AUTH-NO
LINE-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ
POSTING-TYPE
ODISET3 GLT-OBJ-ID KeyChange
INVC-PREFIX
INVC-NUMBER
AUTH-NO
LINE-NBR
SEQ
POSTING-TYPE
ODISET4 ATN-OBJ-ID KeyChange, Subset
INVC-PREFIX Where ATN-OBJ-ID != Zeroes
INVC-NUMBER
AUTH-NO
LINE-NBR
SEQ
POSTING-TYPE
OEDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ODI-COMPANY -> -COMPANY (XXXXXXXXXX)
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ODI-CUSTOMER -> CUD-CUSTOMER
Glchartdtl GLCHARTDTL Required
GLS-CHART-NAME -> GDT-CHART-NAME
GLM-SUMM-ACCT-ID -> GDT-SUMRY-ACCT-ID
ODI-ACCOUNT -> GDT-ACCOUNT
ODI-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Glmaster GLMASTER Not Required
ODI-COMPANY -> GLM-COMPANY
ODI-ACCT-UNIT -> GLM-ACCT-UNIT
ODI-ACCOUNT -> GLM-ACCOUNT
ODI-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
ODI-COMPANY -> GLS-COMPANY
Oecompany OECOMPANY Required
ODI-COMPANY -> OEC-COMPANY
Oeinvcline OEINVCLINE Not Required
Valid When ODI-LINE-NBR != Zeroes
And ODI-SEQ = Zeroes
ODI-COMPANY -> OIL-COMPANY
ODI-INVC-PREFIX -> OIL-INVC-PREFIX
ODI-INVC-NUMBER -> OIL-INVC-NUMBER
ODI-LINE-NBR -> OIL-LINE-NBR
Oeinvcmisc OEINVCMISC Not Required
Valid When ODI-LINE-NBR != Zeroes
And ODI-SEQ != Zeroes
ODI-COMPANY -> OIM-COMPANY
ODI-INVC-PREFIX -> OIM-INVC-PREFIX
ODI-INVC-NUMBER -> OIM-INVC-NUMBER
ODI-LINE-NBR -> OIM-LINE-NBR
ODI-SEQ -> OIM-SEQ
Oeinvoice OEINVOICE Required
ODI-COMPANY -> OEI-COMPANY
ODI-INVC-PREFIX -> OEI-INVC-PREFIX
ODI-INVC-NUMBER -> OEI-INVC-NUMBER
Oeproclev OEPROCLEV Required
ODI-COMPANY -> OEP-COMPANY
ODI-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
OEDIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
ODI-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|