From 011efb45dd8929c8d6833ef6c726dd9081bc1537 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期五, 19 三月 2021 14:37:05 +0800
Subject: [PATCH] 1.0.3 全局-发货通知相关功能
---
version/version/wjh.sql | 289 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 288 insertions(+), 1 deletions(-)
diff --git a/version/version/wjh.sql b/version/version/wjh.sql
index 487a86c..d2f1fd8 100644
--- a/version/version/wjh.sql
+++ b/version/version/wjh.sql
@@ -38,4 +38,291 @@
/* v1.0.3 2021.03.11 */
--琛ㄧ粨鏋勫彉鏇�
-alter table asr_loc_normal add id int identity(1,1)
\ No newline at end of file
+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
--
Gitblit v1.9.1