Bookshelf v7.7: Siebel Simple Product

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

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

Table 70. Siebel Simple Product ASI Fields
Name	XML Tag	Data Type	Length	Req.	Note
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 Thumbnail Image Id	ProductThumbnailImageId	DTYPE_ID		N	Added in UAN 4.0.
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	Fix for CR #12-EV2BXZ.
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
Literature Type	LiteratureType	DTYPE_TEXT	30	N	Added for UAN 4.0.
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