-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathdecifraBase64.txt
28 lines (26 loc) · 1.99 KB
/
decifraBase64.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[unifiedtaxcorrige]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[unifiedtaxcorrige]
GO
CREATE TABLE [dbo].[unifiedtaxcorrige] (
[idunifiedtaxcorrige] [int] NOT NULL ,
[idexpensetaxcorrige] [int] NOT NULL ,
[taxcode] [int] NOT NULL ,
[ayear] [smallint] NULL ,
[employamount] [decimal](19, 2) NULL ,
[adminamount] [decimal](19, 2) NULL ,
[idcity] [int] NULL ,
[idfiscaltaxregion] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[adate] [datetime] NULL ,
[ct] [datetime] NOT NULL ,
[cu] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[lt] [datetime] NOT NULL ,
[lu] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[nmonth] [smallint] NULL ,
[iddbdepartment] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[idreg] [int] NULL ,
[ymov] [smallint] NULL ,
[nmov] [int] NULL ,
[npay] [int] NULL ,
[idexp] [int] NULL
) ON [PRIMARY]
GO