compiere.sql

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

--

CREATE TABLE AD_LabelPrinter(
    AD_LabelPrinter_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 AD_LabelPrinter_Key PRIMARY KEY (AD_LabelPrinter_ID)
)
;



-- 
-- TABLE: AD_LabelPrinterFunction 
--

CREATE TABLE AD_LabelPrinterFunction(
    AD_LabelPrinterFunction_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),
    AD_LabelPrinter_ID            NUMBER(10, 0)     NOT NULL,
    FunctionPrefix                NVARCHAR2(40)     NOT NULL,
    FunctionSuffix                NVARCHAR2(40)     NOT NULL,
    XYSeparator                   NVARCHAR2(20)     NOT NULL,
    CONSTRAINT AD_LabelPrinterFunction_Key PRIMARY KEY (AD_LabelPrinterFunction_ID)
)
;



-- 
-- TABLE: AD_Language 
--

CREATE TABLE AD_Language(
    AD_Language       VARCHAR2(6)      NOT NULL,
    AD_Client_ID      NUMBER(10, 0)    NOT NULL,
    AD_Org_ID         NUMBER(10, 0)    NOT NULL,
    AD_Language_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,
    LanguageISO       CHAR(2)          NOT NULL,
    CountryCode       CHAR(2)          NOT NULL,
    IsDecimalPoint    CHAR(1)          DEFAULT 'Y' NOT NULL
                      CHECK (IsDecimalPoint in ('Y','N')),
    DatePattern       NVARCHAR2(20),
    TimePattern       NVARCHAR2(20),
    Processing        CHAR(1),
    CONSTRAINT AD_Language_Key PRIMARY KEY (AD_Language)
)
;



-- 
-- TABLE: AD_Menu 
--

CREATE TABLE AD_Menu(
    AD_Menu_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),
    IsSummary          CHAR(1)           DEFAULT 'N' NOT NULL,
    EntityType         VARCHAR2(4)       DEFAULT 'D' NOT NULL,
    Action             CHAR(1)           NOT NULL,
    AD_Window_ID       NUMBER(10, 0),
    AD_Workflow_ID     NUMBER(10, 0),
    AD_Task_ID         NUMBER(10, 0),
    AD_Process_ID      NUMBER(10, 0),
    AD_Form_ID         NUMBER(10, 0),
    AD_Workbench_ID    NUMBER(10, 0),
    CONSTRAINT AD_Menu_Key PRIMARY KEY (AD_Menu_ID)
)
;



-- 
-- TABLE: AD_Menu_Trl 
--

CREATE TABLE AD_Menu_Trl(
    AD_Menu_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),
    CONSTRAINT AD_Menu_Trl_Key PRIMARY KEY (AD_Menu_ID, AD_Language)
)
;



-- 
-- TABLE: AD_Message 
--

CREATE TABLE AD_Message(
    AD_Message_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,
    MsgText          NVARCHAR2(2000),
    MsgType          CHAR(1)            NOT NULL,
    EntityType       VARCHAR2(4)        DEFAULT 'D' NOT NULL,
    MsgTip           NVARCHAR2(2000),
    CONSTRAINT AD_Message_Key PRIMARY KEY (AD_Message_ID)
)
;



-- 
-- TABLE: AD_Message_Trl 
--

CREATE TABLE AD_Message_Trl(
    AD_Message_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,
    MsgText          NVARCHAR2(2000),
    MsgTip           NVARCHAR2(2000),
    CONSTRAINT AD_Message_Trl_Key PRIMARY KEY (AD_Message_ID, AD_Language)
)
;



-- 
-- 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,
    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),
    Description          NVARCHAR2(255),
    AD_Table_ID          NUMBER(10, 0),
    Record_ID            NUMBER(10, 0)      NOT NULL,
    TextMsg              NVARCHAR2(2000),
    Processing           CHAR(1),
    AD_WF_Activity_ID    NUMBER(10, 0),
    CONSTRAINT AD_Note_Key PRIMARY KEY (AD_Note_ID)
)
;



-- 
-- TABLE: AD_Org 
--

CREATE TABLE AD_Org(
    AD_Org_ID       NUMBER(10, 0)     NOT NULL,
    AD_Client_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),
    IsSummary       CHAR(1)           DEFAULT 'N' NOT NULL,
    CONSTRAINT AD_Org_Key PRIMARY KEY (AD_Org_ID)
)
;



-- 
-- TABLE: AD_OrgInfo 
--

CREATE TABLE AD_OrgInfo(
    AD_Org_ID         NUMBER(10, 0)    NOT NULL,
    AD_Client_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_Location_ID     NUMBER(10, 0),
    DUNS              CHAR(11)         NOT NULL,
    TaxID             VARCHAR2(20)     NOT NULL,
    PA_Goal_ID        NUMBER(10, 0),
    Supervisor_ID     NUMBER(10, 0),
    Parent_Org_ID     NUMBER(10, 0),
    AD_OrgType_ID     NUMBER(10, 0),
    M_Warehouse_ID    NUMBER(10, 0),
    CONSTRAINT AD_OrgInfo_Key PRIMARY KEY (AD_Org_ID)
)
;



-- 
-- TABLE: AD_OrgType 
--

CREATE TABLE AD_OrgType(
    AD_OrgType_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),
    AD_PrintColor_ID    NUMBER(10, 0),
    CONSTRAINT AD_OrgType_Key PRIMARY KEY (AD_OrgType_ID)
)
;



-- 
-- TABLE: AD_PInstance 
--

CREATE TABLE AD_PInstance(
    AD_PInstance_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_Process_ID      NUMBER(10, 0)      NOT NULL,
    Record_ID          NUMBER(10, 0)      NOT NULL,
    AD_User_ID         NUMBER(10, 0),
    Result             NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    ErrorMsg           NVARCHAR2(2000),
    CONSTRAINT AD_PInstance_Key PRIMARY KEY (AD_PInstance_ID)
)
;



-- 
-- 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 NOT NULL,
    P_ID               NUMBER(10, 0)      NOT NULL,
    P_Number           NUMBER,
    P_Msg              NVARCHAR2(2000)    NOT NULL,
    CONSTRAINT AD_PInstance_Log_Key PRIMARY KEY (AD_PInstance_ID, Log_ID)
)
;



-- 
-- TABLE: AD_PInstance_Para 
--

CREATE TABLE AD_PInstance_Para(
    AD_PInstance_ID    NUMBER(10, 0)    NOT NULL,
    SeqNo              NUMBER(10, 0)    DEFAULT 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,
    ParameterName      NVARCHAR2(60)    NOT NULL,
    P_String           NVARCHAR2(60)    NOT NULL,
    P_String_To        NVARCHAR2(60)    NOT NULL,
    P_Number           NUMBER,
    P_Number_To        NUMBER,
    P_Date             DATE             NOT NULL,
    P_Date_To          DATE             NOT NULL,
    Info               NVARCHAR2(60),
    Info_To            NVARCHAR2(60),
    CONSTRAINT AD_PInstance_Para_Key PRIMARY KEY (AD_PInstance_ID, SeqNo)
)
;



-- 
-- 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,
    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,
    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)