Table 94. Siebel Simple Product ASI Fields
|
|
|
|
|
|
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 |
|
Image File Name |
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 |
|
Price Type |
PriceType |
DTYPE_TEXT |
|
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 |
30 |
N |
Added in UAN 4.1. |
Service Type |
ServiceType |
DTYPE_TEXT |
|
|
|
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 |
|
FS Inventory Options |
|
Allocate Below Safety Flag |
AllocateBelowSafetyFlag |
DTYPE_TEXT |
30 |
N |
|
Auto AllocateFlag |
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 |
|
Internal Product_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 |
|
FS 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 |
|
Internal Product_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 |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
N |
|
Internal Product_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 |
|
Internal Product_Admin 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 |
|
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 |
|
FS 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 |
|