Table 20. Account Attribute Mapping
Siebel Field
|
Oracle Base Column
|
Siebel to Oracle Integration
|
Oracle to Siebel Integration
|
Siebel Field (Order Entry - Orders)
|
Oracle Base Column (SO_HEADERS_ALL)
|
Siebel to Oracle Integration (SIE_HEADERS_INTERFACE_ALL)
|
Oracle to Siebel Integration
(SIE_HEADERS_ALL_V)
|
Id
|
ORIGINAL_SYSTEM_REFERENCE
|
ORIG_SYSTEM_ REFERENCE
|
ORIG_SYSTEM_REFERENCE
|
Order Number
|
PURCHASE_ORDER_NUM
|
PURCHASE_ORDER_NUM
|
PURCHASE_ORDER_NUM
|
Order Date
|
DATE_ORDERED
|
DATE_ORDERED
|
DATE_ORDERED
|
Pricing Date
|
CONVERSION_DATE
|
CONVERSION_DATE
|
CONVERSION_DATE
|
Ship to Account Integration Id
|
SHIP_TO_SITE_USE_ID
|
SHIP_TO_CUSTOMER_ID
|
SHIP_TO_CUSTOMER_ID
|
Account Integration Id
|
CUSTOMER_ID
|
CUSTOMER_ID
|
CUSTOMER_ID
|
Bill To Account Integration Id
|
INVOICE_TO_SITE_USE_ID
|
INVOICE_CUSTOMER_ID
|
INVOICE_TO_CUSTOMER_ID
|
Bill To Address Integration Id
|
INVOICE_TO_SITE_USE_ID
|
INVOICE_ADDRESS_ID
|
|
Ship To Address Integration Id
|
SHIP_TO_SITE_USE_ID
|
SHIP_ADDRESS_ID
|
SHIP_ADDRESS_ID
|
Requested Ship Date
|
DATE_REQUESTED_CURRENT
|
DATE_REQUESTED_CURRENT
|
DATE_REQUESTED_CURRENT
|
Ship To Contact Integration Id
|
SHIP_TO_CONTACT_ID
|
SHIP_TO_CONTACT_ID
|
|
Contact Integration Id
|
ORDERED_BY_CONTACT_ID
|
ORDERED_BY_CONTACT_ID
|
ORDERED_BY_CONTACT_ID
|
Number before "-" in:
Price List Integration Id
|
PRICE_LIST_ID
|
PRICE_LIST_ID
|
|
Bill To Contact Integration Id
|
INVOICE_TO_CONTACT_ID
|
INVOICE_TO_CONTACT _ID
|
|
Ship Instructions
|
SHIPPING_INSTRUCTIONS
|
SHIPPING_INSTRUCTIONS
|
SHIPPING_INSTRUCTIONS
|
Organization Integration Id
|
ORG_ID
|
ORG_ID
|
ORG_ID
|
Comments
|
PACKING_INSTRUCTIONS
|
|
PACKING_INSTRUCTIONS
|
Integration Id
|
HEADER_ID
|
|
HEADER_ID
|
Back Office Order Number
|
ORDER_NUMBER
|
|
ORDER_NUMBER
|
Status
|
NAME
(SO_RESULTS)
|
ORDER_STATUS
(through EAI Value Map Oracle Order Status)
|
STATUS
(SIE_ORDER_HEADER_STATUS_V)
|
Hold Flag
|
|
|
Calculated based on the existence of row in
SIE_ORDER_HEADER_HOLDS_V
|
Created By
|
CREATED_BY
|
CREATED_BY (through value map Oracle User ID)
|
|
Updated By
|
LAST_UPDATED_BY
|
LAST_UPDATED_BY (through value map Oracle User ID)
|
|
Created
|
CREATION_DATE
|
CREATION_DATE
|
|
Updated
|
LAST_UPDATE_DATE
|
LAST_UPDATE_DATE
|
|
Currency Code
|
CURRENCY_CODE
|
CURRENCY_CODE
|
CURRENCY_CODE
|
Order Type
|
ORDER_TYPE_ID SO_ORDER_TYPES_ALL.NAME
|
ORDER_TYPE
(through EAI Value Map Oracle Order Type)
|
|
Tax Exempt
|
TAX_EXEMPT_FLAG
|
TAX_EXEMPT_FLAG
(through EAI Value Map Oracle Tax Exempt Flag)
|
TAX_EXEMPT_FLAG
(through EAI Value Map Oracle Tax Exempt Flag)
|
Tax Exempt Reason
|
TAX_EXEMPT_REASON_CODE
|
TAX_EXEMPT_REASON_ CODE
(through EAI Value Map Tax Exempt Reason)
|
TAX_EXEMPT_REASON_CODE
(through EAI Value Map Tax Exempt Reason)
|
Payment Method
|
PAYMENT_TYPE_CODE
|
PAYMENT_TYPE_CODE
(through EAI Value Map Oracle Payment Type Code)
|
PAYMENT_TYPE_CODE
(through EAI Value Map "Oracle Payment Type Code)
|
Order Priority
|
SHIPMENT_PRIORITY_CODE
|
SHIPMENT_PRIORITY_ CODE
(through EAI Value Map Oracle Shipment Priority Code)
|
SHIPMENT_PRIORITY_CODE
(through EAI Value Map Oracle Shipment Priority Code)
|
Carrier Type
|
SHIP_METHOD_CODE
|
SHIP_METHOD_CODE
(through EAI Value Map Oracle Ship Method Code)
|
|
Freight Terms
|
FREIGHT_TERMS_ CODE
|
FREIGHT_TERMS_CODE
(through EAI Value Map Oracle Freight)
|
FREIGHT_TERMS_CODE
(through EAI Value Map "Oracle Freight")
|
Freight Terms Info
|
FOB_CODE
|
FOB_CODE
(through EAI Value Map Oracle Fob Code)
|
FOB_CODE
(through EAI Value Map Oracle Fob Code)
|
Payment Term Integration Id
|
TERMS_ID
|
TERMS_ID
|
|
Primary Position Contact Id
|
SALESREP_ID
|
SALESREP_ID
(through EAI Value Map Oracle Sales Rep ID)
|
|
Siebel Field (Order Entry - Line Items)
|
Oracle Base Column
(SO_LINES_ALL)
|
Siebel to Oracle Integration
(SIE_LINES_INTERFACE_ ALL)
|
Oracle to Siebel Integration
(SIE_LINES_ALL_V)
|
Order Number
|
SO_HEADERS_ALL. PURCHASE_ORDER_ NUM
|
|
PURCHASE_ORDER_NUM
(SIE_HEADERS_ALL_V)
|
Line Number
|
LINE_NUMBER
|
LINE_NUMBER
|
LINE_NUMBER
|
Quantity Requested
|
ORDERED_QUANTITY
|
ORDERED_QUANTITY
|
ORDERED_QUANTITY
|
Due Date
|
DATE_REQUESTED_ CURRENT
|
DATE_REQUESTED_ CURRENT
|
DATE_REQUESTED_CURRENT
|
Base Price
|
LIST_PRICE
|
LIST_PRICE
|
LIST_PRICE
|
Item Price
|
SELLING_PRICE
|
SELLING_PRICE
|
|
Product Integration Id
|
INVENTORY_ITEM_ID
|
INVENTORY_ITEM_ID
|
INVENTORY_ITEM_ID
|
Organization Integration Id
|
ORG_ID
|
ORG_ID
|
|
Quantity Shipped
|
SHIPPED_QUANTITY
|
|
|
|
TAX_CODE
|
TAX_CODE
|
TAX_CODE
(SIE_LINES_ALL_V)
|
Number before "-" in:
Price List Integration Id
|
PRICE_LIST_ID
|
PRICE_LIST_ID
|
|
Id
|
ORIGINAL_SYSTEM_ LINE_REFERENCE
|
ORIGINAL_SYSTEM_LINE_ REFERENCE
|
ORIGINAL_SYSTEM_LINE_ REFERENCE
|
Ship To Address Integration Id
(Order Entry - Orders)
|
SHIP_TO_SITE_USE_ID
|
SHIP_ADDRESS_ID
|
SHIP_TO_ADDRESS_ID
|
Account Integration Id
(Order Entry - Orders)
|
SHIP_TO_SITE_USE_ID
|
SHIP_TO_CUSTOMER_ID
|
See bug 12-57RW00
|
Contact Integration Id
(Order Entry - Orders)
|
SHIP_TO_CONTACT_ID
|
SHIP_TO_CONTACT_ID
|
See bug 12-57RW00
|
Created By
|
CREATED_BY
|
CREATED_BY (through value map Oracle User ID)
|
|
Updated By
|
LAST_UPDATED_BY
|
LAST_UPDATED_BY (through value map Oracle User ID)
|
|
Created
|
CREATION_DATE
|
CREATION_DATE
|
|
Updated
|
LAST_UPDATE_DATE
|
LAST_UPDATE_DATE
|
|
Product Unit of Measure
|
UNIT_CODE
|
UNIT_CODE
(through EAI Value Map Oracle Unit of Measure)
|
UNIT_CODE
(through EAI Value Map Oracle Unit of Measure)
|
Carrier Code
|
SHIP_METHOD_CODE
|
SHIP_METHOD_CODE
(through EAI Value Map Oracle Ship Method Code)
|
|
Source Inventory Loc Integration Id (Order Entry - Orders)
|
WAREHOUSE_ID
|
WAREHOUSE_ID
|
|
Order Priority
(Order Entry - Orders)
|
SHIPMENT_PRIORITY_CODE
|
SHIPMENT_PRIORITY_CODE
|
|
Payment Term Integration Id
(Order Entry - Orders)
|
TERMS_ID
|
TERMS_ID
|
|
Calculate Price Flag
(Order Entry - Line Items)
|
|
CALCULATE_PRICE
(value is calculated depending on Siebel Field Item Price, if Item Price is not null, set it to Y, and otherwise set it to N)
|
|
Integration Id
|
LINE_ID
|
|
LINE_ID
|
Quantity To Invoice
|
QUANTITY_TO_ INVOICE
|
|
QUANTITY_TO_INVOICE
|
Status
|
NAME
(SO_RESULTS)
|
|
STATUS
(SIE_ORDER_LINE_ STATUS_V)
|
Hold Flag
|
|
|
Calculated based on the existence of integration component SIE_ORDER_LINE_HOLDS_V
|
Ship Method
|
SHIP_METHOD_CODE
|
|
SHIP_METHOD_CODE
(through EAI Value Map Oracle Ship Method Code)
|
Order Priority
(Order Entry - Orders)
|
SHIPMENT_PRIORITY_CODE
|
SHIPMENT_PRIORITY_ CODE (through EAI Value Map Oracle Shipment Priority Code)
|
SHIPMENT_PRIORITY_CODE
(SIE_LINES_ALL_V) (through EAI Value Map Oracle Shipment Priority Code)
|
Siebel Field (Order Entry - Line Items)
|
Oracle Base Column
(SO_PRICE_ ADJUSTMENTS)
|
Siebel to Oracle Integration
(SIE_PRICE_ ADJUSTMENT_INT)
|
Oracle to Siebel Integration
|
Calculated Net Discount Percent
|
PERCENT
|
PERCENT
|
|
Number after "-" in: Price List Integration Id
(Order Entry - Orders)
|
DISCOUNT_ID
|
DISCOUNT_ID
|
|
Volume Discount Integration Id
|
DISCOUNT_LINE_ID
|
DISCOUNT_LINE_ID
|
|
Id
|
LINE_ID
|
ORIGINAL_SYSTEM_LINE_ REFERENCE
|
|
Id
(Order Entry - Orders)
|
HEADER_ID
|
ORIGINAL_SYSTEM_ REFERENCE
|
|
Created By
|
CREATED_BY
|
CREATED_BY (through value map Oracle User ID)
|
|
Updated By
|
LAST_UPDATED_BY
|
LAST_UPDATED_BY (through value map Oracle User ID)
|
|
Created
|
CREATION_DATE
|
CREATION_DATE
|
|
Siebel Field (Order Entry - Line Item Actions - "Schedule")
|
Oracle Base Column
|
Siebel to Oracle Integration
|
Oracle to Siebel Integration (SIE_SCHEDULE_QUANTITIES_V)
|
Line Item Action Type
|
|
|
Schedule
|
Actual Start Date
|
SCHEDULE_DATE
(SO_LINES_ALL, SO_LINES_DETAILS)
|
|
DATE_SCHEDULE
|
Quantity
|
ORDERED_QUANTITY
(SO_LINES_ALL,
SO_LINE_DETAILS)
|
|
SCHEDULE_QUANTITY
|
Integration Id
|
LINE_ID
(SO_LINES_ALL),
LINE_DETAIL_ID
(SO_LINE_DETAILS)
|
|
SCHEDULE_LINE_ID
|
Line Item Action Number
|
LINE_ID
(SO_LINES_ALL),
LINE_DETAIL_ID
(SO_LINE_DETAILS)
|
|
SCHEDULE_LINE_ID
|
Siebel Field (Order Entry - Line Item Actions - "Ship")
|
Oracle Base Column (SO_PICKING_LINES_ALL)
|
Siebel to Oracle Integration
|
Oracle to Siebel Integration (SIE_SHIPMENT_QUANTITIES_V)
|
Line Item Action Type
|
|
|
Ship
|
Actual Start Date
|
DATE_SHIPPED
(SO_PICKING_HEADERS_ALL)
|
|
DATE_SHIPPED
|
Quantity
|
SHIPPED_QUANTITY
|
|
SHIPPED_QUANTITY
|
Integration Id
|
PICKING_LINE_ID
|
|
PICKING_LINE_ID
|
Line Item Action Number
|
PICKING_LINE_ID
|
|
PICKING_LINE_ID
|