|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Import Template
Table Name: OTPL
Table Description: Import Template
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TplNum | Template Number | Int | 11 | - | Â | Â | Â |
| TplName | Template Name | nVarChar | 100 | - | Â | Â | Â |
| TplType | Template Type | nVarChar | 5 | - | Â | T | Target BPs |
| Â | Â | Â | Â | Â | Â | B | BP |
| Â | Â | Â | Â | Â | Â | I | Items |
| Â | Â | Â | Â | Â | Â | F | Fixed Asset |
| Â | Â | Â | Â | Â | Â | WB | WebClient BP |
| Â | Â | Â | Â | Â | Â | WBCP | WebClient BP Contact Person |
| Â | Â | Â | Â | Â | Â | WBAD | WebClient BP Address |
| Â | Â | Â | Â | Â | Â | WBPM | WebClient BP Payment Method |
| Â | Â | Â | Â | Â | Â | WBCA | WebClient BP Control Accounts |
| Â | Â | Â | Â | Â | Â | WJ | WebClient Journal Entry |
| Â | Â | Â | Â | Â | Â | WJE1 | WebClient JE line1 |
| Â | Â | Â | Â | Â | Â | WJE2 | WebClient JE line2 |
| Â | Â | Â | Â | Â | Â | WI | WebClient Items |
| Â | Â | Â | Â | Â | Â | WIP | WebClient Items Prices |
| Â | Â | Â | Â | Â | Â | WIW | WebClient Items Warehouses |
| TplCode | Template Code | nVarChar | 20 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TplNum |
| CODE | Yes | TplCode |
| Â | Â | TplType |