Tables [dbo].[Vendor_Item_Extension]
Extension type/value tied to the Vendor_Item table
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Vendor_Item_Extension: VendorItemID\ExtensionTypeIndexes TWstat_Vendor_Item_Extension_ExtensionType_VendorItemIDForeign Keys FK_Vendor_Item_Extension_VendorItemID_Vendor_Item_ID: [dbo].[Vendor_Item].VendorItemIDVendorItemID[dbo].[uniqueid]9NOT NULLVendor Item Identifier - Link to Vendor_Item.ID
Cluster Primary Key PK_Vendor_Item_Extension: VendorItemID\ExtensionTypeIndexes TWstat_Vendor_Item_Extension_ExtensionType_VendorItemIDExtensionTypevarchar(15)15NOT NULLType Identifier for ExtensionValue (EX. 'Answer')
ExtensionValuevarchar(max)maxNOT NULLExtension value, generic value, use depends on Type defined