/* v1.0.1  */
--表结构变更
alter table dbo.asr_loc_detl add mat_status varchar(10);
alter table dbo.asr_wrk_detl add mat_status varchar(10);
/* v1.0.2 2021.03.05 */
--表结构变更
CREATE TABLE [dbo].[asr_loc_normal](
	[matnr] [varchar](50) NOT NULL,
	[maktx] [nvarchar](50) NULL,
	[lgnum] [varchar](255) NULL,
	[type] [varchar](50) NULL,
	[mnemonic] [varchar](255) NULL,
	[supplier] [varchar](255) NULL,
	[warehouse] [varchar](255) NULL,
	[brand] [varchar](255) NULL,
	[anfme] [decimal](24, 9) NULL,
	[altme] [nvarchar](50) NULL,
	[bname] [nvarchar](50) NULL,
	[memo] [varchar](600) NULL,
	[modi_user] [bigint] NULL,
	[modi_time] [datetime] NULL,
	[appe_user] [bigint] NULL,
	[appe_time] [datetime] NULL,
	[state] [varchar](10) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[asr_loc_area](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[uuid] [varchar](50) NULL,
	[name] [varchar](255) NULL,
	[status] [int] NULL,
	[create_by] [bigint] NULL,
	[create_time] [datetime] NULL,
	[update_by] [bigint] NULL,
	[update_time] [datetime] NULL,
	[memo] [varchar](255) NULL
) ON [PRIMARY]

/* v1.0.3 2021.03.11 */
--表结构变更
alter table asr_loc_normal add id int identity(1,1)

/* v1.0.4 2021.03.17 */
USE [xtyasrs]
GO
/****** Object:  Table [dbo].[OutStockbill]    Script Date: 2021/3/17 10:18:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OutStockbill](
	[FBrNo] [varchar](10) NOT NULL,
	[FInterID] [int] NOT NULL,
	[FBillNo] [nvarchar](255) NOT NULL,
	[FTranType] [smallint] NULL,
	[FSalType] [int] NULL,
	[FCustID] [int] NULL,
	[FDate] [datetime] NULL,
	[FStockID] [int] NULL,
	[FAdd] [char](255) NULL,
	[FNote] [char](255) NULL,
	[FEmpID] [int] NULL,
	[FCheckerID] [int] NULL,
	[FBillerID] [int] NULL,
	[FManagerID] [int] NULL,
	[FClosed] [int] NOT NULL,
	[FInvoiceClosed] [smallint] NULL,
	[FBClosed] [smallint] NOT NULL,
	[FDeptID] [int] NULL,
	[FSettleID] [int] NULL,
	[FTranStatus] [int] NOT NULL,
	[FExchangeRate] [float] NULL,
	[FCurrencyID] [int] NULL,
	[FStatus] [smallint] NOT NULL,
	[FCancellation] [bit] NOT NULL,
	[FMultiCheckLevel1] [int] NULL,
	[FMultiCheckLevel2] [int] NULL,
	[FMultiCheckLevel3] [int] NULL,
	[FMultiCheckLevel4] [int] NULL,
	[FMultiCheckLevel5] [int] NULL,
	[FMultiCheckLevel6] [int] NULL,
	[FMultiCheckDate1] [datetime] NULL,
	[FMultiCheckDate2] [datetime] NULL,
	[FMultiCheckDate3] [datetime] NULL,
	[FMultiCheckDate4] [datetime] NULL,
	[FMultiCheckDate5] [datetime] NULL,
	[FMultiCheckDate6] [datetime] NULL,
	[FCurCheckLevel] [int] NULL,
	[FRelateBrID] [int] NULL,
	[FCheckDate] [datetime] NULL,
	[FExplanation] [nvarchar](255) NOT NULL,
	[FFetchAdd] [nvarchar](255) NOT NULL,
	[FSelTranType] [int] NOT NULL,
	[FChildren] [int] NOT NULL,
	[FBrID] [int] NULL,
	[FAreaPS] [int] NOT NULL,
	[FPOOrdBillNo] [nvarchar](255) NULL,
	[FManageType] [int] NULL,
	[FPrintCount] [smallint] NULL,
	[Fflag_rw] [int] NULL,
	[Fflag_finish] [int] NULL
) ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[OutStockbill] ADD [FWeiOrder] [varchar](255) NOT NULL
ALTER TABLE [dbo].[OutStockbill] ADD [FWeiOpenID] [nvarchar](255) NOT NULL
ALTER TABLE [dbo].[OutStockbill] ADD [FOrderBillNo] [nvarchar](255) NOT NULL
SET ANSI_PADDING ON
ALTER TABLE [dbo].[OutStockbill] ADD [FWLNumber] [varchar](255) NULL
ALTER TABLE [dbo].[OutStockbill] ADD [FWLCompany] [varchar](255) NULL
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[OutStockbill] ADD [FReturnFundType] [varchar](255) NOT NULL
 CONSTRAINT [pk_OutStockbill_1__16] PRIMARY KEY CLUSTERED
(
	[FBrNo] ASC,
	[FInterID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[OutStockbillEntry]    Script Date: 2021/3/17 10:18:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OutStockbillEntry](
	[FBrNo] [varchar](10) NOT NULL,
	[FInterID] [int] NOT NULL,
	[FEntryID] [int] NOT NULL,
	[FItemID] [int] NULL,
	[FQty] [decimal](28, 10) NOT NULL,
	[FCommitQty] [decimal](28, 10) NOT NULL,
	[FPrice] [decimal](28, 10) NOT NULL,
	[FAmount] [decimal](20, 2) NOT NULL,
	[FOrderInterID] [int] NOT NULL,
	[FDate] [datetime] NULL,
	[FNote] [varchar](1024) NULL,
	[FInvoiceQty] [decimal](28, 10) NOT NULL,
	[FBCommitQty] [decimal](28, 10) NOT NULL,
	[FUnitID] [int] NOT NULL,
	[FAuxBCommitQty] [decimal](28, 10) NOT NULL,
	[FAuxCommitQty] [decimal](28, 10) NOT NULL,
	[FAuxInvoiceQty] [decimal](28, 10) NOT NULL,
	[FAuxPrice] [decimal](28, 10) NOT NULL,
	[FAuxQty] [decimal](28, 10) NOT NULL,
	[FSourceEntryID] [int] NOT NULL,
	[FMapNumber] [varchar](80) NOT NULL,
	[FMapName] [nvarchar](256) NULL,
	[FAuxPropID] [int] NOT NULL,
	[FBatchNo] [nvarchar](255) NOT NULL,
	[FCheckDate] [datetime] NULL,
	[FExplanation] [nvarchar](255) NOT NULL,
	[FFetchAdd] [nvarchar](255) NOT NULL,
	[FFetchDate] [datetime] NULL,
	[FMultiCheckDate1] [datetime] NULL,
	[FMultiCheckDate2] [datetime] NULL,
	[FMultiCheckDate3] [datetime] NULL,
	[FMultiCheckDate4] [datetime] NULL,
	[FMultiCheckDate5] [datetime] NULL,
	[FMultiCheckDate6] [datetime] NULL,
	[FSecCoefficient] [decimal](28, 10) NOT NULL,
	[FSecQty] [decimal](28, 10) NOT NULL,
	[FSecCommitQty] [decimal](28, 10) NOT NULL,
	[FSourceTranType] [int] NOT NULL,
	[FSourceInterId] [int] NOT NULL,
	[FSourceBillNo] [nvarchar](255) NOT NULL,
	[FContractInterID] [int] NOT NULL,
	[FContractEntryID] [int] NOT NULL,
	[FContractBillNo] [nvarchar](255) NOT NULL,
	[FOrderEntryID] [int] NOT NULL,
	[FOrderBillNo] [nvarchar](255) NOT NULL,
	[FStockID] [int] NOT NULL,
	[FBackQty] [decimal](28, 10) NOT NULL,
	[FAuxBackQty] [decimal](28, 10) NOT NULL,
	[FSecBackQty] [decimal](28, 10) NOT NULL,
	[FStdAmount] [decimal](23, 10) NOT NULL,
	[FPlanMode] [int] NOT NULL,
	[FMTONo] [nvarchar](50) NOT NULL,
	[FDetailID] [int] NOT NULL,
	[FStockQtyOnlyForShow] [decimal](23, 10) NOT NULL,
	[FComplexQty] [varchar](255) NULL,
	[Fmodel] [varchar](80) NULL,
	[Fname] [varchar](80) NULL,
	[Fnumber] [varchar](80) NULL
) ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[OutStockbillEntry] ADD [FBarCode] [varchar](100) NOT NULL
ALTER TABLE [dbo].[OutStockbillEntry] ADD [FBTPLCommitQty] [decimal](28, 10) NOT NULL
ALTER TABLE [dbo].[OutStockbillEntry] ADD [FTPLCommitQty] [decimal](28, 10) NOT NULL
ALTER TABLE [dbo].[OutStockbillEntry] ADD [fsecinvoiceqty] [decimal](23, 10) NULL
 CONSTRAINT [pk_OutStockbillEntry_1__16] PRIMARY KEY CLUSTERED
(
	[FBrNo] ASC,
	[FInterID] ASC,
	[FEntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FClosed]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FInvoiceClosed]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FBClosed]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((-1)) FOR [FSettleID]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FTranStatus]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FStatus]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FCancellation]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  CONSTRAINT [DF__OutStockbill__FConsig]  DEFAULT ((0)) FOR [FRelateBrID]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FExplanation]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FFetchAdd]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FSelTranType]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FChildren]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ((0)) FOR [FAreaPS]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FWeiOrder]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FWeiOpenID]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FOrderBillNo]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FWLNumber]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FWLCompany]
GO
ALTER TABLE [dbo].[OutStockbill] ADD  DEFAULT ('') FOR [FReturnFundType]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FPrice]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAmount]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  CONSTRAINT [DF_OutStockbillEntry_FOrderInterID]  DEFAULT ((0)) FOR [FOrderInterID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FInvoiceQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FBCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FUnitID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxBCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxInvoiceQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxPrice]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  CONSTRAINT [DF__SEOutStoc__FSour__558158D4]  DEFAULT ((0)) FOR [FSourceEntryID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FMapNumber]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  CONSTRAINT [DF__SEOutStoc__FMapN__5769A146]  DEFAULT ('') FOR [FMapName]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxPropID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FBatchNo]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FExplanation]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FFetchAdd]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSecCoefficient]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSecQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSecCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSourceTranType]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSourceInterId]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FSourceBillNo]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FContractInterID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FContractEntryID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FContractBillNo]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FOrderEntryID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FOrderBillNo]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FStockID]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FBackQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FAuxBackQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FSecBackQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FStdAmount]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((14036)) FOR [FPlanMode]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FMTONo]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('0') FOR [FStockQtyOnlyForShow]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ('') FOR [FBarCode]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FBTPLCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [FTPLCommitQty]
GO
ALTER TABLE [dbo].[OutStockbillEntry] ADD  DEFAULT ((0)) FOR [fsecinvoiceqty]
GO
/* v1.0.5 2021.03.24 */
alter table asr_loc_area add area_type varchar(10);