Gtt Deal Itemloc
Out of ScopeTechnical: GTT_DEAL_ITEMLOC | ID: OR-CST-GTT_DEAL_ITEMLOC-GTT_DEAL_ITEMLOC
This table will temporarily hold records from the DEAL_HEAD table based on the 4 new DEAL_ITEMLOC tables.
See how this object fits into Cost
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_DEAL_ITEMLOC
Field Definitions(5)
Rules & Considerations(23)
validation
constraint
Sample Load Data(4)
| _scenario | DEAL_IDR | PARTNER_TYPER | TYPE | STATUS | COMMENTS | ORDER_NO | SUPPLIER | SUP_NAME | CREATE_ID | CLOSE_DATE | EXT_REF_NO | PARTNER_ID | ACTIVE_DATE | REJECT_DATE | PARTNER_DESC | SECURITY_IND | APPROVAL_DATE | CURRENCY_CODE | CREATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | S | 2026-01-01 | SAM | 2026-01-01 |
| default | 1000000003 | Gtt De | Gtt De | PENDIN | Gtt Deal Itemloc-002-ALT | 4 | 3 | Gtt Deal Itemloc Secondary | MDM_USER | 2026-01-03 | Gtt Deal Itemloc-002-ALT | ALT-GTT_DE | 2026-01-03 | 2026-01-03 | Gtt Deal Itemloc-002-ALT | G | 2026-01-03 | ALT | 2026-01-03 |
| default | 1000000005 | Gtt De | Gtt De | ACTIVE | Gtt Deal Itemloc-003-EDGE | 6 | 5 | Gtt Deal Itemloc Core | BATCH_USER | 2026-01-05 | Gtt Deal Itemloc-003-EDGE | EDGE-GTT_D | 2026-01-05 | 2026-01-05 | Gtt Deal Itemloc-003-EDGE | G | 2026-01-05 | EDG | 2026-01-05 |
Example values from field definitions
- DEAL_IDR
- 1
- PARTNER_TYPER
- SAMPLE
- TYPE
- SAMPLE
- STATUS
- SAMPLE
- COMMENTS
- SAMPLE
- ORDER_NO
- 1
- SUPPLIER
- 1
- SUP_NAME
- SAMPLE
- CREATE_ID
- SAMPLE
- CLOSE_DATE
- 2026-01-01
- EXT_REF_NO
- SAMPLE
- PARTNER_ID
- SAMPLE
- ACTIVE_DATE
- 2026-01-01
- REJECT_DATE
- 2026-01-01
- PARTNER_DESC
- SAMPLE
- SECURITY_IND
- S
- APPROVAL_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- CREATE_DATETIME
- 2026-01-01
default
- DEAL_IDR
- 1000000003
- PARTNER_TYPER
- Gtt De
- TYPE
- Gtt De
- STATUS
- PENDIN
- COMMENTS
- Gtt Deal Itemloc-002-ALT
- ORDER_NO
- 4
- SUPPLIER
- 3
- SUP_NAME
- Gtt Deal Itemloc Secondary
- CREATE_ID
- MDM_USER
- CLOSE_DATE
- 2026-01-03
- EXT_REF_NO
- Gtt Deal Itemloc-002-ALT
- PARTNER_ID
- ALT-GTT_DE
- ACTIVE_DATE
- 2026-01-03
- REJECT_DATE
- 2026-01-03
- PARTNER_DESC
- Gtt Deal Itemloc-002-ALT
- SECURITY_IND
- G
- APPROVAL_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- CREATE_DATETIME
- 2026-01-03
default
- DEAL_IDR
- 1000000005
- PARTNER_TYPER
- Gtt De
- TYPE
- Gtt De
- STATUS
- ACTIVE
- COMMENTS
- Gtt Deal Itemloc-003-EDGE
- ORDER_NO
- 6
- SUPPLIER
- 5
- SUP_NAME
- Gtt Deal Itemloc Core
- CREATE_ID
- BATCH_USER
- CLOSE_DATE
- 2026-01-05
- EXT_REF_NO
- Gtt Deal Itemloc-003-EDGE
- PARTNER_ID
- EDGE-GTT_D
- ACTIVE_DATE
- 2026-01-05
- REJECT_DATE
- 2026-01-05
- PARTNER_DESC
- Gtt Deal Itemloc-003-EDGE
- SECURITY_IND
- G
- APPROVAL_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- CREATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 23