Future Cost Working (GTT)
Out of ScopeTechnical: FUTURE_COST_WORKING_GTT | ID: OR-FND-FUTURE_COST_WORKING_GTT-FUTURE_COST_WORKING_GTT
this table is used during the processing of cost engine.
See how this object fits into Foundation Data
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
- FUTURE_COST_WORKING_GTT
Field Definitions(5)
Rules & Considerations(75)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | LOCATIONR | SUPPLIERR | ORIGIN_COUNTRY_IDR | DEAL_ID | ELC_AMT | WAC_TAX | KEY_RANK | LOC_TYPE | NET_COST | BASE_COST | CALC_DATE | START_IND | BG_BUY_QTY | BG_GET_QTY | DEAL_CLASS | PARTNER_ID | ACTIVE_DATE | BG_BUY_ITEM | BG_GET_ITEM | BG_GET_TYPE | BG_GET_VALUE | BG_RECUR_IND | KEY_DAY_RANK | NET_NET_COST | PARTNER_TYPE | PRICING_COST | BG_BUY_TARGET | COST_APPL_IND | CURRENCY_CODE | BG_BUY_AVG_LOC | DEAL_DETAIL_ID | DEAL_HEAD_TYPE | HELPER_BUY_QTY | HELPER_GET_QTY | KEY_RANK_COUNT | CREATE_DATETIME | DEAL_CLOSE_DATE | THRESHOLD_VALUE | ACQUISITION_COST | DEAL_ACTIVE_DATE | HELPER_GET_VALUE | DEAD_NET_NET_COST | GET_FREE_DISCOUNT | HELPER_BUY_TARGET | HELPER_GET_TARGET | PROCESSING_SEQ_NO | EXTENDED_BASE_COST | PRICE_COST_APPL_IND | DEFAULT_COSTING_TYPE | NEGOTIATED_ITEM_COST | THRESHOLD_VALUE_TYPE | HELPER_THRESH_GET_QTY | HELPER_TOTAL_DISCOUNT | BG_FREE_ITEM_UNIT_COST | HELPER_BUY_PLUS_GET_QTY | PRIMARY_SUPP_COUNTRY_IND | HELPER_BUY_DISCOUNT_SHARE | HELPER_BUY_ITEM_UNIT_COST | HELPER_GET_DISCOUNT_SHARE | HELPER_GET_ITEM_UNIT_COST | HELPER_NEW_BUY_UNIT_COST_ | HELPER_NEW_GET_UNIT_COST_ | HELPER_NEW_ITEM_UNIT_COST | HELPER_NEW_BUY_UNIT_COST_NN | HELPER_NEW_GET_UNIT_COST_NN | HELPER_NEW_BUY_UNIT_COST_DNN | HELPER_NEW_GET_UNIT_COST_DNN | DEAL_DETAIL_APPLICATION_ORDER | HELPER_GET_ITEM_UNIT_COST_INIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAM | 1 | 1.0000 | 1.0000 | 1 | S | 1.0000 | 1.0000 | 2026-01-01 | S | 1.0000 | 1.0000 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | S | 1 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAM | 1.0000 | 1 | SAMPLE | 1.0000 | 1.0000 | 1 | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1.0000 | 1.0000 | 1 | 1.0000 | S | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 |
| default | Future Cost Working Gtt-0 | 3 | 3 | ALT | 1000000003 | 12.5000 | 12.5000 | 3 | F | 12.5000 | 12.5000 | 2026-01-03 | F | 12.5000 | 12.5000 | cu | ALT-FUTURE | 2026-01-03 | Future Cost Working Gtt-0 | Future Cost Working Gtt-0 | percen | 12.5000 | y | 3 | 12.5000 | s2 | 12.5000 | 12.5000 | n | ALT | 12.5000 | 1000000003 | a | 12.5000 | 12.5000 | 3 | 2026-01-03 | 2026-01-03 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 3 | 12.5000 | 12.5000 | 4 | 12.5000 | F | nic | 12.5000 | m | 12.5000 | 12.5000 | 12.5000 | 12.5000 | F | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 3 | 12.5000 |
| default | Future Cost Working Gtt-0 | 5 | 5 | EDG | 1000000005 | 14.0000 | 14.0000 | 5 | F | 14.0000 | 14.0000 | 2026-01-05 | F | 14.0000 | 14.0000 | cs | EDGE-FUTUR | 2026-01-05 | Future Cost Working Gtt-0 | Future Cost Working Gtt-0 | amount | 14.0000 | y | 5 | 14.0000 | s3 | 14.0000 | 14.0000 | nn | EDG | 14.0000 | 1000000005 | p | 14.0000 | 14.0000 | 5 | 2026-01-05 | 2026-01-05 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 5 | 14.0000 | 14.0000 | 6 | 14.0000 | F | bc | 14.0000 | q | 14.0000 | 14.0000 | 14.0000 | 14.0000 | F | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 5 | 14.0000 |
Example values from field definitions
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- SUPPLIERR
- 1
- ORIGIN_COUNTRY_IDR
- SAM
- DEAL_ID
- 1
- ELC_AMT
- 1.0000
- WAC_TAX
- 1.0000
- KEY_RANK
- 1
- LOC_TYPE
- S
- NET_COST
- 1.0000
- BASE_COST
- 1.0000
- CALC_DATE
- 2026-01-01
- START_IND
- S
- BG_BUY_QTY
- 1.0000
- BG_GET_QTY
- 1.0000
- DEAL_CLASS
- SAMPLE
- PARTNER_ID
- SAMPLE
- ACTIVE_DATE
- 2026-01-01
- BG_BUY_ITEM
- SAMPLE
- BG_GET_ITEM
- SAMPLE
- BG_GET_TYPE
- SAMPLE
- BG_GET_VALUE
- 1.0000
- BG_RECUR_IND
- S
- KEY_DAY_RANK
- 1
- NET_NET_COST
- 1.0000
- PARTNER_TYPE
- SAMPLE
- PRICING_COST
- 1.0000
- BG_BUY_TARGET
- 1.0000
- COST_APPL_IND
- SAMPLE
- CURRENCY_CODE
- SAM
- BG_BUY_AVG_LOC
- 1.0000
- DEAL_DETAIL_ID
- 1
- DEAL_HEAD_TYPE
- SAMPLE
- HELPER_BUY_QTY
- 1.0000
- HELPER_GET_QTY
- 1.0000
- KEY_RANK_COUNT
- 1
- CREATE_DATETIME
- 2026-01-01
- DEAL_CLOSE_DATE
- 2026-01-01
- THRESHOLD_VALUE
- 1.0000
- ACQUISITION_COST
- 1.0000
- DEAL_ACTIVE_DATE
- 2026-01-01
- HELPER_GET_VALUE
- 1.0000
- DEAD_NET_NET_COST
- 1.0000
- GET_FREE_DISCOUNT
- 1
- HELPER_BUY_TARGET
- 1.0000
- HELPER_GET_TARGET
- 1.0000
- PROCESSING_SEQ_NO
- 1
- EXTENDED_BASE_COST
- 1.0000
- PRICE_COST_APPL_IND
- S
- DEFAULT_COSTING_TYPE
- SAMPLE
- NEGOTIATED_ITEM_COST
- 1.0000
- THRESHOLD_VALUE_TYPE
- SAMPLE
- HELPER_THRESH_GET_QTY
- 1.0000
- HELPER_TOTAL_DISCOUNT
- 1.0000
- BG_FREE_ITEM_UNIT_COST
- 1.0000
- HELPER_BUY_PLUS_GET_QTY
- 1.0000
- PRIMARY_SUPP_COUNTRY_IND
- S
- HELPER_BUY_DISCOUNT_SHARE
- 1.0000
- HELPER_BUY_ITEM_UNIT_COST
- 1.0000
- HELPER_GET_DISCOUNT_SHARE
- 1.0000
- HELPER_GET_ITEM_UNIT_COST
- 1.0000
- HELPER_NEW_BUY_UNIT_COST_
- 1.0000
- HELPER_NEW_GET_UNIT_COST_
- 1.0000
- HELPER_NEW_ITEM_UNIT_COST
- 1.0000
- HELPER_NEW_BUY_UNIT_COST_NN
- 1.0000
- HELPER_NEW_GET_UNIT_COST_NN
- 1.0000
- HELPER_NEW_BUY_UNIT_COST_DNN
- 1.0000
- HELPER_NEW_GET_UNIT_COST_DNN
- 1.0000
- DEAL_DETAIL_APPLICATION_ORDER
- 1
- HELPER_GET_ITEM_UNIT_COST_INIT
- 1.0000
default
- ITEMR
- Future Cost Working Gtt-0
- LOCATIONR
- 3
- SUPPLIERR
- 3
- ORIGIN_COUNTRY_IDR
- ALT
- DEAL_ID
- 1000000003
- ELC_AMT
- 12.5000
- WAC_TAX
- 12.5000
- KEY_RANK
- 3
- LOC_TYPE
- F
- NET_COST
- 12.5000
- BASE_COST
- 12.5000
- CALC_DATE
- 2026-01-03
- START_IND
- F
- BG_BUY_QTY
- 12.5000
- BG_GET_QTY
- 12.5000
- DEAL_CLASS
- cu
- PARTNER_ID
- ALT-FUTURE
- ACTIVE_DATE
- 2026-01-03
- BG_BUY_ITEM
- Future Cost Working Gtt-0
- BG_GET_ITEM
- Future Cost Working Gtt-0
- BG_GET_TYPE
- percen
- BG_GET_VALUE
- 12.5000
- BG_RECUR_IND
- y
- KEY_DAY_RANK
- 3
- NET_NET_COST
- 12.5000
- PARTNER_TYPE
- s2
- PRICING_COST
- 12.5000
- BG_BUY_TARGET
- 12.5000
- COST_APPL_IND
- n
- CURRENCY_CODE
- ALT
- BG_BUY_AVG_LOC
- 12.5000
- DEAL_DETAIL_ID
- 1000000003
- DEAL_HEAD_TYPE
- a
- HELPER_BUY_QTY
- 12.5000
- HELPER_GET_QTY
- 12.5000
- KEY_RANK_COUNT
- 3
- CREATE_DATETIME
- 2026-01-03
- DEAL_CLOSE_DATE
- 2026-01-03
- THRESHOLD_VALUE
- 12.5000
- ACQUISITION_COST
- 12.5000
- DEAL_ACTIVE_DATE
- 2026-01-03
- HELPER_GET_VALUE
- 12.5000
- DEAD_NET_NET_COST
- 12.5000
- GET_FREE_DISCOUNT
- 3
- HELPER_BUY_TARGET
- 12.5000
- HELPER_GET_TARGET
- 12.5000
- PROCESSING_SEQ_NO
- 4
- EXTENDED_BASE_COST
- 12.5000
- PRICE_COST_APPL_IND
- F
- DEFAULT_COSTING_TYPE
- nic
- NEGOTIATED_ITEM_COST
- 12.5000
- THRESHOLD_VALUE_TYPE
- m
- HELPER_THRESH_GET_QTY
- 12.5000
- HELPER_TOTAL_DISCOUNT
- 12.5000
- BG_FREE_ITEM_UNIT_COST
- 12.5000
- HELPER_BUY_PLUS_GET_QTY
- 12.5000
- PRIMARY_SUPP_COUNTRY_IND
- F
- HELPER_BUY_DISCOUNT_SHARE
- 12.5000
- HELPER_BUY_ITEM_UNIT_COST
- 12.5000
- HELPER_GET_DISCOUNT_SHARE
- 12.5000
- HELPER_GET_ITEM_UNIT_COST
- 12.5000
- HELPER_NEW_BUY_UNIT_COST_
- 12.5000
- HELPER_NEW_GET_UNIT_COST_
- 12.5000
- HELPER_NEW_ITEM_UNIT_COST
- 12.5000
- HELPER_NEW_BUY_UNIT_COST_NN
- 12.5000
- HELPER_NEW_GET_UNIT_COST_NN
- 12.5000
- HELPER_NEW_BUY_UNIT_COST_DNN
- 12.5000
- HELPER_NEW_GET_UNIT_COST_DNN
- 12.5000
- DEAL_DETAIL_APPLICATION_ORDER
- 3
- HELPER_GET_ITEM_UNIT_COST_INIT
- 12.5000
default
- ITEMR
- Future Cost Working Gtt-0
- LOCATIONR
- 5
- SUPPLIERR
- 5
- ORIGIN_COUNTRY_IDR
- EDG
- DEAL_ID
- 1000000005
- ELC_AMT
- 14.0000
- WAC_TAX
- 14.0000
- KEY_RANK
- 5
- LOC_TYPE
- F
- NET_COST
- 14.0000
- BASE_COST
- 14.0000
- CALC_DATE
- 2026-01-05
- START_IND
- F
- BG_BUY_QTY
- 14.0000
- BG_GET_QTY
- 14.0000
- DEAL_CLASS
- cs
- PARTNER_ID
- EDGE-FUTUR
- ACTIVE_DATE
- 2026-01-05
- BG_BUY_ITEM
- Future Cost Working Gtt-0
- BG_GET_ITEM
- Future Cost Working Gtt-0
- BG_GET_TYPE
- amount
- BG_GET_VALUE
- 14.0000
- BG_RECUR_IND
- y
- KEY_DAY_RANK
- 5
- NET_NET_COST
- 14.0000
- PARTNER_TYPE
- s3
- PRICING_COST
- 14.0000
- BG_BUY_TARGET
- 14.0000
- COST_APPL_IND
- nn
- CURRENCY_CODE
- EDG
- BG_BUY_AVG_LOC
- 14.0000
- DEAL_DETAIL_ID
- 1000000005
- DEAL_HEAD_TYPE
- p
- HELPER_BUY_QTY
- 14.0000
- HELPER_GET_QTY
- 14.0000
- KEY_RANK_COUNT
- 5
- CREATE_DATETIME
- 2026-01-05
- DEAL_CLOSE_DATE
- 2026-01-05
- THRESHOLD_VALUE
- 14.0000
- ACQUISITION_COST
- 14.0000
- DEAL_ACTIVE_DATE
- 2026-01-05
- HELPER_GET_VALUE
- 14.0000
- DEAD_NET_NET_COST
- 14.0000
- GET_FREE_DISCOUNT
- 5
- HELPER_BUY_TARGET
- 14.0000
- HELPER_GET_TARGET
- 14.0000
- PROCESSING_SEQ_NO
- 6
- EXTENDED_BASE_COST
- 14.0000
- PRICE_COST_APPL_IND
- F
- DEFAULT_COSTING_TYPE
- bc
- NEGOTIATED_ITEM_COST
- 14.0000
- THRESHOLD_VALUE_TYPE
- q
- HELPER_THRESH_GET_QTY
- 14.0000
- HELPER_TOTAL_DISCOUNT
- 14.0000
- BG_FREE_ITEM_UNIT_COST
- 14.0000
- HELPER_BUY_PLUS_GET_QTY
- 14.0000
- PRIMARY_SUPP_COUNTRY_IND
- F
- HELPER_BUY_DISCOUNT_SHARE
- 14.0000
- HELPER_BUY_ITEM_UNIT_COST
- 14.0000
- HELPER_GET_DISCOUNT_SHARE
- 14.0000
- HELPER_GET_ITEM_UNIT_COST
- 14.0000
- HELPER_NEW_BUY_UNIT_COST_
- 14.0000
- HELPER_NEW_GET_UNIT_COST_
- 14.0000
- HELPER_NEW_ITEM_UNIT_COST
- 14.0000
- HELPER_NEW_BUY_UNIT_COST_NN
- 14.0000
- HELPER_NEW_GET_UNIT_COST_NN
- 14.0000
- HELPER_NEW_BUY_UNIT_COST_DNN
- 14.0000
- HELPER_NEW_GET_UNIT_COST_DNN
- 14.0000
- DEAL_DETAIL_APPLICATION_ORDER
- 5
- HELPER_GET_ITEM_UNIT_COST_INIT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 88
- Governed Rule Count
- 75