Bookshelf v8.1/8.2: 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.

Table 92. 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
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
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
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
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
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
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
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
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
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.