Receive Inventory Transaction Service

Field Name	Maps to Column	Description
SOURCE_CODE	SOURCE_CODE	Required. Identifies the external system.
SOURCE_LINE_ID	SOURCE_ LINE_ID	Required. External System Reference to line.
SOURCE_HEADER_ID	SOURCE_ HEADER_ID	Required. External System Reference to header.
INVENTORY_ITEM	INVENTORY_ ITEM_ID	Derives the Inventory Item ID from the MTK_SYSTEM_ITEMS_B_KFV table.
REVISION	REVISION	Revision number if under revision control.
ORGANIZATION_NAME	ORGANIZATION_ ID	Required. Derived using ORG_ORGANIZATION_ DEFINITIONS table.
SET_OF_BOOKS_NAME
SUBINVENTORY_CODE	SUBINVENTORY_ CODE	Subinventory code for the item and all transaction types except cost update.
LOCATOR	LOCATOR_ID	Derived from the MTK_ITEM_ LOCATIONS_KFV table. To be provided if item under locator control.
TRANSACTION_ QUANTITY	TRANSACTION_ QUANTITY	Required.
TRANSACTION_UOM	TRANSACTION_ UOM	Required.
TRANSACTION_DATE	TRANSACTION_ DATE	Required.
TRANSACTION_ SOURCE_NAME	TRANSACTION_ SOURCE_NAME	User defined source name.
TRANSACTION_ TYPE_NAME	TRANSACTION_ TYPE_ID TRANSACTION_ SOURCE_ID	Derived from the MTL_TRANSACTION_ TYPES table.
ACCOUNT		Required for an account type of transaction. COMBINATION_ID is derived using GL_CODE_ COBMINATIONS_KFV.
ACCOUNT_ALIAS		Required for account alias transactions. DISPOSITION_ID is derived using the MTL_GENERIC_ DISPOSITIONS table.
JOB		Required only for WIP and Schedule transactions. WIP_ENTITY_ID is derived using WIP_ENTITIES table.
SALES_ORDER		Required for Sales Order Transactions. Key flexfield segments provided. HEADER_ID is derived from the OE_ORDER_ HEADERS_ALL table.
REASON	REASON_ID	Derived from MTL_TRANSACTION_ REASONS.
PO_REQUISITION_ NUMBER	REQUISITION_ LINE_ID	Derived from the PO_REQUISITION_ HEADERS_ALL and PO_REQUISITION_ LINES_ALL tables.
PO_REQUISITION_ LINE_NUMBER
TRANSACTION_REFERENCE	TRANSACTION_ REFERENCE
TRANSACTION_COST	TRANSACTION_ COST	Cost to be used for inventory issues. If left blank, the cost in the system is used.
DISTRIBUTION_ ACCOUNT_CODE	DISTRIBUTION_ ACCOUNT_ID	Required in case of inventory issues and receipts of an asset item and for sales order shipment transactions.
CURRENCY_CODE	CURRENCY_ CODE	Required if transaction cost is in a different currency than the set of books currency.
CURRENCY_CONVERSION_ TYPE	CURRENCY_ CONVERSION_ TYPE
CURRENCY_CONVERSION_ RATE	CURRENCY_ CONVERSION_ RATE
CURRENCY_CONVERSION_ DATE	CURRENCY_ CONVERSION_ DATE
USSGL_TRANSCTION_CODE	USSGL_ TRANSACTION_ CODE	United States GL Code.
ENCUMBRANCE_ ACCOUNT	ENCUMBRANCE_ ACCOUNT	Derived from GL_CODE_ COMBINATIONS_KFV.
ENCUMBRANCE_ AMOUNT	ENCUMBRANCE_ AMOUNT
VENDOR_LOT_NUMBER	VENDOR_LOT_ NUMBER	Cross Reference Supplier Lot Number.
TRANSFER_SUBINVENTORY	TRANSFER_ SUBINVENTORY	Required for subinventory transfers.
TRANSFER_ORGANIZATION_ NAME	TRANSFER_ ORGANIZATION	Derives the ORGANIZATION_ID using the organization name.
TRANSFER_LOCATOR_ SEGMENTED	TRANSFER_ LOCATOR	Destination Locator Internal ID derived from MTL_ITEM_ LOCATIONS_KFV.
SHIPMENT_NUMBER	SHIPMENT_ NUMBER	Shipment Number. Required for in-transit shipments.
TRANSPORTATION_COST	TRANSPORTATION_ COST
TRANSPORTATION_ ACCOUNT_CODE	TRANSPORTTAION_ ACCOUNT	Derives CODE_COMBINATION_ID from GL_CODE_ COMBINATIONS_KFV.
TRANSFER_COST	TRANSFER_COST
FREIGHT_CODE	FREIGHT_CODE
CONTAINERS	CONTAINERS	Number of containers.
WAYBILL_AIRBILL	WAYBILL_AIRBILL
EXPECTED_ARRIVAL_DATE	EXPECTED_ ARRIVAL_DATE	Has no timestamp.
NEW_AVERAGE_COST	NEW_AVERAGE_COST	Required for average cost transactions.
VALUE_CHANGE	VALUE_CHANGE	Required for average cost transactions.
PERCENTAGE_CHANGE	PERCENTAGE_ CHANGE	Required for average cost transactions.
WIP_ENTITY_TYPE	WIP_ENTITY_TYPE	Required for WIP component issues and returns. Use: 1 for Standard discrete jobs. 2 for Repetitive schedules. 3 for Non-standard discrete jobs. 4 for Work order less schedule.
SCHEDULE_NUMBER	SCHEDULE_NUMBER	Schedule number.
OPERATION_SEQ_NO	OPERATION_ SEQ_NUM	Required for WIP component issues and returns with routings. For WIP routings, values should be 1.
SHIPPABLE_FLAG	SHIPPABLE_FLAG
BOM_REVISION	BOM_REVISION
ROUTING_REVISION	ROUTING_REVISION
BOM_REVISION_DATE	BOM_REVISION_DATE
ROUTING_REVISION_DATE	ROUTING_REVISION_ DATE
ALTERNATE_BOM_ DESIGNATOR	ALTERNATE_BOM_ DESIGNATOR
ALTERNATE_ROUTING_ DESIGNATOR	ALTERNATE_ ROUTING_ DESIGNATOR
ACCOUNTING_CLASS	ACCOUNTING_ CLASS	Accounting class to be used for the flow schedule.
DEMAND_CLASS	DEMAND_CLASS	The class to which demand is tied.
SUBSTITUTION_ID	SUBSTITUTION_ID	Use: 1 for Change. 2 for Delete. 3 for Add. 4 for Lot/Serial number information for items.
SUBSTITUTION_ITEM	SUBSTITUTION_ ITEM_ID	Derived from MTL_SYSTEM_ITEMS_ B_KFV.
SCHEDULED_FLAG	SCHEDULED_FLAG
SCHEDULE_GROUP	SCHEDULE_GROUP
REPETITIVE_LINE_ID	REPETITIVE_LINE_ID
PICKING_LINE_ID	PICKING_LINE_ID
CUSTOMER_SHIP_ID	CUSTOMER_SHIP_ID
FLOW_SCHEDULE	FLOW_SCHEDULE
COST_GROUP_NAME	COST_GROUP_ID

Script	Description
wm_install_into_invtxn.sql	Runs the scripts listed below, except the uninstall script.
wm_into_invtxn_pkg.sql	Installs WM_INV_TXN_IMP_HANDLER_PKG.WM_HANDLE_INV_TXN, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT procedure to submit the Inventory Open Transaction Import process. The process in the Inventory Module is Material Transaction.
wm_into_invtxn_seq.sql	Creates the following components: WM_MTL_TRANSACTION_HEADER_S, which creates the TRANSACTION_HEADER_ID sequence WM_SERIAL_TRANSACTION_TEMP_S, which create the SERIAL_TRANSACTION_TEMP_ID sequence WM_MATERIAL_TRANSACTION_S, which creates the TRANSACTION_INTERFACE_ID sequence
wm_drop_into_invtxn.sql	Uninstalls all components created by wm_install_into_invtxn.sql.

For items that are:	Use this document structure:
Serial-controlled	MTL_TRANSACTIONS and MTL_SERIAL_NUMBERS
Lot-controlled	MTL_TRANSACTIONS and MTL_TRANSACTION_LOTS
Serial-controlled and lot-controlled	MTL_TRANSACTIONS, MTL_SERIAL_NUMBERS, and MTL_TRANSACTION_LOTS
Neither serial number-controlled nor lot-controlled	MTL_TRANSACTIONS

Field Name	Maps to Column	Description
WIP_ENTITY_NAME	WIP_ENTITY_ID	Required. Derived WIP_ENTITY_ID from WIP_ENTITIES.
OPERATION_SEQ_ NUM	OPERATION_SEQ_ NUMBER	Required. WIP operation sequence information.
QUANTITY_ COMPLETED	QUANTITY_ COMPLETED	Required.

Field Name	Maps to Column	Description
SOURCE_CODE	SOURCE_CODE	Required. User Defined Source Identifier.
SOURCE_LINE_ID	SOURCE_LINE_ID	External line identifier.
VENDOR_SERIAL_ NUMBER	VENDOR_SERIAL_ NUMBER	References vendor information.
FM_SERIAL_NUMBER	FM_SERIAL_NUMBER	Required. Starting serial number in the range. If only the FM_SERIAL_NUMBER is entered, the transaction processor assumes that only one transaction is being processed.
TO_SERIAL_NUMBER	TO_SERIAL_NUMBER	Required. End serial number to specify a range.

Field Name	Maps to Column	Description
SOURCE_CODE	SOURCE_CODE	Required. User-defined source identifier.
SOURCE_LINE_ID	SOURCE_LINE_ID	External line identifier.
VENDOR_SERIAL_ NUMBER	VENDOR_SERIAL_ NUMBER	References vendor information.
FM_SERIAL_NUMBER	FM_SERIAL_NUMBER	Required. Starting serial number in the range. If only the FM_SERIAL_NUMBER is entered, the transaction processor assumes that only one transaction is being processed.
TO_SERIAL_NUMBER	TO_SERIAL_NUMBER	Required. End serial number to specify a range.