|
|
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
UPDATED BY
BL123 BL199 BL963 OE130
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODI-COMPANY Numeric 4 BL123 BL963
Company The company number represents an OE130
established company and is entered on
all function codes.
ODI-GLT-OBJ-ID Numeric 12 BL123 BL963
Subsystem GL This is a subsystem General Ledger OE130
Interface ID interface identification number. It is
used for Drill Around purposes.
ODI-ATN-OBJ-ID Numeric 12 BL123 BL963
AC System Object ID Activities are the processes or OE130
(Sales) 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 BL963
Process Level This field contains the process level, OE130
which is the reporting hierarchy below
company.
ODI-GL-DATE Numeric 8 (yyyymmdd) BL123 BL963
General Ledger Date The general ledger posting date for OE130
this particular journal entry.
ODI-ACCT-UNIT Alpha 15 BL123 BL963
Accounting Unit This is the accounting unit that will OE130
be debited or credited in general ledger
when this journal entry distribution is
interfaced into the General Ledger
system.
ODI-ACCOUNT Numeric 6 BL123 BL963
Account This field indicates the general ledger OE130
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 BL963
Subaccount This is the general ledger subaccount OE130
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 BL963
Invoice Prefix This field contains the invoice prefix OE130
that is assigned from either the company
or process level, depending on the
invoice-level option chosen.
ODI-INVC-NUMBER Numeric 8 BL123 BL963
Invc Number Invoice number associated with this OE130
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 BL963
Auth No This is the returns authorization OE130
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 BL963
Line Number Identifies the line number on the OE130
invoice this distribution journal entry
is associated with.
ODI-SEQ Numeric 3 BL123 BL963
Sequence Number If this distribution record pertains to OE130
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 BL963
Posting Type This field indicates what type of OE130
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 BL963
Customer Number This field contains the number that OE130
represents a customer.
ODI-ACTIVITY Alpha 15 BL123 BL963
Activity Activities are the processes or OE130
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 BL963
Account Category Account categories are groupings of OE130
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 15.2 BL123 BL963
Base Amount Amount of distribution journal entry in OE130
company base currency.
ODI-AMOUNT-CURR Signed 15.2 BL123 BL963
Amount Curr Amount of distribution journal entry in OE130
original billing currency.
ODI-CURRENCY-CODE Alpha 5 BL123 BL963
Currency Code This field contains the company's base OE130
currency code established in the General
Ledger system.
ODI-CURR-RATE Signed 13.6 BL123 BL963
Currency 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 BL963
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
INVC-PREFIX
INVC-NUMBER
AUTH-NO
LINE-NBR
SEQ
POSTING-TYPE
ODISET2 COMPANY
INVC-PREFIX
INVC-NUMBER
AUTH-NO
LINE-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ
POSTING-TYPE
ODISET3 GLT-OBJ-ID KeyChange BL963
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 -> ACO-COMPANY (ACOSET1)
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 -> x u� u� �( -SUMRY-ACCT-ID
ODI-ACCOUNT -> x u� u� �( -ACCOUNT
ODI-SUB-ACCOUNT -> x u� u� �( -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
|