Posupld Line Item (Service Layer GTT)

Out of Scope

Technical: SVC_POSUPLD_LINE_ITEM_GTT | ID: OR-ITM-SVC_POSUPLD_LINE_ITEM_GTT-SVC_POSUPLD_LINE_ITEM_GTT

Stores a row for each THEAD line with lookups for data related to the input record. It also holds some aggregation values, for example totals across the TDETL lines that...

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
gtt

Target Structure

Load Approach
Table
Target Objects
SVC_POSUPLD_LINE_ITEM_GTT

Field Definitions(5)

Rules & Considerations(130)

constraint

validation

Sample Load Data(4)

Example values from field definitions

CHUNK_IDR
1
SALES_THEAD_IDR
1
SALES_PROCESS_IDR
1
POSUPLD_LINE_ITEM_IDR
1
FDATE
2026-01-01
IM_DEPT
1
IM_ITEM
SAMPLE
PACK_NO
SAMPLE
EOM_DATE
2026-01-01
EOW_DATE
2026-01-01
IM_CLASS
1
PACK_QTY
1.0000
ERROR_MSG
SAMPLE
IL_STATUS
S
IM_STATUS
S
ITEM_TYPE
SAM
LOC_VALUE
1
RETURN_WH
SAMPLE
SALES_QTY
1.0000
TRAN_DATE
2026-01-01
UOM_RATIO
1.000000
GTAX_VALUE
1.0000
ITEM_VALUE
SAMPLE
ORIG_STORE
1
SALES_TYPE
S
SUPS_TERMS
SAMPLE
VI_VAT_AMT
1.0000
CUM_TAX_PCT
1.0000
ILS_AV_COST
1.0000
IM_PACK_IND
S
IM_REF_ITEM
SAMPLE
IM_SUBCLASS
1
IS_SUPPLIER
1
PH_PROM_IND
S
POS_TRAN_ID
1
SALES_VALUE
1.0000
SELLING_UOM
SAMP
VI_VAT_CODE
SAMPLE
VI_VAT_RATE
1.0000000000
DROPSHIP_IND
S
IM_WASTE_PCT
1.000000
INVENTORY_ID
SAMPLE
PH_CLEAR_IND
S
CUM_TAX_VALUE
1.0000000000
CW_NOMINAL_WT
1.0000
ILS_UNIT_COST
1.0000
IM_ITEM_LEVEL
1
IM_TRAN_LEVEL
1
IM_WASTE_TYPE
SAMPLE
PACK_COMP_IND
S
PH_REG_RETAIL
1.000000
ST_STORE_TYPE
SAMPLE
ST_VAT_REGION
1
TERMS_DUEDAYS
1
TERMS_PERCENT
1.0000
TRAN_TYPE_NUM
1
FULFILL_LOC_ID
1
ILS_UPDATE_LOC
1
IL_UNIT_RETAIL
1.000000
NO_INV_RET_IND
S
PACK_COMP_ITEM
SAMPLE
PH_CURR_RETAIL
1.000000
PH_PROM_RETAIL
1.000000
SALES_SIGN_NUM
1
TRAN_TYPE_CHAR
S
CATCHWEIGHT_IND
S
GTAX_UNIT_VALUE
1.0000
IL_PRIMARY_SUPP
1
IM_SELLABLE_IND
S
IM_STANDARD_UOM
SAMP
RESA_SALES_TYPE
S
SALES_SIGN_CHAR
S
XFORM_YIELD_PCT
1.0000
ACTUALWEIGHT_QTY
1.0000
CONSIGNMENT_RATE
1.0000
FULFILL_LOC_TYPE
SA
FULFILL_ORDER_NO
SAMPLE
IL_PRIMARY_CNTRY
SAM
IM_INVENTORY_IND
S
IM_ORDERABLE_IND
S
NEW_ITEM_LOC_IND
S
PACK_PRICE_RATIO
1.0000000000
ST_CURRENCY_CODE
SAM
SUPS_RET_COURIER
SAMPLE
CUSTOMER_ORDER_NO
SAMPLE
EOM_DATE_454_WEEK
1
EOM_DATE_454_YEAR
1
EOW_DATE_454_WEEK
1
EOW_DATE_454_YEAR
1
IM_ITEM_XFORM_IND
S
SALES_QTY_STD_UOM
1.0000
SELLING_UOM_CLASS
SAMPLE
SUBTRANS_TYPE_IND
S
SUPS_HANDLING_PCT
1.0000
TOTAL_AV_COST_LOC
1.000000
TOTAL_WASTAGE_QTY
1.0000
DEPS_PURCHASE_TYPE
1
EOM_DATE_454_MONTH
1
EOW_DATE_454_MONTH
1
ILS_AVERAGE_WEIGHT
1.0000
ISCL_PURCHASE_RATE
1.0000
ISCL_PURCHASE_TYPE
1
IS_CONCESSION_RATE
1.0000
LAST_MODIFIED_DATE
2026-01-01
ORDER_PLACED_STORE
1
RETURN_DISPOSITION
SAMPLE
ST_VAT_INCLUDE_IND
S
SUPS_CURRENCY_CODE
SAM
SUPS_RET_ALLOW_IND
S
CLASS_CLASS_VAT_IND
S
IS_CONSIGNMENT_RATE
1.0000
OLD_RETAIL_WITH_VAT
1.000000
ST_CURRENCY_RTL_DEC
1
TOTAL_UNIT_COST_LOC
1.000000
XFORM_PROD_LOSS_PCT
1.0000
XFORM_SELLABLE_ITEM
SAMPLE
IM_DEPOSIT_ITEM_TYPE
SAMPLE
SALES_VALUE_WITH_VAT
1.000000
ST_CURRENCY_COST_DEC
1
WASTAGE_AMT_WITH_VAT
1.000000
CONSIGNMENT_UNIT_COST
1.0000
ISCL_CALCULATION_BASIS
S
OLD_RETAIL_WITHOUT_VAT
1.000000
SALES_VALUE_WITHOUT_VAT
1.000000
SUPS_AUTO_APPR_INVC_IND
S
SUPS_EDI_SALES_RPT_FREQ
S
WASTAGE_AMT_WITHOUT_VAT
1.000000
ILS_LAST_HIST_EXPORT_DATE
2026-01-01
INVENTORY_IDENTIFIER_TYPE
SAMPLE
XFORM_ORDERABLE_UNIT_COST
1.000000
ACTUALWGHT_RETAIL_WITH_VAT
1.000000
ACTUALWGHT_RETAIL_WITHOUT_VAT
1.000000

default

CHUNK_IDR
1000000003
SALES_THEAD_IDR
1000000003
SALES_PROCESS_IDR
1000000003
POSUPLD_LINE_ITEM_IDR
1000000003
FDATE
2026-01-03
IM_DEPT
1003
IM_ITEM
Svc Posupld Line Item Gtt
PACK_NO
Svc Posupld Line Item Gtt
EOM_DATE
2026-01-03
EOW_DATE
2026-01-03
IM_CLASS
1103
PACK_QTY
12.5000
ERROR_MSG
Svc Posupld Line Item Gtt-002-ALT
IL_STATUS
P
IM_STATUS
P
ITEM_TYPE
Svc
LOC_VALUE
3
RETURN_WH
Svc Posupl
SALES_QTY
12.5000
TRAN_DATE
2026-01-03
UOM_RATIO
12.500000
GTAX_VALUE
12.5000
ITEM_VALUE
Svc Posupld Line Item Gtt
ORIG_STORE
1003
SALES_TYPE
S
SUPS_TERMS
Svc Posupld Lin
VI_VAT_AMT
12.5000
CUM_TAX_PCT
12.5000
ILS_AV_COST
12.5000
IM_PACK_IND
S
IM_REF_ITEM
Svc Posupld Line Item Gtt
IM_SUBCLASS
1113
IS_SUPPLIER
3
PH_PROM_IND
S
POS_TRAN_ID
1000000003
SALES_VALUE
12.5000
SELLING_UOM
Svc
VI_VAT_CODE
ALT-SV
VI_VAT_RATE
12.5000000000
DROPSHIP_IND
S
IM_WASTE_PCT
12.500000
INVENTORY_ID
ALT-SVC_POSUPL-002
PH_CLEAR_IND
S
CUM_TAX_VALUE
12.5000000000
CW_NOMINAL_WT
12.5000
ILS_UNIT_COST
12.5000
IM_ITEM_LEVEL
3
IM_TRAN_LEVEL
3
IM_WASTE_TYPE
Svc Po
PACK_COMP_IND
S
PH_REG_RETAIL
12.500000
ST_STORE_TYPE
Svc Po
ST_VAT_REGION
203
TERMS_DUEDAYS
3
TERMS_PERCENT
12.5000
TRAN_TYPE_NUM
4
FULFILL_LOC_ID
1000000003
ILS_UPDATE_LOC
3
IL_UNIT_RETAIL
12.500000
NO_INV_RET_IND
S
PACK_COMP_ITEM
Svc Posupld Line Item Gtt
PH_CURR_RETAIL
12.500000
PH_PROM_RETAIL
12.500000
SALES_SIGN_NUM
4
TRAN_TYPE_CHAR
S
CATCHWEIGHT_IND
S
GTAX_UNIT_VALUE
12.5000
IL_PRIMARY_SUPP
3
IM_SELLABLE_IND
S
IM_STANDARD_UOM
Svc
RESA_SALES_TYPE
S
SALES_SIGN_CHAR
S
XFORM_YIELD_PCT
12.5000
ACTUALWEIGHT_QTY
12.5000
CONSIGNMENT_RATE
12.5000
FULFILL_LOC_TYPE
WH
FULFILL_ORDER_NO
Svc Posupld Line Item Gtt-002-ALT
IL_PRIMARY_CNTRY
Svc
IM_INVENTORY_IND
S
IM_ORDERABLE_IND
S
NEW_ITEM_LOC_IND
S
PACK_PRICE_RATIO
12.5000000000
ST_CURRENCY_CODE
ALT
SUPS_RET_COURIER
Svc Posupld Line Item Gtt-002-ALT
CUSTOMER_ORDER_NO
Svc Posupld Line Item Gtt-002-ALT
EOM_DATE_454_WEEK
3
EOM_DATE_454_YEAR
3
EOW_DATE_454_WEEK
3
EOW_DATE_454_YEAR
3
IM_ITEM_XFORM_IND
S
SALES_QTY_STD_UOM
12.5000
SELLING_UOM_CLASS
Svc Po
SUBTRANS_TYPE_IND
S
SUPS_HANDLING_PCT
12.5000
TOTAL_AV_COST_LOC
12.500000
TOTAL_WASTAGE_QTY
12.5000
DEPS_PURCHASE_TYPE
3
EOM_DATE_454_MONTH
3
EOW_DATE_454_MONTH
3
ILS_AVERAGE_WEIGHT
12.5000
ISCL_PURCHASE_RATE
12.5000
ISCL_PURCHASE_TYPE
1
IS_CONCESSION_RATE
12.5000
LAST_MODIFIED_DATE
2026-01-03
ORDER_PLACED_STORE
1003
RETURN_DISPOSITION
Svc Posupl
ST_VAT_INCLUDE_IND
S
SUPS_CURRENCY_CODE
ALT
SUPS_RET_ALLOW_IND
S
CLASS_CLASS_VAT_IND
S
IS_CONSIGNMENT_RATE
12.5000
OLD_RETAIL_WITH_VAT
12.500000
ST_CURRENCY_RTL_DEC
3
TOTAL_UNIT_COST_LOC
12.500000
XFORM_PROD_LOSS_PCT
12.5000
XFORM_SELLABLE_ITEM
Svc Posupld Line Item Gtt
IM_DEPOSIT_ITEM_TYPE
Svc Po
SALES_VALUE_WITH_VAT
12.500000
ST_CURRENCY_COST_DEC
3
WASTAGE_AMT_WITH_VAT
12.500000
CONSIGNMENT_UNIT_COST
12.5000
ISCL_CALCULATION_BASIS
S
OLD_RETAIL_WITHOUT_VAT
12.500000
SALES_VALUE_WITHOUT_VAT
12.500000
SUPS_AUTO_APPR_INVC_IND
S
SUPS_EDI_SALES_RPT_FREQ
D
WASTAGE_AMT_WITHOUT_VAT
12.500000
ILS_LAST_HIST_EXPORT_DATE
2026-01-03
INVENTORY_IDENTIFIER_TYPE
L
XFORM_ORDERABLE_UNIT_COST
12.500000
ACTUALWGHT_RETAIL_WITH_VAT
12.500000
ACTUALWGHT_RETAIL_WITHOUT_VAT
12.500000

default

CHUNK_IDR
1000000005
SALES_THEAD_IDR
1000000005
SALES_PROCESS_IDR
1000000005
POSUPLD_LINE_ITEM_IDR
1000000005
FDATE
2026-01-05
IM_DEPT
1005
IM_ITEM
Svc Posupld Line Item Gtt
PACK_NO
Svc Posupld Line Item Gtt
EOM_DATE
2026-01-05
EOW_DATE
2026-01-05
IM_CLASS
1105
PACK_QTY
14.0000
ERROR_MSG
Svc Posupld Line Item Gtt-003-EDGE
IL_STATUS
A
IM_STATUS
A
ITEM_TYPE
Svc
LOC_VALUE
5
RETURN_WH
Svc Posupl
SALES_QTY
14.0000
TRAN_DATE
2026-01-05
UOM_RATIO
14.000000
GTAX_VALUE
14.0000
ITEM_VALUE
Svc Posupld Line Item Gtt
ORIG_STORE
1005
SALES_TYPE
S
SUPS_TERMS
Svc Posupld Lin
VI_VAT_AMT
14.0000
CUM_TAX_PCT
14.0000
ILS_AV_COST
14.0000
IM_PACK_IND
S
IM_REF_ITEM
Svc Posupld Line Item Gtt
IM_SUBCLASS
1115
IS_SUPPLIER
5
PH_PROM_IND
S
POS_TRAN_ID
1000000005
SALES_VALUE
14.0000
SELLING_UOM
Svc
VI_VAT_CODE
EDGE-S
VI_VAT_RATE
14.0000000000
DROPSHIP_IND
S
IM_WASTE_PCT
14.000000
INVENTORY_ID
EDGE-SVC_POSUPL-003
PH_CLEAR_IND
S
CUM_TAX_VALUE
14.0000000000
CW_NOMINAL_WT
14.0000
ILS_UNIT_COST
14.0000
IM_ITEM_LEVEL
5
IM_TRAN_LEVEL
5
IM_WASTE_TYPE
Svc Po
PACK_COMP_IND
S
PH_REG_RETAIL
14.000000
ST_STORE_TYPE
Svc Po
ST_VAT_REGION
205
TERMS_DUEDAYS
5
TERMS_PERCENT
14.0000
TRAN_TYPE_NUM
6
FULFILL_LOC_ID
1000000005
ILS_UPDATE_LOC
5
IL_UNIT_RETAIL
14.000000
NO_INV_RET_IND
S
PACK_COMP_ITEM
Svc Posupld Line Item Gtt
PH_CURR_RETAIL
14.000000
PH_PROM_RETAIL
14.000000
SALES_SIGN_NUM
6
TRAN_TYPE_CHAR
S
CATCHWEIGHT_IND
S
GTAX_UNIT_VALUE
14.0000
IL_PRIMARY_SUPP
5
IM_SELLABLE_IND
S
IM_STANDARD_UOM
Svc
RESA_SALES_TYPE
S
SALES_SIGN_CHAR
S
XFORM_YIELD_PCT
14.0000
ACTUALWEIGHT_QTY
14.0000
CONSIGNMENT_RATE
14.0000
FULFILL_LOC_TYPE
SU
FULFILL_ORDER_NO
Svc Posupld Line Item Gtt-003-EDGE
IL_PRIMARY_CNTRY
Svc
IM_INVENTORY_IND
S
IM_ORDERABLE_IND
S
NEW_ITEM_LOC_IND
S
PACK_PRICE_RATIO
14.0000000000
ST_CURRENCY_CODE
EDG
SUPS_RET_COURIER
Svc Posupld Line Item Gtt-003-EDGE
CUSTOMER_ORDER_NO
Svc Posupld Line Item Gtt-003-EDGE
EOM_DATE_454_WEEK
5
EOM_DATE_454_YEAR
5
EOW_DATE_454_WEEK
5
EOW_DATE_454_YEAR
5
IM_ITEM_XFORM_IND
S
SALES_QTY_STD_UOM
14.0000
SELLING_UOM_CLASS
Svc Po
SUBTRANS_TYPE_IND
S
SUPS_HANDLING_PCT
14.0000
TOTAL_AV_COST_LOC
14.000000
TOTAL_WASTAGE_QTY
14.0000
DEPS_PURCHASE_TYPE
5
EOM_DATE_454_MONTH
5
EOW_DATE_454_MONTH
5
ILS_AVERAGE_WEIGHT
14.0000
ISCL_PURCHASE_RATE
14.0000
ISCL_PURCHASE_TYPE
2
IS_CONCESSION_RATE
14.0000
LAST_MODIFIED_DATE
2026-01-05
ORDER_PLACED_STORE
1005
RETURN_DISPOSITION
Svc Posupl
ST_VAT_INCLUDE_IND
S
SUPS_CURRENCY_CODE
EDG
SUPS_RET_ALLOW_IND
S
CLASS_CLASS_VAT_IND
S
IS_CONSIGNMENT_RATE
14.0000
OLD_RETAIL_WITH_VAT
14.000000
ST_CURRENCY_RTL_DEC
5
TOTAL_UNIT_COST_LOC
14.000000
XFORM_PROD_LOSS_PCT
14.0000
XFORM_SELLABLE_ITEM
Svc Posupld Line Item Gtt
IM_DEPOSIT_ITEM_TYPE
Svc Po
SALES_VALUE_WITH_VAT
14.000000
ST_CURRENCY_COST_DEC
5
WASTAGE_AMT_WITH_VAT
14.000000
CONSIGNMENT_UNIT_COST
14.0000
ISCL_CALCULATION_BASIS
S
OLD_RETAIL_WITHOUT_VAT
14.000000
SALES_VALUE_WITHOUT_VAT
14.000000
SUPS_AUTO_APPR_INVC_IND
S
SUPS_EDI_SALES_RPT_FREQ
D
WASTAGE_AMT_WITHOUT_VAT
14.000000
ILS_LAST_HIST_EXPORT_DATE
2026-01-05
INVENTORY_IDENTIFIER_TYPE
E
XFORM_ORDERABLE_UNIT_COST
14.000000
ACTUALWGHT_RETAIL_WITH_VAT
14.000000
ACTUALWGHT_RETAIL_WITHOUT_VAT
14.000000

Rule Validation Summary

Source Rule Count
144
Governed Rule Count
130