Siebel Simple Product

Oracle’s Siebel Simple Product ASI is used in the CME Create Product Business Integration Process and the CME Update Product Business Integration Process to create and synchronize Siebel simple products.

The following image shows the Siebel Simple Product ASI structure (for Internal Product), which contains the following components: Inventory Options, Related Equivalet Product, Related Inventory Location, Related Organization, Related Product, Related Product Line, Related Sales Tool by Product, and Related Warranty.

The following table lists the integration components and XML tags of this ASI.

Integration Component	XML Tag	User Keys
Internal Product	InternalProduct	Id Integration Id, Product Name Integration Id, Primary Organization, Primary Vendor, Product Name, Vendor Primary Organization, Vendor Site Primary Organization, Primary Vendor, Product Name, Vendor Primary Organization, Vendor Site
FS Inventory Options	InventoryOptions	Id Integration Id Inventory Type, Product Name
Internal Product_Equivalent Product	RelatedEquivalentProduct	Id Integration Id Equivalent Product, Equivalent Product Primary Organization, Equivalent Product Vendor, Equivalent Product Vendor Location, Equivalent Product Vendor Organization
FS Inventory Location	RelatedInventoryLocation	Id Integration Id Inventory Name, Primary Organization
Internal Product_Organization	RelatedOrganization	Id Integration Id Organization
Internal Product_Related Product	RelatedProduct	Id Integration Id Organization, Product Name, Vendor, Vendor Location
Internal Product_Admin Product Line	RelatedProductLine	Id Integration Id Product Line
Sales Tool by Product	RelatedSalesToolByProduct	Id Integration Id Name, Primary Organization
FS Warranty	RelatedWarranty	Id Integration Id Warranty Name, Warranty Provider Name, Warranty Provider Primary Organization, Warranty Provider Site

Internal Product Fields in Siebel Simple Product ASI

The following table lists Internal Product fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Allocate Below Safety Flag	AllocateBelowSafetyFlag	DTYPE_TEXT	30	No
Auto Allocate Flag	AutoAllocateFlag	DTYPE_TEXT	30	No
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	No
Class Id	ClassId	DTYPE_ID	NA	No
Class Integration Id	ClassIntegrationId	DTYPE_TEXT	30	No
Class Name	ClassName	DTYPE_TEXT	75	No
Class Type	ClassType	DTYPE_TEXT	30	No
Compensable	CompensableFlag	DTYPE_TEXT	NA	No
Description	Description	DTYPE_TEXT	255	No
Division Code	DivisionCode	DTYPE_TEXT	30	No
Effective End Date	EffectiveEndDate	DTYPE_DATETIME	NA	No
Effective Start Date	EffectiveStartDate	DTYPE_DATETIME	NA	No
Field Replacable	FieldReplacable	DTYPE_TEXT	NA	No
Global Assembly Level Code	GlobalAssemblyLevelCode	DTYPE_TEXT	50	No
Global Product Classification Code	GlobalProductClassificationCode	DTYPE_TEXT	50	No
Global Product Identifier	GlobalProductIdentifier	DTYPE_TEXT	50	No
Global Product Lifecycle Status Code	GlobalProductLifecycleStatusCode	DTYPE_TEXT	50	No
Global Supply Chain Code	GlobalSupplyChainCode	DTYPE_TEXT	50	No
Id	Id	DTYPE_ID	30	No
Image Name	ImageName	DTYPE_TEXT	100	No
Image Primary Organization Name	ImagePrimaryOrganizationName	DTYPE_TEXT	100	No
Image File Name	ImageFileName	DTYPE_TEXT	200	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
IsAdminMode	IsAdminMode	DTYPE_TEXT	NA	No
Item Size	ItemSize	DTYPE_NUMBER	NA	No
Lead Time	LeadTime	DTYPE_TEXT	30	No
MTBF	MTBF	DTYPE_NUMBER	NA	No
MTTR	MTTR	DTYPE_NUMBER	NA	No
Maximum Quantity	MaximumQuantity	DTYPE_NUMBER	NA	No
Minimum Quantity	MinimumQuantity	DTYPE_NUMBER	NA	No
Orderable	Orderable	DTYPE_TEXT	NA	No
Parent Internal Product Id (Joined)	ParentInternalProductId	DTYPE_ID	NA	No
Parent Internal Product Integration Id	ParentInternalProductIntegrationId	DTYPE_TEXT	30	No
Parent Internal Product Name	ParentInternalProductName	DTYPE_TEXT	100	No
Parent Internal Product Primary Organization	ParentInternalProductPrimaryOrganization	DTYPE_TEXT	100	No
Parent Internal Product Vendor	ParentInternalProductVendor	DTYPE_TEXT	100	No
Parent Internal Product Vendor Location	ParentInternalProductVendorLocation	DTYPE_TEXT	50	No
Parent Internal Product Vendor Organization	ParentInternalProductVendorOrganization	DTYPE_TEXT	100	No
Part Number	PartNumber	DTYPE_TEXT	50	No
Price Type	PriceType	DTYPE_TEXT	NA	No
Primary Organization	PrimaryOrganization	DTYPE_TEXT	50	No
Primary Vendor	PrimaryVendor	DTYPE_TEXT	100	No
Product Image Id	ProductImageId	DTYPE_ID	NA	No
Product Image Integration Id	ProductImageIntegrationId	DTYPE_TEXT	30	No
Product Level	ProductLevel	DTYPE_NUMBER	NA	No
Product Name	ProductName	DTYPE_TEXT	100	No
Product Type	ProductType	DTYPE_TEXT	30	No
Return if Defective	ReturnifDefective	DTYPE_TEXT	NA	No
Revision	Version	DTYPE_TEXT	30	No
Sales Product	SalesProduct	DTYPE_TEXT	NA	No
Serialized	Serialized	DTYPE_TEXT	NA	No
Service Product	ServiceProduct	DTYPE_TEXT	30	No
Service Type	ServiceType	DTYPE_TEXT	NA	No
Ship Carrier	Carrier	DTYPE_TEXT	30	No
Shipping Via	ShippingVia	DTYPE_TEXT	30	No
Status	Status	DTYPE_TEXT	30	No
Targeted Country	TargetedCountry	DTYPE_TEXT	250	No
Targeted Industry	TargetedIndustry	DTYPE_TEXT	250	No
Targeted Max Age	TargetedMaxAge	DTYPE_NUMBER	NA	No
Targeted Min Age	TargetedMinAge	DTYPE_NUMBER	NA	No
Targeted Postal Code	TargetedPostalCode	DTYPE_TEXT	250	No
Tool Flag	ToolFlag	DTYPE_TEXT	NA	No
Unit of Measure	UnitofMeasure	DTYPE_TEXT	30	No
Units In Inventory	UnitsInInventory	DTYPE_NUMBER	NA	No
Units In Inventory As Of	UnitsInInventoryAsOf	DTYPE_TEXT	NA	No
Vendor Id	VendorId	DTYPE_ID	NA	No
Vendor Integration Id	VendorIntegrationId	DTYPE_TEXT	30	No
Vendor Part Number	VendorPartNumber	DTYPE_TEXT	50	No
Vendor Primary Organization	VendorPrimaryOrganization	DTYPE_TEXT	100	No
Vendor Site	VendorSite	DTYPE_TEXT	50	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

FS Inventory Options Fields in Siebel Simple Product ASI

The following table lists FS Inventory Options fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Allocate Below Safety Flag	AllocateBelowSafetyFlag	DTYPE_TEXT	30	No
Auto AllocateFlag	AutoAllocateFlag	DTYPE_TEXT	30	No
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	No
Class ABC	ClassABC	DTYPE_TEXT	30	No
Class XYZ	ClassXYZ	DTYPE_TEXT	30	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Inventory Type	InventoryType	DTYPE_TEXT	30	No
Product Name	ProductName	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Internal Product_Equivalent Product Fields in Siebel Simple Product ASI

The following table describes Internal Product_Equivalent Product fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Equivalent Product	EquivalentProduct	DTYPE_TEXT	100	No
Equivalent Product Primary Organization	EquivalentProductPrimaryOrganization	DTYPE_TEXT	50	No
Equivalent Product Vendor	EquivalentProductVendor	DTYPE_TEXT	100	No
Equivalent Product Vendor Location	EquivalentProductVendorLocation	DTYPE_TEXT	50	No
Equivalent Product Vendor Organization	EquivalentProductVendorOrganization	DTYPE_TEXT	100	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

FS Inventory Location Fields in Siebel Simple Product ASI

The following table lists FS Inventory Location fields and attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Inventory Name	InventoryName	DTYPE_TEXT	100	No
Primary Organization Name	PrimaryOrganizationName	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Internal Product_Organization Fields in Siebel Simple Product ASI

The following table lists Internal Product_Organization fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Organization	Organization	DTYPE_TEXT	50	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Internal Product_Related Product Fields in Siebel Simple Product ASI

The following table lists Internal Product_Related Product fields and attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Organization	Organization	DTYPE_TEXT	50	No
Product Name	ProductName	DTYPE_TEXT	100	No
Vendor	Vendor	DTYPE_TEXT	100	No
Vendor Location	VendorLocation	DTYPE_TEXT	50	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Internal Product_Admin Product Line Fields in Siebel Simple Product ASI

The following table lists Internal Product_Admin Product Line fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Product Line	ProductLine	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Sales Tool by Product Fields in Siebel Simple Product ASI

The following table lists Sales Tool by Product fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
LitFileName	LitFileName	DTYPE_TEXT	220	No
Name	Name	DTYPE_TEXT	50	No
Primary Organization	PrimaryOrganization	DTYPE_TEXT	50	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

FS Warranty Fields in Siebel Simple Product ASI

The following table lists FS Warranty fields and their attributes in Siebel Simple Product ASI.

Name	XML Tag	Data Type	Length	Req.
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Warranty Name	WarrantyName	DTYPE_TEXT	100	No
Warranty Provider Name	WarrantyProviderName	DTYPE_TEXT	100	No
Warranty Provider Primary Organization	WarrantyProviderPrimaryOrganization	DTYPE_TEXT	100	No
Warranty Provider Site	WarrantyProviderSite	DTYPE_TEXT	50	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No