管理控制台 资源中心
redqq - by - 02 四月, 2008 13:32

销售订单接口表
==========================================

订单的表头信息接口表 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测试通过:


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
)


    最新回复








博客日历
« 八月 2008 »
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
搜索
管理控制台
TOP_Read
TOP_Reply
New_Reply
文章分类
网站链接
新闻聚合
RSS 0.90
RSS 1.0
RSS 2.0
Atom 0.3