|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Withholding Tax Definition
Table Name: OWTD
Table Description: Withholding Tax Definition
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| WTCode | WTax Code | nVarChar | 4 | - | Â | Â | Â |
| WTName | WTax Code Name | nVarChar | 50 | - | Â | Â | Â |
| Rate | Rate | Num | 19.6 | - | Â | Â | Â |
| EffecDate | Effective From | Date | 8 | - | Â | Â | Â |
| Inactive | Inactive | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| OffclCode | Official Code | nVarChar | 15 | - | Â | Â | Â |
| Category | Category | VarChar | 1 | - | P | I | Invoice |
| Â | Â | Â | Â | Â | Â | P | Payment |
| BaseType | Base Type | VarChar | 1 | - | N | N | Net |
| Â | Â | Â | Â | Â | Â | V | VAT |
| Â | Â | Â | Â | Â | Â | G | Gross |
| Â | Â | Â | Â | Â | Â | H | Gross - VAT |
| WTTypeId | Type | Int | 11 | OWTT | Â | Â | Â |
| BaseMin | Min. Amount | Num | 19.6 | - | Â | Â | Â |
| PrctBsAmnt | % Base Amount | Num | 19.6 | - | Â | Â | Â |
| FmlId | Formula ID | Int | 11 | OFML | Â | Â | Â |
| Account | Account | nVarChar | 15 | OACT | Â | Â | Â |
| SlScProgr | Sliding Scale Progressive Tax | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| CalcWHTCrM | Calculate Withholding Tax in Automatic Credit Memo | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| WT_CODE | Yes | WTCode |
| WT_NAME | No | WTName |