Ordloc Discount
In ScopeTechnical: ORDLOC_DISCOUNT | ID: OR-TRD-ORDLOC_DISCOUNT-ORDLOC_DISCOUNT
This table will hold the various deal components that apply to a ITEM on a PO. The table will be rebuilt nightly in a batch process driven off the DEAL_CALC_QUEUE…
See how this object fits into Trade Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ORDLOC_DISCOUNT
Field Definitions(13)
Rules & Considerations(26)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | SEQ_NOR | DEAL_IDRPK | LOCATIONR | ORDER_NORPK | PAID_INDR | DISCOUNT_TYPER | DEAL_DETAIL_IDR | DISCOUNT_VALUER | LAST_CALC_DATER | APPLICATION_ORDERR | DISCOUNT_AMT_PER_UNITR | PACK_NO |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 1 | S | SAMPLE | 1 | 1.0000 | 2026-01-01 | 1 | 1.0000 | SAMPLE |
Example values from field definitions
- ITEMR
- SAMPLE
- SEQ_NOR
- 1
- DEAL_IDRPK
- 1
- LOCATIONR
- 1
- ORDER_NORPK
- 1
- PAID_INDR
- S
- DISCOUNT_TYPER
- SAMPLE
- DEAL_DETAIL_IDR
- 1
- DISCOUNT_VALUER
- 1.0000
- LAST_CALC_DATER
- 2026-01-01
- APPLICATION_ORDERR
- 1
- DISCOUNT_AMT_PER_UNITR
- 1.0000
- PACK_NO
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 26