yilv_new/AA/sql/table.sql

create database wtu
go
use wtu
go

--档案传递信息表
create table dbo.transtime
(
	entitytype	nvarchar(60) not null,	--档案类型
	lasttime	datetime				--最后传递时间
)
go
--错误信息表
create table dbo.errmsg
(
	sysid int identity(1,1),
	operdate datetime default(getdate()),
	opertype nvarchar(60) not null,
	msg	nvarchar(4000),
	sources nvarchar(400),
	errorflag int default(0) --0,从中间库到业务系统，1，从业务系统到中间库
)
go

--旺店通日志表
create table dbo.wdtlogs
(
	sysid int identity(1,1),
	operdate datetime default(getdate()),
	opertype nvarchar(60) not null,
	args	nvarchar(4000) null,
	returncode nvarchar(10) null,
	msg		nvarchar(400) null
)

--存货
CREATE TABLE dbo.Inventory(
	sysid int identity(1,1),
	cInvCode nvarchar(60) NOT NULL,	
	cInvName nvarchar(255) NULL,
	cInvStd nvarchar(255) NULL,
	bPurchase bit NOT NULL,
	iTaxRate float NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	cComUnitCode nvarchar(35) null,
	processflag bit default(0)
)
GO

--库存期初
create table dbo.stock(
	sysid int identity(1,1),
	cInvCode nvarchar(60) NOT NULL,	
	cwhcode  nvarchar(30) not null,
	qty decimal(26,4) not null default(0),
	price decimal(13,4) not null default(0),	
	importdate datetime null default(getdate()),
	processflag int default(0)
)
go

--仓库
CREATE TABLE dbo.Warehouse(
    sysid int identity(1,1),
	cWhCode nvarchar(10) NOT NULL,
	cWhName nvarchar(20) NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0)
)

--供应商
CREATE TABLE dbo.Vendor(
	sysid int identity(1,1),
	cVenCode nvarchar(20) NOT NULL,
	cVenName nvarchar(98) NULL,
	cVenPhone nvarchar(100) null,
	cVenAbbName nvarchar(60) NOT NULL,
	cVenPerson [nvarchar](50) NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0)
	)

GO

--其他入库单

CREATE TABLE [dbo].[RdRecord08](
	sysid int identity(1,1),
	[ID] [bigint] NOT NULL,
	[bRdFlag] [tinyint] NOT NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cBusType] [nvarchar](12) NULL,
	[cSource] [nvarchar](50) NOT NULL,
	[cBusCode] [nvarchar](30) NULL,
	[cWhCode] [nvarchar](10) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cSTCode] [nvarchar](2) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cOrderCode] [nvarchar](30) NULL,
	[cARVCode] [nvarchar](30) NULL,
	[cBillCode] [bigint] NULL,
	[cDLCode] [bigint] NULL,
	[cProBatch] [nvarchar](60) NULL,
	[cHandler] [nvarchar](20) NULL,
	[cMemo] [nvarchar](255) NULL,
	[bTransFlag] [bit] NOT NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[dKeepDate] [nvarchar](5) NULL,
	[dVeriDate] [datetime] NULL,
	[bpufirst] [bit] NULL,
	[biafirst] [bit] NULL,
	[iMQuantity] [float] NULL,
	[dARVDate] [datetime] NULL,
	[cChkCode] [nvarchar](30) NULL,
	[dChkDate] [datetime] NULL,
	[cChkPerson] [nvarchar](40) NULL,
	[VT_ID] [int] NULL,
	[bIsSTQc] [bit] NOT NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[gspcheck] [nvarchar](10) NULL,
	[ufts] [timestamp] NULL,
	[iExchRate] [float] NULL,
	[cExch_Name] [nvarchar](8) NULL,
	[bOMFirst] [bit] NULL,
	[bFromPreYear] [bit] NULL,
	[bIsLsQuery] [bit] NULL,
	[bIsComplement] [smallint] NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[ireturncount] [int] NULL,
	[iverifystate] [int] NULL,
	[iswfcontrolled] [int] NULL,
	[cModifyPerson] [nvarchar](50) NULL,
	[dModifyDate] [datetime] NULL,
	[dnmaketime] [datetime] NULL,
	[dnmodifytime] [datetime] NULL,
	[dnverifytime] [datetime] NULL,
	[bredvouch] [int] NULL,
	[iFlowId] [int] NULL,
	[cPZID] [nvarchar](30) NULL,
	[cSourceLs] [nvarchar](4) NULL,
	[cSourceCodeLs] [nvarchar](20) NULL,
	[iPrintCount] [int] NULL,
	[ctransflag] [nvarchar](2) NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cCheckSignFlag] [nvarchar](36) NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0)    --0：从U8到中间库，1：从旺店通到中间库
	
	
)
CREATE TABLE [dbo].[rdrecords08](
	sysid int identity(1,1),
	[AutoID] [bigint] NOT NULL,
	[ID] [bigint] NOT NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iUnitCost] [decimal](30, 10) NULL,
	[iPrice] [money] NULL,
	[iAPrice] [money] NULL,
	[iPUnitCost] [decimal](30, 10) NULL,
	[iPPrice] [money] NULL,
	[cBatch] [nvarchar](60) NULL,
	[cVouchCode] [bigint] NULL,
	[cInVouchCode] [nvarchar](30) NULL,
	[cinvouchtype] [nvarchar](2) NULL,
	[iSOutQuantity] [decimal](30, 10) NULL,
	[iSOutNum] [decimal](30, 10) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iFlag] [tinyint] NOT NULL,
	[iFNum] [decimal](30, 10) NULL,
	[iFQuantity] [decimal](30, 10) NULL,
	[dVDate] [datetime] NULL,
	[iTrIds] [bigint] NULL,
	[cPosition] [nvarchar](20) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[cName] [nvarchar](255) NULL,
	[cItemCName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[cBarCode] [nvarchar](200) NULL,
	[iNQuantity] [decimal](30, 10) NULL,
	[iNNum] [decimal](30, 10) NULL,
	[cAssUnit] [nvarchar](35) NULL,
	[dMadeDate] [datetime] NULL,
	[iMassDate] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iCheckIds] [bigint] NULL,
	[cBVencode] [nvarchar](20) NULL,
	[chVencode] [nvarchar](20) NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[cCheckCode] [nvarchar](30) NULL,
	[iCheckIdBaks] [bigint] NULL,
	[cRejectCode] [nvarchar](30) NULL,
	[iRejectIds] [bigint] NULL,
	[cCheckPersonCode] [nvarchar](20) NULL,
	[dCheckDate] [datetime] NULL,
	[cMassUnit] [smallint] NULL,
	[bChecked] [bit] NULL,
	[bLPUseFree] [bit] NULL,
	[iRSRowNO] [int] NULL,
	[iOriTrackID] [bigint] NULL,
	[coritracktype] [nvarchar](2) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[dbKeepDate] [datetime] NULL,
	[bCosting] [bit] NULL,
	[bVMIUsed] [bit] NULL,
	[iVMISettleQuantity] [decimal](30, 10) NULL,
	[iVMISettleNum] [decimal](30, 10) NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iInvSNCount] [int] NULL,
	[cwhpersoncode] [nvarchar](20) NULL,
	[cwhpersonname] [nvarchar](50) NULL,
	[cserviceoid] [varchar](38) NULL,
	[cbserviceoid] [varchar](38) NULL,
	[iinvexchrate] [decimal](38, 8) NULL
)
go



CREATE TABLE [dbo].[RdRecord09](
	sysid int identity(1,1),
	[ID] [bigint] NOT NULL,
	[bRdFlag] [tinyint] NOT NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cBusType] [nvarchar](12) NULL,
	[cSource] [nvarchar](50) NOT NULL,
	[cBusCode] [nvarchar](30) NULL,
	[cWhCode] [nvarchar](10) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cSTCode] [nvarchar](2) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cOrderCode] [nvarchar](30) NULL,
	[cARVCode] [nvarchar](30) NULL,
	[cBillCode] [bigint] NULL,
	[cDLCode] [bigint] NULL,
	[cProBatch] [nvarchar](60) NULL,
	[cHandler] [nvarchar](20) NULL,
	[cMemo] [nvarchar](255) NULL,
	[bTransFlag] [bit] NOT NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[dKeepDate] [nvarchar](5) NULL,
	[dVeriDate] [datetime] NULL,
	[bpufirst] [bit] NULL,
	[biafirst] [bit] NULL,
	[iMQuantity] [float] NULL,
	[dARVDate] [datetime] NULL,
	[cChkCode] [nvarchar](30) NULL,
	[dChkDate] [datetime] NULL,
	[cChkPerson] [nvarchar](40) NULL,
	[VT_ID] [int] NULL,
	[bIsSTQc] [bit] NOT NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[gspcheck] [nvarchar](10) NULL,
	[ufts] [timestamp] NULL,
	[iExchRate] [float] NULL,
	[cExch_Name] [nvarchar](8) NULL,
	[cShipAddress] [nvarchar](200) NULL,
	[caddcode] [nvarchar](60) NULL,
	[bOMFirst] [bit] NULL,
	[bFromPreYear] [bit] NULL,
	[bIsLsQuery] [bit] NULL,
	[bIsComplement] [smallint] NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[iBG_OverFlag] [smallint] NULL,
	[cBG_Auditor] [nvarchar](20) NULL,
	[cBG_AuditTime] [nvarchar](20) NULL,
	[ControlResult] [smallint] NULL,
	[ireturncount] [int] NULL,
	[iverifystate] [int] NULL,
	[iswfcontrolled] [int] NULL,
	[cModifyPerson] [nvarchar](50) NULL,
	[dModifyDate] [datetime] NULL,
	[dnmaketime] [datetime] NULL,
	[dnmodifytime] [datetime] NULL,
	[dnverifytime] [datetime] NULL,
	[bredvouch] [int] NULL,
	[iFlowId] [int] NULL,
	[cPZID] [nvarchar](30) NULL,
	[cSourceLs] [nvarchar](4) NULL,
	[cSourceCodeLs] [nvarchar](20) NULL,
	[iPrintCount] [int] NULL,
	[ctransflag] [nvarchar](2) NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cCheckSignFlag] [nvarchar](36) NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0), --0:未处理，1：已处理
	direction int default(0)    --0：从U8到中间库，1：从旺店通到中间库
	)
go


CREATE TABLE [dbo].[rdrecords09](
    sysid int identity(1,1),
	[AutoID] [bigint] NOT NULL,
	[ID] [bigint] NOT NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iUnitCost] [decimal](30, 10) NULL,
	[iPrice] [money] NULL,
	[iAPrice] [money] NULL,
	[iPUnitCost] [decimal](30, 10) NULL,
	[iPPrice] [money] NULL,
	[cBatch] [nvarchar](60) NULL,
	[cVouchCode] [bigint] NULL,
	[cInVouchCode] [nvarchar](30) NULL,
	[cinvouchtype] [nvarchar](2) NULL,
	[iSOutQuantity] [decimal](30, 10) NULL,
	[iSOutNum] [decimal](30, 10) NULL,
	[coutvouchid] [bigint] NULL,
	[coutvouchtype] [nvarchar](2) NULL,
	[iSRedOutQuantity] [decimal](30, 10) NULL,
	[iSRedOutNum] [decimal](30, 10) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iFlag] [tinyint] NOT NULL,
	[iFNum] [decimal](30, 10) NULL,
	[iFQuantity] [decimal](30, 10) NULL,
	[dVDate] [datetime] NULL,
	[iTrIds] [bigint] NULL,
	[cPosition] [nvarchar](20) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[iDLsID] [bigint] NULL,
	[cName] [nvarchar](255) NULL,
	[cItemCName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[cBarCode] [nvarchar](200) NULL,
	[iNQuantity] [decimal](30, 10) NULL,
	[iNNum] [decimal](30, 10) NULL,
	[cAssUnit] [nvarchar](35) NULL,
	[dMadeDate] [datetime] NULL,
	[iMassDate] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iCheckIds] [bigint] NULL,
	[cBVencode] [nvarchar](20) NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[cCheckCode] [nvarchar](30) NULL,
	[iCheckIdBaks] [bigint] NULL,
	[cRejectCode] [nvarchar](30) NULL,
	[iRejectIds] [bigint] NULL,
	[cCheckPersonCode] [nvarchar](20) NULL,
	[dCheckDate] [datetime] NULL,
	[cMassUnit] [smallint] NULL,
	[bChecked] [bit] NULL,
	[iEqDID] [int] NULL,
	[bLPUseFree] [bit] NULL,
	[iRSRowNO] [int] NULL,
	[iOriTrackID] [bigint] NULL,
	[coritracktype] [nvarchar](2) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[dbKeepDate] [datetime] NULL,
	[bCosting] [bit] NULL,
	[bVMIUsed] [bit] NULL,
	[iVMISettleQuantity] [decimal](30, 10) NULL,
	[iVMISettleNum] [decimal](30, 10) NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iInvSNCount] [int] NULL,
	[cwhpersoncode] [nvarchar](20) NULL,
	[cwhpersonname] [nvarchar](50) NULL,
	[cserviceoid] [varchar](38) NULL,
	[cbserviceoid] [varchar](38) NULL,
	[iinvexchrate] [decimal](38, 8) NULL,
	[cbdlcode] [nvarchar](30) NULL
) 
go



CREATE TABLE [dbo].[RdRecord01](
	sysid int identity(1,1),
	[ID] [bigint] NOT NULL,
	[bRdFlag] [tinyint] NOT NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cBusType] [nvarchar](12) NULL,
	[cSource] [nvarchar](50) NOT NULL,
	[cBusCode] [nvarchar](30) NULL,
	[cWhCode] [nvarchar](10) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cSTCode] [nvarchar](2) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cOrderCode] [nvarchar](30) NULL,
	[cARVCode] [nvarchar](30) NULL,
	[cBillCode] [bigint] NULL,
	[cDLCode] [bigint] NULL,
	[cProBatch] [nvarchar](60) NULL,
	[cHandler] [nvarchar](20) NULL,
	[cMemo] [nvarchar](255) NULL,
	[bTransFlag] [bit] NOT NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[dKeepDate] [nvarchar](5) NULL,
	[dVeriDate] [datetime] NULL,
	[bpufirst] [bit] NULL,
	[biafirst] [bit] NULL,
	[iMQuantity] [float] NULL,
	[dARVDate] [datetime] NULL,
	[cChkCode] [nvarchar](30) NULL,
	[dChkDate] [datetime] NULL,
	[cChkPerson] [nvarchar](40) NULL,
	[VT_ID] [int] NULL,
	[bIsSTQc] [bit] NOT NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[gspcheck] [nvarchar](10) NULL,
	[ipurorderid] [bigint] NULL,
	[ipurarriveid] [bigint] NULL,
	[iarriveid] [nvarchar](30) NULL,
	[isalebillid] [nvarchar](30) NULL,
	[ufts] [timestamp] NULL,
	[iTaxRate] [decimal](20, 6) NULL,
	[iExchRate] [float] NULL,
	[cExch_Name] [nvarchar](8) NULL,
	[bOMFirst] [bit] NULL,
	[bFromPreYear] [bit] NULL,
	[bIsLsQuery] [bit] NULL,
	[bIsComplement] [smallint] NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[ireturncount] [int] NULL,
	[iverifystate] [int] NULL,
	[iswfcontrolled] [int] NULL,
	[cModifyPerson] [nvarchar](50) NULL,
	[dModifyDate] [datetime] NULL,
	[dnmaketime] [datetime] NULL,
	[dnmodifytime] [datetime] NULL,
	[dnverifytime] [datetime] NULL,
	[bredvouch] [int] NULL,
	[cVenPUOMProtocol] [nvarchar](20) NULL,
	[dCreditStart] [datetime] NULL,
	[iCreditPeriod] [int] NULL,
	[dGatheringDate] [datetime] NULL,
	[bCredit] [tinyint] NULL,
	[iFlowId] [int] NULL,
	[cPZID] [nvarchar](30) NULL,
	[cSourceLs] [nvarchar](4) NULL,
	[cSourceCodeLs] [nvarchar](20) NULL,
	[iPrintCount] [int] NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cCheckSignFlag] [nvarchar](36) NULL,
	[cGCRouteCode] [nvarchar](40) NULL,
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0)    --0：从U8到中间库，1：从旺店通到中间库
	)

GO



CREATE TABLE [dbo].[rdrecords01](
	sysid int identity(1,1),
	[AutoID] [bigint] NOT NULL,
	[ID] [bigint] NOT NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iUnitCost] [decimal](30, 10) NULL,
	[iPrice] [money] NULL,
	[iAPrice] [money] NULL,
	[iPUnitCost] [decimal](30, 10) NULL,
	[iPPrice] [money] NULL,
	[cBatch] [nvarchar](60) NULL,
	[cVouchCode] [bigint] NULL,
	[cInVouchCode] [nvarchar](30) NULL,
	[cinvouchtype] [nvarchar](2) NULL,
	[iSOutQuantity] [decimal](30, 10) NULL,
	[iSOutNum] [decimal](30, 10) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iFlag] [tinyint] NOT NULL,
	[dSDate] [datetime] NULL,
	[iTax] [money] NULL,
	[iSQuantity] [decimal](30, 10) NULL,
	[iSNum] [decimal](30, 10) NULL,
	[iMoney] [money] NULL,
	[iFNum] [decimal](30, 10) NULL,
	[iFQuantity] [decimal](30, 10) NULL,
	[dVDate] [datetime] NULL,
	[cPosition] [nvarchar](20) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[iPOsID] [bigint] NULL,
	[fACost] [decimal](30, 10) NULL,
	[cName] [nvarchar](255) NULL,
	[cItemCName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[cBarCode] [nvarchar](200) NULL,
	[iNQuantity] [decimal](30, 10) NULL,
	[iNNum] [decimal](30, 10) NULL,
	[cAssUnit] [nvarchar](35) NULL,
	[dMadeDate] [datetime] NULL,
	[iMassDate] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iCheckIds] [bigint] NULL,
	[cBVencode] [nvarchar](20) NULL,
	[chVencode] [nvarchar](20) NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[iArrsId] [bigint] NULL,
	[cCheckCode] [nvarchar](30) NULL,
	[iCheckIdBaks] [bigint] NULL,
	[cRejectCode] [nvarchar](30) NULL,
	[iRejectIds] [bigint] NULL,
	[cCheckPersonCode] [nvarchar](20) NULL,
	[dCheckDate] [datetime] NULL,
	[iOriTaxCost] [decimal](20, 6) NULL,
	[iOriCost] [decimal](20, 6) NULL,
	[iOriMoney] [money] NULL,
	[iOriTaxPrice] [money] NULL,
	[ioriSum] [money] NULL,
	[iTaxRate] [decimal](20, 6) NULL,
	[iTaxPrice] [money] NULL,
	[iSum] [money] NULL,
	[bTaxCost] [bit] NULL,
	[cPOID] [nvarchar](30) NULL,
	[cMassUnit] [smallint] NULL,
	[iMaterialFee] [money] NULL,
	[iProcessCost] [decimal](30, 10) NULL,
	[iProcessFee] [money] NULL,
	[dMSDate] [datetime] NULL,
	[iSMaterialFee] [money] NULL,
	[iSProcessFee] [money] NULL,
	[iOMoDID] [int] NULL,
	[strContractId] [nvarchar](64) NULL,
	[strCode] [nvarchar](150) NULL,
	[bChecked] [bit] NULL,
	[bRelated] [bit] NULL,
	[iOMoMID] [bigint] NULL,
	[iMatSettleState] [int] NOT NULL,
	[iBillSettleCount] [int] NOT NULL,
	[bLPUseFree] [bit] NULL,
	[iOriTrackID] [bigint] NULL,
	[coritracktype] [nvarchar](2) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[dbKeepDate] [datetime] NULL,
	[bCosting] [bit] NULL,
	[iSumBillQuantity] [decimal](30, 10) NULL,
	[bVMIUsed] [bit] NULL,
	[iVMISettleQuantity] [decimal](30, 10) NULL,
	[iVMISettleNum] [decimal](30, 10) NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iInvSNCount] [int] NULL,
	[cwhpersoncode] [nvarchar](20) NULL,
	[cwhpersonname] [nvarchar](50) NULL,
	[impcost] [decimal](30, 10) NULL,
	[iIMOSID] [int] NULL,
	[iIMBSID] [int] NULL,
	[cbarvcode] [nvarchar](30) NULL,
	[dbarvdate] [nvarchar](30) NULL,
	[iinvexchrate] [decimal](30, 10) NULL,
	[corufts] [varchar](16) NULL,
	[comcode] [nvarchar](30) NULL,
	[strContractGUID] [uniqueidentifier] NULL,
	[iExpiratDateCalcu] [smallint] NULL
) 
go


CREATE TABLE [dbo].[rdrecord11](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[ID] [bigint] NOT NULL,
	[bRdFlag] [tinyint] NOT NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cBusType] [nvarchar](12) NULL,
	[cSource] [nvarchar](50) NOT NULL,
	[cBusCode] [nvarchar](30) NULL,
	[cWhCode] [nvarchar](10) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cSTCode] [nvarchar](2) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cOrderCode] [nvarchar](30) NULL,
	[cARVCode] [nvarchar](30) NULL,
	[cBillCode] [bigint] NULL,
	[cDLCode] [bigint] NULL,
	[cProBatch] [nvarchar](60) NULL,
	[cHandler] [nvarchar](20) NULL,
	[cMemo] [nvarchar](255) NULL,
	[bTransFlag] [bit] NOT NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[dKeepDate] [nvarchar](5) NULL,
	[dVeriDate] [datetime] NULL,
	[bpufirst] [bit] NULL,
	[biafirst] [bit] NULL,
	[iMQuantity] [float] NULL,
	[dARVDate] [datetime] NULL,
	[cChkCode] [nvarchar](30) NULL,
	[dChkDate] [datetime] NULL,
	[cChkPerson] [nvarchar](40) NULL,
	[VT_ID] [int] NULL,
	[bIsSTQc] [bit] NOT NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[cPsPcode] [nvarchar](60) NULL,
	[cMPoCode] [nvarchar](30) NULL,
	[gspcheck] [nvarchar](10) NULL,
	[ipurorderid] [bigint] NULL,
	[iproorderid] [int] NULL,
	[ufts] [timestamp] NULL,
	[iExchRate] [float] NULL,
	[cExch_Name] [nvarchar](8) NULL,
	[bOMFirst] [bit] NULL,
	[bFromPreYear] [bit] NULL,
	[bIsLsQuery] [bit] NULL,
	[bIsComplement] [smallint] NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[ireturncount] [int] NULL,
	[iverifystate] [int] NULL,
	[iswfcontrolled] [int] NULL,
	[cModifyPerson] [nvarchar](50) NULL,
	[dModifyDate] [datetime] NULL,
	[dnmaketime] [datetime] NULL,
	[dnmodifytime] [datetime] NULL,
	[dnverifytime] [datetime] NULL,
	[bredvouch] [int] NULL,
	[bmotran] [tinyint] NULL,
	[iFlowId] [int] NULL,
	[cPZID] [nvarchar](30) NULL,
	[cSourceLs] [nvarchar](4) NULL,
	[cSourceCodeLs] [nvarchar](20) NULL,
	[bHYVouch] [bit] NULL,
	[iPrintCount] [int] NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cCheckSignFlag] [nvarchar](36) NULL
)
GO


CREATE TABLE [dbo].[rdrecords11](
	sysid int identity(1,1),
	[AutoID] [bigint] NOT NULL,
	[ID] [bigint] NOT NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iUnitCost] [decimal](30, 10) NULL,
	[iPrice] [money] NULL,
	[iAPrice] [money] NULL,
	[iPUnitCost] [decimal](30, 10) NULL,
	[iPPrice] [money] NULL,
	[cBatch] [nvarchar](60) NULL,
	[cObjCode] [nvarchar](12) NULL,
	[cVouchCode] [bigint] NULL,
	[cInVouchCode] [nvarchar](30) NULL,
	[cinvouchtype] [nvarchar](2) NULL,
	[iSOutQuantity] [decimal](30, 10) NULL,
	[iSOutNum] [decimal](30, 10) NULL,
	[coutvouchid] [bigint] NULL,
	[coutvouchtype] [nvarchar](2) NULL,
	[iSRedOutQuantity] [decimal](30, 10) NULL,
	[iSRedOutNum] [decimal](30, 10) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iFlag] [tinyint] NOT NULL,
	[iSQuantity] [decimal](30, 10) NULL,
	[iSNum] [decimal](30, 10) NULL,
	[iFNum] [decimal](30, 10) NULL,
	[iFQuantity] [decimal](30, 10) NULL,
	[dVDate] [datetime] NULL,
	[iTrIds] [bigint] NULL,
	[cPosition] [nvarchar](20) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[cName] [nvarchar](255) NULL,
	[cItemCName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[cBarCode] [nvarchar](200) NULL,
	[iNQuantity] [decimal](30, 10) NULL,
	[iNNum] [decimal](30, 10) NULL,
	[cAssUnit] [nvarchar](35) NULL,
	[dMadeDate] [datetime] NULL,
	[iMassDate] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iMPoIds] [bigint] NULL,
	[iCheckIds] [bigint] NULL,
	[cBVencode] [nvarchar](20) NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[cCheckCode] [nvarchar](30) NULL,
	[iCheckIdBaks] [bigint] NULL,
	[cRejectCode] [nvarchar](30) NULL,
	[iRejectIds] [bigint] NULL,
	[cCheckPersonCode] [nvarchar](20) NULL,
	[dCheckDate] [datetime] NULL,
	[cMassUnit] [smallint] NULL,
	[cMoLotCode] [nvarchar](60) NULL,
	[iMaterialFee] [money] NULL,
	[iProcessCost] [decimal](30, 10) NULL,
	[iProcessFee] [money] NULL,
	[dMSDate] [datetime] NULL,
	[iSMaterialFee] [money] NULL,
	[iSProcessFee] [money] NULL,
	[iOMoDID] [int] NULL,
	[bFilled] [bigint] NULL,
	[bChecked] [bit] NULL,
	[iOMoMID] [bigint] NULL,
	[cmworkcentercode] [nvarchar](8) NULL,
	[bLPUseFree] [bit] NULL,
	[iRSRowNO] [int] NULL,
	[iOriTrackID] [bigint] NULL,
	[coritracktype] [nvarchar](2) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[dbKeepDate] [datetime] NULL,
	[bCosting] [bit] NULL,
	[bVMIUsed] [bit] NULL,
	[iVMISettleQuantity] [decimal](30, 10) NULL,
	[iVMISettleNum] [decimal](30, 10) NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iInvSNCount] [int] NULL,
	[cwhpersoncode] [nvarchar](20) NULL,
	[cwhpersonname] [nvarchar](50) NULL,
	[iMaIDs] [bigint] NULL,
	[cserviceoid] [varchar](38) NULL,
	[cbserviceoid] [varchar](38) NULL,
	[iinvexchrate] [decimal](38, 8) NULL
) 
GO



CREATE TABLE [dbo].[PO_Pomain](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[cPOID] [nvarchar](30) NULL,
	[dPODate] [datetime] NOT NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cArrivalPlace] [nvarchar](255) NULL,
	[cSCCode] [nvarchar](2) NULL,
	[cexch_name] [nvarchar](8) NULL,
	[nflat] [float] NULL,
	[iTaxRate] [float] NULL,
	[cPayCode] [nvarchar](3) NULL,
	[iCost] [money] NULL,
	[iBargain] [money] NULL,
	[cMemo] [nvarchar](255) NULL,
	[cState] [tinyint] NULL,
	[cPeriod] [nvarchar](12) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cVerifier] [nvarchar](20) NULL,
	[cCloser] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[POID] [int] NOT NULL,
	[iVTid] [int] NOT NULL,
	[ufts] [timestamp] NULL,
	[cChanger] [nvarchar](20) NULL,
	[cBusType] [nvarchar](8) NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[cLocker] [nvarchar](20) NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[iverifystateex] [int] NULL,
	[ireturncount] [int] NULL,
	[IsWfControlled] [bit] NULL,
	[cmaketime] [datetime] NULL,
	[cModifyTime] [datetime] NULL,
	[cAuditTime] [datetime] NULL,
	[cAuditDate] [datetime] NULL,
	[cModifyDate] [datetime] NULL,
	[cReviser] [nvarchar](40) NULL,
	[cVenPUOMProtocol] [nvarchar](20) NULL,
	[cChangVerifier] [nvarchar](40) NULL,
	[cChangAuditTime] [datetime] NULL,
	[cChangAuditDate] [datetime] NULL,
	[iBG_OverFlag] [smallint] NULL,
	[cBG_Auditor] [nvarchar](20) NULL,
	[cBG_AuditTime] [nvarchar](20) NULL,
	[ControlResult] [smallint] NULL,
	[iflowid] [int] NULL,
	[iPrintCount] [int] NULL,
	[dCloseDate] [datetime] NULL,
	[dCloseTime] [datetime] NULL,
	[ccleanver] [nvarchar](50) NULL,
	[cContactCode] [nvarchar](60) NULL,
	[cVenPerson] [nvarchar](100) NULL,
	[cVenBank] [nvarchar](200) NULL,
	[cVenAccount] [nvarchar](100) NULL,
	[cappcode] [nvarchar](64) NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cGCRouteCode] [nvarchar](40) NULL,
	[bGCTransforming] [bit] NULL)
GO


CREATE TABLE [dbo].[PO_Podetails](
	[ID] [int] NOT NULL,
	[cPOID] [nvarchar](30) NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuotedPrice] [decimal](30, 10) NULL,
	[iUnitPrice] [decimal](30, 10) NULL,
	[iMoney] [money] NULL,
	[iTax] [money] NULL,
	[iSum] [money] NULL,
	[iDisCount] [money] NULL,
	[iNatUnitPrice] [decimal](30, 10) NULL,
	[iNatMoney] [money] NULL,
	[iNatTax] [money] NULL,
	[iNatSum] [money] NULL,
	[iNatDisCount] [money] NULL,
	[dArriveDate] [datetime] NULL,
	[iReceivedQTY] [decimal](30, 10) NULL,
	[iReceivedNum] [decimal](30, 10) NULL,
	[iReceivedMoney] [money] NULL,
	[iInvQTY] [decimal](30, 10) NULL,
	[iInvNum] [decimal](30, 10) NULL,
	[iInvMoney] [money] NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iNatInvMoney] [money] NULL,
	[iOriTotal] [money] NULL,
	[iTotal] [money] NULL,
	[iPerTaxRate] decimal(26,4) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[iflag] [tinyint] NULL,
	[cItemCode] [nvarchar](60) NULL,
	[cItem_class] [nvarchar](10) NULL,
	[PPCIds] [int] NULL,
	[cItemName] [nvarchar](255) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[bGsp] [tinyint] NULL,
	[POID] [int] NULL,
	[cUnitID] [nvarchar](35) NULL,
	[iTaxPrice] decimal(26,4) NULL,
	[iArrQTY] decimal(26,4) NULL,
	[iArrNum] decimal(26,4) NULL,
	[iArrMoney] [money] NULL,
	[iNatArrMoney] [money] NULL,
	[iAppIds] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iSOsID] [int] NULL,
	[bTaxCost] [bit] NULL,
	[cSource] [nvarchar](10) NULL,
	[cbCloser] [nvarchar](20) NULL,
	[iPPartId] [int] NULL,
	[iPQuantity] decimal(26,4) NULL,
	[iPTOSeq] [int] NULL,
	[SoType] [tinyint] NULL,
	[SoDId] [nvarchar](50) NULL,
	[ContractRowGUID] [uniqueidentifier] NULL,
	[cupsocode] [nvarchar](64) NULL,
	[iInvMPCost] [decimal](20, 6) NULL,
	[ContractCode] [nvarchar](128) NULL,
	[ContractRowNo] [nvarchar](150) NULL,
	[fPoValidQuantity] decimal(26,4) NULL,
	[fPoValidNum] decimal(26,4) NULL,
	[fPoArrQuantity] decimal(26,4) NULL,
	[fPoArrNum] decimal(26,4) NULL,
	[fPoRetQuantity] decimal(26,4) NULL,
	[fPoRetNum] decimal(26,4) NULL,
	[fPoRefuseQuantity] decimal(26,4) NULL,
	[fPoRefuseNum] decimal(26,4) NULL,
	[dUfts] [timestamp] NULL,
	[iorderdid] [int] NULL,
	[iordertype] [tinyint] NULL,
	[csoordercode] [nvarchar](50) NULL,
	[iorderseq] [int] NULL,
	[cbCloseTime] [datetime] NULL,
	[cbCloseDate] [datetime] NULL,
	[cBG_ItemCode] [nvarchar](50) NULL,
	[cBG_ItemName] [nvarchar](100) NULL,
	[cBG_CaliberKey1] [nvarchar](50) NULL,
	[cBG_CaliberKeyName1] [nvarchar](100) NULL,
	[cBG_CaliberKey2] [nvarchar](50) NULL,
	[cBG_CaliberKeyName2] [nvarchar](100) NULL,
	[cBG_CaliberKey3] [nvarchar](50) NULL,
	[cBG_CaliberKeyName3] [nvarchar](100) NULL,
	[cBG_CaliberCode1] [nvarchar](90) NULL,
	[cBG_CaliberName1] [nvarchar](100) NULL,
	[cBG_CaliberCode2] [nvarchar](90) NULL,
	[cBG_CaliberName2] [nvarchar](100) NULL,
	[cBG_CaliberCode3] [nvarchar](90) NULL,
	[cBG_CaliberName3] [nvarchar](100) NULL,
	[iBG_Ctrl] [tinyint] NULL,
	[cBG_Auditopinion] [nvarchar](100) NULL,
	[fexquantity] decimal(26,4) NULL,
	[fexnum] decimal(26,4) NULL,
	[ivouchrowno] [int] NULL,
	[cBG_CaliberKey4] [nvarchar](50) NULL,
	[cBG_CaliberKeyName4] [nvarchar](100) NULL,
	[cBG_CaliberKey5] [nvarchar](50) NULL,
	[cBG_CaliberKeyName5] [nvarchar](100) NULL,
	[cBG_CaliberKey6] [nvarchar](50) NULL,
	[cBG_CaliberKeyName6] [nvarchar](100) NULL,
	[cBG_CaliberCode4] [nvarchar](90) NULL,
	[cBG_CaliberName4] [nvarchar](100) NULL,
	[cBG_CaliberCode5] [nvarchar](90) NULL,
	[cBG_CaliberName5] [nvarchar](100) NULL,
	[cBG_CaliberCode6] [nvarchar](90) NULL,
	[cBG_CaliberName6] [nvarchar](100) NULL,
	[csocode] [nvarchar](40) NULL,
	[irowno] [int] NULL,
	[freceivedqty] decimal(26,4) NULL,
	[freceivednum] decimal(26,4) NULL,
	[cxjspdids] [nvarchar](60) NULL,
	[cbMemo] [nvarchar](255) NULL,
	[cbsysbarcode] [nvarchar](80) NULL,
	[planlotnumber] [nvarchar](40) NULL,
	[bgift] [smallint] NULL,
	[cFactoryCode] [nvarchar](50) NULL
) 

GO



CREATE TABLE [dbo].[PU_ArrivalVouch](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[iVTid] [int] NOT NULL,
	[ufts] [timestamp] NULL,
	[ID] [int] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cPTCode] [nvarchar](2) NULL,
	[dDate] [datetime] NOT NULL,
	[cVenCode] [nvarchar](20) NOT NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPayCode] [nvarchar](3) NULL,
	[cSCCode] [nvarchar](2) NULL,
	[cexch_name] [nvarchar](8) NOT NULL,
	[iExchRate] [float] NULL,
	[iTaxRate] [decimal](20, 6) NULL,
	[cMemo] [nvarchar](255) NULL,
	[cBusType] [nvarchar](8) NOT NULL,
	[cMaker] [nvarchar](20) NOT NULL,
	[bNegative] [int] NOT NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[ccloser] [nvarchar](20) NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[iBillType] [tinyint] NOT NULL,
	[cvouchtype] [nvarchar](10) NULL,
	[cgeneralordercode] [nvarchar](300) NULL,
	[ctmcode] [nvarchar](30) NULL,
	[cincotermcode] [nvarchar](30) NULL,
	[ctransordercode] [nvarchar](30) NULL,
	[dportdate] [datetime] NULL,
	[csportcode] [nvarchar](30) NULL,
	[caportcode] [nvarchar](30) NULL,
	[csvencode] [nvarchar](30) NULL,
	[carrivalplace] [nvarchar](100) NULL,
	[dclosedate] [datetime] NULL,
	[idec] [int] NULL,
	[bcal] [bit] NULL,
	[guid] [nvarchar](50) NULL,
	[cMakeTime] [datetime] NULL,
	[cModifyTime] [datetime] NULL,
	[cModifyDate] [datetime] NULL,
	[cReviser] [nvarchar](40) NULL,
	[iverifystate] [int] NULL,
	[cAuditDate] [datetime] NULL,
	[caudittime] [datetime] NULL,
	[cverifier] [nvarchar](20) NULL,
	[iverifystateex] [int] NULL,
	[ireturncount] [int] NULL,
	[IsWfControlled] [bit] NULL,
	[cVenPUOMProtocol] [nvarchar](20) NULL,
	[cchanger] [nvarchar](20) NULL,
	[iflowid] [int] NULL,
	[iPrintCount] [int] NULL,
	[ccleanver] [nvarchar](50) NULL,
	[cpocode] [nvarchar](64) NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL)
	go



CREATE TABLE [dbo].[PU_ArrivalVouchs](
	[Autoid] [int] NOT NULL,
	[ID] [int] NULL,
	[cWhCode] [nvarchar](10) NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](20, 6) NULL,
	[iQuantity] [decimal](20, 6) NOT NULL,
	[iOriCost] [decimal](20, 6) NULL,
	[iOriTaxCost] [decimal](20, 6) NULL,
	[iOriMoney] [money] NULL,
	[iOriTaxPrice] [money] NULL,
	[iOriSum] [money] NULL,
	[iCost] [decimal](20, 6) NULL,
	[iMoney] [money] NULL,
	[iTaxPrice] [money] NULL,
	[iSum] [money] NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[iTaxRate] [decimal](20, 6) NOT NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[cItem_class] [nvarchar](2) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[iPOsID] [int] NULL,
	[cItemName] [nvarchar](255) NULL,
	[cUnitID] [nvarchar](50) NULL,
	[fValidInQuan] [decimal](20, 6) NULL,
	[fKPQuantity] [decimal](20, 6) NULL,
	[fRealQuantity] [decimal](20, 6) NULL,
	[fValidQuantity] [decimal](20, 6) NULL,
	[finValidQuantity] [decimal](20, 6) NULL,
	[cCloser] [nvarchar](20) NULL,
	[iCorId] [int] NULL,
	[fRetQuantity] [decimal](20, 6) NULL,
	[fInValidInQuan] [decimal](20, 6) NULL,
	[bGsp] [tinyint] NULL,
	[cBatch] [nvarchar](60) NULL,
	[dVDate] [datetime] NULL,
	[dPDate] [datetime] NULL,
	[fRefuseQuantity] [decimal](20, 6) NULL,
	[cGspState] [nvarchar](20) NULL,
	[fValidNum] decimal(26,4) NULL,
	[fValidInNum] decimal(26,4) NULL,
	[fInValidNum] decimal(26,4) NULL,
	[fRealNum] decimal(26,4) NULL,
	[bTaxCost] [bit] NULL,
	[bInspect] [tinyint] NULL,
	[fRefuseNum] [decimal](20, 6) NULL,
	[iPPartId] [int] NULL,
	[iPQuantity] decimal(26,4) NULL,
	[iPTOSeq] [int] NULL,
	[SoDId] [nvarchar](50) NULL,
	[SoType] [tinyint] NULL,
	[ContractRowGUID] [uniqueidentifier] NULL,
	[imassdate] [int] NULL,
	[cmassunit] [tinyint] NULL,
	[bexigency] [tinyint] NULL,
	[cbcloser] [nvarchar](20) NULL,
	[fSumRefuseQuantity] [decimal](20, 6) NULL,
	[FSumRefuseNum] [decimal](20, 6) NULL,
	[fRetNum] [decimal](20, 6) NULL,
	[fDTQuantity] [decimal](20, 6) NULL,
	[fInvalidInNum] [decimal](20, 6) NULL,
	[fDegradeQuantity] [decimal](20, 6) NULL,
	[fDegradeNum] [decimal](20, 6) NULL,
	[fDegradeInQuantity] [decimal](20, 6) NULL,
	[fDegradeInNum] [decimal](20, 6) NULL,
	[fInspectQuantity] [decimal](20, 6) NULL,
	[fInspectNum] [decimal](20, 6) NULL,
	[iInvMPCost] [decimal](20, 6) NULL,
	[guids] [nvarchar](50) NULL,
	[iinvexchrate] [decimal](28, 8) NULL,
	[objectid_source] [nvarchar](30) NULL,
	[autoid_source] [int] NULL,
	[ufts_source] [nvarchar](50) NULL,
	[irowno_source] [int] NULL,
	[csocode] [nvarchar](50) NULL,
	[isorowno] [int] NULL,
	[iorderid] [int] NULL,
	[cordercode] [nvarchar](50) NULL,
	[iorderrowno] [int] NULL,
	[dlineclosedate] [datetime] NULL,
	[ContractCode] [nvarchar](128) NULL,
	[ContractRowNo] [nvarchar](150) NULL,
	[RejectSource] [bit] NULL,
	[iciqbookid] [int] NULL,
	[cciqbookcode] [nvarchar](30) NULL,
	[cciqcode] [nvarchar](30) NULL,
	[fciqchangrate] decimal(20,6) NULL,
	[irejectautoid] [int] NULL,
	[iExpiratDateCalcu] [smallint] NULL,
	[cExpirationdate] [nvarchar](20) NULL,
	[dExpirationdate] [datetime] NULL,
	[cupsocode] [nvarchar](120) NULL,
	[iorderdid] [int] NULL,
	[iordertype] [tinyint] NULL,
	[csoordercode] [nvarchar](50) NULL,
	[iorderseq] [int] NULL,
	[cBatchProperty1] [decimal](38, 8) NULL,
	[cBatchProperty2] [decimal](38, 8) NULL,
	[cBatchProperty3] [decimal](38, 8) NULL,
	[cBatchProperty4] [decimal](38, 8) NULL,
	[cBatchProperty5] [decimal](38, 8) NULL,
	[cBatchProperty6] [nvarchar](120) NULL,
	[cBatchProperty7] [nvarchar](120) NULL,
	[cBatchProperty8] [nvarchar](120) NULL,
	[cBatchProperty9] [nvarchar](120) NULL,
	[cBatchProperty10] [datetime] NULL,
	[ivouchrowno] [int] NULL,
	[irowno] [int] NULL,
	[cbMemo] [nvarchar](255) NULL,
	[cbsysbarcode] [nvarchar](80) NULL,
	[carrivalcode] [nvarchar](80) NULL,
	[ipickedquantity] [float] NULL,
	[ipickednum] [float] NULL,
	[iSourceMOCode] [nvarchar](60) NULL,
	[iSourceMODetailsID] [int] NULL,
	[freworkquantity] decimal(26,4) NULL,
	[freworknum] decimal(26,4) NULL,
	[fsumreworkquantity] decimal(26,4) NULL,
	[fsumreworknum] decimal(26,4) NULL,
	[iProductType] [tinyint] NULL,
	[cMainInvCode] [nvarchar](60) NULL,
	[iMainMoDetailsID] [int] NULL,
	[PlanLotNumber] [nvarchar](40) NULL,
	[bgift] [smallint] NULL,
	[cFactoryCode] [nvarchar](50) NULL
	)
	go



CREATE TABLE [dbo].[DispatchList](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[DLID] [int] NOT NULL,
	[cDLCode] [nvarchar](30) NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cSTCode] [nvarchar](2) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NOT NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[SBVID] [int] NULL,
	[cSBVCode] [nvarchar](255) NULL,
	[cSOCode] [nvarchar](30) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cPayCode] [nvarchar](3) NULL,
	[cSCCode] [nvarchar](2) NULL,
	[cShipAddress] [nvarchar](255) NULL,
	[cexch_name] [nvarchar](8) NOT NULL,
	[iExchRate] [float] NOT NULL,
	[iTaxRate] [float] NULL,
	[bFirst] [bit] NOT NULL,
	[bReturnFlag] [bit] NOT NULL,
	[bSettleAll] [bit] NOT NULL,
	[cMemo] [nvarchar](255) NULL,
	[cSaleOut] [nvarchar](255) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[cVerifier] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[iNetLock] [real] NULL,
	[iSale] [smallint] NULL,
	[cCusName] [nvarchar](120) NULL,
	[iVTid] [int] NOT NULL,
	[ufts] [timestamp] NULL,
	[cBusType] [nvarchar](8) NULL,
	[cCloser] [nvarchar](20) NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cCreChpName] [nvarchar](20) NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[bIAFirst] [bit] NULL,
	[ioutgolden] [int] NULL,
	[cgatheringplan] [nvarchar](20) NULL,
	[dCreditStart] [datetime] NULL,
	[dGatheringDate] [datetime] NULL,
	[icreditdays] [int] NULL,
	[bCredit] [bit] NULL,
	[caddcode] [nvarchar](30) NULL,
	[iverifystate] [int] NULL,
	[ireturncount] [tinyint] NULL,
	[iswfcontrolled] [tinyint] NULL,
	[icreditstate] [varchar](20) NULL,
	[bARFirst] [bit] NULL,
	[cmodifier] [nvarchar](20) NULL,
	[dmoddate] [datetime] NULL,
	[dverifydate] [datetime] NULL,
	[ccusperson] [nvarchar](100) NULL,
	[dcreatesystime] [datetime] NULL,
	[dverifysystime] [datetime] NULL,
	[dmodifysystime] [datetime] NULL,
	[csvouchtype] [nvarchar](10) NULL,
	[iflowid] [int] NULL,
	[bsigncreate] [bit] NULL,
	[bcashsale] [bit] NULL,
	[cgathingcode] [nvarchar](255) NULL,
	[cChanger] [nvarchar](20) NULL,
	[cChangeMemo] [nvarchar](255) NULL,
	[outid] [uniqueidentifier] NULL,
	[bmustbook] [bit] NULL,
	[cBookDepcode] [nvarchar](12) NULL,
	[cBookType] [nvarchar](10) NULL,
	[bSaUsed] [bit] NULL,
	[bneedbill] [bit] NULL,
	[baccswitchflag] [bit] NULL,
	[iPrintCount] [int] NULL,
	[ccuspersoncode] [nvarchar](30) NULL,
	[cSourceCode] [nvarchar](60) NULL,
	[bsaleoutcreatebill] [bit] NULL,
	[cSysBarCode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[csscode] [nvarchar](3) NULL,
	[cinvoicecompany] [nvarchar](20) NULL,
	[fEBweight] [decimal](30, 9) NULL,
	[cEBweightUnit] [nvarchar](50) NULL,
	[cEBExpressCode] [nvarchar](50) NULL,
	[iEBExpressCoID] [bigint] NULL,
	[SeparateID] [int] NULL,
	[bNotToGoldTax] [tinyint] NULL,
	[cEBTrnumber] [nvarchar](80) NULL,
	[cEBBuyer] [nvarchar](2000) NULL,
	[cEBBuyerNote] [nvarchar](4000) NULL,
	[ccontactname] [nvarchar](255) NULL,
	[cEBprovince] [nvarchar](20) NULL,
	[cEBcity] [nvarchar](20) NULL,
	[cEBdistrict] [nvarchar](60) NULL,
	[cmobilephone] [nvarchar](50) NULL,
	[cInvoiceCusName] [nvarchar](255) NULL,
	[cweighter] [nvarchar](40) NULL,
	[dweighttime] [datetime] NULL,
	[cPickVouchCode] [nvarchar](255) NULL,
	[cGCRouteCode] [nvarchar](10) NULL
) 
go


CREATE TABLE [dbo].[DispatchLists](
	[AutoID] [int] IDENTITY(1,1) NOT NULL,
	[DLID] [int] NOT NULL,
	[iCorID] [int] NULL,
	[cWhCode] [nvarchar](10) NULL,
	[cInvCode] [nvarchar](60) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuotedPrice] [decimal](30, 10) NULL,
	[iUnitPrice] [decimal](30, 10) NULL,
	[iTaxUnitPrice] [decimal](30, 10) NULL,
	[iMoney] [money] NULL,
	[iTax] [money] NULL,
	[iSum] [money] NULL,
	[iDisCount] [money] NULL,
	[iNatUnitPrice] [decimal](30, 10) NULL,
	[iNatMoney] [money] NULL,
	[iNatTax] [money] NULL,
	[iNatSum] [money] NULL,
	[iNatDisCount] [money] NULL,
	[iSettleNum] [decimal](30, 10) NULL,
	[iSettleQuantity] [decimal](30, 10) NULL,
	[iBatch] [int] NULL,
	[cBatch] [nvarchar](60) NULL,
	[bSettleAll] [bit] NOT NULL,
	[cMemo] [nvarchar](255) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iTB] [tinyint] NULL,
	[dvDate] [datetime] NULL,
	[TBQuantity] [decimal](26, 9) NULL,
	[TBNum] [decimal](26, 9) NULL,
	[iSOsID] [int] NULL,
	[iDLsID] [int] NOT NULL,
	[KL] [decimal](30, 10) NULL,
	[KL2] [decimal](30, 10) NULL,
	[cInvName] [nvarchar](255) NULL,
	[iTaxRate] [decimal](30, 10) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[fOutQuantity] [decimal](30, 10) NULL,
	[fOutNum] [decimal](30, 10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[cItem_class] [nvarchar](10) NULL,
	[fSaleCost] [decimal](30, 10) NULL,
	[fSalePrice] [decimal](30, 10) NULL,
	[cVenAbbName] [nvarchar](60) NULL,
	[cItemName] [nvarchar](255) NULL,
	[cItem_CName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[bIsSTQc] [bit] NULL,
	[iInvExchRate] decimal(26,4) NULL,
	[cUnitID] [nvarchar](35) NULL,
	[cCode] [nvarchar](30) NULL,
	[iRetQuantity] decimal(26,4) NULL,
	[fEnSettleQuan] decimal(26,4) NULL,
	[fEnSettleSum] [money] NULL,
	[iSettlePrice] [decimal](30, 10) NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[dMDate] [datetime] NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[cSoCode] [nvarchar](30) NULL,
	[cCorCode] [nvarchar](30) NULL,
	[iPPartSeqID] [int] NULL,
	[iPPartID] [int] NULL,
	[iPPartQty] decimal(26,4) NULL,
	[cContractID] [nvarchar](64) NULL,
	[cContractTagCode] [nvarchar](150) NULL,
	[cContractRowGuid] [uniqueidentifier] ROWGUIDCOL  NULL,
	[iMassDate] [int] NULL,
	[cMassUnit] [smallint] NULL,
	[bQANeedCheck] [bit] NOT NULL,
	[bQAUrgency] [bit] NOT NULL,
	[bQAChecking] [bit] NOT NULL,
	[bQAChecked] [bit] NOT NULL,
	[iQAQuantity] [decimal](30, 10) NULL,
	[iQANum] [decimal](30, 10) NULL,
	[cCusInvCode] [nvarchar](60) NULL,
	[cCusInvName] [nvarchar](100) NULL,
	[fsumsignquantity] [decimal](26, 9) NULL,
	[fsumsignnum] [decimal](26, 9) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[bcosting] [bit] NOT NULL,
	[cordercode] [nvarchar](30) NULL,
	[iorderrowno] [bigint] NULL,
	[fcusminprice] [decimal](26, 9) NULL,
	[icostquantity] [decimal](26, 9) NULL,
	[icostsum] [money] NULL,
	[ispecialtype] [tinyint] NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iexchsum] [money] NULL,
	[imoneysum] [money] NULL,
	[irowno] [bigint] NULL,
	[frettbquantity] [decimal](26, 9) NULL,
	[fretsum] [decimal](26, 9) NULL,
	[iExpiratDateCalcu] [smallint] NULL,
	[dExpirationdate] [datetime] NULL,
	[cExpirationdate] [nvarchar](20) NULL,
	[cbatchproperty1] [decimal](38, 8) NULL,
	[cbatchproperty2] [decimal](38, 8) NULL,
	[cbatchproperty3] [decimal](38, 8) NULL,
	[cbatchproperty4] [decimal](38, 8) NULL,
	[cbatchproperty5] [decimal](38, 8) NULL,
	[cbatchproperty6] [nvarchar](120) NULL,
	[cbatchproperty7] [nvarchar](120) NULL,
	[cbatchproperty8] [nvarchar](120) NULL,
	[cbatchproperty9] [nvarchar](120) NULL,
	[cbatchproperty10] [datetime] NULL,
	[dblPreExchMomey] [decimal](29, 6) NULL,
	[dblPreMomey] [decimal](29, 6) NULL,
	[idemandtype] [smallint] NULL,
	[cdemandcode] [nvarchar](40) NULL,
	[cdemandmemo] [nvarchar](300) NULL,
	[cdemandid] [nvarchar](30) NULL,
	[idemandseq] [bigint] NULL,
	[cvencode] [nvarchar](20) NULL,
	[cReasonCode] [nvarchar](10) NULL,
	[cInvSN] [nvarchar](200) NULL,
	[iInvSNCount] [int] NULL,
	[bneedsign] [bit] NULL,
	[bsignover] [bit] NULL,
	[bneedloss] [bit] NULL,
	[flossrate] [decimal](29, 6) NULL,
	[frlossqty] [decimal](29, 6) NULL,
	[fulossqty] [decimal](29, 6) NULL,
	[isettletype] [smallint] NULL,
	[crelacuscode] [nvarchar](20) NULL,
	[cLossMaker] [nvarchar](20) NULL,
	[dLossDate] [datetime] NULL,
	[dLossTime] [datetime] NULL,
	[icoridlsid] [bigint] NULL,
	[fretoutqty] [decimal](29, 6) NULL,
	[body_outid] [uniqueidentifier] NULL,
	[fVeriBillQty] [decimal](26, 9) NULL,
	[fVeriBillSum] [money] NULL,
	[fVeriRetQty] [decimal](26, 9) NULL,
	[fVeriRetSum] [money] NULL,
	[fLastSettleQty] [decimal](26, 9) NULL,
	[fLastSettleSum] [money] NULL,
	[cBookWhcode] [nvarchar](10) NULL,
	[cInVouchType] [nvarchar](2) NULL,
	[cPosition] [nvarchar](20) NULL,
	[fretqtywkp] [decimal](26, 9) NULL,
	[fretqtyykp] [decimal](26, 9) NULL,
	[frettbqtyykp] [decimal](26, 9) NULL,
	[fretsumykp] [decimal](26, 9) NULL,
	[dkeepdate] [datetime] NULL,
	[cSCloser] [nvarchar](20) NULL,
	[isaleoutid] [bigint] NULL,
	[bsaleprice] [bit] NULL,
	[bgift] [bit] NULL,
	[bmpforderclosed] [bit] NULL,
	[cbSysBarCode] [nvarchar](80) NULL,
	[fxjquantity] [float] NULL,
	[fxjnum] [float] NULL,
	[bIAcreatebill] [bit] NULL,
	[cParentCode] [nvarchar](50) NULL,
	[cChildCode] [nvarchar](50) NULL,
	[fchildqty] [decimal](30, 9) NULL,
	[fchildrate] [decimal](30, 9) NULL,
	[iCalcType] [tinyint] NULL,
	[fappretwkpqty] [decimal](30, 9) NULL,
	[fappretwkpsum] [decimal](30, 9) NULL,
	[fappretykpqty] [decimal](30, 9) NULL,
	[fappretykpsum] [decimal](30, 9) NULL,
	[fappretwkptbqty] [decimal](30, 9) NULL,
	[fappretykptbqty] [decimal](30, 9) NULL,
	[irtnappid] [bigint] NULL,
	[crtnappcode] [nvarchar](30) NULL,
	[fretailrealamount] [decimal](26, 9) NULL,
	[fretailsettleamount] [decimal](26, 9) NULL,
	[cFactoryCode] [nvarchar](50) NULL,
	[GCSourceId] [int] NULL,
	[GCSourceIds] [int] NULL)
	go
	
	

CREATE TABLE [dbo].[SO_SOMain](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[cSTCode] [nvarchar](2) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cSOCode] [nvarchar](30) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cDepCode] [nvarchar](12) NOT NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cSCCode] [nvarchar](2) NULL,
	[cCusOAddress] [nvarchar](255) NULL,
	[cPayCode] [nvarchar](3) NULL,
	[cexch_name] [nvarchar](8) NOT NULL,
	[iExchRate] [float] NULL,
	[iTaxRate] [float] NULL,
	[iMoney] [money] NULL,
	[cMemo] [nvarchar](255) NULL,
	[iStatus] [tinyint] NULL,
	[cMaker] [nvarchar](20) NULL,
	[cVerifier] [nvarchar](20) NULL,
	[cCloser] [nvarchar](20) NULL,
	[bDisFlag] [bit] NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[bReturnFlag] [bit] NOT NULL,
	[cCusName] [nvarchar](120) NULL,
	[bOrder] [bit] NULL,
	[ID] [int] NOT NULL,
	[iVTid] [int] NOT NULL,
	[ufts] [timestamp] NULL,
	[cChanger] [nvarchar](20) NULL,
	[cBusType] [nvarchar](8) NOT NULL,
	[cCreChpName] [nvarchar](20) NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[coppcode] [nvarchar](60) NULL,
	[cLocker] [nvarchar](20) NULL,
	[dPreMoDateBT] [datetime] NULL,
	[dPreDateBT] [datetime] NULL,
	[cgatheringplan] [nvarchar](20) NULL,
	[caddcode] [nvarchar](30) NULL,
	[iverifystate] [int] NULL,
	[ireturncount] [tinyint] NULL,
	[iswfcontrolled] [tinyint] NULL,
	[icreditstate] [varchar](20) NULL,
	[cmodifier] [nvarchar](20) NULL,
	[dmoddate] [datetime] NULL,
	[dverifydate] [datetime] NULL,
	[ccusperson] [nvarchar](100) NULL,
	[dcreatesystime] [datetime] NULL,
	[dverifysystime] [datetime] NULL,
	[dmodifysystime] [datetime] NULL,
	[iflowid] [int] NULL,
	[bcashsale] [bit] NULL,
	[cgathingcode] [nvarchar](255) NULL,
	[cChangeVerifier] [nvarchar](20) NULL,
	[dChangeVerifyDate] [datetime] NULL,
	[dChangeVerifyTime] [datetime] NULL,
	[outid] [uniqueidentifier] NULL,
	[ccuspersoncode] [nvarchar](30) NULL,
	[dclosedate] [datetime] NULL,
	[dclosesystime] [datetime] NULL,
	[iPrintCount] [float] NULL,
	[fbookratio] [float] NULL,
	[bmustbook] [bit] NULL,
	[fbooksum] [money] NULL,
	[fbooknatsum] [money] NULL,
	[fgbooksum] [money] NULL,
	[fgbooknatsum] [money] NULL,
	[csvouchtype] [nvarchar](10) NULL,
	[cCrmPersonCode] [nvarchar](255) NULL,
	[cCrmPersonName] [nvarchar](255) NULL,
	[cMainPersonCode] [nvarchar](255) NULL,
	[cSysBarCode] [nvarchar](60) NULL,
	[ioppid] [int] NULL,
	[optnty_name] [nvarchar](255) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[contract_status] [smallint] NULL,
	[csscode] [nvarchar](3) NULL,
	[cinvoicecompany] [nvarchar](20) NULL,
	[cAttachment] [nvarchar](255) NULL,
	[cEBTrnumber] [nvarchar](80) NULL,
	[cEBBuyer] [nvarchar](2000) NULL,
	[cEBBuyerNote] [nvarchar](4000) NULL,
	[ccontactname] [nvarchar](255) NULL,
	[cEBprovince] [nvarchar](20) NULL,
	[cEBcity] [nvarchar](20) NULL,
	[cEBdistrict] [nvarchar](60) NULL,
	[cmobilephone] [nvarchar](50) NULL,
	[cInvoiceCusName] [nvarchar](255) NULL,
	[cGCRouteCode] [nvarchar](10) NULL)
	go
	
	

CREATE TABLE [dbo].[SO_SODetails](
	[AutoID] [int] IDENTITY(1,1) NOT NULL,
	[cSOCode] [nvarchar](30) NULL,
	[cInvCode] [nvarchar](60) NULL,
	[dPreDate] [datetime] NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuotedPrice] [decimal](30, 10) NULL,
	[iUnitPrice] [decimal](30, 10) NULL,
	[iTaxUnitPrice] [decimal](30, 10) NULL,
	[iMoney] [money] NULL,
	[iTax] [money] NULL,
	[iSum] [money] NULL,
	[iDisCount] [money] NULL,
	[iNatUnitPrice] [decimal](30, 10) NULL,
	[iNatMoney] [money] NULL,
	[iNatTax] [money] NULL,
	[iNatSum] [money] NULL,
	[iNatDisCount] [money] NULL,
	[iFHNum] [decimal](30, 10) NULL,
	[iFHQuantity] [decimal](30, 10) NULL,
	[iFHMoney] [money] NULL,
	[iKPQuantity] [decimal](30, 10) NULL,
	[iKPNum] [decimal](30, 10) NULL,
	[iKPMoney] [money] NULL,
	[cMemo] [nvarchar](255) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[bFH] [int] NULL,
	[iSOsID] [int] NOT NULL,
	[KL] [decimal](30, 10) NULL,
	[KL2] [decimal](30, 10) NULL,
	[cInvName] [nvarchar](255) NULL,
	[iTaxRate] [decimal](30, 10) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItemCode] [nvarchar](60) NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemName] [nvarchar](255) NULL,
	[cItem_CName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[iInvExchRate] decimal(26,4) NULL,
	[cUnitID] [nvarchar](35) NULL,
	[ID] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[FPurQuan] decimal(26,4) NULL,
	[fSaleCost] [decimal](30, 10) NULL,
	[fSalePrice] [decimal](30, 10) NULL,
	[cQuoCode] [nvarchar](30) NULL,
	[iQuoID] [int] NULL,
	[cSCloser] [nvarchar](20) NULL,
	[dPreMoDate] [datetime] NULL,
	[iRowNo] [int] NULL,
	[iCusBomID] [int] NULL,
	[iMoQuantity] decimal(26,4) NULL,
	[cContractID] [nvarchar](64) NULL,
	[cContractTagCode] [nvarchar](150) NULL,
	[cContractRowGuid] [uniqueidentifier] ROWGUIDCOL  NULL,
	[iPPartSeqID] [int] NULL,
	[iPPartID] [int] NULL,
	[iPPartQty] decimal(26,4) NULL,
	[cCusInvCode] [nvarchar](60) NULL,
	[cCusInvName] [nvarchar](100) NULL,
	[iPreKeepQuantity] decimal(26,4) NULL,
	[iPreKeepNum] decimal(26,4) NULL,
	[iPreKeepTotQuantity] decimal(26,4) NULL,
	[iPreKeepTotNum] decimal(26,4) NULL,
	[dreleasedate] [datetime] NULL,
	[fcusminprice] [decimal](26, 9) NULL,
	[fimquantity] [decimal](26, 9) NULL,
	[fomquantity] [decimal](26, 9) NULL,
	[ballpurchase] [bit] NULL,
	[finquantity] [decimal](26, 9) NULL,
	[icostquantity] [decimal](26, 9) NULL,
	[icostsum] [money] NULL,
	[foutquantity] [decimal](26, 9) NULL,
	[foutnum] [decimal](26, 9) NULL,
	[iexchsum] [money] NULL,
	[imoneysum] [money] NULL,
	[dufts] [timestamp] NULL,
	[iaoids] [int] NULL,
	[cpreordercode] [nvarchar](30) NULL,
	[fretquantity] [decimal](29, 6) NULL,
	[fretnum] [decimal](29, 6) NULL,
	[dbclosedate] [datetime] NULL,
	[dbclosesystime] [datetime] NULL,
	[bOrderBOM] [bit] NULL,
	[bOrderBOMOver] [tinyint] NULL,
	[idemandtype] [smallint] NULL,
	[cdemandcode] [nvarchar](40) NULL,
	[cdemandmemo] [nvarchar](300) NULL,
	[fPurSum] [decimal](26, 9) NULL,
	[fPurBillQty] [decimal](26, 9) NULL,
	[fPurBillSum] [decimal](26, 9) NULL,
	[iimid] [bigint] NULL,
	[ccorvouchtype] [nvarchar](10) NULL,
	[icorrowno] [int] NULL,
	[busecusbom] [bit] NULL,
	[body_outid] [uniqueidentifier] NULL,
	[fVeriDispQty] [decimal](26, 9) NULL,
	[fVeriDispSum] [money] NULL,
	[bsaleprice] [bit] NULL,
	[bgift] [bit] NULL,
	[forecastdid] [int] NULL,
	[cdetailsdemandcode] [nvarchar](40) NULL,
	[cdetailsdemandmemo] [nvarchar](300) NULL,
	[fTransedQty] [decimal](30, 10) NULL,
	[cbSysBarCode] [nvarchar](80) NULL,
	[fappqty] [decimal](30, 9) NULL,
	[cParentCode] [nvarchar](50) NULL,
	[cChildCode] [nvarchar](50) NULL,
	[fchildqty] [decimal](30, 9) NULL,
	[fchildrate] [decimal](30, 9) NULL,
	[iCalcType] [tinyint] NULL,
	[iCurPartid] [bigint] NULL,
	[cFactoryCode] [nvarchar](50) NULL,
	[GCSourceId] [int] NULL,
	[GCSourceIds] [int] NULL)
	go


CREATE TABLE [dbo].[Customer](
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
	[cCusCode] [nvarchar](20) NOT NULL,
	[cCusName] [nvarchar](98) NULL,
	[cCusAbbName] [nvarchar](60) NOT NULL,
	[cCCCode] [nvarchar](12) NULL,
	[cDCCode] [nvarchar](12) NULL,
	[cTrade] [nvarchar](50) NULL,
	[cCusAddress] [nvarchar](255) NULL,
	[cCusPostCode] [nvarchar](20) NULL,
	[cCusRegCode] [nvarchar](50) NULL,
	[cCusBank] [nvarchar](100) NULL,
	[cCusAccount] [nvarchar](50) NULL,
	[dCusDevDate] [datetime] NULL,
	[cCusLPerson] [nvarchar](100) NULL,
	[cCusEmail] [nvarchar](100) NULL,
	[cCusPerson] [nvarchar](50) NULL,
	[cCusPhone] [nvarchar](100) NULL,
	[cCusFax] [nvarchar](100) NULL,
	[cCusBP] [nvarchar](20) NULL,
	[cCusHand] [nvarchar](100) NULL,
	[cCusPPerson] [nvarchar](20) NULL,
	[iCusDisRate] [float] NULL,
	[cCusCreGrade] [nvarchar](6) NULL,
	[iCusCreLine] [float] NULL,
	[iCusCreDate] [int] NULL,
	[cCusPayCond] [nvarchar](20) NULL,
	[cCusOAddress] [nvarchar](255) NULL,
	[cCusOType] [nvarchar](10) NULL,
	[cCusHeadCode] [nvarchar](20) NULL,
	[cCusWhCode] [nvarchar](10) NULL,
	[cCusDepart] [nvarchar](12) NULL,
	[iARMoney] [float] NULL,
	[dLastDate] [datetime] NULL,
	[iLastMoney] [float] NULL,
	[dLRDate] [datetime] NULL,
	[iLRMoney] [float] NULL,
	[dEndDate] [datetime] NULL,
	[iFrequency] [int] NULL,
	[cCusDefine1] [nvarchar](20) NULL,
	[cCusDefine2] [nvarchar](20) NULL,
	[cCusDefine3] [nvarchar](20) NULL,
	[iCostGrade] [smallint] NULL,
	[cCreatePerson] [nvarchar](20) NULL,
	[cModifyPerson] [nvarchar](20) NULL,
	[dModifyDate] [datetime] NULL,
	[cRelVendor] [nvarchar](20) NULL,
	[iId] [nvarchar](40) NULL,
	[cPriceGroup] [nvarchar](20) NULL,
	[cOfferGrade] [nvarchar](20) NULL,
	[iOfferRate] [float] NULL,
	[cCusDefine4] [nvarchar](60) NULL,
	[cCusDefine5] [nvarchar](60) NULL,
	[cCusDefine6] [nvarchar](60) NULL,
	[cCusDefine7] [nvarchar](120) NULL,
	[cCusDefine8] [nvarchar](120) NULL,
	[cCusDefine9] [nvarchar](120) NULL,
	[cCusDefine10] [nvarchar](120) NULL,
	[cCusDefine11] [int] NULL,
	[cCusDefine12] [int] NULL,
	[cCusDefine13] [float] NULL,
	[cCusDefine14] [float] NULL,
	[cCusDefine15] [datetime] NULL,
	[cCusDefine16] [datetime] NULL,
	[pubufts] [timestamp] NULL,
	[cInvoiceCompany] [nvarchar](60) NULL,
	[bCredit] [bit] NOT NULL,
	[bCreditDate] [bit] NOT NULL,
	[bCreditByHead] [bit] NOT NULL,
	[bLicenceDate] [bit] NOT NULL,
	[dLicenceSDate] [datetime] NULL,
	[dLicenceEDate] [datetime] NULL,
	[iLicenceADays] [int] NULL,
	[bBusinessDate] [bit] NOT NULL,
	[dBusinessSDate] [datetime] NULL,
	[dBusinessEDate] [datetime] NULL,
	[iBusinessADays] [int] NULL,
	[bProxy] [bit] NOT NULL,
	[dProxySDate] [datetime] NULL,
	[dProxyEDate] [datetime] NULL,
	[iProxyADays] [int] NULL,
	[cMemo] [nvarchar](1000) NULL,
	[bLimitSale] [bit] NOT NULL,
	[cCusContactCode] [uniqueidentifier] NULL,
	[cCusCountryCode] [nvarchar](10) NULL,
	[cCusEnName] [nvarchar](100) NULL,
	[cCusEnAddr1] [nvarchar](60) NULL,
	[cCusEnAddr2] [nvarchar](60) NULL,
	[cCusEnAddr3] [nvarchar](60) NULL,
	[cCusEnAddr4] [nvarchar](60) NULL,
	[cCusPortCode] [nvarchar](10) NULL,
	[cPrimaryVen] [nvarchar](20) NULL,
	[fCommisionRate] [float] NULL,
	[fInsueRate] [float] NULL,
	[bHomeBranch] [bit] NOT NULL,
	[cBranchAddr] [nvarchar](255) NULL,
	[cBranchPhone] [nvarchar](100) NULL,
	[cBranchPerson] [nvarchar](50) NULL,
	[cCusTradeCCode] [nvarchar](12) NULL,
	[CustomerKCode] [nvarchar](4) NULL,
	[bCusState] [bit] NOT NULL,
	[bShop] [smallint] NULL,
	[cCusBankCode] [nvarchar](50) NULL,
	[cCusExch_name] [nvarchar](50) NULL,
	[iCusGSPType] [smallint] NOT NULL,
	[iCusGSPAuth] [smallint] NULL,
	[cCusGSPAuthNo] [nvarchar](120) NULL,
	[cCusBusinessNo] [nvarchar](120) NULL,
	[cCusLicenceNo] [nvarchar](20) NULL,
	[bCusDomestic] [bit] NOT NULL,
	[bCusOverseas] [bit] NOT NULL,
	[cCusCreditCompany] [nvarchar](20) NULL,
	[cCusSAProtocol] [nvarchar](20) NULL,
	[cCusExProtocol] [nvarchar](20) NULL,
	[cCusOtherProtocol] [nvarchar](20) NULL,
	[fCusDiscountRate] [float] NULL,
	[cCusSSCode] [nvarchar](20) NULL,
	[cCusCMProtocol] [nvarchar](20) NULL,
	[dCusCreateDatetime] [datetime] NOT NULL,
	[cCusAppDocNo] [nvarchar](50) NULL,
	[cCusMnemCode] [nvarchar](98) NULL,
	[fAdvancePaymentRatio] [float] NULL,
	[bServiceAttribute] [bit] NOT NULL,
	[bRequestSign] [bit] NOT NULL,
	[bOnGPinStore] [bit] NULL,
	[cCusMngTypeCode] [nvarchar](32) NULL,
	[account_type] [numeric](22, 0) NULL,
	[cCusImAgentProtocol] [nvarchar](20) NULL,
	[iSourceType] [smallint] NULL,
	[iSourceId] [varchar](20) NULL,
	[fExpense] [float] NULL,
	[fApprovedExpense] [float] NULL,
	[dTouchedTime] [datetime] NULL,
	[dRecentlyInvoiceTime] [datetime] NULL,
	[dRecentlyQuoteTime] [datetime] NULL,
	[dRecentlyActivityTime] [datetime] NULL,
	[dRecentlyChanceTime] [datetime] NULL,
	[dRecentlyContractTime] [datetime] NULL,
	[cLtcCustomerCode] [nvarchar](100) NULL,
	[bTransFlag] [bit] NULL,
	[cLtcPerson] [nvarchar](40) NULL,
	[dLtcDate] [datetime] NULL,
	[cLocationSite] [nvarchar](128) NULL,
	[iCusTaxRate] [float] NULL,
	[alloct_dept_time] [datetime] NULL,
	[allot_user_time] [datetime] NULL,
	[recyle_dept_time] [datetime] NULL,
	[recyle_pub_time] [datetime] NULL,
	[cLicenceNo] [nvarchar](120) NULL,
	[cLicenceRange] [nvarchar](255) NULL,
	[cCusBusinessRange] [nvarchar](255) NULL,
	[cCusGSPAuthRange] [nvarchar](255) NULL,
	[dCusGSPEDate] [datetime] NULL,
	[dCusGSPSDate] [datetime] NULL,
	[iCusGSPADays] [int] NULL,
	[bIsCusAttachFile] [bit] NULL,
	[dRecentContractDate] [datetime] NULL,
	[dRecentDeliveryDate] [datetime] NULL,
	[dRecentOutboundDate] [datetime] NULL,
	[cProvince] [nvarchar](255) NULL,
	[cCity] [nvarchar](255) NULL,
	[cCounty] [nvarchar](255) NULL,
	[cCusAddressGUID] [uniqueidentifier] NULL,
	[cAddCode] [nvarchar](30) NULL,
	[cCreditAddCode] [nvarchar](18) NULL,
	[cRegCash] [nvarchar](60) NULL,
	[dDepBeginDate] [datetime] NULL,
	[iEmployeeNum] [int] NULL,
	[cURL] [nvarchar](50) NULL,
	[PictureGUID] [uniqueidentifier] NULL
)

alter table RdRecord08 add  newcode nvarchar(60) null
alter table RdRecord09 add  newcode nvarchar(60) null
alter table RdRecord01 add  newcode nvarchar(60) null
--alter table RdRecord32 add  newcode nvarchar(60) null
alter table so_somain add  newcode nvarchar(60) null
alter table po_pomain add  newcode nvarchar(60) null
alter table dispatchlist add  newcode nvarchar(60) null
alter table PU_ArrivalVouch add  newcode nvarchar(60) null



alter table transtime
add lasttime2 datetime

alter table rdrecords08
add text_flag bigint

alter table rdrecords09
add text_flag bigint
go

insert into transtime(entitytype) values('供应商')
insert into transtime(entitytype) values('仓库')
insert into transtime(entitytype) values('存货')
insert into transtime(entitytype) values('其他入库')
insert into transtime(entitytype) values('其他出库')
insert into transtime(entitytype) values('采购订单')
insert into transtime(entitytype) values('采购入库')
insert into transtime(entitytype) values('采购退货')
insert into transtime(entitytype) values('销售退货')
insert into transtime(entitytype) values('销售订单')
insert into transtime(entitytype) values('材料出库')
insert into transtime(entitytype) values('组装入库')
insert into transtime(entitytype) values('组装出库')
insert into transtime(entitytype) values('委外加工')
go

create index i_importdate on rdrecord08(importdate)
create index i_importdate on rdrecord09(importdate)
create index i_importdate on rdrecord01(importdate)
create index i_importdate on PU_ArrivalVouch(importdate)
create index i_importdate on PO_Pomain(importdate)
create index i_importdate on DispatchList(importdate)
create index i_importdate on SO_SOMain(importdate)
go

create index i_id on rdrecord08(id)
create index i_id on rdrecord09(id)
create index i_id on rdrecord01(id)
create index i_id on PU_ArrivalVouch(id)
create index i_id on PO_Pomain(poid)
create index i_id on DispatchList(dlid)
create index i_id on SO_SOMain(id)
go

create index i_id on rdrecords08(id)
create index i_id on rdrecords09(id)
create index i_id on rdrecords01(id)
create index i_id on PU_ArrivalVouchs(id)
create index i_id on PO_Podetails(poid)
create index i_id on DispatchLists(dlid)
create index i_id on SO_SOdetails(id)
go

alter table so_somain
add platform_id nvarchar(50)
go

alter table inventory add cInvDefine1 nvarchar(20)
alter table inventory add cInvDefine2 nvarchar(20)
alter table inventory add cInvDefine3 nvarchar(20)
alter table inventory add cInvDefine4 nvarchar(60)
alter table inventory add cInvDefine5 nvarchar(60)
alter table inventory add cInvDefine6 nvarchar(60)
alter table inventory add cInvDefine7 nvarchar(120)
alter table inventory add cInvDefine8 nvarchar(120)
alter table inventory add cInvDefine9 nvarchar(120)
alter table inventory add cInvDefine10 nvarchar(120)
alter table inventory add cInvDefine11 int
alter table inventory add cInvDefine12 int
alter table inventory add cInvDefine13 decimal(26,4)
alter table inventory add cInvDefine14 decimal(26,4)
alter table inventory add fRetailPrice decimal(26,4)
go

alter table vendor add contact nvarchar(30)
alter table vendor add phone nvarchar(100)
alter table vendor add mobile nvarchar(100)
alter table vendor add fax nvarchar(100)
alter table vendor add email nvarchar(100)
alter table vendor add cVenDefine11 int
alter table vendor add cVenDefine1  nvarchar(20)
alter table vendor add cVenDefine2  nvarchar(20)
alter table vendor add cVenDefine3  nvarchar(20)
alter table vendor add cVenDefine4  nvarchar(60)
alter table vendor add cVenDefine5  nvarchar(60)
alter table vendor add cVenDefine6  nvarchar(60)
alter table vendor add cVenDefine7  nvarchar(120)
alter table vendor add address  nvarchar(255)
alter table vendor add cmemo  nvarchar(240)
alter table vendor add bank_acc_number  nvarchar(120)
alter table vendor add bank_open  nvarchar(120)
go

--销售出库单
CREATE TABLE [dbo].[rdrecord32](
	[ID] [bigint] NOT NULL,
	[bRdFlag] [tinyint] NOT NULL,
	[cVouchType] [nvarchar](2) NOT NULL,
	[cBusType] [nvarchar](12) NULL,
	[cSource] [nvarchar](50) NOT NULL,
	[cBusCode] [nvarchar](30) NULL,
	[cWhCode] [nvarchar](10) NOT NULL,
	[dDate] [datetime] NOT NULL,
	[cCode] [nvarchar](30) NOT NULL,
	[cRdCode] [nvarchar](5) NULL,
	[cDepCode] [nvarchar](12) NULL,
	[cPersonCode] [nvarchar](20) NULL,
	[cPTCode] [nvarchar](2) NULL,
	[cSTCode] [nvarchar](2) NULL,
	[cCusCode] [nvarchar](20) NULL,
	[cVenCode] [nvarchar](20) NULL,
	[cOrderCode] [nvarchar](30) NULL,
	[cARVCode] [nvarchar](30) NULL,
	[cBillCode] [bigint] NULL,
	[cDLCode] [bigint] NULL,
	[cProBatch] [nvarchar](60) NULL,
	[cHandler] [nvarchar](20) NULL,
	[cMemo] [nvarchar](255) NULL,
	[bTransFlag] [bit] NOT NULL,
	[cAccounter] [nvarchar](20) NULL,
	[cMaker] [nvarchar](20) NULL,
	[cDefine1] [nvarchar](20) NULL,
	[cDefine2] [nvarchar](20) NULL,
	[cDefine3] [nvarchar](20) NULL,
	[cDefine4] [datetime] NULL,
	[cDefine5] [int] NULL,
	[cDefine6] [datetime] NULL,
	[cDefine7] [float] NULL,
	[cDefine8] [nvarchar](4) NULL,
	[cDefine9] [nvarchar](8) NULL,
	[cDefine10] [nvarchar](60) NULL,
	[dKeepDate] [nvarchar](5) NULL,
	[dVeriDate] [datetime] NULL,
	[bpufirst] [bit] NULL,
	[biafirst] [bit] NULL,
	[iMQuantity] [float] NULL,
	[dARVDate] [datetime] NULL,
	[cChkCode] [nvarchar](30) NULL,
	[dChkDate] [datetime] NULL,
	[cChkPerson] [nvarchar](40) NULL,
	[VT_ID] [int] NULL,
	[bIsSTQc] [bit] NOT NULL,
	[cDefine11] [nvarchar](120) NULL,
	[cDefine12] [nvarchar](120) NULL,
	[cDefine13] [nvarchar](120) NULL,
	[cDefine14] [nvarchar](120) NULL,
	[cDefine15] [int] NULL,
	[cDefine16] [float] NULL,
	[gspcheck] [nvarchar](10) NULL,
	[isalebillid] [nvarchar](30) NULL,
	[ufts] [timestamp] NULL,
	[iExchRate] [float] NULL,
	[cExch_Name] [nvarchar](8) NULL,
	[cShipAddress] [nvarchar](200) NULL,
	[caddcode] [nvarchar](60) NULL,
	[bOMFirst] [bit] NULL,
	[bFromPreYear] [bit] NULL,
	[bIsLsQuery] [bit] NULL,
	[bIsComplement] [smallint] NULL,
	[iDiscountTaxType] [tinyint] NULL,
	[ireturncount] [int] NULL,
	[iverifystate] [int] NULL,
	[iswfcontrolled] [int] NULL,
	[cModifyPerson] [nvarchar](50) NULL,
	[dModifyDate] [datetime] NULL,
	[dnmaketime] [datetime] NULL,
	[dnmodifytime] [datetime] NULL,
	[dnverifytime] [datetime] NULL,
	[bredvouch] [int] NULL,
	[iFlowId] [int] NULL,
	[cPZID] [nvarchar](30) NULL,
	[cSourceLs] [nvarchar](4) NULL,
	[cSourceCodeLs] [nvarchar](20) NULL,
	[iPrintCount] [int] NULL,
	[csysbarcode] [nvarchar](60) NULL,
	[cCurrentAuditor] [nvarchar](200) NULL,
	[cinvoicecompany] [nvarchar](20) NULL,
	[fEBweight] [decimal](30, 9) NULL,
	[cEBweightUnit] [nvarchar](50) NULL,
	[cEBExpressCode] [nvarchar](50) NULL,
	[bScanExpress] [tinyint] NULL,
	[cinspector] [nvarchar](40) NULL,
	[dinspecttime] [datetime] NULL,
	[cweighter] [nvarchar](40) NULL,
	[dweighttime] [datetime] NULL,
	[bUpLoaded] [tinyint] NULL,
	[outid] [uniqueidentifier] NULL,
	[isMDdispatch] [tinyint] NULL,
	[cCheckSignFlag] [nvarchar](36) NULL,
	[cGCRouteCode] [nvarchar](40) NULL,
	sysid int identity(1,1),
	importdate datetime null default(getdate()),
	processdate datetime null,
	processflag bit default(0),
	direction int default(0),    --0：从U8到中间库，1：从旺店通到中间库
)
create index i_id on rdrecord32(id)
GO

CREATE TABLE [dbo].[rdrecords32](
	[AutoID] [bigint] NOT NULL,
	[ID] [bigint] NOT NULL,
	[cInvCode] [nvarchar](60) NOT NULL,
	[iNum] [decimal](30, 10) NULL,
	[iQuantity] [decimal](30, 10) NULL,
	[iUnitCost] [decimal](30, 10) NULL,
	[iPrice] [money] NULL,
	[iAPrice] [money] NULL,
	[iPUnitCost] [decimal](30, 10) NULL,
	[iPPrice] [money] NULL,
	[cBatch] [nvarchar](60) NULL,
	[cVouchCode] [bigint] NULL,
	[cInVouchCode] [nvarchar](30) NULL,
	[cinvouchtype] [nvarchar](2) NULL,
	[iSOutQuantity] [decimal](30, 10) NULL,
	[iSOutNum] [decimal](30, 10) NULL,
	[coutvouchid] [bigint] NULL,
	[coutvouchtype] [nvarchar](2) NULL,
	[iSRedOutQuantity] [decimal](30, 10) NULL,
	[iSRedOutNum] [decimal](30, 10) NULL,
	[cFree1] [nvarchar](20) NULL,
	[cFree2] [nvarchar](20) NULL,
	[iFlag] [tinyint] NOT NULL,
	[iFNum] [decimal](30, 10) NULL,
	[iFQuantity] [decimal](30, 10) NULL,
	[dVDate] [datetime] NULL,
	[cPosition] [nvarchar](20) NULL,
	[cDefine22] [nvarchar](60) NULL,
	[cDefine23] [nvarchar](60) NULL,
	[cDefine24] [nvarchar](60) NULL,
	[cDefine25] [nvarchar](60) NULL,
	[cDefine26] [float] NULL,
	[cDefine27] [float] NULL,
	[cItem_class] [nvarchar](10) NULL,
	[cItemCode] [nvarchar](60) NULL,
	[iDLsID] [bigint] NULL,
	[iSBsID] [bigint] NULL,
	[iSendQuantity] [decimal](30, 10) NULL,
	[iSendNum] [decimal](30, 10) NULL,
	[iEnsID] [int] NULL,
	[cName] [nvarchar](255) NULL,
	[cItemCName] [nvarchar](20) NULL,
	[cFree3] [nvarchar](20) NULL,
	[cFree4] [nvarchar](20) NULL,
	[cFree5] [nvarchar](20) NULL,
	[cFree6] [nvarchar](20) NULL,
	[cFree7] [nvarchar](20) NULL,
	[cFree8] [nvarchar](20) NULL,
	[cFree9] [nvarchar](20) NULL,
	[cFree10] [nvarchar](20) NULL,
	[cBarCode] [nvarchar](200) NULL,
	[iNQuantity] [decimal](30, 10) NULL,
	[iNNum] [decimal](30, 10) NULL,
	[cAssUnit] [nvarchar](35) NULL,
	[dMadeDate] [datetime] NULL,
	[iMassDate] [int] NULL,
	[cDefine28] [nvarchar](120) NULL,
	[cDefine29] [nvarchar](120) NULL,
	[cDefine30] [nvarchar](120) NULL,
	[cDefine31] [nvarchar](120) NULL,
	[cDefine32] [nvarchar](120) NULL,
	[cDefine33] [nvarchar](120) NULL,
	[cDefine34] [int] NULL,
	[cDefine35] [int] NULL,
	[cDefine36] [datetime] NULL,
	[cDefine37] [datetime] NULL,
	[iCheckIds] [bigint] NULL,
	[cBVencode] [nvarchar](20) NULL,
	[bGsp] [bit] NULL,
	[cGspState] [nvarchar](20) NULL,
	[cCheckCode] [nvarchar](30) NULL,
	[iCheckIdBaks] [bigint] NULL,
	[cRejectCode] [nvarchar](30) NULL,
	[iRejectIds] [bigint] NULL,
	[cCheckPersonCode] [nvarchar](20) NULL,
	[dCheckDate] [datetime] NULL,
	[cMassUnit] [smallint] NULL,
	[iRefundInspectFlag] [tinyint] NULL,
	[strContractId] [nvarchar](64) NULL,
	[strCode] [nvarchar](150) NULL,
	[bChecked] [bit] NULL,
	[iEqDID] [int] NULL,
	[bLPUseFree] [bit] NULL,
	[iRSRowNO] [int] NULL,
	[iOriTrackID] [bigint] NULL,
	[coritracktype] [nvarchar](2) NULL,
	[cbaccounter] [nvarchar](30) NULL,
	[dbKeepDate] [datetime] NULL,
	[bCosting] [bit] NULL,
	[bVMIUsed] [bit] NULL,
	[iVMISettleQuantity] [decimal](30, 10) NULL,
	[iVMISettleNum] [decimal](30, 10) NULL,
	[cvmivencode] [nvarchar](20) NULL,
	[iInvSNCount] [int] NULL,
	[cwhpersoncode] [nvarchar](20) NULL,
	[cwhpersonname] [nvarchar](50) NULL,
	[cserviceoid] [varchar](38) NULL,
	[cbserviceoid] [varchar](38) NULL,
	[iinvexchrate] [decimal](38, 8) NULL,
	[cbdlcode] [nvarchar](30) NULL,
	sysid int identity(1,1)
)
create index i_id on rdrecords32(id)

go