Table 20. Account Attribute Mapping
|
|
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 |
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 (See Address Mapping for R10.7) |
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 (See Address Mapping for R10.7) |
INVOICE_CUSTOMER_ID |
INVOICE_TO_CUSTOMER_ID |
Bill To Address Integration Id |
INVOICE_TO_SITE_USE_ID (See Address Mapping for R10.7) |
INVOICE_ADDRESS_ID |
|
Ship To Address Integration Id |
SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7) |
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
|
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) |
|
Siebel to Oracle Integration (SIE_LINES_INTERFACE_ ALL) |
Oracle to Siebel Integration |
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 (See Address Mapping for R10.7) |
SHIP_ADDRESS_ID |
SHIP_TO_ADDRESS_ID |
Account Integration Id (Order Entry - Orders) |
SHIP_TO_SITE_USE_ID (See Address Mapping for R10.7) |
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) |
(See Price Adjustment Mapping for R10.7) |
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") |
|
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 |