oracle销售订单界面,二次开发常用接口表(销售订单)

订单的表头信息接口表 OE_HEADERS_IFACE_ALL 其中字段Operation_Code值:'INSERT' ,'UPDATE','DELETE'

明细信息接口表OE_LINES_IFACE_ALL，两个表的ORIG_SYS_DOCUMENT_REF值须相同，

接口写入成功后，可在功能界面(Form:OEXOIMPT.fmb)查到，在这里可导入形成oracle erp的销售订单。

以下格式在11.5.7测试通过：[@more@]

OE_HEADERS_IFACE_ALL(Operation_Code, --Operation_Code:'INSERT' ,'UPDATE','DELETE'

ORDER_SOURCE_ID , --ORDER_SOURCE_ID from OE_ORDER_SOURCES

ORDER_SOURCE ,

ORG_ID ,

ORIG_SYS_DOCUMENT_REF ,

ORDERED_DATE ,

ORDER_TYPE_ID ,

ORDER_TYPE ,

PRICE_LIST_ID ,

PRICE_LIST ,

TRANSACTIONAL_CURR_CODE ,

TRANSACTIONAL_CURR ,

SALESREP_ID ,

SALESREP ,

PAYMENT_TERM_ID ,

PAYMENT_TERM ,

SOLD_TO_ORG_ID ,

SOLD_TO_ORG ,

SHIP_FROM_ORG_ID ,

SHIP_TO_ORG_ID ,

INVOICE_TO_ORG_ID ,

DELIVER_TO_CUSTOMER_NUMBER,

CUSTOMER_ID ,

CUSTOMER_NUMBER ,

BOOKED_FLAG ,

CLOSED_FLAG ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

SHIP_TO_CUSTOMER_ID ,

INVOICE_CUSTOMER_ID ,

REQUEST_DATE ,

RETURN_REASON_CODE

)

OE_LINES_IFACE_ALL(ORDER_SOURCE_ID ,

ORIG_SYS_DOCUMENT_REF ,

ORIG_SYS_LINE_REF ,

ORG_ID ,

LINE_NUMBER ,

LINE_TYPE_ID ,

REQUEST_DATE ,

LINE_TYPE ,

ITEM_TYPE_CODE ,

INVENTORY_ITEM_ID ,

INVENTORY_ITEM ,

ORDERED_QUANTITY ,

ORDER_QUANTITY_UOM ,

PRICING_QUANTITY_UOM ,

SOLD_TO_ORG_ID ,

SHIP_FROM_ORG_ID ,

SHIP_TO_ORG_ID ,

INVOICE_TO_ORG_ID ,

PRICE_LIST_ID ,

PRICING_DATE ,

UNIT_LIST_PRICE ,

UNIT_SELLING_PRICE ,

TAX_CODE ,

TAX ,

TAX_VALUE ,

TAX_DATE ,

PAYMENT_TERM_ID ,

PAYMENT_TERM ,

SALESREP_ID ,

ITEM_REVISION ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

SOLD_FROM_ORG_ID ,

CALCULATE_PRICE_FLAG ,

Shipment_Priority_Code ,

Subinventory ,

RETURN_REASON_CODE

)