Table 31. Order Attribute Mapping
|
|
Siebel to Oracle Integration |
Oracle to Siebel Integration |
Siebel Field (Order Entry - Orders) |
Oracle Base Column (OE_ORDER_HEADERS_ ALL) |
Siebel to Oracle Integration (SIE_ORDER_HEADERS_ALL) |
Oracle to Siebel Integration (SIE_HEADERS_ALL_V) |
Created |
CREATION_DATE |
CREATION_DATE |
|
Created By |
CREATED_BY |
CREATED_BY |
|
Updated |
LAST_UPDATE_DATE |
LAST_UPDATE_DATE |
|
Updated By |
LAST_UPDATED_BY |
LAST_UPDATED_BY |
|
Id |
ORIG_SYS_DOCUMENT_ REF |
ORIG_SYS_DOCUMENT_ REF |
ORIG_SYS_DOCUMENT_ REF |
Order Type |
TRANSACTION_TYPE_CODE(OE_TRANSACTION_ TYPES_ALL) |
ORDER TYPE |
|
Order Date |
ORDERED_DATE |
ORDERED_DATE |
DATE_ORDERED |
Siebel Field (Order Entry - Orders) (continued) |
Oracle Base Column (OE_ORDER_HEADERS_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_HEADERS_ALL) (continued) |
Oracle to Siebel Integration (SIE_HEADERS_ALL_V) (continued) |
|
BOOKED_DATE |
BOOKED_DATE |
|
Currency Code |
TRANSACTIONAL_ CURR_CODE |
TRANSACTIONAL_ URR_CODE |
CURRENCY_CODE |
Pricing Date |
PRICING_DATE |
PRICING_DATE |
|
Status |
FLOW_STATUS_CODE |
ENTERED_STATE_NAME (through EAI Value Map Oracle R11i Order Status) |
STATUS (through EAI Value Map Oracle R11i Order Status) |
No Siebel field available |
BOOKED_FLAG |
BOOKED_FLAG (set to Y when order status is BOOKED) |
|
Account Integration Id |
SOLD_TO_ORG_ID |
SOLD_TO_ORG_ID |
CUSTOMER_ID |
Primary Position Contact Id |
SALESREP_ID |
SALESREP_ID |
|
Requested Ship Date |
REQUEST_DATE |
REQUEST_DATE |
DATE_REQUESTED_ CURRENT |
Tax Exempt |
TAX_EXEMPT_FLAG |
TAX_EXEMPT_FLAG (through EAI Value Map Oracle R11i Tax Exempt Flag) |
TAX_EXEMPT_FLAG (through EAI Value Map Oracle R11i Tax Exempt Flag) |
Tax Exempt Number |
TAX_EXEMPT_NUMBER |
TAX_EXEMPT_NUMBER |
TAX_EXEMPT_NUMBER |
Tax Exempt Reason |
TAX_EXEMPT_REASON_ CODE |
TAX_EXEMPT_REASON_ CODE (through EAI Value Map Oracle R11i Tax Exempt Reason) |
TAX_EXEMPT_REASON_ CODE (through EAI Value Map Oracle R11i Tax Exempt Reason) |
Siebel Field (Order Entry - Orders) (continued) |
Oracle Base Column (OE_ORDER_HEADERS_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_HEADERS_ALL) (continued) |
Oracle to Siebel Integration (SIE_HEADERS_ALL_V) (continued) |
Price List Integration Id (Order Entry - Orders) |
PRICE_LIST_ID |
PRICE_LIST_ID |
PRICE_LIST_ID |
Order Priority |
SHIPMENT_PRIORITY_ CODE |
SHIPMENT_PRIORITY_ CODE (through EAI Value Map Oracle R11i Shipment Priority) |
SHIPMENT_PRIORITY_ CODE |
Carrier Type |
SHIPPING_PRIORITY _CODE |
SHIPPING_METHOD_ CODE (through EAI Value Map Oracle R11i Ship Method Code) |
SHIPPING_PRIORITY CODE (through EAI Value Map Oracle R11i Ship Method Code) |
Freight Terms |
FREIGHT_TERMS_CODE |
FREIGHT_TERMS_CODE (through EAI Value Map Oracle R11i Freight) |
FREIGHT_TERMS_CODE (through EAI Value Map Oracle R11i Freight) |
Freight Terms Info |
FOB_POINT_CODE |
FOB_POINT_CODE (through EAI Value Map Oracle 1i Fob Code) |
FOB_CODE (through EAI Value Map Oracle11i Fob Code) |
Ship Instruction |
SHIPPING_ INSTRUCTIONS |
SHIPPING_ INSTRUCTIONS |
SHIPPING_INSTRUCTIONS |
Organization Integration Id |
ORG_ID |
ORG_ID |
ORG_ID |
|
- |
SOLD_FROM_ORG_ID |
|
No Siebel Field Available |
|
VERSION_NUMBER (hard coded to 1 in DTE) |
|
Bill To Address Site Use Integration Id |
CUST_ACCT_SITE_ID(HZ_CUST_SITE_USE_ALL) |
INVOICE_TO_ORG_ID |
INVOICE_TO_ADDRESS_ID (subject to change) |
Siebel Field (Order Entry - Orders) (continued) |
Oracle Base Column (OE_ORDER_HEADERS_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_HEADERS_ALL) (continued) |
Oracle to Siebel Integration (SIE_HEADERS_ALL_V) (continued) |
Ship To Address Site Use Integration Id |
CUST_ACCT_SITE_ID(HZ_CUST_SITE_USE_ALL) |
SHIP_TO_ORG_ID |
SHIP_TO_ADDRESS_ID |
Ship To Contact Integration Id |
SHIP_TO_CONTACT_ID |
|
SHIP_TO_CONTACT_ID |
Payment Term Integration Id |
PAYMENT_TERM_ID |
PAYMENT_TERM_ID |
TERM_ID |
Payment Method |
PAYMENT_TYPE_CODE |
PAYMENT_TYPE_CODE (through EAI Value Map Oracle R11i Payment Type Code) |
PAYMENT_TYPE_CODE (through EAI Value Map Oracle R11i Payment Type Code) |
Credit Card Expiration Date |
CREDIT_CARD_ EXPIRATION_DATE |
CREDIT_CARD_ EXPIRATION_DATE |
|
Credit Card Holder |
CREDIT_CARD_HOLDER_NAME |
CREDIT_CARD_HOLDER_NAME |
|
Credit Card Number |
CREDIT_CARD_NUMBER |
CREDIT_CARD_NUMBER |
|
Integration Id |
HEADER_ID |
|
HEADER_ID |
Back Office Order Number |
ORDER_NUMBER |
|
ORDER_NUMBER |
Contact Integration Id |
SOLD_TO_CONTACT_ID |
|
ORDERED_BY_CONTACT_ ID |
Hold Flag (hard coded in inbound DTE) |
|
|
|
Siebel Field (Order Entry - Line Items) |
Oracle Base Table (OE_ORDER_LINES_ ALL) |
Siebel to Oracle Integration (SIE_ORDER_LINES_INTERFACE) |
Oracle to Siebel Integration (SIE_LINES_ALL_V) |
Created |
CREATION_DATE |
CREATION_DATE |
|
Created By |
CREATED_BY |
CREATED_BY |
|
Updated |
LAST_UPDATE_DATE |
LAST_UPDATED_DATE |
|
Updated By |
LAST_UPDATED_BY |
LAST_UPDATED_BY (through EAI Value Map Oracle R11i User ID) |
|
Id (Order Entry - Orders) |
ORIG_SYS_DOCUMENT_ REF |
ORIG_SYS_DOCUMENT_ REF |
|
Id |
ORIG_SYS_LINE_REF |
ORIG_SYS_LINE_REF |
ORIG_SYS_LINE_REF |
Line Number |
LINE_NUMBER |
LINE_NUMBER |
LINE_NUMBER |
Quantity Requested |
|
ORDERED_QUANTITY |
ORDERED_QUANTITY |
No Siebel field available |
ORDERED_QUANTITY |
CALCULATE_PRICE_ FLAG (hard coded to Y in DTE) |
|
Due Date |
REQUEST_DATE |
REQUEST_DATE |
DATE_REQUESTED |
Base Price |
UNIT_LIST_PRICE |
UNIT_LIST_PRICE |
UNIT_LIST_PRICE |
Unit Price |
UNIT_SELLING_PRICE |
UNIT_SELLING_PRICE |
UNIT_SELLING_PRICE |
Product Integration Id |
INVENTORY_ITEM_ID |
INVENTORY_ITEM_ID |
INVENTORY_ITEM_ID |
Quantity Shipped |
SHIPPED_QUANTITY |
SHIPPED_QUANTITY |
SHIPPED_QUANTITY |
Order Priority (Order Entry - Orders) |
SHIPMENT_PRIORITY_ CODE |
SHIPMENT_PRIORITY_ CODE (through EAI Value Map Oracle R11i Shipment Priority) |
|
Siebel Field (Order Entry - Line Items) (continued) |
Oracle Base Table (OE_ORDER_LINES_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_LINES_INTERFACE) (continued) |
Oracle to Siebel Integration (SIE_LINES_ALL_V) (continued) |
Carrier Code |
SHIPPING_METHOD_ CODE |
SHIPPING_METHOD_ CODE (through EAI Value Map Oracle R11i Ship Method Code) |
SHIPPING_METHOD_CODE (through EAI Value Map Oracle R11i Ship Method Code) |
Price List Integration Id |
PRICE_LIST_ID |
PRICE_LIST_ID |
|
Source Inventory Loc Integration Id (Order Entry - Orders) |
SOLD_FROM_ORG_ID |
SOLD_FROM_ORG_ID |
|
|
SHIP_FROM_ORG_ID |
SHIP_FROM_ORG_ID |
|
Tax Exempt Flag |
TAX_EXEMPT_FLAG |
TAX_EXEMPT_FLAG (through EAI Value Map Oracle R11i Tax Exempt Flag) |
|
Tax Exempt Number |
TAX_EXEMPT_NUMBER |
TAX_EXEMPT_NUMBER |
TAX_EXEMPT_NUMBER |
Tax Exempt Reason |
TAX_EXEMPT_REASON_ CODE |
TAX_EXEMPT_REASON_ CODE (though EAI Value Map Oracle R11i Tax Exempt Reason) |
TAX_EXEMPT_REASON_ CODE (though EAI Value Map Oracle R11i Tax Exempt Reason) |
Organization Integration Id (Order Entry - Orders) |
ORG_ID |
ORG_ID |
|
Bill To Address Site Use Integration Id (Order Entry - Orders) |
INVOICE_TO_ORG_ID |
INVOICE_TO_ORG_ID |
|
Siebel Field (Order Entry - Line Items) (continued) |
Oracle Base Table (OE_ORDER_LINES_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_LINES_INTERFACE) (continued) |
Oracle to Siebel Integration (SIE_LINES_ALL_V) (continued) |
Ship to Address Integration Id |
CUST_ACCT_SITE_ID(HZ_CUST_SITE_USE_ALL) |
|
SHIP_TO_ADDRESS_ID |
Payment Term Integration Id (Order Entry - Orders) |
PAYMENT_TERM_ID |
PAYMENT_TERM_ID |
|
Integration Id |
LINE_ID |
|
LINE_ID |
Cancelled Quantity |
CANCELLED_QUANTITY |
|
CANCELLED_QUANTITY |
Price List Id (Siebel row_id of the associated price list is found in DTE function GetPriceListId, and then set Price List Id to this found row_id) |
|
|
|
Source Inventory Loc Id (Siebel row_id of the associated inventory location is found in DTE function GetInvLocId, and then set it to Source Inventory Loc Id) |
|
|
|
Siebel Field (Order Entry - Line Items) (continued) |
Oracle Base Table (OE_ORDER_LINES_ ALL) (continued) |
Siebel to Oracle Integration (SIE_ORDER_LINES_INTERFACE) (continued) |
Oracle to Siebel Integration (SIE_LINES_ALL_V) (continued) |
Invoiced Quantity |
INVOICED_QUANTITY |
|
INVOICED_QUANTITY |
Status |
FLOW_STATUS_CODE |
|
STATUS (through EAI Value Map "Oracle R11i Order Line Status") |
Shipment Number |
SHIPMENT_NUMBER |
|
SHIPMENT_NUMBER |
Scheduled Ship Date |
SCHEDULE_SHIP_DATE |
|
SCHEDULE_DATE |
Hold Flag (hard-coded in inbound DTE) |
|
|
|