USE [ebiz영업_남향해남] GO /****** 개체: Table [dbo].[k13_1] 스크립트 날짜: 10/06/2014 11:01:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[k13_1]( [급지1] [numeric](10, 0) NOT NULL, [급지2] [numeric](10, 0) NOT NULL, [급지3] [numeric](10, 0) NOT NULL, [급지4] [numeric](10, 0) NOT NULL, [급지5] [numeric](10, 0) NOT NULL, [급지기타] [numeric](10, 0) NOT NULL, [고속도로] [numeric](4, 0) NOT NULL, [할부공제] [numeric](4, 0) NOT NULL, [식대지원] [numeric](6, 0) NOT NULL, [식대단가] [numeric](4, 0) NOT NULL, [경유] [numeric](4, 0) NOT NULL, [기본급] [numeric](7, 0) NOT NULL, [만근] [numeric](6, 0) NOT NULL, [월차] [numeric](6, 0) NOT NULL, [월차대무] [numeric](6, 0) NOT NULL, [근속] [numeric](6, 0) NOT NULL, [회전] [numeric](7, 0) NOT NULL, [회전1] [numeric](7, 0) NOT NULL, [잔업시간] [char](5) NOT NULL, [잔업금액] [numeric](6, 0) NOT NULL, [잔업시간1] [char](5) NOT NULL, [잔업금액1] [numeric](6, 0) NOT NULL, [잔업시간2] [char](5) NOT NULL, [잔업금액2] [numeric](6, 0) NOT NULL, [주행거리] [numeric](4, 0) NOT NULL, [주행금액] [numeric](6, 0) NOT NULL, [주행거리1] [numeric](4, 0) NOT NULL, [주행금액1] [numeric](6, 0) NOT NULL, [주행거리2] [numeric](4, 0) NOT NULL, [주행금액2] [numeric](6, 0) NOT NULL, [주행거리3] [numeric](4, 0) NOT NULL, [주행금액3] [numeric](6, 0) NOT NULL, [하조출] [char](5) NOT NULL, [하조출금] [numeric](6, 0) NOT NULL, [하대기] [numeric](6, 0) NOT NULL, [하조출1] [char](5) NOT NULL, [하조출금1] [numeric](6, 0) NOT NULL, [하대기1] [numeric](6, 0) NOT NULL, [하시간] [char](5) NOT NULL, [하대기2] [numeric](6, 0) NOT NULL, [동조출] [char](5) NOT NULL, [동조출금] [numeric](6, 0) NOT NULL, [동대기] [numeric](6, 0) NOT NULL, [동조출1] [char](5) NOT NULL, [동조출금1] [numeric](6, 0) NOT NULL, [동대기1] [numeric](6, 0) NOT NULL, [동시간] [char](5) NOT NULL, [동대기2] [numeric](6, 0) NOT NULL, [구간1] [numeric](5, 0) NOT NULL, [구간2] [numeric](5, 0) NOT NULL, [구간3] [numeric](5, 0) NOT NULL, [구간4] [numeric](5, 0) NOT NULL, [구간5] [numeric](5, 0) NOT NULL, [구간6] [numeric](5, 0) NOT NULL, [구간7] [numeric](5, 0) NOT NULL, [구간8] [numeric](5, 0) NOT NULL, [구간9] [numeric](5, 0) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms560] 스크립트 날짜: 10/06/2014 11:05:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms560]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms560_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms560_d11_cname] DEFAULT (' '), [청구처코드] [char](6) NOT NULL CONSTRAINT [DF_ksms560_청구처코드] DEFAULT (''), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms560_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms560_d16_cname] DEFAULT (' '), [d31_wdate] [datetime] NOT NULL CONSTRAINT [DF_ksms560_d31_wdate] DEFAULT (getdate()), [d52_si] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms560_d52_si] DEFAULT ((0)), [s_date] [datetime] NOT NULL CONSTRAINT [DF_ksms560_s_date] DEFAULT (getdate()), [e_date] [datetime] NOT NULL CONSTRAINT [DF_ksms560_e_date] DEFAULT (getdate()), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms560_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_ksms560_d14_name] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms560_d15_code] DEFAULT (' '), [d15_name] [char](12) NOT NULL CONSTRAINT [DF_ksms560_d15_name] DEFAULT (' '), [d5b_remk] [char](50) NOT NULL CONSTRAINT [DF_ksms560_d5b_remk] DEFAULT (' '), [d52_yo] [char](4) NOT NULL CONSTRAINT [DF_ksms560_d52_yo] DEFAULT (' '), [qty1] [numeric](7, 2) NOT NULL CONSTRAINT [DF_ksms560_qty1] DEFAULT ((0)), [amt1] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms560_amt1] DEFAULT ((0)), [vat1] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms560_vat1] DEFAULT ((0)), [d_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms560_d_gubun] DEFAULT (' '), [d_gono] [char](30) NOT NULL CONSTRAINT [DF_ksms560_d_gono] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[할부_0000] 스크립트 날짜: 10/06/2014 11:00:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[할부_0000]( [d13_date] [datetime] NOT NULL, [d13_code] [char](4) NOT NULL, [d13_name] [char](10) NOT NULL, [gu] [char](1) NOT NULL, [gu1] [char](1) NOT NULL, [대납액] [float] NOT NULL, [회수액] [float] NOT NULL, [이자] [float] NOT NULL, [적요] [char](40) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[k13_2] 스크립트 날짜: 10/06/2014 11:01:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[k13_2]( [g_code] [char](3) NOT NULL, [업소명] [char](20) NOT NULL, [gubun] [char](2) NOT NULL, [구분] [char](10) NOT NULL, [gubun1] [char](2) NOT NULL, [품목] [char](20) NOT NULL, [단가] [float] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms160] 스크립트 날짜: 10/06/2014 11:03:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms160]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms160_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms160_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms160_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms160_d16_cname] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms160_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms160_d15_name] DEFAULT (' '), [d16_15name] [char](10) NOT NULL CONSTRAINT [DF_ksms160_d16_15name] DEFAULT (' '), [d16_time] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms160_d16_time] DEFAULT ((0)), [d16_kiro] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms160_d16_kiro] DEFAULT ((0)), [d16_odate] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms160_d16_odate] DEFAULT (getdate()), [d16_addr] [char](50) NOT NULL CONSTRAINT [DF_ksms160_d16_addr] DEFAULT (' '), [d16_post] [char](7) NOT NULL CONSTRAINT [DF_ksms160_d16_post] DEFAULT (' '), [d16_tele] [char](19) NOT NULL CONSTRAINT [DF_ksms160_d16_tele] DEFAULT (' '), [d16_cgubun] [char](1) NOT NULL CONSTRAINT [DF_ksms160_d16_cgubun] DEFAULT (' '), [d16_sdate] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms160_d16_sdate] DEFAULT (getdate()), [d16_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms160_d16_gubun] DEFAULT (' '), [d16_posi] [char](30) NOT NULL CONSTRAINT [DF_ksms160_d16_posi] DEFAULT (' '), [d16_remk] [char](30) NOT NULL CONSTRAINT [DF_ksms160_d16_remk] DEFAULT (' '), [d16_급지] [numeric](3, 1) NOT NULL CONSTRAINT [DF_ksms160_d16_급지] DEFAULT ((0)), [d16_priper] [numeric](5, 1) NOT NULL CONSTRAINT [DF_ksms160_d16_priper] DEFAULT ((0)), [d_qty000] [numeric](11, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty000] DEFAULT ((0)), [d_qty00] [numeric](10, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty00] DEFAULT ((0)), [d_qty01] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty01] DEFAULT ((0)), [d_qty02] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty02] DEFAULT ((0)), [d_qty03] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty03] DEFAULT ((0)), [d_qty04] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty04] DEFAULT ((0)), [d_qty05] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty05] DEFAULT ((0)), [d_qty06] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty06] DEFAULT ((0)), [d_qty07] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty07] DEFAULT ((0)), [d_qty08] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty08] DEFAULT ((0)), [d_qty09] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty09] DEFAULT ((0)), [d_qty10] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty10] DEFAULT ((0)), [d_qty11] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty11] DEFAULT ((0)), [d_qty12] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_qty12] DEFAULT ((0)), [d_vat000] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat000] DEFAULT ((0)), [d_vat00] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat00] DEFAULT ((0)), [d_vat01] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat01] DEFAULT ((0)), [d_vat02] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat02] DEFAULT ((0)), [d_vat03] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat03] DEFAULT ((0)), [d_vat04] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat04] DEFAULT ((0)), [d_vat05] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat05] DEFAULT ((0)), [d_vat06] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat06] DEFAULT ((0)), [d_vat07] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat07] DEFAULT ((0)), [d_vat08] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat08] DEFAULT ((0)), [d_vat09] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat09] DEFAULT ((0)), [d_vat10] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat10] DEFAULT ((0)), [d_vat11] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat11] DEFAULT ((0)), [d_vat12] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_vat12] DEFAULT ((0)), [d_amt000] [numeric](13, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt000] DEFAULT ((0)), [d_amt00] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt00] DEFAULT ((0)), [d_amt01] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt01] DEFAULT ((0)), [d_amt02] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt02] DEFAULT ((0)), [d_amt03] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt03] DEFAULT ((0)), [d_amt04] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt04] DEFAULT ((0)), [d_amt05] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt05] DEFAULT ((0)), [d_amt06] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt06] DEFAULT ((0)), [d_amt07] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt07] DEFAULT ((0)), [d_amt08] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt08] DEFAULT ((0)), [d_amt09] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt09] DEFAULT ((0)), [d_amt10] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt10] DEFAULT ((0)), [d_amt11] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt11] DEFAULT ((0)), [d_amt12] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_amt12] DEFAULT ((0)), [d_i_amt000] [numeric](13, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt000] DEFAULT ((0)), [d_i_amt00] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt00] DEFAULT ((0)), [d_i_amt01] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt01] DEFAULT ((0)), [d_i_amt02] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt02] DEFAULT ((0)), [d_i_amt03] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt03] DEFAULT ((0)), [d_i_amt04] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt04] DEFAULT ((0)), [d_i_amt05] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt05] DEFAULT ((0)), [d_i_amt06] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt06] DEFAULT ((0)), [d_i_amt07] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt07] DEFAULT ((0)), [d_i_amt08] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt08] DEFAULT ((0)), [d_i_amt09] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt09] DEFAULT ((0)), [d_i_amt10] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt10] DEFAULT ((0)), [d_i_amt11] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt11] DEFAULT ((0)), [d_i_amt12] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_amt12] DEFAULT ((0)), [d_i_vat000] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat000] DEFAULT ((0)), [d_i_vat00] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat00] DEFAULT ((0)), [d_i_vat01] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat01] DEFAULT ((0)), [d_i_vat02] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat02] DEFAULT ((0)), [d_i_vat03] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat03] DEFAULT ((0)), [d_i_vat04] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat04] DEFAULT ((0)), [d_i_vat05] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat05] DEFAULT ((0)), [d_i_vat06] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat06] DEFAULT ((0)), [d_i_vat07] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat07] DEFAULT ((0)), [d_i_vat08] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat08] DEFAULT ((0)), [d_i_vat09] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat09] DEFAULT ((0)), [d_i_vat10] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat10] DEFAULT ((0)), [d_i_vat11] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat11] DEFAULT ((0)), [d_i_vat12] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_vat12] DEFAULT ((0)), [d_i_qty000] [numeric](11, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty000] DEFAULT ((0)), [d_i_qty00] [numeric](10, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty00] DEFAULT ((0)), [d_i_qty01] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty01] DEFAULT ((0)), [d_i_qty02] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty02] DEFAULT ((0)), [d_i_qty03] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty03] DEFAULT ((0)), [d_i_qty04] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty04] DEFAULT ((0)), [d_i_qty05] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty05] DEFAULT ((0)), [d_i_qty06] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty06] DEFAULT ((0)), [d_i_qty07] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty07] DEFAULT ((0)), [d_i_qty08] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty08] DEFAULT ((0)), [d_i_qty09] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty09] DEFAULT ((0)), [d_i_qty10] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty10] DEFAULT ((0)), [d_i_qty11] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty11] DEFAULT ((0)), [d_i_qty12] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms160_d_i_qty12] DEFAULT ((0)), [d_i_dc000] [numeric](13, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc000] DEFAULT ((0)), [d_i_dc00] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc00] DEFAULT ((0)), [d_i_dc01] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc01] DEFAULT ((0)), [d_i_dc02] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc02] DEFAULT ((0)), [d_i_dc03] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc03] DEFAULT ((0)), [d_i_dc04] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc04] DEFAULT ((0)), [d_i_dc05] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc05] DEFAULT ((0)), [d_i_dc06] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc06] DEFAULT ((0)), [d_i_dc07] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc07] DEFAULT ((0)), [d_i_dc08] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc08] DEFAULT ((0)), [d_i_dc09] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc09] DEFAULT ((0)), [d_i_dc10] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc10] DEFAULT ((0)), [d_i_dc11] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc11] DEFAULT ((0)), [d_i_dc12] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms160_d_i_dc12] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[시공등급] 스크립트 날짜: 10/06/2014 10:59:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[시공등급]( [시공등급] [nchar](10) NOT NULL CONSTRAINT [DF_시공등급_시공등급] DEFAULT (''), [설명] [nchar](40) NOT NULL CONSTRAINT [DF_시공등급_설명] DEFAULT ('') ) ON [PRIMARY] GO /****** 개체: Table [dbo].[기간운반단가] 스크립트 날짜: 10/06/2014 10:59:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[기간운반단가]( [시작일] [smalldatetime] NOT NULL CONSTRAINT [DF_기간운반단가_시작일] DEFAULT (getdate()), [마감일] [smalldatetime] NOT NULL CONSTRAINT [DF_기간운반단가_마감일] DEFAULT (getdate()), [운행구분] [char](10) NOT NULL CONSTRAINT [DF_기간운반단가_운행구분] DEFAULT (''), [운반단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_기간운반단가_운반단가] DEFAULT ((0)), [계산구분] [nchar](10) NOT NULL CONSTRAINT [DF_기간운반단가_계산구분] DEFAULT (''), [기초수당] [numeric](5, 0) NOT NULL CONSTRAINT [DF_기간운반단가_기초수당] DEFAULT ((0)), [km추가단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_기간운반단가_km추가단가] DEFAULT ((0)), [유류단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_기간운반단가_유류단가] DEFAULT ((0)), [미만초과단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_기간운반단가_미만초과단가] DEFAULT ((0)), [m3계산기준] [numeric](5, 2) NOT NULL CONSTRAINT [DF_기간운반단가_m3계산기준] DEFAULT ((0)), [회수계산기준] [numeric](5, 2) NOT NULL CONSTRAINT [DF_기간운반단가_회수계산기준] DEFAULT ((0)), [초과m3기준] [numeric](5, 2) NOT NULL CONSTRAINT [DF_기간운반단가_초과m3기준] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[이동_0000] 스크립트 날짜: 10/06/2014 11:00:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[이동_0000]( [d13_date] [datetime] NOT NULL CONSTRAINT [DF_이동_0000_d13_date] DEFAULT (getdate()), [d13_code] [char](4) NOT NULL CONSTRAINT [DF_이동_0000_d13_code] DEFAULT (''), [d13_name] [char](10) NOT NULL CONSTRAINT [DF_이동_0000_d13_name] DEFAULT (''), [gu] [char](1) NOT NULL CONSTRAINT [DF_이동_0000_gu] DEFAULT (''), [gu1] [char](1) NOT NULL CONSTRAINT [DF_이동_0000_gu1] DEFAULT (''), [구간] [numeric](1, 0) NOT NULL CONSTRAINT [DF_이동_0000_구간] DEFAULT ((0)), [수량] [numeric](6, 1) NOT NULL CONSTRAINT [DF_이동_0000_수량] DEFAULT ((0)), [경유량] [numeric](6, 1) NOT NULL CONSTRAINT [DF_이동_0000_경유량] DEFAULT ((0)), [금액] [numeric](10, 0) NOT NULL CONSTRAINT [DF_이동_0000_금액] DEFAULT ((0)), [적요] [nchar](40) NOT NULL CONSTRAINT [DF_이동_0000_적요] DEFAULT (''), [비고] [nchar](200) NOT NULL CONSTRAINT [DF_이동_0000_비고] DEFAULT (''), [용차통행] [numeric](7, 0) NOT NULL CONSTRAINT [DF_이동_0000_용차통행] DEFAULT ((0)), [용차운반] [numeric](7, 0) NOT NULL CONSTRAINT [DF_이동_0000_용차운반] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[k17a] 스크립트 날짜: 10/06/2014 11:01:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[k17a]( [date] [datetime] NOT NULL CONSTRAINT [DF_k17a_date] DEFAULT (getdate()), [d17_order] [char](10) NOT NULL CONSTRAINT [DF_k17a_d17_order] DEFAULT (' '), [법인코드] [char](3) NOT NULL CONSTRAINT [DF_k17a_법인코드] DEFAULT (' '), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_k17a_공장코드] DEFAULT (' '), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_k17a_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_k17a_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_k17a_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_k17a_d16_cname] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_k17a_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_k17a_d14_name] DEFAULT (' '), [d14_honhwa] [char](10) NOT NULL CONSTRAINT [DF_k17a_d14_honhwa] DEFAULT (' '), [d17_gubun] [char](1) NOT NULL CONSTRAINT [DF_k17a_d17_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_k17a_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_k17a_d15_name] DEFAULT (' '), [d17_code] [char](1) NOT NULL CONSTRAINT [DF_k17a_d17_code] DEFAULT (' '), [d17_name] [char](9) NOT NULL CONSTRAINT [DF_k17a_d17_name] DEFAULT (' '), [d17_gbpri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k17a_d17_gbpri] DEFAULT ((0)), [d17_hbpri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k17a_d17_hbpri] DEFAULT ((0)), [d17_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_k17a_d17_qty] DEFAULT ((0)), [d17_priper] [numeric](6, 2) NOT NULL CONSTRAINT [DF_k17a_d17_priper] DEFAULT ((0)), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_k17a_d17_jogun] DEFAULT (' '), [d17_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k17a_d17_pri] DEFAULT ((0)), [d17_remk] [char](30) NOT NULL CONSTRAINT [DF_k17a_d17_remk] DEFAULT (' '), [ch_lube] [numeric](10, 2) NOT NULL CONSTRAINT [DF_k17a_ch_lube] DEFAULT ((0)), [d17_no] [char](2) NOT NULL CONSTRAINT [DF_k17a_d17_no] DEFAULT (' '), [order_no] [char](20) NOT NULL CONSTRAINT [DF_k17a_order_no] DEFAULT (' '), [매입코드] [char](6) NOT NULL CONSTRAINT [DF_k17a_매입코드] DEFAULT (' '), [매출코드] [char](6) NOT NULL CONSTRAINT [DF_k17a_매출코드] DEFAULT (' '), [여신금액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_k17a_여신금액] DEFAULT ((0)), [여신잔액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_k17a_여신잔액] DEFAULT ((0)), [ye_date] [smalldatetime] NOT NULL CONSTRAINT [DF_k17a_ye_date] DEFAULT (getdate()), [d17_부가세구분] [char](10) NOT NULL CONSTRAINT [DF_k17a_d17_부가세구분] DEFAULT (''), [d17_pri1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k17a_d17_pri1] DEFAULT ((0)), [타설부위] [char](30) NOT NULL CONSTRAINT [DF_k17a_타설부위] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms110] 스크립트 날짜: 10/06/2014 11:02:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms110]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms110_d11_code] DEFAULT (' '), [d11_cname] [char](50) NOT NULL CONSTRAINT [DF_ksms110_d11_cname] DEFAULT (' '), [d11_tel] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_tel] DEFAULT (' '), [d11_name] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_name] DEFAULT (' '), [d11_cmcase] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_cmcase] DEFAULT ((0)), [d11_cmposi] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_cmposition] DEFAULT ((0)), [d11_ename] [char](50) NOT NULL CONSTRAINT [DF_ksms110_d11_ename] DEFAULT (''), [d11_법인상호] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_법인상호] DEFAULT (''), [d11_시공구분] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_시공구분] DEFAULT (''), [d11_거래처담당자] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_거래처담당자] DEFAULT (''), [d11_거래처담당자직급] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_거래처담당자직급] DEFAULT (''), [d11_회계거래처코드] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_회계거래처코드] DEFAULT (''), [d11_최근동향] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_최근동향] DEFAULT (''), [d11_매입처코드] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_매입처코드] DEFAULT (''), [d11_매입처명] [char](50) NOT NULL CONSTRAINT [DF_ksms110_d11_매입처명] DEFAULT (''), [d11_주사업장코드] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_주사업장코드] DEFAULT (''), [d11_주사업장명] [char](50) NOT NULL CONSTRAINT [DF_ksms110_d11_주사업장명] DEFAULT (''), [d11_주사업장사용여부] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_주사업장사용여부] DEFAULT (''), [d11_현금비율] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_현금비율] DEFAULT ((0)), [d11_수금기일] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms110_d11_수금기일] DEFAULT (getdate()), [d11_부가세구분] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_부가세구분] DEFAULT (''), [d11_창립일] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms110_d11_창립일] DEFAULT (getdate()), [d11_관리번호] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_관리번호] DEFAULT (''), [d11_cno] [char](15) NOT NULL CONSTRAINT [DF_ksms110_d11_cno] DEFAULT (' '), [d11_jmno] [char](14) NOT NULL CONSTRAINT [DF_ksms110_d11_jmno] DEFAULT (' '), [d11_uptae] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_uptae] DEFAULT (' '), [d11_jong] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_jong] DEFAULT (' '), [d11_addr] [char](100) NOT NULL CONSTRAINT [DF_ksms110_d11_addr] DEFAULT (' '), [d11_post] [char](7) NOT NULL CONSTRAINT [DF_ksms110_d11_post] DEFAULT (' '), [d11_cgubun] [char](1) NOT NULL CONSTRAINT [DF_ksms110_d11_cgubun] DEFAULT (' '), [d11_remk] [char](60) NOT NULL CONSTRAINT [DF_ksms110_d11_remk] DEFAULT (' '), [old] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms110_old] DEFAULT ((0)), [d11_fax] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_fax_1] DEFAULT (''), [remk] [char](60) NOT NULL CONSTRAINT [DF_ksms110_remk] DEFAULT (' '), [d11_hp] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_hp] DEFAULT (' '), [y11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms110_y11_cname] DEFAULT (' '), [y11_name] [char](10) NOT NULL CONSTRAINT [DF_ksms110_y11_name] DEFAULT (' '), [y11_jmno] [char](14) NOT NULL CONSTRAINT [DF_ksms110_y11_jmno] DEFAULT (' '), [y11_cno] [char](12) NOT NULL CONSTRAINT [DF_ksms110_y11_cno] DEFAULT (' '), [y11_post] [char](7) NOT NULL CONSTRAINT [DF_ksms110_y11_post_1] DEFAULT (''), [y11_addr] [char](50) NOT NULL CONSTRAINT [DF_ksms110_y11_addr] DEFAULT (' '), [y11_tel] [char](30) NOT NULL CONSTRAINT [DF_ksms110_y11_tel] DEFAULT (' '), [y11_uptae] [char](20) NOT NULL CONSTRAINT [DF_ksms110_y11_uptae] DEFAULT (' '), [y11_jong] [char](20) NOT NULL CONSTRAINT [DF_ksms110_y11_jong] DEFAULT (' '), [y11_suryu] [char](40) NOT NULL CONSTRAINT [DF_ksms110_y11_suryu] DEFAULT (' '), [y11_fax] [char](20) NOT NULL CONSTRAINT [DF_ksms110_y11_fax] DEFAULT (' '), [y11_hp] [char](20) NOT NULL CONSTRAINT [DF_ksms110_y11_hp] DEFAULT (' '), [d11_여신액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_여신액] DEFAULT ((0)), [d11_BillRemk] [char](60) NOT NULL CONSTRAINT [DF_ksms110_d11_BillRemk] DEFAULT (' '), [d11_sdate] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms110_d11_sdate] DEFAULT (getdate()), [d11_email] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_email] DEFAULT (''), [d11_email1] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_email1] DEFAULT (''), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms110_d15_code] DEFAULT (''), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d15_name] DEFAULT (''), [d11_mgcode] [char](1) NOT NULL CONSTRAINT [DF_ksms110_d11_mgcode] DEFAULT (''), [d11_거래구분] [char](10) NOT NULL CONSTRAINT [DF_ksms110_d11_거래구분] DEFAULT (''), [d11_공급구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_공급구분] DEFAULT ((0)), [d11_단가코드] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_단가계정코드] DEFAULT ((0)), [d11_절사구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_절사구분] DEFAULT ((0)), [d11_부과구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms110_d11_부과세구분] DEFAULT ((0)), [d11_결재조건] [char](30) NOT NULL CONSTRAINT [DF_ksms110_d11_결재조건] DEFAULT (''), [d11_수신자명] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_메시지수신자명] DEFAULT (''), [d11_수신주소] [char](40) NOT NULL CONSTRAINT [DF_ksms110_d11_메시지수신자주소] DEFAULT (''), [d11_발신주소] [char](40) NOT NULL CONSTRAINT [DF_ksms110_d11_메시지발신자주소] DEFAULT (''), [d11_거래부서] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_거래처부서] DEFAULT (''), [d11_거래처담당] [char](20) NOT NULL CONSTRAINT [DF_ksms110_d11_거래처담당자연락처] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[급여_0000] 스크립트 날짜: 10/06/2014 10:59:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[급여_0000]( [d13_date] [datetime] NOT NULL, [d13_code] [char](4) NOT NULL, [d13_name] [char](10) NOT NULL, [gu] [char](1) NOT NULL, [식대지원] [numeric](6, 0) NOT NULL, [수량1] [numeric](3, 0) NOT NULL, [식대1] [numeric](6, 0) NOT NULL, [수량2] [numeric](3, 0) NOT NULL, [식대2] [numeric](6, 0) NOT NULL, [수량3] [numeric](3, 0) NOT NULL, [식대3] [numeric](6, 0) NOT NULL, [기본급] [numeric](7, 0) NOT NULL, [근속년수] [numeric](2, 0) NOT NULL, [근속수당] [numeric](6, 0) NOT NULL, [상여금] [numeric](6, 0) NOT NULL, [경비] [numeric](6, 0) NOT NULL, [공제계] [numeric](6, 0) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[회전_0000] 스크립트 날짜: 10/06/2014 11:00:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[회전_0000]( [d13_date] [datetime] NOT NULL CONSTRAINT [DF_회전_0000_d13_date] DEFAULT (getdate()), [d13_code] [char](4) NOT NULL CONSTRAINT [DF_회전_0000_d13_code] DEFAULT (''), [d13_name] [char](10) NOT NULL CONSTRAINT [DF_회전_0000_d13_name] DEFAULT (''), [gu] [char](1) NOT NULL CONSTRAINT [DF_회전_0000_gu] DEFAULT (''), [현장지원] [numeric](2, 0) NOT NULL CONSTRAINT [DF_회전_0000_현장지원] DEFAULT ((0)), [예비지원] [numeric](2, 0) NOT NULL CONSTRAINT [DF_회전_0000_예비지원] DEFAULT ((0)), [d13_code1] [char](4) NOT NULL CONSTRAINT [DF_회전_0000_d13_code1] DEFAULT (''), [ger] [char](6) NOT NULL CONSTRAINT [DF_회전_0000_ger] DEFAULT (''), [hyn] [char](4) NOT NULL CONSTRAINT [DF_회전_0000_hyn] DEFAULT (''), [대기시간] [char](5) NOT NULL CONSTRAINT [DF_회전_0000_대기시간] DEFAULT (''), [대기수당] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_대기수당] DEFAULT ((0)), [조시간] [char](5) NOT NULL CONSTRAINT [DF_회전_0000_조시간] DEFAULT (''), [조수당] [numeric](7, 0) NOT NULL CONSTRAINT [DF_회전_0000_조수당] DEFAULT ((0)), [결근] [numeric](2, 0) NOT NULL CONSTRAINT [DF_회전_0000_결근] DEFAULT ((0)), [조퇴] [numeric](2, 0) NOT NULL CONSTRAINT [DF_회전_0000_조퇴] DEFAULT ((0)), [지각] [numeric](2, 0) NOT NULL CONSTRAINT [DF_회전_0000_지각] DEFAULT ((0)), [통행수량1] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량1] DEFAULT ((0)), [통행금액1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액1] DEFAULT ((0)), [통행수량2] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량2] DEFAULT ((0)), [통행금액2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액2] DEFAULT ((0)), [통행수량3] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량3] DEFAULT ((0)), [통행금액3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액3] DEFAULT ((0)), [통행수량4] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량4] DEFAULT ((0)), [통행금액4] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액4] DEFAULT ((0)), [통행수량5] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량5] DEFAULT ((0)), [통행금액5] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액5] DEFAULT ((0)), [통행수량6] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량6] DEFAULT ((0)), [통행금액6] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액6] DEFAULT ((0)), [통행수량7] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량7] DEFAULT ((0)), [통행금액7] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액7] DEFAULT ((0)), [통행수량8] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량8] DEFAULT ((0)), [통행금액8] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액8] DEFAULT ((0)), [통행수량9] [numeric](3, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행수량9] DEFAULT ((0)), [통행금액9] [numeric](6, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액9] DEFAULT ((0)), [통행금액] [numeric](8, 0) NOT NULL CONSTRAINT [DF_회전_0000_통행금액] DEFAULT ((0)), [유류] [numeric](7, 0) NOT NULL CONSTRAINT [DF_회전_0000_유류] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[goan] 스크립트 날짜: 10/06/2014 11:01:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[goan]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_goan_d11_code] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_goan_d16_code] DEFAULT (' '), [d31_no] [char](2) NOT NULL CONSTRAINT [DF_goan_d31_no] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code] DEFAULT (' '), [day1] [datetime] NOT NULL CONSTRAINT [DF_goan_day1] DEFAULT (getdate()), [day2] [datetime] NULL, [day3] [datetime] NULL, [day4] [datetime] NULL, [day5] [char](4) NOT NULL CONSTRAINT [DF_goan_day5] DEFAULT (' '), [no1] [char](21) NOT NULL CONSTRAINT [DF_goan_no1] DEFAULT (' '), [no2] [char](21) NOT NULL CONSTRAINT [DF_goan_no2] DEFAULT (' '), [no3] [char](21) NOT NULL CONSTRAINT [DF_goan_no3] DEFAULT (' '), [no4] [char](25) NOT NULL CONSTRAINT [DF_goan_no4] DEFAULT (' '), [no5] [char](21) NOT NULL CONSTRAINT [DF_goan_no5] DEFAULT (' '), [pri1] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri1] DEFAULT ((0)), [pri2] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri2] DEFAULT ((0)), [pri3] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri3] DEFAULT ((0)), [pri4] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri4] DEFAULT ((0)), [pri5] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri5] DEFAULT ((0)), [pri6] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri6] DEFAULT ((0)), [pri7] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri7] DEFAULT ((0)), [pri8] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_pri8] DEFAULT ((0)), [d31_date] [datetime] NULL, [d14_code1] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code1] DEFAULT (' '), [g_jqty1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty1] DEFAULT ((0)), [g_cqty1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty1] DEFAULT ((0)), [g_gqty1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty1] DEFAULT ((0)), [g_pri1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri1] DEFAULT ((0)), [g_amt1] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt1] DEFAULT ((0)), [g_tqty1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty1] DEFAULT ((0)), [d14_code2] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code2] DEFAULT (' '), [g_jqty2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty2] DEFAULT ((0)), [g_cqty2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty2] DEFAULT ((0)), [g_gqty2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty2] DEFAULT ((0)), [g_pri2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri2] DEFAULT ((0)), [g_amt2] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt2] DEFAULT ((0)), [g_tqty2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty2] DEFAULT ((0)), [d14_code3] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code3] DEFAULT (' '), [g_jqty3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty3] DEFAULT ((0)), [g_cqty3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty3] DEFAULT ((0)), [g_gqty3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty3] DEFAULT ((0)), [g_pri3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri3] DEFAULT ((0)), [g_amt3] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt3] DEFAULT ((0)), [g_tqty3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty3] DEFAULT ((0)), [d14_code4] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code4] DEFAULT (' '), [g_jqty4] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty4] DEFAULT ((0)), [g_cqty4] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty4] DEFAULT ((0)), [g_gqty4] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty4] DEFAULT ((0)), [g_pri4] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri4] DEFAULT ((0)), [g_amt4] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt4] DEFAULT ((0)), [g_tqty4] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty4] DEFAULT ((0)), [d14_code5] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code5] DEFAULT (' '), [g_jqty5] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty5] DEFAULT ((0)), [g_cqty5] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty5] DEFAULT ((0)), [g_gqty5] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty5] DEFAULT ((0)), [g_pri5] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri5] DEFAULT ((0)), [g_amt5] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt5] DEFAULT ((0)), [g_tqty5] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty5] DEFAULT ((0)), [d14_code6] [char](4) NOT NULL CONSTRAINT [DF_goan_d14_code6] DEFAULT (' '), [g_jqty6] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_jqty6] DEFAULT ((0)), [g_cqty6] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_cqty6] DEFAULT ((0)), [g_gqty6] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_gqty6] DEFAULT ((0)), [g_pri6] [numeric](6, 0) NOT NULL CONSTRAINT [DF_goan_g_pri6] DEFAULT ((0)), [g_amt6] [numeric](10, 0) NOT NULL CONSTRAINT [DF_goan_g_amt6] DEFAULT ((0)), [g_tqty6] [numeric](8, 2) NOT NULL CONSTRAINT [DF_goan_g_tqty6] DEFAULT ((0)), [g_wdate] [char](2) NOT NULL CONSTRAINT [DF_goan_g_wdate] DEFAULT (' '), [prip] [numeric](3, 1) NOT NULL CONSTRAINT [DF_goan_prip] DEFAULT ((0)), CONSTRAINT [PK_goan] PRIMARY KEY CLUSTERED ( [d11_code] ASC, [d16_code] ASC, [d31_no] ASC, [day1] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms562] 스크립트 날짜: 10/06/2014 11:06:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms562]( [d31_date] [datetime] NOT NULL CONSTRAINT [DF_ksms562_d31_date] DEFAULT (getdate()), [d31_mgcode] [char](1) NOT NULL CONSTRAINT [DF_ksms562_d31_mgcode] DEFAULT (' '), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms562_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms562_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms562_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms562_d16_cname] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms562_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_ksms562_d14_name] DEFAULT (' '), [d31_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms562_d31_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms562_d15_code] DEFAULT (' '), [d15_name] [char](12) NOT NULL CONSTRAINT [DF_ksms562_d15_name] DEFAULT (' '), [d31_name] [char](9) NOT NULL CONSTRAINT [DF_ksms562_d31_name] DEFAULT (' '), [d31_code] [char](1) NOT NULL CONSTRAINT [DF_ksms562_d31_code] DEFAULT (' '), [d31_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_qty] DEFAULT ((0)), [d31_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_pri] DEFAULT ((0)), [d31_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_amt] DEFAULT ((0)), [d31_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_vat] DEFAULT ((0)), [d31_h_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_h_qty] DEFAULT ((0)), [d31_h_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h_pri] DEFAULT ((0)), [d31_h_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h_amt] DEFAULT ((0)), [d31_h_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h_vat] DEFAULT ((0)), [d31_h1_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_h1_qty] DEFAULT ((0)), [d31_h1_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h1_pri] DEFAULT ((0)), [d31_h1_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h1_amt] DEFAULT ((0)), [d31_h1_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h1_vat] DEFAULT ((0)), [d31_h2_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_h2_qty] DEFAULT ((0)), [d31_h2_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h2_pri] DEFAULT ((0)), [d31_h2_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h2_amt] DEFAULT ((0)), [d31_h2_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_d31_h2_vat] DEFAULT ((0)), [d31_chgb] [char](1) NOT NULL CONSTRAINT [DF_ksms562_d31_chgb] DEFAULT (' '), [d32_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms562_d32_qty] DEFAULT ((0)), [d32_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d32_amt] DEFAULT ((0)), [d32_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_d32_vat] DEFAULT ((0)), [d32_dc] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_d32_dc] DEFAULT ((0)), [dcj_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms562_dcj_qty] DEFAULT ((0)), [dcj_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms562_dcj_amt] DEFAULT ((0)), [dcj_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms562_dcj_vat] DEFAULT ((0)), [d31_remk] [char](20) NOT NULL CONSTRAINT [DF_ksms562_d31_remk] DEFAULT (' '), [d31_totout] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_totout] DEFAULT ((0)), [d31_totgum] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms562_d31_totgum] DEFAULT ((0)), [d17_priper] [numeric](5, 1) NOT NULL CONSTRAINT [DF_ksms562_d17_priper] DEFAULT ((0)), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_ksms562_d17_jogun] DEFAULT (' '), [d52_si] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms562_d52_si] DEFAULT ((0)), [d52_yo] [char](4) NOT NULL CONSTRAINT [DF_ksms562_d52_yo] DEFAULT ((0)), [seri] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms562_seri] DEFAULT ((0)), [sujun] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms562_sujun] DEFAULT ((0)), [balhaeng] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms562_balhaeng] DEFAULT ((0)), [bal_date] [datetime] NOT NULL CONSTRAINT [DF_ksms562_bal_date] DEFAULT (getdate()) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms320] 스크립트 날짜: 10/06/2014 11:05:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms320]( [d32_date] [datetime] NOT NULL CONSTRAINT [DF_ksms320_d32_date] DEFAULT (getdate()), [법인코드] [char](3) NOT NULL CONSTRAINT [DF_ksms320_법인코드] DEFAULT (' '), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_ksms320_공장코드] DEFAULT (' '), [d11_code] [char](10) NOT NULL CONSTRAINT [DF_ksms320_d11_code] DEFAULT (' '), [d11_cname] [char](50) NOT NULL CONSTRAINT [DF_ksms320_d11_cname] DEFAULT (' '), [d16_code] [char](10) NOT NULL CONSTRAINT [DF_ksms320_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms320_d16_cname] DEFAULT (' '), [매출코드] [char](6) NOT NULL CONSTRAINT [DF_ksms320_매출코드] DEFAULT (' '), [매입코드] [char](6) NOT NULL CONSTRAINT [DF_ksms320_매입코드] DEFAULT (' '), [은행코드] [char](4) NOT NULL CONSTRAINT [DF_ksms320_은행코드] DEFAULT (' '), [d32_si] [char](1) NOT NULL CONSTRAINT [DF_ksms320_d32_si] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms320_d14_code] DEFAULT (' '), [d14_name] [char](13) NOT NULL CONSTRAINT [DF_ksms320_d14_name] DEFAULT (' '), [d32_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms320_d32_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms320_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms320_d15_name] DEFAULT (' '), [d32_code] [char](1) NOT NULL CONSTRAINT [DF_ksms320_d32_code] DEFAULT (' '), [d32_name] [char](9) NOT NULL CONSTRAINT [DF_ksms320_d32_name] DEFAULT (' '), [d32_cgubun] [char](1) NOT NULL CONSTRAINT [DF_ksms320_d32_cgubun] DEFAULT (' '), [d32_total] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms320_d32_total] DEFAULT ((0)), [d32_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms320_d32_qty] DEFAULT ((0)), [d32_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms320_d32_pri] DEFAULT ((0)), [d32_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms320_d32_amt] DEFAULT ((0)), [d32_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms320_d32_vat] DEFAULT ((0)), [d31_date] [datetime] NOT NULL CONSTRAINT [DF_ksms320_d31_date] DEFAULT (getdate()), [d31_dc] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms320_d31_dc] DEFAULT ((0)), [d31_15code] [char](3) NOT NULL CONSTRAINT [DF_ksms320_d31_15code] DEFAULT (' '), [d31_15name] [char](10) NOT NULL CONSTRAINT [DF_ksms320_d31_15name] DEFAULT (' '), [d32_b_wday] [datetime] NOT NULL CONSTRAINT [DF_ksms320_d32_b_wday] DEFAULT (getdate()), [d32_b_oday] [datetime] NOT NULL CONSTRAINT [DF_ksms320_d32_b_oday] DEFAULT (getdate()), [d32_b_no] [varchar](30) NOT NULL CONSTRAINT [DF_ksms320_d32_b_no] DEFAULT (' '), [d32_b_writ] [varchar](50) NOT NULL CONSTRAINT [DF_ksms320_d32_b_writ] DEFAULT (' '), [d32_b_posi] [char](20) NOT NULL CONSTRAINT [DF_ksms320_d32_b_posi] DEFAULT (' '), [d32_remk] [varchar](50) NOT NULL CONSTRAINT [DF_ksms320_d32_remk] DEFAULT (' '), [subtotal] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms320_subtotal] DEFAULT ((0)), [bigo1] [varchar](50) NOT NULL CONSTRAINT [DF_ksms320_bigo1] DEFAULT (' '), [order_no] [char](10) NOT NULL CONSTRAINT [DF_ksms320_order_no] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms140] 스크립트 날짜: 10/06/2014 11:02:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms140]( [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms140_d14_code] DEFAULT (' '), [d14_name] [char](14) NOT NULL CONSTRAINT [DF_ksms140_d14_name] DEFAULT (' '), [s_date] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms140_s_date] DEFAULT (getdate()), [e_date] [smalldatetime] NOT NULL CONSTRAINT [DF_ksms140_e_date] DEFAULT (getdate()), [honhwa] [char](16) NOT NULL CONSTRAINT [DF_ksms140_honhwa] DEFAULT (' '), [d14_minsu0] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_minsu0] DEFAULT ((0)), [d14_minsu1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_minsu1] DEFAULT ((0)), [d14_minsu2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_minsu2] DEFAULT ((0)), [d14_minsu3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_minsu3] DEFAULT ((0)), [d14_sang0] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_sang0] DEFAULT ((0)), [d14_sang1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_sang1] DEFAULT ((0)), [d14_sang2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_sang2] DEFAULT ((0)), [d14_sang3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_sang3] DEFAULT ((0)), [d14_imga0] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imga0] DEFAULT ((0)), [d14_imga1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imga1] DEFAULT ((0)), [d14_imga2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imga2] DEFAULT ((0)), [d14_imga3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imga3] DEFAULT ((0)), [d14_imsan0] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imsan0] DEFAULT ((0)), [d14_imsan1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imsan1] DEFAULT ((0)), [d14_imsan2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imsan2] DEFAULT ((0)), [d14_imsan3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_imsan3] DEFAULT ((0)), [d14_goan0] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_goan0] DEFAULT ((0)), [d14_goan1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_goan1] DEFAULT ((0)), [d14_goan2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_goan2] DEFAULT ((0)), [d14_goan3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_goan3] DEFAULT ((0)), [관리코드] [nchar](10) NOT NULL CONSTRAINT [DF_ksms140_관리코드] DEFAULT (''), [현장구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_현장구분] DEFAULT ((0)), [믹서구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_믹서구분] DEFAULT ((0)), [혼화제] [char](2) NOT NULL CONSTRAINT [DF_ksms140_혼화제] DEFAULT (''), [ks구분] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_ks구분] DEFAULT ((0)), [g1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_g1] DEFAULT ((0)), [g2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_g2] DEFAULT ((0)), [g3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_g3] DEFAULT ((0)), [g4] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_g4] DEFAULT ((0)), [s1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_s1] DEFAULT ((0)), [s2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_s2] DEFAULT ((0)), [c1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms140_c1] DEFAULT ((0)), [c2] [numeric](6, 1) NOT NULL CONSTRAINT [DF_ksms140_c2] DEFAULT ((0)), [c3] [numeric](6, 1) NOT NULL CONSTRAINT [DF_ksms140_c3] DEFAULT ((0)), [c4] [numeric](6, 1) NOT NULL CONSTRAINT [DF_ksms140_c4] DEFAULT ((0)), [w1] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_water1] DEFAULT ((0)), [w2] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_water2] DEFAULT ((0)), [w3] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_w3] DEFAULT ((0)), [ad1] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad1] DEFAULT ((0)), [ad2] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad2] DEFAULT ((0)), [ad3] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad3] DEFAULT ((0)), [ad4] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad4] DEFAULT ((0)), [ad5] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad5] DEFAULT ((0)), [ad6] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad6] DEFAULT ((0)), [ad7] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad7] DEFAULT ((0)), [ad8] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ksms140_ad8] DEFAULT ((0)), [pp] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms140_pp] DEFAULT ((0)), [비고1] [char](50) NOT NULL CONSTRAINT [DF_ksms140_비고1] DEFAULT (''), [비고2] [char](50) NOT NULL CONSTRAINT [DF_ksms140_비고2] DEFAULT (''), [염화물] [char](5) NOT NULL CONSTRAINT [DF_ksms140_염화물] DEFAULT (''), [공기량1] [char](5) NOT NULL CONSTRAINT [DF_ksms140_공기량1] DEFAULT (''), [공기량2] [char](5) NOT NULL CONSTRAINT [DF_ksms140_공기량2] DEFAULT (''), [시멘트종류] [char](50) NOT NULL CONSTRAINT [DF_ksms140_시멘트종류] DEFAULT (''), [저열] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms140_저열] DEFAULT ((0)), [d14_bunno] [numeric](5, 0) NOT NULL CONSTRAINT [DF_ksms140_d14_bunno] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[gnp] 스크립트 날짜: 10/06/2014 11:00:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[gnp]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_gnp_d11_code] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_gnp_d16_code] DEFAULT (' '), [bal_date] [datetime] NOT NULL CONSTRAINT [DF_gnp_bal_date] DEFAULT (getdate()), [d31_no] [char](2) NOT NULL CONSTRAINT [DF_gnp_d31_no] DEFAULT (' '), [d31_sno] [char](4) NOT NULL CONSTRAINT [DF_gnp_d31_sno] DEFAULT (' '), [g_no1] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no1] DEFAULT (' '), [g_code1] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code1] DEFAULT (' '), [g_name1] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name1] DEFAULT (' '), [g_gqty1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty1] DEFAULT ((0)), [g_pri1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri1] DEFAULT ((0)), [g_amt1] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt1] DEFAULT ((0)), [g_no2] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no2] DEFAULT (' '), [g_code2] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code2] DEFAULT (' '), [g_name2] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name2] DEFAULT (' '), [g_gqty2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty2] DEFAULT ((0)), [g_pri2] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri2] DEFAULT ((0)), [g_amt2] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt2] DEFAULT ((0)), [g_no3] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no3] DEFAULT (' '), [g_code3] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code3] DEFAULT (' '), [g_name3] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name3] DEFAULT (' '), [g_gqty3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty3] DEFAULT ((0)), [g_pri3] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri3] DEFAULT ((0)), [g_amt3] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt3] DEFAULT ((0)), [g_no4] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no4] DEFAULT (' '), [g_code4] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code4] DEFAULT (' '), [g_name4] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name4] DEFAULT (' '), [g_gqty4] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty4] DEFAULT ((0)), [g_pri4] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri4] DEFAULT ((0)), [g_amt4] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt4] DEFAULT ((0)), [g_no5] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no5] DEFAULT (' '), [g_code5] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code5] DEFAULT (' '), [g_name5] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name5] DEFAULT (' '), [g_gqty5] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty5] DEFAULT ((0)), [g_pri5] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri5] DEFAULT ((0)), [g_amt5] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt5] DEFAULT ((0)), [g_no6] [char](1) NOT NULL CONSTRAINT [DF_gnp_g_no6] DEFAULT (' '), [g_code6] [char](10) NOT NULL CONSTRAINT [DF_gnp_g_code6] DEFAULT (' '), [g_name6] [char](9) NOT NULL CONSTRAINT [DF_gnp_g_name6] DEFAULT (' '), [g_gqty6] [numeric](8, 2) NOT NULL CONSTRAINT [DF_gnp_g_gqty6] DEFAULT ((0)), [g_pri6] [numeric](6, 0) NOT NULL CONSTRAINT [DF_gnp_g_pri6] DEFAULT ((0)), [g_amt6] [numeric](10, 0) NOT NULL CONSTRAINT [DF_gnp_g_amt6] DEFAULT ((0)), CONSTRAINT [PK_gnp] PRIMARY KEY CLUSTERED ( [d11_code] ASC, [d16_code] ASC, [bal_date] ASC, [d31_no] ASC, [d31_sno] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms9999] 스크립트 날짜: 10/06/2014 11:06:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms9999]( [tablename] [varchar](15) NOT NULL, [fshow] [int] NOT NULL, [No] [int] NOT NULL, [fname] [varchar](50) NOT NULL, [sname] [nvarchar](50) NOT NULL, [flangth] [int] NOT NULL, [fedit] [int] NOT NULL, [remark] [nvarchar](max) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms120] 스크립트 날짜: 10/06/2014 11:02:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms120]( [d12_code] [char](3) NOT NULL CONSTRAINT [DF_ksms120_d12_code] DEFAULT (' '), [d12_name] [char](10) NOT NULL CONSTRAINT [DF_ksms120_d12_name] DEFAULT (' '), [d12_swno] [char](6) NOT NULL CONSTRAINT [DF_ksms120_d12_swno] DEFAULT (' '), [d12_remk] [char](20) NOT NULL CONSTRAINT [DF_ksms120_d12_remk] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms130] 스크립트 날짜: 10/06/2014 11:02:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms130]( [d13_code] [char](4) NOT NULL CONSTRAINT [DF_ksms130_d13_code] DEFAULT (' '), [d13_name] [char](20) NOT NULL CONSTRAINT [DF_ksms130_d13_name] DEFAULT (' '), [d13_carno] [char](12) NOT NULL CONSTRAINT [DF_ksms130_d13_carno] DEFAULT (' '), [d13_carday] [char](2) NOT NULL CONSTRAINT [DF_ksms130_d13_carday] DEFAULT (' '), [d13_machin] [char](20) NOT NULL CONSTRAINT [DF_ksms130_d13_machin] DEFAULT (' '), [d13_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms130_d13_gubun] DEFAULT (' '), [d13_amt] [numeric](7, 0) NOT NULL CONSTRAINT [DF_ksms130_d13_amt] DEFAULT ((0)), [d12_code] [char](3) NOT NULL CONSTRAINT [DF_ksms130_d12_code] DEFAULT (' '), [d12_name] [char](10) NOT NULL CONSTRAINT [DF_ksms130_d12_name] DEFAULT (' '), [d13_remk] [char](30) NOT NULL CONSTRAINT [DF_ksms130_d13_remk] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms150] 스크립트 날짜: 10/06/2014 11:02:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms150]( [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms150_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms150_d15_name] DEFAULT (' '), [d15_swno] [char](6) NOT NULL CONSTRAINT [DF_ksms150_d15_swno] DEFAULT (' '), [d15_remk] [char](20) NOT NULL CONSTRAINT [DF_ksms150_d15_remk] DEFAULT (' '), [d15_직위] [char](10) NULL CONSTRAINT [DF_ksms150_d15_직위] DEFAULT (' '), [d15_부서명] [char](10) NULL CONSTRAINT [DF_ksms150_d15_부서명] DEFAULT (' '), [d15_사업장코드] [char](10) NULL CONSTRAINT [DF_ksms150_d15_사업장코드] DEFAULT (' '), [d15_사업장명] [char](50) NULL CONSTRAINT [DF_ksms150_d15_사업장명] DEFAULT (' '), [d15_전화번호] [char](20) NULL CONSTRAINT [DF_ksms150_d15_전화번호] DEFAULT (' '), [d15_등록일] [smalldatetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms0000] 스크립트 날짜: 10/06/2014 11:01:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms0000]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_ksms0000_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_ksms0000_공장코드] DEFAULT (''), [d11_code] [char](10) NOT NULL CONSTRAINT [DF_ksms0000_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms0000_d11_cname] DEFAULT (' '), [d16_code] [char](10) NOT NULL CONSTRAINT [DF_ksms0000_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms0000_d16_cname] DEFAULT (' '), [d_amt000] [numeric](15, 0) NOT NULL CONSTRAINT [DF_ksms0000_d_amt000] DEFAULT ((0)), [d_qty000] [numeric](10, 10) NOT NULL CONSTRAINT [DF_ksms0000_d_qty000] DEFAULT ((0)), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms0000_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms0000_d15_name] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms0000_d14_code] DEFAULT (''), [d14_name] [char](14) NOT NULL CONSTRAINT [DF_ksms0000_d14_name] DEFAULT (''), [hon] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms0000_hon] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms491] 스크립트 날짜: 10/06/2014 11:05:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms491]( [bno] [char](9) NOT NULL CONSTRAINT [DF_ksms491_bno] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms550] 스크립트 날짜: 10/06/2014 11:05:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ksms550]( [qty1] [float] NOT NULL CONSTRAINT [DF_ksms550_qty1] DEFAULT ((0)), [amt1] [float] NOT NULL CONSTRAINT [DF_ksms550_amt1] DEFAULT ((0)), [vat1] [float] NOT NULL CONSTRAINT [DF_ksms550_vat1] DEFAULT ((0)) ) ON [PRIMARY] GO /****** 개체: Table [dbo].[sysuser] 스크립트 날짜: 10/06/2014 11:06:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[sysuser]( [U_ID] [nchar](10) NOT NULL CONSTRAINT [DF_sysuser_U_ID] DEFAULT (''), [u_saupno] [char](12) NOT NULL CONSTRAINT [DF_sysuser_u_saupno] DEFAULT (' '), [u_company] [char](30) NOT NULL CONSTRAINT [DF_sysuser_u_company] DEFAULT (' '), [u_presidnt] [char](20) NOT NULL CONSTRAINT [DF_sysuser_u_presidnt] DEFAULT (' '), [u_compaddr] [char](40) NOT NULL CONSTRAINT [DF_sysuser_u_compaddr] DEFAULT (' '), [u_uptae] [char](20) NOT NULL CONSTRAINT [DF_sysuser_u_uptae] DEFAULT (' '), [u_jong] [char](20) NOT NULL CONSTRAINT [DF_sysuser_u_jong] DEFAULT (' '), [u_tele] [char](14) NOT NULL CONSTRAINT [DF_sysuser_u_tel] DEFAULT (' '), [id] [char](30) NOT NULL CONSTRAINT [DF_sysuser_id] DEFAULT (''), [pass] [char](30) NOT NULL CONSTRAINT [DF_sysuser_pass] DEFAULT (''), [이메일] [char](40) NOT NULL CONSTRAINT [DF_sysuser_이메일] DEFAULT (''), [zipcode] [char](10) NOT NULL CONSTRAINT [DF_sysuser_zipcode] DEFAULT (''), [담당자] [char](20) NOT NULL CONSTRAINT [DF_sysuser_담당자] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[통장관리] 스크립트 날짜: 10/06/2014 11:00:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[통장관리]( [은행코드] [char](4) NOT NULL CONSTRAINT [DF_통장관리_은행코드] DEFAULT (' '), [은행명] [char](20) NOT NULL CONSTRAINT [DF_통장관리_은행명] DEFAULT (' '), [구좌번호] [char](20) NOT NULL CONSTRAINT [DF_통장관리_구좌번호] DEFAULT (' '), [비고] [char](30) NOT NULL CONSTRAINT [DF_통장관리_비고] DEFAULT (' '), [회계전송코드] [nchar](20) NOT NULL CONSTRAINT [DF_통장관리_회계전송코드] DEFAULT (''), CONSTRAINT [PK_통장관리] PRIMARY KEY CLUSTERED ( [은행코드] ASC, [은행명] ASC, [구좌번호] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[car_amt0] 스크립트 날짜: 10/06/2014 11:00:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[car_amt0]( [cdate] [datetime] NOT NULL CONSTRAINT [DF_car_amt0_cdate] DEFAULT (getdate()), [cno] [char](4) NOT NULL CONSTRAINT [DF_car_amt0_cno] DEFAULT (''), [name] [char](8) NOT NULL CONSTRAINT [DF_car_amt0_name] DEFAULT (''), [amt] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_amt] DEFAULT ((0)), [vat] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_vat] DEFAULT ((0)), [gu_tot] [numeric](7, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_tot] DEFAULT ((0)), [gu_01] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_01] DEFAULT ((0)), [gu_02] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_02] DEFAULT ((0)), [gu_03] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_03] DEFAULT ((0)), [gu_04] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_04] DEFAULT ((0)), [gu_05] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_gu_05] DEFAULT ((0)), [bu_01] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_bu_01] DEFAULT ((0)), [bu_02] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_bu_02] DEFAULT ((0)), [bu_03] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_bu_03] DEFAULT ((0)), [bu_04] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_bu_04] DEFAULT ((0)), [bu_05] [numeric](6, 1) NOT NULL CONSTRAINT [DF_car_amt0_bu_05] DEFAULT ((0)), [gamt_01] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_gamt_01] DEFAULT ((0)), [gamt_02] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_gamt_02] DEFAULT ((0)), [gamt_03] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_gamt_03] DEFAULT ((0)), [gamt_04] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_gamt_04] DEFAULT ((0)), [gamt_05] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_gamt_05] DEFAULT ((0)), [bamt_01] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_bamt_01] DEFAULT ((0)), [bamt_02] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_bamt_02] DEFAULT ((0)), [bamt_03] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_bamt_03] DEFAULT ((0)), [bamt_04] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_bamt_04] DEFAULT ((0)), [bamt_05] [numeric](8, 0) NOT NULL CONSTRAINT [DF_car_amt0_bamt_05] DEFAULT ((0)), [ho_01] [numeric](4, 0) NOT NULL CONSTRAINT [DF_car_amt0_ho_01] DEFAULT ((0)), [ho_02] [numeric](4, 0) NOT NULL CONSTRAINT [DF_car_amt0_ho_02] DEFAULT ((0)), [ho_03] [numeric](4, 0) NOT NULL CONSTRAINT [DF_car_amt0_ho_03] DEFAULT ((0)), [ho_04] [numeric](4, 0) NOT NULL CONSTRAINT [DF_car_amt0_ho_04] DEFAULT ((0)), [ho_05] [numeric](4, 0) NOT NULL CONSTRAINT [DF_car_amt0_ho_05] DEFAULT ((0)), [dout_03] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_03] DEFAULT ((0)), [dout_04] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_04] DEFAULT ((0)), [dout_05] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_05] DEFAULT ((0)), [dout_06a] [numeric](2, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_06a] DEFAULT ((0)), [dout_06] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_06] DEFAULT ((0)), [dout_07a] [numeric](2, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_07a] DEFAULT ((0)), [dout_07] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_07] DEFAULT ((0)), [dout_08] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_08] DEFAULT ((0)), [dout_09] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_09] DEFAULT ((0)), [dout_10] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_10] DEFAULT ((0)), [dout_11] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_11] DEFAULT ((0)), [dout_12] [numeric](10, 0) NOT NULL CONSTRAINT [DF_car_amt0_dout_12] DEFAULT ((0)), [din_01] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_01] DEFAULT ((0)), [din_02] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_02] DEFAULT ((0)), [din_03] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_03] DEFAULT ((0)), [din_04] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_04] DEFAULT ((0)), [din_05] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_05] DEFAULT ((0)), [din_06] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_06] DEFAULT ((0)), [din_07] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_07] DEFAULT ((0)), [din_08] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_08] DEFAULT ((0)), [din_09] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_09] DEFAULT ((0)), [din_10] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_10] DEFAULT ((0)), [din_11] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_11] DEFAULT ((0)), [din_12] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_12] DEFAULT ((0)), [din_13] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_13] DEFAULT ((0)), [din_14] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_14] DEFAULT ((0)), [din_15] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_15] DEFAULT ((0)), [din_21] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_21] DEFAULT ((0)), [din_22] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_22] DEFAULT ((0)), [din_23] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_23] DEFAULT ((0)), [din_24] [numeric](9, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_24] DEFAULT ((0)), [din_tot] [numeric](10, 0) NOT NULL CONSTRAINT [DF_car_amt0_din_tot] DEFAULT ((0)), [ga_out] [numeric](10, 0) NOT NULL CONSTRAINT [DF_car_amt0_ga_out] DEFAULT ((0)), [ga_in] [numeric](10, 0) NOT NULL CONSTRAINT [DF_car_amt0_ga_in] DEFAULT ((0)), [remk] [char](50) NOT NULL CONSTRAINT [DF_car_amt0_remk] DEFAULT (''), [gubun] [char](1) NOT NULL CONSTRAINT [DF_car_amt0_gubun] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms165] 스크립트 날짜: 10/06/2014 11:04:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms165]( [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms165_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms165_d16_cname] DEFAULT (' '), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms165_d11_code] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms165_d15_code] DEFAULT (' '), [d16_15name] [char](10) NOT NULL CONSTRAINT [DF_ksms165_d16_15name] DEFAULT (' '), [d16_time] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms165_d16_time] DEFAULT ((0)), [d16_kiro] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms165_d16_kiro] DEFAULT ((0)), [d16_addr] [char](50) NOT NULL CONSTRAINT [DF_ksms165_d16_addr] DEFAULT (' '), [d16_post] [char](7) NOT NULL CONSTRAINT [DF_ksms165_d16_post] DEFAULT (' '), [d16_tele] [char](20) NOT NULL CONSTRAINT [DF_ksms165_d16_tele] DEFAULT (' '), [d16_posi] [char](30) NOT NULL CONSTRAINT [DF_ksms165_d16_posi] DEFAULT (' '), [d16_remk] [char](50) NOT NULL CONSTRAINT [DF_ksms165_d16_remk] DEFAULT (' '), [d16_g] [char](30) NOT NULL CONSTRAINT [DF_ksms165_d16_g] DEFAULT (' '), [d16_여신액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_ksms165_d16_여신액] DEFAULT ((0)), [d16_BillRemk] [char](30) NOT NULL CONSTRAINT [DF_ksms165_d16_BillRemk] DEFAULT (' '), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_ksms165_d17_jogun] DEFAULT (''), [d31_priper] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms165_d31_priper_1] DEFAULT ((0)), [d16_급지] [numeric](3, 1) NOT NULL CONSTRAINT [DF_ksms165_d16_급지] DEFAULT ((0)), [d31_code] [char](1) NOT NULL CONSTRAINT [DF_ksms165_d31_code] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms561] 스크립트 날짜: 10/06/2014 11:06:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms561]( [d31_date] [datetime] NOT NULL, [d31_mgcode] [char](1) NOT NULL CONSTRAINT [DF_ksms561_d31_mgcode] DEFAULT (' '), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms561_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms561_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms561_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms561_d16_cname] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms561_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_ksms561_d14_name] DEFAULT (' '), [d31_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms561_d31_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms561_d15_code] DEFAULT (' '), [d15_name] [char](12) NOT NULL CONSTRAINT [DF_ksms561_d15_name] DEFAULT (' '), [d31_name] [char](9) NOT NULL CONSTRAINT [DF_ksms561_d31_name] DEFAULT (' '), [d31_code] [char](1) NOT NULL CONSTRAINT [DF_ksms561_d31_code] DEFAULT (' '), [d31_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_qty] DEFAULT ((0)), [d31_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_pri] DEFAULT ((0)), [d31_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_amt] DEFAULT ((0)), [d31_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_vat] DEFAULT ((0)), [d31_h_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_h_qty] DEFAULT ((0)), [d31_h_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h_pri] DEFAULT ((0)), [d31_h_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h_amt] DEFAULT ((0)), [d31_h_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h_vat] DEFAULT ((0)), [d31_h1_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_h1_qty] DEFAULT ((0)), [d31_h1_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h1_pri] DEFAULT ((0)), [d31_h1_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h1_amt] DEFAULT ((0)), [d31_h1_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h1_vat] DEFAULT ((0)), [d31_h2_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_h2_qty] DEFAULT ((0)), [d31_h2_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h2_pri] DEFAULT ((0)), [d31_h2_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h2_amt] DEFAULT ((0)), [d31_h2_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_d31_h2_vat] DEFAULT ((0)), [d31_chgb] [char](1) NOT NULL CONSTRAINT [DF_ksms561_d31_chgb] DEFAULT (' '), [d32_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms561_d32_qty] DEFAULT ((0)), [d32_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d32_amt] DEFAULT ((0)), [d32_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_d32_vat] DEFAULT ((0)), [d32_dc] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_d32_dc] DEFAULT ((0)), [dcj_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms561_dcj_qty] DEFAULT ((0)), [dcj_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms561_dcj_amt] DEFAULT ((0)), [dcj_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms561_dcj_vat] DEFAULT ((0)), [d31_remk] [char](20) NOT NULL CONSTRAINT [DF_ksms561_d31_remk] DEFAULT (' '), [d31_totout] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_totout] DEFAULT ((0)), [d31_totgum] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms561_d31_totgum] DEFAULT ((0)), [d17_priper] [numeric](5, 1) NOT NULL CONSTRAINT [DF_ksms561_d17_priper] DEFAULT ((0)), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_ksms561_d17_jogun] DEFAULT (' '), [d52_si] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms561_d52_si] DEFAULT ((0)), [d52_yo] [char](4) NOT NULL CONSTRAINT [DF_ksms561_d52_yo] DEFAULT (' '), [seri] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms561_seri] DEFAULT ((0)), [sujun] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms561_sujun] DEFAULT ((0)), [balhaeng] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms561_balhaeng] DEFAULT ((0)), [baldate] [datetime] NOT NULL CONSTRAINT [DF_ksms561_baldate] DEFAULT (getdate()) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[post] 스크립트 날짜: 10/06/2014 11:06:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[post]( [우편번호] [char](7) NOT NULL CONSTRAINT [DF_zipcode_우편번호] DEFAULT (''), [코드] [char](12) NOT NULL CONSTRAINT [DF_zipcode_코드] DEFAULT (''), [시도] [nchar](20) NOT NULL CONSTRAINT [DF_zipcode_시도] DEFAULT (''), [시군구] [nchar](20) NOT NULL CONSTRAINT [DF_zipcode_시군구] DEFAULT (''), [읍면동] [nchar](10) NOT NULL CONSTRAINT [DF_zipcode_읍면동] DEFAULT (''), [리] [char](10) NOT NULL CONSTRAINT [DF_zipcode_리] DEFAULT (''), [길명] [nchar](10) NOT NULL CONSTRAINT [DF_zipcode_길명] DEFAULT (''), [건물] [nchar](30) NOT NULL CONSTRAINT [DF_zipcode_건물] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[k18a] 스크립트 날짜: 10/06/2014 11:01:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[k18a]( [d18_order] [char](10) NOT NULL CONSTRAINT [DF_k18a_d18_order] DEFAULT (' '), [법인코드] [char](3) NOT NULL CONSTRAINT [DF_k18a_법인코드] DEFAULT (' '), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_k18a_공장코드] DEFAULT (' '), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_k18a_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_k18a_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_k18a_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_k18a_d16_cname] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_k18a_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_k18a_d14_name] DEFAULT (' '), [d14_honhwa] [char](10) NOT NULL CONSTRAINT [DF_k18a_d14_honhwa] DEFAULT (' '), [d18_gubun] [char](1) NOT NULL CONSTRAINT [DF_k18a_d18_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_k18a_d15_code] DEFAULT (' '), [d15_name] [char](12) NOT NULL CONSTRAINT [DF_k18a_d15_name] DEFAULT (' '), [d18_qty] [numeric](10, 2) NOT NULL CONSTRAINT [DF_k18a_d18_qty] DEFAULT ((0)), [d18_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k18a_d18_pri] DEFAULT ((0)), [d18_napday] [smalldatetime] NOT NULL CONSTRAINT [DF_k18a_d18_napday] DEFAULT (getdate()), [d18_fstday] [smalldatetime] NOT NULL CONSTRAINT [DF_k18a_d18_fstday] DEFAULT (getdate()), [d18_cgeday] [smalldatetime] NOT NULL CONSTRAINT [DF_k18a_d18_cgeday] DEFAULT (getdate()), [d18_totout] [numeric](9, 2) NOT NULL CONSTRAINT [DF_k18a_d18_totout] DEFAULT ((0)), [d18_totgum] [numeric](9, 2) NOT NULL CONSTRAINT [DF_k18a_d18_totgum] DEFAULT ((0)), [d18_notgum] [numeric](9, 2) NOT NULL CONSTRAINT [DF_k18a_d18_notgum] DEFAULT ((0)), [order_no] [char](20) NOT NULL CONSTRAINT [DF_k18a_order_no] DEFAULT (' '), [수요기관] [char](40) NOT NULL CONSTRAINT [DF_k18a_소요기관] DEFAULT (''), [매입코드] [char](6) NOT NULL CONSTRAINT [DF_k18a_매입코드] DEFAULT (' '), [매출코드] [char](6) NOT NULL CONSTRAINT [DF_k18a_매출코드] DEFAULT (' '), [여신금액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_k18a_여신금액] DEFAULT ((0)), [여신잔액] [numeric](12, 0) NOT NULL CONSTRAINT [DF_k18a_여신잔액] DEFAULT ((0)), [ye_date] [smalldatetime] NOT NULL CONSTRAINT [DF_k18a_ye_date] DEFAULT (getdate()), [d18_pri1] [numeric](6, 0) NOT NULL CONSTRAINT [DF_k18a_d18_pri1] DEFAULT ((0)), [타설부위] [char](30) NOT NULL CONSTRAINT [DF_k18a_타설부위] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms5b0] 스크립트 날짜: 10/06/2014 11:06:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms5b0]( [s_date] [datetime] NOT NULL CONSTRAINT [DF_ksms5b0_s_date] DEFAULT (getdate()), [e_date] [datetime] NOT NULL CONSTRAINT [DF_ksms5b0_e_date] DEFAULT (getdate()), [p_date] [datetime] NOT NULL CONSTRAINT [DF_ksms5b0_p_date] DEFAULT (getdate()), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms5b0_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms5b0_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms5b0_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms5b0_d16_cname] DEFAULT (' '), [si] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms5b0_si] DEFAULT ((0)), [d5b_remk] [char](50) NOT NULL CONSTRAINT [DF_ksms5b0_d5b_remk] DEFAULT (' '), [d5b_gul] [char](30) NOT NULL CONSTRAINT [DF_ksms5b0_d5b_gul] DEFAULT (' '), [d5b_nap] [char](30) NOT NULL CONSTRAINT [DF_ksms5b0_d5b_nap] DEFAULT (' '), [d5b_15name] [char](30) NOT NULL CONSTRAINT [DF_ksms5b0_d5b_15name] DEFAULT (' '), [gubun] [char](10) NOT NULL CONSTRAINT [DF_ksms5b0_gubun] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[fday] 스크립트 날짜: 10/06/2014 11:00:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[fday]( [sday] [datetime] NOT NULL CONSTRAINT [DF_fday_sday] DEFAULT (getdate()), CONSTRAINT [PK_fday] PRIMARY KEY CLUSTERED ( [sday] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** 개체: Table [dbo].[ksms310] 스크립트 날짜: 10/06/2014 11:05:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms310]( [d31_date] [datetime] NOT NULL CONSTRAINT [DF_ksms310_d31_date] DEFAULT (getdate()), [d31_mgcode] [char](1) NOT NULL CONSTRAINT [DF_ksms310_d31_mgcode] DEFAULT (' '), [법인코드] [char](3) NOT NULL CONSTRAINT [DF_ksms310_법인코드] DEFAULT (' '), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_ksms310_공장코드] DEFAULT (' '), [d11_code] [char](10) NOT NULL CONSTRAINT [DF_ksms310_d11_code] DEFAULT (' '), [d11_cname] [char](50) NOT NULL CONSTRAINT [DF_ksms310_d11_cname] DEFAULT (' '), [d16_code] [char](10) NOT NULL CONSTRAINT [DF_ksms310_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms310_d16_cname] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms310_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_ksms310_d14_name] DEFAULT (' '), [d31_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms310_d31_gubun] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms310_d15_name] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d15_code] DEFAULT (' '), [d31_name] [char](9) NOT NULL CONSTRAINT [DF_ksms310_d31_name] DEFAULT (' '), [d31_code] [char](1) NOT NULL CONSTRAINT [DF_ksms310_d31_code] DEFAULT (' '), [d31_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_qty] DEFAULT ((0)), [d31_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_pri] DEFAULT ((0)), [d31_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_amt] DEFAULT ((0)), [d31_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_vat] DEFAULT ((0)), [d31_h_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h_qty] DEFAULT ((0)), [d31_h_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h_pri] DEFAULT ((0)), [d31_h_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h_amt] DEFAULT ((0)), [d31_h_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h_vat] DEFAULT ((0)), [d31_h1_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h1_qty] DEFAULT ((0)), [d31_h1_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h1_pri] DEFAULT ((0)), [d31_h1_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h1_amt] DEFAULT ((0)), [d31_h1_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h1_vat] DEFAULT ((0)), [d31_h2_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h2_qty] DEFAULT ((0)), [d31_h2_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h2_pri] DEFAULT ((0)), [d31_h2_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h2_amt] DEFAULT ((0)), [d31_h2_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h2_vat] DEFAULT ((0)), [d31_chgb] [char](1) NOT NULL CONSTRAINT [DF_ksms310_d31_chgb] DEFAULT (' '), [d32_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms310_d32_qty] DEFAULT ((0)), [d32_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d32_amt] DEFAULT ((0)), [d32_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d32_vat] DEFAULT ((0)), [d32_dc] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d32_dc] DEFAULT ((0)), [dcj_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms310_dcj_qty] DEFAULT ((0)), [dcj_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_dcj_amt] DEFAULT ((0)), [dcj_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_dcj_vat] DEFAULT ((0)), [d31_remk] [varchar](50) NOT NULL CONSTRAINT [DF_ksms310_d31_remk] DEFAULT (' '), [d31_totout] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_totout] DEFAULT ((0)), [d31_totgum] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_totgum] DEFAULT ((0)), [d17_priper] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d17_priper] DEFAULT ((0)), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_ksms310_d17_jogun] DEFAULT (' '), [d52_si] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d52_si] DEFAULT (' '), [d52_yo] [char](4) NOT NULL CONSTRAINT [DF_ksms310_d52_yo] DEFAULT (' '), [bigo1] [char](10) NOT NULL CONSTRAINT [DF_ksms310_bigo1] DEFAULT (' '), [subtotal] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_subtotal] DEFAULT ((0)), [tt_amt00] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_tt_amt00] DEFAULT ((0)), [balhaeng] [numeric](1, 0) NOT NULL CONSTRAINT [DF_ksms310_balhaeng] DEFAULT ((0)), [no] [numeric](5, 0) NOT NULL CONSTRAINT [DF_ksms310_no] DEFAULT ((0)), [order_no] [char](10) NOT NULL CONSTRAINT [DF_ksms310_order_no] DEFAULT (' '), [매입코드] [char](6) NOT NULL CONSTRAINT [DF_ksms310_매입코드] DEFAULT (' '), [매입처명] [char](30) NOT NULL CONSTRAINT [DF_ksms310_매입명] DEFAULT (''), [매출코드] [char](6) NOT NULL CONSTRAINT [DF_ksms310_매출코드] DEFAULT (' '), [bal_date] [datetime] NOT NULL CONSTRAINT [DF_ksms310_bal_date] DEFAULT (getdate()), [d52_h6_si] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d52_h6_si] DEFAULT (''), [d31_h6_wdate] [datetime] NOT NULL CONSTRAINT [DF_ksms310_d31_h6_wdate] DEFAULT (getdate()), [d31_h6_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h6_pri] DEFAULT ((0)), [d31_h6_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h6_qty] DEFAULT ((0)), [d31_h6_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h6_amt] DEFAULT ((0)), [d31_h6_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h6_vat] DEFAULT ((0)), [d52_h5_si] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d52_h5_si] DEFAULT (''), [d31_h5_wdate] [datetime] NOT NULL CONSTRAINT [DF_ksms310_d31_h5_wdate] DEFAULT (getdate()), [d31_h5_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h5_pri] DEFAULT ((0)), [d31_h5_qty] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h5_qty] DEFAULT ((0)), [d31_h5_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h5_amt] DEFAULT ((0)), [d31_h5_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h5_vat] DEFAULT ((0)), [d52_h4_si] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d52_h4_si] DEFAULT (''), [d31_h4_wdate] [datetime] NOT NULL CONSTRAINT [DF_ksms310_d31_h4_wdate] DEFAULT (getdate()), [d31_h4_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h4_pri] DEFAULT ((0)), [d31_h4_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h4_qty] DEFAULT ((0)), [d31_h4_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h4_amt] DEFAULT ((0)), [d31_h4_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h4_vat] DEFAULT ((0)), [d31_h3_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h3_vat] DEFAULT ((0)), [d31_h3_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h3_amt] DEFAULT ((0)), [d31_h3_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms310_d31_h3_qty] DEFAULT ((0)), [d31_h3_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms310_d31_h3_pri] DEFAULT ((0)), [d31_h3_wdate] [datetime] NOT NULL CONSTRAINT [DF_ksms310_d31_h3_wdate] DEFAULT (getdate()), [d52_h3_si] [char](3) NOT NULL CONSTRAINT [DF_ksms310_d52_h3_si_1] DEFAULT (''), [d31_부가세구분] [char](10) NOT NULL CONSTRAINT [DF_ksms310_d31_부가세구분] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[CLASSGROUP] 스크립트 날짜: 10/06/2014 11:00:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CLASSGROUP]( [groupNo] [numeric](4, 0) NOT NULL CONSTRAINT [DF_CLASSGROUP_GROUPNO] DEFAULT ((0)), [groupName] [char](20) NOT NULL CONSTRAINT [DF_CLASSGROUP_GROUPNAME] DEFAULT (''), [regDate] [datetime] NOT NULL CONSTRAINT [DF_CLASSGROUP_REGDATE] DEFAULT (getdate()), [groupNote] [nchar](200) NOT NULL CONSTRAINT [DF_CLASSGROUP_GROUPNOTE] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[혼화제] 스크립트 날짜: 10/06/2014 11:00:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[혼화제]( [코드] [nchar](10) NOT NULL CONSTRAINT [DF_혼화제_코드] DEFAULT (''), [혼화제명] [nchar](60) NOT NULL CONSTRAINT [DF_혼화제_혼화제명] DEFAULT ('') ) ON [PRIMARY] GO /****** 개체: Table [dbo].[CLASSTABLE] 스크립트 날짜: 10/06/2014 11:00:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CLASSTABLE]( [groupNo] [numeric](4, 0) NOT NULL CONSTRAINT [DF_Table_1_GROUPNO] DEFAULT ((0)), [caseNo] [numeric](4, 0) NOT NULL CONSTRAINT [DF_Table_1_CASENO] DEFAULT ((0)), [caseName] [char](20) NOT NULL CONSTRAINT [DF_Table_1_CASENAME] DEFAULT (''), [correCode] [char](50) NOT NULL CONSTRAINT [DF_Table_1_CORRECODE] DEFAULT (''), [extendName] [char](20) NOT NULL CONSTRAINT [DF_Table_1_EXTENDNAME] DEFAULT (''), [defaultOrder] [char](20) NOT NULL CONSTRAINT [DF_CLASSTABLE_defaultOrder] DEFAULT (''), [caseVisible] [numeric](1, 0) NOT NULL CONSTRAINT [DF_CLASSTABLE_caseVisible] DEFAULT ((0)), [regDate] [datetime] NOT NULL CONSTRAINT [DF_CLASSTABLE_regDate] DEFAULT (getdate()), [caseNote] [char](100) NOT NULL CONSTRAINT [DF_CLASSTABLE_caseNote] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms5b1] 스크립트 날짜: 10/06/2014 11:06:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms5b1]( [d31_date] [datetime] NOT NULL CONSTRAINT [DF_ksms5b1_d31_date] DEFAULT (getdate()), [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms5b1_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms5b1_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms5b1_d16_code] DEFAULT (' '), [d16_cname] [char](60) NOT NULL CONSTRAINT [DF_ksms5b1_d16_cname] DEFAULT (' '), [si] [numeric](4, 0) NOT NULL CONSTRAINT [DF_ksms5b1_si] DEFAULT ((0)), [d31_mgcode] [char](1) NOT NULL CONSTRAINT [DF_ksms5b1_d31_mgcode] DEFAULT (' '), [d14_code] [char](4) NOT NULL CONSTRAINT [DF_ksms5b1_d14_code] DEFAULT (' '), [d14_name] [char](12) NOT NULL CONSTRAINT [DF_ksms5b1_d14_name] DEFAULT (' '), [d31_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms5b1_d31_gubun] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms5b1_d15_code] DEFAULT (' '), [d31_name] [char](9) NOT NULL CONSTRAINT [DF_ksms5b1_d31_name] DEFAULT (' '), [d31_code] [char](1) NOT NULL CONSTRAINT [DF_ksms5b1_d31_code] DEFAULT (' '), [d31_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_qty] DEFAULT ((0)), [d31_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_pri] DEFAULT ((0)), [d31_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_amt] DEFAULT ((0)), [d31_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_vat] DEFAULT ((0)), [d31_h_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h_qty] DEFAULT ((0)), [d31_h_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h_pri] DEFAULT ((0)), [d31_h_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h_amt] DEFAULT ((0)), [d31_h_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h_vat] DEFAULT ((0)), [d31_h1_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h1_qty] DEFAULT ((0)), [d31_h1_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h1_pri] DEFAULT ((0)), [d31_h1_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h1_amt] DEFAULT ((0)), [d31_h1_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h1_vat] DEFAULT ((0)), [d31_h2_qty] [numeric](6, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h2_qty] DEFAULT ((0)), [d31_h2_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h2_pri] DEFAULT ((0)), [d31_h2_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h2_amt] DEFAULT ((0)), [d31_h2_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d31_h2_vat] DEFAULT ((0)), [d31_chgb] [char](1) NOT NULL CONSTRAINT [DF_ksms5b1_d31_chgb] DEFAULT (' '), [d32_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d32_qty] DEFAULT ((0)), [d32_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d32_amt] DEFAULT ((0)), [d32_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d32_vat] DEFAULT ((0)), [d32_dc] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_d32_dc] DEFAULT ((0)), [dcj_qty] [numeric](9, 2) NOT NULL CONSTRAINT [DF_ksms5b1_dcj_qty] DEFAULT ((0)), [dcj_amt] [numeric](11, 0) NOT NULL CONSTRAINT [DF_ksms5b1_dcj_amt] DEFAULT ((0)), [dcj_vat] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms5b1_dcj_vat] DEFAULT ((0)), [d31_remk] [char](20) NOT NULL CONSTRAINT [DF_ksms5b1_d31_remk] DEFAULT (' '), [d31_totout] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_totout] DEFAULT ((0)), [d31_totgum] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ksms5b1_d31_totgum] DEFAULT ((0)), [d17_priper] [numeric](5, 1) NOT NULL CONSTRAINT [DF_ksms5b1_d17_priper] DEFAULT ((0)), [d17_jogun] [char](1) NOT NULL CONSTRAINT [DF_ksms5b1_d17_jogun] DEFAULT (' '), [si1] [numeric](3, 0) NOT NULL CONSTRAINT [DF_ksms5b1_si1] DEFAULT ((0)), [bal_date] [datetime] NOT NULL CONSTRAINT [DF_ksms5b1_bal_date] DEFAULT (getdate()) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[계정코드] 스크립트 날짜: 10/06/2014 10:59:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[계정코드]( [계정코드] [nchar](10) NOT NULL CONSTRAINT [DF_계정코드_계정코드] DEFAULT (''), [계정명] [nchar](40) NOT NULL CONSTRAINT [DF_계정코드_계정명] DEFAULT (''), [비고] [nchar](60) NOT NULL CONSTRAINT [DF_계정코드_비고] DEFAULT ('') ) ON [PRIMARY] GO /****** 개체: Table [dbo].[PRODGROUP] 스크립트 날짜: 10/06/2014 11:06:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PRODGROUP]( [ACCode] [numeric](4, 0) NOT NULL CONSTRAINT [DF_PRODGROUP_ACCode] DEFAULT ((0)), [PGCode] [char](3) NOT NULL CONSTRAINT [DF_PRODGROUP_PGCode] DEFAULT (''), [PGName] [char](10) NOT NULL, [PGNote] [char](40) NOT NULL CONSTRAINT [DF_PRODGROUP_PGNote] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms410] 스크립트 날짜: 10/06/2014 11:05:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms410]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms410_d11_code] DEFAULT (' '), [b_11name] [char](30) NOT NULL CONSTRAINT [DF_ksms410_b_11name] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms410_d16_code] DEFAULT (' '), [b_16name] [char](30) NOT NULL CONSTRAINT [DF_ksms410_b_16name] DEFAULT (' '), [b_mj_date] [datetime] NOT NULL CONSTRAINT [DF_ksms410_b_mj_date] DEFAULT (getdate()), [b_code] [char](4) NOT NULL CONSTRAINT [DF_ksms410_b_code] DEFAULT (' '), [b_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms410_b_gubun] DEFAULT (' '), [b_baldate] [datetime] NOT NULL CONSTRAINT [DF_ksms410_b_baldate] DEFAULT (getdate()), [b_sg_date] [datetime] NOT NULL CONSTRAINT [DF_ksms410_b_sg_date] DEFAULT (getdate()), [b_billno] [char](20) NOT NULL CONSTRAINT [DF_ksms410_b_billno] DEFAULT (' '), [b_baperson] [char](20) NOT NULL CONSTRAINT [DF_ksms410_b_baperson] DEFAULT (' '), [b_bank] [char](30) NOT NULL CONSTRAINT [DF_ksms410_b_bank] DEFAULT (' '), [b_billgb] [char](1) NOT NULL CONSTRAINT [DF_ksms410_b_billgb] DEFAULT (' '), [b_amt] [numeric](10, 0) NOT NULL CONSTRAINT [DF_ksms410_b_amt] DEFAULT ((0)), [b_guldate] [datetime] NOT NULL CONSTRAINT [DF_ksms410_b_guldate] DEFAULT (getdate()), [b_beperson] [char](20) NOT NULL CONSTRAINT [DF_ksms410_b_beperson] DEFAULT (' '), [b_remk] [char](10) NOT NULL CONSTRAINT [DF_ksms410_b_remk] DEFAULT (' ') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ksms161] 스크립트 날짜: 10/06/2014 11:04:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ksms161]( [d11_code] [char](6) NOT NULL CONSTRAINT [DF_ksms161_d11_code] DEFAULT (' '), [d11_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms161_d11_cname] DEFAULT (' '), [d16_code] [char](4) NOT NULL CONSTRAINT [DF_ksms161_d16_code] DEFAULT (' '), [d16_cname] [char](30) NOT NULL CONSTRAINT [DF_ksms161_d16_cname] DEFAULT (' '), [d15_code] [char](3) NOT NULL CONSTRAINT [DF_ksms161_d15_code] DEFAULT (' '), [d15_name] [char](10) NOT NULL CONSTRAINT [DF_ksms161_d15_name] DEFAULT (' '), [d16_15name] [char](10) NOT NULL CONSTRAINT [DF_ksms161_d16_15name] DEFAULT (' '), [d16_time] [float] NOT NULL CONSTRAINT [DF_ksms161_d16_time] DEFAULT ((0)), [d16_kiro] [float] NOT NULL CONSTRAINT [DF_ksms161_d16_kiro] DEFAULT ((0)), [d16_odate] [datetime] NOT NULL CONSTRAINT [DF_ksms161_d16_odate] DEFAULT (getdate()), [d16_addr] [char](50) NOT NULL CONSTRAINT [DF_ksms161_d16_addr] DEFAULT (' '), [d16_post] [char](7) NOT NULL CONSTRAINT [DF_ksms161_d16_post] DEFAULT (' '), [d16_tele] [char](19) NOT NULL CONSTRAINT [DF_ksms161_d16_tele] DEFAULT (' '), [d16_cgubun] [char](1) NOT NULL CONSTRAINT [DF_ksms161_d16_cgubun] DEFAULT (' '), [d16_sdate] [datetime] NOT NULL CONSTRAINT [DF_ksms161_d16_sdate] DEFAULT (getdate()), [d16_gubun] [char](1) NOT NULL CONSTRAINT [DF_ksms161_d16_gubun] DEFAULT (' '), [d16_posi] [char](30) NOT NULL CONSTRAINT [DF_ksms161_d16_posi] DEFAULT (' '), [d16_remk] [char](30) NOT NULL CONSTRAINT [DF_ksms161_d16_remk] DEFAULT (' '), [d16_급지] [float] NOT NULL CONSTRAINT [DF_ksms161_d16_급지] DEFAULT ((0)), [d_qty000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty000] DEFAULT ((0)), [d_qty00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty00] DEFAULT ((0)), [d_qty01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty01] DEFAULT ((0)), [d_qty02] [float] NOT NULL, [d_qty03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty03] DEFAULT ((0)), [d_qty04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty04] DEFAULT ((0)), [d_qty05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty05] DEFAULT ((0)), [d_qty06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty06] DEFAULT ((0)), [d_qty07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty07] DEFAULT ((0)), [d_qty08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty08] DEFAULT ((0)), [d_qty09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty09] DEFAULT ((0)), [d_qty10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty10] DEFAULT ((0)), [d_qty11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty11] DEFAULT ((0)), [d_qty12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_qty12] DEFAULT ((0)), [d_vat000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat000] DEFAULT ((0)), [d_vat00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat00] DEFAULT ((0)), [d_vat01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat01] DEFAULT ((0)), [d_vat02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat02] DEFAULT ((0)), [d_vat03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat03] DEFAULT ((0)), [d_vat04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat04] DEFAULT ((0)), [d_vat05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat05] DEFAULT ((0)), [d_vat06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat06] DEFAULT ((0)), [d_vat07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat07] DEFAULT ((0)), [d_vat08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat08] DEFAULT ((0)), [d_vat09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat09] DEFAULT ((0)), [d_vat10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat10] DEFAULT ((0)), [d_vat11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat11] DEFAULT ((0)), [d_vat12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_vat12] DEFAULT ((0)), [d_amt000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt000] DEFAULT ((0)), [d_amt00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt00] DEFAULT ((0)), [d_amt01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt01] DEFAULT ((0)), [d_amt02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt02] DEFAULT ((0)), [d_amt03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt03] DEFAULT ((0)), [d_amt04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt04] DEFAULT ((0)), [d_amt05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt05] DEFAULT ((0)), [d_amt06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt06] DEFAULT ((0)), [d_amt07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt07] DEFAULT ((0)), [d_amt08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt08] DEFAULT ((0)), [d_amt09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt09] DEFAULT ((0)), [d_amt10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt10] DEFAULT ((0)), [d_amt11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt11] DEFAULT ((0)), [d_amt12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_amt12] DEFAULT ((0)), [d_i_amt000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt000] DEFAULT ((0)), [d_i_amt00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt00] DEFAULT ((0)), [d_i_amt01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt01] DEFAULT ((0)), [d_i_amt02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt02] DEFAULT ((0)), [d_i_amt03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt03] DEFAULT ((0)), [d_i_amt04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt04] DEFAULT ((0)), [d_i_amt05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt05] DEFAULT ((0)), [d_i_amt06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt06] DEFAULT ((0)), [d_i_amt07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt07] DEFAULT ((0)), [d_i_amt08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt08] DEFAULT ((0)), [d_i_amt09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt09] DEFAULT ((0)), [d_i_amt10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt10] DEFAULT ((0)), [d_i_amt11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt11] DEFAULT ((0)), [d_i_amt12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_amt12] DEFAULT ((0)), [d_i_vat000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat000] DEFAULT ((0)), [d_i_vat00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat00] DEFAULT ((0)), [d_i_vat01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat01] DEFAULT ((0)), [d_i_vat02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat02] DEFAULT ((0)), [d_i_vat03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat03] DEFAULT ((0)), [d_i_vat04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat04] DEFAULT ((0)), [d_i_vat05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat05] DEFAULT ((0)), [d_i_vat06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat06] DEFAULT ((0)), [d_i_vat07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat07] DEFAULT ((0)), [d_i_vat08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat08] DEFAULT ((0)), [d_i_vat09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat09] DEFAULT ((0)), [d_i_vat10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat10] DEFAULT ((0)), [d_i_vat11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat11] DEFAULT ((0)), [d_i_vat12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_vat12] DEFAULT ((0)), [d_i_qty000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty000] DEFAULT ((0)), [d_i_qty00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty00] DEFAULT ((0)), [d_i_qty01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty01] DEFAULT ((0)), [d_i_qty02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty02] DEFAULT ((0)), [d_i_qty03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty03] DEFAULT ((0)), [d_i_qty04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty04] DEFAULT ((0)), [d_i_qty05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty05] DEFAULT ((0)), [d_i_qty06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty06] DEFAULT ((0)), [d_i_qty07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty07] DEFAULT ((0)), [d_i_qty08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty08] DEFAULT ((0)), [d_i_qty09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty09] DEFAULT ((0)), [d_i_qty10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty10] DEFAULT ((0)), [d_i_qty11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty11] DEFAULT ((0)), [d_i_qty12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_qty12] DEFAULT ((0)), [d_i_dc000] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc000] DEFAULT ((0)), [d_i_dc00] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc00] DEFAULT ((0)), [d_i_dc01] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc01] DEFAULT ((0)), [d_i_dc02] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc02] DEFAULT ((0)), [d_i_dc03] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc03] DEFAULT ((0)), [d_i_dc04] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc04] DEFAULT ((0)), [d_i_dc05] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc05] DEFAULT ((0)), [d_i_dc06] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc06] DEFAULT ((0)), [d_i_dc07] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc07] DEFAULT ((0)), [d_i_dc08] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc08] DEFAULT ((0)), [d_i_dc09] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc09] DEFAULT ((0)), [d_i_dc10] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc10] DEFAULT ((0)), [d_i_dc11] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc11] DEFAULT ((0)), [d_i_dc12] [float] NOT NULL CONSTRAINT [DF_ksms161_d_i_dc12] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[운반단가] 스크립트 날짜: 10/06/2014 11:00:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[운반단가]( [운반코드] [char](3) NOT NULL CONSTRAINT [DF_운반단가_운반코드] DEFAULT (''), [운반구간명] [char](10) NOT NULL CONSTRAINT [DF_운반단가_운반구간명] DEFAULT (''), [운반구단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_운반단가_운반구단가] DEFAULT ((0)), [야간운반단가] [numeric](5, 0) NOT NULL CONSTRAINT [DF_운반단가_야간운반단가] DEFAULT ((0)), [야간VAT] [numeric](5, 0) NOT NULL CONSTRAINT [DF_운반단가_야간VAT] DEFAULT ((0)), [적재중량] [numeric](5, 0) NOT NULL CONSTRAINT [DF_운반단가_적재중량] DEFAULT ((0)), [주유대] [numeric](6, 0) NOT NULL CONSTRAINT [DF_운반단가_주유대] DEFAULT ((0)), [등록일자] [smalldatetime] NOT NULL CONSTRAINT [DF_운반단가_등록일자] DEFAULT (getdate()), [운반구분] [char](10) NOT NULL CONSTRAINT [DF_운반단가_운반구분] DEFAULT (''), [운반단가] [numeric](6, 0) NOT NULL CONSTRAINT [DF_운반단가_운반단가] DEFAULT ((0)), [야간시간] [char](5) NOT NULL CONSTRAINT [DF_운반단가_야간시간] DEFAULT (''), [계정과목] [char](10) NOT NULL CONSTRAINT [DF_운반단가_계정과목] DEFAULT (''), [기초수당] [numeric](6, 0) NOT NULL CONSTRAINT [DF_운반단가_기초수당] DEFAULT ((0)), [계산구분] [char](10) NOT NULL CONSTRAINT [DF_운반단가_계산구분] DEFAULT (''), [비고] [char](30) NOT NULL CONSTRAINT [DF_운반단가_비고] DEFAULT (''), [비고2] [char](30) NOT NULL CONSTRAINT [DF_운반단가_비고2] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO