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