Posupld Load (Service Layer)

In Scope

Technical: SVC_POSUPLD_LOAD | ID: OR-FND-SVC_POSUPLD_LOAD-POSUPLD_LOAD_SERVICE_LAYER

Table where raw POSU file is uploaded. This is populated through the uploadsales.ksh script.

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_LOAD

Field Definitions(5)

Rules & Considerations(13)

constraint

validation

Sample Load Data(4)

_scenario	LINE_IDR	FILE_TYPER	LINE_TEXTR	LINE_SEQ_IDR	FILENAME	ERROR_MSG	THREAD_VAL	POS_TRAN_ID	SALES_PROCESS_ID
Example values from field definitions	1	SAMPL	SAMPLE	1	SAMPLE	SAMPLE	1	1	1
default	1000000003	Svc P	Svc Posupld Load-002-ALT	1000000003	Svc Posupld Load-002-ALT	Svc Posupld Load-002-ALT	3	1000000003	1000000003
default	1000000005	Svc P	Svc Posupld Load-003-EDGE	1000000005	Svc Posupld Load-003-EDGE	Svc Posupld Load-003-EDGE	5	1000000005	1000000005

Example values from field definitions

LINE_IDR: 1
FILE_TYPER: SAMPL
LINE_TEXTR: SAMPLE
LINE_SEQ_IDR: 1
FILENAME: SAMPLE
ERROR_MSG: SAMPLE
THREAD_VAL: 1
POS_TRAN_ID: 1
SALES_PROCESS_ID: 1

default

LINE_IDR: 1000000003
FILE_TYPER: Svc P
LINE_TEXTR: Svc Posupld Load-002-ALT
LINE_SEQ_IDR: 1000000003
FILENAME: Svc Posupld Load-002-ALT
ERROR_MSG: Svc Posupld Load-002-ALT
THREAD_VAL: 3
POS_TRAN_ID: 1000000003
SALES_PROCESS_ID: 1000000003

default

LINE_IDR: 1000000005
FILE_TYPER: Svc P
LINE_TEXTR: Svc Posupld Load-003-EDGE
LINE_SEQ_IDR: 1000000005
FILENAME: Svc Posupld Load-003-EDGE
ERROR_MSG: Svc Posupld Load-003-EDGE
THREAD_VAL: 5
POS_TRAN_ID: 1000000005
SALES_PROCESS_ID: 1000000005

Rule Validation Summary

Source Rule Count: 16
Governed Rule Count: 13