Transaction Detail Information
In ScopeTechnical: SVC_WF_COST_TMPL_UPLD_TDETL | ID: OR-FND-SVC_WF_COST_TMPL_UPLD_TDETL-WF_COST_TMPL_UPLOAD_TDETL_SERVICE_LAYER
This is an interface table used in the franchise cost template upload process. It holds transaction detail information.
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_WF_COST_TMPL_UPLD_TDETL
Field Definitions(5)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | DEPT | ITEM | CLASS | SEQ_NO | STATUS | END_DATE | LOCATION | SUBCLASS | ERROR_MSG | PROCESS_ID | START_DATE | COST_COMP_ID | FILE_LINE_ID | MESSAGE_TYPE | NEW_END_DATE | NEW_START_DATE | FILE_RECORD_DESCRIPTOR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | S | 2026-01-01 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPL |
| default | 1003 | Svc Wf Cost Tmpl Upld Tde | 1103 | 4 | E | 2026-01-03 | 3 | 1113 | Svc Wf Cost Tmpl Upld Tdetl-002-ALT | 1000000003 | 2026-01-03 | ALT-SVC_WF | 1000000003 | Svc Wf Cost Tmpl Upld Tdetl-00 | 2026-01-03 | 2026-01-03 | Svc W |
| default | 1005 | Svc Wf Cost Tmpl Upld Tde | 1105 | 6 | R | 2026-01-05 | 5 | 1115 | Svc Wf Cost Tmpl Upld Tdetl-003-EDGE | 1000000005 | 2026-01-05 | EDGE-SVC_W | 1000000005 | Svc Wf Cost Tmpl Upld Tdetl-00 | 2026-01-05 | 2026-01-05 | Svc W |
Example values from field definitions
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- SEQ_NO
- 1
- STATUS
- S
- END_DATE
- 2026-01-01
- LOCATION
- 1
- SUBCLASS
- 1
- ERROR_MSG
- SAMPLE
- PROCESS_ID
- 1
- START_DATE
- 2026-01-01
- COST_COMP_ID
- SAMPLE
- FILE_LINE_ID
- 1
- MESSAGE_TYPE
- SAMPLE
- NEW_END_DATE
- 2026-01-01
- NEW_START_DATE
- 2026-01-01
- FILE_RECORD_DESCRIPTOR
- SAMPL
default
- DEPT
- 1003
- ITEM
- Svc Wf Cost Tmpl Upld Tde
- CLASS
- 1103
- SEQ_NO
- 4
- STATUS
- E
- END_DATE
- 2026-01-03
- LOCATION
- 3
- SUBCLASS
- 1113
- ERROR_MSG
- Svc Wf Cost Tmpl Upld Tdetl-002-ALT
- PROCESS_ID
- 1000000003
- START_DATE
- 2026-01-03
- COST_COMP_ID
- ALT-SVC_WF
- FILE_LINE_ID
- 1000000003
- MESSAGE_TYPE
- Svc Wf Cost Tmpl Upld Tdetl-00
- NEW_END_DATE
- 2026-01-03
- NEW_START_DATE
- 2026-01-03
- FILE_RECORD_DESCRIPTOR
- Svc W
default
- DEPT
- 1005
- ITEM
- Svc Wf Cost Tmpl Upld Tde
- CLASS
- 1105
- SEQ_NO
- 6
- STATUS
- R
- END_DATE
- 2026-01-05
- LOCATION
- 5
- SUBCLASS
- 1115
- ERROR_MSG
- Svc Wf Cost Tmpl Upld Tdetl-003-EDGE
- PROCESS_ID
- 1000000005
- START_DATE
- 2026-01-05
- COST_COMP_ID
- EDGE-SVC_W
- FILE_LINE_ID
- 1000000005
- MESSAGE_TYPE
- Svc Wf Cost Tmpl Upld Tdetl-00
- NEW_END_DATE
- 2026-01-05
- NEW_START_DATE
- 2026-01-05
- FILE_RECORD_DESCRIPTOR
- Svc W
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 13