PR請購單導入需分兩步進行:
先準備接口表數據, 通過SQLLoader或其他三方軟件將數據插入接口表, 然後在系統中提交標準PR導入請求, 完成PR生成.
1, insert into PR interface table:
INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
(INTERFACE_SOURCE_CODE,
DESTINATION_TYPE_CODE,
AUTHORIZATION_STATUS,
REQUISITION_TYPE,
PREPARER_ID,
PREPARER_NAME,
QUANTITY,
CHARGE_ACCOUNT_ID,
DESTINATION_ORGANIZATION_ID,
DESTINATION_SUBINVENTORY,
SOURCE_TYPE_CODE,
UNIT_PRICE,
DELIVER_TO_LOCATION_ID,
DELIVER_TO_REQUESTOR_ID,
ITEM_ID,
UNIT_OF_MEASURE,
UOM_CODE,
NEED_BY_DATE,
CREATION_DATE,
ITEM_DESCRIPTION,
LINE_TYPE,
HEADER_DESCRIPTION,
LINE_TYPE_ID,
SUGGESTED_VENDOR_ID,
SUGGESTED_VENDOR_SITE_ID)
VALUES( 'EXTERNAL', 'INVENTORY', 'INCOMPLETE', 'PURCHASE', 25, 'Stock, Ms Pat', 10, 13401, 204, 'Stores', 'VENDOR', 23, 204, 25, 63, 'Each', 'Ea', sysdate, sysdate, 'Sentinal Multimedia', 'GOODS', 'Test Requisitions', 1, 21, 41);
2, Log in as user: operations/welcome
resp: Purchasing, Vision Operations (USA)
Submit request: Requisition Import
Parameter:
source: external
