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

Table 21. Oracle Account Category
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Commercial
Commercial
Commercial Customer
Commercial Customer
Customer
Customer
CUSTOMER
Customer
Federal
Federal
Govt Customer
Govt Customer
Siebel Inbound
Commercial
Commercial
Commercial Customer
Commercial Customer
Customer
Customer
CUSTOMER
Customer
Federal
Federal
Govt Customer
Govt Customer

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

Table 22. Oracle Account Phone
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Main Fax Number
N/A
FAX
Fax
Main Phone Number
N/A
GEN
General
Siebel Inbound
Main Fax Number
N/A
FAX
Fax
Main Phone Number
N/A
GEN
General

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

Table 23. Oracle Account Status
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Active
Active
A
Active Only
Inactive
Inactive
I
Inactive Only
Siebel Inbound
Active
Active
A
Active Only
Inactive
Inactive
I
Inactive Only

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

Table 24. Oracle Address Phone
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Fax Number
N/A
FAX
Fax
Phone Number
N/A
GEN
General
Siebel Inbound
Fax Number
N/A
FAX
Fax
Phone Number
N/A
GEN
General

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

Table 25. Oracle Contact Phone
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Alternate Phone #
N/A
ALTERNATE
Alternate Phone
Assistant Phone #
N/A
ASSISTANT
Assistant Phone
Cellular Phone #
N/A
CELL
Cellular Phone
Fax Phone #
N/A
FAX
Fax
Siebel Outbound (continued)
Home Phone #
N/A
HOME
Home Phone
Work Phone #
N/A
GEN
General Phone
Siebel Inbound
Alternate Phone #
N/A
ALTERNATE
Alternate Phone
Assistant Phone #
N/A
ASSISTANT
Assistant Phone
Cellular Phone #
N/A
CELL
Cellular Phone
Fax Phone #
N/A
FAX
Fax
Home Phone #
N/A
HOME
Home Phone
Work Phone #
N/A
GEN
General Phone

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

Table 26. Oracle Contact Title
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Mr.
Mr.
MR
Mr.
Mrs.
Mrs.
MRS
Mrs.
Ms.
Ms.
MS
Ms.
Dr.
Dr.
DR
Dr.
Miss
Miss
MISS
Miss
Siebel Inbound
Mr.
Mr.
MR
Mr.
Mrs.
Mrs.
MRS
Mrs.
Ms.
Ms.
MS
Ms.
Dr.
Dr.
DR
Dr.
Miss
Miss
MISS
Miss

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

Table 27. Oracle Country
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Inbound
USA
USA
US
United States
United Kingdom
United Kingdom
GB
United Kingdom
Siebel Outbound
USA
USA
US
United States
United Kingdom
United Kingdom
GB
United Kingdom
36 more Siebel countries are being mapped.

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

Table 28. Oracle Fob Code
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Destination
N/A
BUY
Destination
Origin
N/A
SEL
Origin
CIF
N/A
CIF
CIF
Siebel Inbound
Destination
N/A
BUY
Destination
Origin
N/A
SEL
Origin
CIF
N/A
CIF
CIF

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

Table 29. Oracle Freight
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Due
Due
Due
Buyer pays freight
No Charge
No Charge
Paid
Seller pays freight
FOB
FOB
FOB
Freight on Board
TBD
TBD
TBD
To be decided
Siebel Inbound
Due
Due
Due
Buyer pays freight
No Charge
No Charge
Paid
Seller pays freight
FOB
FOB
FOB
Freight on Board
TBD
TBD
TBD
To be decided

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

Table 30. Oracle Order Status
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Booked
Booked
Booked
N/A
Open
Open
Entered
N/A
Booked
Booked
Enter Booked
N/A
Open
Open
Enter Entered
N/A
Siebel Inbound
Booked
Booked
Enter Booked
N/A
Open
Open
Booked
N/A
Open
Open
Enter Partial
N/A
Closed
Closed
Complete Order-Closed
N/A
Cancelled
Cancelled
Cancel Order-Complete
N/A

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

Table 31. Oracle Order Line Status
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Inbound
Open
Open
Enter-Entered
NA
Booked
Booked
Enter-Booked
NA
Booked
Booked
Demand Interface-Partial
NA
Booked
Booked
Demand Interface-Interfaced
NA
Shipped
Shipped
Ship Confirm-Confirmed
NA
Shipped
Shipped
Ship Confirm-Backordered Complete
NA
Siebel Inbound (continued)
Shipped
Shipped
Inventory Interface-Interface Error
NA
Shipped
Shipped
Inventory Interface - Interfaced
NA
Partially Shipped
Partially Shipped
Ship Confirm-Partial
NA
Partially Shipped
Partially Shipped
Ship Confirm-Backordered-Partial
NA
Shipped
Shipped
Receivables Interface-Partial
NA
Shipped
Shipped
Receivables Interface-Interfaced
NA
Picked
Picked
Pick Release-Released
NA
Picked
Picked
Prick Release-Partial
NA
Picked
Picked
Backorder Release-Released
NA
Picked
Picked
Backorder Release-Partial
NA
Closed
Closed
Complete Line-Closed
NA
Closed
Closed
Booked
NA
Cancelled
Cancelled
Pick Release-Not Applicable
NA
Cancelled
Cancelled
Backorder Release-Not Applicable
NA
Cancelled
Cancelled
Cancel Line-Partial
NA

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/A

Oracle 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

Table 33. Oracle Payment Type Code
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Cash
N/A
CASH
Cash
Check
N/A
CHECK
Check
Credit
N/A
CREDIT
Credit Card
Siebel Inbound
Cash
N/A
CASH
Cash
Check
N/A
CHECK
Check
Credit
N/A
CREDIT
Credit Card

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
1025
 

Oracle 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

Table 35. Oracle Ship Method Code
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Airborne
Airborne
AIRBORNE
Airborne
DHL
DHL
DHL
DHL
Emery
Emery
EMERY
Emery
Federal Express
Federal Express
FedExEcon
Federal Express
UPS
UPS
UPS
UPS
US Mail
US Mail
USMAIL
US Mail
Siebel Inbound
Airborne
Airborne
AIRBORNE
Airborne
DHL
DHL
DHL
DHL
Emery
Emery
EMERY
Emery
Federal Express
Federal Express
FedExEcon
Federal Express
 
UPS
UPS
UPS
UPS
US Mail
US Mail
USMAIL
US Mail

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

Table 36. Oracle Shipment Priority Code
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Inbound
Urgent
Urgent
Priority 1
Urgent orders
High
High
Priority 2
High priority orders
Medium
Medium
Priority 3
Standard orders
Low
Low
Priority 4
Low priority orders
Siebel Outbound
Urgent
Urgent
Priority 1
Urgent orders
High
High
Priority 2
High priority orders
Medium
Medium
Priority 3
Standard orders
Low
Low
Priority 4
Low priority orders

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
Standard

Oracle 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

Table 38. Oracle Tax Exempt Reason
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
Education
N/A
EDUCATION
education
Hospital
N/A
HOSPITAL
hospital
Manufacturer
N/A
MANUFACTURER
manufacturer
Siebel Inbound
Education
N/A
EDUCATION
education
Hospital
N/A
HOSPITAL
hospital
Manufacturer
N/A
MANUFACTURE
manufacturer

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_CODE

Oracle Lookup Type (Table). MTL_UNITS_OF_MEASURE.UOM_CODE

Oracle Screen Navigation. (Order Entry Super User activity) Navigate >Setup > UOM > Units

Table 39. Oracle Unit of Measure
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Inbound
Dozen
Dozen
DZ
Dozen
Each
Each
EA
Each
Gram
Gram
G
Gram
Kilogram
Kilogram
KG
Kilogram
Litre
Litre
L
Liter
Ounce
Ounce
OZ
Ounce
Pound
Pound
LBS
Pound
Day
Day
DAY
Day
Foot
Foot
FT
Foot
Hour
Hour
HR
Hour
Dollar
Dollar
USD
US Dollar
Year
Year
YR
Year
Bag
Bag
BAG
Bag
Case
Case
CSE
Case
Half Pallet
Half Pallet
HPL
Half Pallet
Pallet
Pallet
PL
Pallet
Thousand
Thousand
BTH
Box of 1000
Unit
Unit
UNT
Unit
Siebel Outbound
Dozen
Dozen
DZ
Dozen
Each
Each
EA
Each
Gram
Gram
G
Gram
Kilogram
Kilogram
KG
Kilogram
Litre
Litre
L
Liter
Ounce
Ounce
OZ
Ounce
Pound
Pound
LBS
Pound
Day
Day
DAY
Day
Foot
Foot
FT
Foot
Hour
Hour
HR
Hour
Dollar
Dollar
USD
US Dollar
Year
Year
YR
Year
Bag
Bag
BAG
Bag
Case
Case
CSE
Case
Half Pallet
Half Pallet
HPL
Half Pallet
Pallet
Pallet
PL
Pallet
Thousand
Thousand
BTH
Box of 1000
Unit
Unit
UNT
Unit

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

Table 40. Oracle User ID
Direction
Siebel Value
Siebel Display Value
Oracle Value
Oracle Meaning
Siebel Outbound
0-1
SADMIN
1000113
N/A


 Siebel Connector for Oracle Applications 
 Published: 18 April 2003