| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | DOCID | Document Ledger Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | /OPT/DOCID | Allow NULL? |
| 3 | WITHT | Indicator for withholding tax type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T059P | WITHT | Allow NULL? |
| 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | CHAR | (N' ') | No | T059Z | WT_WITHCD | Allow NULL? |
| 5 | WT_QSSHH | Withholding tax base amount (local currency) | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS | |
| 6 | WT_QSSHB | Withholding tax base amount in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS1 | |
| 7 | WT_QSSH2 | Withholding tax base amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS2 | |
| 8 | WT_QSSH3 | Withholding tax base amount in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS3 | |
| 9 | WT_BASMAN | Indicator: Withholding tax base amount entered manually | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_BASMAN | Allow NULL? |
| 10 | WT_QBSHH | Withholding tax amount (in local currency) | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT | |
| 11 | WT_QBSHB | Withholding tax amount in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT1 | |
| 12 | WT_QBSH2 | Withholding tax amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT2 | |
| 13 | WT_QBSH3 | Withholding tax amount in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT3 | |
| 14 | WT_AMNMAN | Indicator: Withholding tax amount entered manually | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_AMNMAN | Allow NULL? |
| 15 | WT_EXNR | Exemption certificate number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | WT_EXNR | Allow NULL? |
| 16 | WT_EXDF | Date on which exemption begins | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WT_EXDF | Allow NULL? |
| 17 | WT_EXDT | Date on which exemption ends | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WT_EXDT | Allow NULL? |
| 18 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |