OEORDDISC – Order Discount
- System
- Billing (BL)
- Prefix
OOD- Primary key
COMPANY,ORD-DISC-CODE,CURRENCY-CODE- Fields
- 9
- Updated by
- 0 programs
- Referenced by
- 0 programs
OEORDDISC is the Order Discount table in Lawson Billing (prefix OOD). It is indexed by COMPANY, ORD-DISC-CODE, CURRENCY-CODE (OODSET1). It is related 1:1 to CUCODES, GLCHARTDTL, GLMASTER, GLSYSTEM and OECOMPANY. The table has 9 fields, 1 index and 5 documented relations.
About OEORDDISC
This file stores the order discounts that have been assessed. Order discounts are set up in the Lawson Order Entry system and are placed onto the customer master accounts indicating that those customers will have the percentage associated with the order discount code discounted from their orders.
Fields (9)
Column = COBOL field name without the OOD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OOD-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. | — |
OOD-ORD-DISC-CODE PKORD_DISC_CODE | Alpha 4 | This order discount code is user defined and is designed to be added to the customer master accounts indicating which customers are to be affected by the discount rules tied to the code. The discounts are assessed on the order amount as a whole. | — |
OOD-CURRENCY-CODE PKCURRENCY_CODE | Alpha 5 | This is the currency code the system will use when assessing the order discount. The discount must use the same currency code as the order. | — |
OOD-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description explaining the order discount code. | — |
OOD-ACCT-UNITACCT_UNIT | Alpha 15 | The general ledger account unit that will be debited when an order discount is created. | — |
OOD-ACCOUNTACCOUNT | Numeric 6 | General ledger account number debited when the discount is calculated. | — |
OOD-SUB-ACCTSUB_ACCT | Numeric 4 | General ledger subaccount number debited when the discount is calculated. | — |
OOD-DOLLAR-LIMITDOLLAR_LIMIT | Numeric 11 Occurs 6 Times ×6 | Amount indicating how much the order amount should be before the associated discount is assessed. | — |
OOD-PCTPCT | Percent 5.2 (Percent) Occurs 6 Times ×6 | The order discount percentage to be used when the order dollar amount is exceeded. | — |
Indexes (1)
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 |
|---|---|---|---|---|
OODSET1 | COMPANY, ORD-DISC-CODE, CURRENCY-CODE | Primary | AR08.1, AR10.1, AR501, AR550, WH20.2, WH20.7 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cucodes | CUCODES | Required | When OOD-CURRENCY-CODE != Spaces | OOD-CURRENCY-CODE → CUC-CURRENCY-CODE |
| Glchartdtl | GLCHARTDTL | Not Required | GLS-CHART-NAME → GDT-CHART-NAME, GLM-SUMM-ACCT-ID → GDT-SUMRY-ACCT-ID, OOD-ACCOUNT → GDT-ACCOUNT, OOD-SUB-ACCT → GDT-SUB-ACCOUNT | |
| Glmaster | GLMASTER | Required | OOD-COMPANY → GLM-COMPANY, OOD-ACCT-UNIT → GLM-ACCT-UNIT, OOD-ACCOUNT → GLM-ACCOUNT, OOD-SUB-ACCT → GLM-SUB-ACCOUNT | |
| Glsystem | GLSYSTEM | Required | OOD-COMPANY → GLS-COMPANY | |
| Oecompany | OECOMPANY | Required | OOD-COMPANY → OEC-COMPANY |
Programs
No Lawson programs are documented as updating or referencing this table.