[Home] [Help] [Dependency Information]
Object Name: | PA_EXPENDITURE_ITEMS_AR# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_BATCH_ID | NUMBER | (15) | Yes | |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | |
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (3) | ||
BURDEN_SUM_DEST_RUN_ID | NUMBER | (15) | ||
COST_IND_COMPILED_SET_ID | NUMBER | (15) | ||
REV_IND_COMPILED_SET_ID | NUMBER | (15) | ||
INV_IND_COMPILED_SET_ID | NUMBER | (15) | ||
COST_BURDEN_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
IND_COST_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (50) | ||
TRANSACTION_SOURCE | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | (15) | ||
SOURCE_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
ADJUSTED_RATE | NUMBER | (22) | ||
BILL_AMOUNT | NUMBER | (22) | ||
FORECAST_REVENUE | NUMBER | (22) | ||
BILL_RATE_MULTIPLIER | NUMBER | (22) | ||
REV_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
EVENT_NUM | NUMBER | (15) | ||
EVENT_TASK_ID | NUMBER | (15) | ||
BILL_JOB_ID | NUMBER | (15) | ||
BILL_JOB_BILLING_TITLE | VARCHAR2 | (80) | ||
BILL_EMPLOYEE_BILLING_TITLE | VARCHAR2 | (80) | ||
ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | (15) | ||
CONVERTED_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
EXPENDITURE_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
COST_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
BILLABLE_FLAG | VARCHAR2 | (1) | ||
BILL_HOLD_FLAG | VARCHAR2 | (1) | ||
QUANTITY | NUMBER | (22) | ||
NON_LABOR_RESOURCE | VARCHAR2 | (20) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | ||
RAW_COST | NUMBER | (22) | ||
RAW_COST_RATE | NUMBER | (22) | ||
BURDEN_COST | NUMBER | (22) | ||
BURDEN_COST_RATE | NUMBER | (22) | ||
COST_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | (20) | ||
RAW_REVENUE | NUMBER | (22) | ||
BILL_RATE | NUMBER | (22) | ||
ACCRUED_REVENUE | NUMBER | (22) | ||
ACCRUAL_RATE | NUMBER | (22) | ||
DENORM_ID | NUMBER | (15) | ||
ADJUSTED_REVENUE | NUMBER | (22) | ||
RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
RECEIPT_EXCHANGE_RATE | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_RAW_COST | NUMBER | |||
DENOM_BURDENED_COST | NUMBER | |||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCT_RATE_DATE | DATE | |||
ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_EXCHANGE_RATE | NUMBER | |||
ACCT_RAW_COST | NUMBER | |||
ACCT_BURDENED_COST | NUMBER | |||
ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_EXCHANGE_RATE | NUMBER | |||
CC_CROSS_CHARGE_CODE | VARCHAR2 | (1) | ||
CC_PRVDR_ORGANIZATION_ID | NUMBER | (15) | ||
CC_RECVR_ORGANIZATION_ID | NUMBER | (15) | ||
CC_REJECTION_CODE | VARCHAR2 | (30) | ||
DENOM_TP_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_TRANSFER_PRICE | NUMBER | |||
ACCT_TP_RATE_DATE | DATE | |||
ACCT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_TP_EXCHANGE_RATE | NUMBER | |||
ACCT_TRANSFER_PRICE | NUMBER | |||
PROJACCT_TRANSFER_PRICE | NUMBER | |||
CC_MARKUP_BASE_CODE | VARCHAR2 | (1) | ||
TP_BASE_AMOUNT | NUMBER | |||
CC_CROSS_CHARGE_TYPE | VARCHAR2 | (2) | ||
RECVR_ORG_ID | NUMBER | (15) | ||
CC_BL_DISTRIBUTED_CODE | VARCHAR2 | (1) | ||
CC_IC_PROCESSED_CODE | VARCHAR2 | (1) | ||
TP_IND_COMPILED_SET_ID | NUMBER | (15) | ||
TP_BILL_RATE | NUMBER | |||
TP_BILL_MARKUP_PERCENTAGE | NUMBER | |||
TP_SCHEDULE_LINE_PERCENTAGE | NUMBER | |||
TP_RULE_PERCENTAGE | NUMBER | |||
CC_PRVDR_COST_RECLASS_CODE | VARCHAR2 | (1) | ||
CRL_ASSET_CREATION_STATUS_CODE | VARCHAR2 | (1) | ||
CRL_ASSET_CREATION_REJ_CODE | VARCHAR2 | (30) | ||
COST_JOB_ID | NUMBER | (15) | ||
TP_JOB_ID | NUMBER | (15) | ||
PROV_PROJ_BILL_JOB_ID | NUMBER | (15) | ||
COST_DIST_WARNING_CODE | VARCHAR2 | (30) | ||
PROJECT_TP_RATE_DATE | DATE | |||
PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_TP_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_TP_RATE_DATE | DATE | |||
PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_TP_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_TRANSFER_PRICE | NUMBER | |||
BILL_TRANS_FORECAST_CURR_CODE | VARCHAR2 | (15) | ||
BILL_TRANS_FORECAST_REVENUE | NUMBER | |||
PROJFUNC_REV_RATE_DATE | DATE | |||
PROJFUNC_REV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_RATE_DATE | VARCHAR2 | (240) | ||
PROJFUNC_COST_EXCHANGE_RATE | NUMBER | |||
PROJECT_RAW_COST | NUMBER | |||
PROJECT_BURDENED_COST | NUMBER | |||
ASSIGNMENT_ID | NUMBER | (15) | ||
WORK_TYPE_ID | NUMBER | (15) | ||
PROJFUNC_RAW_REVENUE | NUMBER | |||
PROJECT_BILL_AMOUNT | NUMBER | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RAW_REVENUE | NUMBER | |||
PROJECT_TRANSFER_PRICE | NUMBER | |||
TP_AMT_TYPE_CODE | VARCHAR2 | (30) | ||
BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | ||
BILL_TRANS_RAW_REVENUE | NUMBER | |||
BILL_TRANS_BILL_AMOUNT | NUMBER | |||
BILL_TRANS_ADJUSTED_REVENUE | NUMBER | |||
REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
REVPROC_RATE_DATE | VARCHAR2 | (240) | ||
REVPROC_EXCHANGE_RATE | NUMBER | |||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
INVPROC_RATE_DATE | DATE | |||
DISCOUNT_PERCENTAGE | NUMBER | |||
LABOR_MULTIPLIER | NUMBER | |||
AMOUNT_CALCULATION_CODE | VARCHAR2 | (15) | ||
BILL_MARKUP_PERCENTAGE | NUMBER | |||
RATE_SOURCE_ID | NUMBER | (15) | ||
INVPROC_EXCHANGE_RATE | NUMBER | |||
INV_GEN_REJECTION_CODE | VARCHAR2 | (30) | ||
PROJFUNC_BILL_AMOUNT | NUMBER | |||
PROJECT_REV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_REV_RATE_DATE | VARCHAR2 | (240) | ||
PROJECT_REV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INV_RATE_DATE | DATE | |||
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | |||
PROJECT_INV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_INV_RATE_DATE | VARCHAR2 | (240) | ||
PROJECT_INV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_FCST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_FCST_RATE_DATE | VARCHAR2 | (240) | ||
PROJFUNC_FCST_EXCHANGE_RATE | NUMBER | |||
PRVDR_ACCRUAL_DATE | DATE | |||
RECVR_ACCRUAL_DATE | VARCHAR2 | (240) | ||
RATE_DISC_REASON_CODE | VARCHAR2 | (30) | ||
POSTED_DENOM_BURDENED_COST | NUMBER | |||
POSTED_PROJECT_BURDENED_COST | NUMBER | |||
POSTED_PROJFUNC_BURDENED_COST | NUMBER | |||
POSTED_ACCT_BURDENED_COST | NUMBER | |||
ADJUSTMENT_TYPE | VARCHAR2 | (150) | ||
CAPITAL_EVENT_ID | NUMBER | (15) | ||
PO_LINE_ID | NUMBER | |||
PO_PRICE_TYPE | VARCHAR2 | (30) | ||
INVENTORY_ITEM_ID | NUMBER | |||
WIP_RESOURCE_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
DOCUMENT_HEADER_ID | NUMBER | (15) | ||
DOCUMENT_DISTRIBUTION_ID | NUMBER | (15) | ||
DOCUMENT_LINE_NUMBER | NUMBER | (15) | ||
DOCUMENT_PAYMENT_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
LOCATION_ID | NUMBER | (15) | ||
PAY_ELEMENT_TYPE_ID | NUMBER | (15) | ||
CBS_ELEMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, SYSTEM_LINKAGE_FUNCTION
, BURDEN_SUM_DEST_RUN_ID
, COST_IND_COMPILED_SET_ID
, REV_IND_COMPILED_SET_ID
, INV_IND_COMPILED_SET_ID
, COST_BURDEN_DISTRIBUTED_FLAG
, IND_COST_DIST_REJECTION_CODE
, ORIG_TRANSACTION_REFERENCE
, TRANSACTION_SOURCE
, PROJECT_ID
, SOURCE_EXPENDITURE_ITEM_ID
, JOB_ID
, ORG_ID
, ADJUSTED_RATE
, BILL_AMOUNT
, FORECAST_REVENUE
, BILL_RATE_MULTIPLIER
, REV_DIST_REJECTION_CODE
, EVENT_NUM
, EVENT_TASK_ID
, BILL_JOB_ID
, BILL_JOB_BILLING_TITLE
, BILL_EMPLOYEE_BILLING_TITLE
, ADJUSTED_EXPENDITURE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID
, CONVERTED_FLAG
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, EXPENDITURE_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, EXPENDITURE_ID
, TASK_ID
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_TYPE
, COST_DISTRIBUTED_FLAG
, REVENUE_DISTRIBUTED_FLAG
, BILLABLE_FLAG
, BILL_HOLD_FLAG
, QUANTITY
, NON_LABOR_RESOURCE
, ORGANIZATION_ID
, OVERRIDE_TO_ORGANIZATION_ID
, RAW_COST
, RAW_COST_RATE
, BURDEN_COST
, BURDEN_COST_RATE
, COST_DIST_REJECTION_CODE
, LABOR_COST_MULTIPLIER_NAME
, RAW_REVENUE
, BILL_RATE
, ACCRUED_REVENUE
, ACCRUAL_RATE
, DENORM_ID
, ADJUSTED_REVENUE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, CC_CROSS_CHARGE_CODE
, CC_PRVDR_ORGANIZATION_ID
, CC_RECVR_ORGANIZATION_ID
, CC_REJECTION_CODE
, DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_DATE
, ACCT_TP_RATE_TYPE
, ACCT_TP_EXCHANGE_RATE
, ACCT_TRANSFER_PRICE
, PROJACCT_TRANSFER_PRICE
, CC_MARKUP_BASE_CODE
, TP_BASE_AMOUNT
, CC_CROSS_CHARGE_TYPE
, RECVR_ORG_ID
, CC_BL_DISTRIBUTED_CODE
, CC_IC_PROCESSED_CODE
, TP_IND_COMPILED_SET_ID
, TP_BILL_RATE
, TP_BILL_MARKUP_PERCENTAGE
, TP_SCHEDULE_LINE_PERCENTAGE
, TP_RULE_PERCENTAGE
, CC_PRVDR_COST_RECLASS_CODE
, CRL_ASSET_CREATION_STATUS_CODE
, CRL_ASSET_CREATION_REJ_CODE
, COST_JOB_ID
, TP_JOB_ID
, PROV_PROJ_BILL_JOB_ID
, COST_DIST_WARNING_CODE
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE
, PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE
, BILL_TRANS_FORECAST_CURR_CODE
, BILL_TRANS_FORECAST_REVENUE
, PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, ASSIGNMENT_ID
, WORK_TYPE_ID
, PROJFUNC_RAW_REVENUE
, PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJECT_RAW_REVENUE
, PROJECT_TRANSFER_PRICE
, TP_AMT_TYPE_CODE
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_RAW_REVENUE
, BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_ADJUSTED_REVENUE
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, DISCOUNT_PERCENTAGE
, LABOR_MULTIPLIER
, AMOUNT_CALCULATION_CODE
, BILL_MARKUP_PERCENTAGE
, RATE_SOURCE_ID
, INVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE
, PROJFUNC_BILL_AMOUNT
, PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE
, PROJFUNC_REV_RATE_TYPE
, PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJECT_INV_RATE_TYPE
, PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE
, PROJFUNC_FCST_RATE_TYPE
, PROJFUNC_FCST_RATE_DATE
, PROJFUNC_FCST_EXCHANGE_RATE
, PRVDR_ACCRUAL_DATE
, RECVR_ACCRUAL_DATE
, RATE_DISC_REASON_CODE
, POSTED_DENOM_BURDENED_COST
, POSTED_PROJECT_BURDENED_COST
, POSTED_PROJFUNC_BURDENED_COST
, POSTED_ACCT_BURDENED_COST
, ADJUSTMENT_TYPE
, CAPITAL_EVENT_ID
, PO_LINE_ID
, PO_PRICE_TYPE
, INVENTORY_ITEM_ID
, WIP_RESOURCE_ID
, UNIT_OF_MEASURE
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_LINE_NUMBER
, DOCUMENT_PAYMENT_ID
, VENDOR_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, LOCATION_ID
, PAY_ELEMENT_TYPE_ID
, CBS_ELEMENT_ID
FROM PA.PA_EXPENDITURE_ITEMS_AR#;
|
|
|