compiere.sql

大家共享愉快, 共享愉快, 共享愉快, 共享愉快,共享愉快

    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_Table_ID         NUMBER(10, 0)      NOT NULL,
    Record_ID           NUMBER(10, 0)      NOT NULL,
    Title               NVARCHAR2(60)      NOT NULL,
    TextMsg             NVARCHAR2(2000),
    BinaryData          BLOB,
    CONSTRAINT AD_Attachment_Key PRIMARY KEY (AD_Attachment_ID)
)
;



-- 
-- TABLE: AD_AttachmentNote 
--

CREATE TABLE AD_AttachmentNote(
    AD_AttachmentNote_ID    NUMBER(10, 0)      NOT NULL,
    AD_Client_ID            NUMBER(10, 0)      NOT NULL,
    AD_Org_ID               NUMBER(10, 0)      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_Attachment_ID        NUMBER(10, 0)      NOT NULL,
    AD_User_ID              NUMBER(10, 0)      NOT NULL,
    Title                   NVARCHAR2(60),
    TextMsg                 NVARCHAR2(2000)    NOT NULL,
    CONSTRAINT AD_AttachmentNote_Key PRIMARY KEY (AD_AttachmentNote_ID)
)
;



-- 
-- TABLE: AD_Attribute 
--

CREATE TABLE AD_Attribute(
    AD_Attribute_ID          NUMBER(10, 0)      NOT NULL,
    AD_Client_ID             NUMBER(10, 0)      NOT NULL,
    AD_Org_ID                NUMBER(10, 0)      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_Table_ID              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),
    Callout                  NVARCHAR2(60)      NOT NULL,
    ValueMin                 NVARCHAR2(20)      NOT NULL,
    ValueMax                 NVARCHAR2(20)      NOT NULL,
    DefaultValue             NVARCHAR2(2000),
    FieldLength              NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    DisplayLength            NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    SeqNo                    NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    DisplayLogic             NVARCHAR2(2000)    NOT NULL,
    VFormat                  NVARCHAR2(60),
    CONSTRAINT AD_Attribute_Key PRIMARY KEY (AD_Attribute_ID)
)
;



-- 
-- TABLE: AD_Attribute_Value 
--

CREATE TABLE AD_Attribute_Value(
    AD_Attribute_ID    NUMBER(10, 0)      NOT NULL,
    Record_ID          NUMBER(10, 0)      NOT NULL,
    V_Number           NUMBER,
    V_Date             DATE               NOT NULL,
    V_String           NVARCHAR2(2000)    NOT NULL,
    CONSTRAINT AD_Attribute_Value_Key PRIMARY KEY (AD_Attribute_ID, Record_ID)
)
;



-- 
-- TABLE: AD_ChangeLog 
--

CREATE TABLE AD_ChangeLog(
    AD_ChangeLog_ID    NUMBER(10, 0)      NOT NULL,
    AD_Session_ID      NUMBER(10, 0)      NOT NULL,
    AD_Table_ID        NUMBER(10, 0)      NOT NULL,
    AD_Column_ID       NUMBER(10, 0)      NOT NULL,
    AD_Client_ID       NUMBER(10, 0)      NOT NULL,
    AD_Org_ID          NUMBER(10, 0)      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,
    Record_ID          NUMBER(10, 0)      NOT NULL,
    OldValue           NVARCHAR2(2000)    NOT NULL,
    NewValue           NVARCHAR2(2000)    NOT NULL,
    UnDo               CHAR(1),
    ReDo               CHAR(1),
    TrxName            NVARCHAR2(60),
    CONSTRAINT AD_ChangeLog_Key PRIMARY KEY (AD_ChangeLog_ID, AD_Session_ID, AD_Table_ID, AD_Column_ID)
)
;



-- 
-- TABLE: AD_Client 
--

CREATE TABLE AD_Client(
    AD_Client_ID              NUMBER(10, 0)      NOT NULL,
    AD_Org_ID                 NUMBER(10, 0)      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),
    SMTPHost                  NVARCHAR2(60)      NOT NULL,
    RequestEMail              NVARCHAR2(60),
    RequestUser               NVARCHAR2(20)      NOT NULL,
    RequestUserPW             NVARCHAR2(20)      NOT NULL,
    RequestFolder             NVARCHAR2(20)      NOT NULL,
    AD_Language               VARCHAR2(6)        NOT NULL,
    WebInfo                   NVARCHAR2(2000)    NOT NULL,
    WebParam1                 NVARCHAR2(2000)    NOT NULL,
    WebParam2                 NVARCHAR2(2000)    NOT NULL,
    WebParam3                 NVARCHAR2(2000)    NOT NULL,
    WebParam4                 NVARCHAR2(2000)    NOT NULL,
    WebParam5                 NVARCHAR2(2000)    NOT NULL,
    WebParam6                 NVARCHAR2(2000)    NOT NULL,
    WebOrderEMail             NVARCHAR2(60),
    WebDir                    NVARCHAR2(60)      NOT NULL,
    DocumentDir               NVARCHAR2(60)      NOT NULL,
    EncryptionKey             NVARCHAR2(255),
    LDAPQuery                 NVARCHAR2(255),
    ModelValidationClasses    NVARCHAR2(255),
    AutoArchive               CHAR(1)            NOT NULL,
    CONSTRAINT AD_Client_Key PRIMARY KEY (AD_Client_ID)
)
;



-- 
-- TABLE: AD_ClientInfo 
--

CREATE TABLE AD_ClientInfo(
    AD_Client_ID              NUMBER(10, 0)    NOT NULL,
    AD_Org_ID                 NUMBER(10, 0)    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_Calendar_ID             NUMBER(10, 0),
    C_AcctSchema1_ID          NUMBER(10, 0),
    C_AcctSchema2_ID          NUMBER(10, 0),
    C_AcctSchema3_ID          NUMBER(10, 0),
    C_UOM_Volume_ID           NUMBER(10, 0),
    C_UOM_Weight_ID           NUMBER(10, 0),
    C_UOM_Length_ID           NUMBER(10, 0),
    C_UOM_Time_ID             NUMBER(10, 0),
    AD_Tree_Menu_ID           NUMBER(10, 0),
    AD_Tree_Org_ID            NUMBER(10, 0),
    AD_Tree_BPartner_ID       NUMBER(10, 0),
    AD_Tree_Project_ID        NUMBER(10, 0),
    AD_Tree_SalesRegion_ID    NUMBER(10, 0),
    AD_Tree_Product_ID        NUMBER(10, 0),
    AD_Tree_Campaign_ID       NUMBER(10, 0),
    AD_Tree_Activity_ID       NUMBER(10, 0),
    M_ProductFreight_ID       NUMBER(10, 0)    NOT NULL,
    C_BPartnerCashTrx_ID      NUMBER(10, 0)    NOT NULL,
    M_PriceList_ID            NUMBER(10, 0),
    PA_Goal_ID                NUMBER(10, 0),
    KeepLogDays               NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    CONSTRAINT AD_ClientInfo_Key PRIMARY KEY (AD_Client_ID)
)
;



-- 
-- TABLE: AD_Color 
--

CREATE TABLE AD_Color(
    AD_Color_ID       NUMBER(10, 0)    NOT NULL,
    AD_Client_ID      NUMBER(10, 0)    NOT NULL,
    AD_Org_ID         NUMBER(10, 0)    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,
    ColorType         CHAR(1)          NOT NULL,
    Red               NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Green             NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Blue              NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Alpha             NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    AD_Image_ID       NUMBER(10, 0),
    ImageAlpha        NUMBER,
    Red_1             NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Green_1           NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Blue_1            NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    Alpha_1           NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    LineWidth         NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    LineDistance      NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    StartPoint        NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    RepeatDistance    NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    CONSTRAINT AD_Color_Key PRIMARY KEY (AD_Color_ID)
)
;



-- 
-- TABLE: AD_Column 
--

CREATE TABLE AD_Column(
    AD_Column_ID             NUMBER(10, 0)      NOT NULL,
    AD_Client_ID             NUMBER(10, 0)      NOT NULL,
    AD_Org_ID                NUMBER(10, 0)      NOT NULL,
    Created                  DATE               DEFAULT SYSDATE NOT NULL,
    Updated                  DATE               DEFAULT SYSDATE NOT NULL,
    CreatedBy                NUMBER(10, 0)      NOT NULL,
    UpdatedBy                NUMBER(10, 0)      NOT NULL,
    Name                     NVARCHAR2(60)      NOT NULL,
    Description              NVARCHAR2(255),
    Help                     NVARCHAR2(2000),
    Version                  NUMBER             NOT NULL,
    EntityType               VARCHAR2(4)        DEFAULT 'D' NOT NULL,
    ColumnName               VARCHAR2(40),
    AD_Table_ID              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),
    FieldLength              NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    DefaultValue             NVARCHAR2(2000)    NOT NULL,
    ReadOnlyLogic            NVARCHAR2(2000)    NOT NULL,
    SeqNo                    NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    Callout                  NVARCHAR2(255),
    VFormat                  NVARCHAR2(60),
    ValueMin                 NVARCHAR2(20)      NOT NULL,
    ValueMax                 NVARCHAR2(20)      NOT NULL,
    AD_Element_ID            NUMBER(10, 0),
    AD_Process_ID            NUMBER(10, 0),
    CONSTRAINT AD_Column_Key PRIMARY KEY (AD_Column_ID)
)
;



-- 
-- TABLE: AD_Column_Access 
--

CREATE TABLE AD_Column_Access(
    AD_Role_ID      NUMBER(10, 0)    NOT NULL,
    AD_Column_ID    NUMBER(10, 0)    NOT NULL,
    AD_Client_ID    NUMBER(10, 0)    NOT NULL,
    AD_Org_ID       NUMBER(10, 0)    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_Table_ID     NUMBER(10, 0),
    CONSTRAINT AD_Column_Access_Key PRIMARY KEY (AD_Role_ID, AD_Column_ID)
)
;



-- 
-- TABLE: AD_Column_Trl 
--

CREATE TABLE AD_Column_Trl(
    AD_Column_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,
    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,
    CONSTRAINT AD_Column_Trl_Key PRIMARY KEY (AD_Column_ID, AD_Language)
)
;



-- 
-- TABLE: AD_Desktop 
--

CREATE TABLE AD_Desktop(
    AD_Desktop_ID    NUMBER(10, 0)      NOT NULL,
    AD_Client_ID     NUMBER(10, 0)      NOT NULL,
    AD_Org_ID        NUMBER(10, 0)      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_Image_ID      NUMBER(10, 0),
    AD_Color_ID      NUMBER(10, 0),
    CONSTRAINT AD_Desktop_Key PRIMARY KEY (AD_Desktop_ID)
)
;



-- 
-- TABLE: AD_Desktop_Trl 
--

CREATE TABLE AD_Desktop_Trl(
    AD_Desktop_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,
    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),
    CONSTRAINT AD_Desktop_Trl_Key PRIMARY KEY (AD_Desktop_ID, AD_Language)
)
;



-- 
-- TABLE: AD_DesktopWorkbench 
--

CREATE TABLE AD_DesktopWorkbench(
    AD_DesktopWorkbench_ID    NUMBER(10, 0)    NOT NULL,