Opportunities - Project Codes Table Formats (OpportunityProjectCodes)

Follow DPS 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	Project code 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 Project Code