| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CpnNo | Campaign No. | Int | 11 | OCPN | |||
| CpnLineNum | Campaign Line Number | Int | 11 | - | |||
| BpCode | BP Code | nVarChar | 15 | OCRD | |||
| BpName | BP Name | nVarChar | 200 | - | |||
| GroupName | BP Group Name | nVarChar | 100 | - | |||
| Industry | BP Industry Name | nVarChar | 40 | - | |||
| Status | BP Status | VarChar | 1 | - | A | Active | |
| I | Inactive | ||||||
| CntCode | Contact Code | nVarChar | 50 | - | |||
| CntTitle | Contact Title | nVarChar | 10 | - | |||
| CntPstn | Contact Position | nVarChar | 90 | - | |||
| CntEmail | Contact E-Mail | nVarChar | 100 | - | |||
| CntTel | Contact Telephone | nVarChar | 50 | - | |||
| CntMobile | Contact Mobile | nVarChar | 50 | - | |||
| CntFax | Contact Fax | nVarChar | 50 | - | |||
| CntAddr | Contact Address | nVarChar | 254 | - | |||
| Response | Response from Company | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| OpprId | Related Opportunity | Int | 11 | OOPR | |||
| LogIns | Log Instance - History | Int | 11 | - | |||
| VisOrder | Visual Order | Int | 11 | - | |||
| Street | Street | nVarChar | 100 | - | |||
| Block | Block | nVarChar | 100 | - | |||
| City | City | nVarChar | 100 | - | |||
| ZipCode | Zip Code | nVarChar | 100 | - | |||
| County | County | nVarChar | 100 | - | |||
| State | State | nVarChar | 3 | OCST | |||
| Country | Country/Region | nVarChar | 3 | OCRY | |||
| Building | Building/Floor/Room | Text | 16 | - | |||
| CActivity | Create Activity [Y/N] | VarChar | 1 | - | Y | ||
| DocType | Document Type | nVarChar | 20 | - | -1 | -1 | |
| 97 | Sales Opportunities | ||||||
| 23 | Sales Quotations | ||||||
| 17 | Sales Orders | ||||||
| 15 | Deliveries | ||||||
| 13 | A/R Invoices | ||||||
| -97 | Purchase Opportunities | ||||||
| 540000006 | Purchase Quotations | ||||||
| 22 | Purchase Orders | ||||||
| 20 | Goods Receipt POs | ||||||
| 18 | A/P Invoices | ||||||
| ShowBPDoc | Show BP Documents [Y/N] | VarChar | 1 | - | N | ||
| DocNumber | Related Document | Int | 11 | - | |||
| DocEntry | Document Entry | Int | 11 | - | |||
| AssignTo | Assign to User or Employee | VarChar | 1 | - | U | U | User |
| E | Employee | ||||||
| AssignName | User or Employee Name | Int | 11 | - | |||
| FirstName | First Name | nVarChar | 50 | - | |||
| MiddleName | Middle Name | nVarChar | 50 | - | |||
| LastName | Last Name | nVarChar | 50 | - | |||
| LicTradNum | Federal Tax ID | nVarChar | 32 | - | |||
| AddrType | Address Type | nVarChar | 100 | - | |||
| Address2 | Address Name 2 | nVarChar | 50 | - | |||
| Address3 | Address Name 3 | nVarChar | 50 | - | |||
| StreetNo | Street No. | nVarChar | 100 | - | |||
| AddressID | Address ID | nVarChar | 50 | - | |||
| RspType | Response Type | nVarChar | 20 | ORPT | |||
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| D | Erased | ||||||
| B | Blocked | ||||||
| U | Unblocked | ||||||
| EncryptIV | Encrypt IV | nVarChar | 100 | - | |||
| Key | Unique | Field |
| PRIMARY | Yes | CpnNo |
| CpnLineNum |