CREATE TABLE gtg_ts_projectcosts (
    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,
    ACCT_BURDENED_COST              NUMBER       ,
    ACCT_CURRENCY_CODE              VARCHAR2(60) ,
    ACCT_RAW_COST                   NUMBER       ,
    BILLABLE_FLAG                   VARCHAR2(4)  ,
    BUDGET_PERIOD_ID                NUMBER(18, 0),
    BURDEN_COST_RATE                NUMBER       ,
    CAPITALIZABLE_FLAG              VARCHAR2(4)  ,
    CONTRACT_ID                     NUMBER(18, 0),
    COST_JOB_ID                     NUMBER(18, 0),
    DENOM_BURDENED_COST             NUMBER       ,
    DENOM_CURRENCY_CODE             VARCHAR2(60) ,
    DENOM_RAW_COST                  NUMBER       ,
    DOCUMENT_ID                     NUMBER(18, 0),
    DOC_ENTRY_ID                    NUMBER(18, 0),
    EXPENDITURE_ITEM_DATE           DATE         ,
    EXPENDITURE_ITEM_ID             NUMBER(18, 0),
    EXPENDITURE_ORGANIZATION_ID     NUMBER(18, 0),
    EXPENDITURE_TYPE_ID             NUMBER(18, 0),
    EXPNDITEMID                     NUMBER(18, 0),
    EXP_GROUP_ID                    NUMBER(18, 0),
    FUNDING_ALLOCATION_ID           NUMBER(18, 0),
    LABOR_COST_MULTIPLIER_NAME      VARCHAR2(80) ,
    LINE_NUM                        NUMBER(18, 0),
    LINE_TYPE                       VARCHAR2(4)  ,
    ORGID                           NUMBER(18, 0),
    PJCCOSTDISTLINESALL_CB          VARCHAR2(256),
    PJCCOSTDISTLINESALL_CD          TIMESTAMP(6) ,
    PJCCOSTDISTLINESALL_LUB         VARCHAR2(256),
    PJCCOSTDISTLINESALL_LUD         TIMESTAMP(6) ,
    PJCEXPGROUPSALL_CB              VARCHAR2(256),
    PJCEXPGROUPSALL_CD              TIMESTAMP(6) ,
    PJCEXPGROUPSALL_LUB             VARCHAR2(256),
    PJCEXPGROUPSALL_LUD             TIMESTAMP(6) ,
    PJCEXPITEMSALL_CB               VARCHAR2(256),
    PJCEXPITEMSALL_CD               TIMESTAMP(6) ,
    PJCEXPITEMSALL_LUB              VARCHAR2(256),
    PJCEXPITEMSALL_LUD              TIMESTAMP(6) ,
    PROJECT_BURDENED_COST           NUMBER       ,
    PROJECT_CURRENCY_CODE           VARCHAR2(60) ,
    PROJECT_EXCHANGE_RATE           NUMBER       ,
    PROJECT_ID                      NUMBER(18, 0),
    PROJECT_RATE_DATE               DATE         ,
    PROJECT_RATE_TYPE               VARCHAR2(120),
    PROJECT_RAW_COST                NUMBER       ,
    PROJECT_UNIT_ID                 NUMBER(18, 0),
    PROJFUNC_BURDENED_COST          NUMBER       ,
    PROJFUNC_CURRENCY_CODE          VARCHAR2(60) ,
    PROJFUNC_RAW_COST               NUMBER       ,
    PRVDR_GL_DATE                   DATE         ,
    PRVDR_GL_PERIOD_NAME            VARCHAR2(60) ,
    PRVDR_PA_DATE                   DATE         ,
    PRVDR_PA_PERIOD_NAME            VARCHAR2(60) ,
    QUANTITY                        NUMBER       ,
    RAW_COST_RATE                   NUMBER       ,
    TASK_ID                         NUMBER(18, 0),
    TRANSACTION_SOURCE_ID           NUMBER(18, 0),
    TRANSFERRED_FROM_EXP_ITEM_ID    NUMBER(18, 0),
    UNIT_OF_MEASURE                 VARCHAR2(120),
    USER_BATCH_NAME                 VARCHAR2(800),
    WORK_TYPE_ID                    NUMBER(18, 0),
    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,
    ACCT_BURDENED_COST              NUMBER       ,
    ACCT_CURRENCY_CODE              VARCHAR2(60) ,
    ACCT_RAW_COST                   NUMBER       ,
    BILLABLE_FLAG                   VARCHAR2(4)  ,
    BUDGET_PERIOD_ID                NUMBER(18, 0),
    BURDEN_COST_RATE                NUMBER       ,
    CAPITALIZABLE_FLAG              VARCHAR2(4)  ,
    CONTRACT_ID                     NUMBER(18, 0),
    COST_JOB_ID                     NUMBER(18, 0),
    DENOM_BURDENED_COST             NUMBER       ,
    DENOM_CURRENCY_CODE             VARCHAR2(60) ,
    DENOM_RAW_COST                  NUMBER       ,
    DOCUMENT_ID                     NUMBER(18, 0),
    DOC_ENTRY_ID                    NUMBER(18, 0),
    EXPENDITURE_ITEM_DATE           DATE         ,
    EXPENDITURE_ITEM_ID             NUMBER(18, 0),
    EXPENDITURE_ORGANIZATION_ID     NUMBER(18, 0),
    EXPENDITURE_TYPE_ID             NUMBER(18, 0),
    EXPNDITEMID                     NUMBER(18, 0),
    EXP_GROUP_ID                    NUMBER(18, 0),
    FUNDING_ALLOCATION_ID           NUMBER(18, 0),
    LABOR_COST_MULTIPLIER_NAME      VARCHAR2(80) ,
    LINE_NUM                        NUMBER(18, 0),
    LINE_TYPE                       VARCHAR2(4)  ,
    ORGID                           NUMBER(18, 0),
    PJCCOSTDISTLINESALL_CB          VARCHAR2(256),
    PJCCOSTDISTLINESALL_CD          TIMESTAMP(6) ,
    PJCCOSTDISTLINESALL_LUB         VARCHAR2(256),
    PJCCOSTDISTLINESALL_LUD         TIMESTAMP(6) ,
    PJCEXPGROUPSALL_CB              VARCHAR2(256),
    PJCEXPGROUPSALL_CD              TIMESTAMP(6) ,
    PJCEXPGROUPSALL_LUB             VARCHAR2(256),
    PJCEXPGROUPSALL_LUD             TIMESTAMP(6) ,
    PJCEXPITEMSALL_CB               VARCHAR2(256),
    PJCEXPITEMSALL_CD               TIMESTAMP(6) ,
    PJCEXPITEMSALL_LUB              VARCHAR2(256),
    PJCEXPITEMSALL_LUD              TIMESTAMP(6) ,
    PROJECT_BURDENED_COST           NUMBER       ,
    PROJECT_CURRENCY_CODE           VARCHAR2(60) ,
    PROJECT_EXCHANGE_RATE           NUMBER       ,
    PROJECT_ID                      NUMBER(18, 0),
    PROJECT_RATE_DATE               DATE         ,
    PROJECT_RATE_TYPE               VARCHAR2(120),
    PROJECT_RAW_COST                NUMBER       ,
    PROJECT_UNIT_ID                 NUMBER(18, 0),
    PROJFUNC_BURDENED_COST          NUMBER       ,
    PROJFUNC_CURRENCY_CODE          VARCHAR2(60) ,
    PROJFUNC_RAW_COST               NUMBER       ,
    PRVDR_GL_DATE                   DATE         ,
    PRVDR_GL_PERIOD_NAME            VARCHAR2(60) ,
    PRVDR_PA_DATE                   DATE         ,
    PRVDR_PA_PERIOD_NAME            VARCHAR2(60) ,
    QUANTITY                        NUMBER       ,
    RAW_COST_RATE                   NUMBER       ,
    TASK_ID                         NUMBER(18, 0),
    TRANSACTION_SOURCE_ID           NUMBER(18, 0),
    TRANSFERRED_FROM_EXP_ITEM_ID    NUMBER(18, 0),
    UNIT_OF_MEASURE                 VARCHAR2(120),
    USER_BATCH_NAME                 VARCHAR2(800),
    WORK_TYPE_ID                    NUMBER(18, 0),
    CONSTRAINT pk_gtg_ts_projectcosts PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
