RPM Clr Quick Create (GTT)
Out of ScopeTechnical: RPM_CLR_QUICK_CREATE_GTT | ID: OR-PRC-RPM_CLR_QUICK_CREATE_GTT-RPM_CLR_QUICK_CREATE_GTT
This table is a temporary working table used in the validation of quick creation of clearances.
See how this object fits into Pricing & Promotions
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
- RPM_CLR_QUICK_CREATE_GTT
Field Definitions(5)
Rules & Considerations(32)
Sample Load Data(4)
| _scenario | DEPT | ITEM | CLASS | STATE | DIFF_ID | ZONE_ID | LOCATION | SUBCLASS | DIFF_TYPE | ERROR_IND | RANGE_IND | ITEM_LEVEL | TRAN_LEVEL | CHANGE_TYPE | REASON_CODE | CLEARANCE_ID | GENERATED_BY | IL_OWNED_IND | MARKDOWN_NBR | WORKSPACE_ID | CHANGE_AMOUNT | ORIGINAL_ITEM | PURCHASE_TYPE | CHANGE_PERCENT | EFFECTIVE_DATE | ZONE_NODE_TYPE | CHANGE_CURRENCY | NEED_EXPLODE_IND | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | APPLY_CLR_DEFAULTS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | S | 1 | SAMPLE | 1 | 1.0000 | SAMPLE | 1 | 1.0000 | 2026-01-01 | 1 | SAM | 1 | SAMPLE | 1 | 1 | 1 | S |
| default | 1003 | RPM Clr Quick Create Gtt- | 1103 | 3 | ALT-RPM_CL | 1000000003 | 3 | 1113 | RPM Clr Qu | 3 | 3 | 3 | 3 | 3 | ALT-RP | 1000000003 | S | 0 | RPM Cl | 1000000003 | 12.5000 | RPM Clr Quick Create Gtt- | 1 | 12.5000 | 2026-01-03 | 3 | RPM | 0 | ALT-RPM_CL | 1000000003 | 3 | 1000000003 | R |
| default | 1005 | RPM Clr Quick Create Gtt- | 1105 | 5 | EDGE-RPM_C | 1000000005 | 5 | 1115 | RPM Clr Qu | 5 | 5 | 5 | 5 | 5 | EDGE-R | 1000000005 | S | 0 | RPM Cl | 1000000005 | 14.0000 | RPM Clr Quick Create Gtt- | 0 | 14.0000 | 2026-01-05 | 5 | RPM | 0 | EDGE-RPM_C | 1000000005 | 5 | 1000000005 | R |
Example values from field definitions
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- STATE
- 1
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- SUBCLASS
- 1
- DIFF_TYPE
- SAMPLE
- ERROR_IND
- 1
- RANGE_IND
- 1
- ITEM_LEVEL
- 1
- TRAN_LEVEL
- 1
- CHANGE_TYPE
- 1
- REASON_CODE
- SAMPLE
- CLEARANCE_ID
- 1
- GENERATED_BY
- S
- IL_OWNED_IND
- 1
- MARKDOWN_NBR
- SAMPLE
- WORKSPACE_ID
- 1
- CHANGE_AMOUNT
- 1.0000
- ORIGINAL_ITEM
- SAMPLE
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 1.0000
- EFFECTIVE_DATE
- 2026-01-01
- ZONE_NODE_TYPE
- 1
- CHANGE_CURRENCY
- SAM
- NEED_EXPLODE_IND
- 1
- ORIGINAL_DIFF_ID
- SAMPLE
- ORIGINAL_ZONE_ID
- 1
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1
- APPLY_CLR_DEFAULTS
- S
default
- DEPT
- 1003
- ITEM
- RPM Clr Quick Create Gtt-
- CLASS
- 1103
- STATE
- 3
- DIFF_ID
- ALT-RPM_CL
- ZONE_ID
- 1000000003
- LOCATION
- 3
- SUBCLASS
- 1113
- DIFF_TYPE
- RPM Clr Qu
- ERROR_IND
- 3
- RANGE_IND
- 3
- ITEM_LEVEL
- 3
- TRAN_LEVEL
- 3
- CHANGE_TYPE
- 3
- REASON_CODE
- ALT-RP
- CLEARANCE_ID
- 1000000003
- GENERATED_BY
- S
- IL_OWNED_IND
- 0
- MARKDOWN_NBR
- RPM Cl
- WORKSPACE_ID
- 1000000003
- CHANGE_AMOUNT
- 12.5000
- ORIGINAL_ITEM
- RPM Clr Quick Create Gtt-
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- ZONE_NODE_TYPE
- 3
- CHANGE_CURRENCY
- RPM
- NEED_EXPLODE_IND
- 0
- ORIGINAL_DIFF_ID
- ALT-RPM_CL
- ORIGINAL_ZONE_ID
- 1000000003
- PRIMARY_SUPPLIER
- 3
- ROUNDING_RULE_ID
- 1000000003
- APPLY_CLR_DEFAULTS
- R
default
- DEPT
- 1005
- ITEM
- RPM Clr Quick Create Gtt-
- CLASS
- 1105
- STATE
- 5
- DIFF_ID
- EDGE-RPM_C
- ZONE_ID
- 1000000005
- LOCATION
- 5
- SUBCLASS
- 1115
- DIFF_TYPE
- RPM Clr Qu
- ERROR_IND
- 5
- RANGE_IND
- 5
- ITEM_LEVEL
- 5
- TRAN_LEVEL
- 5
- CHANGE_TYPE
- 5
- REASON_CODE
- EDGE-R
- CLEARANCE_ID
- 1000000005
- GENERATED_BY
- S
- IL_OWNED_IND
- 0
- MARKDOWN_NBR
- RPM Cl
- WORKSPACE_ID
- 1000000005
- CHANGE_AMOUNT
- 14.0000
- ORIGINAL_ITEM
- RPM Clr Quick Create Gtt-
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- ZONE_NODE_TYPE
- 5
- CHANGE_CURRENCY
- RPM
- NEED_EXPLODE_IND
- 0
- ORIGINAL_DIFF_ID
- EDGE-RPM_C
- ORIGINAL_ZONE_ID
- 1000000005
- PRIMARY_SUPPLIER
- 5
- ROUNDING_RULE_ID
- 1000000005
- APPLY_CLR_DEFAULTS
- R
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 32
