Ordloc Discount Build
In ScopeTechnical: ORDLOC_DISCOUNT_BUILD | ID: OR-PUR-ORDLOC_DISCOUNT_BUILD-ORDLOC_DISCOUNT_BUILD
This temporary table will hold all order items that will be recalculated in this deal application session. It will drive the discount calculation process, performed by the orddscnt batch program.
See how this object fits into Purchasing
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_BUILD
Field Definitions(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | ORDER_NOR | UNIT_COSTR | ORIGIN_COUNTRY_IDR | AREA | DEPT | CHAIN | CLASS | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | REGION | PACK_NO | DISTRICT | DIVISION | GROUP_NO | LOCATION | LOC_TYPE | SUBCLASS | ITEM_PARENT | QTY_ORDERED | ITEM_GRANDPARENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | SAM | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | 1 | 1 | S | 1 | SAMPLE | 1.0000 | SAMPLE |
| default | Ordloc Discount Build-002 | 4 | 12.5000 | ALT | 103 | 1003 | 13 | 1103 | Ordloc Dis | Ordloc Dis | Ordloc Dis | Ordloc Dis | 203 | Ordloc Discount Build-002 | 303 | 103 | 4 | 3 | O | 1113 | Ordloc Discount Build-002 | 12.5000 | Ordloc Discount Build-002 |
| default | Ordloc Discount Build-003 | 6 | 14.0000 | EDG | 105 | 1005 | 15 | 1105 | Ordloc Dis | Ordloc Dis | Ordloc Dis | Ordloc Dis | 205 | Ordloc Discount Build-003 | 305 | 105 | 6 | 5 | O | 1115 | Ordloc Discount Build-003 | 14.0000 | Ordloc Discount Build-003 |
Example values from field definitions
- ITEMR
- SAMPLE
- ORDER_NOR
- 1
- UNIT_COSTR
- 1.0000
- ORIGIN_COUNTRY_IDR
- SAM
- AREA
- 1
- DEPT
- 1
- CHAIN
- 1
- CLASS
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- REGION
- 1
- PACK_NO
- SAMPLE
- DISTRICT
- 1
- DIVISION
- 1
- GROUP_NO
- 1
- LOCATION
- 1
- LOC_TYPE
- S
- SUBCLASS
- 1
- ITEM_PARENT
- SAMPLE
- QTY_ORDERED
- 1.0000
- ITEM_GRANDPARENT
- SAMPLE
default
- ITEMR
- Ordloc Discount Build-002
- ORDER_NOR
- 4
- UNIT_COSTR
- 12.5000
- ORIGIN_COUNTRY_IDR
- ALT
- AREA
- 103
- DEPT
- 1003
- CHAIN
- 13
- CLASS
- 1103
- DIFF_1
- Ordloc Dis
- DIFF_2
- Ordloc Dis
- DIFF_3
- Ordloc Dis
- DIFF_4
- Ordloc Dis
- REGION
- 203
- PACK_NO
- Ordloc Discount Build-002
- DISTRICT
- 303
- DIVISION
- 103
- GROUP_NO
- 4
- LOCATION
- 3
- LOC_TYPE
- O
- SUBCLASS
- 1113
- ITEM_PARENT
- Ordloc Discount Build-002
- QTY_ORDERED
- 12.5000
- ITEM_GRANDPARENT
- Ordloc Discount Build-002
default
- ITEMR
- Ordloc Discount Build-003
- ORDER_NOR
- 6
- UNIT_COSTR
- 14.0000
- ORIGIN_COUNTRY_IDR
- EDG
- AREA
- 105
- DEPT
- 1005
- CHAIN
- 15
- CLASS
- 1105
- DIFF_1
- Ordloc Dis
- DIFF_2
- Ordloc Dis
- DIFF_3
- Ordloc Dis
- DIFF_4
- Ordloc Dis
- REGION
- 205
- PACK_NO
- Ordloc Discount Build-003
- DISTRICT
- 305
- DIVISION
- 105
- GROUP_NO
- 6
- LOCATION
- 5
- LOC_TYPE
- O
- SUBCLASS
- 1115
- ITEM_PARENT
- Ordloc Discount Build-003
- QTY_ORDERED
- 14.0000
- ITEM_GRANDPARENT
- Ordloc Discount Build-003
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 33
