1. Tables and Views for Project Management
  2. PJF_TXN_ACCUM_IN_GT

PJF_TXN_ACCUM_IN_GT

This is an input 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 for transaction table row id for tie back process *****

ORGANIZATION_IDNUMBER18The organization ID of the element, if RBS element is a organization. *****

PERSON_IDNUMBER18The person ID of the element, if RBS element is a person. *****

PROJECT_ROLE_IDNUMBER18The role ID of the element, if RBS element is a role. *****

PERSON_TYPEVARCHAR230Person Type Code *****

JOB_IDNUMBER18The job ID of the element, if RBS element is a job. *****

VENDOR_IDNUMBER18Identifier of the vendor.

EXPENDITURE_TYPE_IDNUMBER18The expenditure type ID, if RBS element is an expenditure type. *****

EXPENDITURE_CATEGORY_IDNUMBER18The expenditure category ID, if RBS element is an expenditure category. *****

EVENT_TYPE_IDNUMBER18The event type ID, if RBS element is an event type. *****

REVENUE_CATEGORYVARCHAR230Revenue Category Code *****

NON_LABOR_RESOURCE_IDNUMBER18The Non-labor Resource ID of the element, if RBS element is a PA Non-Labor resource. *****

EQUIPMENT_RESOURCE_FLAGVARCHAR21Indicates that the nonlabor resource is of the Equipment resource class.

INVENTORY_ITEM_IDNUMBER18The item ID of the element, if RBS element is an item. *****

ITEM_CATEGORY_IDNUMBER18The item category ID of the element, if RBS element is an item category. *****

SYSTEM_LINKAGE_FUNCTIONVARCHAR23The Oracle Fusion Project Costing function used to identify the resource class.

ORDER_TYPE_LOOKUP_CODEVARCHAR225Specifies the purchase order type.

RESOURCE_CLASS_CODEVARCHAR225Code identifying the resource class.

RESOURCE_CLASS_IDNUMBER18Identifier of the resource class.

TXN_ACCUM_HEADER_IDNUMBER18This is identifier for header. *****

RBS_VERSION_IDNUMBER18Identifier of the RBS version to which the element belongs. *****

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

CONTRACT_IDNUMBER18Unique identifier of the award.

FUNDING_SOURCE_IDNUMBER18Identifier of the award funding source.

Indexes

Index Uniqueness Columns
PJF_TXN_ACCUM_IN_GT_N1 Non Unique SOURCE_ID