1
Download Oracle® Order Management
Transcript
Integrating Oracle Order Management Using Order Import ■ CUSTOMER_PAYMENT_TERM_ID = RA_TERMS_B.TERM_ID ■ SALESREP = RA_SALESREPS_ALL.NAME ■ CUSTOMER_PAYMENT_TERM = RA_TERMS_TL.NAME ■ PAYMENT_TERM = RA_TERMS_TL.NAME ■ PRICE_LIST = QP_LIST_HEADERS_TL.NAME ■ ORDER_SOURCE_ID = OE_ORDER_SOURCES.ORDER_SOURCE_ID ■ ORIG_SYS_DOCUMENT_REF = ■ OE_HEADERS_IFACE_ALL.ORIG_SYS_DOCUMENT_REF ■ LINK_TO_LINE_REF = OE_LINES_IFACE_ALL.ORIG_SYS_LINE_REF ■ TOP_MODEL_LINE_REF = OE_LINES_IFACE_ALL.ORIG_SYS_LINE_REF Table 2–6 OE_LINES_IFACE_ALL Conditional Settings Column Name Conditional Setting requirement INVENTORY_ITEM_ID Condition is that either column should be populated INVENTORY_ITEM TOP_MODEL_LINE_REF Required for model items only LINK_TO_LINE_REF SHIPPING_QUANTITY SHIPPING_QUANTITY_UOM PRICING_QUANTITY PRICING_QUANTITY_UOM Condition is that both columns should be populated, if populated since they are not required. Condition is that both columns should be populated, if populated since they are not required. RETURN_REASON_CODE Only required for returns. REFERENCE_TYPE Reference_Type should be there to populate either REFERENCE_HEADER_ID reference_header_id/reference_header and reference_line_id/reference_line REFERENCE_HEADER REFERENCE_LINE_ID (either id or value column should be populated; not both) REFERENCE_LINE Oracle Order Management Open Interfaces and APIs 2-55
