Epicor自建表在Function，BPM，BAQ中的使用-YES开发框架网

一、新建测试表

分别在dbo、erp、ice三个schema中个创建两个表分别观察结果用来对比

区别是

默认表包含了三个标准字段：Company、SysRowID、SysRevID

表2没有包含Company：SysRowID、SysRevID

SQL语句如下：

SQL 全选

CREATE TABLE dbo.ZGarsonTestDbo (
	Company nvarchar(8) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestDbo PRIMARY KEY (SysRowID)
);

CREATE TABLE dbo.ZGarsonTestDbo2 (
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestDbo2 PRIMARY KEY (SysRowID)
);

CREATE TABLE ice.ZGarsonTestIce (
	Company nvarchar(8) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestIce PRIMARY KEY (SysRowID)
);

CREATE TABLE ice.ZGarsonTestIce2 (
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestIce2 PRIMARY KEY (SysRowID)
);

CREATE TABLE erp.ZGarsonTestErp (
	Company nvarchar(8) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestErp PRIMARY KEY (SysRowID)
);

CREATE TABLE erp.ZGarsonTestErp2 (
	id varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	UserName varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	Age int NOT NULL,
	Birthday date NOT NULL,
	IsAdmin bit NOT NULL,
	SysRowID uniqueidentifier NOT NULL,
	SysRevID timestamp NOT NULL,
	CONSTRAINT PK_ZGarsonTestErp2 PRIMARY KEY (SysRowID)
);