PA_PROJECTS
Project Accounting Project Codes
tableFINPA
PA_PROJECTS — Project Accounting Project Codes. FIN table in the standard Ross ERP 8.0 schema: 40 columns, used by 43 programs. Columns, data types, keys, foreign keys and relationships.
Open PA_PROJECTS in the interactive Data Dictionary →Part of PA tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | PA_PROJECT_CODE | varchar(10) | PK | PA Project Code |
| 4 | PA_PROJECT_NAME | varchar(30) | ||
| 5 | PA_PROJECT_DESCRIPTION | text | PA Project Description | |
| 6 | PA_START_DATE | datetime | Project or WBS Activity Start Date | |
| 7 | PA_END_DATE | datetime | Project or WBS Activity End Date | |
| 8 | PA_MAX_WBS_LEVELS | smallint | Maximum number of WBS levels in this project | |
| 9 | PA_WBS_DELIMITER | varchar(1) | Project WBS Delimiter | |
| 10 | PA_PROJECT_STATUS | smallint | PA Project Status | |
| 11 | PA_PROJECT_TYPE | smallint | Project Type | |
| 12 | PA_ALLOW_WBS_UPDATES_DEFAULT | varchar(1) | Project default value for WBS activities | |
| 13 | PA_WBS_LEVEL_1_PROMPT | varchar(15) | ||
| 14 | PA_WBS_LEVEL_2_PROMPT | varchar(15) | ||
| 15 | PA_WBS_LEVEL_3_PROMPT | varchar(15) | ||
| 16 | PA_WBS_LEVEL_4_PROMPT | varchar(15) | ||
| 17 | PA_WBS_LEVEL_5_PROMPT | varchar(15) | ||
| 18 | PA_WBS_LEVEL_1_LENGTH | smallint | ||
| 19 | PA_WBS_LEVEL_2_LENGTH | smallint | ||
| 20 | PA_WBS_LEVEL_3_LENGTH | smallint | ||
| 21 | PA_WBS_LEVEL_4_LENGTH | smallint | ||
| 22 | PA_WBS_LEVEL_5_LENGTH | smallint | ||
| 23 | PA_AR_DIVISION | varchar(2) | ||
| 24 | PA_CUSTOMER | varchar(8) | ||
| 25 | PA_PROJECT_MANAGER | varchar(20) | ||
| 26 | PA_PROJECT_ADMINISTRATOR | varchar(20) | ||
| 27 | PA_DOCUMENT_LINK_1 | varchar(500) | ||
| 28 | PA_DOCUMENT_LINK_2 | varchar(500) | ||
| 29 | PA_DOCUMENT_LINK_3 | varchar(500) | ||
| 30 | PA_REQUIRE_WBS_APPROVAL | varchar(1) | Require Approval for WBS Adds and Deletes | |
| 31 | PA_CONTRACT_DESCRIPTION | varchar(30) | ||
| 32 | PA_CONTRACT_INFORMATION | text | PA Contract Information | |
| 33 | PA_UPDATES_ALLOWED | varchar(1) | PA Project/WBS Activity Updates Allowed Flag | |
| 34 | PA_OPEN_DATE | datetime | Project Open Date | |
| 35 | PA_PROJECT_CLASS | varchar(6) | Project Class | |
| 36 | PA_CONTRACT_CODE | varchar(8) | Contract Code | |
| 37 | GL_PA_LABOR_ACCOUNT | varchar(50) | ||
| 38 | GL_PA_LAB_OH_ACCOUNT | varchar(50) | ||
| 39 | GL_PA_LABOR_CODE | varchar(6) | ||
| 40 | GL_PA_LAB_OH_CODE | varchar(6) |