8000DataResults$00[dbo].[Products]1252false3falsefalseTABLOCK,CHECK_CONSTRAINTS21474836470DataResults$0falsefalse21474836470select
CONVERT(NVARCHAR(200),item_number) as PRODUCTNUMBER,
CONVERT(NVARCHAR(200),'') as AREIDENTICALCONFIGURATIONSALLOWED,
-- 5/18 LP Harmonized will be left blank for now. GAP EU/US codes and D365 only have one field at the products v2 entity (GAP-5165)
CONVERT(NVARCHAR(200),item_harmonize) as HARMONIZEDSYSTEMCODE,
CONVERT(NVARCHAR(200),'') as ISAUTOMATICVARIANTGENERATIONENABLED,
CONVERT(NVARCHAR(200),'No') as ISCATCHWEIGHTPRODUCT,
CONVERT(NVARCHAR(200),'') as ISPRODUCTKIT,
CONVERT(NVARCHAR(200),'') as ISPRODUCTVARIANTUNITCONVERSIONENABLED,
CONVERT(NVARCHAR(200),'') as NMFCCODE,
CONVERT(NVARCHAR(200),'') as PRODUCTCOLORGROUPID,
CONVERT(NVARCHAR(200),item_desc) as PRODUCTDESCRIPTION,
CONVERT(NVARCHAR(200),'') as PRODUCTDIMENSIONGROUPNAME,
CONVERT(NVARCHAR(200),item_desc) as PRODUCTNAME,
CONVERT(NVARCHAR(200),item_desc) as PRODUCTSEARCHNAME,
CONVERT(NVARCHAR(200),'') AS PRODUCTSIZEGROUPID,
CONVERT(NVARCHAR(200),'') as PRODUCTSTYLEGROUPID,
CONVERT(NVARCHAR(200),'Product') as PRODUCTSUBTYPE,
CONVERT(NVARCHAR(200),'Item') as PRODUCTTYPE,
CONVERT(NVARCHAR(200),'') as PRODUCTVARIANTNAMENOMENCLATURENAME,
CONVERT(NVARCHAR(200),'') as PRODUCTVARIANTNUMBERNOMENCLATURENAME,
-- 5/18 LP Retail Category will be left blank at the product entity. Set at the released product entity and a separate import.
CONVERT(NVARCHAR(200),'') as RETAILPRODUCTCATEGORYNAME,
CONVERT(NVARCHAR(200),'NotSpecified') as SERVICETYPE,
CONVERT(NVARCHAR(200),'') as STCCCODE,
CONVERT(NVARCHAR(200),'SW') as STORAGEDIMENSIONGROUPNAME,
CONVERT(NVARCHAR(200),'NONE') as TRACKINGDIMENSIONGROUPNAME,
CONVERT(NVARCHAR(200),'') as VARIANTCONFIGURATIONTECHNOLOGY,
CONVERT(NVARCHAR(200),'') as WARRANTYDURATIONTIME,
CONVERT(NVARCHAR(200),'') as WARRANTYDURATIONTIMEUNIT,
CONVERT(NVARCHAR(200),'') AS INVENTORYUNITSYMBOL,
CONVERT(NVARCHAR(200),'') AS PURCHASEUNITSYMBOL,
CONVERT(NVARCHAR(200),'') AS SALESUNITSYMBOL
from item with (nolock)
WHERE item_status IN ('P','S','5')1252false2DataSourceViewIDTableInfoObjectTypeTableDataSourceViewIDTableInfoObjectTypeTableDataSourceViewIDTableInfoObjectTypeTableDataSourceViewID]]>