Bookshelf Home | Contents | Index | 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 MapsOracle Account CategorySiebel 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 PhoneSiebel 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.* 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 StatusSiebel 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 PhoneSiebel 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.* 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 PhoneSiebel 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.* 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 TitleSiebel 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 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 CountrySiebel 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 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 codeSiebel 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 FreightSiebel 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 StatusSiebel 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 StatusSiebel 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 TypeSiebel 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 Oracle Payment Type CodeSiebel 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 IDSiebel 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 Oracle User Interface. Salesperson (Order) Oracle Table.Column. SO_HEADERS_ALL. SALESREP_ID > RA_ SALESREPS_ ALL. SALESREP_ID Oracle Lookup Type (Table). N/A Oracle Ship Method CodeSiebel 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 CodeSiebel 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 FlagsSiebel 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 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) Oracle Tax Exempt ReasonSiebel 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 MeasureSiebel 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, Oracle Lookup Type (Table). MTL_UNITS_OF_MEASURE.UOM_CODE Oracle Screen Navigation. (Order Entry Super User activity) Navigate >Setup > UOM > Units Oracle User IDSiebel 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 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 |
Siebel Connector for Oracle Applications |