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_TXN_ACCUM

Object Details

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

PA_TXN_ACCUM stores the lowest level of summarization which is the
base for project summary amounts.
Transaction accumulation records are grouped by
transaction attributes for each pa_period,
gl_period, week_ending_date, month_ending_date,
task_id and project_id for cost distribution line
s, revenue distribution lines, event revenue
distribution lines, and commitments; one record for each combination
is created in this table. For project level amounts, the task_id is
stored as zero.
.
Incremental amounts are added to total amounts when
amounts are rolled-up to project summary tables
PA_PROJECT_ACCUM_ACTUALS and PA_PROJECT_ACCUM_COMMITMENTS).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TXN_ACCUM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TXN_ACCUM_ID
PA_TXN_ACCUM_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
PA_TXN_ACCUM_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID GL_PERIOD TASK_ID
PA_TXN_ACCUM_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
PA_TXN_ACCUM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PA_PERIOD TASK_ID WEEK_ENDING_DATE EXPENDITURE_TYPE ORGANIZATION_ID PERSON_ID
PA_TXN_ACCUM_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PA_PERIOD TASK_ID WEEK_ENDING_DATE EVENT_TYPE ORGANIZATION_ID
PA_TXN_ACCUM_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTUAL_COST_ROLLUP_FLAG PROJECT_ID
PA_TXN_ACCUM_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ROLLUP_FLAG PROJECT_ID
PA_TXN_ACCUM_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CMT_ROLLUP_FLAG PROJECT_ID
PA_TXN_ACCUM_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TXN_ACCUM_ID	NUMBER	(15)	Yes	The identifier uniquely identifies txns that were groups of accumulated txns
PERSON_ID	NUMBER			The identifier of the person for which accumulation is done
JOB_ID	NUMBER			The identifier of the job for which accumulation is done
ORGANIZATION_ID	NUMBER			The identifier of the organization for which accumulation is done
VENDOR_ID	NUMBER			The identifier of the supplier for which accumulation is done
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure type of the accumulated txn
EVENT_TYPE	VARCHAR2	(30)		Event type of the accumulated txn
NON_LABOR_RESOURCE	VARCHAR2	(20)		Expenditure category of the accumulated txn
EXPENDITURE_CATEGORY	VARCHAR2	(30)		Expenditure category of the accumulated txn
REVENUE_CATEGORY	VARCHAR2	(30)		Revenue category of the accumulated txn
NON_LABOR_RESOURCE_ORG_ID	NUMBER			Non labor resource organization id of the accumulated txn
EVENT_TYPE_CLASSIFICATION	VARCHAR2	(30)		Event type classification of the accumulated txn
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)		System linkage function of the accumulated txn
PROJECT_ID	NUMBER	(15)	Yes	Identifier of project for the accumulated txn
TASK_ID	NUMBER	(15)	Yes	Identifier of task for the accumulated txn
PA_PERIOD	VARCHAR2	(20)	Yes	PA period name of the accumulated txn
GL_PERIOD	VARCHAR2	(15)	Yes	GL period name of the accumulated txn
MONTH_ENDING_DATE	DATE		Yes	Month ending date for the accumulated transaction
WEEK_ENDING_DATE	DATE		Yes	Week ending date for the accumulated transaction
TOT_REVENUE	NUMBER			Total revenue amount
TOT_RAW_COST	NUMBER			Total Raw cost amount
TOT_BURDENED_COST	NUMBER			Total Burdened cost amount
TOT_QUANTITY	NUMBER			Total quantity amount
TOT_LABOR_HOURS	NUMBER			Total labor hours amount
TOT_BILLABLE_RAW_COST	NUMBER			Total billable raw cost amount
TOT_BILLABLE_BURDENED_COST	NUMBER			Total billable burdened cost amount
TOT_BILLABLE_QUANTITY	NUMBER			Total billable quantity amount
TOT_BILLABLE_LABOR_HOURS	NUMBER			Total billable labor hours amount
TOT_CMT_RAW_COST	NUMBER			Total commitment raw cost amount
TOT_CMT_BURDENED_COST	NUMBER			Total commitment burdened cost amount
TOT_CMT_QUANTITY	NUMBER			Total commitment quantity amount
I_TOT_REVENUE	NUMBER			Also stores future period revenue amount
I_TOT_RAW_COST	NUMBER			Also stores future period raw cost amount
I_TOT_BURDENED_COST	NUMBER			Also stores future period burdened cost amount
I_TOT_QUANTITY	NUMBER			Also stores future period quantity
I_TOT_LABOR_HOURS	NUMBER			Also stores future period labor hours
I_TOT_BILLABLE_RAW_COST	NUMBER			Also stores future period billable raw cost
I_TOT_BILLABLE_BURDENED_COST	NUMBER			Also stores future period billable burdened cost
I_TOT_BILLABLE_QUANTITY	NUMBER			Also stores future period billable quantity
I_TOT_BILLABLE_LABOR_HOURS	NUMBER			Also stores future period billable labor hours
COST_IND_COMPILED_SET_ID	NUMBER	(15)		Indirect compiled set id used for calculating burdened cost
REV_IND_COMPILED_SET_ID	NUMBER	(15)		Indirect compiled set id used for calculating revenue
INV_IND_COMPILED_SET_ID	NUMBER	(15)		Indirect compiled set id used for calculating invoice
CMT_IND_COMPILED_SET_ID	NUMBER	(15)		Indirect compiled set used for calculating burdened cost for commitments
UNIT_OF_MEASURE	VARCHAR2	(30)		Unit of measure for commitments or actual cost
ACTUAL_COST_ROLLUP_FLAG	VARCHAR2	(1)	Yes	Indicates if the actual cost is rolled up to pa_project_accum_actuals
REVENUE_ROLLUP_FLAG	VARCHAR2	(1)	Yes	Indicates if the revenue is rolled up to pa_project_accum_actuals
CMT_ROLLUP_FLAG	VARCHAR2	(1)	Yes	Indicates if the commitment are rolled up to pa_project_accum_commitments
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.

Query Text

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


SELECT TXN_ACCUM_ID
,      PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      VENDOR_ID
,      EXPENDITURE_TYPE
,      EVENT_TYPE
,      NON_LABOR_RESOURCE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      NON_LABOR_RESOURCE_ORG_ID
,      EVENT_TYPE_CLASSIFICATION
,      SYSTEM_LINKAGE_FUNCTION
,      PROJECT_ID
,      TASK_ID
,      PA_PERIOD
,      GL_PERIOD
,      MONTH_ENDING_DATE
,      WEEK_ENDING_DATE
,      TOT_REVENUE
,      TOT_RAW_COST
,      TOT_BURDENED_COST
,      TOT_QUANTITY
,      TOT_LABOR_HOURS
,      TOT_BILLABLE_RAW_COST
,      TOT_BILLABLE_BURDENED_COST
,      TOT_BILLABLE_QUANTITY
,      TOT_BILLABLE_LABOR_HOURS
,      TOT_CMT_RAW_COST
,      TOT_CMT_BURDENED_COST
,      TOT_CMT_QUANTITY
,      I_TOT_REVENUE
,      I_TOT_RAW_COST
,      I_TOT_BURDENED_COST
,      I_TOT_QUANTITY
,      I_TOT_LABOR_HOURS
,      I_TOT_BILLABLE_RAW_COST
,      I_TOT_BILLABLE_BURDENED_COST
,      I_TOT_BILLABLE_QUANTITY
,      I_TOT_BILLABLE_LABOR_HOURS
,      COST_IND_COMPILED_SET_ID
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      CMT_IND_COMPILED_SET_ID
,      UNIT_OF_MEASURE
,      ACTUAL_COST_ROLLUP_FLAG
,      REVENUE_ROLLUP_FLAG
,      CMT_ROLLUP_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADW_NOTIFY_FLAG
FROM PA.PA_TXN_ACCUM;

Dependencies

[top of page]

PA.PA_TXN_ACCUM does not reference any database object

PA.PA_TXN_ACCUM is referenced by following:

PA: PA_TXN_ACCUM#