(自动创建PO)interface.doc

Standard po: Standard po 需要insert 3個interface（po_headers_interface,po_lines_interface,po_distributions_interface）,然后再跑一個request(Import Standard Purchase Orders),最后去參看是否產生，如果沒有去table(po_interface_errors)找對應的原因。 INSERT INTO po.po_headers_interface (interface_header_id,---------sequence(po_headers_interface_s) batch_id,--------￥i￥HàH?K¤@-ó??|r -- process_code, action,---------------original,replace,update org_id,------------------ -- Your operating unit id  document_type_code,----------------standard,blanket currency_code,----------------currency code(|paG￥?usd?h￥2?·￥[rate|r?q) agent_id,------------------buyer(po_agents_v) vendor_name,----------supply(PO_VENDORS) vendor_site_code,--------po_vendor_sites_all ship_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,  63,  ¨ê???ì§T(??|{)|3--¤?￥q, ??|{, ZKT_SZ,  ZKT_SZ,  TEST3) -- Any reference num /INSERT INTO po.po_lines_interface (interface_line_id,--------sequence(po_lines_interface_s) interface_header_id,--------1?à3po_headers_interface line_num,---------------|??1 shipment_num,--------- line_type,-------------type item,-----------------item uom_code,----3?|ì quantity,-----???q unit_price,----------3??ù promised_date,----------¤é′á ship_to_organization_code,----------organization_code ship_to_location)---------------¤￡2M·?VALUES (po_lines_interface_s.nextval, po_headers_interface_s.currval, 1, 1, Goods, TEST_AP, PCS, 1, 17.50, SYSDATE, SZ1, ) INSERT INTO po.po_distributions_interface (interface_header_id,----------------sequence interface_line_id,-----------------------sequence interface_distribution_id,--------------------sequence distribution_num,----------num quantity_ordered, charge_ac