📄 compiere.sql
字号:
CONSTRAINT AD_PrintFont_Key PRIMARY KEY (AD_PrintFont_ID)
)
;
--
-- TABLE: AD_PrintForm
--
CREATE TABLE AD_PrintForm(
AD_PrintForm_ID NUMBER(10, 0) NOT NULL,
AD_Client_ID NUMBER(10, 0),
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),
Order_PrintFormat_ID NUMBER(10, 0),
Invoice_PrintFormat_ID NUMBER(10, 0),
Shipment_PrintFormat_ID NUMBER(10, 0),
Remittance_PrintFormat_ID NUMBER(10, 0),
Order_MailText_ID NUMBER(10, 0),
Invoice_MailText_ID NUMBER(10, 0),
Shipment_MailText_ID NUMBER(10, 0),
Remittance_MailText_ID NUMBER(10, 0),
CHECK (IsActive in ('Y','N')),
CONSTRAINT AD_PrintForm_Key PRIMARY KEY (AD_PrintForm_ID)
)
;
--
-- TABLE: AD_PrintFormat
--
CREATE TABLE AD_PrintFormat(
AD_PrintFormat_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),
IsTableBased CHAR(1) DEFAULT 'Y' NOT NULL,
IsForm CHAR(1) DEFAULT 'N' NOT NULL,
AD_ReportView_ID NUMBER(10, 0),
AD_Table_ID NUMBER(10, 0) NOT NULL,
AD_PrintPaper_ID NUMBER(10, 0) NOT NULL,
AD_PrintColor_ID NUMBER(10, 0) NOT NULL,
AD_PrintFont_ID NUMBER(10, 0) NOT NULL,
IsStandardHeaderFooter CHAR(1) DEFAULT 'Y' NOT NULL,
HeaderMargin NUMBER(10, 0) NOT NULL,
FooterMargin NUMBER(10, 0) NOT NULL,
CreateCopy CHAR(1),
AD_PrintTableFormat_ID NUMBER(10, 0),
CHECK (IsActive in ('Y','N')),
CHECK (IsTableBased in ('Y','N')),
CHECK (IsForm in ('Y','N')),
CHECK (IsStandardHeaderFooter in ('Y','N')),
CONSTRAINT AD_PrintFormat_Key PRIMARY KEY (AD_PrintFormat_ID)
)
;
COMMENT ON COLUMN AD_PrintFormat.AD_ReportView_ID IS 'XML Report Definition'
;
COMMENT ON COLUMN AD_PrintFormat.AD_Table_ID IS 'AD_Table_ID Definition'
;
--
-- TABLE: AD_PrintFormatItem
--
CREATE TABLE AD_PrintFormatItem(
AD_PrintFormatItem_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_PrintFormat_ID NUMBER(10, 0) NOT NULL,
Name NVARCHAR2(60) NOT NULL,
PrintName NVARCHAR2(2000),
IsPrinted CHAR(1) DEFAULT 'Y' NOT NULL,
IsSuppressNull CHAR(1) DEFAULT 'N' NOT NULL,
PrintAreaType CHAR(1) NOT NULL,
SeqNo NUMBER(10, 0) NOT NULL,
PrintFormatType CHAR(1) NOT NULL,
AD_Column_ID NUMBER(10, 0),
AD_PrintFormatChild_ID NUMBER(10, 0),
AD_PrintGraph_ID NUMBER(10, 0),
IsRelativePosition CHAR(1) DEFAULT 'Y' NOT NULL,
IsNextLine CHAR(1) DEFAULT 'Y' NOT NULL,
IsNextPage CHAR(1) DEFAULT 'N' NOT NULL,
BelowColumn NUMBER(10, 0),
IsSetNLPosition CHAR(1) DEFAULT 'N' NOT NULL,
Xspace NUMBER(10, 0) NOT NULL,
Yspace NUMBER(10, 0) NOT NULL,
Xposition NUMBER(10, 0) NOT NULL,
Yposition NUMBER(10, 0) NOT NULL,
MaxWidth NUMBER(10, 0) NOT NULL,
IsHeightOneLine CHAR(1) DEFAULT 'Y' NOT NULL,
MaxHeight NUMBER(10, 0) NOT NULL,
IsFixedWidth CHAR(1) DEFAULT 'N' NOT NULL,
FieldAlignmentType CHAR(1) NOT NULL,
LineAlignmentType CHAR(1) NOT NULL,
AD_PrintColor_ID NUMBER(10, 0),
AD_PrintFont_ID NUMBER(10, 0),
IsOrderBy CHAR(1) DEFAULT 'N' NOT NULL,
SortNo NUMBER(10, 0) NOT NULL,
IsGroupBy CHAR(1) DEFAULT 'N' NOT NULL,
IsPageBreak CHAR(1) DEFAULT 'N' NOT NULL,
IsSummarized CHAR(1) DEFAULT 'N' NOT NULL,
IsCounted CHAR(1) DEFAULT 'N' NOT NULL,
IsAveraged CHAR(1) DEFAULT 'N' NOT NULL,
ImageIsAttached CHAR(1) DEFAULT 'N' NOT NULL,
ImageURL NVARCHAR2(120),
CHECK (IsActive in ('Y','N')),
CHECK (IsPrinted in ('Y','N')),
CHECK (IsSuppressNull in ('Y','N')),
CHECK (IsRelativePosition in ('Y','N')),
CHECK (IsNextLine in ('Y','N')),
CHECK (IsNextPage in ('Y','N')),
CHECK (IsSetNLPosition in ('Y','N')),
CHECK (IsHeightOneLine in ('Y','N')),
CHECK (IsFixedWidth in ('Y','N')),
CHECK (IsOrderBy in ('Y','N')),
CHECK (IsGroupBy in ('Y','N')),
CHECK (IsPageBreak in ('Y','N')),
CHECK (IsSummarized in ('Y','N')),
CHECK (IsCounted in ('Y','N')),
CHECK (IsAveraged in ('Y','N')),
CHECK (ImageIsAttached in ('Y','N')),
CONSTRAINT AS_PrintFormatItem_Key PRIMARY KEY (AD_PrintFormatItem_ID)
)
;
--
-- TABLE: AD_PrintFormatItem_Trl
--
CREATE TABLE AD_PrintFormatItem_Trl(
AD_PrintFormatItem_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,
PrintName NVARCHAR2(2000),
IsTranslated CHAR(1) DEFAULT 'N' NOT NULL,
CHECK (IsActive in ('Y','N')),
CHECK (IsTranslated in ('Y','N')),
CONSTRAINT AD_PrintFormatItem_Trl_Key PRIMARY KEY (AD_PrintFormatItem_ID, AD_Language)
USING INDEX
TABLESPACE INDX
)
;
--
-- TABLE: AD_PrintGraph
--
CREATE TABLE AD_PrintGraph(
AD_PrintGraph_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_PrintFormat_ID NUMBER(10, 0) NOT NULL,
Name NVARCHAR2(60) NOT NULL,
Description NVARCHAR2(255),
GraphType CHAR(1) NOT NULL,
Description_PrintFormatItem_ID NUMBER(10, 0) NOT NULL,
Data_PrintFormatItem_ID NUMBER(10, 0) NOT NULL,
Data1_PrintFormatItem_ID NUMBER(10, 0),
Data2_PrintFormatItem_ID NUMBER(10, 0),
Data3_PrintFormatItem_ID NUMBER(10, 0),
Data4_PrintFormatItem_ID NUMBER(10, 0),
CHECK (IsActive in ('Y','N')),
CONSTRAINT AD_PrintGraph_Key PRIMARY KEY (AD_PrintGraph_ID)
USING INDEX
TABLESPACE INDX
)
;
--
-- TABLE: AD_PrintPaper
--
CREATE TABLE AD_PrintPaper(
AD_PrintPaper_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),
IsDefault CHAR(1) DEFAULT 'N' NOT NULL,
IsLandscape CHAR(1) DEFAULT 'Y' NOT NULL,
Code NVARCHAR2(2000) NOT NULL,
MarginTop NUMBER(10, 0) DEFAULT 36 NOT NULL,
MarginLeft NUMBER(10, 0) DEFAULT 36 NOT NULL,
MarginRight NUMBER(10, 0) DEFAULT 36 NOT NULL,
MarginBottom NUMBER(10, 0) DEFAULT 36 NOT NULL,
Processing CHAR(1),
CHECK (IsActive in ('Y','N')),
CHECK (IsLandscape in ('Y','N')),
CONSTRAINT AD_PrintPaper_Key PRIMARY KEY (AD_PrintPaper_ID)
)
;
COMMENT ON COLUMN AD_PrintPaper.Code IS 'MediaSize'
;
--
-- TABLE: AD_PrintTableFormat
--
CREATE TABLE AD_PrintTableFormat(
AD_PrintTableFormat_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),
Hdr_PrintFont_ID NUMBER(10, 0),
HdrTextFG_PrintColor_ID NUMBER(10, 0),
HdrTextBG_PrintColor_ID NUMBER(10, 0),
HdrLine_PrintColor_ID NUMBER(10, 0),
Funct_PrintFont_ID NUMBER(10, 0),
FunctFG_PrintColor_ID NUMBER(10, 0),
FunctBG_PrintColor_ID NUMBER(10, 0),
Line_PrintColor_ID NUMBER(10, 0),
IsPaintBoundaryLines CHAR(1) DEFAULT 'N' NOT NULL,
IsPaintVLines CHAR(1) DEFAULT 'N' NOT NULL,
IsPaintHLines CHAR(1) DEFAULT 'N' NOT NULL,
IsPrintFunctionSymbols CHAR(1) DEFAULT 'Y' NOT NULL,
CHECK (IsActive in ('Y','N')),
CHECK (IsPaintBoundaryLines in ('Y','N')),
CHECK (IsPaintVLines in ('Y','N')),
CHECK (IsPaintHLines in ('Y','N')),
CHECK (IsPrintFunctionSymbols in ('Y','N')),
CONSTRAINT AD_PrintTableFormat_Key PRIMARY KEY (AD_PrintTableFormat_ID)
USING INDEX
TABLESPACE INDX
)
;
--
-- TABLE: AD_Process
--
CREATE TABLE AD_Process(
AD_Process_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,
Value NVARCHAR2(40) NOT NULL,
Name NVARCHAR2(60) NOT NULL,
Description NVARCHAR2(255),
Help NVARCHAR2(2000),
AccessLevel CHAR(1) NOT NULL,
EntityType CHAR(1) DEFAULT 'D' NOT NULL,
IsUserStartable CHAR(1) DEFAULT 'Y' NOT NULL,
ProcedureName NVARCHAR2(60),
IsReport CHAR(1) DEFAULT 'Y' NOT NULL,
IsDirectPrint CHAR(1) DEFAULT 'N',
ClassName NVARCHAR2(60),
AD_ReportView_ID NUMBER(10, 0),
AD_PrintFormat_ID NUMBER(10, 0),
Statistic_Count NUMBER(10, 0),
Statistic_Seconds NUMBER,
CHECK (IsActive in ('Y','N')),
CHECK (IsUserStartable in ('Y','N')),
CHECK (IsReport in ('Y','N')),
CHECK (IsDirectPrint in ('Y','N')),
CONSTRAINT AD_Process_Key PRIMARY KEY (AD_Process_ID)
)
CACHE
;
--
-- TABLE: AD_Process_Access
--
CREATE TABLE AD_Process_Access(
AD_Process_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_Process_Access_Key PRIMARY KEY (AD_Process_ID, AD_Role_ID)
USING INDEX
TABLESPACE INDX
)
;
--
-- TABLE: AD_Process_Para
--
CREATE TABLE AD_Process_Para(
AD_Process_Para_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),
AD_Process_ID NUMBER(10, 0) NOT NULL,
SeqNo NUMBER(10, 0) NOT NULL,
AD_Reference_ID NUMBER(10, 0) NOT NULL,
AD_Reference_Value_ID NUMBER(10, 0),
AD_Val_Rule_ID NUMBER(10, 0),
ColumnName VARCHAR2(40) NOT NULL,
AD_Element_ID NUMBER(10, 0),
IsCentrallyMaintained CHAR(1) DEFAULT 'Y' NOT NULL,
EntityType CHAR(1) DEFAULT 'D' NOT NULL,
FieldLength NUMBER(10, 0) NOT NULL,
IsMandatory CHAR(1) DEFAULT 'N' NOT NULL,
IsRange CHAR(1) DEFAULT 'N' NOT NULL,
DefaultValue NVARCHAR2(60),
DefaultValue2 NVARCHAR2(60),
VFormat NVARCHAR2(20),
ValueMin NVARCHAR2(20),
ValueMax NVARCHAR2(20),
CHECK (IsActive in ('Y','N')),
CHECK (IsCentrallyMaintained in ('Y','N')),
CHECK (IsMandatory in ('Y','N')),
CHECK (IsRange in ('Y','N')),
CONSTRAINT AD_Process_Para_Key PRIMARY KEY (AD_Process_Para_ID)
)
;
--
-- TABLE: AD_Process_Para_Trl
--
CREATE TABLE AD_Process_Para_Trl(
AD_Process_Para_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 (IsActive in ('Y','N')),
CHECK (IsTranslated in ('Y','N')),
CONSTRAINT AD_Process_Parameter_Trl_Key PRIMARY KEY (AD_Process_Para_ID, AD_Language)
)
;
--
-- TABLE: AD_Process_Trl
--
CREATE TABLE AD_Process_Trl(
AD_Process_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 (IsActive in ('Y','N')),
CHECK (IsTranslated in ('Y','N')),
CONSTRAINT AD_Process_Trl_Key PRIMARY KEY (AD_Process_ID, AD_Language)
)
;
--
-- TABLE: AD_ReportView
--
CREATE TABLE AD_ReportView(
AD_ReportView_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,
WhereClause NVARCHAR2(2000),
OrderByClause NVARCHAR2(2000),
CHECK (IsActive in ('Y','N')),
CONSTRAINT AD_ReportView_Key PRIMARY KEY (AD_ReportView_ID)
USING INDEX
TABLESPACE INDX
)
;
COMMENT ON COLUMN AD_ReportView.AD_ReportView_ID IS 'XML Report Definition'
;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -