1. Tables and Views for Project Management
  2. PJF_TXN_ACCUM_OUT_GT

PJF_TXN_ACCUM_OUT_GT

This is an output table for creating txn accum header and rbs mapping

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

Columns

Name

SOURCE_IDNUMBER18Identifier used as primary key in transaction table for tie back process *****

SOURCE_ROW_IDROWIDIdentifier of transaction table row id for tie back process *****

ITEM_CATEGORY_IDNUMBER18Identifier of the item category.

RESOURCE_CLASS_IDNUMBER18Identifier of the resource class.

TXN_ACCUM_HEADER_IDNUMBER18YesThis is identifier for header. *****

ATTRIBUTE1NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE2NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE3NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE4NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE5NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE6VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE7VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE8VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE9VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE10VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE11DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE12DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE13DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE14DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE15DATEDescriptive Flexfield: segment of the user descriptive flexfield.

PROJECT_IDNUMBER18PROJECT_ID

TASK_IDNUMBER18TASK_ID

BUDGET_VERSION_IDNUMBER18BUDGET_VERSION_ID

RBS_VERSION_IDNUMBER18RBS_VERSION_ID

PLAN_LEVEL_CODEVARCHAR21PLAN_LEVEL_CODE

RBS_ELEMENT_IDNUMBER18RBS_ELEMENT_ID

BUDGET_PROJ_ELEMENT_IDNUMBER18BUDGET_PROJ_ELEMENT_ID

BUDGET_RBS_ELEMENT_IDNUMBER18BUDGET_RBS_ELEMENT_ID

PLANNED_FLAGVARCHAR21PLANNED_FLAG

CONTRACT_IDNUMBER18Unique identifier of the award.

FUNDING_SOURCE_IDNUMBER18Identifier of the award funding source.

Indexes

Index Uniqueness Columns
PJF_TXN_ACCUM_OUT_GT_N1 Non Unique RBS_VERSION_ID, TXN_ACCUM_HEADER_ID