RyanSusana/something.sql

## something.sql
create database [test Coo];
go
use [test Coo];

go
CREATE TABLE [imp_tbl_calc_mc] ([urencalculatieid] [int] NULL,[mcid] [int] NOT NULL,[type] [nvarchar](4) NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[aantal] [float] NULL,[pins] [int] NULL,[tijd] [int] NULL,[opmerking] [nvarchar](MAX) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_tijden] ([id] [int] NOT NULL,[categorie] [nvarchar](15) NULL,[processtap] [int] NULL,[aktiviteit] [nvarchar](50) NULL,[tijd] [float] NULL,[man] [int] NULL,[machine] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_notities] ([id] [nvarchar](2) NOT NULL,[notitie] [varchar](MAX) NULL,[medewerker] [nvarchar](30) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_order_samples] ([id] [int] NOT NULL,[receivedate] [datetime] NULL,[sample delivery] [datetime] NULL,[ecd] [datetime] NULL,[text] [nvarchar](50) NULL,[instruction] [int] NULL,[prioriteit] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_opmerkingen] ([id] [int] NOT NULL,[opmerking] [nvarchar](50) NULL,[tekst] [varchar](MAX) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_sub] ([art_id] [int] NOT NULL,[offerte_id] [int] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[npi] [smallint] NULL,[melding_wvb] [varchar](MAX) NULL,[pcbdata] [nvarchar](3) NULL,[pcb] [datetime] NULL,[stuklijst] [datetime] NULL,[bomtemp] [smallint] NULL,[calculatie] [datetime] NULL,[test] [smallint] NULL,[dlt] [smallint] NULL,[melding_inkoop] [varchar](MAX) NULL,[pcbaanvraag] [datetime] NULL,[stuklijst_ink] [datetime] NULL,[inkoopdata] [datetime] NULL,[eenheid] [nvarchar](30) NULL,[aantal] [int] NULL,[categorie] [nvarchar](10) NULL,[uitbesteding] [smallint] NULL,[prijs] [money] NULL,[opmerking] [varchar](MAX) NULL,[richtprijs] [smallint] NULL,[wvb_check] [smallint] NULL,[wvb_emp] [int] NULL,[ink_check] [smallint] NULL,[ink_emp] [int] NULL,[progkosten] [float] NULL,[seriekosten] [float] NULL,[prodkosten] [float] NULL,[stencilkosten] [float] NULL,[materiaalkosten] [float] NULL,[surplus] [float] NULL,[typedeel] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_urencalculatie] ([urencalculatieid] [numeric] NOT NULL,[id] [int] NULL,[soldeerprocesid] [numeric] NULL,[kwaliteitsnormid] [numeric] NULL,[smd] [int] NULL,[th] [int] NULL,[mc] [int] NULL,[paneel] [int] NULL,[aantalinpaneel] [int] NULL,[separeren] [int] NULL,[medewerker] [nvarchar](30) NULL,[smdzijdeid] [numeric] NULL,[eenstencil] [int] NULL,[printreinigen] [int] NULL,[handmatigreinigen] [int] NULL,[ultrasonereinigen] [numeric] NULL,[ultrasoon] [int] NULL,[opmerking] [nvarchar](1024) NULL,[top] [int] NULL,[bottom] [int] NULL,[smdid] [int] NULL,[rctype] [numeric] NULL,[ictype] [numeric] NULL,[intapen] [int] NULL,[intapetijd] [numeric] NULL,[smdhand] [numeric] NULL,[rchand] [numeric] NULL,[ichand] [numeric] NULL,[smdmach] [numeric] NULL,[reflow] [numeric] NULL,[thid] [numeric] NULL,[afspotten] [int] NULL,[knipbuig] [int] NULL,[bestucken] [int] NULL,[sockets] [int] NULL,[addid] [int] NULL,[pressfit] [int] NULL,[programmeren] [int] NULL,[xray] [int] NULL,[eindcontrole] [int] NULL,[precon] [int] NULL,[drybake] [nvarchar](20) NULL,[profiling] [int] NULL,[test] [int] NULL,[typedeel] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertestmp] ([off_id] [int] NOT NULL,[QuotationID] [int] NULL,[CustomerID] [int] NULL,[Quotation_Number] [nvarchar](20) NULL,[Description] [varchar](MAX) NULL,[Entry_Date] [datetime] NULL,[Receive_Date] [datetime] NULL,[Deadline] [datetime] NULL,[Priority] [int] NULL,[Competition] [nvarchar](10) NULL,[Notes_Sales] [varchar](MAX) NULL,[Notes] [varchar](MAX) NULL,[Valid_Date] [datetime] NULL,[Deliverytime] [nvarchar](50) NULL,[Page_End] [smallint] NULL,[Reason] [nvarchar](30) NULL,[Offer_Date] [datetime] NULL,[Approved_Date] [datetime] NULL,[Final_Date] [datetime] NULL,[Direct] [smallint] NULL,[Additional_Remark] [varchar](MAX) NULL,[Cancelled] [smallint] NULL,[Rejected] [nvarchar](20) NULL,[RejectRemark] [varchar](MAX) NULL,[Sales_Order] [nchar](8) NULL,[Follow_up] [datetime] NULL,[Follow_up_Notes] [varchar](MAX) NULL,[Completed] [smallint] NULL,[Vacation_Period] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_order] ([id] [int] NOT NULL,[ordernummer] [nchar](8) NULL,[offertenummer] [nvarchar](20) NULL,[artikelnummer] [nvarchar](30) NULL,[behandeld] [date] NULL,[klant] [nvarchar](50) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_additioneelopmerking] ([additioneelopmerkingid] [int] NOT NULL,[urencalculatieid] [int] NOT NULL,[opmerking] [nvarchar](MAX) NULL,[tijd] [int] NULL,[batch] [bit] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_thhandsoldeer] ([id] [int] NOT NULL,[urencalculatieid] [int] NULL,[categorieid] [int] NULL,[aantal] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_tarieven] ([id] [int] NOT NULL,[category] [nvarchar](50) NULL,[description] [nvarchar](50) NULL,[price] [float] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_history] ([historyid] [uniqueidentifier] NOT NULL,[historynr] [int] NULL,[type] [int] NULL,[motivetype] [int] NULL,[materialreference] [nvarchar](50) NULL,[materialname] [nvarchar](50) NULL,[username] [nvarchar](50) NULL,[masterordername] [nvarchar](50) NULL,[workordername] [nvarchar](50) NULL,[linenumber] [int] NULL,[hostidentification] [nvarchar](50) NULL,[costcentername] [nvarchar](50) NULL,[lot] [nvarchar](50) NULL,[serialnumber] [nvarchar](50) NULL,[expirydate] [datetime] NULL,[productiondate] [datetime] NULL,[releasedate] [datetime] NULL,[qualification] [nvarchar](50) NULL,[ownername] [nvarchar](50) NULL,[recipientname] [nvarchar](50) NULL,[handlingunit] [nvarchar](50) NULL,[pickwarehousename] [nvarchar](50) NULL,[pickstorageunitname] [nvarchar](50) NULL,[pickcarriername] [nvarchar](50) NULL,[pickshelfname] [nvarchar](50) NULL,[pickzone] [nvarchar](50) NULL,[pickxstep] [int] NULL,[pickystep] [int] NULL,[picklocationname] [nvarchar](50) NULL,[pickbinname] [nvarchar](50) NULL,[putwarehousename] [nvarchar](50) NULL,[putstorageunitname] [nvarchar](50) NULL,[putcarriername] [nvarchar](50) NULL,[putshelfname] [nvarchar](50) NULL,[putzone] [nvarchar](50) NULL,[putxstep] [int] NULL,[putystep] [int] NULL,[putlocationname] [nvarchar](50) NULL,[putbinname] [nvarchar](50) NULL,[quantityrequested] [float] NULL,[quantityconfirmed] [float] NULL,[quantitydeviated] [float] NULL,[reasoncode] [nvarchar](50) NULL,[histmasterorderid] [uniqueidentifier] NULL,[histmasterorderlineid] [uniqueidentifier] NULL,[tasknr] [int] NULL,[creationdate] [datetime] NULL,[exportstatetype] [int] NULL,[uploaddate] [datetime] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_items] ([line_id] [int] NOT NULL,[offerte_id] [int] NULL,[artikel_id] [int] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[aantal] [int] NULL,[prijs] [money] NULL,[eenheid] [nvarchar](30) NULL,[opmerking] [nvarchar](100) NULL,[richtprijs] [smallint] NULL,[uitbesteding] [smallint] NULL,[datacheck] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_check] ([id] [int] NOT NULL,[artikelnummer] [nvarchar](30) NULL,[pcbnummer] [nvarchar](30) NULL,[tekening] [int] NULL,[txttekening] [nvarchar](50) NULL,[stuklijst] [int] NULL,[txtstuklijst] [nvarchar](50) NULL,[pcbdata] [int] NULL,[txtpcbdata] [nvarchar](50) NULL,[fiducialspacing] [int] NULL,[txtfiducialspacing] [nvarchar](50) NULL,[fiducialrand] [int] NULL,[txtfiducialrand] [nvarchar](50) NULL,[pcbdatabot] [int] NULL,[txtpcbdatabot] [nvarchar](50) NULL,[fiducialspacingbot] [int] NULL,[txtfiducialspacingbot] [nvarchar](50) NULL,[fiducialrandbot] [int] NULL,[txtfiducialrandbot] [nvarchar](50) NULL,[placementdata] [int] NULL,[txtplacementdata] [nvarchar](50) NULL,[maskerkleur] [int] NULL,[txtmaskerkleur] [nvarchar](50) NULL,[materiaal] [int] NULL,[txtmateriaal] [nvarchar](50) NULL,[laagdikte] [int] NULL,[txtlaagdikte] [nvarchar](50) NULL,[finish] [int] NULL,[txtfinish] [nvarchar](50) NULL,[silkscreen] [int] NULL,[txtsilkscreen] [nvarchar](50) NULL,[koperdikte] [int] NULL,[txtkoperdikte] [nvarchar](50) NULL,[pcbx] [float] NULL,[pcby] [float] NULL,[pcbdikte] [float] NULL,[paneelx] [int] NULL,[paneely] [int] NULL,[paneelrand] [float] NULL,[mousebites] [smallint] NULL,[vcut] [smallint] NULL,[reinigen] [smallint] NULL,[edges] [smallint] NULL,[stencildata] [smallint] NULL,[opmerking] [varchar](MAX) NULL,[randx1] [smallint] NULL,[randx2] [smallint] NULL,[randy1] [smallint] NULL,[randy2] [smallint] NULL,[uitmeten] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_details] ([det_id] [int] NOT NULL,[off_id] [int] NULL,[aantal] [float] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[fabrikant] [nvarchar](255) NULL,[fabrikantnummer] [nvarchar](255) NULL,[leveranciercode] [nchar](6) NULL,[leverancier] [nvarchar](50) NULL,[bestelnummer] [nvarchar](30) NULL,[bestelgrootte] [int] NULL,[verpakkingsaantal] [int] NULL,[eenheid] [nvarchar](30) NULL,[inkoopprijs] [float] NULL,[levertijd] [int] NULL,[laatst_ingekocht] [nvarchar](30) NULL,[opmerking] [varchar](MAX) NULL,[offerte_prijs] [float] NULL,[surplus] [int] NULL,[behoefte] [float] NULL,[stuksprijs] [float] NULL,[klantartno] [nvarchar](30) NULL,[beschikbaar] [float] NULL,[eprlevel] [int] NULL,[sublevel] [nvarchar](30) NULL,[eenmalig] [float] NULL,[moq] [int] NULL,[status] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes] ([off_id] [int] NOT NULL,[QuotationID] [int] NULL,[CustomerID] [int] NULL,[Quotation_Number] [nvarchar](20) NULL,[Description] [varchar](MAX) NULL,[Entry_Date] [datetime] NULL,[Receive_Date] [datetime] NULL,[Deadline] [datetime] NULL,[Priority] [int] NULL,[Competition] [nvarchar](10) NULL,[Notes_Sales] [varchar](MAX) NULL,[Notes] [varchar](MAX) NULL,[Valid_Date] [datetime] NULL,[Deliverytime] [nvarchar](50) NULL,[Page_End] [smallint] NULL,[Reason] [nvarchar](30) NULL,[Offer_Date] [datetime] NULL,[Approved_Date] [datetime] NULL,[Final_Date] [datetime] NULL,[Direct] [smallint] NULL,[Additional_Remark] [varchar](MAX) NULL,[Cancelled] [smallint] NULL,[Rejected] [nvarchar](20) NULL,[RejectRemark] [varchar](MAX) NULL,[Sales_Order] [nchar](8) NULL,[Follow_up] [datetime] NULL,[Follow_up_Notes] [varchar](MAX) NULL,[Completed] [smallint] NULL,[Vacation_Period] [smallint] NULL,[Prio_rity] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL)
	create database [test Coo];
	go
	use [test Coo];

	go
	CREATE TABLE [imp_tbl_calc_mc] ([urencalculatieid] [int] NULL,[mcid] [int] NOT NULL,[type] [nvarchar](4) NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[aantal] [float] NULL,[pins] [int] NULL,[tijd] [int] NULL,[opmerking] [nvarchar](MAX) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_tijden] ([id] [int] NOT NULL,[categorie] [nvarchar](15) NULL,[processtap] [int] NULL,[aktiviteit] [nvarchar](50) NULL,[tijd] [float] NULL,[man] [int] NULL,[machine] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_notities] ([id] [nvarchar](2) NOT NULL,[notitie] [varchar](MAX) NULL,[medewerker] [nvarchar](30) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_order_samples] ([id] [int] NOT NULL,[receivedate] [datetime] NULL,[sample delivery] [datetime] NULL,[ecd] [datetime] NULL,[text] [nvarchar](50) NULL,[instruction] [int] NULL,[prioriteit] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_opmerkingen] ([id] [int] NOT NULL,[opmerking] [nvarchar](50) NULL,[tekst] [varchar](MAX) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_sub] ([art_id] [int] NOT NULL,[offerte_id] [int] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[npi] [smallint] NULL,[melding_wvb] [varchar](MAX) NULL,[pcbdata] [nvarchar](3) NULL,[pcb] [datetime] NULL,[stuklijst] [datetime] NULL,[bomtemp] [smallint] NULL,[calculatie] [datetime] NULL,[test] [smallint] NULL,[dlt] [smallint] NULL,[melding_inkoop] [varchar](MAX) NULL,[pcbaanvraag] [datetime] NULL,[stuklijst_ink] [datetime] NULL,[inkoopdata] [datetime] NULL,[eenheid] [nvarchar](30) NULL,[aantal] [int] NULL,[categorie] [nvarchar](10) NULL,[uitbesteding] [smallint] NULL,[prijs] [money] NULL,[opmerking] [varchar](MAX) NULL,[richtprijs] [smallint] NULL,[wvb_check] [smallint] NULL,[wvb_emp] [int] NULL,[ink_check] [smallint] NULL,[ink_emp] [int] NULL,[progkosten] [float] NULL,[seriekosten] [float] NULL,[prodkosten] [float] NULL,[stencilkosten] [float] NULL,[materiaalkosten] [float] NULL,[surplus] [float] NULL,[typedeel] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_urencalculatie] ([urencalculatieid] [numeric] NOT NULL,[id] [int] NULL,[soldeerprocesid] [numeric] NULL,[kwaliteitsnormid] [numeric] NULL,[smd] [int] NULL,[th] [int] NULL,[mc] [int] NULL,[paneel] [int] NULL,[aantalinpaneel] [int] NULL,[separeren] [int] NULL,[medewerker] [nvarchar](30) NULL,[smdzijdeid] [numeric] NULL,[eenstencil] [int] NULL,[printreinigen] [int] NULL,[handmatigreinigen] [int] NULL,[ultrasonereinigen] [numeric] NULL,[ultrasoon] [int] NULL,[opmerking] [nvarchar](1024) NULL,[top] [int] NULL,[bottom] [int] NULL,[smdid] [int] NULL,[rctype] [numeric] NULL,[ictype] [numeric] NULL,[intapen] [int] NULL,[intapetijd] [numeric] NULL,[smdhand] [numeric] NULL,[rchand] [numeric] NULL,[ichand] [numeric] NULL,[smdmach] [numeric] NULL,[reflow] [numeric] NULL,[thid] [numeric] NULL,[afspotten] [int] NULL,[knipbuig] [int] NULL,[bestucken] [int] NULL,[sockets] [int] NULL,[addid] [int] NULL,[pressfit] [int] NULL,[programmeren] [int] NULL,[xray] [int] NULL,[eindcontrole] [int] NULL,[precon] [int] NULL,[drybake] [nvarchar](20) NULL,[profiling] [int] NULL,[test] [int] NULL,[typedeel] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertestmp] ([off_id] [int] NOT NULL,[QuotationID] [int] NULL,[CustomerID] [int] NULL,[Quotation_Number] [nvarchar](20) NULL,[Description] [varchar](MAX) NULL,[Entry_Date] [datetime] NULL,[Receive_Date] [datetime] NULL,[Deadline] [datetime] NULL,[Priority] [int] NULL,[Competition] [nvarchar](10) NULL,[Notes_Sales] [varchar](MAX) NULL,[Notes] [varchar](MAX) NULL,[Valid_Date] [datetime] NULL,[Deliverytime] [nvarchar](50) NULL,[Page_End] [smallint] NULL,[Reason] [nvarchar](30) NULL,[Offer_Date] [datetime] NULL,[Approved_Date] [datetime] NULL,[Final_Date] [datetime] NULL,[Direct] [smallint] NULL,[Additional_Remark] [varchar](MAX) NULL,[Cancelled] [smallint] NULL,[Rejected] [nvarchar](20) NULL,[RejectRemark] [varchar](MAX) NULL,[Sales_Order] [nchar](8) NULL,[Follow_up] [datetime] NULL,[Follow_up_Notes] [varchar](MAX) NULL,[Completed] [smallint] NULL,[Vacation_Period] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_order] ([id] [int] NOT NULL,[ordernummer] [nchar](8) NULL,[offertenummer] [nvarchar](20) NULL,[artikelnummer] [nvarchar](30) NULL,[behandeld] [date] NULL,[klant] [nvarchar](50) NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_additioneelopmerking] ([additioneelopmerkingid] [int] NOT NULL,[urencalculatieid] [int] NOT NULL,[opmerking] [nvarchar](MAX) NULL,[tijd] [int] NULL,[batch] [bit] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_calc_thhandsoldeer] ([id] [int] NOT NULL,[urencalculatieid] [int] NULL,[categorieid] [int] NULL,[aantal] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_calc_tarieven] ([id] [int] NOT NULL,[category] [nvarchar](50) NULL,[description] [nvarchar](50) NULL,[price] [float] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_history] ([historyid] [uniqueidentifier] NOT NULL,[historynr] [int] NULL,[type] [int] NULL,[motivetype] [int] NULL,[materialreference] [nvarchar](50) NULL,[materialname] [nvarchar](50) NULL,[username] [nvarchar](50) NULL,[masterordername] [nvarchar](50) NULL,[workordername] [nvarchar](50) NULL,[linenumber] [int] NULL,[hostidentification] [nvarchar](50) NULL,[costcentername] [nvarchar](50) NULL,[lot] [nvarchar](50) NULL,[serialnumber] [nvarchar](50) NULL,[expirydate] [datetime] NULL,[productiondate] [datetime] NULL,[releasedate] [datetime] NULL,[qualification] [nvarchar](50) NULL,[ownername] [nvarchar](50) NULL,[recipientname] [nvarchar](50) NULL,[handlingunit] [nvarchar](50) NULL,[pickwarehousename] [nvarchar](50) NULL,[pickstorageunitname] [nvarchar](50) NULL,[pickcarriername] [nvarchar](50) NULL,[pickshelfname] [nvarchar](50) NULL,[pickzone] [nvarchar](50) NULL,[pickxstep] [int] NULL,[pickystep] [int] NULL,[picklocationname] [nvarchar](50) NULL,[pickbinname] [nvarchar](50) NULL,[putwarehousename] [nvarchar](50) NULL,[putstorageunitname] [nvarchar](50) NULL,[putcarriername] [nvarchar](50) NULL,[putshelfname] [nvarchar](50) NULL,[putzone] [nvarchar](50) NULL,[putxstep] [int] NULL,[putystep] [int] NULL,[putlocationname] [nvarchar](50) NULL,[putbinname] [nvarchar](50) NULL,[quantityrequested] [float] NULL,[quantityconfirmed] [float] NULL,[quantitydeviated] [float] NULL,[reasoncode] [nvarchar](50) NULL,[histmasterorderid] [uniqueidentifier] NULL,[histmasterorderlineid] [uniqueidentifier] NULL,[tasknr] [int] NULL,[creationdate] [datetime] NULL,[exportstatetype] [int] NULL,[uploaddate] [datetime] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_items] ([line_id] [int] NOT NULL,[offerte_id] [int] NULL,[artikel_id] [int] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[aantal] [int] NULL,[prijs] [money] NULL,[eenheid] [nvarchar](30) NULL,[opmerking] [nvarchar](100) NULL,[richtprijs] [smallint] NULL,[uitbesteding] [smallint] NULL,[datacheck] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_check] ([id] [int] NOT NULL,[artikelnummer] [nvarchar](30) NULL,[pcbnummer] [nvarchar](30) NULL,[tekening] [int] NULL,[txttekening] [nvarchar](50) NULL,[stuklijst] [int] NULL,[txtstuklijst] [nvarchar](50) NULL,[pcbdata] [int] NULL,[txtpcbdata] [nvarchar](50) NULL,[fiducialspacing] [int] NULL,[txtfiducialspacing] [nvarchar](50) NULL,[fiducialrand] [int] NULL,[txtfiducialrand] [nvarchar](50) NULL,[pcbdatabot] [int] NULL,[txtpcbdatabot] [nvarchar](50) NULL,[fiducialspacingbot] [int] NULL,[txtfiducialspacingbot] [nvarchar](50) NULL,[fiducialrandbot] [int] NULL,[txtfiducialrandbot] [nvarchar](50) NULL,[placementdata] [int] NULL,[txtplacementdata] [nvarchar](50) NULL,[maskerkleur] [int] NULL,[txtmaskerkleur] [nvarchar](50) NULL,[materiaal] [int] NULL,[txtmateriaal] [nvarchar](50) NULL,[laagdikte] [int] NULL,[txtlaagdikte] [nvarchar](50) NULL,[finish] [int] NULL,[txtfinish] [nvarchar](50) NULL,[silkscreen] [int] NULL,[txtsilkscreen] [nvarchar](50) NULL,[koperdikte] [int] NULL,[txtkoperdikte] [nvarchar](50) NULL,[pcbx] [float] NULL,[pcby] [float] NULL,[pcbdikte] [float] NULL,[paneelx] [int] NULL,[paneely] [int] NULL,[paneelrand] [float] NULL,[mousebites] [smallint] NULL,[vcut] [smallint] NULL,[reinigen] [smallint] NULL,[edges] [smallint] NULL,[stencildata] [smallint] NULL,[opmerking] [varchar](MAX) NULL,[randx1] [smallint] NULL,[randx2] [smallint] NULL,[randy1] [smallint] NULL,[randy2] [smallint] NULL,[uitmeten] [smallint] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes_details] ([det_id] [int] NOT NULL,[off_id] [int] NULL,[aantal] [float] NULL,[artikelnummer] [nvarchar](30) NULL,[omschrijving] [nvarchar](60) NULL,[fabrikant] [nvarchar](255) NULL,[fabrikantnummer] [nvarchar](255) NULL,[leveranciercode] [nchar](6) NULL,[leverancier] [nvarchar](50) NULL,[bestelnummer] [nvarchar](30) NULL,[bestelgrootte] [int] NULL,[verpakkingsaantal] [int] NULL,[eenheid] [nvarchar](30) NULL,[inkoopprijs] [float] NULL,[levertijd] [int] NULL,[laatst_ingekocht] [nvarchar](30) NULL,[opmerking] [varchar](MAX) NULL,[offerte_prijs] [float] NULL,[surplus] [int] NULL,[behoefte] [float] NULL,[stuksprijs] [float] NULL,[klantartno] [nvarchar](30) NULL,[beschikbaar] [float] NULL,[eprlevel] [int] NULL,[sublevel] [nvarchar](30) NULL,[eenmalig] [float] NULL,[moq] [int] NULL,[status] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL);CREATE TABLE [imp_tbl_offertes] ([off_id] [int] NOT NULL,[QuotationID] [int] NULL,[CustomerID] [int] NULL,[Quotation_Number] [nvarchar](20) NULL,[Description] [varchar](MAX) NULL,[Entry_Date] [datetime] NULL,[Receive_Date] [datetime] NULL,[Deadline] [datetime] NULL,[Priority] [int] NULL,[Competition] [nvarchar](10) NULL,[Notes_Sales] [varchar](MAX) NULL,[Notes] [varchar](MAX) NULL,[Valid_Date] [datetime] NULL,[Deliverytime] [nvarchar](50) NULL,[Page_End] [smallint] NULL,[Reason] [nvarchar](30) NULL,[Offer_Date] [datetime] NULL,[Approved_Date] [datetime] NULL,[Final_Date] [datetime] NULL,[Direct] [smallint] NULL,[Additional_Remark] [varchar](MAX) NULL,[Cancelled] [smallint] NULL,[Rejected] [nvarchar](20) NULL,[RejectRemark] [varchar](MAX) NULL,[Sales_Order] [nchar](8) NULL,[Follow_up] [datetime] NULL,[Follow_up_Notes] [varchar](MAX) NULL,[Completed] [smallint] NULL,[Vacation_Period] [smallint] NULL,[Prio_rity] [int] NULL,[iqbs_timestamp] [datetime] NULL,[iqbs_processed] [bit] NOT NULL,[iqbs_operation] [varchar](1) NULL,[iqbs_connector] [varchar](20) NULL)