Allocation Template

In Scope

Technical: ALC_TEMPLATE | ID: OR-ALLOC-ALC_TEMPLATE-ACTUAL_LANDED_COST_TEMPLATE

Stores information for the Rule or Location Templates created.

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_TEMPLATE

Field Definitions(5)

Rules & Considerations(18)

constraint

validation

Sample Load Data(4)

Example values from field definitions

USER_TYPER
S
TEMPLATE_IDRPK
1
CREATED_DATER
2026-01-01
TEMPLATE_NAMER
SAMPLE
TEMPLATE_TYPER
S
CREATED_BY
SAMPLE
LAST_UPDATED_BY
SAMPLE
LAST_APPLIED_DATE
2026-01-01
LAST_UPDATED_DATE
2026-01-01 12:00:00.000000
OBJECT_VERSION_NUMBER
1
NEVER_UPDATE_GROUP_IND
S
ENFORCE_WH_STORE_REL_IND
S
LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
SAMPLE

default

USER_TYPER
A
TEMPLATE_IDRPK
1000000003
CREATED_DATER
2026-01-03
TEMPLATE_NAMER
Alc Template Secondary
TEMPLATE_TYPER
L
CREATED_BY
Alc Template-002-ALT
LAST_UPDATED_BY
LAST_APPLIED_DATE
2026-01-03
LAST_UPDATED_DATE
OBJECT_VERSION_NUMBER
3
NEVER_UPDATE_GROUP_IND
y
ENFORCE_WH_STORE_REL_IND
y
LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
2026-01-02-ALT

default

USER_TYPER
A
TEMPLATE_IDRPK
1000000005
CREATED_DATER
2026-01-05
TEMPLATE_NAMER
Alc Template Core
TEMPLATE_TYPER
L
CREATED_BY
Alc Template-003-EDGE
LAST_UPDATED_BY
LAST_APPLIED_DATE
2026-01-05
LAST_UPDATED_DATE
OBJECT_VERSION_NUMBER
5
NEVER_UPDATE_GROUP_IND
N
ENFORCE_WH_STORE_REL_IND
y
LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
2026-01-03-EDGE

Rule Validation Summary

Source Rule Count
30
Governed Rule Count
18