Bookshelf v7.7: Siebel Application to Oracle R10.7 Integration EAI Value Maps

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
Siebel Outbound	Main Phone Number	N/A	GEN	General
Siebel Inbound	Main Fax Number	N/A	FAX	Fax
Siebel Inbound	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
Siebel Outbound	Inactive	Inactive	I	Inactive Only
Siebel Inbound	Active	Active	A	Active Only
Siebel Inbound	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
Siebel Outbound	Phone Number	N/A	GEN	General
Siebel Inbound	Fax Number	N/A	FAX	Fax
Siebel Inbound	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
Siebel Outbound (continued)	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
Siebel Inbound	United Kingdom	United Kingdom	GB	United Kingdom
Siebel Outbound	USA	USA	US	United States
Siebel Outbound	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
Siebel Outbound	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