eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: PA.PA_EXPENDITURE_ITEMS_ALL#

Source

View Text - Preformatted


select EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, EXPENDITURE_ID EXPENDITURE_ID, TASK_ID TASK_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_TYPE EXPENDITURE_TYPE, COST_DISTRIBUTED_FLAG COST_DISTRIBUTED_FLAG, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG, BILLABLE_FLAG BILLABLE_FLAG, BILL_HOLD_FLAG BILL_HOLD_FLAG, QUANTITY QUANTITY, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, ORGANIZATION_ID ORGANIZATION_ID, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID, RAW_COST RAW_COST, RAW_COST_RATE RAW_COST_RATE, BURDEN_COST BURDEN_COST, BURDEN_COST_RATE BURDEN_COST_RATE, COST_DIST_REJECTION_CODE COST_DIST_REJECTION_CODE, LABOR_COST_MULTIPLIER_NAME LABOR_COST_MULTIPLIER_NAME, RAW_REVENUE RAW_REVENUE, BILL_RATE BILL_RATE, ACCRUED_REVENUE ACCRUED_REVENUE, ACCRUAL_RATE ACCRUAL_RATE, ADJUSTED_REVENUE ADJUSTED_REVENUE, ADJUSTED_RATE ADJUSTED_RATE, BILL_AMOUNT BILL_AMOUNT, FORECAST_REVENUE FORECAST_REVENUE, BILL_RATE_MULTIPLIER BILL_RATE_MULTIPLIER, REV_DIST_REJECTION_CODE REV_DIST_REJECTION_CODE, EVENT_NUM EVENT_NUM, EVENT_TASK_ID EVENT_TASK_ID, BILL_JOB_ID BILL_JOB_ID, BILL_JOB_BILLING_TITLE BILL_JOB_BILLING_TITLE, BILL_EMPLOYEE_BILLING_TITLE BILL_EMPLOYEE_BILLING_TITLE, ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG, TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID, CONVERTED_FLAG CONVERTED_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, COST_IND_COMPILED_SET_ID COST_IND_COMPILED_SET_ID, REV_IND_COMPILED_SET_ID REV_IND_COMPILED_SET_ID, INV_IND_COMPILED_SET_ID INV_IND_COMPILED_SET_ID, COST_BURDEN_DISTRIBUTED_FLAG COST_BURDEN_DISTRIBUTED_FLAG, IND_COST_DIST_REJECTION_CODE IND_COST_DIST_REJECTION_CODE, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE, TRANSACTION_SOURCE TRANSACTION_SOURCE, PROJECT_ID PROJECT_ID, SOURCE_EXPENDITURE_ITEM_ID SOURCE_EXPENDITURE_ITEM_ID, JOB_ID JOB_ID, ORG_ID ORG_ID, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_RAW_COST DENOM_RAW_COST, DENOM_BURDENED_COST DENOM_BURDENED_COST, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ACCT_RAW_COST ACCT_RAW_COST, ACCT_BURDENED_COST ACCT_BURDENED_COST, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, DENORM_ID DENORM_ID, CC_CROSS_CHARGE_CODE CC_CROSS_CHARGE_CODE, CC_PRVDR_ORGANIZATION_ID CC_PRVDR_ORGANIZATION_ID, CC_RECVR_ORGANIZATION_ID CC_RECVR_ORGANIZATION_ID, CC_REJECTION_CODE CC_REJECTION_CODE, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE, ACCT_TRANSFER_PRICE ACCT_TRANSFER_PRICE, PROJACCT_TRANSFER_PRICE PROJACCT_TRANSFER_PRICE, CC_MARKUP_BASE_CODE CC_MARKUP_BASE_CODE, TP_BASE_AMOUNT TP_BASE_AMOUNT, CC_CROSS_CHARGE_TYPE CC_CROSS_CHARGE_TYPE, RECVR_ORG_ID RECVR_ORG_ID, CC_BL_DISTRIBUTED_CODE CC_BL_DISTRIBUTED_CODE, CC_IC_PROCESSED_CODE CC_IC_PROCESSED_CODE, TP_IND_COMPILED_SET_ID TP_IND_COMPILED_SET_ID, TP_BILL_RATE TP_BILL_RATE, TP_BILL_MARKUP_PERCENTAGE TP_BILL_MARKUP_PERCENTAGE, TP_SCHEDULE_LINE_PERCENTAGE TP_SCHEDULE_LINE_PERCENTAGE, TP_RULE_PERCENTAGE TP_RULE_PERCENTAGE, CC_PRVDR_COST_RECLASS_CODE CC_PRVDR_COST_RECLASS_CODE, CRL_ASSET_CREATION_STATUS_CODE CRL_ASSET_CREATION_STATUS_CODE, CRL_ASSET_CREATION_REJ_CODE CRL_ASSET_CREATION_REJ_CODE, COST_JOB_ID COST_JOB_ID, TP_JOB_ID TP_JOB_ID, PROV_PROJ_BILL_JOB_ID PROV_PROJ_BILL_JOB_ID, COST_DIST_WARNING_CODE COST_DIST_WARNING_CODE, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE, BILL_TRANS_FORECAST_CURR_CODE BILL_TRANS_FORECAST_CURR_CODE, BILL_TRANS_FORECAST_REVENUE BILL_TRANS_FORECAST_REVENUE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJECT_RAW_COST PROJECT_RAW_COST, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, ASSIGNMENT_ID ASSIGNMENT_ID, WORK_TYPE_ID WORK_TYPE_ID, PROJFUNC_RAW_REVENUE PROJFUNC_RAW_REVENUE, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJECT_RAW_REVENUE PROJECT_RAW_REVENUE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE, BILL_TRANS_RAW_REVENUE BILL_TRANS_RAW_REVENUE, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT, BILL_TRANS_ADJUSTED_REVENUE BILL_TRANS_ADJUSTED_REVENUE, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, REVPROC_RATE_TYPE REVPROC_RATE_TYPE, REVPROC_RATE_DATE REVPROC_RATE_DATE, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, INVPROC_RATE_TYPE INVPROC_RATE_TYPE, INVPROC_RATE_DATE INVPROC_RATE_DATE, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE, LABOR_MULTIPLIER LABOR_MULTIPLIER, AMOUNT_CALCULATION_CODE AMOUNT_CALCULATION_CODE, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE, RATE_SOURCE_ID RATE_SOURCE_ID, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE, PROJECT_INV_RATE_TYPE PROJECT_INV_RATE_TYPE, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE, PROJFUNC_FCST_RATE_TYPE PROJFUNC_FCST_RATE_TYPE, PROJFUNC_FCST_RATE_DATE PROJFUNC_FCST_RATE_DATE, PROJFUNC_FCST_EXCHANGE_RATE PROJFUNC_FCST_EXCHANGE_RATE, PRVDR_ACCRUAL_DATE PRVDR_ACCRUAL_DATE, RECVR_ACCRUAL_DATE RECVR_ACCRUAL_DATE, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE, POSTED_DENOM_BURDENED_COST POSTED_DENOM_BURDENED_COST, POSTED_PROJECT_BURDENED_COST POSTED_PROJECT_BURDENED_COST, POSTED_PROJFUNC_BURDENED_COST POSTED_PROJFUNC_BURDENED_COST, POSTED_ACCT_BURDENED_COST POSTED_ACCT_BURDENED_COST, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, CAPITAL_EVENT_ID CAPITAL_EVENT_ID, PO_LINE_ID PO_LINE_ID, PO_PRICE_TYPE PO_PRICE_TYPE, WIP_RESOURCE_ID WIP_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, SRC_SYSTEM_LINKAGE_FUNCTION SRC_SYSTEM_LINKAGE_FUNCTION, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, DOCUMENT_LINE_NUMBER DOCUMENT_LINE_NUMBER, DOCUMENT_PAYMENT_ID DOCUMENT_PAYMENT_ID, VENDOR_ID VENDOR_ID, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE, HISTORICAL_FLAG HISTORICAL_FLAG, LOCATION_ID LOCATION_ID, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID, COSTING_METHOD COSTING_METHOD, RATE_SOURCE_CODE RATE_SOURCE_CODE, PAYROLL_ACCRUAL_FLAG PAYROLL_ACCRUAL_FLAG, RBC_ELEMENT_TYPE_ID RBC_ELEMENT_TYPE_ID, INTERFACE_RUN_ID INTERFACE_RUN_ID, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_EXPENDITURE_ITEMS_ALL"

View Text - HTML Formatted

SELECT EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, EXPENDITURE_ID EXPENDITURE_ID
, TASK_ID TASK_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, COST_DISTRIBUTED_FLAG COST_DISTRIBUTED_FLAG
, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG
, BILLABLE_FLAG BILLABLE_FLAG
, BILL_HOLD_FLAG BILL_HOLD_FLAG
, QUANTITY QUANTITY
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, ORGANIZATION_ID ORGANIZATION_ID
, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID
, RAW_COST RAW_COST
, RAW_COST_RATE RAW_COST_RATE
, BURDEN_COST BURDEN_COST
, BURDEN_COST_RATE BURDEN_COST_RATE
, COST_DIST_REJECTION_CODE COST_DIST_REJECTION_CODE
, LABOR_COST_MULTIPLIER_NAME LABOR_COST_MULTIPLIER_NAME
, RAW_REVENUE RAW_REVENUE
, BILL_RATE BILL_RATE
, ACCRUED_REVENUE ACCRUED_REVENUE
, ACCRUAL_RATE ACCRUAL_RATE
, ADJUSTED_REVENUE ADJUSTED_REVENUE
, ADJUSTED_RATE ADJUSTED_RATE
, BILL_AMOUNT BILL_AMOUNT
, FORECAST_REVENUE FORECAST_REVENUE
, BILL_RATE_MULTIPLIER BILL_RATE_MULTIPLIER
, REV_DIST_REJECTION_CODE REV_DIST_REJECTION_CODE
, EVENT_NUM EVENT_NUM
, EVENT_TASK_ID EVENT_TASK_ID
, BILL_JOB_ID BILL_JOB_ID
, BILL_JOB_BILLING_TITLE BILL_JOB_BILLING_TITLE
, BILL_EMPLOYEE_BILLING_TITLE BILL_EMPLOYEE_BILLING_TITLE
, ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID
, CONVERTED_FLAG CONVERTED_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, COST_IND_COMPILED_SET_ID COST_IND_COMPILED_SET_ID
, REV_IND_COMPILED_SET_ID REV_IND_COMPILED_SET_ID
, INV_IND_COMPILED_SET_ID INV_IND_COMPILED_SET_ID
, COST_BURDEN_DISTRIBUTED_FLAG COST_BURDEN_DISTRIBUTED_FLAG
, IND_COST_DIST_REJECTION_CODE IND_COST_DIST_REJECTION_CODE
, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, PROJECT_ID PROJECT_ID
, SOURCE_EXPENDITURE_ITEM_ID SOURCE_EXPENDITURE_ITEM_ID
, JOB_ID JOB_ID
, ORG_ID ORG_ID
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_RAW_COST DENOM_RAW_COST
, DENOM_BURDENED_COST DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ACCT_RAW_COST ACCT_RAW_COST
, ACCT_BURDENED_COST ACCT_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, DENORM_ID DENORM_ID
, CC_CROSS_CHARGE_CODE CC_CROSS_CHARGE_CODE
, CC_PRVDR_ORGANIZATION_ID CC_PRVDR_ORGANIZATION_ID
, CC_RECVR_ORGANIZATION_ID CC_RECVR_ORGANIZATION_ID
, CC_REJECTION_CODE CC_REJECTION_CODE
, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE
, ACCT_TRANSFER_PRICE ACCT_TRANSFER_PRICE
, PROJACCT_TRANSFER_PRICE PROJACCT_TRANSFER_PRICE
, CC_MARKUP_BASE_CODE CC_MARKUP_BASE_CODE
, TP_BASE_AMOUNT TP_BASE_AMOUNT
, CC_CROSS_CHARGE_TYPE CC_CROSS_CHARGE_TYPE
, RECVR_ORG_ID RECVR_ORG_ID
, CC_BL_DISTRIBUTED_CODE CC_BL_DISTRIBUTED_CODE
, CC_IC_PROCESSED_CODE CC_IC_PROCESSED_CODE
, TP_IND_COMPILED_SET_ID TP_IND_COMPILED_SET_ID
, TP_BILL_RATE TP_BILL_RATE
, TP_BILL_MARKUP_PERCENTAGE TP_BILL_MARKUP_PERCENTAGE
, TP_SCHEDULE_LINE_PERCENTAGE TP_SCHEDULE_LINE_PERCENTAGE
, TP_RULE_PERCENTAGE TP_RULE_PERCENTAGE
, CC_PRVDR_COST_RECLASS_CODE CC_PRVDR_COST_RECLASS_CODE
, CRL_ASSET_CREATION_STATUS_CODE CRL_ASSET_CREATION_STATUS_CODE
, CRL_ASSET_CREATION_REJ_CODE CRL_ASSET_CREATION_REJ_CODE
, COST_JOB_ID COST_JOB_ID
, TP_JOB_ID TP_JOB_ID
, PROV_PROJ_BILL_JOB_ID PROV_PROJ_BILL_JOB_ID
, COST_DIST_WARNING_CODE COST_DIST_WARNING_CODE
, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE
, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE
, BILL_TRANS_FORECAST_CURR_CODE BILL_TRANS_FORECAST_CURR_CODE
, BILL_TRANS_FORECAST_REVENUE BILL_TRANS_FORECAST_REVENUE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST PROJECT_RAW_COST
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, ASSIGNMENT_ID ASSIGNMENT_ID
, WORK_TYPE_ID WORK_TYPE_ID
, PROJFUNC_RAW_REVENUE PROJFUNC_RAW_REVENUE
, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJECT_RAW_REVENUE PROJECT_RAW_REVENUE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE
, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_RAW_REVENUE BILL_TRANS_RAW_REVENUE
, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_ADJUSTED_REVENUE BILL_TRANS_ADJUSTED_REVENUE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE REVPROC_RATE_TYPE
, REVPROC_RATE_DATE REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE INVPROC_RATE_TYPE
, INVPROC_RATE_DATE INVPROC_RATE_DATE
, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE
, LABOR_MULTIPLIER LABOR_MULTIPLIER
, AMOUNT_CALCULATION_CODE AMOUNT_CALCULATION_CODE
, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE
, RATE_SOURCE_ID RATE_SOURCE_ID
, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE
, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT
, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE
, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE
, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
, PROJECT_INV_RATE_TYPE PROJECT_INV_RATE_TYPE
, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE
, PROJFUNC_FCST_RATE_TYPE PROJFUNC_FCST_RATE_TYPE
, PROJFUNC_FCST_RATE_DATE PROJFUNC_FCST_RATE_DATE
, PROJFUNC_FCST_EXCHANGE_RATE PROJFUNC_FCST_EXCHANGE_RATE
, PRVDR_ACCRUAL_DATE PRVDR_ACCRUAL_DATE
, RECVR_ACCRUAL_DATE RECVR_ACCRUAL_DATE
, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE
, POSTED_DENOM_BURDENED_COST POSTED_DENOM_BURDENED_COST
, POSTED_PROJECT_BURDENED_COST POSTED_PROJECT_BURDENED_COST
, POSTED_PROJFUNC_BURDENED_COST POSTED_PROJFUNC_BURDENED_COST
, POSTED_ACCT_BURDENED_COST POSTED_ACCT_BURDENED_COST
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, CAPITAL_EVENT_ID CAPITAL_EVENT_ID
, PO_LINE_ID PO_LINE_ID
, PO_PRICE_TYPE PO_PRICE_TYPE
, WIP_RESOURCE_ID WIP_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, SRC_SYSTEM_LINKAGE_FUNCTION SRC_SYSTEM_LINKAGE_FUNCTION
, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_LINE_NUMBER DOCUMENT_LINE_NUMBER
, DOCUMENT_PAYMENT_ID DOCUMENT_PAYMENT_ID
, VENDOR_ID VENDOR_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE
, HISTORICAL_FLAG HISTORICAL_FLAG
, LOCATION_ID LOCATION_ID
, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID
, COSTING_METHOD COSTING_METHOD
, RATE_SOURCE_CODE RATE_SOURCE_CODE
, PAYROLL_ACCRUAL_FLAG PAYROLL_ACCRUAL_FLAG
, RBC_ELEMENT_TYPE_ID RBC_ELEMENT_TYPE_ID
, INTERFACE_RUN_ID INTERFACE_RUN_ID
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_EXPENDITURE_ITEMS_ALL"