(自动创建po)interface

《(自动创建po)interface》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Standardpo:Standardpo需要insert3個interface（po_headers_interface,po_lines_interface,po_distributions_interface）,然后再跑一個request(ImportStandardPurchaseOrders),最后去參看是否產生，如果沒有去table(po_interface_errors)找對應的原因。INSERTINTOpo.po_headers_interface(interface_header_id,---------sequence(po_headers_interface_s)batc

2、h_id,--------¥i¥HÀH«K¤@ӼƦr--process_code,action,---------------original,replace,updateorg_id,--------------------Youroperatingunitiddocument_type_code,----------------standard,blanketcurrency_code,----------------currencycode(¦pªG¥Îusd«h¥²¶·¥[rate¦r¬q)agent_id,------------------buyer(po_agents_v)v

3、endor_name,----------supply(PO_VENDORS)vendor_site_code,--------po_vendor_sites_allship_to_location,----SHIP_TO_LOCATION_CODE(AP_VENDORS_V)bill_to_location,-----bill_to_location_code(AP_VENDORS_V)reference_num)VALUES(apps.po_headers_interface_s.NEXTVAL,9,--'ACCEPTED','ORIGINAL',103,'STANDARD','RMB',

4、63,'¨Ê¶©¬ì§Þ(Ĭ¦{)¦³¤½¥q','Ĭ¦{','ZKT_SZ','ZKT_SZ','TEST3')--Anyreferencenum/INSERTINTOpo.po_lines_interface(interface_line_id,--------sequence(po_lines_interface_s)interface_header_id,--------¹ïÀ³po_headers_interfaceline_num,---------------¦æ¸¹shipment_num,---------line_type,-------------typeitem,-

5、----------------itemuom_code,----³æ¦ìquantity,-----¼Æ¶qunit_price,----------³æ»ùpromised_date,----------¤é´Áship_to_organization_code,----------organization_codeship_to_location)---------------¤£²M·¡VALUES(po_lines_interface_s.nextval,po_headers_interface_s.currval,1,1,'Goods','TEST_AP','PCS',1,17.5

6、0,SYSDATE,'SZ1','')INSERTINTOpo.po_distributions_interface(interface_header_id,----------------sequenceinterface_line_id,-----------------------sequenceinterface_distribution_id,--------------------sequencedistribution_num,----------numquantity_ordered,charge_account_id)----------POBV_PO_DISTRIBUTIO

7、NS(table)VALUES(po_headers_interface_s.currval,po.po_lines_interface_s.CURRVAL,po.po_distributions_interface_s.NEXTVAL,1,1,4265);Blanketpo:Blanketpo只需對應兩個interface（po_headers_interface,po_lines_interf