OEDIST – Order Entry GL Distribution

System: Billing (BL)
Prefix: ODI
Primary key: COMPANY, GL-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, INVC-PREFIX, INVC-NUMBER, AUTH-NO, LINE-NBR, SEQ, POSTING-TYPE
Fields: 21
Updated by: 1 program
Referenced by: 0 programs

OEDIST is the Order Entry GL Distribution table in Lawson Billing (prefix ODI). It is indexed by COMPANY, GL-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, INVC-PREFIX, INVC-NUMBER, AUTH-NO, LINE-NBR, SEQ, POSTING-TYPE (ODISET1); alternate indexes: ODISET2, ODISET3 and ODISET4. It is related 1:1 to ARCOMP, CUSTDESC, GLCHARTDTL, GLMASTER, GLSYSTEM, OECOMPANY, OEINVCLINE, OEINVCMISC and 2 more and 1:M to SLTRANS. It is updated by TX101. The table has 21 fields, 4 indexes and 11 documented relations.

About OEDIST

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the ODI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ODI-COMPANY` PK 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` GLT_OBJ_ID	Numeric 12	This is a subsystem General Ledger interface identification number. It is used for Drill Around purposes.	—
`ODI-ATN-OBJ-ID` ATN_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` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	—
`ODI-GL-DATE` PK GL_DATE	Numeric 8 (yyyymmdd)	The general ledger posting date for this particular journal entry.	—
`ODI-ACCT-UNIT` PK 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` PK 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` PK SUB_ACCOUNT	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` PK 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` PK 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` PK 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` PK LINE_NBR	Numeric 6	Identifies the line number on the invoice this distribution journal entry is associated with.	—
`ODI-SEQ` PK 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` PK 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` CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	—
`ODI-ACTIVITY` 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` 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` AMOUNT_BASE	Signed 18.2	Amount of distribution journal entry in company base currency.	—
`ODI-AMOUNT-CURR` AMOUNT_CURR	Signed 18.2	Amount of distribution journal entry in original billing currency.	—
`ODI-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company's base currency code established in the General Ledger system.	—
`ODI-CURR-RATE` CURR_RATE	Signed 14.7	The currency rate used to convert this distribution amount from original billing currency to company base currency.	—

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ODISET1`	`COMPANY`, `GL-DATE`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `INVC-PREFIX`, `INVC-NUMBER`, `AUTH-NO`, `LINE-NBR`, `SEQ`, `POSTING-TYPE`	Primary		—
`ODISET2`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `AUTH-NO`, `LINE-NBR`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `SEQ`, `POSTING-TYPE`			TX101
`ODISET3`	`GLT-OBJ-ID`, `INVC-PREFIX`, `INVC-NUMBER`, `AUTH-NO`, `LINE-NBR`, `SEQ`, `POSTING-TYPE`	KeyChange		—
`ODISET4`	`ATN-OBJ-ID`, `INVC-PREFIX`, `INVC-NUMBER`, `AUTH-NO`, `LINE-NBR`, `SEQ`, `POSTING-TYPE`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
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` → `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`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Sltrans	SLTRANS			`ODI-GLT-OBJ-ID` → `SLT-GLT-OBJ-ID`, → `SLT-OBJ-ID`

Programs

Updated by (1)

TX101 Journal File Create