CREATE TABLE gtg_ts_assetssourceinf (
    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,
    AP_DISTRIBUTION_LINE_NUMBER       NUMBER(18, 0) ,
    ASSET_ID                          NUMBER(18, 0) ,
    ASSET_INVOICE_ID                  NUMBER(18, 0) ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    CORP_SOURCE_LINE_ID               NUMBER(18, 0) ,
    CREATE_BATCH_DATE                 DATE          ,
    CREATE_BATCH_ID                   NUMBER(18, 0) ,
    DATE_EFFECTIVE                    DATE          ,
    DATE_INEFFECTIVE                  DATE          ,
    DELETED_FLAG                      VARCHAR2(12)  ,
    DEPRECIATE_IN_GROUP_FLAG          VARCHAR2(4)   ,
    DESCRIPTION                       VARCHAR2(320) ,
    EXPENDITURE_ORGANIZATION_ID       NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID               NUMBER(18, 0) ,
    FAASSETINVOICES_CB                VARCHAR2(256) ,
    FAASSETINVOICES_CD                TIMESTAMP(6)  ,
    FAASSETINVOICES_LUB               VARCHAR2(256) ,
    FAASSETINVOICES_LUD               TIMESTAMP(6)  ,
    FEEDER_SYSTEM_NAME                VARCHAR2(160) ,
    FIXED_ASSETS_COST                 NUMBER        ,
    INVOICE_DATE                      DATE          ,
    INVOICE_DISTRIBUTION_ID           NUMBER(18, 0) ,
    INVOICE_ID                        NUMBER(18, 0) ,
    INVOICE_LINE_DESCRIPTION          VARCHAR2(960) ,
    INVOICE_LINE_NUMBER               NUMBER        ,
    INVOICE_LINE_TYPE                 VARCHAR2(120) ,
    INVOICE_NUMBER                    VARCHAR2(200) ,
    INVOICE_PAYMENT_ID                NUMBER(18, 0) ,
    INVOICE_TRANSACTION_ID_IN         NUMBER(18, 0) ,
    INVOICE_VOUCHER_NUMBER            VARCHAR2(200) ,
    LINE_TYPE_LOOKUP_CODE             VARCHAR2(100) ,
    MATERIAL_INDICATOR_FLAG           VARCHAR2(4)   ,
    MERGED_CODE                       VARCHAR2(12)  ,
    MERGE_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    PARENT_MASS_ADDITION_ID           NUMBER(18, 0) ,
    PAYABLES_BATCH_NAME               VARCHAR2(200) ,
    PAYABLES_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    PAYABLES_COST                     NUMBER        ,
    PAYABLES_UNITS                    NUMBER        ,
    POST_BATCH_ID                     NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    PO_NUMBER                         VARCHAR2(120) ,
    PO_VENDOR_ID                      NUMBER(18, 0) ,
    PRIOR_SOURCE_LINE_ID              NUMBER(18, 0) ,
    PROJECT_ASSET_LINE_ID             NUMBER(18, 0) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    PROJECT_NUMBER                    VARCHAR2(100) ,
    PROJECT_ORGANIZATION_ID           NUMBER(18, 0) ,
    PROJECT_TASK_NUMBER               VARCHAR2(400) ,
    PROJECT_TXN_DOC_ENTRY_ID          NUMBER(18, 0) ,
    SOURCE_LINE_ID                    NUMBER(18, 0) ,
    SPLIT_CODE                        VARCHAR2(12)  ,
    SPLIT_MERGED_CODE                 VARCHAR2(12)  ,
    SPLIT_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    TASK_ORGANIZATION_ID              NUMBER(18, 0) ,
    UNREVALUED_COST                   NUMBER        ,
    VENDOR_NAME                       VARCHAR2(1440),
    VENDOR_NUMBER                     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,
    AP_DISTRIBUTION_LINE_NUMBER       NUMBER(18, 0) ,
    ASSET_ID                          NUMBER(18, 0) ,
    ASSET_INVOICE_ID                  NUMBER(18, 0) ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    CORP_SOURCE_LINE_ID               NUMBER(18, 0) ,
    CREATE_BATCH_DATE                 DATE          ,
    CREATE_BATCH_ID                   NUMBER(18, 0) ,
    DATE_EFFECTIVE                    DATE          ,
    DATE_INEFFECTIVE                  DATE          ,
    DELETED_FLAG                      VARCHAR2(12)  ,
    DEPRECIATE_IN_GROUP_FLAG          VARCHAR2(4)   ,
    DESCRIPTION                       VARCHAR2(320) ,
    EXPENDITURE_ORGANIZATION_ID       NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID               NUMBER(18, 0) ,
    FAASSETINVOICES_CB                VARCHAR2(256) ,
    FAASSETINVOICES_CD                TIMESTAMP(6)  ,
    FAASSETINVOICES_LUB               VARCHAR2(256) ,
    FAASSETINVOICES_LUD               TIMESTAMP(6)  ,
    FEEDER_SYSTEM_NAME                VARCHAR2(160) ,
    FIXED_ASSETS_COST                 NUMBER        ,
    INVOICE_DATE                      DATE          ,
    INVOICE_DISTRIBUTION_ID           NUMBER(18, 0) ,
    INVOICE_ID                        NUMBER(18, 0) ,
    INVOICE_LINE_DESCRIPTION          VARCHAR2(960) ,
    INVOICE_LINE_NUMBER               NUMBER        ,
    INVOICE_LINE_TYPE                 VARCHAR2(120) ,
    INVOICE_NUMBER                    VARCHAR2(200) ,
    INVOICE_PAYMENT_ID                NUMBER(18, 0) ,
    INVOICE_TRANSACTION_ID_IN         NUMBER(18, 0) ,
    INVOICE_VOUCHER_NUMBER            VARCHAR2(200) ,
    LINE_TYPE_LOOKUP_CODE             VARCHAR2(100) ,
    MATERIAL_INDICATOR_FLAG           VARCHAR2(4)   ,
    MERGED_CODE                       VARCHAR2(12)  ,
    MERGE_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    PARENT_MASS_ADDITION_ID           NUMBER(18, 0) ,
    PAYABLES_BATCH_NAME               VARCHAR2(200) ,
    PAYABLES_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    PAYABLES_COST                     NUMBER        ,
    PAYABLES_UNITS                    NUMBER        ,
    POST_BATCH_ID                     NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    PO_NUMBER                         VARCHAR2(120) ,
    PO_VENDOR_ID                      NUMBER(18, 0) ,
    PRIOR_SOURCE_LINE_ID              NUMBER(18, 0) ,
    PROJECT_ASSET_LINE_ID             NUMBER(18, 0) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    PROJECT_NUMBER                    VARCHAR2(100) ,
    PROJECT_ORGANIZATION_ID           NUMBER(18, 0) ,
    PROJECT_TASK_NUMBER               VARCHAR2(400) ,
    PROJECT_TXN_DOC_ENTRY_ID          NUMBER(18, 0) ,
    SOURCE_LINE_ID                    NUMBER(18, 0) ,
    SPLIT_CODE                        VARCHAR2(12)  ,
    SPLIT_MERGED_CODE                 VARCHAR2(12)  ,
    SPLIT_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    TASK_ORGANIZATION_ID              NUMBER(18, 0) ,
    UNREVALUED_COST                   NUMBER        ,
    VENDOR_NAME                       VARCHAR2(1440),
    VENDOR_NUMBER                     VARCHAR2(120) ,
    CONSTRAINT pk_gtg_ts_assetssourceinf PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
