Merge Code for Item Master

[ITEM_NO]

[ITEM_CATEGORY]

[AUTHORIZED]

[ITEM_NAME]

[ALTERNATE_NAME]

[ENGLISH_DESCRIPTION]

[ALTERNATE_DESCRIPTION]

[ITEM_TYPE]

[STOCK_UNIT]

[MAIN_LOCATION]

[COST_CENTRE]

[CONTROL_BY_MPS]

[MAKE_OR_BY]

[SAFETY_STOCK]

[REORDER_POINT]

[REORDER_QTY]

[PURCHASE_LOT_SIZE]

[IQC]

[MATRIX]

[BIN_CONTROL]

[PREFERRED_VENDOR_A]

[VENDOR_NO]

[VENDOR_NAME]

[PREFERRED_VENDOR_B]

[BASIC_SPECS]

[DRAWING_NO]

[DRAWING_DATE]

[PRODUCTION_LOTSIZE]

[WEIGHT_UNIT]

[GW_PER_UNIT]

[NW_PER_UNIT]

[DIMENSION_UNIT]

[DIMENSION_LENGTH]

[DIMENSION_WIDTH]

[DIMENSION_HEIGHT]

[STANDARD_COST]

[QUALITY_CODE]

[SCRAP_RATE]

[SCRAP_QTY]

[MIN_ISSUE_QTY]

[SPECIFICATIONS_REF]

[REVISION_NO]

[BASE_PRICE]

[SALES_UNIT]

[PURCHASE_UNIT]

[ITEM_DISCOUNT]

[SALES_LOTSIZE]

[QTY_PER_INNER_CTN]

[QTY_PER_OUTER_CTN]

[SALES_LEADTIME]

[PRODUCTION_LEADTIME]

[PURCHASE_LEADTIME]

[QTY_ON_HAND]

[QTY_ON_ORDER_SALES]

[QTY_ON_ORDER_PURCHASE]

[QTY_REQUESTED]

[QTY_IN_PROCESS]

[INVENTORY_TOTAL_COST]

[INVENTORY_UNIT_COST]

[QTY_IN_UNALLOCATED]

[QTY_OUT_UNALLOCATED]

[LAST_UNIT_COST]

[LAST_IN_DATE]

[LAST_IN_REF]

[LAST_OUT_COST]

[LAST_OUT_DATE]

[LAST_OUT_REF]

[ANLYS1]

[ANLYS2]

[ANLYS3]

[CREATE_BY]

[CREATE_DATE]

[LAST_UPDATE_BY]

[LAST_UPDATE_DATE]

[PRICE_UPDATE_BY]

[PRICE_UPDATE_DATE]

[IMAGE_FILE_NAME]

[IMAGE_FILE_NAME2]

[PART_NO]

[AS_PRODUCT]

[AS_MATERIAL]

[VOLUME]

[VOLUME_UNIT]

[MEMO]

[QTY_PER_20_FT]

[QTY_PER_40_FT]

[COLOUR]

[COPIED]

[CURRENCY_CODE]

[UNIT]

[START_QTY]

[UNIT_PRICE]

[ORIGIN]

[MATERIAL]