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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ODI-COMPANY PKCOMPANY | 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 SET3GLT_OBJ_ID | Numeric 12 | This is a subsystem General Ledger interface identification number. It is used for Drill Around purposes. | — |
#ODI-ATN-OBJ-ID SET4ATN_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-LEVELPROCESS_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | — |
#ODI-GL-DATE PKGL_DATE | Numeric 8 (yyyymmdd) | The general ledger posting date for this particular journal entry. | — |
#ODI-ACCT-UNIT PKACCT_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 PKACCOUNT | 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 PKSUB_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 PKINVC_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 PKINVC_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 PKAUTH_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 PKLINE_NBR | Numeric 6 | Identifies the line number on the invoice this distribution journal entry is associated with. | — |
#ODI-SEQ PKSEQ | 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 PKPOSTING_TYPE | Alpha 2 | This field indicates what type of account this distribution journal entry is debiting or crediting.
| — |
#ODI-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
#ODI-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-BASEAMOUNT_BASE | Signed 18.2 | Amount of distribution journal entry in company base currency. | — |
#ODI-AMOUNT-CURRAMOUNT_CURR | Signed 18.2 | Amount of distribution journal entry in original billing currency. | — |
#ODI-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company's base currency code established in the General Ledger system. | — |
#ODI-CURR-RATECURR_RATE | Signed 14.7 | The currency rate used to convert this distribution amount from original billing currency to company base currency. | — |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ODISET1 |
| Primary | — | |
ODISET2 |
| TX101 | ||
ODISET3 |
| KeyChange | — | |
ODISET4 |
| KeyChange, Subset | Where ATN-OBJ-ID != Zeroes | — |
Relations
One to one (10) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP | Required |
| ||||||||||||||||
| Custdesc | CUSTDESC | Required |
| ||||||||||||||||
| Glchartdtl | GLCHARTDTL | Required |
| ||||||||||||||||
| Glmaster | GLMASTER | Not Required |
| ||||||||||||||||
| Glsystem | GLSYSTEM | Required |
| ||||||||||||||||
| Oecompany | OECOMPANY | Required |
| ||||||||||||||||
| Oeinvcline | OEINVCLINE | Not Required | Valid When ODI-LINE-NBR != Zeroes And ODI-SEQ = Zeroes |
| |||||||||||||||
| Oeinvcmisc | OEINVCMISC | Not Required | Valid When ODI-LINE-NBR != Zeroes And ODI-SEQ != Zeroes |
| |||||||||||||||
| Oeinvoice | OEINVOICE | Required |
| ||||||||||||||||
| Oeproclev | OEPROCLEV | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Sltrans | SLTRANS |
|
Programs
Updated by (1)
- TX101 Journal File Create