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 |