Opportunities Project Codes Table Formats (OpportunityProjectCodes)
Follow Vision specifications for preparing a file containing opportunity project codes.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| OpportunityID | varchar | 32 | Internal reference number for the opportunity record; primary key; must exist in Opportunity (OpportunityID/Opportunity) |
| ProjectCode | varchar | 4 | Projectcode for the type of work expected to be performed; primary key; must exist in CFGProjectCode (ProjectCode/Description) |
| Fee | decimal | 9 | Fees for the work represented by the ProjectCode |