Nil Input Working
In ScopeTechnical: NIL_INPUT_WORKING | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- NIL_INPUT_WORKING
Field Definitions(131)
Rules & Considerations(62)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 11.0000 | 11.0000 | 1 | 1001 | Nil Input Working-001 | 000001 | 1101 | Nil Input Working-001 | Nil Input Working-001 | Nil Input Working-001 | Nil Input Working-001 | 01 | 11.0000 | 1000000001 | Nil Input Working-001 | store | Nil Input Working-001 | Nil Input Working-001 | 1111 | Nil Input Working-001 | Nil Input Working-001 | s | 11.0000 | 11.0000 | STD-NIL_INPUT-001 | Nil Input Working-001 | v | v | 9001 | Nil Input Working-001 | 11.0000 | 9001 | Nil Input Working-001 | 1 | 1001 | Nil Input Working-001 | Nil Input Working-001 | 1 | 0201 | sp | 1 | Nil Input Working-001 | Nil Input Working-001 | w | 11.0000 | 1000000001 | 1 | Nil Input Working-001 | y | Nil Input Working-001 | Nil Input Working-001 | 11.0000 | 1 | y | Nil Input Working-001 | Nil Input Working-001 | 11.0000 | Nil Input Working-001 | STD-NIL_INPUT-001 | 11.0000 | y | e | Nil Input Working-001 | 11.0000 | 0 | Nil Input Working-001 | 11.0000 | 11.0000 | Nil Input Working-001 | 1 | Nil Input Working-001 | Nil Input Working-001 | 11.0000 | Y | 1 | c | 11.0000 | N | bc | Nil Input Working-001 | a | Nil Input Working-001 | Nil Input Working-001 | NULL | Nil Input Working-001 | Nil Input Working-001 | y | Nil Input Working-001 | 11.0000 | 11.0000 | Y | Nil Input Working-001 | N | Nil Input Working-001 | Nil Input Working-001 | Nil Input Working-001 | Nil Input Working-001 | 0 | Nil Input Working-001 | 1000000001 | C | 11.0000 | Nil Input Working-001 | STD-NIL_INPUT-001 | 1000000001 | Nil Input Working-001 | 11.0000 | Nil Input Working-001 | Nil Input Working-001 | y | 0201 | Y | STD-NIL_INPUT-001 | STD-NIL_INPUT-001 | STD-NIL_INPUT-001 | 11.0000 | N | 01 | 1000000001 | N | 11.0000 | 11.0000 | STD-NIL_INPUT-001 | 2026-01-01 | Nil Input Working-001 | 11.0000 | N | 2026-01-01 | 2026-01-01 | 2026-01-01 |
default
- PROCESS_IDR
- 1000000001
- HI
- 11.0000
- TI
- 11.0000
- LOC
- 1
- DEPT
- 1001
- ITEM
- Nil Input Working-001
- LANG
- 000001
- CLASS
- 1101
- DIFF_1
- Nil Input Working-001
- DIFF_2
- Nil Input Working-001
- DIFF_3
- Nil Input Working-001
- DIFF_4
- Nil Input Working-001
- PREFIX
- 01
- AV_COST
- 11.0000
- ZONE_ID
- 1000000001
- COST_UOM
- Nil Input Working-001
- LOC_TYPE
- store
- PACK_IND
- Nil Input Working-001
- RFID_IND
- Nil Input Working-001
- SUBCLASS
- 1111
- UIN_TYPE
- Nil Input Working-001
- UOM_ISCD
- Nil Input Working-001
- VAT_CODE
- s
- VAT_RATE
- 11.0000
- AV_WEIGHT
- 11.0000
- FORMAT_ID
- STD-NIL_INPUT-001
- ITEM_DESC
- Nil Input Working-001
- PACK_TYPE
- v
- SALE_TYPE
- v
- SOURCE_WH
- 9001
- UIN_LABEL
- Nil Input Working-001
- WASTE_PCT
- 11.0000
- DEFAULT_WH
- 9001
- HIER_LEVEL
- Nil Input Working-001
- ITEM_LEVEL
- 1
- LIKE_STORE
- 1001
- RANGED_IND
- Nil Input Working-001
- STORE_TYPE
- Nil Input Working-001
- TRAN_LEVEL
- 1
- VAT_REGION
- 0201
- WASTE_TYPE
- sp
- COSTING_LOC
- 1
- EXT_UIN_IND
- Nil Input Working-001
- ITEM_PARENT
- Nil Input Working-001
- ITEM_STATUS
- w
- MULTI_UNITS
- 11.0000
- ORG_UNIT_ID
- 1000000001
- PRICING_LOC
- 1
- SELLING_UOM
- Nil Input Working-001
- TAXABLE_IND
- y
- CAPTURE_TIME
- Nil Input Working-001
- ITEM_LOC_IND
- Nil Input Working-001
- MEAS_OF_EACH
- 11.0000
- PRIMARY_SUPP
- 1
- SELLABLE_IND
- y
- STANDARD_UOM
- Nil Input Working-001
- UOM_OF_PRICE
- Nil Input Working-001
- WH_UNIT_COST
- 11.0000
- CLASS_VAT_IND
- Nil Input Working-001
- CURRENCY_CODE
- STD-NIL_INPUT-001
- MEAS_OF_PRICE
- 11.0000
- ORDERABLE_IND
- y
- ORDER_AS_TYPE
- e
- PRIMARY_CNTRY
- Nil Input Working-001
- PURCHASE_RATE
- 11.0000
- PURCHASE_TYPE
- 0
- SOURCE_METHOD
- Nil Input Working-001
- UNIT_COST_LOC
- 11.0000
- UNIT_COST_SUP
- 11.0000
- CONTAINER_ITEM
- Nil Input Working-001
- HIER_NUM_VALUE
- 1
- ITEM_XFORM_IND
- Nil Input Working-001
- IZP_EXISTS_IND
- Nil Input Working-001
- MARKUP_PERCENT
- 11.0000
- PROMOTABLE_IND
- Y
- SOURCE_WH_SUPP
- 1
- STORE_ORD_MULT
- c
- DAILY_WASTE_PCT
- 11.0000
- DEFAULT_LOC_IND
- N
- DEFAULT_PO_COST
- bc
- HIER_CHAR_VALUE
- Nil Input Working-001
- ITEM_LOC_STATUS
- a
- ITEM_SHORT_DESC
- Nil Input Working-001
- LOCAL_ITEM_DESC
- Nil Input Working-001
- PRICING_CONTROL
- NULL
- PRIMARY_VARIANT
- Nil Input Working-001
- RECEIVE_AS_TYPE
- Nil Input Working-001
- SIMPLE_PACK_IND
- y
- STORE_PRICE_IND
- Nil Input Working-001
- UNIT_RETAIL_LOC
- 11.0000
- UOM_CONV_FACTOR
- 11.0000
- CATCH_WEIGHT_IND
- Y
- CATCH_WEIGHT_UOM
- Nil Input Working-001
- CHILD_FROM_INPUT
- N
- COSTING_LOC_TYPE
- Nil Input Working-001
- ITEM_GRANDPARENT
- Nil Input Working-001
- ITEM_NUMBER_TYPE
- Nil Input Working-001
- LOCAL_SHORT_DESC
- Nil Input Working-001
- MARKUP_CALC_TYPE
- 0
- PRICING_LOC_TYPE
- Nil Input Working-001
- ROUNDING_RULE_ID
- 1000000001
- CALCULATION_BASIS
- C
- DEFAULT_WASTE_PCT
- 11.0000
- DEPOSIT_ITEM_TYPE
- Nil Input Working-001
- IMPORT_COUNTRY_ID
- STD-NIL_INPUT-001
- ITEM_BASE_ZONE_ID
- 1000000001
- MULTI_SELLING_UOM
- Nil Input Working-001
- MULTI_UNIT_RETAIL
- 11.0000
- PRIMARY_COST_PACK
- Nil Input Working-001
- RETAIL_EXISTS_IND
- Nil Input Working-001
- CONTAINS_INNER_IND
- y
- REGULAR_ZONE_GROUP
- 0201
- ROUNDING_CHECK_IND
- Y
- SUPP_CURRENCY_CODE
- STD-NIL_INPUT-001
- ZONE_CURRENCY_CODE
- STD-NIL_INPUT-001
- DELIVERY_COUNTRY_ID
- STD-NIL_INPUT-001
- SELLING_UNIT_RETAIL
- 11.0000
- ITEM_FROM_INPUT_PACK
- N
- INBOUND_HANDLING_DAYS
- 01
- SOURCE_WH_ORG_UNIT_ID
- 1000000001
- DEFAULT_TO_CHILDREN_IND
- N
- MFG_SUG_RETAIL_EXCL_TAX
- 11.0000
- MFG_SUG_RETAIL_INCL_TAX
- 11.0000
- ITEM_BASE_ZONE_CURR_CODE
- STD-NIL_INPUT-001
- SELLING_PHASE_START_DATE
- 2026-01-01
- CONVERT_RTL_TO_LOC_CURR_IND
- Nil Input Working-001
- MIN_UNITS_FOR_SELL_DATE_RESET
- 11.0000
- DELIVERY_COUNTRY_LOCALIZED_IND
- N
- UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND
- 2026-01-01
- UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND
- 2026-01-01
- UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
- 2026-01-01