IF OBJECT_ID('tempdb..#tempProductMasterImport') IS NOT NULL DROP TABLE #tempProductMasterImport 

CREATE TABLE #tempProductMasterImport (
	ID int identity(1,1),
	ProductName VARCHAR(800),
	ProductFullName	VARCHAR(800),
	Manufacturer VARCHAR(100),
	Supplier VARCHAR(100),
	AlternateProductCodes VARCHAR(100),	
	UnitDescription	VARCHAR(100),
	Brand VARCHAR(100),
	Department VARCHAR(100),
	Class VARCHAR(100),
	SubClass VARCHAR(100),
	PurchasePrice FLOAT,
	PurchaseUnit FLOAT,	
	PurchaseTax	VARCHAR(100),
	SalesPrice FLOAT,
	SalesUnit FLOAT,
	SalesTax VARCHAR(100),	
	MRP FLOAT,
	CashDiscountEligibility	VARCHAR(50),
	AllowDirectInward VARCHAR(50),
	IsBillable VARCHAR(50),
	IsActive VARCHAR(50),
	AgeGroup VARCHAR(100),
	Color VARCHAR(100),
	Gender VARCHAR(100),
	Season VARCHAR(100),
	Size VARCHAR(100),
	EANCode VARCHAR(100),
	ToonLabel VARCHAR(100),
	TaxCategory VARCHAR(100),
	Classification VARCHAR(50),
	MaximumDiscount	FLOAT,
	GarmentType VARCHAR(100),
	BusinessSegment VARCHAR(100),
	Article VARCHAR(100),
	Division VARCHAR(100),
	MarketingDivision VARCHAR(100),
	QuarterSeason VARCHAR(100),
	ProductCategory VARCHAR(100),
	Sports VARCHAR(100),
	BusinessUnit VARCHAR(100),
	PackageInformation VARCHAR(100),
	AllowFractions VARCHAR(50),
	AcceptRate VARCHAR(50),
	HasMultipleUnits VARCHAR(50),
	StockUOMAltCode VARCHAR(50),
	PriceUOMAltCode VARCHAR(50),
	DefaultSaleUOMAltCode VARCHAR(50),
	DefaultPurchaseUOMAltCode VARCHAR(50),
	ReportingUOMAltCode VARCHAR(50),
	DefaultIndentUOMAltCode VARCHAR(50),
	AllowInIndent VARCHAR(50),
	Weight FLOAT,
	IndentProductGroup VARCHAR(50),
	InventoryNotToBeMaintained VARCHAR(50),
	DoNotCheckStock VARCHAR(50),
	ProductGroup VARCHAR(50),
	ExciseDuty VARCHAR(50),
	StockType VARCHAR(50),
	ProductType VARCHAR(50),
	FreeScheme VARCHAR(50),
	OrderType  VARCHAR(50),
	IsTaxInclusive VARCHAR(50),
	HSNCode VARCHAR(50)
	
)