-
Notifications
You must be signed in to change notification settings - Fork 0
/
ban_makebill_bom.sql
56 lines (53 loc) · 1.73 KB
/
ban_makebill_bom.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
/****** Object: Table [dbo].[ban_makebill_bom] Script Date: 2017-09-02 9:57:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ban_makebill_bom](
[mb_number] [varchar](20) NOT NULL,
[bomid] [bigint] NOT NULL,
[matioid] [varchar](30) NULL,
[styleno] [varchar](20) NULL,
[item_code] [varchar](20) NULL,
[item_desc] [varchar](200) NULL,
[itemtype] [varchar](4) NULL,
[itemtypedesc] [varchar](20) NULL,
[partid] [varchar](200) NULL,
[unit] [varchar](20) NULL,
[model] [varchar](50) NULL,
[wasterate] [decimal](18, 4) NULL,
[useqty] [decimal](18, 5) NULL,
[sumqty] [numeric](18, 4) NULL,
[element] [varchar](100) NULL,
[gweight] [varchar](50) NULL,
[costprice] [numeric](18, 4) NULL,
[costtotal] [numeric](18, 4) NULL,
[sourcetype] [varchar](10) NULL,
[sourcetypedesc] [varchar](20) NULL,
[stylecolorid] [varchar](20) NULL,
[stylecolordesc] [varchar](50) NULL,
[bansize] [varchar](50) NULL,
[itemcolorid] [varchar](20) NULL,
[itemcolordesc] [varchar](50) NULL,
[stampcolorid] [varchar](20) NULL,
[stampcolordesc] [varchar](50) NULL,
[washedcolorid] [varchar](20) NULL,
[washedcolordesc] [varchar](50) NULL,
[goodsqty] [int] NULL,
[sjqty] [numeric](18, 2) NULL,
[qtymiss] [numeric](18, 2) NULL,
[qtyother] [numeric](18, 2) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Index [mb_number] Script Date: 2017-09-02 9:57:22 ******/
CREATE NONCLUSTERED INDEX [mb_number] ON [dbo].[ban_makebill_bom]
(
[mb_number] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO