Posupld Staging Rej (Service Layer)

In Scope

Technical: SVC_POSUPLD_STAGING_REJ | ID: OR-FND-SVC_POSUPLD_STAGING_REJ-POSUPLD_STAGING_REJ_SERVICE_LAYER

Stores the records coming from v_svc_posupld_load view for processing.

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_POSUPLD_STAGING_REJ

Field Definitions(5)

Sample Load Data(4)

_scenario	FILE_TYPER	LINE_SEQ_IDR	COL_1	COL_2	COL_3	COL_4	COL_5	COL_6	COL_7	COL_8	COL_9	COL_10	COL_11	COL_12	COL_13	COL_14	COL_15	COL_16	COL_17	COL_18	COL_19	COL_20	COL_21	COL_22	COL_23	COL_24	COL_25	COL_26	COL_27	COL_28	COL_29	COL_30	COL_31	COL_32	COL_33	COL_34	TTAX_ID	CHUNK_ID	FILENAME	LOCATION	TDETL_ID	THEAD_ID	ERROR_MSG	THREAD_VAL	HEAD_DETL_ID	ILS_UPDATE_LOC	SALESPROCESS_LOC	SALES_PROCESS_ID
Example values from field definitions	SAMPL	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	SAMP	SAMP	SAMPLE	SAMPLE	SAMP	SAMP	SAMPLE	SAMPLE	SAMP	SAMPLE	SAMPLE	SAMP	SAMPLE	SAMP	SAMPLE	S	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SA	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	SAMPLE	1	1	1	SAMPLE	1	1	1	1	1
default	Svc P	1000000003	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc	Svc	Svc	Svc Posupld Staging Rej-	Svc Posupld Staging Rej-002-ALT	Svc	Svc	Svc Posupld Staging Rej-002-ALT	Svc Posupld Stag	Svc	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Svc	Svc Posupld Staging Rej-002-ALT	Svc	Svc Posupld Staging Rej-002-ALT	S	S	Svc Posupl	Svc Posupl	Svc Posupld Staging Rej-002-ALT	Svc Posupld Staging Rej-002-ALT	Sv	Svc Posupl	Svc Posupl	Svc Posupl	Svc Posupld	Svc Posupld Staging	1000000003	1000000003	Svc Posupld Staging Rej-002-ALT	3	1000000003	1000000003	Svc Posupld Staging Rej-002-ALT	3	1000000003	3	3	1000000003
default	Svc P	1000000005	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc	Svc	Svc	Svc Posupld Staging Rej-	Svc Posupld Staging Rej-003-EDGE	Svc	Svc	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Stag	Svc	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Svc	Svc Posupld Staging Rej-003-EDGE	Svc	Svc Posupld Staging Rej-003-EDGE	S	S	Svc Posupl	Svc Posupl	Svc Posupld Staging Rej-003-EDGE	Svc Posupld Staging Rej-003-EDGE	Sv	Svc Posupl	Svc Posupl	Svc Posupl	Svc Posupld	Svc Posupld Staging	1000000005	1000000005	Svc Posupld Staging Rej-003-EDGE	5	1000000005	1000000005	Svc Posupld Staging Rej-003-EDGE	5	1000000005	5	5	1000000005

Example values from field definitions

FILE_TYPER: SAMPL
LINE_SEQ_IDR: 1
COL_1: SAMPLE
COL_2: SAMPLE
COL_3: SAMPLE
COL_4: SAMPLE
COL_5: SAMPLE
COL_6: SAMPLE
COL_7: SAMP
COL_8: SAMP
COL_9: SAMP
COL_10: SAMPLE
COL_11: SAMPLE
COL_12: SAMP
COL_13: SAMP
COL_14: SAMPLE
COL_15: SAMPLE
COL_16: SAMP
COL_17: SAMPLE
COL_18: SAMPLE
COL_19: SAMP
COL_20: SAMPLE
COL_21: SAMP
COL_22: SAMPLE
COL_23: S
COL_24: S
COL_25: SAMPLE
COL_26: SAMPLE
COL_27: SAMPLE
COL_28: SAMPLE
COL_29: SA
COL_30: SAMPLE
COL_31: SAMPLE
COL_32: SAMPLE
COL_33: SAMPLE
COL_34: SAMPLE
TTAX_ID: 1
CHUNK_ID: 1
FILENAME: SAMPLE
LOCATION: 1
TDETL_ID: 1
THEAD_ID: 1
ERROR_MSG: SAMPLE
THREAD_VAL: 1
HEAD_DETL_ID: 1
ILS_UPDATE_LOC: 1
SALESPROCESS_LOC: 1
SALES_PROCESS_ID: 1

default

FILE_TYPER: Svc P
LINE_SEQ_IDR: 1000000003
COL_1: Svc Posupld Staging Rej-002-ALT
COL_2: Svc Posupld Staging Rej-002-ALT
COL_3: Svc Posupld Staging Rej-002-ALT
COL_4: Svc Posupld Staging Rej-002-ALT
COL_5: Svc Posupld Staging Rej-002-ALT
COL_6: Svc Posupld Staging Rej-002-ALT
COL_7: Svc
COL_8: Svc
COL_9: Svc
COL_10: Svc Posupld Staging Rej-
COL_11: Svc Posupld Staging Rej-002-ALT
COL_12: Svc
COL_13: Svc
COL_14: Svc Posupld Staging Rej-002-ALT
COL_15: Svc Posupld Stag
COL_16: Svc
COL_17: Svc Posupld Staging Rej-002-ALT
COL_18: Svc Posupld Staging Rej-002-ALT
COL_19: Svc
COL_20: Svc Posupld Staging Rej-002-ALT
COL_21: Svc
COL_22: Svc Posupld Staging Rej-002-ALT
COL_23: S
COL_24: S
COL_25: Svc Posupl
COL_26: Svc Posupl
COL_27: Svc Posupld Staging Rej-002-ALT
COL_28: Svc Posupld Staging Rej-002-ALT
COL_29: Sv
COL_30: Svc Posupl
COL_31: Svc Posupl
COL_32: Svc Posupl
COL_33: Svc Posupld
COL_34: Svc Posupld Staging
TTAX_ID: 1000000003
CHUNK_ID: 1000000003
FILENAME: Svc Posupld Staging Rej-002-ALT
LOCATION: 3
TDETL_ID: 1000000003
THEAD_ID: 1000000003
ERROR_MSG: Svc Posupld Staging Rej-002-ALT
THREAD_VAL: 3
HEAD_DETL_ID: 1000000003
ILS_UPDATE_LOC: 3
SALESPROCESS_LOC: 3
SALES_PROCESS_ID: 1000000003

default

FILE_TYPER: Svc P
LINE_SEQ_IDR: 1000000005
COL_1: Svc Posupld Staging Rej-003-EDGE
COL_2: Svc Posupld Staging Rej-003-EDGE
COL_3: Svc Posupld Staging Rej-003-EDGE
COL_4: Svc Posupld Staging Rej-003-EDGE
COL_5: Svc Posupld Staging Rej-003-EDGE
COL_6: Svc Posupld Staging Rej-003-EDGE
COL_7: Svc
COL_8: Svc
COL_9: Svc
COL_10: Svc Posupld Staging Rej-
COL_11: Svc Posupld Staging Rej-003-EDGE
COL_12: Svc
COL_13: Svc
COL_14: Svc Posupld Staging Rej-003-EDGE
COL_15: Svc Posupld Stag
COL_16: Svc
COL_17: Svc Posupld Staging Rej-003-EDGE
COL_18: Svc Posupld Staging Rej-003-EDGE
COL_19: Svc
COL_20: Svc Posupld Staging Rej-003-EDGE
COL_21: Svc
COL_22: Svc Posupld Staging Rej-003-EDGE
COL_23: S
COL_24: S
COL_25: Svc Posupl
COL_26: Svc Posupl
COL_27: Svc Posupld Staging Rej-003-EDGE
COL_28: Svc Posupld Staging Rej-003-EDGE
COL_29: Sv
COL_30: Svc Posupl
COL_31: Svc Posupl
COL_32: Svc Posupl
COL_33: Svc Posupld
COL_34: Svc Posupld Staging
TTAX_ID: 1000000005
CHUNK_ID: 1000000005
FILENAME: Svc Posupld Staging Rej-003-EDGE
LOCATION: 5
TDETL_ID: 1000000005
THEAD_ID: 1000000005
ERROR_MSG: Svc Posupld Staging Rej-003-EDGE
THREAD_VAL: 5
HEAD_DETL_ID: 1000000005
ILS_UPDATE_LOC: 5
SALESPROCESS_LOC: 5
SALES_PROCESS_ID: 1000000005

Rule Validation Summary

Source Rule Count: 53
Governed Rule Count: 50

All objects