Gtt Incomp Items
Out of ScopeTechnical: GTT_INCOMP_ITEMS | ID: OR-ITM-GTT_INCOMP_ITEMS-GTT_INCOMP_ITEMS
This global temporary table is used to populate data for Incomplete Items report.
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_INCOMP_ITEMS
Field Definitions(5)
Rules & Considerations(37)
Sample Load Data(4)
| _scenario | HTS | UDA | VAT | VPN | DEPT | ITEM | CLASS | IMAGES | STATUS | TICKET | SEASONS | LOCATION | PACK_IND | SUBCLASS | CREATE_ID | DEPT_NAME | ITEM_DESC | REF_ITEMS | UNIT_COST | CLASS_NAME | DIMENSIONS | ITEM_LEVEL | SUBS_ITEMS | TRAN_LEVEL | CREATE_DATE | DISPLAY_IND | IMPORT_ATTR | ITEM_PARENT | SIMPLE_PACK | PRIM_COUNTRY | SUP_CURRENCY | PRIM_SUPPLIER | RELATED_ITEMS | REPLENISHMENT | SUBCLASS_NAME | SELLING_RETAIL | REQD_COMPLETION | PRIM_SUPPLIER_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | S | 1 | 1 | 1 | S | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | 1 | 1 | 1 | 1 | 2026-01-01 | S | 1 | SAMPLE | 1 | SAM | SAM | 1 | 1 | 1 | SAMPLE | 1.0000 | 1 | SAMPLE |
| default | 3 | 3 | 3 | Gtt Incomp Items-002-ALT | 1003 | Gtt Incomp Items-002-ALT | 1103 | 3 | P | 3 | 3 | 3 | G | 1113 | MDM_USER | Footwear | Gtt Incomp Items-002-ALT | 3 | 12.5000 | Womenswear | 3 | 3 | 3 | 3 | 2026-01-03 | G | 3 | Gtt Incomp Items-002-ALT | 3 | Gtt | Gtt | 3 | 3 | 3 | Fashion Range | 12.5000 | 3 | Gtt Incomp Items Secondary |
| default | 5 | 5 | 5 | Gtt Incomp Items-003-EDGE | 1005 | Gtt Incomp Items-003-EDGE | 1105 | 5 | A | 5 | 5 | 5 | G | 1115 | BATCH_USER | Beauty | Gtt Incomp Items-003-EDGE | 5 | 14.0000 | Kidswear | 5 | 5 | 5 | 5 | 2026-01-05 | G | 5 | Gtt Incomp Items-003-EDGE | 5 | Gtt | Gtt | 5 | 5 | 5 | Value Range | 14.0000 | 5 | Gtt Incomp Items Core |
Example values from field definitions
- HTS
- 1
- UDA
- 1
- VAT
- 1
- VPN
- SAMPLE
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- IMAGES
- 1
- STATUS
- S
- TICKET
- 1
- SEASONS
- 1
- LOCATION
- 1
- PACK_IND
- S
- SUBCLASS
- 1
- CREATE_ID
- SAMPLE
- DEPT_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- REF_ITEMS
- 1
- UNIT_COST
- 1.0000
- CLASS_NAME
- SAMPLE
- DIMENSIONS
- 1
- ITEM_LEVEL
- 1
- SUBS_ITEMS
- 1
- TRAN_LEVEL
- 1
- CREATE_DATE
- 2026-01-01
- DISPLAY_IND
- S
- IMPORT_ATTR
- 1
- ITEM_PARENT
- SAMPLE
- SIMPLE_PACK
- 1
- PRIM_COUNTRY
- SAM
- SUP_CURRENCY
- SAM
- PRIM_SUPPLIER
- 1
- RELATED_ITEMS
- 1
- REPLENISHMENT
- 1
- SUBCLASS_NAME
- SAMPLE
- SELLING_RETAIL
- 1.0000
- REQD_COMPLETION
- 1
- PRIM_SUPPLIER_NAME
- SAMPLE
default
- HTS
- 3
- UDA
- 3
- VAT
- 3
- VPN
- Gtt Incomp Items-002-ALT
- DEPT
- 1003
- ITEM
- Gtt Incomp Items-002-ALT
- CLASS
- 1103
- IMAGES
- 3
- STATUS
- P
- TICKET
- 3
- SEASONS
- 3
- LOCATION
- 3
- PACK_IND
- G
- SUBCLASS
- 1113
- CREATE_ID
- MDM_USER
- DEPT_NAME
- Footwear
- ITEM_DESC
- Gtt Incomp Items-002-ALT
- REF_ITEMS
- 3
- UNIT_COST
- 12.5000
- CLASS_NAME
- Womenswear
- DIMENSIONS
- 3
- ITEM_LEVEL
- 3
- SUBS_ITEMS
- 3
- TRAN_LEVEL
- 3
- CREATE_DATE
- 2026-01-03
- DISPLAY_IND
- G
- IMPORT_ATTR
- 3
- ITEM_PARENT
- Gtt Incomp Items-002-ALT
- SIMPLE_PACK
- 3
- PRIM_COUNTRY
- Gtt
- SUP_CURRENCY
- Gtt
- PRIM_SUPPLIER
- 3
- RELATED_ITEMS
- 3
- REPLENISHMENT
- 3
- SUBCLASS_NAME
- Fashion Range
- SELLING_RETAIL
- 12.5000
- REQD_COMPLETION
- 3
- PRIM_SUPPLIER_NAME
- Gtt Incomp Items Secondary
default
- HTS
- 5
- UDA
- 5
- VAT
- 5
- VPN
- Gtt Incomp Items-003-EDGE
- DEPT
- 1005
- ITEM
- Gtt Incomp Items-003-EDGE
- CLASS
- 1105
- IMAGES
- 5
- STATUS
- A
- TICKET
- 5
- SEASONS
- 5
- LOCATION
- 5
- PACK_IND
- G
- SUBCLASS
- 1115
- CREATE_ID
- BATCH_USER
- DEPT_NAME
- Beauty
- ITEM_DESC
- Gtt Incomp Items-003-EDGE
- REF_ITEMS
- 5
- UNIT_COST
- 14.0000
- CLASS_NAME
- Kidswear
- DIMENSIONS
- 5
- ITEM_LEVEL
- 5
- SUBS_ITEMS
- 5
- TRAN_LEVEL
- 5
- CREATE_DATE
- 2026-01-05
- DISPLAY_IND
- G
- IMPORT_ATTR
- 5
- ITEM_PARENT
- Gtt Incomp Items-003-EDGE
- SIMPLE_PACK
- 5
- PRIM_COUNTRY
- Gtt
- SUP_CURRENCY
- Gtt
- PRIM_SUPPLIER
- 5
- RELATED_ITEMS
- 5
- REPLENISHMENT
- 5
- SUBCLASS_NAME
- Value Range
- SELLING_RETAIL
- 14.0000
- REQD_COMPLETION
- 5
- PRIM_SUPPLIER_NAME
- Gtt Incomp Items Core
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 37