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,
    AD_Workbench_ID           NUMBER(10, 0)    NOT NULL,
    AD_Desktop_ID             NUMBER(10, 0)    NOT NULL,
    SeqNo                     NUMBER(10, 0)    DEFAULT 0 NOT NULL,
    CONSTRAINT AD_DesktopWorkbench_Key PRIMARY KEY (AD_DesktopWorkbench_ID)
)
;



-- 
-- TABLE: AD_Element 
--

CREATE TABLE AD_Element(
    AD_Element_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,
    ColumnName        VARCHAR2(40),
    EntityType        VARCHAR2(4)        DEFAULT 'D' NOT NULL,
    Name              NVARCHAR2(60)      NOT NULL,
    PrintName         NVARCHAR2(60)      NOT NULL,
    Description       NVARCHAR2(255),
    Help              NVARCHAR2(2000),
    PO_Name           NVARCHAR2(60)      NOT NULL,
    PO_PrintName      NVARCHAR2(60)      NOT NULL,
    PO_Description    NVARCHAR2(255),
    PO_Help           NVARCHAR2(2000),
    CONSTRAINT AD_Element_Key PRIMARY KEY (AD_Element_ID)
)
;



-- 
-- TABLE: AD_Element_Trl 
--

CREATE TABLE AD_Element_Trl(
    AD_Element_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,
    PrintName         NVARCHAR2(60)      NOT NULL,
    Description       NVARCHAR2(255),
    Help              NVARCHAR2(2000),
    PO_Name           NVARCHAR2(60)      NOT NULL,
    PO_PrintName      NVARCHAR2(60)      NOT NULL,
    PO_Description    NVARCHAR2(255),
    PO_Help           NVARCHAR2(2000),
    CONSTRAINT AD_Element_Trl_Key PRIMARY KEY (AD_Element_ID, AD_Language)
)
;



-- 
-- TABLE: AD_Error 
--

CREATE TABLE AD_Error(
    AD_Error_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,
    Code            NVARCHAR2(2000)    NOT NULL,
    AD_Language     VARCHAR2(6)        NOT NULL,
    CONSTRAINT AD_Error_Key PRIMARY KEY (AD_Error_ID)
)
;



-- 
-- TABLE: AD_Field 
--

CREATE TABLE AD_Field(
    AD_Field_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),
    EntityType          VARCHAR2(4)        DEFAULT 'D' NOT NULL,
    AD_Tab_ID           NUMBER(10, 0)      NOT NULL,
    AD_Column_ID        NUMBER(10, 0),
    AD_FieldGroup_ID    NUMBER(10, 0),
    DisplayLogic        NVARCHAR2(2000)    NOT NULL,
    DisplayLength       NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    SeqNo               NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    SortNo              NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    ObscureType         CHAR(3)            NOT NULL,
    CONSTRAINT AD_Field_Key PRIMARY KEY (AD_Field_ID)
)
;



-- 
-- TABLE: AD_Field_Trl 
--

CREATE TABLE AD_Field_Trl(
    AD_Field_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_Field_Trl_Key PRIMARY KEY (AD_Field_ID, AD_Language)
)
;



-- 
-- TABLE: AD_FieldGroup 
--

CREATE TABLE AD_FieldGroup(
    AD_FieldGroup_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,
    EntityType          VARCHAR2(4)      DEFAULT 'D' NOT NULL,
    CONSTRAINT AD_FieldGroup_Key PRIMARY KEY (AD_FieldGroup_ID)
)
;



-- 
-- TABLE: AD_FieldGroup_Trl 
--

CREATE TABLE AD_FieldGroup_Trl(
    AD_FieldGroup_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_FieldGroup_Trl_Key PRIMARY KEY (AD_FieldGroup_ID, AD_Language)
)
;



-- 
-- TABLE: AD_Find 
--

CREATE TABLE AD_Find(
    AD_Find_ID      NUMBER(10, 0)    NOT NULL,
    Find_ID         NUMBER,
    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,
    AndOr           CHAR(1)          NOT NULL,
    AD_Column_ID    NUMBER(10, 0)    NOT NULL,
    Operation       CHAR(2)          NOT NULL,
    Value           NVARCHAR2(40)    NOT NULL,
    Value2          NVARCHAR2(40)    NOT NULL,
    CONSTRAINT AD_Find_Key PRIMARY KEY (AD_Find_ID)
)
;



-- 
-- TABLE: AD_Form 
--

CREATE TABLE AD_Form(
    AD_Form_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),
    EntityType      VARCHAR2(4)        DEFAULT 'D' NOT NULL,
    AccessLevel     CHAR(1)            NOT NULL,
    ClassName       NVARCHAR2(60),
    JSPURL          NVARCHAR2(120),
    CONSTRAINT AD_Form_Key PRIMARY KEY (AD_Form_ID)
)
;



-- 
-- TABLE: AD_Form_Access 
--

CREATE TABLE AD_Form_Access(
    AD_Role_ID      NUMBER(10, 0)    NOT NULL,
    AD_Form_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,
    CONSTRAINT AD_Form_Access_Key PRIMARY KEY (AD_Role_ID, AD_Form_ID)
)
;



-- 
-- TABLE: AD_Form_Trl 
--

CREATE TABLE AD_Form_Trl(
    AD_Form_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
                    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),
    IsTranslated    CHAR(1)            DEFAULT 'N' NOT NULL
                    CHECK (IsTranslated in ('Y','N')),
    CONSTRAINT AD_Form_Trl_Key PRIMARY KEY (AD_Form_ID, AD_Language)
)
;



-- 
-- TABLE: AD_Image 
--

CREATE TABLE AD_Image(
    AD_Image_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),
    EntityType      VARCHAR2(4)       DEFAULT 'D' NOT NULL,
    ImageURL        NVARCHAR2(120),
    BinaryData      BLOB              NOT NULL,
    CONSTRAINT AD_Image_Key PRIMARY KEY (AD_Image_ID)
)
;



-- 
-- TABLE: AD_ImpFormat 
--

CREATE TABLE AD_ImpFormat(
    AD_ImpFormat_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_Table_ID        NUMBER(10, 0)     NOT NULL,
    FormatType         CHAR(1)           NOT NULL,
    Processing         CHAR(1),
    CONSTRAINT AD_ImpFormat_Key PRIMARY KEY (AD_ImpFormat_ID)
)
;



-- 
-- TABLE: AD_ImpFormat_Row 
--

CREATE TABLE AD_ImpFormat_Row(
    AD_ImpFormat_Row_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_ImpFormat_ID        NUMBER(10, 0)      NOT NULL,
    SeqNo                  NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    Name                   NVARCHAR2(60)      NOT NULL,
    AD_Column_ID           NUMBER(10, 0)      NOT NULL,
    StartNo                NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    EndNo                  NUMBER(10, 0)      DEFAULT 0 NOT NULL,
    DataType               CHAR(1)            NOT NULL,
    DataFormat             NVARCHAR2(20)      NOT NULL,
    DecimalPoint           CHAR(1)            NOT NULL,
    ConstantValue          NVARCHAR2(60),
    Callout                NVARCHAR2(60),
    Script                 NVARCHAR2(2000),
    CONSTRAINT AD_ImpFormat_Row_Key PRIMARY KEY (AD_ImpFormat_Row_ID)
)
;



-- 
-- TABLE: AD_LabelPrinter