Customer Order Substitution Header Information
In ScopeTechnical: SVC_CUSTORDSUB | ID: OR-FND-SVC_CUSTORDSUB-CUSTORDSUB_SERVICE_LAYER
This table is a parameter table used in integration services (e.g. web service, bulk interfaces).
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_CUSTORDSUB
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | CHUNK_IDR | PROCESS_IDR | ACTION_TYPER | CUSTORDSUB_IDRPK | PROCESS_STATUSR | ITEM | LOC_ID | QTY_UOM | ITEM_QTY | LOC_TYPE | CREATE_ID | ERROR_MSG | LAST_UPDATE_ID | CREATE_DATETIME | FULFILL_ORDER_NO | CUSTOMER_ORDER_NO | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | S | SAMPLE | 1 | SAMP | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 |
| default | 1000000003 | 1000000003 | Svc Custor | 1000000003 | P | Svc Custordsub-002-ALT | 1000000003 | Svc | 12.5000 | S | MDM_USER | Svc Custordsub-002-ALT | MDM_USER | 2026-01-03 | Svc Custordsub-002-ALT | Svc Custordsub-002-ALT | 2026-01-03 |
| default | 1000000005 | 1000000005 | Svc Custor | 1000000005 | A | Svc Custordsub-003-EDGE | 1000000005 | Svc | 14.0000 | S | BATCH_USER | Svc Custordsub-003-EDGE | BATCH_USER | 2026-01-05 | Svc Custordsub-003-EDGE | Svc Custordsub-003-EDGE | 2026-01-05 |
Example values from field definitions
- CHUNK_IDR
- 1
- PROCESS_IDR
- 1
- ACTION_TYPER
- SAMPLE
- CUSTORDSUB_IDRPK
- 1
- PROCESS_STATUSR
- S
- ITEM
- SAMPLE
- LOC_ID
- 1
- QTY_UOM
- SAMP
- ITEM_QTY
- 1.0000
- LOC_TYPE
- S
- CREATE_ID
- SAMPLE
- ERROR_MSG
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- FULFILL_ORDER_NO
- SAMPLE
- CUSTOMER_ORDER_NO
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- CHUNK_IDR
- 1000000003
- PROCESS_IDR
- 1000000003
- ACTION_TYPER
- Svc Custor
- CUSTORDSUB_IDRPK
- 1000000003
- PROCESS_STATUSR
- P
- ITEM
- Svc Custordsub-002-ALT
- LOC_ID
- 1000000003
- QTY_UOM
- Svc
- ITEM_QTY
- 12.5000
- LOC_TYPE
- S
- CREATE_ID
- MDM_USER
- ERROR_MSG
- Svc Custordsub-002-ALT
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- FULFILL_ORDER_NO
- Svc Custordsub-002-ALT
- CUSTOMER_ORDER_NO
- Svc Custordsub-002-ALT
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- CHUNK_IDR
- 1000000005
- PROCESS_IDR
- 1000000005
- ACTION_TYPER
- Svc Custor
- CUSTORDSUB_IDRPK
- 1000000005
- PROCESS_STATUSR
- A
- ITEM
- Svc Custordsub-003-EDGE
- LOC_ID
- 1000000005
- QTY_UOM
- Svc
- ITEM_QTY
- 14.0000
- LOC_TYPE
- S
- CREATE_ID
- BATCH_USER
- ERROR_MSG
- Svc Custordsub-003-EDGE
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- FULFILL_ORDER_NO
- Svc Custordsub-003-EDGE
- CUSTOMER_ORDER_NO
- Svc Custordsub-003-EDGE
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 32