Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for Oracle Applications > Detailed Data Mappings > EAI Value Mappings for Oracle Applications R10.7 >
Siebel Application to Oracle R10.7 Integration EAI Value Maps
Oracle Account Category
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel account type to Oracle customer category mapping
Siebel User Interface. Type (Account)
Siebel Buscomp.Field. Account.Type
Siebel LOV Type. ACCOUNT_ TYPE
Oracle User Interface. Category (Customer)
Oracle Table.Column. RA_ CUSTOMERS. CUSTOMER_ CATEGORY_ CODE
Oracle Lookup Type (Table). CUSTOMER_ CATEGORY (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > Sales and Marketing categories for customers
Oracle Account Phone
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel account field name containing phone number mapping to Oracle phone type
Siebel User Interface. Main Fax #, Main Phone # (Account)
Siebel Buscomp.Field. Account.*
Siebel LOV Type. N/A
Oracle User Interface. Telephone Type (Customer)
Oracle Table.Column. RA_PHONES. PHONE_TYPE
Oracle Lookup Type (Table). COMMUNICATION_TYPE (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > Types of communication used in contacting customers
Oracle Account Status
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel account status to Oracle customer status mapping
Siebel User Interface.Status (Account)
Siebel Buscomp.Field. Account. Account Status
Siebel LOV Type. ACCOUNT_ STATUS
Oracle User Interface. Status (Customer)
Oracle Table.Column. RA_ CUSTOMERS. STATUS
Oracle Lookup Type (Table). CUSTOMER_ STATUS (AR_ LOOKUPS)
Oracle Screen Navigation. Seeded in Oracle Database
Oracle Address Phone
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel address field name containing phone number mapping to Oracle phone type
Siebel User Interface. Not exposed in standard Account Address user interface
Siebel Buscomp.Field. Business Address.*
Siebel LOV Type. N/A
Oracle User Interface. Address Telephone Type (Customer)
Oracle Table.Column. RA_PHONES. PHONE_TYPE
Oracle Lookup Type (Table). COMMUNICATION_TYPE (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > Types of communication used in contacting customers
Oracle Contact Phone
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel contact field name containing phone number mapping to Oracle phone type
Siebel User Interface. Work Phone #, Work Fax #, Assistant Phone #, Home Phone # (Contact). Alternate Phone # and Cellular Phone # are not exposed in the standard UI.
Siebel Buscomp.Field. Contact.*
Siebel LOV Type. N/A
Oracle User Interface. Telephone Type (Customer Contact)
Oracle Table.Column. RA_PHONES. PHONE_TYPE
Oracle Lookup Type (Table). COMMUNICATION_TYPE (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > Types of communication used in contacting customers
Oracle Contact Title
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle Contact title (Mr., Mrs., and so on) mapping
Siebel User Interface. Mr./Ms. (Contact)
Siebel Buscomp.Field. Contact.M/M
Siebel LOV Type. MR_MS
Oracle User Interface. Title (Customer Contact)
Oracle Table.Column. RA_ CONTACTS. TITLE
Oracle Lookup Type (Table). CONTACT_ TITLE (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > Titles of contact persons at customer sites
Oracle Country
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle country mapping
Siebel User Interface. Country (Account Address)
Siebel Buscomp.Field. Business Address.Country
Siebel LOV Type. COUNTRY
Oracle User Interface. Country (Customer Address)
Oracle Table.Column. RA_ ADDRESSES_ALL.COUNTRY
Oracle Lookup Type (Table). FND_ TERRITORIES.TERRITORY_ CODE
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Country
Oracle Fob code
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel Freight Terms Info to Oracle FOB Point
Siebel User Interface. Shipping Terms Info
Siebel Buscomp.Field. Order Entry - Orders.Freight Terms Info
Siebel LOV Type. Not configured in standard product. A picklist should be configured on this field to take advantage of this mapping.
Oracle User Interface. FOB Point (Order)
Oracle Table.Column. SO_HEADERS_ALL.FOB_ CODE
Oracle Lookup Type (Table). FOB (AR_ LOOKUPS) (exposed through SO_ FOBS_ACTIVE_V)
Oracle Screen Navigation. (AR Super User responsibility) Navigate > Setup System > Quickcodes > Receivables > FOB
Oracle Freight
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle freight terms mapping
Siebel User Interface. Shipping Terms (Order), Shipping Terms (Price List)
Siebel Buscomp.Field. Order Entry - Orders.Freight Terms, Price List.Freight Terms
Siebel LOV Type. FREIGHT_TERMS
Oracle User Interface. Freight Terms (Order), Freight Terms (Price List)
Oracle Table.Column. SO_HEADERS_ALL.FREIGHT_TERMS_ CODE
Oracle Lookup Type (Table). FREIGHT_ TERMS (SO_ LOOKUPS)
Oracle Screen Navigation. (Entry Super User responsibility) Navigate > Setup > Order Entry > Freight Terms
Oracle Order Status
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle order status mapping
Siebel User Interface. Status (Order)
Siebel Buscomp.Field. Order Entry - Orders.Status
Siebel LOV Type. FS_ORDER_ STATUS
Oracle User Interface. Entry Status (Order)
Oracle Table.Column. SIE_ORDER_ HEADER_ STATUS_ V.STATUS
Oracle Lookup Type (Table). SO_ENTRY_ STATUSES_ ACTIVE_ V.ENTRY_ STATUS
Oracle Screen Navigation. (Order Entry Super User responsibility) Navigate > Setup > Orders > Cycles > Results
Oracle Order Line Status
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle order line status mapping
Siebel User Interface. Status (Order)
Siebel Buscomp.Field. Order Entry - OrdersLines. Status
Siebel LOV Type. FS_ORDER_ STATUS
Oracle User Interface. Status (Order)
Oracle Table.Column:. Oracle Lookup Type (Table):
Oracle Screen Navigation. (Order Entry Super User activity) Navigate > Setup > Orders > Cycles > Results
Oracle Order Type
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Order type mapping
Siebel User Interface. Type (Order)
Siebel Buscomp.Field. Order Entry - Orders.Order Type --> Order Entry - Order Types.Order Type
Siebel LOV Type. FS_ORDER_ TYPE
Oracle User Interface. Type (Order)
Oracle Table.Column. SO_HEADERS_ALL.ORDER_ TYPE_ID -> SO_ORDER_ TYPES_ALL. ORDER_TYPE_ID -> SO_ORDER_ TYPES_ALL. NAME
Oracle Lookup Type (Table). N/A
Oracle Screen Navigation. (Order Entry Super User activity) Navigate > Setup > Orders > Types
Table 32. Oracle Order Type Direction Siebel Value Siebel Display Value Oracle Value Oracle Meaning Siebel Outbound eSales Order eSales Order Standard N/A Sales Order Sales Order Standard N/AOracle Payment Type Code
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Payment Type mapping
Siebel User Interface. Payment Method (Order)
Siebel Buscomp.Field. Order Entry - Orders.Payment Method
Siebel LOV Type. PAYMENT_ METHOD
Oracle User Interface. Payment Type (Order)
Oracle Table.Column. SO_HEADERS_ALL.PAYMENT_TYPE_CODE
Oracle Lookup Type (Table). PAYMENT TYPE (SO_ LOOKUPS)
Oracle Screen Navigation. (Order Entry Super User activity) Navigate > Setup > Quickcodes > Order Entry > Payment Type
Oracle Sales Rep ID
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel user ID to Oracle Sales Rep ID mapping
Siebel User Interface. Help > About Record (User)
Siebel Buscomp.Field. Order Entry - Orders.Primary Position Contact Id
Siebel LOV Type. N/A
Oracle User Interface. Salesperson (Order)
Oracle Table.Column. SO_HEADERS_ALL. SALESREP_ID > RA_ SALESREPS_ ALL. SALESREP_ID
Oracle Lookup Type (Table). N/A
Table 34. Oracle Sales Rep ID Direction Siebel Value Siebel Display Value Oracle Value Oracle Meaning Siebel Outbound 0-1 SADMIN 1025Oracle Ship Method Code
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Order Ship Carrier mapping
Siebel User Interface. Ship Carrier (Order), Shipping Method (Price List)
Siebel Buscomp.Field. Order Entry - Orders.Carrier Type, Price List.Shipping Method
Siebel LOV Type. FS_CARRIER/SHIPPING_ METHOD
Oracle User Interface. Freight Carrier (Order), Freight Carrier (Price List)
Oracle Table.Column. SO_HEADERS_ALL.SHIP_ METHOD_ CODE, SO_PRICE_ LISTS.SHIP_ METHOD_ CODE
Oracle Lookup Type (Table). ORG_FREIGHT.FREIGHT_ CODE
Oracle Screen Navigation. (Order Entry Super User activity) Navigate > Setup > Shipping > Carriers
Oracle Shipment Priority Code
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Order priority mapping
Siebel User Interface. Priority (Order)
Siebel Buscomp.Field. Order Entry - Orders.Order Priority
Siebel LOV Type. FS_INVLOC_ ORDPRI
Oracle User Interface. Shipment Priority (Order)
Oracle Table.Column. SO_HEADERS_ALL. SHIPMENT_ PRIORITY_ CODE
Oracle Lookup Type (Table). SHIPMENT_ PRIORITY (SO_ LOOKUPS)
Oracle Screen Navigation. (Order Entry Super User activity) Navigate > Setup > Quickcodes > Order Entry > Shipment Priorities
Oracle Tax Exempt Flags
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Tax Exempt status mapping
Siebel User Interface. Tax Exempt (Order)
Siebel Buscomp.Field. Order Entry - Orders.Tax Exempt
Siebel LOV Type. Boolean Y/N
Oracle User Interface. Tax Exemption Tax (Order)
Oracle Table.Column. SO_HEADERS_ALL.TAX_ EXEMPT_ FLAG
Oracle Lookup Type (Table). S (Standard), E (Exempt), R (Require)
Table 37. Oracle Tax Exempt Flags Direction Siebel Value Siebel Display Value Oracle Value Oracle Meaning Siebel Inbound N Unchecked S Standard Siebel Outbound N Unchecked S StandardOracle Tax Exempt Reason
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Tax Exempt Reason mapping
Siebel User Interface. Not exposed in standard User Interface
Siebel Buscomp.Field. Order Entry - Orders.Tax Exempt Reason
Siebel LOV Type. N/A (unbounded)
Oracle User Interface. Tax Exemption: Reason (Order)
Oracle Table.Column. SO_HEADERS_ALL.TAX_ EXEMPT_ REASON_ CODE
Oracle Lookup Type (Table). TAX_REASON (AR_ LOOKUPS)
Oracle Screen Navigation. (AR Super User activity) Navigate > Setup > System > Quickcodes > Receivables > Tax Exemption Reason
Oracle Unit of Measure
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Product unit of measure mapping
Siebel User Interface. U/M (Product)
Siebel Buscomp.Field. Order Entry - Line Items.Product Unit of Measure, Internal Product.Unit of Measure
Siebel LOV Type. UNIT_OF_ MEASURE
Oracle User Interface. Unit (Order Line), Primary Unit of Measure (Item)
Oracle Table.Column. SO_LINES_ ALL.UNIT_ CODE,
MTL_S YSTEM_ITEMS.PRIMARY_ UOM_CODEOracle Lookup Type (Table). MTL_UNITS_OF_MEASURE.UOM_CODE
Oracle Screen Navigation. (Order Entry Super User activity) Navigate >Setup > UOM > Units
Oracle User ID
KEY:
Siebel List of Values (LOV) types are based on the business component PickList Generic (S_LST_OF_VAL table) unless indicated otherwise.
Siebel Display Value and Oracle Meaning are in American English language.
Description. Siebel to Oracle User ID mapping
Siebel User Interface. Help > About Record
Siebel Buscomp.Field. Created By, Updated By, and so on > S_USER. ROW_ID
Siebel LOV Type. N/A
Oracle User Interface. Row - who
Oracle Table.Column. CREATED_BY, LAST_ UPDATED_BY, and so on--> FND_ USER.USER_ ID
Oracle Lookup Type (Table). N/A
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for Oracle Applications Published: 18 April 2003 |