CREATE TABLE gtg_ts_paydeductiontypes (
    ETL_SEQUENCE_ID              NUMBER(19, 0),
    ETL_VERSION_NUMBER           NUMBER(18, 0),
    DELETE_VERSION_NUMBER        NUMBER(18, 0),
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    BASE_DEDUCTION_TYPE_ID       NUMBER(18, 0),
    BASE_NAME                    VARCHAR2(960),
    DEDUCTION_CODE               VARCHAR2(960),
    DEDUCTION_GROUP_ID           NUMBER(18, 0),
    DEDUCTION_TYPE_ID            NUMBER(18, 0),
    DISPLAY_SEQUENCE             NUMBER(18, 0),
    ENTERPRISE_ID                NUMBER(18, 0),
    ID                           NUMBER(18, 0),
    LANGUAGECOLUMN               VARCHAR2(16) ,
    LEGISLATION_CODE             VARCHAR2(120),
    LEGISLATIVE_DATA_GROUP_ID    NUMBER(18, 0),
    MODID                        VARCHAR2(128),
    NAME                         VARCHAR2(960),
    PAYDEDUCTIONTYPESTL_CB       VARCHAR2(256),
    PAYDEDUCTIONTYPESTL_CD       TIMESTAMP(6) ,
    PAYDEDUCTIONTYPESTL_LUB      VARCHAR2(256),
    PAYDEDUCTIONTYPESTL_LUD      TIMESTAMP(6) ,
    PAYDEDUCTIONTYPES_CB         VARCHAR2(256),
    PAYDEDUCTIONTYPES_CD         TIMESTAMP(6) ,
    PAYDEDUCTIONTYPES_LUB        VARCHAR2(256),
    PAYDEDUCTIONTYPES_LUD        TIMESTAMP(6) ,
    USE_ALL_TAX_UNITS            VARCHAR2(120),
    ETL_SEQUENCE_ID              NUMBER(19, 0),
    ETL_VERSION_NUMBER           NUMBER(18, 0),
    DELETE_VERSION_NUMBER        NUMBER(18, 0),
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    BASE_DEDUCTION_TYPE_ID       NUMBER(18, 0),
    BASE_NAME                    VARCHAR2(960),
    DEDUCTION_CODE               VARCHAR2(960),
    DEDUCTION_GROUP_ID           NUMBER(18, 0),
    DEDUCTION_TYPE_ID            NUMBER(18, 0),
    DISPLAY_SEQUENCE             NUMBER(18, 0),
    ENTERPRISE_ID                NUMBER(18, 0),
    ID                           NUMBER(18, 0),
    LANGUAGECOLUMN               VARCHAR2(16) ,
    LEGISLATION_CODE             VARCHAR2(120),
    LEGISLATIVE_DATA_GROUP_ID    NUMBER(18, 0),
    LNG                          VARCHAR2(16) ,
    MODID                        VARCHAR2(128),
    NAME                         VARCHAR2(960),
    PAYDEDUCTIONTYPESTL_CB       VARCHAR2(256),
    PAYDEDUCTIONTYPESTL_CD       TIMESTAMP(6) ,
    PAYDEDUCTIONTYPESTL_LUB      VARCHAR2(256),
    PAYDEDUCTIONTYPESTL_LUD      TIMESTAMP(6) ,
    PAYDEDUCTIONTYPES_CB         VARCHAR2(256),
    PAYDEDUCTIONTYPES_CD         TIMESTAMP(6) ,
    PAYDEDUCTIONTYPES_LUB        VARCHAR2(256),
    PAYDEDUCTIONTYPES_LUD        TIMESTAMP(6) ,
    USE_ALL_TAX_UNITS            VARCHAR2(120),
    CONSTRAINT pk_gtg_ts_paydeductiontypes PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
