compiere.sql

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

--
--ER/Studio 6.6 SQL Code Generation
-- Company :      ComPiere, Inc.
-- Project :      AD251h
-- Author :       Jorg Janke
--
-- Date Created : Monday, February 07, 2005 15:31:31
-- Target DBMS : Oracle 9i
--

-- 
-- TABLE: A_Asset 
--

CREATE TABLE A_Asset(
    A_Asset_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),
    A_Asset_Group_ID             NUMBER(10, 0)      NOT NULL,
    Parent_Asset_ID              NUMBER(10, 0),
    M_Product_ID                 NUMBER(10, 0),
    M_AttributeSetInstance_ID    NUMBER(10, 0),
    C_UOM_ID                     NUMBER(10, 0),
    SerNo                        NVARCHAR2(40),
    Lot                          NVARCHAR2(40),
    VersionNo                    NVARCHAR2(40),
    GuaranteeDate                DATE               NOT NULL,
    AssetServiceDate             DATE               NOT NULL,
    AssetDisposalDate            DATE               NOT NULL,
    LocationComment              NVARCHAR2(255),
    M_Locator_ID                 NUMBER(10, 0),
    C_BPartner_ID                NUMBER(10, 0),
    C_BPartner_Location_ID       NUMBER(10, 0),
    AD_User_ID                   NUMBER(10, 0),
    C_Location_ID                NUMBER(10, 0),
    LastMaintenanceDate          DATE               NOT NULL,
    NextMaintenanceDate          DATE               NOT NULL,
    LastMaintenanceUseUnit       NUMBER             DEFAULT 0 NOT NULL,
    NextMaintenanceUseUnit       NUMBER             DEFAULT 0 NOT NULL,
    Lease_BPartner_ID            NUMBER(10, 0),
    LeaseTerminationDate         DATE               NOT NULL,
    Processing                   CHAR(1),
    CONSTRAINT A_Asset_Key PRIMARY KEY (A_Asset_ID)
)
;



-- 
-- TABLE: A_Asset_Acct 
--

CREATE TABLE A_Asset_Acct(
    A_Asset_ID                    NUMBER(10, 0)    NOT NULL,
    C_AcctSchema_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_Acct                  NUMBER(10, 0)    NOT NULL,
    A_Depreciation_Acct           NUMBER(10, 0)    NOT NULL,
    A_AccumDepreciation_Acct      NUMBER(10, 0)    NOT NULL,
    A_Disposal_Loss               NUMBER(10, 0)    NOT NULL,
    A_Disposal_Gain               NUMBER(10, 0)    NOT NULL,
    A_Maintenance_Acct            NUMBER(10, 0)    NOT NULL,
    A_LeaseCost_Acct              NUMBER(10, 0)    NOT NULL,
    SalvageAmt                    NUMBER           DEFAULT 0 NOT NULL,
    LifeUseUnits                  NUMBER,
    A_Depreciation_ID             NUMBER(10, 0),
    AssetDepreciationStartDate    DATE             NOT NULL,
    UseLifeYears                  NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    UseLifeMonths                 NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    CONSTRAINT A_Asset_Acct_Key PRIMARY KEY (A_Asset_ID, C_AcctSchema_ID)
)
;



-- 
-- TABLE: A_Asset_Addition 
--

CREATE TABLE A_Asset_Addition(
    A_Asset_Addition_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_InvoiceLine_ID       NUMBER(10, 0),
    M_MovementLine_ID      NUMBER(10, 0),
    AssetValueAmt          NUMBER           DEFAULT 0 NOT NULL,
    C_Currency_ID          NUMBER(10, 0),
    C_Charge_ID            NUMBER(10, 0),
    CONSTRAINT A_Asset_Addition_Key PRIMARY KEY (A_Asset_Addition_ID)
)
;



-- 
-- TABLE: A_Asset_Change 
--

CREATE TABLE A_Asset_Change(
    A_Asset_Change_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,
    ChangeType               CHAR(1)           NOT NULL,
    ChangeDate               DATE              NOT NULL,
    DateAcct                 DATE              NOT NULL,
    Description              NVARCHAR2(255),
    UseLifeYears             NUMBER(10, 0)     DEFAULT 0 NOT NULL,
    UseLifeMonths            NUMBER(10, 0)     DEFAULT 0 NOT NULL,
    LifeUseUnits             NUMBER,
    AssetDepreciationDate    DATE              NOT NULL,
    A_Asset_Retirement_ID    NUMBER(10, 0),
    A_Asset_Addition_ID      NUMBER(10, 0),
    A_Depreciation_ID        NUMBER(10, 0),
    AssetMarketValueAmt      NUMBER            DEFAULT 0 NOT NULL,
    AssetValueChangeAmt      NUMBER            DEFAULT 0 NOT NULL,
    C_Currency_ID            NUMBER(10, 0),
    C_Charge_ID              NUMBER(10, 0),
    Processing               CHAR(1),
    Posted                   CHAR(1)           DEFAULT 'N' NOT NULL,
    CONSTRAINT A_Asset_Change_Key PRIMARY KEY (A_Asset_Change_ID)
)
;



-- 
-- TABLE: A_Asset_Change_Amt 
--

CREATE TABLE A_Asset_Change_Amt(
    A_Asset_Change_ID            NUMBER(10, 0)    NOT NULL,
    C_AcctSchema_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,
    AssetMarketValueAmt          NUMBER           DEFAULT 0 NOT NULL,
    AssetBookValueAmt            NUMBER           DEFAULT 0 NOT NULL,
    AssetBookValueChangeAmt      NUMBER           DEFAULT 0 NOT NULL,
    AssetDepreciationAmt         NUMBER           DEFAULT 0 NOT NULL,
    AssetAccumDepreciationAmt    NUMBER           DEFAULT 0 NOT NULL,
    CONSTRAINT A_Asset_Change_Amt_Key PRIMARY KEY (A_Asset_Change_ID, C_AcctSchema_ID)
)
;



-- 
-- TABLE: A_Asset_Delivery 
--

CREATE TABLE A_Asset_Delivery(
    A_Asset_Delivery_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,
    MovementDate            DATE              NOT NULL,
    Description             NVARCHAR2(255),
    SerNo                   NVARCHAR2(40),
    Lot                     NVARCHAR2(40),
    VersionNo               NVARCHAR2(40),
    M_InOutLine_ID          NUMBER(10, 0),
    EMail                   NVARCHAR2(60),
    AD_User_ID              NUMBER(10, 0),
    MessageID               VARCHAR2(120)     NOT NULL,
    DeliveryConfirmation    VARCHAR2(120)     NOT NULL,
    URL                     NVARCHAR2(120),
    Remote_Addr             NVARCHAR2(60),
    Remote_Host             NVARCHAR2(60),
    Referrer                NVARCHAR2(255),
    CONSTRAINT A_Asset_Delivery_Key PRIMARY KEY (A_Asset_Delivery_ID)
)
;



-- 
-- TABLE: A_Asset_Group 
--

CREATE TABLE A_Asset_Group(
    A_Asset_Group_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),
    CONSTRAINT A_Asset_Group_Key PRIMARY KEY (A_Asset_Group_ID)
)
;



-- 
-- TABLE: A_Asset_Group_Acct 
--

CREATE TABLE A_Asset_Group_Acct(
    A_Asset_Group_ID            NUMBER(10, 0)    NOT NULL,
    C_AcctSchema_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_Acct                NUMBER(10, 0)    NOT NULL,
    A_Depreciation_Acct         NUMBER(10, 0)    NOT NULL,
    A_AccumDepreciation_Acct    NUMBER(10, 0)    NOT NULL,
    A_Disposal_Loss             NUMBER(10, 0)    NOT NULL,
    A_Disposal_Gain             NUMBER(10, 0)    NOT NULL,
    A_Maintenance_Acct          NUMBER(10, 0)    NOT NULL,
    A_LeaseCost_Acct            NUMBER(10, 0)    NOT NULL,
    A_Depreciation_ID           NUMBER(10, 0)    NOT NULL,
    C_Calendar_ID               NUMBER(10, 0)    NOT NULL,
    Processing                  CHAR(1),
    CONSTRAINT A_Asset_Group_Acct_Key PRIMARY KEY (A_Asset_Group_ID, C_AcctSchema_ID)
)
;



-- 
-- TABLE: A_Asset_Maintenance 
--

CREATE TABLE A_Asset_Maintenance(
    A_Asset_Maintenance_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,
    Date                      DATE              NOT NULL,
    Description               NVARCHAR2(255),
    UseUnits                  NUMBER            DEFAULT 0 NOT NULL,
    NextMaintenenceDate       DATE              NOT NULL,
    NextMaintenanceUseUnit    NUMBER            DEFAULT 0 NOT NULL,
    C_InvoiceLine_ID          NUMBER(10, 0),
    Processing                CHAR(1),
    CONSTRAINT A_Asset_Maintenance_Key PRIMARY KEY (A_Asset_Maintenance_ID)
)
;



-- 
-- TABLE: A_Asset_MethodUse 
--

CREATE TABLE A_Asset_MethodUse(
    A_Asset_ID           NUMBER(10, 0)     NOT NULL,
    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,
    Description          NVARCHAR2(255),
    CONSTRAINT A_Asset_MethodUse_Key PRIMARY KEY (A_Asset_ID, A_Depreciation_ID)
)
;



-- 
-- TABLE: A_Asset_Retirement 
--

CREATE TABLE A_Asset_Retirement(
    A_Asset_Retirement_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_InvoiceLine_ID         NUMBER(10, 0),
    M_MovementLine_ID        NUMBER(10, 0),
    AssetMarketValueAmt      NUMBER           DEFAULT 0 NOT NULL,
    AssetValueAmt            NUMBER           DEFAULT 0 NOT NULL,
    C_Currency_ID            NUMBER(10, 0),
    C_Charge_ID              NUMBER(10, 0),
    CONSTRAINT A_Asset_Retirement_Key PRIMARY KEY (A_Asset_Retirement_ID)
)
;



-- 
-- TABLE: A_Asset_Use 
--

CREATE TABLE A_Asset_Use(
    A_Asset_Use_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,
    UseDate           DATE              NOT NULL,
    UseUnits          NUMBER,
    Description       NVARCHAR2(255),
    Processing        CHAR(1),
    CONSTRAINT A_Asset_Use_Key PRIMARY KEY (A_Asset_Use_ID)
)
;



-- 
-- TABLE: A_AssetTracking 
--

CREATE TABLE A_AssetTracking(
    A_AssetTracking_ID        NUMBER(10, 0)     NOT NULL,