Projects Codes Table Formats (PRProjectCodes)
Follow Ajera CRM specifications for preparing a file containing project codes.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| WBS1 | varchar | 30 | Project record number; primary key; must exist in PR |
| WBS2 | varchar | 7 | Phase record number; primary key; must exist in PR |
| WBS3 | varchar | 7 | Task record number; primary key; must exist in PR |
| ProjectCode | varchar | Project code; primary key; must exist in CFGProjectCode (ProjectCode/Description) | |
| Fees | decimal | 9 | Total fees for work associated with the Project Code |
| Seq | smallint | 2 | Sort sequence for data in the ProjectCodes grid, used with Description to sort data when retrieved or displayed |