|
|
SAP Business One SDK 10.0 - Database Tables Reference |
WTax Certificates
Table Name: OWTC
Table Description: WTax Certificates
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| RctType | Object Type | nVarChar | 20 | - | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payment |
| RctAbs | Receipt No. | Int | 11 | - | Â | Â | Â |
| Jurisdict | Jurisdiction | nVarChar | 2 | - | Â | Â | Â |
| WtaxType | WTax Type | nVarChar | 2 | - | Â | -- | WTax Certificate |
| Â | Â | Â | Â | Â | Â | OV | Outgoing VAT - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OG | Outgoing Gross Income - Withholding Tax |
| Â | Â | Â | Â | Â | Â | ON | Outgoing Income - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OS | Outgoing Social Security - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OI | Outgoing Industry Specific - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OD | Outgoing District Specific - Withholding Tax |
| Â | Â | Â | Â | Â | Â | IC | Incoming WTax Certificate |
| WtAbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| CerSeries | WTax Certificate Series | Int | 11 | - | Â | Â | Â |
| Number | Number | Int | 11 | - | Â | Â | Â |
| RefNumber | Reference Number | nVarChar | 20 | - | Â | Â | Â |
| SumVatAmnt | Sum of VAT Amount | Num | 19.6 | - | Â | Â | Â |
| SumDocTot | Sum of Doc. Total Amount | Num | 19.6 | - | Â | Â | Â |
| SumBaseAmn | Sum of Base Amount | Num | 19.6 | - | Â | Â | Â |
| SumAccumAm | Sum of Accumulated Amount | Num | 19.6 | - | Â | Â | Â |
| SumPercpAm | Sum of Perception Amount | Num | 19.6 | - | Â | Â | Â |
| PTICode | POI Code | nVarChar | 5 | - | Â | Â | Â |
| Handwrtten | Manual Numbering | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PIndicator | Period Indicator | nVarChar | 10 | - | ' ' | Â | Â |
| PTICodeRef | POI Code Reference | nVarChar | 20 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |