VIEW: PA.PA_EI_DENORM_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, ORIG_TRANSACTION_REFERENCE_7 ORIG_TRANSACTION_REFERENCE_7, ADJUSTED_EXPENDITURE_ITEM_ID_7 ADJUSTED_EXPENDITURE_ITEM_ID_7, NET_ZERO_ADJUSTMENT_FLAG_7 NET_ZERO_ADJUSTMENT_FLAG_7, EXPENDITURE_COMMENT_7 EXPENDITURE_COMMENT_7, DENORM_TOTAL_QTY DENORM_TOTAL_QTY, DENORM_TOTAL_AMOUNT DENORM_TOTAL_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EXPENDITURE_ID EXPENDITURE_ID, DENORM_ID DENORM_ID, PERSON_ID PERSON_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, BILLABLE_FLAG BILLABLE_FLAG, EXPENDITURE_TYPE EXPENDITURE_TYPE, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE, UNIT_OF_MEASURE UNIT_OF_MEASURE, DEFAULT_SYS_LINK_FUNC DEFAULT_SYS_LINK_FUNC, EXPENDITURE_ITEM_ID_1 EXPENDITURE_ITEM_ID_1, EXPENDITURE_ITEM_DATE_1 EXPENDITURE_ITEM_DATE_1, QUANTITY_1 QUANTITY_1, SYSTEM_LINKAGE_FUNCTION_1 SYSTEM_LINKAGE_FUNCTION_1, NON_LABOR_RESOURCE_1 NON_LABOR_RESOURCE_1, ORGANIZATION_ID_1 ORGANIZATION_ID_1, OVERRIDE_TO_ORGANIZATION_ID_1 OVERRIDE_TO_ORGANIZATION_ID_1, RAW_COST_1 RAW_COST_1, RAW_COST_RATE_1 RAW_COST_RATE_1, ATTRIBUTE_CATEGORY_1 ATTRIBUTE_CATEGORY_1, ATTRIBUTE1_1 ATTRIBUTE1_1, ATTRIBUTE1_2 ATTRIBUTE1_2, ATTRIBUTE1_3 ATTRIBUTE1_3, ATTRIBUTE1_4 ATTRIBUTE1_4, ATTRIBUTE1_5 ATTRIBUTE1_5, ATTRIBUTE1_6 ATTRIBUTE1_6, ATTRIBUTE1_7 ATTRIBUTE1_7, ATTRIBUTE1_8 ATTRIBUTE1_8, ATTRIBUTE1_9 ATTRIBUTE1_9, ATTRIBUTE1_10 ATTRIBUTE1_10, ORIG_TRANSACTION_REFERENCE_1 ORIG_TRANSACTION_REFERENCE_1, ADJUSTED_EXPENDITURE_ITEM_ID_1 ADJUSTED_EXPENDITURE_ITEM_ID_1, NET_ZERO_ADJUSTMENT_FLAG_1 NET_ZERO_ADJUSTMENT_FLAG_1, ATTRIBUTE_CATEGORY_6 ATTRIBUTE_CATEGORY_6, ATTRIBUTE6_1 ATTRIBUTE6_1, ATTRIBUTE6_2 ATTRIBUTE6_2, ATTRIBUTE6_3 ATTRIBUTE6_3, ATTRIBUTE6_4 ATTRIBUTE6_4, ATTRIBUTE6_5 ATTRIBUTE6_5, ATTRIBUTE6_6 ATTRIBUTE6_6, ATTRIBUTE6_7 ATTRIBUTE6_7, ATTRIBUTE6_8 ATTRIBUTE6_8, ATTRIBUTE6_9 ATTRIBUTE6_9, ATTRIBUTE6_10 ATTRIBUTE6_10, ORIG_TRANSACTION_REFERENCE_6 ORIG_TRANSACTION_REFERENCE_6, ADJUSTED_EXPENDITURE_ITEM_ID_6 ADJUSTED_EXPENDITURE_ITEM_ID_6, NET_ZERO_ADJUSTMENT_FLAG_6 NET_ZERO_ADJUSTMENT_FLAG_6, EXPENDITURE_COMMENT_6 EXPENDITURE_COMMENT_6, EXPENDITURE_ITEM_ID_7 EXPENDITURE_ITEM_ID_7, EXPENDITURE_ITEM_DATE_7 EXPENDITURE_ITEM_DATE_7, QUANTITY_7 QUANTITY_7, SYSTEM_LINKAGE_FUNCTION_7 SYSTEM_LINKAGE_FUNCTION_7, NON_LABOR_RESOURCE_7 NON_LABOR_RESOURCE_7, ORGANIZATION_ID_7 ORGANIZATION_ID_7, OVERRIDE_TO_ORGANIZATION_ID_7 OVERRIDE_TO_ORGANIZATION_ID_7, RAW_COST_7 RAW_COST_7, RAW_COST_RATE_7 RAW_COST_RATE_7, ATTRIBUTE_CATEGORY_7 ATTRIBUTE_CATEGORY_7, ATTRIBUTE7_1 ATTRIBUTE7_1, ATTRIBUTE7_2 ATTRIBUTE7_2, ATTRIBUTE7_3 ATTRIBUTE7_3, ATTRIBUTE7_4 ATTRIBUTE7_4, ATTRIBUTE7_5 ATTRIBUTE7_5, ATTRIBUTE7_6 ATTRIBUTE7_6, ATTRIBUTE7_7 ATTRIBUTE7_7, ATTRIBUTE7_8 ATTRIBUTE7_8, ATTRIBUTE7_9 ATTRIBUTE7_9, ATTRIBUTE7_10 ATTRIBUTE7_10, EXPENDITURE_COMMENT_4 EXPENDITURE_COMMENT_4, EXPENDITURE_ITEM_ID_5 EXPENDITURE_ITEM_ID_5, EXPENDITURE_ITEM_DATE_5 EXPENDITURE_ITEM_DATE_5, QUANTITY_5 QUANTITY_5, SYSTEM_LINKAGE_FUNCTION_5 SYSTEM_LINKAGE_FUNCTION_5, NON_LABOR_RESOURCE_5 NON_LABOR_RESOURCE_5, ORGANIZATION_ID_5 ORGANIZATION_ID_5, OVERRIDE_TO_ORGANIZATION_ID_5 OVERRIDE_TO_ORGANIZATION_ID_5, RAW_COST_5 RAW_COST_5, RAW_COST_RATE_5 RAW_COST_RATE_5, ATTRIBUTE_CATEGORY_5 ATTRIBUTE_CATEGORY_5, ATTRIBUTE5_1 ATTRIBUTE5_1, ATTRIBUTE5_2 ATTRIBUTE5_2, ATTRIBUTE5_3 ATTRIBUTE5_3, ATTRIBUTE5_4 ATTRIBUTE5_4, ATTRIBUTE5_5 ATTRIBUTE5_5, ATTRIBUTE5_6 ATTRIBUTE5_6, ATTRIBUTE5_7 ATTRIBUTE5_7, ATTRIBUTE5_8 ATTRIBUTE5_8, ATTRIBUTE5_9 ATTRIBUTE5_9, ATTRIBUTE5_10 ATTRIBUTE5_10, ORIG_TRANSACTION_REFERENCE_5 ORIG_TRANSACTION_REFERENCE_5, ADJUSTED_EXPENDITURE_ITEM_ID_5 ADJUSTED_EXPENDITURE_ITEM_ID_5, NET_ZERO_ADJUSTMENT_FLAG_5 NET_ZERO_ADJUSTMENT_FLAG_5, EXPENDITURE_COMMENT_5 EXPENDITURE_COMMENT_5, EXPENDITURE_ITEM_ID_6 EXPENDITURE_ITEM_ID_6, EXPENDITURE_ITEM_DATE_6 EXPENDITURE_ITEM_DATE_6, QUANTITY_6 QUANTITY_6, SYSTEM_LINKAGE_FUNCTION_6 SYSTEM_LINKAGE_FUNCTION_6, NON_LABOR_RESOURCE_6 NON_LABOR_RESOURCE_6, ORGANIZATION_ID_6 ORGANIZATION_ID_6, OVERRIDE_TO_ORGANIZATION_ID_6 OVERRIDE_TO_ORGANIZATION_ID_6, RAW_COST_6 RAW_COST_6, RAW_COST_RATE_6 RAW_COST_RATE_6, ATTRIBUTE3_2 ATTRIBUTE3_2, ATTRIBUTE3_3 ATTRIBUTE3_3, ATTRIBUTE3_4 ATTRIBUTE3_4, ATTRIBUTE3_5 ATTRIBUTE3_5, ATTRIBUTE3_6 ATTRIBUTE3_6, ATTRIBUTE3_7 ATTRIBUTE3_7, ATTRIBUTE3_8 ATTRIBUTE3_8, ATTRIBUTE3_9 ATTRIBUTE3_9, ATTRIBUTE3_10 ATTRIBUTE3_10, ORIG_TRANSACTION_REFERENCE_3 ORIG_TRANSACTION_REFERENCE_3, ADJUSTED_EXPENDITURE_ITEM_ID_3 ADJUSTED_EXPENDITURE_ITEM_ID_3, NET_ZERO_ADJUSTMENT_FLAG_3 NET_ZERO_ADJUSTMENT_FLAG_3, EXPENDITURE_COMMENT_3 EXPENDITURE_COMMENT_3, EXPENDITURE_ITEM_ID_4 EXPENDITURE_ITEM_ID_4, EXPENDITURE_ITEM_DATE_4 EXPENDITURE_ITEM_DATE_4, QUANTITY_4 QUANTITY_4, SYSTEM_LINKAGE_FUNCTION_4 SYSTEM_LINKAGE_FUNCTION_4, NON_LABOR_RESOURCE_4 NON_LABOR_RESOURCE_4, ORGANIZATION_ID_4 ORGANIZATION_ID_4, OVERRIDE_TO_ORGANIZATION_ID_4 OVERRIDE_TO_ORGANIZATION_ID_4, RAW_COST_4 RAW_COST_4, RAW_COST_RATE_4 RAW_COST_RATE_4, ATTRIBUTE_CATEGORY_4 ATTRIBUTE_CATEGORY_4, ATTRIBUTE4_1 ATTRIBUTE4_1, ATTRIBUTE4_2 ATTRIBUTE4_2, ATTRIBUTE4_3 ATTRIBUTE4_3, ATTRIBUTE4_4 ATTRIBUTE4_4, ATTRIBUTE4_5 ATTRIBUTE4_5, ATTRIBUTE4_6 ATTRIBUTE4_6, ATTRIBUTE4_7 ATTRIBUTE4_7, ATTRIBUTE4_8 ATTRIBUTE4_8, ATTRIBUTE4_9 ATTRIBUTE4_9, ATTRIBUTE4_10 ATTRIBUTE4_10, ORIG_TRANSACTION_REFERENCE_4 ORIG_TRANSACTION_REFERENCE_4, ADJUSTED_EXPENDITURE_ITEM_ID_4 ADJUSTED_EXPENDITURE_ITEM_ID_4, NET_ZERO_ADJUSTMENT_FLAG_4 NET_ZERO_ADJUSTMENT_FLAG_4, EXPENDITURE_COMMENT_1 EXPENDITURE_COMMENT_1, EXPENDITURE_ITEM_ID_2 EXPENDITURE_ITEM_ID_2, EXPENDITURE_ITEM_DATE_2 EXPENDITURE_ITEM_DATE_2, QUANTITY_2 QUANTITY_2, SYSTEM_LINKAGE_FUNCTION_2 SYSTEM_LINKAGE_FUNCTION_2, NON_LABOR_RESOURCE_2 NON_LABOR_RESOURCE_2, ORGANIZATION_ID_2 ORGANIZATION_ID_2, OVERRIDE_TO_ORGANIZATION_ID_2 OVERRIDE_TO_ORGANIZATION_ID_2, RAW_COST_2 RAW_COST_2, RAW_COST_RATE_2 RAW_COST_RATE_2, ATTRIBUTE_CATEGORY_2 ATTRIBUTE_CATEGORY_2, ATTRIBUTE2_1 ATTRIBUTE2_1, ATTRIBUTE2_2 ATTRIBUTE2_2, ATTRIBUTE2_3 ATTRIBUTE2_3, ATTRIBUTE2_4 ATTRIBUTE2_4, ATTRIBUTE2_5 ATTRIBUTE2_5, ATTRIBUTE2_6 ATTRIBUTE2_6, ATTRIBUTE2_7 ATTRIBUTE2_7, ATTRIBUTE2_8 ATTRIBUTE2_8, ATTRIBUTE2_9 ATTRIBUTE2_9, ATTRIBUTE2_10 ATTRIBUTE2_10, ORIG_TRANSACTION_REFERENCE_2 ORIG_TRANSACTION_REFERENCE_2, ADJUSTED_EXPENDITURE_ITEM_ID_2 ADJUSTED_EXPENDITURE_ITEM_ID_2, NET_ZERO_ADJUSTMENT_FLAG_2 NET_ZERO_ADJUSTMENT_FLAG_2, EXPENDITURE_COMMENT_2 EXPENDITURE_COMMENT_2, EXPENDITURE_ITEM_ID_3 EXPENDITURE_ITEM_ID_3, EXPENDITURE_ITEM_DATE_3 EXPENDITURE_ITEM_DATE_3, QUANTITY_3 QUANTITY_3, SYSTEM_LINKAGE_FUNCTION_3 SYSTEM_LINKAGE_FUNCTION_3, NON_LABOR_RESOURCE_3 NON_LABOR_RESOURCE_3, ORGANIZATION_ID_3 ORGANIZATION_ID_3, OVERRIDE_TO_ORGANIZATION_ID_3 OVERRIDE_TO_ORGANIZATION_ID_3, RAW_COST_3 RAW_COST_3, RAW_COST_RATE_3 RAW_COST_RATE_3, ATTRIBUTE_CATEGORY_3 ATTRIBUTE_CATEGORY_3, ATTRIBUTE3_1 ATTRIBUTE3_1, JOB_ID_1 JOB_ID_1, JOB_ID_2 JOB_ID_2, JOB_ID_3 JOB_ID_3, JOB_ID_4 JOB_ID_4, JOB_ID_5 JOB_ID_5, JOB_ID_6 JOB_ID_6, JOB_ID_7 JOB_ID_7, ADJUSTED_DENORM_ID ADJUSTED_DENORM_ID, BILLABLE_FLAG_1 BILLABLE_FLAG_1, BILLABLE_FLAG_2 BILLABLE_FLAG_2, BILLABLE_FLAG_3 BILLABLE_FLAG_3, BILLABLE_FLAG_4 BILLABLE_FLAG_4, BILLABLE_FLAG_5 BILLABLE_FLAG_5, BILLABLE_FLAG_6 BILLABLE_FLAG_6, BILLABLE_FLAG_7 BILLABLE_FLAG_7 from "PA"."PA_EI_DENORM_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, ORIG_TRANSACTION_REFERENCE_7 ORIG_TRANSACTION_REFERENCE_7
, ADJUSTED_EXPENDITURE_ITEM_ID_7 ADJUSTED_EXPENDITURE_ITEM_ID_7
, NET_ZERO_ADJUSTMENT_FLAG_7 NET_ZERO_ADJUSTMENT_FLAG_7
, EXPENDITURE_COMMENT_7 EXPENDITURE_COMMENT_7
, DENORM_TOTAL_QTY DENORM_TOTAL_QTY
, DENORM_TOTAL_AMOUNT DENORM_TOTAL_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EXPENDITURE_ID EXPENDITURE_ID
, DENORM_ID DENORM_ID
, PERSON_ID PERSON_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, BILLABLE_FLAG BILLABLE_FLAG
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, DEFAULT_SYS_LINK_FUNC DEFAULT_SYS_LINK_FUNC
, EXPENDITURE_ITEM_ID_1 EXPENDITURE_ITEM_ID_1
, EXPENDITURE_ITEM_DATE_1 EXPENDITURE_ITEM_DATE_1
, QUANTITY_1 QUANTITY_1
, SYSTEM_LINKAGE_FUNCTION_1 SYSTEM_LINKAGE_FUNCTION_1
, NON_LABOR_RESOURCE_1 NON_LABOR_RESOURCE_1
, ORGANIZATION_ID_1 ORGANIZATION_ID_1
, OVERRIDE_TO_ORGANIZATION_ID_1 OVERRIDE_TO_ORGANIZATION_ID_1
, RAW_COST_1 RAW_COST_1
, RAW_COST_RATE_1 RAW_COST_RATE_1
, ATTRIBUTE_CATEGORY_1 ATTRIBUTE_CATEGORY_1
, ATTRIBUTE1_1 ATTRIBUTE1_1
, ATTRIBUTE1_2 ATTRIBUTE1_2
, ATTRIBUTE1_3 ATTRIBUTE1_3
, ATTRIBUTE1_4 ATTRIBUTE1_4
, ATTRIBUTE1_5 ATTRIBUTE1_5
, ATTRIBUTE1_6 ATTRIBUTE1_6
, ATTRIBUTE1_7 ATTRIBUTE1_7
, ATTRIBUTE1_8 ATTRIBUTE1_8
, ATTRIBUTE1_9 ATTRIBUTE1_9
, ATTRIBUTE1_10 ATTRIBUTE1_10
, ORIG_TRANSACTION_REFERENCE_1 ORIG_TRANSACTION_REFERENCE_1
, ADJUSTED_EXPENDITURE_ITEM_ID_1 ADJUSTED_EXPENDITURE_ITEM_ID_1
, NET_ZERO_ADJUSTMENT_FLAG_1 NET_ZERO_ADJUSTMENT_FLAG_1
, ATTRIBUTE_CATEGORY_6 ATTRIBUTE_CATEGORY_6
, ATTRIBUTE6_1 ATTRIBUTE6_1
, ATTRIBUTE6_2 ATTRIBUTE6_2
, ATTRIBUTE6_3 ATTRIBUTE6_3
, ATTRIBUTE6_4 ATTRIBUTE6_4
, ATTRIBUTE6_5 ATTRIBUTE6_5
, ATTRIBUTE6_6 ATTRIBUTE6_6
, ATTRIBUTE6_7 ATTRIBUTE6_7
, ATTRIBUTE6_8 ATTRIBUTE6_8
, ATTRIBUTE6_9 ATTRIBUTE6_9
, ATTRIBUTE6_10 ATTRIBUTE6_10
, ORIG_TRANSACTION_REFERENCE_6 ORIG_TRANSACTION_REFERENCE_6
, ADJUSTED_EXPENDITURE_ITEM_ID_6 ADJUSTED_EXPENDITURE_ITEM_ID_6
, NET_ZERO_ADJUSTMENT_FLAG_6 NET_ZERO_ADJUSTMENT_FLAG_6
, EXPENDITURE_COMMENT_6 EXPENDITURE_COMMENT_6
, EXPENDITURE_ITEM_ID_7 EXPENDITURE_ITEM_ID_7
, EXPENDITURE_ITEM_DATE_7 EXPENDITURE_ITEM_DATE_7
, QUANTITY_7 QUANTITY_7
, SYSTEM_LINKAGE_FUNCTION_7 SYSTEM_LINKAGE_FUNCTION_7
, NON_LABOR_RESOURCE_7 NON_LABOR_RESOURCE_7
, ORGANIZATION_ID_7 ORGANIZATION_ID_7
, OVERRIDE_TO_ORGANIZATION_ID_7 OVERRIDE_TO_ORGANIZATION_ID_7
, RAW_COST_7 RAW_COST_7
, RAW_COST_RATE_7 RAW_COST_RATE_7
, ATTRIBUTE_CATEGORY_7 ATTRIBUTE_CATEGORY_7
, ATTRIBUTE7_1 ATTRIBUTE7_1
, ATTRIBUTE7_2 ATTRIBUTE7_2
, ATTRIBUTE7_3 ATTRIBUTE7_3
, ATTRIBUTE7_4 ATTRIBUTE7_4
, ATTRIBUTE7_5 ATTRIBUTE7_5
, ATTRIBUTE7_6 ATTRIBUTE7_6
, ATTRIBUTE7_7 ATTRIBUTE7_7
, ATTRIBUTE7_8 ATTRIBUTE7_8
, ATTRIBUTE7_9 ATTRIBUTE7_9
, ATTRIBUTE7_10 ATTRIBUTE7_10
, EXPENDITURE_COMMENT_4 EXPENDITURE_COMMENT_4
, EXPENDITURE_ITEM_ID_5 EXPENDITURE_ITEM_ID_5
, EXPENDITURE_ITEM_DATE_5 EXPENDITURE_ITEM_DATE_5
, QUANTITY_5 QUANTITY_5
, SYSTEM_LINKAGE_FUNCTION_5 SYSTEM_LINKAGE_FUNCTION_5
, NON_LABOR_RESOURCE_5 NON_LABOR_RESOURCE_5
, ORGANIZATION_ID_5 ORGANIZATION_ID_5
, OVERRIDE_TO_ORGANIZATION_ID_5 OVERRIDE_TO_ORGANIZATION_ID_5
, RAW_COST_5 RAW_COST_5
, RAW_COST_RATE_5 RAW_COST_RATE_5
, ATTRIBUTE_CATEGORY_5 ATTRIBUTE_CATEGORY_5
, ATTRIBUTE5_1 ATTRIBUTE5_1
, ATTRIBUTE5_2 ATTRIBUTE5_2
, ATTRIBUTE5_3 ATTRIBUTE5_3
, ATTRIBUTE5_4 ATTRIBUTE5_4
, ATTRIBUTE5_5 ATTRIBUTE5_5
, ATTRIBUTE5_6 ATTRIBUTE5_6
, ATTRIBUTE5_7 ATTRIBUTE5_7
, ATTRIBUTE5_8 ATTRIBUTE5_8
, ATTRIBUTE5_9 ATTRIBUTE5_9
, ATTRIBUTE5_10 ATTRIBUTE5_10
, ORIG_TRANSACTION_REFERENCE_5 ORIG_TRANSACTION_REFERENCE_5
, ADJUSTED_EXPENDITURE_ITEM_ID_5 ADJUSTED_EXPENDITURE_ITEM_ID_5
, NET_ZERO_ADJUSTMENT_FLAG_5 NET_ZERO_ADJUSTMENT_FLAG_5
, EXPENDITURE_COMMENT_5 EXPENDITURE_COMMENT_5
, EXPENDITURE_ITEM_ID_6 EXPENDITURE_ITEM_ID_6
, EXPENDITURE_ITEM_DATE_6 EXPENDITURE_ITEM_DATE_6
, QUANTITY_6 QUANTITY_6
, SYSTEM_LINKAGE_FUNCTION_6 SYSTEM_LINKAGE_FUNCTION_6
, NON_LABOR_RESOURCE_6 NON_LABOR_RESOURCE_6
, ORGANIZATION_ID_6 ORGANIZATION_ID_6
, OVERRIDE_TO_ORGANIZATION_ID_6 OVERRIDE_TO_ORGANIZATION_ID_6
, RAW_COST_6 RAW_COST_6
, RAW_COST_RATE_6 RAW_COST_RATE_6
, ATTRIBUTE3_2 ATTRIBUTE3_2
, ATTRIBUTE3_3 ATTRIBUTE3_3
, ATTRIBUTE3_4 ATTRIBUTE3_4
, ATTRIBUTE3_5 ATTRIBUTE3_5
, ATTRIBUTE3_6 ATTRIBUTE3_6
, ATTRIBUTE3_7 ATTRIBUTE3_7
, ATTRIBUTE3_8 ATTRIBUTE3_8
, ATTRIBUTE3_9 ATTRIBUTE3_9
, ATTRIBUTE3_10 ATTRIBUTE3_10
, ORIG_TRANSACTION_REFERENCE_3 ORIG_TRANSACTION_REFERENCE_3
, ADJUSTED_EXPENDITURE_ITEM_ID_3 ADJUSTED_EXPENDITURE_ITEM_ID_3
, NET_ZERO_ADJUSTMENT_FLAG_3 NET_ZERO_ADJUSTMENT_FLAG_3
, EXPENDITURE_COMMENT_3 EXPENDITURE_COMMENT_3
, EXPENDITURE_ITEM_ID_4 EXPENDITURE_ITEM_ID_4
, EXPENDITURE_ITEM_DATE_4 EXPENDITURE_ITEM_DATE_4
, QUANTITY_4 QUANTITY_4
, SYSTEM_LINKAGE_FUNCTION_4 SYSTEM_LINKAGE_FUNCTION_4
, NON_LABOR_RESOURCE_4 NON_LABOR_RESOURCE_4
, ORGANIZATION_ID_4 ORGANIZATION_ID_4
, OVERRIDE_TO_ORGANIZATION_ID_4 OVERRIDE_TO_ORGANIZATION_ID_4
, RAW_COST_4 RAW_COST_4
, RAW_COST_RATE_4 RAW_COST_RATE_4
, ATTRIBUTE_CATEGORY_4 ATTRIBUTE_CATEGORY_4
, ATTRIBUTE4_1 ATTRIBUTE4_1
, ATTRIBUTE4_2 ATTRIBUTE4_2
, ATTRIBUTE4_3 ATTRIBUTE4_3
, ATTRIBUTE4_4 ATTRIBUTE4_4
, ATTRIBUTE4_5 ATTRIBUTE4_5
, ATTRIBUTE4_6 ATTRIBUTE4_6
, ATTRIBUTE4_7 ATTRIBUTE4_7
, ATTRIBUTE4_8 ATTRIBUTE4_8
, ATTRIBUTE4_9 ATTRIBUTE4_9
, ATTRIBUTE4_10 ATTRIBUTE4_10
, ORIG_TRANSACTION_REFERENCE_4 ORIG_TRANSACTION_REFERENCE_4
, ADJUSTED_EXPENDITURE_ITEM_ID_4 ADJUSTED_EXPENDITURE_ITEM_ID_4
, NET_ZERO_ADJUSTMENT_FLAG_4 NET_ZERO_ADJUSTMENT_FLAG_4
, EXPENDITURE_COMMENT_1 EXPENDITURE_COMMENT_1
, EXPENDITURE_ITEM_ID_2 EXPENDITURE_ITEM_ID_2
, EXPENDITURE_ITEM_DATE_2 EXPENDITURE_ITEM_DATE_2
, QUANTITY_2 QUANTITY_2
, SYSTEM_LINKAGE_FUNCTION_2 SYSTEM_LINKAGE_FUNCTION_2
, NON_LABOR_RESOURCE_2 NON_LABOR_RESOURCE_2
, ORGANIZATION_ID_2 ORGANIZATION_ID_2
, OVERRIDE_TO_ORGANIZATION_ID_2 OVERRIDE_TO_ORGANIZATION_ID_2
, RAW_COST_2 RAW_COST_2
, RAW_COST_RATE_2 RAW_COST_RATE_2
, ATTRIBUTE_CATEGORY_2 ATTRIBUTE_CATEGORY_2
, ATTRIBUTE2_1 ATTRIBUTE2_1
, ATTRIBUTE2_2 ATTRIBUTE2_2
, ATTRIBUTE2_3 ATTRIBUTE2_3
, ATTRIBUTE2_4 ATTRIBUTE2_4
, ATTRIBUTE2_5 ATTRIBUTE2_5
, ATTRIBUTE2_6 ATTRIBUTE2_6
, ATTRIBUTE2_7 ATTRIBUTE2_7
, ATTRIBUTE2_8 ATTRIBUTE2_8
, ATTRIBUTE2_9 ATTRIBUTE2_9
, ATTRIBUTE2_10 ATTRIBUTE2_10
, ORIG_TRANSACTION_REFERENCE_2 ORIG_TRANSACTION_REFERENCE_2
, ADJUSTED_EXPENDITURE_ITEM_ID_2 ADJUSTED_EXPENDITURE_ITEM_ID_2
, NET_ZERO_ADJUSTMENT_FLAG_2 NET_ZERO_ADJUSTMENT_FLAG_2
, EXPENDITURE_COMMENT_2 EXPENDITURE_COMMENT_2
, EXPENDITURE_ITEM_ID_3 EXPENDITURE_ITEM_ID_3
, EXPENDITURE_ITEM_DATE_3 EXPENDITURE_ITEM_DATE_3
, QUANTITY_3 QUANTITY_3
, SYSTEM_LINKAGE_FUNCTION_3 SYSTEM_LINKAGE_FUNCTION_3
, NON_LABOR_RESOURCE_3 NON_LABOR_RESOURCE_3
, ORGANIZATION_ID_3 ORGANIZATION_ID_3
, OVERRIDE_TO_ORGANIZATION_ID_3 OVERRIDE_TO_ORGANIZATION_ID_3
, RAW_COST_3 RAW_COST_3
, RAW_COST_RATE_3 RAW_COST_RATE_3
, ATTRIBUTE_CATEGORY_3 ATTRIBUTE_CATEGORY_3
, ATTRIBUTE3_1 ATTRIBUTE3_1
, JOB_ID_1 JOB_ID_1
, JOB_ID_2 JOB_ID_2
, JOB_ID_3 JOB_ID_3
, JOB_ID_4 JOB_ID_4
, JOB_ID_5 JOB_ID_5
, JOB_ID_6 JOB_ID_6
, JOB_ID_7 JOB_ID_7
, ADJUSTED_DENORM_ID ADJUSTED_DENORM_ID
, BILLABLE_FLAG_1 BILLABLE_FLAG_1
, BILLABLE_FLAG_2 BILLABLE_FLAG_2
, BILLABLE_FLAG_3 BILLABLE_FLAG_3
, BILLABLE_FLAG_4 BILLABLE_FLAG_4
, BILLABLE_FLAG_5 BILLABLE_FLAG_5
, BILLABLE_FLAG_6 BILLABLE_FLAG_6
, BILLABLE_FLAG_7 BILLABLE_FLAG_7
FROM "PA"."PA_EI_DENORM_AR"