Bookshelf v8.1/8.2: 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 69 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.

Table 69. Siebel Simple Product ASI Fields
Name	XML Tag	Data Type	Length	Req.
Internal Product
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
ImageFileName	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
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 Thumbnail Image Id	ProductThumbnailImageId	DTYPE_ID	NA	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	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
Inventory Options
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 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
Product Inventory
Allocate Below Safety Stock Flag	AllocateBelowSafetyStockFlag	DTYPE_TEXT	30	No
Auto Allocate Flag	AutoAllocateFlag	DTYPE_TEXT	30	No
Auto Substitute Flag	AutoSubstituteFlag	DTYPE_TEXT	30	No
Id	Id	DTYPE_ID	30	No
Inventory Location Id	InventoryLocationId	DTYPE_ID	30	No
Maximum Inventory Level	MaximumInventoryLevel	DTYPE_NUMBER	22	No
Minimum Inventory Level	MinimumInventoryLevel	DTYPE_NUMBER	22	No
Movement Class	MovementClass	DTYPE_TEXT	30	No
Product Id	ProductId	DTYPE_TEXT	30	No
Product Name	ProductName	DTYPE_TEXT	100	No
Safety Stock Level	SafetyStockLevel	DTYPE_NUMBER	22	No
Value Class	ValueClass	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No
Related Equivalent Product
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
Related Inventory Location
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
Related Organization
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
Sales Unit of Measure	SalesUnitofMeasure	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No
Related Product
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
Related Product Line
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
Related Sales Tool by Product
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Literature Type	LiteratureType	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
Related Warranty
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

Siebel Application Services Interface Reference		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.