⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 compiere.sql

📁 Java写的ERP系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_Error 
--

CREATE TABLE AD_Error(
	AD_Error_ID		NUMBER(10, 0)	   NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	   NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	   NOT NULL,
	IsActive		CHAR(1)				DEFAULT 'Y' NOT NULL,
	Created			DATE				DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	   NOT NULL,
	Updated			DATE				DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	   NOT NULL,
	Name			NVARCHAR2(60)	   NOT NULL,
	Code			NVARCHAR2(2000),
	AD_Language		VARCHAR2(6),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Error_Key PRIMARY KEY (AD_Error_ID)
) 
;


COMMENT ON COLUMN AD_Error.AD_Error_ID IS 'ID is generated from Sequence'
;
-- 
-- TABLE: AD_FieldGroup 
--

CREATE TABLE AD_FieldGroup(
	AD_FieldGroup_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID			NUMBER(10, 0)	 NOT NULL,
	IsActive			CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created				DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy			NUMBER(10, 0)	 NOT NULL,
	Updated				DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy			NUMBER(10, 0)	 NOT NULL,
	Name				NVARCHAR2(60)	 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_FieldGroup_Key PRIMARY KEY (AD_FieldGroup_ID)
) 
;


-- 
-- TABLE: AD_FieldGroup_Trl 
--

CREATE TABLE AD_FieldGroup_Trl(
	AD_FieldGroup_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Language			VARCHAR2(6)		 NOT NULL,
	AD_Client_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID			NUMBER(10, 0)	 NOT NULL,
	IsActive			CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created				DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy			NUMBER(10, 0)	 NOT NULL,
	Updated				DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy			NUMBER(10, 0)	 NOT NULL,
	Name				NVARCHAR2(60)	 NOT NULL,
	IsTranslated		CHAR(1)			  DEFAULT 'N' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsTranslated in ('Y','N')),
	CONSTRAINT AD_FieldGroup_Trl_Key PRIMARY KEY (AD_FieldGroup_ID, AD_Language)
) 
;


-- 
-- TABLE: AD_Find 
--

CREATE TABLE AD_Find(
	AD_Find_ID		NUMBER(10, 0)	 NOT NULL,
	Find_ID			NUMBER			 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	AndOr			CHAR(1)			 NOT NULL,
	AD_Column_ID	NUMBER(10, 0)	 NOT NULL,
	Operation		CHAR(2)			 NOT NULL,
	Value			NVARCHAR2(40)	 NOT NULL,
	Value2			NVARCHAR2(40),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Find_Key PRIMARY KEY (AD_Find_ID)
	USING INDEX
TABLESPACE INDX
) 
CACHE
;


COMMENT ON TABLE AD_Find IS 'Search Window'
;
-- 
-- TABLE: AD_Form 
--

CREATE TABLE AD_Form(
	AD_Form_ID		NUMBER(10, 0)	   NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	   NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	   NOT NULL,
	IsActive		CHAR(1)				DEFAULT 'Y' NOT NULL,
	Created			DATE				DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	   NOT NULL,
	Updated			DATE				DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	   NOT NULL,
	Name			NVARCHAR2(60)	   NOT NULL,
	Description		NVARCHAR2(255),
	Help			NVARCHAR2(2000),
	EntityType		CHAR(1)				DEFAULT 'D' NOT NULL,
	AccessLevel		CHAR(1)			   NOT NULL,
	ClassName		NVARCHAR2(40)	   NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Form_Key PRIMARY KEY (AD_Form_ID)
) 
;


-- 
-- TABLE: AD_Form_Access 
--

CREATE TABLE AD_Form_Access(
	AD_Form_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Role_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	IsReadWrite		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsReadWrite in ('Y','N')),
	CONSTRAINT AD_Form_Access_Key PRIMARY KEY (AD_Form_ID, AD_Role_ID)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_Form_Trl 
--

CREATE TABLE AD_Form_Trl(
	AD_Form_ID		NUMBER(10, 0)	   NOT NULL,
	AD_Language		VARCHAR2(6)		   NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	   NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	   NOT NULL,
	IsActive		CHAR(1)				DEFAULT 'Y' NOT NULL,
	Created			DATE				DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	   NOT NULL,
	Updated			DATE				DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	   NOT NULL,
	Name			NVARCHAR2(60)	   NOT NULL,
	Description		NVARCHAR2(255),
	Help			NVARCHAR2(2000),
	IsTranslated	CHAR(1)				DEFAULT 'N' NOT NULL,
	CHECK (IsTranslated in ('Y','N')),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Form_Trl_Key PRIMARY KEY (AD_Form_ID, AD_Language)
) 
;


-- 
-- TABLE: AD_Image 
--

CREATE TABLE AD_Image(
	AD_Image_ID		NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	  NOT NULL,
	IsActive		CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created			DATE			   DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	  NOT NULL,
	Updated			DATE			   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	  NOT NULL,
	Name			NVARCHAR2(60)	  NOT NULL,
	ImageURL		NVARCHAR2(120),
	BinaryData		BLOB,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Image_Key PRIMARY KEY (AD_Image_ID)
) 
;


-- 
-- TABLE: AD_ImpFormat 
--

CREATE TABLE AD_ImpFormat(
	AD_ImpFormat_ID	   NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	   NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		   NUMBER(10, 0)	 NOT NULL,
	IsActive		   CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			   DATE				  DEFAULT SYSDATE NOT NULL,
	CreatedBy		   NUMBER(10, 0)	 NOT NULL,
	Updated			   DATE				  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		   NUMBER(10, 0)	 NOT NULL,
	Name			   NVARCHAR2(60)	 NOT NULL,
	Description		   NVARCHAR2(255),
	AD_Table_ID		   NUMBER(10, 0)	 NOT NULL,
	FormatType		   CHAR(1)			 NOT NULL,
	Processing		   CHAR(1)			 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_ImpFormat_Key PRIMARY KEY (AD_ImpFormat_ID)
	USING INDEX
TABLESPACE INDX
) 
;


COMMENT ON COLUMN AD_ImpFormat.AD_Table_ID IS 'AD_Table_ID Definition'
;
COMMENT ON COLUMN AD_ImpFormat.FormatType IS 'F=Fixed, C=Comma, T=Tab, X=XML'
;
-- 
-- TABLE: AD_ImpFormat_Row 
--

CREATE TABLE AD_ImpFormat_Row(
	AD_ImpFormat_Row_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID		   NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID			   NUMBER(10, 0)	  NOT NULL,
	IsActive			   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created				   DATE				   DEFAULT SYSDATE NOT NULL,
	CreatedBy			   NUMBER(10, 0)	  NOT NULL,
	Updated				   DATE				   DEFAULT SYSDATE NOT NULL,
	UpdatedBy			   NUMBER(10, 0)	  NOT NULL,
	AD_ImpFormat_ID		   NUMBER(10, 0)	  NOT NULL,
	SeqNo				   NUMBER(10, 0)	  NOT NULL,
	Name				   NVARCHAR2(60)	  NOT NULL,
	AD_Column_ID		   NUMBER(10, 0)	  NOT NULL,
	StartNo				   NUMBER(10, 0),
	EndNo				   NUMBER(10, 0),
	DataType			   CHAR(1)			  NOT NULL,
	DataFormat			   NVARCHAR2(20),
	DecimalPoint		   CHAR(1)			  NOT NULL,
	DivideBy100			   CHAR(1)			   DEFAULT 'N' NOT NULL,
	ConstantValue		   NVARCHAR2(60),
	Callout				   NVARCHAR2(60),
	Script				   NVARCHAR2(2000),
	CHECK (IsActive in ('Y','N')),
	CHECK (DivideBy100 in ('Y','N')),
	CONSTRAINT AD_ImpFormat_Row_Key PRIMARY KEY (AD_ImpFormat_Row_ID)
	USING INDEX
TABLESPACE INDX
) 
;


COMMENT ON COLUMN AD_ImpFormat_Row.DataType IS '(S)tring, (N)umber, (D)ate'
;
COMMENT ON COLUMN AD_ImpFormat_Row.DataFormat IS 'ddMMyy - Java Date Format String'
;
COMMENT ON COLUMN AD_ImpFormat_Row.DecimalPoint IS 'Default .'
;
COMMENT ON COLUMN AD_ImpFormat_Row.DivideBy100 IS 'If number - divide by 100'
;
-- 
-- TABLE: AD_Note 
--

CREATE TABLE AD_Note(
	AD_Note_ID		 NUMBER(10, 0)		NOT NULL,
	AD_Client_ID	 NUMBER(10, 0)		NOT NULL,
	AD_Org_ID		 NUMBER(10, 0)		NOT NULL,
	IsActive		 CHAR(1)			 DEFAULT 'Y' NOT NULL,
	Created			 DATE				 DEFAULT SYSDATE NOT NULL,
	CreatedBy		 NUMBER(10, 0)		NOT NULL,
	Updated			 DATE				 DEFAULT SYSDATE NOT NULL,
	UpdatedBy		 NUMBER(10, 0)		NOT NULL,
	AD_User_ID		 NUMBER(10, 0),
	AD_Message_ID	 NUMBER(10, 0)		NOT NULL,
	Reference		 NVARCHAR2(60),
	AD_Table_ID		 NUMBER(10, 0),
	Record_ID		 NUMBER(10, 0),
	Text			 NVARCHAR2(2000),
	Processed		 CHAR(1)			 DEFAULT 'N',
	CHECK (IsActive in ('Y','N')),
	CHECK (Processed in ('Y','N')),
	CONSTRAINT AD_Note_Key PRIMARY KEY (AD_Note_ID)
) 
;


COMMENT ON COLUMN AD_Note.AD_Table_ID IS 'AD_Table_ID Definition'
;
-- 
-- TABLE: AD_OrgInfo 
--

CREATE TABLE AD_OrgInfo(
	AD_Org_ID		 NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	 NUMBER(10, 0)	  NOT NULL,
	IsActive		 CHAR(1)		   DEFAULT 'Y' NOT NULL,
	Created			 DATE			   DEFAULT SYSDATE NOT NULL,
	CreatedBy		 NUMBER(10, 0)	  NOT NULL,
	Updated			 DATE			   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		 NUMBER(10, 0)	  NOT NULL,
	C_Location_ID	 NUMBER(10, 0),
	DUNS			 CHAR(11)		  NOT NULL,
	TaxID			 VARCHAR2(20)	  NOT NULL,
	PA_Goal_ID		 NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_OrgInfo_Key PRIMARY KEY (AD_Org_ID)
) 
;


-- 
-- TABLE: AD_PInstance 
--

CREATE TABLE AD_PInstance(
	AD_PInstance_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Process_ID	   NUMBER(10, 0)	  NOT NULL,
	Record_ID		   NUMBER(10, 0)	  NOT NULL,
	IsProcessing	   CHAR(1)			   DEFAULT 'N' NOT NULL,
	Created			   DATE				   DEFAULT SYSDATE NOT NULL,
	AD_User_ID		   NUMBER(10, 0),
	Updated			   DATE				   DEFAULT SYSDATE,
	Result			   NUMBER(10, 0),
	ErrorMsg		   NVARCHAR2(2000),
	CHECK (IsProcessing in ('Y','N')),
	CONSTRAINT AD_PInstance_Key PRIMARY KEY (AD_PInstance_ID)
	USING INDEX
TABLESPACE INDX
) 
;


COMMENT ON TABLE AD_PInstance IS 'Internal Process Table'
;
COMMENT ON COLUMN AD_PInstance.Result IS '0 = Error, 1 = Success'
;
COMMENT ON COLUMN AD_PInstance.ErrorMsg IS 'Not just Error Messages'
;
-- 
-- TABLE: AD_PInstance_Log 
--

CREATE TABLE AD_PInstance_Log(
	AD_PInstance_ID	   NUMBER(10, 0)	  NOT NULL,
	Log_ID			   NUMBER(10, 0)	  NOT NULL,
	P_Date			   DATE				   DEFAULT SYSDATE,
	P_ID			   NUMBER(10, 0),
	P_Number		   NUMBER,
	P_Msg			   NVARCHAR2(2000),
	CONSTRAINT AD_PInstance_Log_Key PRIMARY KEY (AD_PInstance_ID, Log_ID)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_PInstance_Para 
--

CREATE TABLE AD_PInstance_Para(
	AD_PInstance_ID	   NUMBER(10, 0)	NOT NULL,
	SeqNo			   NUMBER(10, 0)	NOT NULL,
	ParameterName	   NVARCHAR2(60),
	P_String		   NVARCHAR2(60),
	P_String_To		   NVARCHAR2(60),
	P_Number		   NUMBER			 DEFAULT 0,
	P_Number_To		   NUMBER			 DEFAULT 0,
	P_Date			   DATE,
	P_Date_To		   DATE,
	Info			   NVARCHAR2(60),
	Info_To			   NVARCHAR2(60),
	CONSTRAINT AD_PInstance_Para_Key PRIMARY KEY (AD_PInstance_ID, SeqNo)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_Preference 
--

CREATE TABLE AD_Preference(
	AD_Preference_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID			NUMBER(10, 0)	 NOT NULL,
	IsActive			CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created				DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy			NUMBER(10, 0)	 NOT NULL,
	Updated				DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy			NUMBER(10, 0)	 NOT NULL,
	AD_Window_ID		NUMBER(10, 0),
	AD_User_ID			NUMBER(10, 0),
	Attribute			NVARCHAR2(60)	 NOT NULL,
	Value				NVARCHAR2(60)	 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Preference_Key PRIMARY KEY (AD_Preference_ID)
) 
;


-- 
-- TABLE: AD_PrintColor 
--

CREATE TABLE AD_PrintColor(
	AD_PrintColor_ID	NUMBER(10, 0)	   NOT NULL,
	AD_Client_ID		NUMBER(10, 0)	   NOT NULL,
	AD_Org_ID			NUMBER(10, 0)	   NOT NULL,
	IsActive			CHAR(1)				DEFAULT 'Y' NOT NULL,
	Created				DATE				DEFAULT SYSDATE NOT NULL,
	CreatedBy			NUMBER(10, 0)	   NOT NULL,
	Updated				DATE				DEFAULT SYSDATE NOT NULL,
	UpdatedBy			NUMBER(10, 0)	   NOT NULL,
	Name				NVARCHAR2(60)	   NOT NULL,
	IsDefault			CHAR(1)				DEFAULT 'N' NOT NULL,
	Code				NVARCHAR2(2000)	   NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_PrintColor_Key PRIMARY KEY (AD_PrintColor_ID)
) 
;


-- 
-- TABLE: AD_PrintFont 
--

CREATE TABLE AD_PrintFont(
	AD_PrintFont_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		   NUMBER(10, 0)	  NOT NULL,
	IsActive		   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created			   DATE				   DEFAULT SYSDATE NOT NULL,
	CreatedBy		   NUMBER(10, 0)	  NOT NULL,
	Updated			   DATE				   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		   NUMBER(10, 0)	  NOT NULL,
	Name			   NVARCHAR2(60)	  NOT NULL,
	IsDefault		   CHAR(1)			   DEFAULT 'N' NOT NULL,
	Code			   NVARCHAR2(2000)	  NOT NULL,
	CHECK (IsActive in ('Y','N')),
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -