Table 79. Siebel Simple Product ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
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
|
|