Stage Data For Allocations

In Scope

Technical: ALC_SVC_ALLOC | ID: OR-ALLOC-ALC_SVC_ALLOC-ACTUAL_LANDED_COST_SERVICE_ALLOCATION

Stores stage data for allocations.

See how this object fits into Allocations

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: ALC_SVC_ALLOC

Field Definitions(5)

Rules & Considerations(28)

Sample Load Data(4)

_scenario	TYPE	ACTION	ROW_ID	STATUS	CONTEXT	ALLOC_ID	ERROR_MSG	PARENT_ID	PROMOTION	ALLOC_DESC	EXT_REF_ID	PROMO_DESC	RELEASE_DATE	WORKSPACE_ID	ALLOC_COMMENT	PROCESS$STATUS	PROCESS_STATUS	PARENT_ALLOCATION	MLD_APPROVAL_LEVEL	MLD_MODIFIED_LEVEL	RULE_TEMPLATE_NAME	AUTO_QTY_LIMITS_IND	DEAGGREGATED_FASHION	LOCATION_TEMPLATE_NAME	NEVER_UPDATE_GROUP_IND	ENFORCE_WH_STORE_REL_IND	NON_SELL_FASHION_PACK_ONL	RELEASE_DATE_FROM_IN_STORE_IND
Example values from field definitions	SAMPL	SAMPLE	1	SA	SAMPLE	1	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	SAMPLE	SAMPLE	ACTIVE	S	SA	SA	SAMPLE	S	S	SAMPLE	S	S	SA	S
default	SA	Alc Svc Al	100003	PE	Alc Svc Al	1000000003	Alc Svc Alloc-002-ALT	1000000003	3	Alc Svc Alloc-002-ALT	ALT-ALC_SVC-002	Alc Svc Alloc-002-ALT	2026-01-03	1000000003	Alc Svc Alloc-002-ALT	PENDING-AL	PENDING-ALT	A	Al	Al	Alc Svc Alloc Secondary	N	A	Alc Svc Alloc Secondary	N	A	N	2
default	SA	Alc Svc Al	100005	AC	Alc Svc Al	1000000005	Alc Svc Alloc-003-EDGE	1000000005	5	Alc Svc Alloc-003-EDGE	EDGE-ALC_SVC-003	Alc Svc Alloc-003-EDGE	2026-01-05	1000000005	Alc Svc Alloc-003-EDGE	ACTIVE-EDG	ACTIVE-EDGE	A	Al	Al	Alc Svc Alloc Core	N	A	Alc Svc Alloc Core	N	A	N	2

Example values from field definitions

TYPE: SAMPL
ACTION: SAMPLE
ROW_ID: 1
STATUS: SA
CONTEXT: SAMPLE
ALLOC_ID: 1
ERROR_MSG: SAMPLE
PARENT_ID: 1
PROMOTION: 1
ALLOC_DESC: SAMPLE
EXT_REF_ID: SAMPLE
PROMO_DESC: SAMPLE
RELEASE_DATE: 2026-01-01
WORKSPACE_ID: 1
ALLOC_COMMENT: SAMPLE
PROCESS$STATUS: SAMPLE
PROCESS_STATUS: ACTIVE
PARENT_ALLOCATION: S
MLD_APPROVAL_LEVEL: SA
MLD_MODIFIED_LEVEL: SA
RULE_TEMPLATE_NAME: SAMPLE
AUTO_QTY_LIMITS_IND: S
DEAGGREGATED_FASHION: S
LOCATION_TEMPLATE_NAME: SAMPLE
NEVER_UPDATE_GROUP_IND: S
ENFORCE_WH_STORE_REL_IND: S
NON_SELL_FASHION_PACK_ONL: SA
RELEASE_DATE_FROM_IN_STORE_IND: S

default

TYPE: SA
ACTION: Alc Svc Al
ROW_ID: 100003
STATUS: PE
CONTEXT: Alc Svc Al
ALLOC_ID: 1000000003
ERROR_MSG: Alc Svc Alloc-002-ALT
PARENT_ID: 1000000003
PROMOTION: 3
ALLOC_DESC: Alc Svc Alloc-002-ALT
EXT_REF_ID: ALT-ALC_SVC-002
PROMO_DESC: Alc Svc Alloc-002-ALT
RELEASE_DATE: 2026-01-03
WORKSPACE_ID: 1000000003
ALLOC_COMMENT: Alc Svc Alloc-002-ALT
PROCESS$STATUS: PENDING-AL
PROCESS_STATUS: PENDING-ALT
PARENT_ALLOCATION: A
MLD_APPROVAL_LEVEL: Al
MLD_MODIFIED_LEVEL: Al
RULE_TEMPLATE_NAME: Alc Svc Alloc Secondary
AUTO_QTY_LIMITS_IND: N
DEAGGREGATED_FASHION: A
LOCATION_TEMPLATE_NAME: Alc Svc Alloc Secondary
NEVER_UPDATE_GROUP_IND: N
ENFORCE_WH_STORE_REL_IND: A
NON_SELL_FASHION_PACK_ONL: N
RELEASE_DATE_FROM_IN_STORE_IND: 2

default

TYPE: SA
ACTION: Alc Svc Al
ROW_ID: 100005
STATUS: AC
CONTEXT: Alc Svc Al
ALLOC_ID: 1000000005
ERROR_MSG: Alc Svc Alloc-003-EDGE
PARENT_ID: 1000000005
PROMOTION: 5
ALLOC_DESC: Alc Svc Alloc-003-EDGE
EXT_REF_ID: EDGE-ALC_SVC-003
PROMO_DESC: Alc Svc Alloc-003-EDGE
RELEASE_DATE: 2026-01-05
WORKSPACE_ID: 1000000005
ALLOC_COMMENT: Alc Svc Alloc-003-EDGE
PROCESS$STATUS: ACTIVE-EDG
PROCESS_STATUS: ACTIVE-EDGE
PARENT_ALLOCATION: A
MLD_APPROVAL_LEVEL: Al
MLD_MODIFIED_LEVEL: Al
RULE_TEMPLATE_NAME: Alc Svc Alloc Core
AUTO_QTY_LIMITS_IND: N
DEAGGREGATED_FASHION: A
LOCATION_TEMPLATE_NAME: Alc Svc Alloc Core
NEVER_UPDATE_GROUP_IND: N
ENFORCE_WH_STORE_REL_IND: A
NON_SELL_FASHION_PACK_ONL: N
RELEASE_DATE_FROM_IN_STORE_IND: 2

Rule Validation Summary

Source Rule Count: 42
Governed Rule Count: 28