Bookshelf v7.5: Siebel Simple Product

This ASI receives information about simple products created in third-party systems. It allows users to create, update, and query a product in the Siebel application. The Siebel Simple Product ASI is intended to synchronize the Siebel system to external product masters, and does not support receiving information about customized products or bundles.

Figure 37 describes the structure of this ASI, and Table 79 lists the field information.

Table 78. Siebel Simple Product ASI Integration Components
Integration Component	XML Tag	User Keys
Internal Product	InternalProduct	Id Integration Id Product Name, Primary Organization, Primary Vendor, Vendor Site, Vendor Primary Organization
Inventory Options	InventoryOptions	Id Integration Id Inventory Type, Product Name
Product Inventory	ProductInventory	Id Product Name, Inventory Location Id
Related Equivalent Product	RelatedEquivalentProduct	Id Integration Id Equivalent Product, Equivalent Product Primary Organization, Equivalent Product Vendor, Equivalent Product Vendor Location, Equivalent Product Organization
Related Inventory Location	RelatedInventoryLocation	Id Integration Id Inventory Name, Primary Organization Name
Related Organization	RelatedOrganization	Id Integration Id Organization
Related Product	RelatedProduct	Id Integration Id Product Name, Vendor, Vendor Location, Organization
Related Product Line	RelatedProductLine	Id Integration Id Name, Product Line
Related Sales Tool by Product	RelatedSalesToolByProduct	Id Integration Id Name, Primary Organization Id
Related Warranty	RelatedWarranty	Id Integration Id Warranty Name, Warranty Provider Name, Warranty Provider Primary Organization Id, Warranty Provider Site

Table 79 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.

Table 79. Siebel Simple Product ASI Fields
Name	XML Tag	Data Type	Length	Req.
Internal Product
Allocate Below Safety Flag	AllocateBelowSafetyFlag	DTYPE_TEXT	30	N
Auto Allocate Flag	AutoAllocateFlag	DTYPE_TEXT	30	N
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	N
Class Id	ClassId	DTYPE_ID		N
Class Integration Id	ClassIntegrationId	DTYPE_TEXT	30	N
Class Name	ClassName	DTYPE_TEXT	75	N
Class Type	ClassType	DTYPE_TEXT	30	N
Compensable	CompensableFlag	DTYPE_TEXT		N
Description	Description	DTYPE_TEXT	255	N
Division Code	DivisionCode	DTYPE_TEXT	30	N
Effective End Date	EffectiveEndDate	DTYPE_DATETIME		N
Effective Start Date	EffectiveStartDate	DTYPE_DATETIME		N
Field Replacable	FieldReplacable	DTYPE_TEXT		N
Global Assembly Level Code	GlobalAssemblyLevelCode	DTYPE_TEXT	50	N
Global Product Classification Code	GlobalProductClassificationCode	DTYPE_TEXT	50	N
Global Product Identifier	GlobalProductIdentifier	DTYPE_TEXT	50	N
Global Product Lifecycle Status Code	GlobalProductLifecycleStatusCode	DTYPE_TEXT	50	N
Global Supply Chain Code	GlobalSupplyChainCode	DTYPE_TEXT	50	N
Id	Id	DTYPE_ID	30	N
Image Name	ImageName	DTYPE_TEXT	100	N
Image Primary Organization Name	ImagePrimaryOrganizationName	DTYPE_TEXT	100	N
ImageFileName	ImageFileName	DTYPE_TEXT	200	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
IsAdminMode	IsAdminMode	DTYPE_TEXT		N
Item Size	ItemSize	DTYPE_NUMBER		N
Lead Time	LeadTime	DTYPE_TEXT	30	N
MTBF	MTBF	DTYPE_NUMBER		N
MTTR	MTTR	DTYPE_NUMBER		N
Maximum Quantity	MaximumQuantity	DTYPE_NUMBER		N
Minimum Quantity	MinimumQuantity	DTYPE_NUMBER		N
Orderable	Orderable	DTYPE_TEXT		N
Parent Internal Product Id (Joined)	ParentInternalProductId	DTYPE_ID		N
Parent Internal Product Integration Id	ParentInternalProductIntegrationId	DTYPE_TEXT	30	N
Parent Internal Product Name	ParentInternalProductName	DTYPE_TEXT	100	N
Parent Internal Product Primary Organization	ParentInternalProductPrimaryOrganization	DTYPE_TEXT	100	N
Parent Internal Product Vendor	ParentInternalProductVendor	DTYPE_TEXT	100	N
Parent Internal Product Vendor Location	ParentInternalProductVendorLocation	DTYPE_TEXT	50	N
Parent Internal Product Vendor Organization	ParentInternalProductVendorOrganization	DTYPE_TEXT	100	N
Part Number	PartNumber	DTYPE_TEXT	50	N
Primary Organization	PrimaryOrganization	DTYPE_TEXT	50	N
Primary Vendor	PrimaryVendor	DTYPE_TEXT	100	N
Product Image Id	ProductImageId	DTYPE_ID		N
Product Image Integration Id	ProductImageIntegrationId	DTYPE_TEXT	30	N
Product Level	ProductLevel	DTYPE_NUMBER		N
Product Name	ProductName	DTYPE_TEXT	100	N
Product Type	ProductType	DTYPE_TEXT	30	N
Return if Defective	ReturnifDefective	DTYPE_TEXT		N
Revision	Version	DTYPE_TEXT	30	N
Sales Product	SalesProduct	DTYPE_TEXT		N
Serialized	Serialized	DTYPE_TEXT		N
Service Product	ServiceProduct	DTYPE_TEXT		N
Ship Carrier	Carrier	DTYPE_TEXT	30	N
Shipping Via	ShippingVia	DTYPE_TEXT	30	N
Status	Status	DTYPE_TEXT	30	N
Targeted Country	TargetedCountry	DTYPE_TEXT	250	N
Targeted Industry	TargetedIndustry	DTYPE_TEXT	250	N
Targeted Max Age	TargetedMaxAge	DTYPE_NUMBER		N
Targeted Min Age	TargetedMinAge	DTYPE_NUMBER		N
Targeted Postal Code	TargetedPostalCode	DTYPE_TEXT	250	N
Tool Flag	ToolFlag	DTYPE_TEXT		N
Unit of Measure	UnitofMeasure	DTYPE_TEXT	30	N
Units In Inventory	UnitsInInventory	DTYPE_NUMBER		N
Units In Inventory As Of	UnitsInInventoryAsOf	DTYPE_TEXT		N
Vendor Id	VendorId	DTYPE_ID		N
Vendor Integration Id	VendorIntegrationId	DTYPE_TEXT	30	N
Vendor Part Number	VendorPartNumber	DTYPE_TEXT	50	N
Vendor Primary Organization	VendorPrimaryOrganization	DTYPE_TEXT	100	N
Vendor Site	VendorSite	DTYPE_TEXT	50	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Inventory Options
Allocate Below Safety Flag	AllocateBelowSafetyFlag	DTYPE_TEXT	30	N
Auto Allocate Flag	AutoAllocateFlag	DTYPE_TEXT	30	N
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	N
Class ABC	ClassABC	DTYPE_TEXT	30	N
Class XYZ	ClassXYZ	DTYPE_TEXT	30	N
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Inventory Type	InventoryType	DTYPE_TEXT	30	N
Product Name	ProductName	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Product Inventory
Allocate Below Safety Stock Flag	AllocateBelowSafetyStockFlag	DTYPE_TEXT	30	N
Auto Allocate Flag	AutoAllocateFlag	DTYPE_TEXT	30	N
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	N
Id	Id	DTYPE_ID	30	N
Inventory Location Id	InventoryLocationId	DTYPE_ID	30	N
Maximum Inventory Level	MaximumInventoryLevel	DTYPE_NUMBER	22	N
Minimum Inventory Level	MinimumInventoryLevel	DTYPE_NUMBER	22	N
Movement Class	MovementClass	DTYPE_TEXT	30	N
Product Id	ProductId	DTYPE_TEXT	30	N
Product Name	ProductName	DTYPE_TEXT	100	N
Safety Stock Level	SafetyStockLevel	DTYPE_NUMBER	22	N
Value Class	ValueClass	DTYPE_TEXT	30	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Equivalent Product
Equivalent Product	EquivalentProduct	DTYPE_TEXT	100	N
Equivalent Product Primary Organization	EquivalentProductPrimaryOrganization	DTYPE_TEXT	50	N
Equivalent Product Vendor	EquivalentProductVendor	DTYPE_TEXT	100	N
Equivalent Product Vendor Location	EquivalentProductVendorLocation	DTYPE_TEXT	50	N
Equivalent Product Vendor Organization	EquivalentProductVendorOrganization	DTYPE_TEXT	100	N
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Inventory Location
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Inventory Name	InventoryName	DTYPE_TEXT	100	N
Primary Organization Name	PrimaryOrganizationName	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Organization
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Organization	Organization	DTYPE_TEXT	50	N
Sales Unit of Measure	SalesUnitofMeasure	DTYPE_TEXT	30	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Product
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Organization	Organization	DTYPE_TEXT	50	N
Product Name	ProductName	DTYPE_TEXT	100	N
Vendor	Vendor	DTYPE_TEXT	100	N
Vendor Location	VendorLocation	DTYPE_TEXT	50	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Product Line
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Product Line	ProductLine	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Sales Tool by Product
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
LitFileName	LitFileName	DTYPE_TEXT	220	N
Name	Name	DTYPE_TEXT	50	N
Primary Organization	PrimaryOrganization	DTYPE_TEXT	50	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N
Related Warranty
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Warranty Name	WarrantyName	DTYPE_TEXT	100	N
Warranty Provider Name	WarrantyProviderName	DTYPE_TEXT	100	N
Warranty Provider Primary Organization	WarrantyProviderPrimaryOrganization	DTYPE_TEXT	100	N
Warranty Provider Site	WarrantyProviderSite	DTYPE_TEXT	50	N
operation	operation	DTYPE_TEXT	30	N
searchspec	searchspec	DTYPE_TEXT	250	N