Untitled
unknown
plain_text
10 months ago
16 kB
4
Indexable
CREATE TABLE [data-product2-00001-c002.snappy] ( [Id] NVARCHAR(MAX) NULL, [Name] NVARCHAR(MAX) NULL, [ProductCode] NVARCHAR(MAX) NULL, [Description] NVARCHAR(MAX) NULL, [QuantityScheduleType] NVARCHAR(MAX) NULL, [QuantityInstallmentPeriod] NVARCHAR(MAX) NULL, [NumberOfQuantityInstallments] INT NULL, [RevenueScheduleType] NVARCHAR(MAX) NULL, [RevenueInstallmentPeriod] NVARCHAR(MAX) NULL, [NumberOfRevenueInstallments] INT NULL, [CanUseQuantitySchedule] BIT NULL, [CanUseRevenueSchedule] BIT NULL, [IsActive] BIT NULL, [CreatedDate] DATETIME NULL, [CreatedById] NVARCHAR(MAX) NULL, [LastModifiedDate] DATETIME NULL, [LastModifiedById] NVARCHAR(MAX) NULL, [SystemModstamp] DATETIME NULL, [Family] NVARCHAR(MAX) NULL, [CurrencyIsoCode] NVARCHAR(MAX) NULL, [ExternalDataSourceId] NVARCHAR(MAX) NULL, [ExternalId] NVARCHAR(MAX) NULL, [DisplayUrl] NVARCHAR(MAX) NULL, [QuantityUnitOfMeasure] NVARCHAR(MAX) NULL, [IsDeleted] BIT NULL, [IsArchived] BIT NULL, [LastViewedDate] DATETIME NULL, [LastReferencedDate] DATETIME NULL, [StockKeepingUnit] NVARCHAR(MAX) NULL, [EAN__c] NVARCHAR(MAX) NULL, [CharacteriticType1__c] NVARCHAR(MAX) NULL, [CharacteriticValue1__c] NVARCHAR(MAX) NULL, [CharacteriticType2__c] NVARCHAR(MAX) NULL, [CharacteriticValue2__c] NVARCHAR(MAX) NULL, [CharacteriticType3__c] NVARCHAR(MAX) NULL, [CharacteriticValue3__c] NVARCHAR(MAX) NULL, [CharacteriticType4__c] NVARCHAR(MAX) NULL, [SousFamille__c] NVARCHAR(MAX) NULL, [PoidsNet__c] REAL NULL, [CharacteriticValue4__c] NVARCHAR(MAX) NULL, [Type1__c] NVARCHAR(MAX) NULL, [Type2__c] NVARCHAR(MAX) NULL, [Modele__c] NVARCHAR(MAX) NULL, [Couleur__c] NVARCHAR(MAX) NULL, [Enseigne__c] NVARCHAR(MAX) NULL, [Pays__c] NVARCHAR(MAX) NULL, [CharacteriticType5__c] NVARCHAR(MAX) NULL, [CharacteriticValue5__c] NVARCHAR(MAX) NULL, [Taille__c] NVARCHAR(MAX) NULL, [Template__c] NVARCHAR(MAX) NULL, [CharacteriticType6__c] NVARCHAR(MAX) NULL, [NiveauStock__c] NVARCHAR(MAX) NULL, [DateDispoProchaine__c] DATETIME NULL, [DelaiApproMoyen__c] REAL NULL, [PrixAchat__c] REAL NULL, [Technologie__c] NVARCHAR(MAX) NULL, [Generation__c] NVARCHAR(MAX) NULL, [DateCreation__c] DATETIME NULL, [DateSuppression__c] DATETIME NULL, [Compatibilite__c] NVARCHAR(MAX) NULL, [CharacteriticValue6__c] NVARCHAR(MAX) NULL, [CharacteriticType7__c] NVARCHAR(MAX) NULL, [CaracteristiquesURL__c] NVARCHAR(MAX) NULL, [CharacteriticValue7__c] NVARCHAR(MAX) NULL, [Conditionnement__c] REAL NULL, [Commentaires__c] NVARCHAR(MAX) NULL, [NomImage__c] NVARCHAR(MAX) NULL, [CAGenere__c] REAL NULL, [PrixVenteGeneral__c] REAL NULL, [CharacteriticType8__c] NVARCHAR(MAX) NULL, [CharacteriticValue8__c] NVARCHAR(MAX) NULL, [CharacteriticType9__c] NVARCHAR(MAX) NULL, [CharacteriticValue9__c] NVARCHAR(MAX) NULL, [CharacteriticType10__c] NVARCHAR(MAX) NULL, [CharacteriticValue10__c] NVARCHAR(MAX) NULL, [StockLevel1__c] REAL NULL, [StockLevel2__c] REAL NULL, [StockLevel3__c] REAL NULL, [ProductGroup__c] NVARCHAR(MAX) NULL, [acCore__Company__c] NVARCHAR(MAX) NULL, [acCore__ExternalID__c] NVARCHAR(MAX) NULL, [acCore__Global__c] BIT NULL, [acCore__PartClass__c] NVARCHAR(MAX) NULL, [acCore__ProductGroup__c] NVARCHAR(MAX) NULL, [acCore__SalesUOM__c] NVARCHAR(MAX) NULL, [acCore__Type__c] NVARCHAR(MAX) NULL, [acCore__lc_CompanyLKP_Done__c] BIT NULL, [acCore__lc_Company_ExternalID__c] NVARCHAR(MAX) NULL, [acCore__lc_ProductGroupLkp_Done__c] BIT NULL, [acCore__lc_ProductGroup_ExternalID__c] NVARCHAR(MAX) NULL, [acSales__ExternalID__c] NVARCHAR(MAX) NULL, [Photography__c] NVARCHAR(MAX) NULL, [On_Hold__c] BIT NULL, [IsDummyProduct__c] BIT NULL, [acCore__MarkForDelete__c] BIT NULL, [CharacteriticValue11__c] NVARCHAR(MAX) NULL, [CharacteriticType11__c] NVARCHAR(MAX) NULL, [Standard_Part_Cost_Q1__c] REAL NULL, [Standard_Part_Cost_Q2__c] REAL NULL, [Standard_Part_Cost_Q3__c] REAL NULL, [Standard_Part_Cost_Q4__c] REAL NULL, [Buttons__c] NVARCHAR(MAX) NULL, [Produit_Findbox__c] BIT NULL, [MOQ__c] REAL NULL, [Runout_Test__c] BIT NULL, [Display_Technology_Segmented__c] BIT NULL, [Display_Technology_Segmented_E_Paper__c] BIT NULL, [Display_Technology_LCD__c] BIT NULL, [Display_Technology_E_Paper__c] BIT NULL, [ImageEpicor__c] NVARCHAR(MAX) NULL, [Display_Size_1_6__c] BIT NULL, [Display_Size_2_2__c] BIT NULL, [Display_Size_2_6__c] BIT NULL, [Display_Size_2_7__c] BIT NULL, [Display_Size_4_2__c] BIT NULL, [Display_Size_4_5__c] BIT NULL, [Display_Size_6_0__c] BIT NULL, [Display_Size_7_4__c] BIT NULL, [Display_Size_12_2__c] BIT NULL, [Display_Size_Other__c] NVARCHAR(MAX) NULL, [Radio_Transmission_37_4_KHz_LF__c] BIT NULL, [Radio_Transmission_2_4_GHz_HF__c] BIT NULL, [Radio_Transmission_868_MHz__c] BIT NULL, [Radio_Transmission_915_MHz__c] BIT NULL, [Display_Colors_BW__c] BIT NULL, [Display_Colors_BWR__c] BIT NULL, [Display_Colors_BWY__c] BIT NULL, [Casing_color_rear__c] NVARCHAR(MAX) NULL, [Casing_Design_S_Tag__c] BIT NULL, [Casing_Design_G_Tag__c] BIT NULL, [Casing_Design_G1__c] BIT NULL, [Casing_Design_SmartESL__c] BIT NULL, [Casing_Design_Vicky__c] BIT NULL, [Casing_Design_Fashion__c] BIT NULL, [Casing_Design_Sigrid__c] BIT NULL, [Casing_Design_Other__c] NVARCHAR(MAX) NULL, [Front_Cover_Silkscreen__c] BIT NULL, [Front_Cover_G1_Cover_Frame__c] BIT NULL, [Front_Cover_QRcode__c] BIT NULL, [Front_Cover_Other__c] NVARCHAR(MAX) NULL, [Front_Lens__c] NVARCHAR(MAX) NULL, [LED_None__c] BIT NULL, [LED_White__c] BIT NULL, [LED_WhiteRGB__c] BIT NULL, [Not_for_sale__c] BIT NULL, [Fixing_Mounting_Easylock__c] BIT NULL, [Fixing_Mounting_Meto_large_dove_tai__c] BIT NULL, [Fixing_Mounting_Imago_small_dove_ta__c] BIT NULL, [Fixing_Mounting_Alarm__c] BIT NULL, [Fixing_Mounting_Other__c] NVARCHAR(MAX) NULL, [NFC_passive_redirect_to_app_only__c] BIT NULL, [NFC_passive_URL_redirect__c] BIT NULL, [NFC_active__c] BIT NULL, [Near_Field_Communication_Other__c] NVARCHAR(MAX) NULL, [Operating_Temperature_10_to_40_C__c] BIT NULL, [Operating_Temperature_0_to_40_C__c] BIT NULL, [Operating_Temperature_below_0_C_Freez__c] BIT NULL, [Operating_Temperature_above_40_C__c] BIT NULL, [Waterproof_IP67__c] BIT NULL, [Water_resistant_IP54__c] BIT NULL, [Orientation_Portrait_only__c] BIT NULL, [Orientation_Landscape_only__c] BIT NULL, [Orientation_180__c] BIT NULL, [Display_Technology_Other__c] NVARCHAR(MAX) NULL, [Display_Colors_Other__c] NVARCHAR(MAX) NULL, [Lot_size__c] REAL NULL, [Reporting_group__c] NVARCHAR(MAX) NULL, [Launch_date__c] DATETIME NULL, [Power_supply__c] NVARCHAR(MAX) NULL, [Custom_color_for_casing_rear__c] NVARCHAR(MAX) NULL, [Product_Group__c] NVARCHAR(MAX) NULL, [Product_Release_Date__c] DATETIME NULL, [Delivery_in_days_EXW__c] NVARCHAR(MAX) NULL, [Run_out_status__c] BIT NULL, [Front_cover_Inlay_color__c] NVARCHAR(MAX) NULL, [LED_WhiteRed__c] BIT NULL, [Radio_Transmission_779_MHz__c] BIT NULL, [Spanish_Description__c] NVARCHAR(MAX) NULL, [US_Description__c] NVARCHAR(MAX) NULL, [Product_Id_18__c] NVARCHAR(MAX) NULL, [Reason__c] NVARCHAR(MAX) NULL, [fferpcore__SalesTaxStatus__c] NVARCHAR(MAX) NULL, [fferpcore__TaxCode__c] NVARCHAR(MAX) NULL, [Category__c] NVARCHAR(MAX) NULL, [Delivery_Time_in_Days_FCA__c] NVARCHAR(MAX) NULL, [SBQQ__AssetAmendmentBehavior__c] NVARCHAR(MAX) NULL, [SBQQ__AssetConversion__c] NVARCHAR(MAX) NULL, [SBQQ__BatchQuantity__c] REAL NULL, [SBQQ__BillingFrequency__c] NVARCHAR(MAX) NULL, [SBQQ__BillingType__c] NVARCHAR(MAX) NULL, [SBQQ__BlockPricingField__c] NVARCHAR(MAX) NULL, [SBQQ__ChargeType__c] NVARCHAR(MAX) NULL, [SBQQ__Component__c] BIT NULL, [SBQQ__CompoundDiscountRate__c] REAL NULL, [SBQQ__ConfigurationEvent__c] NVARCHAR(MAX) NULL, [SBQQ__ConfigurationFieldSet__c] NVARCHAR(MAX) NULL, [SBQQ__ConfigurationFields__c] NVARCHAR(MAX) NULL, [SBQQ__ConfigurationFormTitle__c] NVARCHAR(MAX) NULL, [SBQQ__ConfigurationType__c] NVARCHAR(MAX) NULL, [SBQQ__ConfigurationValidator__c] NVARCHAR(MAX) NULL, [SBQQ__ConfiguredCodePattern__c] NVARCHAR(MAX) NULL, [SBQQ__ConfiguredDescriptionPattern__c] NVARCHAR(MAX) NULL, [SBQQ__CostEditable__c] BIT NULL, [SBQQ__CostSchedule__c] NVARCHAR(MAX) NULL, [SBQQ__CustomConfigurationPage__c] NVARCHAR(MAX) NULL, [SBQQ__CustomConfigurationRequired__c] BIT NULL, [SBQQ__CustomerCommunityAvailability__c] NVARCHAR(MAX) NULL, [SBQQ__DefaultPricingTable__c] NVARCHAR(MAX) NULL, [SBQQ__DefaultQuantity__c] REAL NULL, [SBQQ__DescriptionLocked__c] BIT NULL, [SBQQ__DiscountCategory__c] NVARCHAR(MAX) NULL, [SBQQ__DiscountSchedule__c] NVARCHAR(MAX) NULL, [SBQQ__DynamicPricingConstraint__c] NVARCHAR(MAX) NULL, [SBQQ__ExcludeFromMaintenance__c] BIT NULL, [SBQQ__ExcludeFromOpportunity__c] BIT NULL, [SBQQ__ExternallyConfigurable__c] BIT NULL, [SBQQ__GenerateContractedPrice__c] NVARCHAR(MAX) NULL, [SBQQ__HasConfigurationAttributes__c] BIT NULL, [SBQQ__HasConsumptionSchedule__c] BIT NULL, [SBQQ__Hidden__c] BIT NULL, [SBQQ__HidePriceInSearchResults__c] BIT NULL, [SBQQ__IncludeInMaintenance__c] BIT NULL, [SBQQ__NewQuoteGroup__c] BIT NULL, [SBQQ__NonDiscountable__c] BIT NULL, [SBQQ__NonPartnerDiscountable__c] BIT NULL, [SBQQ__OptionLayout__c] NVARCHAR(MAX) NULL, [SBQQ__OptionSelectionMethod__c] NVARCHAR(MAX) NULL, [SBQQ__Optional__c] BIT NULL, [SBQQ__PriceEditable__c] BIT NULL, [SBQQ__PricingMethodEditable__c] BIT NULL, [SBQQ__PricingMethod__c] NVARCHAR(MAX) NULL, [SBQQ__ProductPictureID__c] NVARCHAR(MAX) NULL, [SBQQ__QuantityEditable__c] BIT NULL, [SBQQ__QuantityScale__c] REAL NULL, [SBQQ__ReconfigurationDisabled__c] BIT NULL, [SBQQ__RenewalProduct__c] NVARCHAR(MAX) NULL, [SBQQ__SortOrder__c] REAL NULL, [SBQQ__Specifications__c] NVARCHAR(MAX) NULL, [SBQQ__SubscriptionBase__c] NVARCHAR(MAX) NULL, [SBQQ__SubscriptionCategory__c] NVARCHAR(MAX) NULL, [SBQQ__SubscriptionPercent__c] REAL NULL, [SBQQ__SubscriptionPricing__c] NVARCHAR(MAX) NULL, [SBQQ__SubscriptionTarget__c] NVARCHAR(MAX) NULL, [SBQQ__SubscriptionTerm__c] REAL NULL, [SBQQ__SubscriptionType__c] NVARCHAR(MAX) NULL, [SBQQ__TaxCode__c] NVARCHAR(MAX) NULL, [SBQQ__Taxable__c] BIT NULL, [SBQQ__TermDiscountLevel__c] NVARCHAR(MAX) NULL, [SBQQ__TermDiscountSchedule__c] NVARCHAR(MAX) NULL, [SBQQ__UpgradeCredit__c] NVARCHAR(MAX) NULL, [SBQQ__UpgradeRatio__c] REAL NULL, [SBQQ__UpgradeSource__c] NVARCHAR(MAX) NULL, [SBQQ__UpgradeTarget__c] NVARCHAR(MAX) NULL, [SBQQ__EnableLargeConfiguration__c] BIT NULL, [SBQQ__PricingGuidance__c] NVARCHAR(MAX) NULL, [AmericasMOQ__c] REAL NULL, [AmericasStandardProduct__c] BIT NULL, [BackColor__c] NVARCHAR(MAX) NULL, [BusinessInfo__c] NVARCHAR(MAX) NULL, [CamRail__c] BIT NULL, [Certification_AUS_NZE__c] NVARCHAR(MAX) NULL, [Certification_Canada__c] NVARCHAR(MAX) NULL, [Certification_China__c] NVARCHAR(MAX) NULL, [Certification_EU_CE__c] NVARCHAR(MAX) NULL, [Certification_India__c] NVARCHAR(MAX) NULL, [Certification_Indonesia__c] NVARCHAR(MAX) NULL, [Certification_Japan__c] NVARCHAR(MAX) NULL, [Certification_Korea__c] NVARCHAR(MAX) NULL, [Certification_Malaysia__c] NVARCHAR(MAX) NULL, [Certification_Mexico__c] NVARCHAR(MAX) NULL, [Certification_Philippines__c] NVARCHAR(MAX) NULL, [Certification_Russia_Kazakhstan_EAC__c] NVARCHAR(MAX) NULL, [Certification_Serbia__c] NVARCHAR(MAX) NULL, [Certification_Singapore__c] NVARCHAR(MAX) NULL, [Certification_Taiwan__c] NVARCHAR(MAX) NULL, [Certification_Thailand__c] NVARCHAR(MAX) NULL, [Certification_USA_FCC_IC__c] NVARCHAR(MAX) NULL, [Color__c] NVARCHAR(MAX) NULL, [DefaultChargeType__c] NVARCHAR(MAX) NULL, [DefaultESLNumber__c] NVARCHAR(MAX) NULL, [DefaultRatio__c] REAL NULL, [EarliestDeliveryDate__c] DATETIME NULL, [Flash__c] NVARCHAR(MAX) NULL, [FrontColor__c] NVARCHAR(MAX) NULL, [Image_URL__c] NVARCHAR(MAX) NULL, [InclinerRail__c] BIT NULL, [Lens__c] NVARCHAR(MAX) NULL, [LineDisplay__c] NVARCHAR(MAX) NULL, [NFC__c] NVARCHAR(MAX) NULL, [NFSNonPilot__c] NVARCHAR(MAX) NULL, [NeedManlift__c] BIT NULL, [PricingMethodNonStandard__c] BIT NULL, [R4R5Rails__c] BIT NULL, [Radio__c] NVARCHAR(MAX) NULL, [Size__c] NVARCHAR(MAX) NULL, [StandardProduct__c] BIT NULL, [TECHfamilyCOPY__c] NVARCHAR(MAX) NULL, [UnitOfMeasure__c] NVARCHAR(MAX) NULL, [WrapperBundle__c] NVARCHAR(MAX) NULL, [French_Description__c] NVARCHAR(MAX) NULL, [Unit_Gross_Weight_kg__c] REAL NULL, [Italian_Description__c] NVARCHAR(MAX) NULL, [Unit_Net_Weight_kg__c] REAL NULL, [Certification_Brazil__c] NVARCHAR(MAX) NULL, [FreightCharges__c] BIT NULL, [TECHTariffOption__c] BIT NULL, [TagUnitCostUSD__c] REAL NULL, [USGoldPrice__c] REAL NULL, [USPlatinumPrice__c] REAL NULL, [USSilverPrice__c] REAL NULL, [Application__c] NVARCHAR(MAX) NULL, [Certification_Ukraine__c] NVARCHAR(MAX) NULL, [Product_Substitution__c] NVARCHAR(MAX) NULL, [Seasonal_Product__c] BIT NULL, [Sold_Out_Delivery_Time__c] DATETIME NULL, [Sold_Out__c] BIT NULL, [Tech_Image_Url__c] NVARCHAR(MAX) NULL, [CatalogFamilyCode__c] NVARCHAR(MAX) NULL, [LegacyProductCode__c] NVARCHAR(MAX) NULL, [SalesUnitConvFactor__c] REAL NULL, [Always_Hide__c] BIT NULL, [ImageSAP__c] NVARCHAR(MAX) NULL, [CatalogFamilyDescription__c] NVARCHAR(MAX) NULL, [CatalogSubFamilyCode__c] NVARCHAR(MAX) NULL, [CatalogSubFamilyDescription__c] NVARCHAR(MAX) NULL, [EndOfSalesValidity__c] DATETIME NULL, [MaterialStatus__c] NVARCHAR(MAX) NULL, [SubstituteMaterialId__c] NVARCHAR(MAX) NULL, [SubstituteReason__c] NVARCHAR(MAX) NULL, [SubstituteValidFrom__c] DATETIME NULL, [SubstituteValidTo__c] DATETIME NULL, [New_Material_Number__c] NVARCHAR(MAX) NULL, [UnitPerPallet__c] REAL NULL, [Material_group__c] NVARCHAR(MAX) NULL, [TECH_Tmp_Unit_Net_Weight_kg__c] REAL NULL, [German_Description__c] NVARCHAR(MAX) NULL, [TECH_Tmp_Sales_Unit_Conv_Factor__c] REAL NULL, [TECH_Tmp_Category__c] NVARCHAR(MAX) NULL, [CPQ_ExtendedWarranty__c] NVARCHAR(MAX) NULL, [ExtendedWarrantyESL2__c] NVARCHAR(MAX) NULL, [YearsFamily__c] NVARCHAR(MAX) NULL, [Certification_Chile__c] NVARCHAR(MAX) NULL, [Extended_Warranty__c] BIT NULL, [OptionToBeDeleted__c] BIT NULL, [TECH_Tmp_Delivery_Unit__c] REAL NULL, [SupplyScheme__c] NVARCHAR(MAX) NULL, [BusinessUnitSelect__c] NVARCHAR(MAX) NULL, [BusinessUnit__c] NVARCHAR(MAX) NULL, [USMSRPPrice__c] REAL NULL, [Certification_Kuwait__c] NVARCHAR(MAX) NULL, [Innovative_Product__c] BIT NULL, [Stock_Push__c] BIT NULL, [VAS__c] NVARCHAR(MAX) NULL, [vasLevel1__c] NVARCHAR(MAX) NULL, [vasLevel2__c] NVARCHAR(MAX) NULL, [CatalogLowestFamily__c] NVARCHAR(MAX) NULL, [CatalogLowestFamilyCode__c] NVARCHAR(MAX) NULL, [ESL_Category__c] NVARCHAR(MAX) NULL, [Product_Line__c] NVARCHAR(MAX) NULL, [Product_SubLine__c] NVARCHAR(MAX) NULL, [Product_BU_Code__c] NVARCHAR(MAX) NULL );
Editor is loading...
Leave a Comment