CREATE TABLE gtg_etl_assets (
    ID                        NUMBER           NOT NULL,
    MAPPER_ID                 NUMBER           NOT NULL,
    ETL_ID                    VARCHAR2(100)    NOT NULL,
    ETL_LANGUAGE              VARCHAR2(100),
    ASSETS_CRTDBY             VARCHAR2(64) ,
    ASSETS_CRTDON             TIMESTAMP(6) ,
    ASSETS_LSTUPTBY           VARCHAR2(64) ,
    ASSETS_LSTUPTON           TIMESTAMP(6) ,
    ASSETADDCRTBY             VARCHAR2(64) ,
    ASSETADDCRTDATE           TIMESTAMP(6) ,
    ASSETADDLSTUPBY           VARCHAR2(64) ,
    ASSETADDLSTUPDT           TIMESTAMP(6) ,
    ASSETALWDEPRLIMAMT        NUMBER       ,
    ASSETCONVDT               TIMESTAMP(6) ,
    ASSETCURUNIT              NUMBER       ,
    ASSETDEPRFLG              VARCHAR2(3)  ,
    ASSETDTPLACINSRV          TIMESTAMP(6) ,
    ASSETPRORTDT              TIMESTAMP(6) ,
    ASSETSHORTFISYRFLG        VARCHAR2(3)  ,
    ASSETWRKATTRCATCD         VARCHAR2(30) ,
    ASSETWRKBOUGHT            VARCHAR2(50) ,
    ASSETWRKCOMMIT            VARCHAR2(30) ,
    ASSETWRKCOST              NUMBER       ,
    ASSETWRKDESC              VARCHAR2(80) ,
    ASSETWRKID                NUMBER       ,
    ASSETWRKINUSEFLAG         VARCHAR2(3)  ,
    ASSETWRKINVLAW            VARCHAR2(30) ,
    ASSETWRKKEY               NUMBER       ,
    ASSETWRKLEASEID           NUMBER       ,
    ASSETWRKMANUNAME          VARCHAR2(360),
    ASSETWRKMODEL             VARCHAR2(40) ,
    ASSETWRKNUM               VARCHAR2(30) ,
    ASSETWRKORIGCOST          NUMBER       ,
    ASSETWRKOWNLEASE          VARCHAR2(15) ,
    ASSETWRKPARENT            NUMBER       ,
    ASSETWRKPCNTSALVAGEVAL    NUMBER       ,
    ASSETWRKPHYINV            VARCHAR2(3)  ,
    ASSETWRKPROPCLS           VARCHAR2(4)  ,
    ASSETWRKRECOVERCOST       NUMBER       ,
    ASSETWRKREVALCEIL         NUMBER       ,
    ASSETWRKSALVAGETYP        VARCHAR2(30) ,
    ASSETWRKSALVAGEVAL        NUMBER       ,
    ASSETWRKSERIALNUM         VARCHAR2(35) ,
    ASSETWRKTAGNUM            VARCHAR2(15) ,
    ASSETWRKTRANHEADIN        NUMBER       ,
    ASSETWRKTYPE              VARCHAR2(11) ,
    ASTADDCREATEDBY           VARCHAR2(64) ,
    ASTADDCREATEDON           TIMESTAMP(6) ,
    ASTADDLASTUPDATEDON       TIMESTAMP(6) ,
    ASTADDUPDATEDBY           VARCHAR2(64) ,
    BOOKTYPECODE              VARCHAR2(30) ,
    CREATED_BY                VARCHAR2(64)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(64)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(32) ,
    ID                        NUMBER           NOT NULL,
    MAPPER_ID                 NUMBER           NOT NULL,
    ETL_ID                    VARCHAR2(100)    NOT NULL,
    ETL_LANGUAGE              VARCHAR2(100),
    ASSETS_CRTDBY             VARCHAR2(64) ,
    ASSETS_CRTDON             TIMESTAMP(6) ,
    ASSETS_LSTUPTBY           VARCHAR2(64) ,
    ASSETS_LSTUPTON           TIMESTAMP(6) ,
    ASSETADDCRTBY             VARCHAR2(64) ,
    ASSETADDCRTDATE           TIMESTAMP(6) ,
    ASSETADDLSTUPBY           VARCHAR2(64) ,
    ASSETADDLSTUPDT           TIMESTAMP(6) ,
    ASSETALWDEPRLIMAMT        NUMBER       ,
    ASSETCONVDT               TIMESTAMP(6) ,
    ASSETCURUNIT              NUMBER       ,
    ASSETDEPRFLG              VARCHAR2(3)  ,
    ASSETDTPLACINSRV          TIMESTAMP(6) ,
    ASSETPRORTDT              TIMESTAMP(6) ,
    ASSETSHORTFISYRFLG        VARCHAR2(3)  ,
    ASSETWRKATTRCATCD         VARCHAR2(30) ,
    ASSETWRKBOUGHT            VARCHAR2(50) ,
    ASSETWRKCOMMIT            VARCHAR2(30) ,
    ASSETWRKCOST              NUMBER       ,
    ASSETWRKDESC              VARCHAR2(80) ,
    ASSETWRKID                NUMBER       ,
    ASSETWRKINUSEFLAG         VARCHAR2(3)  ,
    ASSETWRKINVLAW            VARCHAR2(30) ,
    ASSETWRKKEY               NUMBER       ,
    ASSETWRKLEASEID           NUMBER       ,
    ASSETWRKMANUNAME          VARCHAR2(360),
    ASSETWRKMODEL             VARCHAR2(40) ,
    ASSETWRKNUM               VARCHAR2(30) ,
    ASSETWRKORIGCOST          NUMBER       ,
    ASSETWRKOWNLEASE          VARCHAR2(15) ,
    ASSETWRKPARENT            NUMBER       ,
    ASSETWRKPCNTSALVAGEVAL    NUMBER       ,
    ASSETWRKPHYINV            VARCHAR2(3)  ,
    ASSETWRKPROPCLS           VARCHAR2(4)  ,
    ASSETWRKRECOVERCOST       NUMBER       ,
    ASSETWRKREVALCEIL         NUMBER       ,
    ASSETWRKSALVAGETYP        VARCHAR2(30) ,
    ASSETWRKSALVAGEVAL        NUMBER       ,
    ASSETWRKSERIALNUM         VARCHAR2(35) ,
    ASSETWRKTAGNUM            VARCHAR2(15) ,
    ASSETWRKTRANHEADIN        NUMBER       ,
    ASSETWRKTYPE              VARCHAR2(11) ,
    ASTADDCREATEDBY           VARCHAR2(64) ,
    ASTADDCREATEDON           TIMESTAMP(6) ,
    ASTADDLASTUPDATEDON       TIMESTAMP(6) ,
    ASTADDUPDATEDBY           VARCHAR2(64) ,
    BOOKTYPECODE              VARCHAR2(30) ,
    CREATED_BY                VARCHAR2(64)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(64)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(32) ,
    CONSTRAINT pk_gtg_etl_assets PRIMARY KEY (ETL_LANGUAGE, ASSETWRKID, ASSETWRKTRANHEADIN, ETL_LANGUAGE, ASSETWRKID, ASSETWRKTRANHEADIN)
);
