Ordloc Discount
In ScopeTechnical: ORDLOC_DISCOUNT | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- ORDLOC_DISCOUNT
Field Definitions(13)
Rules & Considerations(45)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Ordloc Discount-001 | 2 | 1000000001 | 1 | 2 | Y | Q | 1000000001 | 11.0000 | 2026-01-01 | 1 | 11.0000 | Ordloc Discount-001 |
default
- ITEMR
- Ordloc Discount-001
- SEQ_NOR
- 2
- DEAL_IDRPK
- 1000000001
- LOCATIONR
- 1
- ORDER_NORPK
- 2
- PAID_INDR
- Y
- DISCOUNT_TYPER
- Q
- DEAL_DETAIL_IDR
- 1000000001
- DISCOUNT_VALUER
- 11.0000
- LAST_CALC_DATER
- 2026-01-01
- APPLICATION_ORDERR
- 1
- DISCOUNT_AMT_PER_UNITR
- 11.0000
- PACK_NO
- Ordloc Discount-001