if not Exists(SELECT * FROM information_schema.tables where Table_name = 'TaxHeader')
begin
create table dbo.TaxHeader
(
	ID	int Primary key,
	FC_ID	int references dbo.Finance_Cycle(ID) not null,
	Pro_ID_VahedMali	int references dbo.OtherProperties(ID) not null,
	Mat_ID	bigint references dbo.Matter(ID) not null,
	Dom_ID_Status	int references dbo.Domain(ID) not null,
	Dom_ID_BillType	int references dbo.Domain(ID) not null,
	Dom_ID_PatternType	int references dbo.Domain(ID) not null,
	Dom_ID_SubjectTax	int references dbo.Domain(ID) not null,
	Dom_ID_CustomerType	int references dbo.Domain(ID) not null,
	Dom_ID_FlyType	int references dbo.Domain(ID) not null,
	Dom_ID_SettlementType	int references dbo.Domain(ID) not null,
	Dom_ID_VatPaymentType	int references dbo.Domain(ID) not null,
	[Datetime]	Datetime not null,
	
	--Serial	nvarchar(200),
	Taxid	nvarchar(200),
	Indatim	bigint not null,
	Indati2m	bigint not null,
	Inty	int  not null,
	Inno	nvarchar(200),
	Irtaxid	nvarchar(200),
	Inp	int  not null,
	Ins	int  not null,
	Tins	nvarchar(200),
	Tob	int  not null,
	Bid	nvarchar(200),
	Tinb	nvarchar(200),
	Sbc	nvarchar(200),
	Bpc	nvarchar(200),
	Bbc	nvarchar(200),
	Ft	int  not null,
	Bpn	nvarchar(200),
	Scln	nvarchar(200),
	Scc	nvarchar(200),
	Crn	nvarchar(200),
	Billid	nvarchar(200),
	Tprdis	decimal(19,4) not null,
	Tdis	decimal(19,4) not null,
	Tadis	decimal(19,4) not null,
	Tvam	decimal(19,4) not null,
	Todam	decimal(19,4) not null,
	Tbill	decimal(19,4) not null,
	Setm	int not null,
	
	Cap		decimal(19,4) not null,
	Insp	decimal(19,4) not null,
	Tvop	decimal(19,4) not null,
	Dpvb	int not null,
	Tax17	decimal(19,4) not null,
	
	Cdcn	nvarchar(200),
	Cdcd	int not null,
	Tonw	decimal(19,4)not null,
	Torv	decimal(19,4)not null,
	Tocv	decimal(19,4)not null,
	
	
	
	
	
	ReferenceNumber	nvarchar(600),
	[UID]	nvarchar(600),
	[Guid] nvarchar(400),
	[Error] nvarchar(max),
	[Warning] nvarchar(max),
	[JsonData] nvarchar(max)
	
)
end