Franchise Customer Group Information

In Scope

Technical: SVC_FCUSTUPLD_THEAD | ID: OR-FND-SVC_FCUSTUPLD_THEAD-FCUSTUPLD_THEAD_SERVICE_LAYER

This is an interface table used for franchise customer upload process. Each record in this table signifies a unique transaction header and each transaction header holds franchise customer group 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_THEAD

Field Definitions(5)

Rules & Considerations(14)

constraint

validation

Sample Load Data(4)

_scenario	PROCESS_IDRPK	FILE_LINE_IDRPK	STATUS	CHUNK_ID	ERROR_MSG	FCUST_SEQ_NO	MESSAGE_TYPE	F_CUSTOMER_GROUP_ID	F_CUSTOMER_GROUP_NAME	FILE_RECORD_DESCRIPTOR
Example values from field definitions	1	1	S	1	SAMPLE	1	SAMPLE	1	SAMPLE	SAMPL
default	1000000003	1000000003	E	1000000003	Svc Fcustupld Thead-002-ALT	4	Svc Fcustupld Thead-002-ALT	1000000003	Svc Fcustupld Thead Secondary	Svc F
default	1000000005	1000000005	R	1000000005	Svc Fcustupld Thead-003-EDGE	6	Svc Fcustupld Thead-003-EDGE	1000000005	Svc Fcustupld Thead Core	Svc F

Example values from field definitions

PROCESS_IDRPK: 1
FILE_LINE_IDRPK: 1
STATUS: S
CHUNK_ID: 1
ERROR_MSG: SAMPLE
FCUST_SEQ_NO: 1
MESSAGE_TYPE: SAMPLE
F_CUSTOMER_GROUP_ID: 1
F_CUSTOMER_GROUP_NAME: SAMPLE
FILE_RECORD_DESCRIPTOR: SAMPL

default

PROCESS_IDRPK: 1000000003
FILE_LINE_IDRPK: 1000000003
STATUS: E
CHUNK_ID: 1000000003
ERROR_MSG: Svc Fcustupld Thead-002-ALT
FCUST_SEQ_NO: 4
MESSAGE_TYPE: Svc Fcustupld Thead-002-ALT
F_CUSTOMER_GROUP_ID: 1000000003
F_CUSTOMER_GROUP_NAME: Svc Fcustupld Thead Secondary
FILE_RECORD_DESCRIPTOR: Svc F