Orddetail (Service Layer)

In Scope

Technical: SVC_ORDDETAIL | ID: OR-ITM-SVC_ORDDETAIL-ORDDETAIL_SERVICE_LAYER

This is the staging table for PO Induction module which is used to temporarily hold data before it is uploaded in the ORDSKU, ORDLOC, ALLOC_HEADER, and ALLOC_DETAIL tables.

See how this object fits into Item Management

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_ORDDETAIL

Field Definitions(5)

Rules & Considerations(38)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	VPN	ITEM	ACTION	DIFF_1	DIFF_2	DIFF_3	DIFF_4	ALLOC_NO	LOCATION	LOC_TYPE	ORDER_NO	REF_ITEM	CREATE_ID	ITEM_DESC	UNIT_COST	RE_APPROVE	CANCEL_CODE	ITEM_PARENT	LAST_UPD_ID	QTY_ORDERED	RELEASE_DATE	DELIVERY_DATE	IN_STORE_DATE	LOCATION_DESC	NON_SCALE_IND	PROCESSING_WH	QTY_CANCELLED	PROCESS$STATUS	SUPP_PACK_SIZE	CREATE_DATETIME	PROCESSING_TYPE	QTY_TRANSFERRED	LATEST_SHIP_DATE	SET_TO_WORKSHEET	LAST_UPD_DATETIME	ORIGIN_COUNTRY_ID	EARLIEST_SHIP_DATE	ESTIMATED_INSTOCK_DATE
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	S	1	SAMPLE	SAMPLE	SAMPLE	1.0000	S	S	SAMPLE	SAMPLE	1.0000	2026-01-01	2026-01-01	2026-01-01	SAMPLE	S	1	1.0000	SAMPLE	1.0000	2026-01-01	S	1.0000	2026-01-01	S	2026-01-01	SAM	2026-01-01	2026-01-01
default	3	1000000003	1000000003	Svc Orddetail-002-ALT	Svc Orddetail-002-ALT	Svc Orddet	Svc Orddet	Svc Orddet	Svc Orddet	Svc Orddet	4	3	W	4	Svc Orddetail-002-ALT	USER	Svc Orddetail-002-ALT	12.5000	N	A	Svc Orddetail-002-ALT	USER	12.5000	2026-01-03	2026-01-03	2026-01-03	Svc Orddetail-002-ALT	N	9003	12.5000	N	12.5000	2026-01-03	S	12.5000	2026-01-03	N	2026-01-03	ALT	2026-01-03	2026-01-03
default	5	1000000005	1000000005	Svc Orddetail-003-EDGE	Svc Orddetail-003-EDGE	Svc Orddet	Svc Orddet	Svc Orddet	Svc Orddet	Svc Orddet	6	5	S	6	Svc Orddetail-003-EDGE	USER	Svc Orddetail-003-EDGE	14.0000	N	E	Svc Orddetail-003-EDGE	USER	14.0000	2026-01-05	2026-01-05	2026-01-05	Svc Orddetail-003-EDGE	Y	9005	14.0000	N	14.0000	2026-01-05	S	14.0000	2026-01-05	N	2026-01-05	EDG	2026-01-05	2026-01-05

Example values from field definitions

ROW_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
VPN: SAMPLE
ITEM: SAMPLE
ACTION: SAMPLE
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
ALLOC_NO: 1
LOCATION: 1
LOC_TYPE: S
ORDER_NO: 1
REF_ITEM: SAMPLE
CREATE_ID: SAMPLE
ITEM_DESC: SAMPLE
UNIT_COST: 1.0000
RE_APPROVE: S
CANCEL_CODE: S
ITEM_PARENT: SAMPLE
LAST_UPD_ID: SAMPLE
QTY_ORDERED: 1.0000
RELEASE_DATE: 2026-01-01
DELIVERY_DATE: 2026-01-01
IN_STORE_DATE: 2026-01-01
LOCATION_DESC: SAMPLE
NON_SCALE_IND: S
PROCESSING_WH: 1
QTY_CANCELLED: 1.0000
PROCESS$STATUS: SAMPLE
SUPP_PACK_SIZE: 1.0000
CREATE_DATETIME: 2026-01-01
PROCESSING_TYPE: S
QTY_TRANSFERRED: 1.0000
LATEST_SHIP_DATE: 2026-01-01
SET_TO_WORKSHEET: S
LAST_UPD_DATETIME: 2026-01-01
ORIGIN_COUNTRY_ID: SAM
EARLIEST_SHIP_DATE: 2026-01-01
ESTIMATED_INSTOCK_DATE: 2026-01-01

default

ROW_SEQRPK: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
VPN: Svc Orddetail-002-ALT
ITEM: Svc Orddetail-002-ALT
ACTION: Svc Orddet
DIFF_1: Svc Orddet
DIFF_2: Svc Orddet
DIFF_3: Svc Orddet
DIFF_4: Svc Orddet
ALLOC_NO: 4
LOCATION: 3
LOC_TYPE: W
ORDER_NO: 4
REF_ITEM: Svc Orddetail-002-ALT
CREATE_ID: USER
ITEM_DESC: Svc Orddetail-002-ALT
UNIT_COST: 12.5000
RE_APPROVE: N
CANCEL_CODE: A
ITEM_PARENT: Svc Orddetail-002-ALT
LAST_UPD_ID: USER
QTY_ORDERED: 12.5000
RELEASE_DATE: 2026-01-03
DELIVERY_DATE: 2026-01-03
IN_STORE_DATE: 2026-01-03
LOCATION_DESC: Svc Orddetail-002-ALT
NON_SCALE_IND: N
PROCESSING_WH: 9003
QTY_CANCELLED: 12.5000
PROCESS$STATUS: N
SUPP_PACK_SIZE: 12.5000
CREATE_DATETIME: 2026-01-03
PROCESSING_TYPE: S
QTY_TRANSFERRED: 12.5000
LATEST_SHIP_DATE: 2026-01-03
SET_TO_WORKSHEET: N
LAST_UPD_DATETIME: 2026-01-03
ORIGIN_COUNTRY_ID: ALT
EARLIEST_SHIP_DATE: 2026-01-03
ESTIMATED_INSTOCK_DATE: 2026-01-03