|
|
SAP Business One SDK 10.0 - Database Tables Reference |
WTax Codes Details for BP
Table Name: WTD3
Table Description: WTax Codes Details for BP
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OWTD | Â | Â | Â |
| LineId | Row Number | Int | 11 | - | Â | Â | Â |
| WTCode | WTax Code | nVarChar | 4 | - | Â | Â | Â |
| KeyPart1 | BP Key Part 1 | nVarChar | 15 | - | Â | Â | Â |
| KeyPart2 | BP Key Part 2 | nVarChar | 15 | - | Â | Â | Â |
| DateFrom | Effective Date From | Date | 8 | - | Â | Â | Â |
| DateTo | Effective Date To | Date | 8 | - | Â | Â | Â |
| Rate | Currency Rate | Num | 19.6 | - | Â | Â | Â |
| DetailType | Type of Detailed Information | nVarChar | 2 | - | Â | A | Allowed |
| Â | Â | Â | Â | Â | Â | S | Special Rate |
| Â | Â | Â | Â | Â | Â | E | Exemption |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | U | UI Reproweb Autocomplete |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineId |
| BP | Yes | WTCode |
| Â | Â | KeyPart1 |
| Â | Â | KeyPart2 |
| Â | Â | DateFrom |
| Â | Â | DetailType |