Nil Input Working
In ScopeTechnical: NIL_INPUT_WORKING | ID: OR-ITM-NIL_INPUT_WORKING-NIL_INPUT_WORKING
This a working table to be used by NEW_ITEM_LOC_SQL package to speed bulk processing of new item location ranging.
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- NIL_INPUT_WORKING
Field Definitions(131)
Rules & Considerations(131)
Sample Load Data(4)
| _scenario | PROCESS_IDR | HI | TI | LOC | DEPT | ITEM | LANG | CLASS | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | PREFIX | AV_COST | ZONE_ID | COST_UOM | LOC_TYPE | PACK_IND | RFID_IND | SUBCLASS | UIN_TYPE | UOM_ISCD | VAT_CODE | VAT_RATE | AV_WEIGHT | FORMAT_ID | ITEM_DESC | PACK_TYPE | SALE_TYPE | SOURCE_WH | UIN_LABEL | WASTE_PCT | DEFAULT_WH | HIER_LEVEL | ITEM_LEVEL | LIKE_STORE | RANGED_IND | STORE_TYPE | TRAN_LEVEL | VAT_REGION | WASTE_TYPE | COSTING_LOC | EXT_UIN_IND | ITEM_PARENT | ITEM_STATUS | MULTI_UNITS | ORG_UNIT_ID | PRICING_LOC | SELLING_UOM | TAXABLE_IND | CAPTURE_TIME | ITEM_LOC_IND | MEAS_OF_EACH | PRIMARY_SUPP | SELLABLE_IND | STANDARD_UOM | UOM_OF_PRICE | WH_UNIT_COST | CLASS_VAT_IND | CURRENCY_CODE | MEAS_OF_PRICE | ORDERABLE_IND | ORDER_AS_TYPE | PRIMARY_CNTRY | PURCHASE_RATE | PURCHASE_TYPE | SOURCE_METHOD | UNIT_COST_LOC | UNIT_COST_SUP | CONTAINER_ITEM | HIER_NUM_VALUE | ITEM_XFORM_IND | IZP_EXISTS_IND | MARKUP_PERCENT | PROMOTABLE_IND | SOURCE_WH_SUPP | STORE_ORD_MULT | DAILY_WASTE_PCT | DEFAULT_LOC_IND | DEFAULT_PO_COST | HIER_CHAR_VALUE | ITEM_LOC_STATUS | ITEM_SHORT_DESC | LOCAL_ITEM_DESC | PRICING_CONTROL | PRIMARY_VARIANT | RECEIVE_AS_TYPE | SIMPLE_PACK_IND | STORE_PRICE_IND | UNIT_RETAIL_LOC | UOM_CONV_FACTOR | CATCH_WEIGHT_IND | CATCH_WEIGHT_UOM | CHILD_FROM_INPUT | COSTING_LOC_TYPE | ITEM_GRANDPARENT | ITEM_NUMBER_TYPE | LOCAL_SHORT_DESC | MARKUP_CALC_TYPE | PRICING_LOC_TYPE | ROUNDING_RULE_ID | CALCULATION_BASIS | DEFAULT_WASTE_PCT | DEPOSIT_ITEM_TYPE | IMPORT_COUNTRY_ID | ITEM_BASE_ZONE_ID | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PRIMARY_COST_PACK | RETAIL_EXISTS_IND | CONTAINS_INNER_IND | REGULAR_ZONE_GROUP | ROUNDING_CHECK_IND | SUPP_CURRENCY_CODE | ZONE_CURRENCY_CODE | DELIVERY_COUNTRY_ID | SELLING_UNIT_RETAIL | ITEM_FROM_INPUT_PACK | INBOUND_HANDLING_DAYS | SOURCE_WH_ORG_UNIT_ID | DEFAULT_TO_CHILDREN_IND | MFG_SUG_RETAIL_EXCL_TAX | MFG_SUG_RETAIL_INCL_TAX | ITEM_BASE_ZONE_CURR_CODE | SELLING_PHASE_START_DATE | CONVERT_RTL_TO_LOC_CURR_IND | MIN_UNITS_FOR_SELL_DATE_RESET | DELIVERY_COUNTRY_LOCALIZED_IND | UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND | UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND | UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1.0000 | 1.0000 | 1 | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | 1 | SAMP | S | S | S | 1 | SAMPLE | SAMP | SAMPLE | 1.0000 | 1.0000 | S | SAMPLE | S | SAMPLE | 1 | SAMPLE | 1.0000 | 1 | SAMPLE | 1 | 1 | S | SAMPLE | 1 | 1 | SAMPLE | 1 | S | SAMPLE | S | 1.0000 | 1 | 1 | SAMP | S | SAMPLE | S | 1.0000 | 1 | S | SAMP | SAMP | 1.0000 | S | SAM | 1.0000 | S | S | SAM | 1.0000 | 1 | S | 1.0000 | 1.0000 | SAMPLE | 1 | S | S | 1.0000 | S | 1 | S | 1.0000 | S | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | S | SAMPLE | S | S | S | 1.0000 | 1.0000000000 | S | SAMP | S | S | SAMPLE | SAMPLE | SAMPLE | 1 | S | 1 | S | 1.0000 | S | SAM | 1 | SAMP | 1.0000 | SAMPLE | S | S | 1 | S | SAM | SAM | SAM | 1.0000 | S | 1 | 1 | S | 1.0000 | 1.0000 | SAM | 2026-01-01 | S | 1.0000 | S | S | S | S |
Example values from field definitions
- PROCESS_IDR
- 1
- HI
- 1.0000
- TI
- 1.0000
- LOC
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- LANG
- 1
- CLASS
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- PREFIX
- 1
- AV_COST
- 1.0000
- ZONE_ID
- 1
- COST_UOM
- SAMP
- LOC_TYPE
- S
- PACK_IND
- S
- RFID_IND
- S
- SUBCLASS
- 1
- UIN_TYPE
- SAMPLE
- UOM_ISCD
- SAMP
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000
- AV_WEIGHT
- 1.0000
- FORMAT_ID
- S
- ITEM_DESC
- SAMPLE
- PACK_TYPE
- S
- SALE_TYPE
- SAMPLE
- SOURCE_WH
- 1
- UIN_LABEL
- SAMPLE
- WASTE_PCT
- 1.0000
- DEFAULT_WH
- 1
- HIER_LEVEL
- SAMPLE
- ITEM_LEVEL
- 1
- LIKE_STORE
- 1
- RANGED_IND
- S
- STORE_TYPE
- SAMPLE
- TRAN_LEVEL
- 1
- VAT_REGION
- 1
- WASTE_TYPE
- SAMPLE
- COSTING_LOC
- 1
- EXT_UIN_IND
- S
- ITEM_PARENT
- SAMPLE
- ITEM_STATUS
- S
- MULTI_UNITS
- 1.0000
- ORG_UNIT_ID
- 1
- PRICING_LOC
- 1
- SELLING_UOM
- SAMP
- TAXABLE_IND
- S
- CAPTURE_TIME
- SAMPLE
- ITEM_LOC_IND
- S
- MEAS_OF_EACH
- 1.0000
- PRIMARY_SUPP
- 1
- SELLABLE_IND
- S
- STANDARD_UOM
- SAMP
- UOM_OF_PRICE
- SAMP
- WH_UNIT_COST
- 1.0000
- CLASS_VAT_IND
- S
- CURRENCY_CODE
- SAM
- MEAS_OF_PRICE
- 1.0000
- ORDERABLE_IND
- S
- ORDER_AS_TYPE
- S
- PRIMARY_CNTRY
- SAM
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- SOURCE_METHOD
- S
- UNIT_COST_LOC
- 1.0000
- UNIT_COST_SUP
- 1.0000
- CONTAINER_ITEM
- SAMPLE
- HIER_NUM_VALUE
- 1
- ITEM_XFORM_IND
- S
- IZP_EXISTS_IND
- S
- MARKUP_PERCENT
- 1.0000
- PROMOTABLE_IND
- S
- SOURCE_WH_SUPP
- 1
- STORE_ORD_MULT
- S
- DAILY_WASTE_PCT
- 1.0000
- DEFAULT_LOC_IND
- S
- DEFAULT_PO_COST
- SAMPLE
- HIER_CHAR_VALUE
- SAMPLE
- ITEM_LOC_STATUS
- S
- ITEM_SHORT_DESC
- SAMPLE
- LOCAL_ITEM_DESC
- SAMPLE
- PRICING_CONTROL
- S
- PRIMARY_VARIANT
- SAMPLE
- RECEIVE_AS_TYPE
- S
- SIMPLE_PACK_IND
- S
- STORE_PRICE_IND
- S
- UNIT_RETAIL_LOC
- 1.0000
- UOM_CONV_FACTOR
- 1.0000000000
- CATCH_WEIGHT_IND
- S
- CATCH_WEIGHT_UOM
- SAMP
- CHILD_FROM_INPUT
- S
- COSTING_LOC_TYPE
- S
- ITEM_GRANDPARENT
- SAMPLE
- ITEM_NUMBER_TYPE
- SAMPLE
- LOCAL_SHORT_DESC
- SAMPLE
- MARKUP_CALC_TYPE
- 1
- PRICING_LOC_TYPE
- S
- ROUNDING_RULE_ID
- 1
- CALCULATION_BASIS
- S
- DEFAULT_WASTE_PCT
- 1.0000
- DEPOSIT_ITEM_TYPE
- S
- IMPORT_COUNTRY_ID
- SAM
- ITEM_BASE_ZONE_ID
- 1
- MULTI_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- PRIMARY_COST_PACK
- SAMPLE
- RETAIL_EXISTS_IND
- S
- CONTAINS_INNER_IND
- S
- REGULAR_ZONE_GROUP
- 1
- ROUNDING_CHECK_IND
- S
- SUPP_CURRENCY_CODE
- SAM
- ZONE_CURRENCY_CODE
- SAM
- DELIVERY_COUNTRY_ID
- SAM
- SELLING_UNIT_RETAIL
- 1.0000
- ITEM_FROM_INPUT_PACK
- S
- INBOUND_HANDLING_DAYS
- 1
- SOURCE_WH_ORG_UNIT_ID
- 1
- DEFAULT_TO_CHILDREN_IND
- S
- MFG_SUG_RETAIL_EXCL_TAX
- 1.0000
- MFG_SUG_RETAIL_INCL_TAX
- 1.0000
- ITEM_BASE_ZONE_CURR_CODE
- SAM
- SELLING_PHASE_START_DATE
- 2026-01-01
- CONVERT_RTL_TO_LOC_CURR_IND
- S
- MIN_UNITS_FOR_SELL_DATE_RESET
- 1.0000
- DELIVERY_COUNTRY_LOCALIZED_IND
- S
- UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND
- S
- UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND
- S
- UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
- S
Rule Validation Summary
- Source Rule Count
- 191
- Governed Rule Count
- 131