51 lines
1.5 KiB
Transact-SQL
51 lines
1.5 KiB
Transact-SQL
|
|
|
|
/****** 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
|
|
|
|
|