Send Item Service

Document Field	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ ID	None
DOCUMENT_ TYPE			ITEM will be populated in this field.
DOCUMENT_ STATUS			UPDATE or INSERT will be populated in this field.
INV_ITEM_ ORG_ID	None		Concatenated String INVENTORY_ITEM_ID\|\|’ -‘\|\|ORGANIZATION_ID. Not applicable for queryItem service.
ITEM_NUMBER	MTL_SYSTEM_ ITEMS_B_ KFV	CONCATENATED_ SEGMENTS	Segmented Item Number.
ORGANIZATION_ NAME	ORGANIZATION_ID	ORGANIZATION_ NAME	Derives ORGANIZATION_NAME from ORG_ORGANIZATION_ DEFINITIONS using ORGANIZATION_ID .
SUMMARY_ FLAG	MTL_SYSTEM_ ITEMS_B	SUMMARY_ FLAG	Flexfield summary flag.
TAX_CODE	MTL_SYSTEM_ ITEMS_B	TAX_CODE	Tax code for the item.
ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	ENABLED_FLAG
START_DATE_ ACTIVE	MTL_SYSTEM_ ITEMS_B	START_DATE_ ACTIVE	Flexfield segment start date.
END_DATE_ ACTIVE	MTL_SYSTEM_ ITEMS_B	END_DATE_ ACTIVE	Flex field segment end date.
DESCRIPTION	MTL_SYSTEM_ ITEMS_B	DESCRIPTION	Item description.
BUYER_FULL_ NAME	PER_ALL_ PEOPLE_F	FULL_NAME	Derives AGENT_ID from PO_AGENTS, PER_ALL_PEOPLE_F, where PO_AGENTS.AGENT_ID = PER_ALL_PEOPLE_F. PERSON_ID.
ACCOUNTING_ RULE_NAME	RA_RULES	RULE_NAME	Derives the RULE_NAME from RA_RULES for the RULE_ID.
INVOICING_ RULE_NAME	RA_RULES	RULE_NAME	Derives the RULE_NAME from RA_RULES for the RULE_ID.
PURCHASING_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	PURCHASING_ ITEM_FLAG	Indicates whether item can be purchased.
SHIPPABLE_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	SHIPPABLE_ ITEM_FLAG	Indicates whether the item can be shipped.
CUSTOMER_ ORDER_FLAG	MTL_SYSTEM_ ITEMS_B	CUSTOMER_ ORDER_FLAG
INTERNAL_ ORDER_FLAG	MTL_SYSTEM_ ITEMS_B	INTERNAL_ ORDER_FLAG
SERVICE_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	SERVICE_ ITEM_FLAG
INVENTORY_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	INVENTORY_ ITEM_FLAG
ENG_ITEM_ FLAG	MTL_SYSTEM_ ITEMS_B	ENG_ITEM_ FLAG
INVENTORY_ ASSET_FLAG	MTL_SYSTEM_ ITEMS_B	INVENTORY_ ASSET_FLAG
PURCHASING_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	PURCHASING_ ENABLED_FLAG	Indicates whether item can be purchased
CUSTOMER_ ORDER_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	CUSTOMER_ ORDER_ ENABLED_FLAG	Indicates whether item is customer orderable.
INTERNAL_ ORDER_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	INTERNAL_ ORDER_ ENABLED_FLAG	Indicates whether item is internally orderable.
SO_ TRANSACTIONS_ FLAG	MTL_SYSTEM_ ITEMS_B	SO_ TRANSACTIONS_ FLAG	Sales Order Transaction Flag.
MTL_ TRANSACTIONS_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	MTL_ TRANSACTIONS_ ENABLED_FLAG	Indicates whether item can be processed.
STOCK_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	STOCK_ ENABLED_FLAG	Indicates item can be stocked.
BOM_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	BOM_ ENABLED_FLAG	Indicates whether item can appear on a Bill of Materials.
BUILD_IN_ WIP_FLAG	MTL_SYSTEM_ ITEMS_B	BUILD_IN_ WIP_FLAG	Indicates whether item can be built in WIP.
REVISION_ QTY_CONTROL	MFG_LOOKUPS	MEANING	Derives MEANING from MFG_LOOKUPS, where LOOKUP_TYPE is MTL_ENG_QUANTITY for LOOKUP_CODE.
ITEM_CATALOG_ GROUP_ DESCRIPTION	MTL_ITEM_ CATALOG_ GROUPS	DESCRIPTION
CATALOG_ STATUS_FLAG	MTL_SYSTEM_ ITEMS_B	CATALOG_ STATUS_FLAG	Indicates whether item is catalog complete.
CHECK_ SHORTAGES_ FLAG	MTL_SYSTEM_ ITEMS_B	CHECK_ SHORTAGES_ FLAG	Indicates whether material shortages should be checked.
RETURNABLE_ FLAG	MTL_SYSTEM_ ITEMS_B	RETURNABLE_ FLAG	Indicates whether item can be returned.
DEFAULT_ SHIP_ ORGANIZATION_ NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Derives ORGANIZATION_NAME from ORG_ORGANIZATION_ DEFINITIONS
COLLATERAL_ FLAG	MTL_SYSTEM_ ITEMS_B	COLLATERAL_ FLAG	Indicates whether the item is a collateral item.
TAXABLE_FLAG	MTL_SYSTEM_ ITEMS_B	TAXABLE_FLAG	Indicates whether the item is taxable.
QTY_RCV_ EXCEPTION_ CODE	MTL_SYSTEM_ ITEMS_B	QTY_RCV_ EXCEPTION_ CODE	Use: NONE for no receiving control enforced. REJECT for prevent receipt of goods or services. WARNING for display warning message.
ALLOW_ITEM_ DESC_UPDATE_ FLAG	MTL_SYSTEM_ ITEMS_B	ALLOW_ITEM_ DESC_UPDATE_ FLAG	Indicates whether to allow item description updates on inventory item lines.
INSPECTION_ REQUIRED_ FLAG	MTL_SYSTEM_ ITEMS_B	INSPECTION_ REQUIRED_ FLAG
RECEIPT_ REQUIRED_ FLAG	MTL_SYSTEM_ ITEMS_B	RECEIPT_ REQUIRED_ FLAG	Indicates whether a supplier receipt is required.
MARKET_PRICE	MTL_SYSTEM_ ITEMS_B	MARKET_PRICE
HAZARD_CLASS	PO_HAZARD_ CLASSES	HAZARD_ CLASS_NAME	Derives the HAZARD_CLASS_NAME from PO_HAZARD_CLASSES_B.
RFQ_ REQUIRED_ FLAG	MTL_SYSTEM_ ITEMS_B	RFQ_ REQUIRED_ FLAG	Indicates whether an RFQ is required.
QTY_RCV_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	QTY_RCV_ TOLERANCE	Maximum permissible amount over receipt percentage.
LIST_PRICE_ PER_UNIT	MTL_SYSTEM_ ITEMS_B	LIST_PRICE_ PER_UNIT	List price per unit.
UN_NUMBER_ID	MTL_SYSTEM_ ITEMS_B	UN_NUMBER_ID	Purchasing UN number.
PRICE_ TOLERANCE_ PERCENT	MTL_SYSTEM_ ITEMS_B	PRICE_ TOLERANCE_ PERCENT	Price tolerance percentage.
ASSET_ CATEGORY	FA_ASSET_ CATEGORIES_ B_KFV	CONCATENATED_ SEGMENT	Derives the CONCATENATED_SEGMENTS from FA_CATEGORIES_B_KFV for the ASSET_CATEGORY_ID.
ROUNDING_ FACTOR	MTL_SYSTEM_ ITEMS_B	ROUNDING_ FACTOR	Determines order quantity.
UNIT_OF_ISSUE	MTL_SYSTEM_ ITEMS_B	UNIT_OF_ISSUE
ENFORCE_ SHIP_TO_ LOCATION_ CODE	MTL_SYSTEM_ ITEMS_B	ENFORCE_ SHIP_TO_ LOCATION_ CODE	Requires receipt location to match ship to location.
ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	MTL_SYSTEM_ ITEMS_B	ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute receipts are allowed.
ALLOW_ UNORDERED_ RECEIPTS_ FLAG	MTL_SYSTEM_ ITEMS_B	ALLOW_ UNORDERED_ RECEIPTS_ FLAG	Indicates whether to allow unordered receipts.
ALLOW_ EXPRESS_ DELIVERY_ FLAG	MTL_SYSTEM_ ITEMS_B	ALLOW_ EXPRESS_ RECEIPTS_ FLAG	Indicates whether to allow express delivery.
DAYS_EARLY_ RECEIPT_ ALLOWED	MTL_SYSTEM_ ITEMS_B	DAYS_EARLY_ RECEIPT_ ALLOWED
DAYS_LATE_ RECEIPT_ ALLOWED	MTL_SYSTEM_ ITEMS_B	DAYS_LATE_ RECEIPT_ ALLOWED
RECEIPT_DAYS_ EXCEPTION_ CODE	MTL_SYSTEM_ ITEMS_B	RECEIPT_DAYS_ EXCEPTION_ CODE	Use: NONE for no receiving control enforced. REJECT for prevent receipt of goods or services or WARNING for display warning message.
RECEIVING_ ROUTING_ NAME	RCV_ROUTING_ HEADERS	ROUTING_NAME	Derives ROUTING_NAME from RCV_ROUTING_HEADERS for RCV_ROUTING_ID.
INVOICE_ CLOSE_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	INVOICE_ CLOSE_ TOLERANCE
RECEIVE_ CLOSE_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	RECEIVE_ CLOSE_ TOLERANCE
AUTO_LOT_ ALPHA_PREFIX	MTL_SYSTEM_ ITEMS_B	AUTO_LOT_ ALPHA_PREFIX	Lot prefix for lot number controlled item.
START_AUTO_ LOT_NUMBER	MTL_SYSTEM_ ITEMS_B	START_AUTO_ LOT_NUMBER	Starting lot number.
LOT_CONTROL	MFG_LOOKUPS	MEANING	Derives MEANING from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOT_CONTROL for the LOT_CONTROL_CODE. Use: L for the meaning column. 1 for No lot control or 2 for Full lot control.
SHELF_LIFE	MFG_LOOKUPS	MEANING	Derives MEANING from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SHELF_LIFE for the SHELF_LIFE_CODE column. Use: 1 for No shelf life control. 2 for Item shelf life days. 4 for User-defined expiration date.
SHELF_LIFE_ DAYS	MTL_SYSTEM_ ITEMS_B	SHELF_LIFE_ DAYS	Number of shelf life days.
SERIAL_ NUMBER_ CONTROL	MFG_LOOKUPS	MEANING	Derives MEANING from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SERIAL_NUMBER for the SERIAL_NUMBER_ CONTROL_CODE column. Use: 1 for No serial number control. 2 for Predefined serial numbers. 5 for Dynamic entry at inventory receipt. 6 for Dynamic entry at sales order issue.
START_AUTO_ SERIAL_ NUMBER	MTL_SYSTEM_ ITEMS_B	START_AUTO_ SERIAL_ NUMBER
AUTO_SERIAL_ ALPHA_PREFIX	MTL_SYSTEM_ ITEMS_B	AUTO_SERIAL_ ALPHA_PREFIX	Serial number prefix.
SOURCE_TYPE	MFG_LOOKUPS	MEANING	For either Inventory or Supplier. Derives MEANING from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SOURCE_TYPES for the SOURCE_TYPE.
SOURCE_ ORGANIZATION	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Derives ORGANIZATION_NAME from ORG_ORGANIZATION_ DEFINITIONS for the SOURCE_ORGANIZATION_ID.
SOURCE_ SUBINVENTORY	MTL_SYSTEM_ ITEMS_B	SOURCE_ SUBINVENTORY
EXPENSE_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Derived from GL_CODE_COMBINATIONS_KFV for the EXPENSE_ACCOUNT.
ENCUMBRANCE_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Derived from GL_CODE_COMBINATIONS_KFV for the ENCUMBRANCE_ ACCOUNT.
RESTRICT_ SUBINVENTORIES	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SUBINVENTORY_ RESTRICTIONS for the RESTRICT_SUBINVENTORIES_ CODE column. Use: 1 for Subinventories restricted to pre-defined list, or 2 for Subinventories not restricted to pre-defined list.
UNIT_WEIGHT	MTL_SYSTEM_ ITEMS_B	UNIT_WEIGHT
WEIGHT_UOM_ CODE	MTL_SYSTEM_ ITEMS_B	WEIGHT_UOM_ CODE	Weight unit of measure code.
VOLUME_UOM_ CODE	MTL_SYSTEM_ ITEMS_B	VOLUME_UOM_ CODE	Volume unit of measure code.
UNIT_VOLUME	MTL_SYSTEM_ ITEMS_B	UNIT_VOLUME
RESTRICT_ LOCATORS	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS, where LOOKUP_TYPE= MTL_LOCATOR_ RESTRICTIONS for the RESTRICT_LOCATORS_ CODE. Use: 1 for Locators restricted to pre-defined list, 2 for Locators not restricted to pre-defined list.
LOCATION_ CONTROL	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS, where LOOKUP_TYPE=MTL_LO CATION_CONTROL for the LOCATION_CONTROL_CODE column. Use: 1 for No locator control. 2 for Pre-specified locator control. 3 for Dynamic entry locator control. 4 for Locator control determined at subinventory level. 5 for Locator control determined at item level.
SHRINKAGE_ RATE	MTL_SYSTEM_ ITEMS_B	SHRINKAGE_ RATE	Planned shrinkage rate.
ACCEPTABLE_ EARLY_DAYS	MTL_SYSTEM_ ITEMS_B	ACCEPTABLE_ EARLY_DAYS	Days an order may be early before rescheduling is recommended.
PLANNING_ TIME_FENCE	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_TIME_FENCE for the PLANNING_TIME_FENCE_CODE column. Use: 1 for Cumulative total lead time. 2 for Cumulative manufacturing lead time. 3 for Total lead time, or 4 for User-defined time fence.
DEMAND_TIME_ FENCE	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS where LOOKUP_TYPE = MTL_TIME_FENCE for the DEMAND_TIME_FENCE_CODE column. Use: 1 for Cumulative total lead time. 2 for Cumulative manufacturing lead time. 3 for Total lead time, or 4 for User-defined time fence.
LEAD_TIME_ LOT_SIZE	MTL_SYSTEM_ ITEMS_B	LEAD_TIME_ LOT_SIZE	Lead time lot size.
STD_LOT_SIZE	MTL_SYSTEM_ ITEMS_B	STD_LOT_SIZE	Standard lot size.
CUM_ MANUFACTURING_ LEAD_TIME	MTL_SYSTEM_ ITEMS_B	CUM_ MANUFACTURING_ LEAD_TIME	Cumulative lead time.
OVERRUN_ PERCENTAGE	MTL_SYSTEM_ ITEMS_B	OVERRUN_ PERCENTAGE	MRP repetitive overrun rate.
MRP_ CALCULATE_ ATP_FLAG	MTL_SYSTEM_ ITEMS_B	MRP_ CALCULATE_ ATP_FLAG
ACCEPTABLE_ RATE_ INCREASE	MTL_SYSTEM_ ITEMS_B	ACCEPTABLE_ RATE_ INCREASE	MRP repetitive acceptable rate increase.
ACCEPTABLE_ RATE_ DECREASE	MTL_SYSTEM_ ITEMS_B	ACCEPTABLE_ RATE_ DECREASE	MRP repetitive acceptable rate decrease.
CUMULATIVE_ TOTAL_LEAD_ TIME	MTL_SYSTEM_ ITEMS_B	CUMULATIVE_ TOTAL_LEAD_ TIME	Cumulative total lead time.
PLANNING_ TIME_FENCE_ DAYS	MTL_SYSTEM_ ITEMS_B	PLANNING_ TIME_FENCE_ DAYS	Planning time fence.
DEMAND_ TIME_FENCE_ DAYS	MTL_SYSTEM_ ITEMS_B	DEMAND_ TIME_FENCE_ DAYS	Demand time fence.
END_ ASSEMBLY_ PEGGING_FLAG	MTL_SYSTEM_ ITEMS_B	END_ ASSEMBLY_ PEGGING_FLAG	End assembly pegging flag.
REPETITIVE_ PLANNING_ FLAG	MTL_SYSTEM_ ITEMS_B	REPETITIVE_ PLANNING_ FLAG	Repetitive planning flag.
PLANNING_ EXCEPTION_ SET	MTL_SYSTEM_ ITEMS_B	PLANNING_ EXCEPTION_ SET	Exception control set.
BOM_ITEM_TYPE	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS, where LOOKUP_TYPE is BOM_ITEM_TYPE for BOM_ITEM_TYPE column.
PICK_ COMPONENTS_ FLAG	MTL_SYSTEM_ ITEMS_B	PICK_ COMPONENTS_ FLAG
REPLENISH_ TO_ORDER_ FLAG	MTL_SYSTEM_ ITEMS_B	REPLENISH_ TO_ORDER_ FLAG
BASE_ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Derived from MTL_SYSTEM_ITEMS_B_KFV for the BASE_ITEM_ID and Organization.
ATP_ COMPONENTS_ FLAG	MTL_SYSTEM_ ITEMS_B	ATP_ COMPONENTS_ FLAG
ATP_FLAG	MTL_SYSTEM_ ITEMS_B	ATP_FLAG	Indicates whether ATP must be checked when ordering the item.
FIXED_LEAD_ TIME	MTL_SYSTEM_ ITEMS_B	FIXED_LEAD_ TIME	Fixed portion of the assembly lead time.
VARIABLE_ LEAD_TIME	MTL_SYSTEM_ ITEMS_B	VARIABLE_ LEAD_TIME	Variable lead time.
WIP_SUPPLY_ LOCATOR	MTL_ITEM_ LOCATIONS_KFV	CONCATENATED_ SEGMENTS	Derived from MTL_ITEM_LOCATIONS_KFV for the WIP_SUPPLY_LOCATOR.
WIP_SUPPLY_ TYPE	MFG_LOOKUPS	MEANING	Derived from MFG_LOOKUPS for LOOKUP_TYPE WIP_SUPPLY.
WIP_SUPPLY_ SUBINVENTORY	MTL_SYSTEM_ ITEMS_B	WIP_SUPPLY_ SUBINVENTORY
PRIMARY_UOM_ CODE	MTL_SYSTEM_ ITEMS_B	PRIMARY_ UOM_CODE	Primary unit of measure code.
ALLOWED_ UNITS_LOOKUP	MFG_LOOKUP	MEANING	Allowed Units Lookup Code. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_CONVERSION_TYPE for the ALLOWED_UNITS_LOOKUP_CODE column.
COST_OF_ SALES_ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Derives CONCATENATED_SEGMENTS from GL_CODE_COMBINATIONS_KFV for the COST_OF_SALES_ACCOUNT segment.
SALES_ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Derives CONCATENATED_SEGMENTS from GL_CODE_ COMBINATIONS_KFV for the SALES_ACCOUNT.
DEFAULT_ INCLUDE_IN_ ROLLUP_FLAG	MTL_SYSTEM_ ITEMS_B	DEFAULT_ INCLUDE_IN_ ROLLUP_FLAG	Indicates whether to include default value in cost rollup.
INVENTORY_ ITEM_STATUS_ CODE	MTL_SYSTEM_ ITEMS_B	INVENTORY_ ITEM_STATUS_ CODE	Inventory item status.
INVENTORY_ PLANNING	MFG_LOOKUPS	MEANING	Inventory Planning Code. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_MATERIAL_PLANNING.
PLANNER_CODE	MTL_SYSTEM_ ITEMS_B	PLANNER_CODE
PLANNING_ MAKE_BUY	MTL_SYSTEM_ ITEMS_B	PLANNING_ MAKE_BUY_ CODE	Indicates whether item is planned as manufactured or purchased. Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_PLANNING_MAKE_BUY.
FIXED_LOT_ MULTIPLIER	MTL_SYSTEM_ ITEMS_B	FIXED_LOT_ MULTIPLIER
ROUNDING_ CONTROL_ TYPE	MFG_LOOKUPS	MEANING	Rounding Control Code. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MTL_ROUNDING for the ROUNDING_CONTROL_TYPE column.
CARRYING_ COST	MTL_SYSTEM_ ITEMS_B	CARRYING_ COST	Annual carrying cost.
POSTPROCESSING_ LEAD_TIME	MTL_SYSTEM_ ITEMS_B	POSTPROCESSING_ LEAD_TIME
PREPROCESSING_ LEAD_TIME	MTL_SYSTEM_ ITEMS_B	PREPROCESSING_ LEAD_TIME
FULL_LEAD_ TIME	MTL_SYSTEM_ ITEMS_B	FULL_LEAD_ TIME	Full lead time.
ORDER_COST	MTL_SYSTEM_ ITEMS_B	ORDER_COST
MRP_SAFETY_ STOCK_ PERCENT	MTL_SYSTEM_ ITEMS_B	MRP_SAFETY_ STOCK_ PERCENT	Safety stock percentage.
MRP_SAFETY_ STOCK	MFG_LOOKUPS	MEANING	Safety Stock Code. Derived from MFG_LOOKUPS for LOOKUP_TYPE MTL_SAFETY_STOCK_TYPE for the MRP_SAFETY_STOCK_CODE column.
MIN_MINMAX_ QUANTITY	MTL_SYSTEM_ ITEMS_B	MIN_MINMAX_ QUANTITY	Minimum minmax quantity.
MAX_MINMAX_ QUANTITY	MTL_SYSTEM_ ITEMS_B	MAX_MINMAX_ QUANTITY	Maximum minmax quantity.
MINIMUM_ ORDER_ QUANTITY	MTL_SYSTEM_ ITEMS_B	MINIMUM_ ORDER_ QUANTITY	Minimum order quantity.
FIXED_ ORDER_ QUANTITY	MTL_SYSTEM_ ITEMS_B	FIXED_ ORDER_ QUANTITY
FIXED_DAYS_ SUPPLY	MTL_SYSTEM_ ITEMS_B	FIXED_DAYS_ SUPPLY
MAXIMUM_ ORDER_ QUANTITY	MTL_SYSTEM_ ITEMS_B	MAXIMUM_ ORDER_ QUANTITY
ATP_RULE_NAME	MTL_ATP_RULES	RULE_NAME	Derives RULE_NAME from MTL_ATP_RULES for the ATP_RULE_ID.
PICKING_ RULE_NAME	MTL_PICKING_ RULES	PICKING_ RULE_NAME	Derives PICKING_RULE_NAME from MTL_PICKING_RULES for PICKING_RULE_ID.
RESERVABLE_ TYPE	MFG_LOOKUPS	MEANING	Derives from MFG_LOOKUPS for LOOKUP_TYPE MTL_RESERVATION_CONTROL.
POSITIVE_ MEASUREMENT_ ERROR	MTL_SYSTEM_ ITEMS_B	POSITIVE_ MEASUREMENT_ ERROR	Percent error above measured quantity.
NEGATIVE_ MEASUREMENT_ ERROR	MTL_SYSTEM_ ITEMS_B	NEGATIVE_ MEASUREMENT_ ERROR	Percent error below measured quantity.
ENGINEERING_ ECN_CODE	MTL_SYSTEM_ ITEMS_B	ENGINEERING_ ECN_CODE	Engineering ECN Code.
ENGINEERING_ ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Derives from MTL_SYSTEM_ITEMS_B_KFV for the ENGINEERING_ITEM_ID.
ENGINEERING_ DATE	MTL_SYSTEM_ ITEMS_B	ENGINEERING_ DATE
SERVICE_ START_DATE	MTL_SYSTEM_ ITEMS_B	SERVICE_ START_DATE	Service start date. Used in inbound transactions only.
SERVICE_ STARTING_ DELAY	MTL_SYSTEM_ ITEMS_B	SERVICE_ STARTING_ DELAY	Days after shipment that service begins.
VENDOR_ WARRANTY_ FLAG	MTL_SYSTEM_ ITEMS_B	VENDOR_ WARRANTY_ FLAG
SERVICEABLE_ COMPONENT_ FLAG	MTL_SYSTEM_ ITEMS_B	SERVICEABLE_ COMPONENT_ FLAG
SERVICEABLE_ PRODUCT_ FLAG	MTL_SYSTEM_ ITEMS_B	SERVICEABLE_ PRODUCT_ FLAG
BASE_ WARRANTY_ SERVICE_ ITEM	MTL_SYSTEM_ ITEMS_B_KVF	CONCATENATED_ SEGMENTS	Derived from MTL_SYSTEM_ITEMS_B_KFV for the BASE_WARRANTY_SERVICE_ITEM_ ID and organization.
PAYMENT_ TERM_NAME	RA_TERMS_B	TERM_NAME	Derived from RA_TERMS_B.
PREVENTATIVE_ MAINTENANCE_ FLAG	MTL_SYSTEM_ ITEMS_B	PREVENTATIVE_ MAINTENANCE_ FLAG
PRIMARY_ SPECIALIST_ FULL_NAME	PER_ALL_ PEOPLE_F	FULL_NAME	Derived from PER_ALL_PEOPLE_F for PRIMARY_SPECIALIST_ID.
SECONDARY_ SPECIALIST_ FULL_NAME	PER_ALL_ PEOPLE_F	FULL_NAME	Derived from PER_ALL_PEOPLE_F for SECONDARY_SPECIALIST_ID.
SERVICEABLE_ ITEM_CLASS_ NAME	CS_SERVICEABLE_ ITEM_CLASSES	SERVICEABLE_ ITEM_CLASS_ NAME	Derived CS_SERVICEABLE_ITEM_CLASSES for the SERVICEABLE_ITEM_CLASS_ID.
TIME_ BILLABLE_ FLAG	MTL_SYSTEM_ ITEMS_B	TIME_ BILLABLE_ FLAG	Indicates whether service hours are billable.
MATERIAL_ BILLABLE_FLAG	MTL_SYSTEM_ ITEMS_B	MATERIAL_ BILLABLE_FLAG	Indicates whether service items are billable.
EXPENSE_ BILLABLE_FLAG	MTL_SYSTEM_ ITEMS_B	EXPENSE_ BILLABLE_FLAG	Indicates whether service expenses are billable.
PRORATE_ SERVICE_FLAG	MTL_SYSTEM_ ITEMS_B	PRORATE_ SERVICE_FLAG	Indicates cost of service may be prorated.
COVERAGE_ SCHEDULE_ NAME	CS_ COVERAGE_ SCHEDULES	COVERAGE_ SCHEDULE_ NAME	Derived from CS_COVERAGE_SCHEDULES for the COVERAGE_SCHEDULE_ID
SERVICE_ DURATION_ PERIOD_CODE	MTL_SYSTEM_ ITEMS_B	SERVICE_ DURATION_ PERIOD_CODE	Service duration period code.
SERVICE_ DURATION	MTL_SYSTEM_ ITEMS_B	SERVICE_ DURATION	Default service duration.
WARRANTY_ VENDOR_NAME	AP_SUPPLIERS	VENDOR_NAME	Derived from AP_SUPPLIERS for the WARRANTY_VENDOR_ID.
MAX_ WARRANTY_ AMOUNT	MTL_SYSTEM_ ITEMS_B	MAX_ WARRANTY_ AMOUNT	Maximum warranty amount.
REPONSE_ TIME_PERIOD_ CODE	MTL_SYSTEM_ ITEMS_B	REPONSE_ TIME_PERIOD_ CODE	Response time period code.
RESPONSE_ TIME_VALUE	MTL_SYSTEM_ ITEMS_B	RESPONSE_ TIME_VALUE	Response time value.
INVOICEABLE_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	INVOICEABLE_ ITEM_FLAG	Indicates whether item can be invoiced.
INVOICE_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	INVOICE_ ENABLED_FLAG
MUST_USE_ APPROVED_ VENDOR_FLAG	MTL_SYSTEM_ ITEMS_B	MUST_USE_ APPROVED_ VENDOR_FLAG	Indicates whether purchases are restricted to an approved supplier.
OUTSIDE_ OPERATION_ FLAG	MTL_SYSTEM_ ITEMS_B	OUTSIDE_ OPERATION_ FLAG
OUTSIDE_ OPERATION_ UOM_TYPE	MTL_SYSTEM_ ITEMS_B	OUTSIDE_ OPERATION_ UOM_ TYPE
SAFETY_ STOCK_ BUCKET_DAYS	MTL_SYSTEM_ ITEMS_B	SAFETY_ STOCK_ BUCKET_DAYS	Safety stock bucket days.
AUTO_ REDUCE_MPS	MTL_SYSTEM_ ITEMS_B	AUTO_ REDUCE_MPS	Automatically deletes MPS entries in a period.
COSTING_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	COSTING_ ENABLED_FLAG
AUTO_ CREATED_ CONFIG_FLAG	MTL_SYSTEM_ ITEMS_B	AUTO_ CREATED_ CONFIG_FLAG	Indicates whether the configuration item is automatically created.
CYCLE_COUNT_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS_B	CYCLE_COUNT_ ENABLED_FLAG	Indicates whether the item may be cycle counted.
DEMAND_SOURCE_ LINE	Not Used	Not Used	Used for inbound transactions only.
COPY_ITEM_ NUMBER	Not Used	Not Used	Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment. Used for inbound transactions only.
SET_ID	Not Used	Not Used	Set identifier used for ATO. Used for inbound transactions only.
REVISION	MTL_SYSTEM_ ITEMS_B	REVISION	Item revision.
ITEM_TYPE	FND_ COMMON_ LOOKUPS	MEANING	User defined item type. Derived from FND_COMMON_LOOKUPS, where LOOKUP_TYPE = ITEM_TYPE for the ITEM_TYPE as LOOKUP_CODE.
MODEL_CONFIG_ CLAUSE_NAME	MTL_SYSTEM_ ITEMS_B	MODEL_CONFIG_ CLAUSE_NAME	Model Configuration Clause Name.
SHIP_MODEL_ COMPLETE_ FLAG	MTL_SYSTEM_ ITEMS_B	SHIP_MODEL_ COMPLETE_ FLAG	Indicates model must be complete to ship.
MRP_PLANNING	MFG_LOOKUPS	MEANING	MRP planning option. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MRP_PLANNING_CODE.
RETURN_ INSPECTION_ REQUIREMENT	MTL_SYSTEM_ ITEMS_B	RETURN_ INSPECTION_ REQUIREMENT	RMA inspection requirement. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_RETURN_INSPECTION.
DEMAND_ SOURCE_TYPE	Not Used	Not Used	Used for inbound transactions.
DEMAND_ SOURCE_ HEADER_ID	Not Used	Not Used	Used for inbound transactions.
TEMPLATE_NAME	Not Used	Not Used	Item Template Name. Used for inbound transactions only.
COPY_ ORGANIZATION_ NAME	Not Used	Not Used	Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. Used for inbound transaction only.
ATO_ FORECAST_ CONTROL	MFG_LOOKUPS	MEANING	Type of forecast control for ATO. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MRP_ATO_FORECAST_ CONTROL.
MATERIAL_COST	Not Used	Not Used	Used for inbound transactions.
MATERIAL_ SUB_ ELEMENT	Not Used	Not Used	Used for inbound transactions.
MATERIAL_ OH_RATE	Not Used	Not Used	Used for inbound transactions.
MATERIAL_ OH_ SUBELEMENT	Not Used	Not Used	Used for inbound transactions.
RELEASE_ TIME_FENCE	MFG_LOOKUPS	MEANING	Indicates whether the item is auto releasable by MRP. Derived from MFG_LOOKUPS, where LOOKUP_TYPE is MTL_RELEASE_TIME_ FENCE.
RELEASE_ TIME_FENCE_ DAYS	MTL_SYSTEM_ ITEMS_B	RELEASE_ TIME_FENCE_ DAYS	Number of days within which this item should be auto released.
CONTAINER_ ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	CONTAINER_ ITEM_FLAG	Indicates whether the item is a container. Used for shipping sales orders.
VEHICLE_ITEM_ FLAG	MTL_SYSTEM_ ITEMS_B	VEHICLE_ITEM_ FLAG	Indicates whether the item is a vehicle. Used for shipping sales orders.
MAXIMUM_ LOAD_WEIGHT	MTL_SYSTEM_ ITEMS_B	MAXIMUM_ LOAD_WEIGHT	Maximum load weight of a container or a vehicle that can be used for shipping sales orders.
MINIMUM_FILL_ PERCENT	MTL_SYSTEM_ ITEMS_B	MINIMUM_FILL_ PERCENT	Minimum fill condition under which the container or vehicle should be used.
CONTAINER_ TYPE_CODE	MTL_SYSTEM_ ITEMS_B	CONTAINER_ TYPE_CODE	Container type code for container items. Container types are user definable.
INTERNAL_ VOLUME	MTL_SYSTEM_ ITEMS_B	INTERNAL_ VOLUME	Internal volume for container items. Used by shipping to calculate container capacity restrictions.
WH_UPDATE_ DATE	MTL_SYSTEM_ ITEMS_B	WH_UPDATE_ DATE	Warehouse update date for tracking changes relevant to data collected in Data Warehouse.
PRODUCT_ FAMILY_ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Derived from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment.
PURCHASING_ TAX_CODE	MTL_SYSTEM_ ITEMS_B	PURCHASING_ TAX_CODE
OVERCOMPLETION_ TOLERANCE_ TYPE	MFG_LOOKUPS	MEANING	Over-completion toleration type. Derived from MFG_LOOKUPS, where LOOKUP_TYPE is WIP_TOLERANCE_TYPE.
OVERCOMPLETION_ TOLERANCE_ VALUE	MTL_SYSTEM_ ITEMS_B	OVERCOMPLETION_ TOLERANCE_ \| VALUE	Over completion tolerance value.
EFFECTIVITY_ CONTROL	MFG_LOOKUPS	MEANING	Effective Control. Derived from MFG_LOOKUPS where LOOKUP_TYPE is MTL_EFFECTIVITY_ CONTROL.
OVERSHIPMENT_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	OVERSHIPMENT_ TOLERANCE	Over-shipment tolerance.
UNDERSHIPMENT_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	UNDERSHIPMENT_ TOLERANCE	Under-shipment tolerance.
OVER_RETURN_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	OVER_RETURN_ TOLERANCE	Over-return tolerance.
UNDER_RETURN_ TOLERANCE	MTL_SYSTEM_ ITEMS_B	UNDER_RETURN_ TOLERANCE	Under-return tolerance.
EQUIPMENT_ TYPE	MTL_SYSTEM_ ITEMS_B	EQUIPMENT_ TYPE	Use: 1 for Yes. 2 for No.
RECOVERED_ PART_DISP_ CODE	MTL_SYSTEM_ ITEMS_B	RECOVERED_ PART_DISP_ CODE	Indicates whether return is required for recovered parts or scrap in field, which is used for spare parts.
DEFECT_ TRACKING_ON_ FLAG	MTL_SYSTEM_ ITEMS_B	DEFECT_ TRACKING_ON_ FLAG	Specifies whether a defect or bug can be filed against the product.
USAGE_ITEM_FLAG	MTL_SYSTEM_ ITEMS_B	USAGE_ITEM_ FLAG
EVENT_FLAG	MTL_SYSTEM_ ITEMS_B	EVENT_FLAG	Indicates whether item is to be treated as an event.
ELECTRONIC_FLAG	MTL_SYSTEM_ ITEMS_B	ELECTRONIC_ FLAG	Indicates whether an item exists only in electronic format.
DOWNLOADABLE_ FLAG	MTL_SYSTEM_ ITEMS_B	DOWNLOADABLE_ FLAG
VOL_ DISCOUNT_ EXEMPT_FLAG	MTL_SYSTEM_ ITEMS_B	VOLUME_ DISCOUNT_ EXEMPT_FLAG	Indicates whether an item does not contribute to volume discount for any order.
COUPON_ EXEMPT_FLAG	MTL_SYSTEM_ ITEMS_B	COUPON_ EXEMPT_FLAG	Indicates whether an item is excluded from coupons even if it is part of the group that any coupon applies.
COMMS_NL_ TRACKABLE_ FLAG	MTL_SYSTEM_ ITEMS_B	COMMS_NL_ TRACKABLE_ FLAG	Indicates whether item is tracked using network logistics.
ASSET_ CREATION_ CODE	MTL_SYSTEM_ ITEMS_B	ASSET_ CREATION_ CODE
COMMS_ ACTIVATION_ REQD_FLAG	MTL_SYSTEM_ ITEMS_B	COMMS_ ACTIVATION_ REQUIRED_ FLAG	Indicates whether network activation is required.
ORDERABLE_ ON_WEB_ FLAG	MTL_SYSTEM_ ITEMS_B	ORDERABLE_ ON_WEB_ FLAG	Indicates whether item can be ordered on the Web.
BACK_ ORDERABLE_ FLAG	MTL_SYSTEM_ ITEMS_B	BACK_ ORDERABLE_ FLAG	If ATP failed, can item be back ordered.
WEB_STATUS	MTL_SYSTEM_ ITEMS_B	WEB_STATUS
INDIVISIBLE_ FLAG	MTL_SYSTEM_ ITEMS_B	INDIVISIBLE_ FLAG
DIMENSION_ UOM_CODE	MTL_SYSTEM_ ITEMS_B	DIMENSION_ UOM_CODE	Dimension unit of measure code.
UNIT_LENGTH	MTL_SYSTEM_ ITEMS_B	UNIT_LENGTH
UNIT_WIDTH	MTL_SYSTEM_ ITEMS_B	UNIT_WIDTH
UNIT_HEIGHT	MTL_SYSTEM_ ITEMS_B	UNIT_HEIGHT
BULK_PICKED_ FLAG	MTL_SYSTEM_ ITEMS_B	BULK_PICKED_ FLAG
LOT_STATUS_ ENABLED	MTL_SYSTEM_ ITEMS_B	LOT_STATUS_ ENABLED
CONFIG_ MODEL_TYPE	MTL_SYSTEM_ ITEMS_B	CONFIG_ MODEL_TYPE	Configuration model type (Standard/ Container).
IB_ITEM_ INSTANCE_TYPE	MTL_SYSTEM_ ITEMS_B	IB_ITEM_ INSTANCE_TYPE	Install base tracking. Use of this field requires that Install Base Tracking is true.
LOT_ SUBSTITUTION_ ENABLED	MTL_SYSTEM_ ITEMS_B	LOT_ SUBSTITUTION_ ENABLED	Lot substitution enabled.
MINIMUM_ LICENSE_ QUANTITY	MTL_SYSTEM_ ITEMS_B	MINIMUM_ LICENSE_ QUANTITY	Minimum license quantity.

Script	Description
wm_install_from_invitem.sql	Runs the scripts listed below, except the uninstall script.
wm_from_invitem_vw.sql	Creates the following required view components for item outbound transactions: WM_INV_ITEMS_VW WM_INV_ITEM_CATEGORIES_VW WM_INV_ITEM_REVISIONS_VW WM_INV_ITEMS_QRY_VW
wm_from_invitem_trg.sql	Creates the following required trigger components for item outbound transactions: WM_MTL_SYSTEM_ITEMS_B_IU_TRG WM_MTL_ITEM_CATEGORIES_IUD_TRG WM_MTL_ITEM_REVISIONS_IU_TRG
wm_disable_from_invitem.sql	Disables the triggers installed by wm_from_invitem_trg.sql.
wm_enable_from_invitem.sql	Re-enables the triggers installed by wm_from_invitem_trg.sql.
wm_drop_from_invitem.sql	Uninstalls all components created by wm_install_from_invitem.sql.

Document Field	Oracle Applications Table/View Name	Column Name	Description
INV_ITEM_ ORG_ID	None		Concatenated String INVENTORY_ITEM_ID\|\|’- ‘\|\|ORGANIZATION_ID.
CATEGORY_ SET_NAME	MTL_ITEM_ CATEGORIES_V	CATEGORY_ SET_NAME	Category Set Name.
CATEGORY_ NAME	MTL_ITEM_ CATEGORIES_V	CATEGORY_ NAME	Concatenated category name.
TRANSACTION_ TYPE	Not Used	Not Used	Used for inbound transactions only.

Document Field	Oracle Applications Table/View Name	Column Name	Description
REVISION	MTL_ITEM_ REVISIONS_B	REVISION	Item Revision Code.
INV_ITEM_ ORG_ID	None		Concatenated String INVENTORY_ITEM_ID\|\|’- ‘\|\|ORGANIZATION_ID.
CHANGE_NOTICE	MTL_ITEM_ REVISIONS_B	CHANGE_NOTICE
ECN_ INITIATION_ DATE	MTL_ITEM_ REVISIONS_B	ECN_ INITIATION_ DATE	Engineering change initiation date.
IMPLEMENTATION_ DATE	MTL_ITEM_ REVISIONS_B	IMPLEMENTATION_ DATE	Implementation date.
IMPLEMENTED_ SERIAL_ NUMBER	MTL_ITEM_ REVISIONS_B	IMPLEMENTED_ SERIAL_ NUMBER	Implemented serial number.
EFFECTIVITY_ DATE	MTL_ITEM_ REVISIONS_B	EFFECTIVITY_ DATE	Effective date.
REVISED_ITEM_ SEQUENCE_ ID	MTL_ITEM_ REVISIONS_B	REVISED_ITEM_ SEQUENCE_ ID	Used to identify multiple occurrences of the same item on a engineering change order.
DESCRIPTION	MTL_ITEM_ REVISIONS_B	DESCRIPTION	Item revision description.
REVISION_ LABEL	MTL_ITEM_ REVISIONS_B	REVISION_ LABEL	Revision label.
REVISION_ REASON	MTL_ITEM_ REVISIONS_B	REVISION_ REASON	Revision reason.