Cost Component Upd Stg (Service Layer)
In ScopeTechnical: SVC_COST_COMP_UPD_STG | ID: OR-FND-SVC_COST_COMP_UPD_STG-COST_COMPONENT_UPD_STG_SERVICE_LAYER
This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in COST_COMP_UPD_STG.
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_COST_COMP_UPD_STG
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | ACTION | COMP_ID | COMP_TYPE | CREATE_ID | LAST_UPD_ID | EXPENSE_TYPE | NEW_COMP_RATE | NEW_PER_COUNT | EFFECTIVE_DATE | PROCESS$STATUS | CREATE_DATETIME | DEPT_DEFAULT_IND | ITEM_DEFAULT_IND | PTNR_DEFAULT_IND | SUPP_DEFAULT_IND | CNTRY_DEFAULT_IND | LAST_UPD_DATETIME | NEW_COMP_CURRENCY | NEW_PER_COUNT_UOM | ORDER_DEFAULT_IND | EFFECTIVE_DATE_UPD | TSF_ALLOC_DEFAULT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | S | S | S | S | S | 2026-01-01 | SAM | SAMP | S | 2026-01-01 | S |
| default | 3 | 1000000003 | 1000000003 | Svc Cost C | ALT-SVC_CO | S | USER | USER | Svc Co | 12.5000 | 12.5000 | 2026-01-03 | N | 2026-01-03 | S | S | S | S | S | 2026-01-03 | Svc | Svc | S | 2026-01-03 | S |
| default | 5 | 1000000005 | 1000000005 | Svc Cost C | EDGE-SVC_C | S | USER | USER | Svc Co | 14.0000 | 14.0000 | 2026-01-05 | N | 2026-01-05 | S | S | S | S | S | 2026-01-05 | Svc | Svc | S | 2026-01-05 | S |
Example values from field definitions
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDRPK
- 1
- ACTION
- SAMPLE
- COMP_ID
- SAMPLE
- COMP_TYPE
- S
- CREATE_ID
- SAMPLE
- LAST_UPD_ID
- SAMPLE
- EXPENSE_TYPE
- SAMPLE
- NEW_COMP_RATE
- 1.0000
- NEW_PER_COUNT
- 1.0000
- EFFECTIVE_DATE
- 2026-01-01
- PROCESS$STATUS
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- DEPT_DEFAULT_IND
- S
- ITEM_DEFAULT_IND
- S
- PTNR_DEFAULT_IND
- S
- SUPP_DEFAULT_IND
- S
- CNTRY_DEFAULT_IND
- S
- LAST_UPD_DATETIME
- 2026-01-01
- NEW_COMP_CURRENCY
- SAM
- NEW_PER_COUNT_UOM
- SAMP
- ORDER_DEFAULT_IND
- S
- EFFECTIVE_DATE_UPD
- 2026-01-01
- TSF_ALLOC_DEFAULT_IND
- S
default
- ROW_SEQR
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDRPK
- 1000000003
- ACTION
- Svc Cost C
- COMP_ID
- ALT-SVC_CO
- COMP_TYPE
- S
- CREATE_ID
- USER
- LAST_UPD_ID
- USER
- EXPENSE_TYPE
- Svc Co
- NEW_COMP_RATE
- 12.5000
- NEW_PER_COUNT
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- PROCESS$STATUS
- N
- CREATE_DATETIME
- 2026-01-03
- DEPT_DEFAULT_IND
- S
- ITEM_DEFAULT_IND
- S
- PTNR_DEFAULT_IND
- S
- SUPP_DEFAULT_IND
- S
- CNTRY_DEFAULT_IND
- S
- LAST_UPD_DATETIME
- 2026-01-03
- NEW_COMP_CURRENCY
- Svc
- NEW_PER_COUNT_UOM
- Svc
- ORDER_DEFAULT_IND
- S
- EFFECTIVE_DATE_UPD
- 2026-01-03
- TSF_ALLOC_DEFAULT_IND
- S
default
- ROW_SEQR
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDRPK
- 1000000005
- ACTION
- Svc Cost C
- COMP_ID
- EDGE-SVC_C
- COMP_TYPE
- S
- CREATE_ID
- USER
- LAST_UPD_ID
- USER
- EXPENSE_TYPE
- Svc Co
- NEW_COMP_RATE
- 14.0000
- NEW_PER_COUNT
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- PROCESS$STATUS
- N
- CREATE_DATETIME
- 2026-01-05
- DEPT_DEFAULT_IND
- S
- ITEM_DEFAULT_IND
- S
- PTNR_DEFAULT_IND
- S
- SUPP_DEFAULT_IND
- S
- CNTRY_DEFAULT_IND
- S
- LAST_UPD_DATETIME
- 2026-01-05
- NEW_COMP_CURRENCY
- Svc
- NEW_PER_COUNT_UOM
- Svc
- ORDER_DEFAULT_IND
- S
- EFFECTIVE_DATE_UPD
- 2026-01-05
- TSF_ALLOC_DEFAULT_IND
- S
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 25