Table 51. Order Attribute Mapping
Siebel Field
|
Oracle Base Column
|
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)
|
|
|
|