|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Target Group Business Partner
Table Name: OTBP
Table Description: Target Group Business Partner
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CardCode | BP Code | nVarChar | 15 | - | Â | Â | Â |
| CardName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| CntctPrsn | Contact Person | nVarChar | 90 | - | Â | Â | Â |
| Title | Title | nVarChar | 10 | - | Â | Â | Â |
| Position | Position | nVarChar | 90 | - | Â | Â | Â |
| E_Mail | nVarChar | 100 | - | Â | Â | Â | |
| Telephone | Telephone | nVarChar | 50 | - | Â | Â | Â |
| Cellolar | Mobile Phone | nVarChar | 50 | - | Â | Â | Â |
| Fax | Fax | nVarChar | 50 | - | Â | Â | Â |
| Address | Address | nVarChar | 254 | - | Â | Â | Â |
| Street | Street/PO Box | nVarChar | 100 | - | Â | Â | Â |
| Block | Block | nVarChar | 100 | - | Â | Â | Â |
| City | City | nVarChar | 100 | - | Â | Â | Â |
| ZipCode | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| County | County | nVarChar | 100 | - | Â | Â | Â |
| Building | Building/Floor/Room | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CardCode |