Contracts - Customers Table Formats (PRClientAssoc)
Follow GovWin Capture Management specifications for preparing a file containing contract-customer associations.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| WBS1 | varchar | 30 | Contract record number; primary key; must exist in PR |
| ClientID | varchar | 32 | Internal identifier for the customer; links to the CL Table; primary key; must exist in CL (ClientID/Client) |
| PrimaryInd | varchar | 1 | Variable indicating whether or not the customer is the contract's Primary Customer; default is N (no) |
| Role | varchar | 10 | The customer's contract role; null or must exist in CFGClientRole (Code/Description) |
| Address | varchar | 20 | Unique identifier for the address record; linking to the CLAddress Table; null or must exist in CLAddress |
| RoleDescription | text | 16 | The user-entered text describing the role |
| ClientConfidential | varchar | 1 | Variable indicating whether or not the Primary Customer is marked Confidential on the General tab of the Contract Info Center; default is N (No) |