Allocation Template
In ScopeTechnical: 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)
| _scenario | USER_TYPER | TEMPLATE_IDRPK | CREATED_DATER | TEMPLATE_NAMER | TEMPLATE_TYPER | CREATED_BY | LAST_UPDATED_BY | LAST_APPLIED_DATE | LAST_UPDATED_DATE | OBJECT_VERSION_NUMBER | NEVER_UPDATE_GROUP_IND | ENFORCE_WH_STORE_REL_IND | LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | 1 | 2026-01-01 | SAMPLE | S | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 12:00:00.000000 | 1 | S | S | SAMPLE |
| default | A | 1000000003 | 2026-01-03 | Alc Template Secondary | L | Alc Template-002-ALT | — | 2026-01-03 | — | 3 | y | y | 2026-01-02-ALT |
| default | A | 1000000005 | 2026-01-05 | Alc Template Core | L | Alc Template-003-EDGE | — | 2026-01-05 | — | 5 | N | y | 2026-01-03-EDGE |
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