OE模块常用表结构so_headers_all；so_lines_all；
表名:ONT.OE_order_headers_all
说明：订单头
HEADER_ID NUMBER
ORG_ID NUMBER
ORDER_TYPE_ID NUMBER
ORDER_NUMBER NUMBER ORDERED_DATE DATE REQUEST_DATE DATE
DEMAND_CLASS_CODE VARCHAR2(30) PRICE_LIST_ID NUMBER TRANSACTIONAL_CURR_CODE VARCHAR2(15) CUST_PO_NUMBER VARCHAR2(50) INVOICING_RULE_ID NUMBER(15) ACCOUNTING_RULE_ID NUMBER(15) PAYMENT_TERM_ID NUMBER(15) SHIPPING_METHOD_CODE VARCHAR2(30) FOB_POINT_CODE VARCHAR2(30) FREIGHT_TERMS_CODE VARCHAR2(30) SHIP_FROM_ORG_ID NUMBER
SHIP_TO_ORG_ID NUMBER INVOICE_TO_ORG_ID NUMBER
SOLD_TO_CONTACT_ID NUMBER
SHIP_TO_CONTACT_ID NUMBER INVOICE_TO_CONTACT_ID NUMBER CREATION_DATE DATE CREATED_BY NUMBER
LAST_UPDATED_BY NUMBER
LAST_UPDATE_DATE DATE
冬瓜虾仁的做法LAST_UPDATE_LOGIN NUMBER ATTRIBUTE1DATE ATTRIBUTE2DATE ATTRIBUTE3VARCHAR2(240) ATTRIBUTE11VARCHAR2(240) ATTRIBUTE12VARCHAR2(240) ATTRIBUTE13VARCHAR2(240) ATTRIBUTE14DATE CANCELLED_FLAG VARCHAR2(1) OPEN_FLAG VARCHAR2(1) BOOKED_FLAG VARCHAR2(1) SALESREP_ID NUMBER(15) RETURN_REASON_CODE VARCHAR2(30) SALES_CHANNEL_CODE VARCHAR2(30) ORDER_CATEGORY_CODE VARCHAR2(30) SHIPPING_INSTRUCTIONS VARCHAR2(2000) PACKING_INSTRUCTIONS VARCHAR2(2000) FLOW_STATUS_CODE VARCHAR2(30) BOOKED_DATE DATE
表名:ONT.OE_order_lines_all
说明：订单行
LINE_ID NUMBER
ORG_ID NUMBER HEADER_ID NUMBER
LINE_TYPE_ID NUMBER
LINE_NUMBER NUMBER ORDERED_ITEM VARCHAR2(2000) REQUEST_DATE DATE PROMISE_DATE DATE SCHEDULE_SHIP_DATE DATE
ORDER_QUANTITY_UOM VARCHAR2(3) CANCELLED_QUANTITY NUMBER SHIPPED_QUANTITY NUMBER ORDERED_QUANTITY NUMBER SHIPPING_QUANTITY_UOM VARCHAR2(3) DELIVERY_LEAD_TIME NUMBER
SHIP_FROM_ORG_ID NUMBER
SHIP_TO_ORG_ID NUMBER INVOICE_TO_ORG_ID NUMBER
oppo手机如何
SHIP_TO_CONTACT_ID NUMBER INVOICE_TO_CONTACT_ID NUMBER
SOLD_TO_ORG_ID NUMBER
CUST_PO_NUMBER VARCHAR2(50) INVENTORY_ITEM_ID NUMBER INVOICE_INTERFACE_STATUS_CODE VARCHAR2(30) DEMAND_CLASS_CODE VARCHAR2(30) PRICE_LIST_ID NUMBER SHIPPING_METHOD_CODE VARCHAR2(30) FREIGHT_TERMS_CODE VARCHAR2(30) FOB_POINT_CODE VARCHAR2(30) PAYMENT_TERM_ID NUMBER(15) INVOICING_RULE_ID NUMBER(15) ACCOUNTING_RULE_ID NUMBER(15) ITEM_REVISION VARCHAR2(3) UNIT_SELLING_PRICE NUMBER
UNIT_LIST_PRICE NUMBER CONTEXT VARCHAR2(30) ATTRIBUTE1VARCHAR2(240) ATTRIBUTE2VARCHAR2(240) ATTRIBUTE3VARCHAR2(240) ATTRIBUTE4VARCHAR2(240) ATTRIBUTE5VARCHAR2(240) ATTRIBUTE6VARCHAR2(240) ATTRIBUTE7VARCHAR2(240) ATTRIBUTE8VARCHAR2(240) ATTRIBUTE9VARCHAR2(240) ATTRIBUTE10VARCHAR2(240) ATTRIBUTE11VARCHAR2(240) ATTRIBUTE12VARCHAR2(240)
ATTRIBUTE13VARCHAR2(240) ATTRIBUTE14VARCHAR2(240) CREATION_DATE DATE
CREATED_BY NUMBER
LAST_UPDATE_DATE DATE
LAST_UPDATED_BY NUMBER
LAST_UPDATE_LOGIN NUMBER
TOP_MODEL_LINE_ID NUMBER
LINK_TO_LINE_ID NUMBERexcel怎么取消密码保护
ITEM_TYPE_CODE VARCHAR2(30) VISIBLE_DEMAND_FLAG VARCHAR2(1)
LINE_CATEGORY_CODE VARCHAR2(30) ATO_LINE_ID NUMBER SCHEDULE_ARRIVAL_DATE DATE
SCHEDULE_STATUS_CODE VARCHAR2(30) CANCELLED_FLAG VARCHAR2(1) OPEN_FLAG VARCHAR2(1) BOOKED_FLAG VARCHAR2(1) SALESREP_ID NUMBER(15) RETURN_REASON_CODE VARCHAR2(30) ORDERED_ITEM_ID NUMBER SHIPPING_INTERFACED_FLAG VARCHAR2(1) FULFILLED_FLAG VARCHAR2(1) INVOICED_QUANTITY NUMBER SHIPPABLE_FLAG VARCHAR2(1) FLOW_STATUS_CODE VARCHAR2(30) SUBINVENTORY VARCHAR2(10)
表名:oe_transaction_types_tl以及oe_transaction_types_all
说明：订单类别表
oe_transaction_types_tl
TRANSACTION_TYPE_ID NUMBER LANGUAGE VARCHAR2(4) NAME VARCHAR2(30) DESCRIPTION VARCHAR2(2000) oe_transaction_types_all
陛下的意思
TRANSACTION_TYPE_ID NUMBER TRANSACTION_TYPE_CODE VARCHAR2(30) ORDER_CATEGORY_CODE VARCHAR2(30) START_DATE_ACTIVE DATE
END_DATE_ACTIVE DATE
ORG_ID NUMBER ATTRIBUTE4VARCHAR2(240) ATTRIBUTE5VARCHAR2(240) ATTRIBUTE6VARCHAR2(240) ATTRIBUTE7VARCHAR2(240) Fold:XXEUL_OM_RELATED_INFO
说明：完整的订单数据
oh.header_id
oh_id
ttl.name
ttl.descriptionorder_type_desc order_type_name
tt.attribute5order_dept_code
fv_dept.description order_dept_desc
tt.attribute6type_class_code
fv_class.description order_type_class_desc
tt.attribute7overa_flag
oh.booked_date
oh.DEMAND_CLASS_CODE
oh.price_list_id
oh.TRANSACTIONAL_CURR_CODE
oh.CUST_PO_NUMBER
oh.PAYMENT_TERM_ID
rt.name term_name
oh.SHIPPING_METHOD_CODE
aning SHIPPING_METHOD_MEANING
oh.fob_point_code
fob.attribute5fob_ship_point
oh.FREIGHT_TERMS_CODE
oh.sold_to_org_id sold_to_customer_id
rc.customer_number
rc.customer_name
rc.Account_name
oh.ship_from_org_id order_ship_from_org_id
ship_fromanization_code ship_from_org_code
rc_ship.customer_id ship_to_customer_id
rc_ship.customer_name ship_to_customer_name
rc_bill.customer_id invoice_to_customer_id
rc_bill.customer_name invoice_to_customer_name
ship_contact.last_Name ship_contact_name
ship_contact.First_Name ship_contact_phone
bill_contact.last_Name invoice_contact_name
社区自治
bill_contact.First_Name invoice_contact_phone
oh.CREATION_DATE ORDER_CREATION_DATE
fu.ur_name creater_name
oh.ATTRIBUTE1Contract_Received_Date
oh.ATTRIBUTE2Customer_Request_Arrive_Date oh.ATTRIBUTE3Due_At_Theoretic_Date
oh.ATTRIBUTE11Customer_Industry_Class
fv_ind.description Customer_Industry_Name
oh.ATTRIBUTE12Contract_Amount
oh.ATTRIBUTE13CSC_Need_Confirm
oh.ATTRIBUTE14Promid_Loan_Application_Date oh.CANCELLED_FLAG ORDER_CANCELLED_FLAG
oh.OPEN_FLAG ORDER_OPEN_FLAG
oh.BOOKED_FLAG
oh.SALESREP_ID
salerep.name SALESREP_NAME
oh.SALES_CHANNEL_CODE
aning SALES_CHANNEL_MEANING oh.ORDER_CATEGORY_CODE
oh.SHIPPING_INSTRUCTIONS
oh.PACKING_INSTRUCTIONS
oh.FLOW_STATUS_CODE ORDER_FLOW_STATUS_CODE
xc_audit.audit_flag
xc_audit.audit_date
ol.line_id
ol.LINE_TYPE_ID
ttl_line.name line_type_name
ol.LINE_NUMBER
ol.REQUEST_DATE LINE_REQUEST_DATE
ol.PROMISE_DATE
ol.SCHEDULE_SHIP_DATE
ol.ORDER_QUANTITY_UOM
ol.CANCELLED_QUANTITY
ol.SHIPPED_QUANTITY
ol.ORDERED_QUANTITY
ol.DELIVERY_LEAD_TIME
ol.SHIP_FROM_ORG_ID LINE_SHIP_FROM_ORG_ID
line_ship_fromanization_code line_ship_from_org_code ol.INVENTORY_ITEM_ID
<1item_gment1
item_description item_description
ol.INVOICE_INTERFACE_STATUS_CODE
ol.UNIT_SELLING_PRICE
ol.UNIT_LIST_PRICE
ol.ATTRIBUTE1Standard_Item
ol.ATTRIBUTE2Need_Dropshipped
substr(ol.ATTRIBUTE413)Main_Category_Code
fv_main.description Main_Category_Desc
ol.ATTRIBUTE4Item_category
fv_cate.description Item_category_description ol.ATTRIBUTE5Item_Audited_Price
ol.ATTRIBUTE6Order_Line_memo
ol.ATTRIBUTE13Audit_Number
ol.ATTRIBUTE14Audit_Content
ol.CREATION_DATE LINE_CREATION_DATE
ol.TOP_MODEL_LINE_ID
ol.ITEM_TYPE_CODE
写检讨书ol.VISIBLE_DEMAND_FLAG
ol.SCHEDULE_ARRIVAL_DATE
ol.SCHEDULE_STATUS_CODE
ol.CANCELLED_FLAG LINE_CANCELLED_FLAG
ol.OPEN_FLAG LINE_OPEN_FLAG
ol.SHIPPING_INTERFACED_FLAG
ol.INVOICED_QUANTITY
ol.FLOW_STATUS_CODE LINE_FLOW_STATUS_CODE ATO_FLAG ATO_FLAG
Fold:XXEUL_OE_DILIVERY_RECORDS
说明：完整的订单发运记录
wdd.source_header_id header_id
15个月宝宝wdd.source_line_id line_id
wdd.delivery_detail_id
wnd.delivery_id
wnd.namedelivery_name
wnd.initial_pickup_date
xsh.DELIVERY_ACK_DATE
xsh.DELIVERY_ACK_PER
xsh.SERVICE_ACK_DATE
xsh.SERVICE_ACK_PER
xsh.SERVICE_ACK_COM
Fold:XXEUL_PRICING_LIST
说明：完整的订单发运记录
qh.list_header_id
qh.namelist_name
qh.currency_code
ql.list_line_id
msi.inventory_item_id
ql.product_attr_val_disp item_gment1
msi.description item_description
ql.operand price
ql.product_uom_codeuom
Fold:Ra Customers V
说明：完整的客户头记录
customer_id
customer_name
customer_number
Account_Name
status
Fold:Ra Address
说明：完整的客户地址信息
address_id
customer_id
org_id
address1,
address2,
address3,
address4,
postal_code
country
city
铅组词
province
county
