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_HISTORY

Object Details

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

PA_EXPENDITURE_HISTORY is normalized representation of PA_EI_DENORM, primarily used for storing audit information for timecards created via Oracle Self-Service Time. Please refer to the original tables (PA_EXPENDITURES_ALL and PA_EXPENDITURE_ITEMS_ALL) for a detailed description of the columns.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EXPENDITURE_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_PERSON_ID EXPENDITURE_ID DENORM_ID
PA_EXPENDITURE_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_PERSON_ID PROJECT_ID TASK_ID
PA_EXPENDITURE_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_PERSON_ID EXPENDITURE_TYPE
PA_EXPENDITURE_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_PERSON_ID EXPENDITURE_ITEM_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
INCURRED_BY_PERSON_ID	NUMBER	(9)	Yes	The identifier of the employee who incurred the charges. This column is always populated for labor and expense report charges and is not populated for supplier invoices. For usages, specifying employees who incurred the charges is optional
EXPENDITURE_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the expenditure
DENORM_ID	NUMBER	(15)	Yes	The identifier of denormalized representation of the expenditure items created through Self-Service Time module
PROJECT_ID	NUMBER	(15)	Yes	The project_id of the event that the expenditure item is FIFO marked by
TASK_ID	NUMBER	(15)	Yes	The identifier of the task to which the expenditure item is charged
EXPENDITURE_CLASS_CODE	VARCHAR2	(30)	Yes	The classification of the expenditure, indicating the type of items grouped into it
EXPENDITURE_SOURCE_CODE	VARCHAR2	(30)	Yes	Identifies the external system in which the transaction originated.
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	The expenditure type that classifies the type of work performed
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
EXPENDITURE_ITEM_DATE	DATE		Yes	The date on which the work occurred
QUANTITY	NUMBER	(22)	Yes	The number of units of the work performed
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
EXPENDITURE_ITEM_COMMENT	VARCHAR2	(240)		The free text comment entered for an expenditure item to further describe work done
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.
CHANGE_CODE	VARCHAR2	(30)		Change Reason for audit purposses
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
AUDIT_TYPE_CODE	VARCHAR2	(30)		The type of audit record.
LATE_ENTRY_CODE	VARCHAR2	(30)		The late entry code specified for the audit record, if any.
REASON_COMMENT	VARCHAR2	(80)		The audit comment specified for the audit record, if any.
AUDIT_ORDER	NUMBER			Order in which this item was audited. Only populated for Self Service Time.

Query Text

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


SELECT INCURRED_BY_PERSON_ID
,      EXPENDITURE_ID
,      DENORM_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_CLASS_CODE
,      EXPENDITURE_SOURCE_CODE
,      EXPENDITURE_TYPE
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      EXPENDITURE_ITEM_COMMENT
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      CHANGE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AUDIT_TYPE_CODE
,      LATE_ENTRY_CODE
,      REASON_COMMENT
,      AUDIT_ORDER
FROM PA.PA_EXPENDITURE_HISTORY;

Dependencies

[top of page]

PA.PA_EXPENDITURE_HISTORY does not reference any database object

PA.PA_EXPENDITURE_HISTORY is referenced by following:

APPS: PA_EXPENDITURE_HISTORY