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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_EXPENDITURE_ITEMS_ALL

Object Details

Object Name:	PA_EXPENDITURE_ITEMS_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_EXPENDITURE_ITEMS_ALL
Subobject Name:
Status:	VALID

PA_EXPENDITURE_ITEMS_ALL stores the smallest categorized
expenditure units charged to projects and tasks.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	40
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EXPENDITURE_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID BILL_HOLD_FLAG
PA_EXPENDITURES_ITEMS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BURDEN_SUM_DEST_RUN_ID
PA_EXPENDITURE_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ID EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE ORIG_TRANSACTION_REFERENCE
PA_EXPENDITURE_ITEMS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REV_IND_COMPILED_SET_ID EXPENDITURE_ITEM_DATE NET_ZERO_ADJUSTMENT_FLAG
PA_EXPENDITURE_ITEMS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INV_IND_COMPILED_SET_ID EXPENDITURE_ITEM_DATE NET_ZERO_ADJUSTMENT_FLAG
PA_EXPENDITURE_ITEMS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_BURDEN_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_TYPE SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURE_ITEMS_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DENORM_ID
PA_EXPENDITURE_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID BILL_HOLD_FLAG PROJECT_ID
PA_EXPENDITURE_ITEMS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CC_BL_DISTRIBUTED_CODE
PA_EXPENDITURE_ITEMS_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CC_CROSS_CHARGE_CODE
PA_EXPENDITURE_ITEMS_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECVR_ORG_ID CC_IC_PROCESSED_CODE CC_CROSS_CHARGE_CODE EXPENDITURE_ITEM_DATE TASK_ID
PA_EXPENDITURE_ITEMS_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TP_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID COST_DISTRIBUTED_FLAG SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURE_ITEMS_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
PA_EXPENDITURE_ITEMS_N27	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID DOCUMENT_LINE_NUMBER DOCUMENT_PAYMENT_ID DOCUMENT_TYPE DOCUMENT_DISTRIBUTION_TYPE
PA_EXPENDITURE_ITEMS_N28	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID SYSTEM_LINKAGE_FUNCTION COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N29	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_TYPE PROJECT_ID
PA_EXPENDITURE_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N30	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_JOB_ID
PA_EXPENDITURE_ITEMS_N31	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
PA_EXPENDITURE_ITEMS_N32	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_IND_COMPILED_SET_ID EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N33	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N34	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_RUN_ID
PA_EXPENDITURE_ITEMS_N35	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N36	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID EXPENDITURE_TYPE REVENUE_DISTRIBUTED_FLAG BILL_HOLD_FLAG
PA_EXPENDITURE_ITEMS_N37	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID EXPENDITURE_ITEM_DATE REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTED_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFERRED_FROM_EXP_ITEM_ID
PA_EXPENDITURE_ITEMS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID EVENT_NUM EVENT_TASK_ID
PA_EXPENDITURE_ITEMS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID EXPENDITURE_ITEM_DATE COST_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the expenditure item
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
EXPENDITURE_ID	NUMBER	(15)	Yes	The identifier of the expenditure to which the expenditure item belongs
TASK_ID	NUMBER	(15)	Yes	The identifier of the task to which the expenditure item is charged
EXPENDITURE_ITEM_DATE	DATE		Yes	The date on which the work occurred
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	The expenditure type that classifies the type of work performed
COST_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the item has been cost distributed. When 'N' the item is marked for cost distribution. When the item is cost distributed, the flag is set to 'Y'.
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the item is revenue distributed. Upon entry, this flag is set to 'N'. When the item is revenue distributed, the flag is set to 'Y' or 'P'
BILLABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls.
BILL_HOLD_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'.
QUANTITY	NUMBER			The number of units of the work performed
NON_LABOR_RESOURCE	VARCHAR2	(20)		The non-labor resource utilized as the work was performed. This column is only populated for usage items
ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables
RAW_COST	NUMBER			Raw cost in project Currency
RAW_COST_RATE	NUMBER			The raw cost rate used to cost the item
BURDEN_COST	NUMBER			The burden cost in project currency
BURDEN_COST_RATE	NUMBER			The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ).
COST_DIST_REJECTION_CODE	VARCHAR2	(30)		The reason why the expenditure item was rejected during cost distribution
LABOR_COST_MULTIPLIER_NAME	VARCHAR2	(20)		The labor cost multiplier specified for a premium labor expenditure item in order to determine the premium labor cost. Cost = (cost ratequantityLCM). This is populated by the timecard entry forms or the Overtime Calculation program
RAW_REVENUE	NUMBER	(22)		The potential revenue of the item. With T&M revenue accrual, raw revenue = (quantity * bill rate) or (raw cost * (markup/100) or (raw cost * labor multiplier). With COST revenue accrual, raw revenue = item's portion of the total revenue
BILL_RATE	NUMBER	(22)		The bill rate for the expenditure item. This column is not populated if (1) a markup percentage or labor multiplier was used to calculate T&M revenue or (2) if revenue is accrued under a Cost/Cost or Cost/Event distribution rule
ACCRUED_REVENUE	NUMBER	(22)		The total amount of revenue that the item accrued. This amount should always equal the sum of the revenue amount in the revenue distribution lines. This amount is different from raw revenue if the project hit a hard funding limit
ACCRUAL_RATE	NUMBER	(22)		The rate based on the accrued revenue. Accrual rate = (accrued revenue / quantity). This column is populated when the item is revenue distributed regardless of the project's distribution rule
ADJUSTED_REVENUE	NUMBER	(22)		The discounted revenue amount of the item based on the bill rate schedule discount. Adjusted revenue = raw revenue * (100-schedule discount)/100
ADJUSTED_RATE	NUMBER	(22)		The rate based on the adjusted revenue. Adjusted rate = (adjusted revenue / quantity)
BILL_AMOUNT	NUMBER	(22)		The amount to be billed for the item. This must always equal the sum of the bill amount on the revenue distribution lines. This amount may differ from the revenue amount if using Cost/Work or if the project hit hard funding limit.
FORECAST_REVENUE	NUMBER	(22)		The forecast revenue amount of a labor item based on T&M bill rates and markups and labor multipliers. This column is populated by the Compute Forecast Revenue process. Once the item is revenue distributed, this column is cleared
BILL_RATE_MULTIPLIER	NUMBER	(22)		The multiplier that can be used to determine an item's raw revenue with T&M bill rate accrual. This multiplier is populated by custom scripts or the OT Calculation program. Raw revenue = (quantity * bill rate * bill rate multiplier).
REV_DIST_REJECTION_CODE	VARCHAR2	(30)		The reason why the expenditure item was rejected during revenue distribution
EVENT_NUM	NUMBER	(15)		The event number of the payment schedule event that fifo (first in-first out) marks the expenditure item as invoiced for an event billing project
EVENT_TASK_ID	NUMBER	(15)		The identifier of the event task that fifo (first in-first out) marks the expenditure item as invoiced for an event billing project
BILL_JOB_ID	NUMBER	(15)		The identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced
BILL_JOB_BILLING_TITLE	VARCHAR2	(80)		The effective job billing title for the labor expenditure item as of the last time the expenditure item was invoiced
BILL_EMPLOYEE_BILLING_TITLE	VARCHAR2	(80)		The effective employee billing title for the labor expenditure item as of the last time the expenditure item was invoiced
ADJUSTED_EXPENDITURE_ITEM_ID	NUMBER	(15)		The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item.
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)		Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice
TRANSFERRED_FROM_EXP_ITEM_ID	NUMBER	(15)		The identifier of the expenditure item from which this expenditure item originated. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task
CONVERTED_FLAG	VARCHAR2	(1)		Flag set to 'Y' if the item is converted. If the item is converted, no adjustments to the item's revenue or cost are allowed. Adjustments allowed are 'Edit Comments', 'Bill Hold', 'One-Time Billing Hold', and 'Release Bill Hold'
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
COST_IND_COMPILED_SET_ID	NUMBER	(15)		The identifier of the compiled set that is used to calculate the cost amount of the expenditure item
REV_IND_COMPILED_SET_ID	NUMBER	(15)		The identifier of the compiled set that is used to calculate the revenue amount of the expenditure item
INV_IND_COMPILED_SET_ID	NUMBER	(15)		The identifier of the compiled set that is used to calculate the billing amount of the expenditure item
COST_BURDEN_DISTRIBUTED_FLAG	VARCHAR2	(1)		Flag indicates whether the expenditure item is burden distributed
IND_COST_DIST_REJECTION_CODE	VARCHAR2	(30)		The reason why the expenditure item was rejected during total burden distribution
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(50)		Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import.
TRANSACTION_SOURCE	VARCHAR2	(30)		Only populated for expenditure items created from transactions imported into PA from an external system; used by PA's expenditure item adjustment modules and costing programs to ensure the proper processing on imported items
PROJECT_ID	NUMBER	(15)		The project_id of the event that the expenditure item is FIFO marked by
SOURCE_EXPENDITURE_ITEM_ID	NUMBER	(15)		Only populated for related items created in PA's Labor Extensions. This number is the identifier of the source expenditure item to which this item is related
JOB_ID	NUMBER	(15)		The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts.
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes	The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)		Burden summarization run id. Id will identify all the expenditure items created by burden component summarization process. This is used to identify all the Cost distribution lines summarized together to create expenditure item
RECEIPT_CURRENCY_AMOUNT	NUMBER			Receipt currency amount of the transaction
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Receipt currency code of the transaction
RECEIPT_EXCHANGE_RATE	NUMBER			Receipt exchange rate for the transaction
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction Currency code of the transaction
DENOM_RAW_COST	NUMBER			The total raw cost of the expenditure item in transaction currency Raw cost = (quantity * cost rate) This value should always equal the sum of the items raw cost distribution lines
DENOM_BURDENED_COST	NUMBER			Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost = raw cost
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Account currency code of the transaction
ACCT_RATE_DATE	DATE			Functional Rate date for the Transaction
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional rate type for the transaction
ACCT_EXCHANGE_RATE	NUMBER			Functional Exchange Rate for the Transaction
ACCT_RAW_COST	NUMBER			Raw cost in Functional Currency
ACCT_BURDENED_COST	NUMBER			Burdened Cost in Functional Currency
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER			Rounding limit for imported transaction
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project Currency Code of the Transaction
PROJECT_RATE_DATE	DATE			Project Rate date for the Transaction
PROJECT_RATE_TYPE	VARCHAR2	(30)		Project Rate Type for the Transaction
PROJECT_EXCHANGE_RATE	NUMBER			Project Exchange Rate for Transaction
DENORM_ID	NUMBER	(15)		The identifier of denormalized representation of the expenditure items created through Self-Service Time module
CC_CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes	Indicates the method of cross charge processing that will be or has been performed on an Expenditure Item.
CC_PRVDR_ORGANIZATION_ID	NUMBER			Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overridden by the client extension to derive provider organization
CC_RECVR_ORGANIZATION_ID	NUMBER			Identifier of the receiver organization. This may be different than the project organization, if it is overridden by the client extension to derive receiver organization
CC_REJECTION_CODE	VARCHAR2	(30)		Code indicating rejection reason encountered while processing cross charge
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE	NUMBER			Transfer price in the transaction currency
ACCT_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert the transfer price from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price
ACCT_TP_RATE_DATE	DATE			Rate date used to convert the transfer price from the transaction currency to the functional currency.
ACCT_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert the transfer price from the transaction currency to the provider functional currency
ACCT_TRANSFER_PRICE	NUMBER			Transfer price in functional currency of the provider operating unit
PROJACCT_TRANSFER_PRICE	NUMBER			Transfer price in the functional currency of cross charged project (receiver operating unit)
CC_MARKUP_BASE_CODE	VARCHAR2	(1)		Audit column.to help derive how transfer price wsa calculated. Basis used to calculate the transfer price.
TP_BASE_AMOUNT	NUMBER			Audit column. Base amount used to derive the transfer price, held in transfer price transaction currency
CC_CROSS_CHARGE_TYPE	VARCHAR2	(2)		Cross Charge Type
RECVR_ORG_ID	NUMBER			Receiver Operating Unit Identifier
CC_BL_DISTRIBUTED_CODE	VARCHAR2	(1)	Yes	Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process
CC_IC_PROCESSED_CODE	VARCHAR2	(1)	Yes	Indicates the processing status of the Expenditure Item by the Generate Intercompany Invoice process
TP_IND_COMPILED_SET_ID	NUMBER			Identifier of the compiled set used to calculate the Transfer Price using a burden schedule
TP_BILL_RATE	NUMBER			Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule
TP_BILL_MARKUP_PERCENTAGE	NUMBER			Audit column. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule
TP_SCHEDULE_LINE_PERCENTAGE	NUMBER			Audit column. Percentage applied to the calculated transfer price from the schedule line
TP_RULE_PERCENTAGE	NUMBER			Audit column. Percentage applied to the calculated transfer price from the rule definition
CC_PRVDR_COST_RECLASS_CODE	VARCHAR2	(1)		Indicates if the cost for the expenditure item is reclassified for intercompany billing
CRL_ASSET_CREATION_STATUS_CODE	VARCHAR2	(1)		For future use
CRL_ASSET_CREATION_REJ_CODE	VARCHAR2	(30)		for future use
COST_JOB_ID	NUMBER	(15)		Costing Job ID
TP_JOB_ID	NUMBER	(15)		Borrowed/Lent Job ID
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)		Provider Project Bill Job ID
COST_DIST_WARNING_CODE	VARCHAR2	(30)		During funds check if the transaction passes in advisory mode then this column will be updated with the apropriate warning.
PROJECT_TP_RATE_DATE	DATE			Rate date used to convert transfer price from the transaction currency to the project currency.
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert transfer price from the transaction currency to the project currency.
PROJECT_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert transfer price from the transaction currency to the project currency.
PROJFUNC_TP_RATE_DATE	DATE			Rate date used to convert transfer price from the transaction currency to the project functional currency.
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert transfer price from the transaction currency to the project functional currency.
PROJFUNC_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert transfer price from the transaction currency to the project functional currency.
PROJFUNC_TRANSFER_PRICE	NUMBER			Transfer price in project functional currency.
BILL_TRANS_FORECAST_CURR_CODE	VARCHAR2	(15)		Bill transaction currency code for the expenditure item for forecast revenue
BILL_TRANS_FORECAST_REVENUE	NUMBER			The forecast revenue amount in bill transaction currency of a labor item based on T&M bill rates and markups and labor multipliers. This column is populated by the Compute Forecast Revenue process. Once the item is revenue distributed, this column is cleared
PROJFUNC_REV_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project functional Currency if 'Fixed Date' rate date type used during revenue generation.
PROJFUNC_REV_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to Project functional currency if 'User' exchange rate type used. During revenue generation
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert costs from the transaction currency to the project functional currency.
PROJFUNC_COST_RATE_DATE	DATE			Rate date used to convert costs from the transaction currency to the project functional currency.
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			Exchange rate used to convert costs from the transaction currency to the project functional currency.
PROJECT_RAW_COST	NUMBER			Raw cost in project currency.
PROJECT_BURDENED_COST	NUMBER			Burdened cost in project currency.
ASSIGNMENT_ID	NUMBER	(15)		Identifier for an assignment associated with the transaction.
WORK_TYPE_ID	NUMBER	(15)		Identifier for a work type assigned to the transaction.
PROJFUNC_RAW_REVENUE	NUMBER			Revenue Amount in Project Functional
PROJECT_BILL_AMOUNT	NUMBER			Bill Amount in Project
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency code.
PROJECT_RAW_REVENUE	NUMBER			Revenue Amount in Project
PROJECT_TRANSFER_PRICE	NUMBER			Transfer price in project currency.
TP_AMT_TYPE_CODE	VARCHAR2	(30)		Cross charge classification.
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)		Bill transaction currency code for the expenditure item for accrued revenue and bill amounts
BILL_TRANS_RAW_REVENUE	NUMBER			The raw revenue of the item in bill transaction currency
BILL_TRANS_BILL_AMOUNT	NUMBER			Bill amount in bill transaction currency.
BILL_TRANS_ADJUSTED_REVENUE	NUMBER			The adjusted revenue of the item in bill transaction currency. For 'Work' revenue accrual or invoicing method adjusted revenue = (quantity * bill rate) or (project currency raw cost * (markup/100) or (project currency raw cost * labor multiplier) - discount amount
REVPROC_CURRENCY_CODE	VARCHAR2	(15)		Revenue Processing Currency Code
REVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to revenue processing currency during revenue generation. Currently Project Functional is the Revenue Processing Currency.
REVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to Revenue Processing Currency if 'Fixed Date' rate date type used during revenue generation. Currently Project Functional is the Revenue Processing Currency
REVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to revenue processing currency if 'User' exchange rate type used. During revenue generation. Currently Project functional currency is the Revenue Processing Currency
INVPROC_CURRENCY_CODE	VARCHAR2	(15)		Invoice Processing Currency
INVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to project functional currency during revenue generation
INVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project functional currency if 'Fixed Date' rate date type used during revenue generation
DISCOUNT_PERCENTAGE	NUMBER			Discount Percentage is used to calculate the adjusted revenue and rate
LABOR_MULTIPLIER	NUMBER			Audit Column for rate derivation.
AMOUNT_CALCULATION_CODE	VARCHAR2	(15)		Audit Column for rate derivation. Valid values are Indirect(I), Overrides(O), Extension (E), Bill rates (B) , Labor Multiplier (L)
BILL_MARKUP_PERCENTAGE	NUMBER			Audit Column for bill rate derivation. Markup Percentage used in derving bill rate was based on a markup in bill rate schedule.
RATE_SOURCE_ID	NUMBER	(15)		Audit Column for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, override id if override used
INVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to project functional. During revenue generation
INV_GEN_REJECTION_CODE	VARCHAR2	(30)		Invoice Generation Rejection Code
PROJFUNC_BILL_AMOUNT	NUMBER			Bill Amount in Project Functional
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to Project currency during revenue generation
PROJECT_REV_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project Currency if 'Fixed Date' rate date type used during revenue generation
PROJECT_REV_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to project currency if 'User' exchange rate type used. During revenue generation
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to project functional currency during revenue generation
PROJFUNC_INV_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to project functional currency during Invoice generation
PROJFUNC_INV_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project functional Currency if 'Fixed Date' rate date type used during invoice generation
PROJFUNC_INV_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to Project functional currency if 'User' exchange rate type used. During invoice generation
PROJECT_INV_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to project functional currency during Invoice generation
PROJECT_INV_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project functional Currency if 'Fixed Date' rate date type used during invoice generation.
PROJECT_INV_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to Project functional currency if 'User' exchange rate type used. During invoice generation
PROJFUNC_FCST_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to project functional currency during Forecast revenue generation.
PROJFUNC_FCST_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to project functional Currency if 'Fixed Date' rate date type used during forecast revenue generation.
PROJFUNC_FCST_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to Project functional currency if 'User' exchange rate type used. During forecast revenue generation.
PRVDR_ACCRUAL_DATE	DATE			Provider operating unit accounting date for transactions included in a reversing expenditure batch.
RECVR_ACCRUAL_DATE	DATE			Receiver operating unit accounting date for transactions included in a reversing expenditure batch.
RATE_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for discount override or rate override
POSTED_DENOM_BURDENED_COST	NUMBER			Accounted burden amount in transaction currency.
POSTED_PROJECT_BURDENED_COST	NUMBER			Accounted burden amount in project currency.
POSTED_PROJFUNC_BURDENED_COST	NUMBER			Accounted burden amount in project functional currency.
POSTED_ACCT_BURDENED_COST	NUMBER			Accounted burden amount in expenditure functional currency.
ADJUSTMENT_TYPE	VARCHAR2	(150)		Adjustment Type Code
CAPITAL_EVENT_ID	NUMBER	(15)		Capital Event Identifier to which the expenditure item is assigned.
PO_LINE_ID	NUMBER			Purchase order line identifier for imported contingent worker labor transactions.
PO_PRICE_TYPE	VARCHAR2	(30)		Purchase order line price type for contingent worker labor transactions.
WIP_RESOURCE_ID	NUMBER			Identifier of the resource for work in progress
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
UNIT_OF_MEASURE	VARCHAR2	(30)		Base unit of measure
SRC_SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)		The system linkage of the source expenditure items which were summarized to create separate burden transaction.
DOCUMENT_HEADER_ID	NUMBER	(15)		This column refers to a header-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.INVOICE_ID. If the expenditure item originated in Oracle Purchasing, it holds the PO_HEADERS_ALL.PO_HEADER_ID. This column is not used for labor and usage expenditure items.
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)		This column refers to a distribution-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID. If the expenditure item originated in Oracle Purchasing, it holds the RCV_TRANSACTIONS.TRANSACTION_ID. This column is not used for labor and usage expenditure items.
DOCUMENT_LINE_NUMBER	NUMBER	(15)		This column refers to a line-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_LINES_ALL.LINE_NUMBER. If the expenditure item originated in Oracle Purchasing, it holds the PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. This column is not used for labor and usage expenditure items.
DOCUMENT_PAYMENT_ID	NUMBER	(15)		This column refers to the payment record identifier in Oracle Payables. It holds the AP_PAYMENT_DISTRIBUTIONS_ALL.PAYMENT_ID. This column is only populated when you enable cash basis accounting or, for payment discounts, when you use accrual basis accounting. This column is not used for labor and usage expenditure items.
VENDOR_ID	NUMBER			This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the PO_HEADERS_ALL.VENDOR_ID. This column is not used for labor and usage expenditure items.
DOCUMENT_TYPE	VARCHAR2	(30)		The supplier cost interface process uses this column to indicate the transaction type. Valid values are as follows: Payables, Purchasing, or Receiving.
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)		The supplier cost interface process uses this column to indicate the transaction type of the distribution. Valid values are as follows: Payables, Purchasing, or Receiving.
HISTORICAL_FLAG	VARCHAR2	(1)		Historical Flag
LOCATION_ID	NUMBER	(15)		HR Location
PAY_ELEMENT_TYPE_ID	NUMBER	(15)		Pay element type id
COSTING_METHOD	VARCHAR2	(150)		The method used to cost the expenditure item
RATE_SOURCE_CODE	VARCHAR2	(30)		Name of the source from which employee rates are derived
PAYROLL_ACCRUAL_FLAG	VARCHAR2	(1)		payroll_accrual_flag is 'Flag to indicate if the labor costs are accrued to a project
RBC_ELEMENT_TYPE_ID	NUMBER	(9)		Pay element identifier
INTERFACE_RUN_ID	NUMBER	(15)		Foreign Key to PA_PAY_AUDIT_ALL
CBS_ELEMENT_ID	NUMBER	(15)		Unique id corresponding to the cost code.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      ADJUSTED_REVENUE
,      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
,      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
,      SYSTEM_LINKAGE_FUNCTION
,      BURDEN_SUM_DEST_RUN_ID
,      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
,      DENORM_ID
,      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_TYPE
,      ACCT_TP_RATE_DATE
,      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
,      WIP_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      UNIT_OF_MEASURE
,      SRC_SYSTEM_LINKAGE_FUNCTION
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_PAYMENT_ID
,      VENDOR_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      HISTORICAL_FLAG
,      LOCATION_ID
,      PAY_ELEMENT_TYPE_ID
,      COSTING_METHOD
,      RATE_SOURCE_CODE
,      PAYROLL_ACCRUAL_FLAG
,      RBC_ELEMENT_TYPE_ID
,      INTERFACE_RUN_ID
,      CBS_ELEMENT_ID
FROM PA.PA_EXPENDITURE_ITEMS_ALL;

Dependencies

[top of page]

PA.PA_EXPENDITURE_ITEMS_ALL does not reference any database object

PA.PA_EXPENDITURE_ITEMS_ALL is referenced by following:

PA: PA_EXPENDITURE_ITEMS_ALL#