Gtt Orditem Sum
Out of ScopeTechnical: GTT_ORDITEM_SUM | ID: OR-ITM-GTT_ORDITEM_SUM-GTT_ORDITEM_SUM
This temporary table is used to summarize order/item parent- grandparent information. It is populated and used by the ordfash.fmb form and should never have data committed to the table.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- GTT_ORDITEM_SUM
Field Definitions(5)
Rules & Considerations(31)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | DIFF_1R | ORDER_NORPK | ITEM_PARENTR | DIFF_2 | DIFF_3 | DIFF_4 | LOCATION | LOC_TYPE | DIFF1_SEQ | DIFF2_SEQ | DIFF3_SEQ | DIFF4_SEQ | QTY_ORDERED | UNIT_RETAIL | QTY_RECEIVED | SUPPLIER_COST | ITEM_GRANDPARENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | 1 | 1 | 1 | 1 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE |
| default | Gtt Orditem Sum-002-ALT | Gtt Ordite | 4 | Gtt Orditem Sum-002-ALT | Gtt Ordite | Gtt Ordite | Gtt Ordite | 3 | G | 3 | 3 | 3 | 3 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | Gtt Orditem Sum-002-ALT |
| default | Gtt Orditem Sum-003-EDGE | Gtt Ordite | 6 | Gtt Orditem Sum-003-EDGE | Gtt Ordite | Gtt Ordite | Gtt Ordite | 5 | G | 5 | 5 | 5 | 5 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | Gtt Orditem Sum-003-EDGE |
Example values from field definitions
- ITEMRPK
- SAMPLE
- DIFF_1R
- SAMPLE
- ORDER_NORPK
- 1
- ITEM_PARENTR
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- LOCATION
- 1
- LOC_TYPE
- S
- DIFF1_SEQ
- 1
- DIFF2_SEQ
- 1
- DIFF3_SEQ
- 1
- DIFF4_SEQ
- 1
- QTY_ORDERED
- 1.0000
- UNIT_RETAIL
- 1.0000
- QTY_RECEIVED
- 1.0000
- SUPPLIER_COST
- 1.0000
- ITEM_GRANDPARENT
- SAMPLE
default
- ITEMRPK
- Gtt Orditem Sum-002-ALT
- DIFF_1R
- Gtt Ordite
- ORDER_NORPK
- 4
- ITEM_PARENTR
- Gtt Orditem Sum-002-ALT
- DIFF_2
- Gtt Ordite
- DIFF_3
- Gtt Ordite
- DIFF_4
- Gtt Ordite
- LOCATION
- 3
- LOC_TYPE
- G
- DIFF1_SEQ
- 3
- DIFF2_SEQ
- 3
- DIFF3_SEQ
- 3
- DIFF4_SEQ
- 3
- QTY_ORDERED
- 12.5000
- UNIT_RETAIL
- 12.5000
- QTY_RECEIVED
- 12.5000
- SUPPLIER_COST
- 12.5000
- ITEM_GRANDPARENT
- Gtt Orditem Sum-002-ALT
default
- ITEMRPK
- Gtt Orditem Sum-003-EDGE
- DIFF_1R
- Gtt Ordite
- ORDER_NORPK
- 6
- ITEM_PARENTR
- Gtt Orditem Sum-003-EDGE
- DIFF_2
- Gtt Ordite
- DIFF_3
- Gtt Ordite
- DIFF_4
- Gtt Ordite
- LOCATION
- 5
- LOC_TYPE
- G
- DIFF1_SEQ
- 5
- DIFF2_SEQ
- 5
- DIFF3_SEQ
- 5
- DIFF4_SEQ
- 5
- QTY_ORDERED
- 14.0000
- UNIT_RETAIL
- 14.0000
- QTY_RECEIVED
- 14.0000
- SUPPLIER_COST
- 14.0000
- ITEM_GRANDPARENT
- Gtt Orditem Sum-003-EDGE
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 31