/****** Object:  Table [dbo].[ZZZ_SalesRportShareData]    Script Date: 2025/3/19 10:16:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ZZZ_SalesRportShareData](
	[销售单主键ID] [INT] NULL,
	[销售员ID] [INT] NULL,
	[F_RecConditionId] [INT] NULL,
	[整单订单总额] [DECIMAL](18, 2) NULL,
	[销售员] [NVARCHAR](50) NULL,
	[分摊比例] [DECIMAL](18, 2) NULL,
	[分摊金额] [DECIMAL](18, 6) NULL,
	[SBU] [NVARCHAR](200) NULL,
	[明细区域] [NVARCHAR](100) NULL,
	[购货单位] [NVARCHAR](255) NULL,
	[公司性质] [NVARCHAR](255) NULL,
	[客户信用] [NVARCHAR](255) NULL,
	[纸质合同号] [NVARCHAR](1000) NULL,
	[项目名称] [NVARCHAR](255) NULL,
	[签订年份] [NVARCHAR](10) NULL,
	[订单日期] [DATETIME] NULL,
	[发货日期] [DATETIME] NULL,
	[整单累计发货金额] [DECIMAL](38, 10) NULL,
	[开票日期] [DATETIME] NULL,
	[整单累计退货金额] [DECIMAL](38, 10) NULL,
	[整单累计开票金额] [DECIMAL](18, 6) NULL,
	[整单累计到款金额] [DECIMAL](38, 10) NULL,
	[订单总额] [DECIMAL](18, 6) NULL,
	[累计发货金额] [DECIMAL](18, 6) NULL,
	[累计退货金额] [DECIMAL](18, 6) NULL,
	[累计开票金额] [DECIMAL](18, 6) NULL,
	[应收款合计] [DECIMAL](18, 6) NULL,
	[累计到款金额] [DECIMAL](18, 6) NULL,
	[组织ID] [INT] NULL,
	[销售订单编号] [NVARCHAR](500) NULL,
	[收款条件主键ID] [INT] NULL,
	[收款条件] [NVARCHAR](205) NULL,
	[应收单日期] [DATETIME] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ZZZ_SalesRportShareData] ADD  CONSTRAINT [DF_ZZZ_SalesRportShareData_开票日期]  DEFAULT (NULL) FOR [开票日期]
GO