Projects Codes Table Formats (PRProjectCodes)
Follow Vision 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 |