compiere.sql

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

    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,
    A_Asset_ID                NUMBER(10, 0)     NOT NULL,
    Date                      DATE              NOT NULL,
    Description               NVARCHAR2(255),
    M_Locator_ID              NUMBER(10, 0),
    C_Location_ID             NUMBER(10, 0),
    C_BPartner_ID             NUMBER(10, 0),
    C_BPartner_Location_ID    NUMBER(10, 0),
    AD_User_ID                NUMBER(10, 0),
    Processing                CHAR(1),
    CONSTRAINT A_AssetTracking_Key PRIMARY KEY (A_AssetTracking_ID)
)
;



-- 
-- TABLE: A_Depreciation 
--

CREATE TABLE A_Depreciation(
    A_Depreciation_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,
    Value                NVARCHAR2(40)      NOT NULL,
    Name                 NVARCHAR2(60)      NOT NULL,
    Description          NVARCHAR2(255),
    Help                 NVARCHAR2(2000),
    DepreciationType     CHAR(2)            NOT NULL,
    Classname            NVARCHAR2(60)      NOT NULL,
    CONSTRAINT A_Depreciation_Key PRIMARY KEY (A_Depreciation_ID)
)
;



-- 
-- TABLE: A_DepreciationPlan 
--

CREATE TABLE A_DepreciationPlan(
    A_DepreciationPlan_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,
    A_Asset_ID                   NUMBER(10, 0)    NOT NULL,
    C_AcctSchema_ID              NUMBER(10, 0)    NOT NULL,
    A_Depreciation_ID            NUMBER(10, 0)    NOT NULL,
    C_Period_ID                  NUMBER(10, 0)    NOT NULL,
    AssetMarketValueAmt          NUMBER           DEFAULT 0 NOT NULL,
    AssetBookValueAmt            NUMBER           DEFAULT 0 NOT NULL,
    AssetBookValueChangeAmt      NUMBER           DEFAULT 0 NOT NULL,
    AssetAccumDepreciationAmt    NUMBER           DEFAULT 0 NOT NULL,
    AssetDepreciationAmt         NUMBER           DEFAULT 0 NOT NULL,
    CONSTRAINT A_DepreciationPlan_Key PRIMARY KEY (A_DepreciationPlan_ID)
)
;



-- 
-- TABLE: A_Registration 
--

CREATE TABLE A_Registration(
    A_Registration_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),
    A_Asset_ID           NUMBER(10, 0),
    M_Product_ID         NUMBER(10, 0),
    C_BPartner_ID        NUMBER(10, 0),
    AD_User_ID           NUMBER(10, 0),
    AssetServiceDate     DATE               NOT NULL,
    Remote_Host          NVARCHAR2(120),
    Remote_Addr          NVARCHAR2(60),
    Note                 NVARCHAR2(2000)    NOT NULL,
    Processing           CHAR(1),
    CONSTRAINT A_Registration_Key PRIMARY KEY (A_Registration_ID)
)
;



-- 
-- TABLE: A_RegistrationAttribute 
--

CREATE TABLE A_RegistrationAttribute(
    A_RegistrationAttribute_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),
    SeqNo                         NUMBER(10, 0)     DEFAULT 0 NOT NULL,
    AD_Reference_ID               NUMBER(10, 0)     NOT NULL,
    ColumnName                    NVARCHAR2(40)     NOT NULL,
    AD_Reference_Value_ID         NUMBER(10, 0),
    CONSTRAINT A_RegistrationAttribute_Key PRIMARY KEY (A_RegistrationAttribute_ID)
)
;



-- 
-- TABLE: A_RegistrationProduct 
--

CREATE TABLE A_RegistrationProduct(
    A_RegistrationAttribute_ID    NUMBER(10, 0)     NOT NULL,
    M_Product_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,
    Description                   NVARCHAR2(255),
    CONSTRAINT A_RegistrationProduct_Key PRIMARY KEY (A_RegistrationAttribute_ID, M_Product_ID)
)
;



-- 
-- TABLE: A_RegistrationValue 
--

CREATE TABLE A_RegistrationValue(
    A_Registration_ID             NUMBER(10, 0)     NOT NULL,
    A_RegistrationAttribute_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),
    CONSTRAINT A_RegistrationValue_Key PRIMARY KEY (A_Registration_ID, A_RegistrationAttribute_ID)
)
;



-- 
-- TABLE: AD_AccessLog 
--

CREATE TABLE AD_AccessLog(
    AD_AccessLog_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),
    AD_Column_ID       NUMBER(10, 0),
    Record_ID          NUMBER(10, 0)      NOT NULL,
    Remote_Addr        NVARCHAR2(60),
    Remote_Host        NVARCHAR2(60),
    Description        NVARCHAR2(255),
    TextMsg            NVARCHAR2(2000)    NOT NULL,
    Reply              NVARCHAR2(2000)    NOT NULL,
    CONSTRAINT AD_AccessLog_Key PRIMARY KEY (AD_AccessLog_ID)
)
;



-- 
-- TABLE: AD_Alert 
--

CREATE TABLE AD_Alert(
    AD_Alert_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),
    AlertSubject            NVARCHAR2(60),
    AlertMessage            NVARCHAR2(2000)    NOT NULL,
    AD_AlertProcessor_ID    NUMBER(10, 0),
    CONSTRAINT AD_Alert_Key PRIMARY KEY (AD_Alert_ID)
)
;



-- 
-- TABLE: AD_AlertProcessor 
--

CREATE TABLE AD_AlertProcessor(
    AD_AlertProcessor_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),
    FrequencyType           CHAR(1)           NOT NULL,
    Frequency               NUMBER(10, 0)     DEFAULT 0 NOT NULL,
    DateLastRun             DATE              NOT NULL,
    DateNextRun             DATE              NOT NULL,
    Supervisor_ID           NUMBER(10, 0)     NOT NULL,
    KeepLogDays             NUMBER(10, 0)     DEFAULT 0 NOT NULL,
    Processing              CHAR(1),
    CONSTRAINT AD_AlertProcessor_Key PRIMARY KEY (AD_AlertProcessor_ID)
)
;



-- 
-- TABLE: AD_AlertProcessorLog 
--

CREATE TABLE AD_AlertProcessorLog(
    AD_AlertProcessor_ID       NUMBER(10, 0)      NOT NULL,
    AD_AlertProcessorLog_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,
    Summary                    NVARCHAR2(2000)    NOT NULL,
    Reference                  NVARCHAR2(60)      NOT NULL,
    Description                NVARCHAR2(255),
    TextMsg                    NVARCHAR2(2000)    NOT NULL,
    BinaryData                 BLOB               NOT NULL,
    CONSTRAINT AD_AlertProcessorLog_Key PRIMARY KEY (AD_AlertProcessor_ID, AD_AlertProcessorLog_ID)
)
;



-- 
-- TABLE: AD_AlertRecipient 
--

CREATE TABLE AD_AlertRecipient(
    AD_AlertRecipient_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_Alert_ID             NUMBER(10, 0)    NOT NULL,
    AD_User_ID              NUMBER(10, 0),
    AD_Role_ID              NUMBER(10, 0),
    CONSTRAINT AD_AltertRecipient_Key PRIMARY KEY (AD_AlertRecipient_ID)
)
;



-- 
-- TABLE: AD_AlertRule 
--

CREATE TABLE AD_AlertRule(
    AD_AlertRule_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,
    AD_Alert_ID        NUMBER(10, 0)      NOT NULL,
    SelectClause       NVARCHAR2(2000)    NOT NULL,
    FromClause         NVARCHAR2(2000)    NOT NULL,
    WhereClause        NVARCHAR2(2000)    NOT NULL,
    OtherClause        NVARCHAR2(2000)    NOT NULL,
    AD_Table_ID        NUMBER(10, 0),
    PreProcessing      NVARCHAR2(2000)    NOT NULL,
    PostProcessing     NVARCHAR2(2000)    NOT NULL,
    ErrorMsg           NVARCHAR2(2000)    NOT NULL,
    CONSTRAINT AD_AlertRule_Key PRIMARY KEY (AD_AlertRule_ID)
)
;



-- 
-- TABLE: AD_Archive 
--

CREATE TABLE AD_Archive(
    AD_Archive_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
                     CHECK (IsActive in ('Y','N')),
    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),
    IsReport         CHAR(1)            DEFAULT 'N' NOT NULL
                     CHECK (IsReport in ('Y','N')),
    AD_Table_ID      NUMBER(10, 0),
    Record_ID        NUMBER(10, 0),
    AD_Process_ID    NUMBER(10, 0),
    C_BPartner_ID    NUMBER(10, 0),
    BinaryData       BLOB,
    CONSTRAINT AD_Archive_Key PRIMARY KEY (AD_Archive_ID)
)
;



-- 
-- TABLE: AD_Attachment 
--

CREATE TABLE AD_Attachment(
    AD_Attachment_ID    NUMBER(10, 0)      NOT NULL,
    AD_Client_ID        NUMBER(10, 0)      NOT NULL,
    AD_Org_ID           NUMBER(10, 0)      NOT NULL,