Svc Posupld Line Item Gtt
Out of ScopeTechnical: SVC_POSUPLD_LINE_ITEM_GTT | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_POSUPLD_LINE_ITEM_GTT
Field Definitions(132)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | CHUNK_IDR | SALES_THEAD_IDR | SALES_PROCESS_IDR | POSUPLD_LINE_ITEM_IDR | FDATE | IM_DEPT | IM_ITEM | PACK_NO | EOM_DATE | EOW_DATE | IM_CLASS | PACK_QTY | ERROR_MSG | IL_STATUS | IM_STATUS | ITEM_TYPE | LOC_VALUE | RETURN_WH | SALES_QTY | TRAN_DATE | UOM_RATIO | GTAX_VALUE | ITEM_VALUE | ORIG_STORE | SALES_TYPE | SUPS_TERMS | VI_VAT_AMT | CUM_TAX_PCT | ILS_AV_COST | IM_PACK_IND | IM_REF_ITEM | IM_SUBCLASS | IS_SUPPLIER | PH_PROM_IND | POS_TRAN_ID | SALES_VALUE | SELLING_UOM | VI_VAT_CODE | VI_VAT_RATE | DROPSHIP_IND | IM_WASTE_PCT | INVENTORY_ID | PH_CLEAR_IND | CUM_TAX_VALUE | CW_NOMINAL_WT | ILS_UNIT_COST | IM_ITEM_LEVEL | IM_TRAN_LEVEL | IM_WASTE_TYPE | PACK_COMP_IND | PH_REG_RETAIL | ST_STORE_TYPE | ST_VAT_REGION | TERMS_DUEDAYS | TERMS_PERCENT | TRAN_TYPE_NUM | FULFILL_LOC_ID | ILS_UPDATE_LOC | IL_UNIT_RETAIL | NO_INV_RET_IND | PACK_COMP_ITEM | PH_CURR_RETAIL | PH_PROM_RETAIL | SALES_SIGN_NUM | TRAN_TYPE_CHAR | CATCHWEIGHT_IND | GTAX_UNIT_VALUE | IL_PRIMARY_SUPP | IM_SELLABLE_IND | IM_STANDARD_UOM | RESA_SALES_TYPE | SALES_SIGN_CHAR | XFORM_YIELD_PCT | ACTUALWEIGHT_QTY | CONSIGNMENT_RATE | FULFILL_LOC_TYPE | FULFILL_ORDER_NO | IL_PRIMARY_CNTRY | IM_INVENTORY_IND | IM_ORDERABLE_IND | NEW_ITEM_LOC_IND | PACK_PRICE_RATIO | ST_CURRENCY_CODE | SUPS_RET_COURIER | CUSTOMER_ORDER_NO | EOM_DATE_454_WEEK | EOM_DATE_454_YEAR | EOW_DATE_454_WEEK | EOW_DATE_454_YEAR | IM_ITEM_XFORM_IND | SALES_QTY_STD_UOM | SELLING_UOM_CLASS | SUBTRANS_TYPE_IND | SUPS_HANDLING_PCT | TOTAL_AV_COST_LOC | TOTAL_WASTAGE_QTY | DEPS_PURCHASE_TYPE | EOM_DATE_454_MONTH | EOW_DATE_454_MONTH | ILS_AVERAGE_WEIGHT | ISCL_PURCHASE_RATE | ISCL_PURCHASE_TYPE | IS_CONCESSION_RATE | LAST_MODIFIED_DATE | ORDER_PLACED_STORE | RETURN_DISPOSITION | ST_VAT_INCLUDE_IND | SUPS_CURRENCY_CODE | SUPS_RET_ALLOW_IND | CLASS_CLASS_VAT_IND | IS_CONSIGNMENT_RATE | OLD_RETAIL_WITH_VAT | ST_CURRENCY_RTL_DEC | TOTAL_UNIT_COST_LOC | XFORM_PROD_LOSS_PCT | XFORM_SELLABLE_ITEM | IM_DEPOSIT_ITEM_TYPE | SALES_VALUE_WITH_VAT | ST_CURRENCY_COST_DEC | WASTAGE_AMT_WITH_VAT | CONSIGNMENT_UNIT_COST | ISCL_CALCULATION_BASIS | OLD_RETAIL_WITHOUT_VAT | SALES_VALUE_WITHOUT_VAT | SUPS_AUTO_APPR_INVC_IND | SUPS_EDI_SALES_RPT_FREQ | WASTAGE_AMT_WITHOUT_VAT | ILS_LAST_HIST_EXPORT_DATE | INVENTORY_IDENTIFIER_TYPE | XFORM_ORDERABLE_UNIT_COST | ACTUALWGHT_RETAIL_WITH_VAT | ACTUALWGHT_RETAIL_WITHOUT_VAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 1000000001 | 1000000001 | 1000000001 | 2026-01-01 | 1001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 2026-01-01 | 2026-01-01 | 1101 | 11.0000 | Svc Posupld Line Item Gtt-001 | ACTIVE | ACTIVE | Svc Posupld Line Item Gtt-001 | 1 | Svc Posupld Line Item Gtt-001 | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | Svc Posupld Line Item Gtt-001 | 1001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 11.0000 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 1111 | 1 | Svc Posupld Line Item Gtt-001 | 1000000001 | 11.0000 | Svc Posupld Line Item Gtt-001 | STD-SVC_POSUPL-001 | 11.0000 | Svc Posupld Line Item Gtt-001 | 11.0000 | STD-SVC_POSUPL-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 1 | 1 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | Svc Posupld Line Item Gtt-001 | 0201 | 001 | 11.0000 | 02 | 1000000001 | 1 | 11.0000 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 02 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 1 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 11.0000 | SU | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | STD-SVC_POSUPL-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 01 | 0001 | 01 | 0001 | Svc Posupld Line Item Gtt-001 | 11.0000 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 1 | 01 | 01 | 11.0000 | 11.0000 | 0 | 11.0000 | 2026-01-01 | 1001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | STD-SVC_POSUPL-001 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | 1 | 11.0000 | 11.0000 | Svc Posupld Line Item Gtt-001 | Svc Posupld Line Item Gtt-001 | 11.0000 | 1 | 11.0000 | 11.0000 | Svc Posupld Line Item Gtt-001 | 11.0000 | 11.0000 | Svc Posupld Line Item Gtt-001 | D | 11.0000 | 2026-01-01 | IIDT | 11.0000 | 11.0000 | 11.0000 |
default
- CHUNK_IDR
- 1000000001
- SALES_THEAD_IDR
- 1000000001
- SALES_PROCESS_IDR
- 1000000001
- POSUPLD_LINE_ITEM_IDR
- 1000000001
- FDATE
- 2026-01-01
- IM_DEPT
- 1001
- IM_ITEM
- Svc Posupld Line Item Gtt-001
- PACK_NO
- Svc Posupld Line Item Gtt-001
- EOM_DATE
- 2026-01-01
- EOW_DATE
- 2026-01-01
- IM_CLASS
- 1101
- PACK_QTY
- 11.0000
- ERROR_MSG
- Svc Posupld Line Item Gtt-001
- IL_STATUS
- ACTIVE
- IM_STATUS
- ACTIVE
- ITEM_TYPE
- Svc Posupld Line Item Gtt-001
- LOC_VALUE
- 1
- RETURN_WH
- Svc Posupld Line Item Gtt-001
- SALES_QTY
- 11.0000
- TRAN_DATE
- 2026-01-01
- UOM_RATIO
- 11.0000
- GTAX_VALUE
- 11.0000
- ITEM_VALUE
- Svc Posupld Line Item Gtt-001
- ORIG_STORE
- 1001
- SALES_TYPE
- Svc Posupld Line Item Gtt-001
- SUPS_TERMS
- Svc Posupld Line Item Gtt-001
- VI_VAT_AMT
- 11.0000
- CUM_TAX_PCT
- 11.0000
- ILS_AV_COST
- 11.0000
- IM_PACK_IND
- Svc Posupld Line Item Gtt-001
- IM_REF_ITEM
- Svc Posupld Line Item Gtt-001
- IM_SUBCLASS
- 1111
- IS_SUPPLIER
- 1
- PH_PROM_IND
- Svc Posupld Line Item Gtt-001
- POS_TRAN_ID
- 1000000001
- SALES_VALUE
- 11.0000
- SELLING_UOM
- Svc Posupld Line Item Gtt-001
- VI_VAT_CODE
- STD-SVC_POSUPL-001
- VI_VAT_RATE
- 11.0000
- DROPSHIP_IND
- Svc Posupld Line Item Gtt-001
- IM_WASTE_PCT
- 11.0000
- INVENTORY_ID
- STD-SVC_POSUPL-001
- PH_CLEAR_IND
- Svc Posupld Line Item Gtt-001
- CUM_TAX_VALUE
- 11.0000
- CW_NOMINAL_WT
- 11.0000
- ILS_UNIT_COST
- 11.0000
- IM_ITEM_LEVEL
- 1
- IM_TRAN_LEVEL
- 1
- IM_WASTE_TYPE
- Svc Posupld Line Item Gtt-001
- PACK_COMP_IND
- Svc Posupld Line Item Gtt-001
- PH_REG_RETAIL
- 11.0000
- ST_STORE_TYPE
- Svc Posupld Line Item Gtt-001
- ST_VAT_REGION
- 0201
- TERMS_DUEDAYS
- 001
- TERMS_PERCENT
- 11.0000
- TRAN_TYPE_NUM
- 02
- FULFILL_LOC_ID
- 1000000001
- ILS_UPDATE_LOC
- 1
- IL_UNIT_RETAIL
- 11.0000
- NO_INV_RET_IND
- Svc Posupld Line Item Gtt-001
- PACK_COMP_ITEM
- Svc Posupld Line Item Gtt-001
- PH_CURR_RETAIL
- 11.0000
- PH_PROM_RETAIL
- 11.0000
- SALES_SIGN_NUM
- 02
- TRAN_TYPE_CHAR
- Svc Posupld Line Item Gtt-001
- CATCHWEIGHT_IND
- Svc Posupld Line Item Gtt-001
- GTAX_UNIT_VALUE
- 11.0000
- IL_PRIMARY_SUPP
- 1
- IM_SELLABLE_IND
- Svc Posupld Line Item Gtt-001
- IM_STANDARD_UOM
- Svc Posupld Line Item Gtt-001
- RESA_SALES_TYPE
- Svc Posupld Line Item Gtt-001
- SALES_SIGN_CHAR
- Svc Posupld Line Item Gtt-001
- XFORM_YIELD_PCT
- 11.0000
- ACTUALWEIGHT_QTY
- 11.0000
- CONSIGNMENT_RATE
- 11.0000
- FULFILL_LOC_TYPE
- SU
- FULFILL_ORDER_NO
- Svc Posupld Line Item Gtt-001
- IL_PRIMARY_CNTRY
- Svc Posupld Line Item Gtt-001
- IM_INVENTORY_IND
- Svc Posupld Line Item Gtt-001
- IM_ORDERABLE_IND
- Svc Posupld Line Item Gtt-001
- NEW_ITEM_LOC_IND
- Svc Posupld Line Item Gtt-001
- PACK_PRICE_RATIO
- 11.0000
- ST_CURRENCY_CODE
- STD-SVC_POSUPL-001
- SUPS_RET_COURIER
- Svc Posupld Line Item Gtt-001
- CUSTOMER_ORDER_NO
- Svc Posupld Line Item Gtt-001
- EOM_DATE_454_WEEK
- 01
- EOM_DATE_454_YEAR
- 0001
- EOW_DATE_454_WEEK
- 01
- EOW_DATE_454_YEAR
- 0001
- IM_ITEM_XFORM_IND
- Svc Posupld Line Item Gtt-001
- SALES_QTY_STD_UOM
- 11.0000
- SELLING_UOM_CLASS
- Svc Posupld Line Item Gtt-001
- SUBTRANS_TYPE_IND
- Svc Posupld Line Item Gtt-001
- SUPS_HANDLING_PCT
- 11.0000
- TOTAL_AV_COST_LOC
- 11.0000
- TOTAL_WASTAGE_QTY
- 11.0000
- DEPS_PURCHASE_TYPE
- 1
- EOM_DATE_454_MONTH
- 01
- EOW_DATE_454_MONTH
- 01
- ILS_AVERAGE_WEIGHT
- 11.0000
- ISCL_PURCHASE_RATE
- 11.0000
- ISCL_PURCHASE_TYPE
- 0
- IS_CONCESSION_RATE
- 11.0000
- LAST_MODIFIED_DATE
- 2026-01-01
- ORDER_PLACED_STORE
- 1001
- RETURN_DISPOSITION
- Svc Posupld Line Item Gtt-001
- ST_VAT_INCLUDE_IND
- Svc Posupld Line Item Gtt-001
- SUPS_CURRENCY_CODE
- STD-SVC_POSUPL-001
- SUPS_RET_ALLOW_IND
- Svc Posupld Line Item Gtt-001
- CLASS_CLASS_VAT_IND
- Svc Posupld Line Item Gtt-001
- IS_CONSIGNMENT_RATE
- 11.0000
- OLD_RETAIL_WITH_VAT
- 11.0000
- ST_CURRENCY_RTL_DEC
- 1
- TOTAL_UNIT_COST_LOC
- 11.0000
- XFORM_PROD_LOSS_PCT
- 11.0000
- XFORM_SELLABLE_ITEM
- Svc Posupld Line Item Gtt-001
- IM_DEPOSIT_ITEM_TYPE
- Svc Posupld Line Item Gtt-001
- SALES_VALUE_WITH_VAT
- 11.0000
- ST_CURRENCY_COST_DEC
- 1
- WASTAGE_AMT_WITH_VAT
- 11.0000
- CONSIGNMENT_UNIT_COST
- 11.0000
- ISCL_CALCULATION_BASIS
- Svc Posupld Line Item Gtt-001
- OLD_RETAIL_WITHOUT_VAT
- 11.0000
- SALES_VALUE_WITHOUT_VAT
- 11.0000
- SUPS_AUTO_APPR_INVC_IND
- Svc Posupld Line Item Gtt-001
- SUPS_EDI_SALES_RPT_FREQ
- D
- WASTAGE_AMT_WITHOUT_VAT
- 11.0000
- ILS_LAST_HIST_EXPORT_DATE
- 2026-01-01
- INVENTORY_IDENTIFIER_TYPE
- IIDT
- XFORM_ORDERABLE_UNIT_COST
- 11.0000
- ACTUALWGHT_RETAIL_WITH_VAT
- 11.0000
- ACTUALWGHT_RETAIL_WITHOUT_VAT
- 11.0000