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 |