想通过接口表的方式退货,现在遇到的难题是系统老是提示数量不够,可是数量上保证没有任何问题.....
我是走费用采购的流程
请指导下..谢谢
我的语句是:
INSERT INTO RCV_TRANSACTIONS_INTERFACE
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
PROCESSING_MODE_CODE,
TRANSACTION_STATUS_CODE,
QUANTITY,--AMOUNT
UNIT_OF_MEASURE,
PRIMARY_QUANTITY,
PRIMARY_UNIT_OF_MEASURE,
CATEGORY_ID,--ITEM_ID,
EMPLOYEE_ID,
RECEIPT_SOURCE_CODE,
VENDOR_ID,
FROM_ORGANIZATION_ID,
FROM_SUBINVENTORY,
FROM_LOCATOR_ID,
SOURCE_DOCUMENT_CODE,
PARENT_TRANSACTION_ID,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
DESTINATION_TYPE_CODE,
DELIVER_TO_PERSON_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
VALIDATION_FLAG
)
VALUES
(rcv_transactions_interface_s.nextval, --INTERFACE_TRANSACTION_ID
rcv_interface_groups_s.nextval, --GROUP_ID
SYSDATE,
--LAST_UPDATE_DATE
0,
--LAST_UPDATE_BY
SYSDATE,
--CREATION_DATE
0,
--CREATED_BY
0,
--LAST_UPDATE_LOGIN
'RETURN TO VENDOR',--TRANSACTION_TYPE
SYSDATE,
--TRANSACTION_DATE
'PENDING',
--PROCESSING_STATUS_CODE
'BATCH',
--PROCESSING_MODE_CODE
'PENDING',
--TRANSACTION_STATUS_CODE
1,
--QUANTITY
'吨',
--UNIT_OF_MEASURE
1000,
---PRIMARY_QUANTITY,
'公斤',
---PRIMARY_UNIT_OF_MEASURE,
590,
--ITEM_ID
818,
--EMPLOYEE_ID
'VENDOR',
--RECEIPT_SOURCE_CODE
396,
--VENDOR_ID
292,
--FROM_ORGANIZATION_ID
NULL,
--FROM_SUBINVENTORY
292,
--FROM_LOCATOR_ID
'PO',
--SOURCE_DOCUMENT_CODE
351669,
--PARENT_TRANSACTION_ID
4931,
--PO_HEADER_ID
10369,
--PO_LINE_ID
10252,
--PO_LINE_LOCATION_ID
8251,
--PO_DISTRIBUTION_ID
314178,
--SHIPMENT_HEADER_ID
168239,
--SHIPMENT_LINE_ID
'EXPENSE',
--DESTINATION_TYPE_CODE
null,
--DELIVER_TO_PERSON_ID
null,
--LOCATION_ID
null,
--DELIVER_TO_LOCATION_ID
'Y'
--VALIDATION_FLAG
);
|