Actual Landed Cost Load (Temporary)
Out of ScopeTechnical: ALC_LOAD_TEMP | ID: OR-ALLOC-ALC_LOAD_TEMP-ALC_LOAD_TEMP
This table is used during the Allocation load process. The ALC_LOAD_ITEM_SOURCE PLSQL package gathers information into this table that is in turn loaded into Java.
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
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- ALC_LOAD_TEMP
Field Definitions(5)
Rules & Considerations(56)
Sample Load Data(4)
| _scenario | HI | TI | WH | DEPT | ITEM | CLASS | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | DOC_NO | TSR_IND | ALLOC_ID | PACK_IND | SUBCLASS | AVAIL_QTY | DEPT_NAME | ITEM_DESC | ITEM_TYPE | CLASS_NAME | IMAGE_ADDR | IMAGE_NAME | ITEM_LEVEL | PACK_ROUND | PROPORTION | TRAN_LEVEL | DIFF_1_DESC | DIFF_2_DESC | DIFF_3_DESC | DIFF_4_DESC | ITEM_PARENT | ON_HAND_QTY | QTY_ORDERED | SOURCE_TYPE | RELEASE_DATE | SELLABLE_IND | BACKORDER_QTY | CALC_MULTIPLE | DEFAULT_LEVEL | MIN_AVAIL_QTY | SUBCLASS_NAME | BREAK_PACK_IND | ITEM_SOURCE_ID | SUPP_PACK_SIZE | HOLD_BACK_VALUE | INNER_PACK_SIZE | ITEM_GRANDPARENT | ITEM_PARENT_DESC | PO_NOT_AFTER_DATE | THRESHOLD_PERCENT | FUTURE_ON_HAND_QTY | HOLD_BACK_PCT_FLAG | ITEM_AGGREGATE_IND | DIFF_1_AGGREGATE_IND | DIFF_2_AGGREGATE_IND | DIFF_3_AGGREGATE_IND | DIFF_4_AGGREGATE_IND | SELLPACK_FASHION_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1.0000 | 1 | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | S | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.000 | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1 | 2026-01-01 | S | 1.0000 | SA | S | 1.0000 | SAMPLE | S | 1 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | 2026-01-01 | 1.00 | 1.0000 | S | S | S | S | S | S | S |
| default | 12.5000 | 12.5000 | 9003 | 1003 | Alc Load Temp-002-ALT | 1103 | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | N | 1000000003 | A | 1113 | 12.5000 | Footwear | Alc Load Temp-002-ALT | Alc Load T | Womenswear | Alc Load Temp-002-ALT | Alc Load Temp Secondary | 3 | 12.500 | 12.5000 | 3 | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | 12.5000 | 12.5000 | 3 | 2026-01-03 | A | 12.5000 | Al | A | 12.5000 | Fashion Range | A | 1000000003 | 12.5000 | 12.5000 | 12.5000 | Alc Load Temp-002-ALT | Alc Load Temp-002-ALT | 2026-01-03 | 12.50 | 12.5000 | A | A | A | A | A | A | A |
| default | 14.0000 | 14.0000 | 9005 | 1005 | Alc Load Temp-003-EDGE | 1105 | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | N | 1000000005 | A | 1115 | 14.0000 | Beauty | Alc Load Temp-003-EDGE | Alc Load T | Kidswear | Alc Load Temp-003-EDGE | Alc Load Temp Core | 5 | 14.000 | 14.0000 | 5 | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | 14.0000 | 14.0000 | 5 | 2026-01-05 | A | 14.0000 | Al | A | 14.0000 | Value Range | A | 1000000005 | 14.0000 | 14.0000 | 14.0000 | Alc Load Temp-003-EDGE | Alc Load Temp-003-EDGE | 2026-01-05 | 14.00 | 14.0000 | A | A | A | A | A | A | A |
Example values from field definitions
- HI
- 1.0000
- TI
- 1.0000
- WH
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- DOC_NO
- SAMPLE
- TSR_IND
- S
- ALLOC_ID
- 1
- PACK_IND
- S
- SUBCLASS
- 1
- AVAIL_QTY
- 1.0000
- DEPT_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- ITEM_TYPE
- SAMPLE
- CLASS_NAME
- SAMPLE
- IMAGE_ADDR
- SAMPLE
- IMAGE_NAME
- SAMPLE
- ITEM_LEVEL
- 1
- PACK_ROUND
- 1.000
- PROPORTION
- 1.0000
- TRAN_LEVEL
- 1
- DIFF_1_DESC
- SAMPLE
- DIFF_2_DESC
- SAMPLE
- DIFF_3_DESC
- SAMPLE
- DIFF_4_DESC
- SAMPLE
- ITEM_PARENT
- SAMPLE
- ON_HAND_QTY
- 1.0000
- QTY_ORDERED
- 1.0000
- SOURCE_TYPE
- 1
- RELEASE_DATE
- 2026-01-01
- SELLABLE_IND
- S
- BACKORDER_QTY
- 1.0000
- CALC_MULTIPLE
- SA
- DEFAULT_LEVEL
- S
- MIN_AVAIL_QTY
- 1.0000
- SUBCLASS_NAME
- SAMPLE
- BREAK_PACK_IND
- S
- ITEM_SOURCE_ID
- 1
- SUPP_PACK_SIZE
- 1.0000
- HOLD_BACK_VALUE
- 1.0000
- INNER_PACK_SIZE
- 1.0000
- ITEM_GRANDPARENT
- SAMPLE
- ITEM_PARENT_DESC
- SAMPLE
- PO_NOT_AFTER_DATE
- 2026-01-01
- THRESHOLD_PERCENT
- 1.00
- FUTURE_ON_HAND_QTY
- 1.0000
- HOLD_BACK_PCT_FLAG
- S
- ITEM_AGGREGATE_IND
- S
- DIFF_1_AGGREGATE_IND
- S
- DIFF_2_AGGREGATE_IND
- S
- DIFF_3_AGGREGATE_IND
- S
- DIFF_4_AGGREGATE_IND
- S
- SELLPACK_FASHION_IND
- S
default
- HI
- 12.5000
- TI
- 12.5000
- WH
- 9003
- DEPT
- 1003
- ITEM
- Alc Load Temp-002-ALT
- CLASS
- 1103
- DIFF_1
- Alc Load Temp-002-ALT
- DIFF_2
- Alc Load Temp-002-ALT
- DIFF_3
- Alc Load Temp-002-ALT
- DIFF_4
- Alc Load Temp-002-ALT
- DOC_NO
- Alc Load Temp-002-ALT
- TSR_IND
- N
- ALLOC_ID
- 1000000003
- PACK_IND
- A
- SUBCLASS
- 1113
- AVAIL_QTY
- 12.5000
- DEPT_NAME
- Footwear
- ITEM_DESC
- Alc Load Temp-002-ALT
- ITEM_TYPE
- Alc Load T
- CLASS_NAME
- Womenswear
- IMAGE_ADDR
- Alc Load Temp-002-ALT
- IMAGE_NAME
- Alc Load Temp Secondary
- ITEM_LEVEL
- 3
- PACK_ROUND
- 12.500
- PROPORTION
- 12.5000
- TRAN_LEVEL
- 3
- DIFF_1_DESC
- Alc Load Temp-002-ALT
- DIFF_2_DESC
- Alc Load Temp-002-ALT
- DIFF_3_DESC
- Alc Load Temp-002-ALT
- DIFF_4_DESC
- Alc Load Temp-002-ALT
- ITEM_PARENT
- Alc Load Temp-002-ALT
- ON_HAND_QTY
- 12.5000
- QTY_ORDERED
- 12.5000
- SOURCE_TYPE
- 3
- RELEASE_DATE
- 2026-01-03
- SELLABLE_IND
- A
- BACKORDER_QTY
- 12.5000
- CALC_MULTIPLE
- Al
- DEFAULT_LEVEL
- A
- MIN_AVAIL_QTY
- 12.5000
- SUBCLASS_NAME
- Fashion Range
- BREAK_PACK_IND
- A
- ITEM_SOURCE_ID
- 1000000003
- SUPP_PACK_SIZE
- 12.5000
- HOLD_BACK_VALUE
- 12.5000
- INNER_PACK_SIZE
- 12.5000
- ITEM_GRANDPARENT
- Alc Load Temp-002-ALT
- ITEM_PARENT_DESC
- Alc Load Temp-002-ALT
- PO_NOT_AFTER_DATE
- 2026-01-03
- THRESHOLD_PERCENT
- 12.50
- FUTURE_ON_HAND_QTY
- 12.5000
- HOLD_BACK_PCT_FLAG
- A
- ITEM_AGGREGATE_IND
- A
- DIFF_1_AGGREGATE_IND
- A
- DIFF_2_AGGREGATE_IND
- A
- DIFF_3_AGGREGATE_IND
- A
- DIFF_4_AGGREGATE_IND
- A
- SELLPACK_FASHION_IND
- A
default
- HI
- 14.0000
- TI
- 14.0000
- WH
- 9005
- DEPT
- 1005
- ITEM
- Alc Load Temp-003-EDGE
- CLASS
- 1105
- DIFF_1
- Alc Load Temp-003-EDGE
- DIFF_2
- Alc Load Temp-003-EDGE
- DIFF_3
- Alc Load Temp-003-EDGE
- DIFF_4
- Alc Load Temp-003-EDGE
- DOC_NO
- Alc Load Temp-003-EDGE
- TSR_IND
- N
- ALLOC_ID
- 1000000005
- PACK_IND
- A
- SUBCLASS
- 1115
- AVAIL_QTY
- 14.0000
- DEPT_NAME
- Beauty
- ITEM_DESC
- Alc Load Temp-003-EDGE
- ITEM_TYPE
- Alc Load T
- CLASS_NAME
- Kidswear
- IMAGE_ADDR
- Alc Load Temp-003-EDGE
- IMAGE_NAME
- Alc Load Temp Core
- ITEM_LEVEL
- 5
- PACK_ROUND
- 14.000
- PROPORTION
- 14.0000
- TRAN_LEVEL
- 5
- DIFF_1_DESC
- Alc Load Temp-003-EDGE
- DIFF_2_DESC
- Alc Load Temp-003-EDGE
- DIFF_3_DESC
- Alc Load Temp-003-EDGE
- DIFF_4_DESC
- Alc Load Temp-003-EDGE
- ITEM_PARENT
- Alc Load Temp-003-EDGE
- ON_HAND_QTY
- 14.0000
- QTY_ORDERED
- 14.0000
- SOURCE_TYPE
- 5
- RELEASE_DATE
- 2026-01-05
- SELLABLE_IND
- A
- BACKORDER_QTY
- 14.0000
- CALC_MULTIPLE
- Al
- DEFAULT_LEVEL
- A
- MIN_AVAIL_QTY
- 14.0000
- SUBCLASS_NAME
- Value Range
- BREAK_PACK_IND
- A
- ITEM_SOURCE_ID
- 1000000005
- SUPP_PACK_SIZE
- 14.0000
- HOLD_BACK_VALUE
- 14.0000
- INNER_PACK_SIZE
- 14.0000
- ITEM_GRANDPARENT
- Alc Load Temp-003-EDGE
- ITEM_PARENT_DESC
- Alc Load Temp-003-EDGE
- PO_NOT_AFTER_DATE
- 2026-01-05
- THRESHOLD_PERCENT
- 14.00
- FUTURE_ON_HAND_QTY
- 14.0000
- HOLD_BACK_PCT_FLAG
- A
- ITEM_AGGREGATE_IND
- A
- DIFF_1_AGGREGATE_IND
- A
- DIFF_2_AGGREGATE_IND
- A
- DIFF_3_AGGREGATE_IND
- A
- DIFF_4_AGGREGATE_IND
- A
- SELLPACK_FASHION_IND
- A
Rule Validation Summary
- Source Rule Count
- 64
- Governed Rule Count
- 56