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
| CREATE TABLE [dbo].[COMMISSION](
[COM_ID] [bigint] NOT NULL,
[COM_AMT_LOCAL] [numeric](18, 6) NULL,
[COM_CUR_NAME] [nvarchar](50) NULL,
[COM_AMT_EURO] [numeric](18, 6) NULL,
[COM_BILLING_YEAR_DAT] [int] NULL,
[COM_BILLING_MONTH_NUM_DAT] [int] NULL,
[COM_LGB_NAME] [nvarchar](255) NULL,
[COM_LOG_NAME] [nvarchar](255) NULL,
[COM_SUB_NAME] [nvarchar](255) NULL,
[COM_BILACC_NAME] [nvarchar](255) NULL,
[COM_IS_EVENT] [smallint] NULL,
[COM_IS_ONE_RATE] [smallint] NULL,
[COM_PRO_NAME] [nvarchar](255) NULL,
[COM_STATUS] [nvarchar](255) NULL,
[COM_SAL_NAME] [nvarchar](255) NULL,
[COM_LOGO_MONTH_NEW] [int] NULL,
[COM_DURATION_BILLED] [numeric](18, 6) NULL,
[COM_BILLING_YEAR_MONTH] [int] NULL,
[COM_IS_BILLED] [int] NULL,
[COM_SALES_GROUP_NAME] [nvarchar](255) NULL,
[COM_LOGO_YEAR_NEW] [int] NULL,
[COM_BILACC_REF] [varchar](255) NULL,
[COM_CUR_ISONAME] [char](4) NULL,
[COM_LOGO_YEAR_MONTH_NEW] [int] NULL,
[COM_WIN_BACK] [int] NULL
) |
Partager