Receive Requisition Service

Field Name	Maps to Column	Description
INTERFACE_SOURCE_ CODE	INTERFACE_SOURCE_ CODE	Required. Use values such as ICX, INV, MRP, MSC, ORDER ENTRY, or WIP.
REQUISITION_TYPE	REQUISITION_TYPE	Requisition type. Use values such as BLANKET, PLANNED, SCHEDULED, STANDARD, INTERNAL, or EXPENSE.
AUTHORIZATION_ STATUS	AUTHORIZATION_ STATUS	Required. Use values such as: APPROVED, CANCELLED, IN PROCESS, INCOMPLETE, PRE–APPROVED, REJECTED, REQUIRES REAPPROVAL, or RETURNED.
PREPARER_NAME	PREPARER_NAME	Required. Name of the person who has prepared the requisition.
APPROVER_NAME	APPROVER_NAME	Name of the person who has approved the requisition.
HEADER_DESCRIPTION	HEADER_DESCRIPTION	Description for the requisition.
NOTE_TO_APPROVER	NOTE_TO_APPROVER
USSGL_TRANSACTION_ CODE	USSGL_TRANSACTION_ CODE	United States standard general ledger transaction code.
KANBAN_CARD_ NUMBER	KANBAN_CARD_ ID
EMERGENCY_PO_ NUM	EMERGENCY_PO_ NUM	Purchase order number reserved in advance for an emergency requisition.
ORGANIZATION_ NAME	ORG_ID	Organization for which a requisition has been raised.
SET_OF_BOOKS_ NAME		Required for retrieving the Account ID using the transformer. See the transformer commonOA1227.utils: getCodeCombinationId.

Field Name	Maps to Column	Description
DESTINATION_TYPE_ CODE	DESTINATION_TYPE_ CODE	Required. Use requisition destination type values such as: EXPENSES, INVENTORY, or SHOP FLOOR.
SOURCE_TYPE_CODE	SOURCE_TYPE_CODE	Conditionally required. Requisition source. Use values such as INVENTORY or VENDOR.
URGENT_FLAG	URGENT_FLAG	Indicates whether requisition is urgent.
RFQ_REQUIRED_ FLAG	RFQ_REQUIRED_ FLAG	Indicates whether a Request For Quotation (RFQ) is required before placement on a purchase order.
JUSTIFICATION	JUSTIFICATION	Purchase justification.
NOTE_TO_BUYER	NOTE_TO_BUYER
NOTE_TO_RECEIVER	NOTE_TO_RECEIVER
ITEM	ITEM_ID	Conditionally required. Item for which requisition is placed.
ITEM_DESCRIPTION	ITEM_DESCRIPTION
ITEM_REVISION	ITEM_REVISION
CATEGORY	CATEGORY_ID	Category of the item.
QUANTITY	QUANTITY	Required. Quantity ordered.
UNIT_PRICE	UNIT_PRICE
UNIT_OF_MEASURE	UNIT_OF_MEASURE
UOM_CODE	UOM_CODE	Unit of measurement code.
LINE_TYPE	LINE_TYPE	Requisition line type.
UN_NUMBER	UN_NUMBER	UN number.
HAZARD_CLASS	HAZARD_CLASS
REFERENCE_NUM	REFERENCE_NUM	Reference number.
SOURCE_ ORGANIZATION_ NAME	SOURCE_ORGANIZATION_ ID	Conditionally required.
SOURCE_SUBINVENTORY	SOURCE_SUBINVENTORY	Conditionally required.
DESTINATION_ ORGANIZATION_NAME	DESTINATION_ ORGANIZATION_ID	Destination organization name.
DESTINATION_ SUBINVENTORY	DESTINATION_ SUBINVENTORY
DELIVER_TO_ LOCATION_CODE	DELIVER_TO_ LOCATION_CODE	Deliver location code.
DELIVER_TO_LOCATION_ ADDRESS_LINE_1	DELIVER_TO_ LOCATION_ID	Address for the delivery location.
DELIVER_TO_LOCATION_ ADDRESS_LINE_2
DELIVER_TO_LOCATION_ ADDRESS_LINE_3
DELIVER_TO_LOCATION_ TOWN_OR_CITY
DELIVER_TO_LOCATION_ COUNTY
DELIVER_TO_LOCATION_ STATE
DELIVER_TO_LOCATION_ POSTAL_CODE
DELIVER_TO_LOCATION_ COUNTRY
DELIVER_TO_ REQUESTOR_NAME	DELIVER_TO_ REQUESTOR_NAME	Conditionally required.
AUTOSOURCE_FLAG	AUTOSOURCE_FLAG	Conditionally required. Value validated against PO_AUTOSOURCE_ DOCUMENTS_ALL.
AUTOSOURCE_DOC_ LINE_NUM	AUTOSOURCE_DOC_ LINE_NUM	Conditionally required.
DOCUMENT_TYPE_CODE	DOCUMENT_TYPE_CODE	Conditionally required.
SUGGESTED_ BUYER_NAME	SUGGESTED_ BUYER_NAME	Conditionally required.
SUGGESTED_ VENDOR_NAME	SUGGESTED_ VENDOR_NAME	Conditionally required.
SUGGESTED_VENDOR_ SITE_ADDRESS_1	SUGGESTED_ VENDOR_SITE_ID	Conditionally required. Supplier’s address.
SUGGESTED_VENDOR_ SITE_ADDRESS_2
SUGGESTED_VENDOR_ SITE_ADDRESS_3
SUGGESTED_VENDOR_ SITE_TOWN_OR_CITY
SUGGESTED_VENDOR_ SITE_TOWN_OR_COUNTY
SUGGESTED_VENDOR_ SITE_STATE
SUGGESTED_VENDOR_ SITE_POSTAL_CODE
SUGGESTED_VENDOR_ SITE_COUNTRY
SUGGESTED_ VENDOR_PHONE	SUGGESTED_ VENDOR_PHONE	Conditionally required. Supplier’s phone.
SUGGESTED_ VENDOR_CONTACT	SUGGESTED_ VENDOR_CONTACT	Conditionally required. Supplier’s contact person.
SUGGESTED_ VENDOR_ITEM	SUGGESTED_ VENDOR_ITEM_NUM	Supplier’s item number.
NEED_BY_DATE	NEED_BY_DATE	Required. Date the item is needed.
CURRENCY_CODE	CURRENCY_CODE
CURRENCY_ UNIT_PRICE	CURRENCY_ UNIT_PRICE	Conditionally required.
RATE	RATE	Conditionally required.
RATE_DATE	RATE_DATE	Conditionally required.
RATE_TYPE	RATE_TYPE	Conditionally required.
WIP_ENTITY_NAME	WIP_ENTITY_ID	Conditionally required.
WIP_LINE_CODE	WIP_LINE_ID
WIP_OPERATION_ SEQ_NUM	WIP_OPERATION_ SEQ_NUM	WIP operation sequence number within a routing.
WIP_RESOURCE_ SEQ_NUM	WIP_RESOURCE_ SEQ_NUM	WIP resource sequence number.
WIP_REPETITIVE_ SCHEDULE	WIP_REPETITIVE_ SCHEDULE_ID	Conditionally required.
BOM_RESOURCE	BOM_RESOURCE_ID	Conditionally required. Bill of materials resource.
TRANSACTION_ REASON_CODE	TRANSACTION_ REASON_CODE
TAX_CODE	TAX_CODE_ID

Field Name	Maps to Column	Description
PROJECT_ ACCOUNTING_ CONTEXT	PROJECT_ ACCOUNTING_ CONTEXT	Indicates whether project accounting is required.
EXPENDITURE_ ORGANIZATION_ NAME	EXPENDITURE_ ORGANIZATION_ID	Conditionally required. Project accounting expenditure organization.
PROJECT_NAME	PROJECT_ID	Conditionally required. For project accounting.
TASK_NAME	TASK_ID	Conditionally required. Project accounting task.
EXPENDITURE_ ITEM_DATE	EXPENDITURE_ ITEM_DATE	Project accounting expenditure date.
GL_DATE	GL_DATE	General Ledger date.
EXPENDITURE_TYPE	EXPENDITURE_TYPE	Conditionally required.
ALLOCATION_TYPE	ALLOCATION_TYPE	Specifies the method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE	ALLOCATION_VALUE	Allocation split value.
QUANTITY	QUANTITY	Required. Quantity to be distributed.
CHARGE_ACCOUNT	CHARGE_ACCOUNT_ID	Required. General ledger charge account number.
ACCRUAL_ACCOUNT	ACCRUAL_ACCOUNT_ID	Conditionally required. General Ledger accrual account number.
BUDGET_ACCOUNT	BUDGET_ACCOUNT_ID	Conditionally required. General Ledger budget account number.
VARIANCE_ACCOUNT	VARIANCE_ACCOUNT_ID	Conditionally required. General Ledger variance account number.

Script	Description
wm_install_into_req.sql	Runs the scripts listed below, except the uninstall script.
wm_into_req_pkg.sql	Installs WM_REQ_IMP_HANDLER_PKG.WM_HANDLE_ REQ, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT procedure to submit the Requisition import process.
wm_into_req_seq.sql	Creates the following components: WM_REQ_BATCH_S, which creates the Req_Batch_sequence_id sequence WM_REQ_DIST_S, which creates the Req_Dist_sequence_id
wm_drop_into_req.sql	Uninstalls all components created by wm_install_into_req.sql.