Pop Terms Def
In ScopeTechnical: POP_TERMS_DEF | ID: OR-CST-POP_TERMS_DEF-POP_TERMS_DEF
This table will hold the proof of performance terms for a given deal, deal/deal component or deal/deal component/deal item-loc combination. These terms are defined by the deal partner that offers...
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- POP_TERMS_DEF
Field Definitions(5)
Rules & Considerations(18)
constraint
validation
Sample Load Data(4)
| _scenario | DEAL_IDR | POP_DEF_SEQ_NORPK | POP_TYPE | CREATE_ID | POP_VALUE | COMMENT_DESC | DEAL_SUB_ITEM | PLAN_END_DATE | DEAL_DETAIL_ID | LAST_UPDATE_ID | POP_VALUE_TYPE | CREATE_DATETIME | PLAN_START_DATE | VEND_REC_END_DATE | DEAL_ITEMLOC_SEQ_NO | VEND_REC_START_DATE | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | 2026-01-01 | 2026-01-01 |
| default | 1000000003 | 4 | Pop Te | C LIENT_INFO | 3 | Pop Terms Def-002-ALT | Pop Terms Def-002-ALT | 2026-01-03 | 1000000003 | MDM_USER | Pop Te | 2026-01-03 | 2026-01-03 | 2026-01-03 | 4 | 2026-01-03 | 2026-01-03 |
| default | 1000000005 | 6 | Pop Te | USE RENV | 5 | Pop Terms Def-003-EDGE | Pop Terms Def-003-EDGE | 2026-01-05 | 1000000005 | BATCH_USER | Pop Te | 2026-01-05 | 2026-01-05 | 2026-01-05 | 6 | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- DEAL_IDR
- 1
- POP_DEF_SEQ_NORPK
- 1
- POP_TYPE
- SAMPLE
- CREATE_ID
- SAMPLE
- POP_VALUE
- 1
- COMMENT_DESC
- SAMPLE
- DEAL_SUB_ITEM
- SAMPLE
- PLAN_END_DATE
- 2026-01-01
- DEAL_DETAIL_ID
- 1
- LAST_UPDATE_ID
- SAMPLE
- POP_VALUE_TYPE
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- PLAN_START_DATE
- 2026-01-01
- VEND_REC_END_DATE
- 2026-01-01
- DEAL_ITEMLOC_SEQ_NO
- 1
- VEND_REC_START_DATE
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- DEAL_IDR
- 1000000003
- POP_DEF_SEQ_NORPK
- 4
- POP_TYPE
- Pop Te
- CREATE_ID
- C LIENT_INFO
- POP_VALUE
- 3
- COMMENT_DESC
- Pop Terms Def-002-ALT
- DEAL_SUB_ITEM
- Pop Terms Def-002-ALT
- PLAN_END_DATE
- 2026-01-03
- DEAL_DETAIL_ID
- 1000000003
- LAST_UPDATE_ID
- MDM_USER
- POP_VALUE_TYPE
- Pop Te
- CREATE_DATETIME
- 2026-01-03
- PLAN_START_DATE
- 2026-01-03
- VEND_REC_END_DATE
- 2026-01-03
- DEAL_ITEMLOC_SEQ_NO
- 4
- VEND_REC_START_DATE
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- DEAL_IDR
- 1000000005
- POP_DEF_SEQ_NORPK
- 6
- POP_TYPE
- Pop Te
- CREATE_ID
- USE RENV
- POP_VALUE
- 5
- COMMENT_DESC
- Pop Terms Def-003-EDGE
- DEAL_SUB_ITEM
- Pop Terms Def-003-EDGE
- PLAN_END_DATE
- 2026-01-05
- DEAL_DETAIL_ID
- 1000000005
- LAST_UPDATE_ID
- BATCH_USER
- POP_VALUE_TYPE
- Pop Te
- CREATE_DATETIME
- 2026-01-05
- PLAN_START_DATE
- 2026-01-05
- VEND_REC_END_DATE
- 2026-01-05
- DEAL_ITEMLOC_SEQ_NO
- 6
- VEND_REC_START_DATE
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 18