Project Accounting attributes

Attribute name Attribute Table name
Account Category ACCT_CATEGORY ACACCTCAT
Account Category Long Name DESCRIPTION ACACCTCAT
Account Category Name ACCT_CATEGORY,DESCRIPTION ACACCTCAT
Category Name CATEGORY_TYPE ACACCTCAT
Activity ACTIVITY ACACTIVITY
Activity Group ACTIVITY_GRP ACACTIVITY
Activity Group Currency CURRENCY_CODE ACACTGRP
Activity Group Name DESCRIPTION ACACTGRP
Activity Long Name ACTIVITY ,ACTIVITY_NAME ACACTIVITY
Activity Name DESCRIPTION ACACTIVITY
Calendar CALENDAR_NAME ACACTGRP
Currency CURRENCY_CODE ACACTIVITY
Report 01 Currency CURR_CODE_1 ACACTGRP
Report 02 Currency CURR_CODE_2 ACACTGRP
Structure STRUCTURE.DESCRIPTION, ACACTIVITY.STRUCTURE STRUCTURE,ACACTIVITY
Accounting Unit ACCT_UNIT GLNAMES
Accounting Unit Long Name ACCT_UNIT,DESCRIPTION GLNAMES
Accounting Unit Name DESCRIPTION GLNAMES
GL Company COMPANY GLNAMES
GL Company Long Name COMPANY, GLSYSTEM.NAME GLNAMES
GL Company Name NAME GLSYSTEM
Org Level 01 LEVEL_DEPTH, ACCT_UNIT,DESCRIPTION GLNAMES
Org Level 02 LEVEL_DEPTH, ACCT_UNIT,DESCRIPTION GLNAMES
Org Level 03 LEVEL_DEPTH, ACCT_UNIT,DESCRIPTION GLNAMES
Org Level 04 LEVEL_DEPTH, ACCT_UNIT,DESCRIPTION GLNAMES
Org Level 05 LEVEL_DEPTH, ACCT_UNIT,DESCRIPTION GLNAMES
Person Responsible PERSON_RESP GLNAMES
Var Level VAR_LEVEL_DISP GLNAMES
Account ACCOUNT GLCHARTDTL
Account Code ACCOUNT, SUB_ACCOUNT GLCHARTDTL
Account Long Name ACCOUNT, SUB_ACCOUNT,ACCOUNT_DESC GLCHARTDTL
Account Name ACCOUNT_DESC GLCHARTDTL
Account Type GL_ACCT_TYPE GLCHARTDTL
Chart CHART_NAME GLCHARTDTL
Chart Level 01 ACCOUNT_DESC GLCHARTSUM
Chart Level 02 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM, GLCHARTDTL
Chart Level 03 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 04 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 05 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 06 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 07 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 08 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Level 09 GLCHARTSUM.ACCOUNT_DESC, GLCHARTSUM.SUMRY_ACCT_ID, GLCHARTDTL.ACCOUNT, GLCHARTDTL.SUB_ACCOUNT, GLCHARTDTL.ACCOUNT_DESC GLCHARTSUM,GLCHARTDTL
Chart Section CHART_SECTION GLCHARTDTL
Sub Account SUB_ACCOUNT GLCHARTDTL
Resource Code RESOURCE_CODE ACCOMMITX
Resource Company RESOURCE_COMP ACCOMMITX
Resource Name RESOURCE_DESC ACCOMMITX
Resource Type RESOURCE_TYPE ACCOMMITX
Resource Type Code RESOURCE_TYPE ACCOMMITX
Source Code SOURCE_CODE ACCOMMITX
System Code R_SYSTEM ACCOMMITX
System Code Description DESCRIPTION SYSTEMCODE
AC Operator OPERATOR.NAME, ACTRANS.OPERATOR OPERATOR, ACTRANS
AC Posting Date POSTING_DATE ACTRANS
AC Trans Date TRAN_DATE ACTRANS
ACT Description DESCRIPTION ACTRANS
Control Group CONTROL_GROUP ACTRANS
Resource Name RESOURCE_DESC ACTRANS
Resource Type RESOURCE_TYPE ACTRANS
Source Code SOURCE_CODE ACTRANS
Status STATUS ACTRANS
Structure STRUCTURE ACACTIVITY
System Code SYSTEM ACTRANS
System Code Description DESCRIPTION SYSTEMCODE