Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Sunday, May 5, 2013


Project Accounting main tables

The below are useful important Oracle Project Accounting tables

Table Name Description
============================================
PA_PROJECTS_ALL Information about projects
PA_AGREEMENTS_ALL Customer contracts that serve as the basis for work authorization
PA_BILL_RATES_ALL Information about bill rates and markups of standard bill rate schedules
PA_BILLING_ASSIGNMENTS_ALL Assignments of billing extensions to a project type, project, or task
PA_COST_DISTRIBUTION_LINES_ALL Information about expenditure item cost distribution
PA_CUST_REV_DIST_LINES_ALL Information about expenditure item revenue distribution
PA_DRAFT_INVOICE_DETAILS_ALL Intercompany invoice details for cross charged transactions
PA_DRAFT_INVOICES_ALL Information about draft invoices generated for projects
PA_DRAFT_REVENUES_ALL Information about draft revenue generated for projects
PA_EXPENDITURE_COST_RATES_ALL Cost rates for non-labor expenditure types
PA_EXPENDITURE_GROUPS_ALL Groups of pre-approved expenditures
PA_EXPENDITURE_ITEMS_ALL The smallest units of expenditure charged to projects and tasks
PA_EXPENDITURES_ALL Groups of expenditure items incurred by employees or organizations for an expenditure period
PA_PERIODS_ALL Implementation-defined periods against which project performance is measured
PA_PROJECT_ASSET_LINES_ALL Summarized project CIP costs
PA_PROJECT_ASSETS_ALL Assets defined for capital projects
PA_EXPENDITURE_TYPES Implementation-defined classifications of expenditures charged to projects and tasks
PA_EXPENDITURE_CATEGORIES Implementation-defined groupings of expenditure types by type of cost
PA_CLASS_CATEGORIES Implementation-defined categories for classifying projects
PA_CLASS_CODES Implementation-defined values within class categories that can be used to classify projects
PA_PROJECT_CLASSES Class codes of class categories that are used to classify projects
PA_BUDGET_VERSIONS Versions of project budgets
PA_BUDGET_LINES Detail lines of project and task budgets

No comments:

Post a Comment