Franchise Customer Information
In ScopeTechnical: SVC_FCUSTUPLD_TDETL | ID: OR-FND-SVC_FCUSTUPLD_TDETL-FCUSTUPLD_TDETL_SERVICE_LAYER
This is an interface table used for franchise customer upload process. Each record in this table signifies a transaction detail record which holds the franchise customer 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_FCUSTUPLD_TDETL
Field Definitions(5)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | PROCESS_IDRPK | FILE_LINE_IDRPK | STATUS | ERROR_MSG | CREDIT_IND | FCUST_SEQ_NO | MESSAGE_TYPE | F_CUSTOMER_ID | F_CUSTOMER_NAME | AUTO_APPROVE_IND | FILE_RECORD_DESCRIPTOR |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | SAMPLE | S | 1 | SAMPLE | 1 | SAMPLE | S | SAMPL |
| default | 1000000003 | 1000000003 | E | Svc Fcustupld Tdetl-002-ALT | N | 4 | Svc Fcustupld Tdetl-002-ALT | 1000000003 | Svc Fcustupld Tdetl Secondary | N | Svc F |
| default | 1000000005 | 1000000005 | R | Svc Fcustupld Tdetl-003-EDGE | Y | 6 | Svc Fcustupld Tdetl-003-EDGE | 1000000005 | Svc Fcustupld Tdetl Core | Y | Svc F |
Example values from field definitions
- PROCESS_IDRPK
- 1
- FILE_LINE_IDRPK
- 1
- STATUS
- S
- ERROR_MSG
- SAMPLE
- CREDIT_IND
- S
- FCUST_SEQ_NO
- 1
- MESSAGE_TYPE
- SAMPLE
- F_CUSTOMER_ID
- 1
- F_CUSTOMER_NAME
- SAMPLE
- AUTO_APPROVE_IND
- S
- FILE_RECORD_DESCRIPTOR
- SAMPL
default
- PROCESS_IDRPK
- 1000000003
- FILE_LINE_IDRPK
- 1000000003
- STATUS
- E
- ERROR_MSG
- Svc Fcustupld Tdetl-002-ALT
- CREDIT_IND
- N
- FCUST_SEQ_NO
- 4
- MESSAGE_TYPE
- Svc Fcustupld Tdetl-002-ALT
- F_CUSTOMER_ID
- 1000000003
- F_CUSTOMER_NAME
- Svc Fcustupld Tdetl Secondary
- AUTO_APPROVE_IND
- N
- FILE_RECORD_DESCRIPTOR
- Svc F
default
- PROCESS_IDRPK
- 1000000005
- FILE_LINE_IDRPK
- 1000000005
- STATUS
- R
- ERROR_MSG
- Svc Fcustupld Tdetl-003-EDGE
- CREDIT_IND
- Y
- FCUST_SEQ_NO
- 6
- MESSAGE_TYPE
- Svc Fcustupld Tdetl-003-EDGE
- F_CUSTOMER_ID
- 1000000005
- F_CUSTOMER_NAME
- Svc Fcustupld Tdetl Core
- AUTO_APPROVE_IND
- Y
- FILE_RECORD_DESCRIPTOR
- Svc F
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 15