| 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 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | CAJO_NUMBER | Cash Journal Number | nvarchar | 4 | 0 | CHAR | (N' ') | No | TCJ_C_JOURNALS | CJNR | Allow NULL? |
| 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | POSTING_NUMBER | Cash Journal Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | TCJ_DOCUMENTS | CJBELNR | Allow NULL? |
| 6 | POSITION_NUMBER | Number of Line Item within Cash Journal Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CJBUZEI | Allow NULL? |
| 7 | WTAXTYPE | Indicator for withholding tax type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T059P | WITHT | Allow NULL? |
| 8 | STATUS | Status of withholding tax items for cash journal doc. item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CJWT_ITEM_STATUS | Allow NULL? |
| 9 | VENDOR_NO | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFB1 | LIFNR | Allow NULL? |
| 10 | WT_KEY | Grouping key for withholding tax information | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | WT_KEY | Allow NULL? |
| 11 | WITHT | Indicator for withholding tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WITHT | Allow NULL? |
| 12 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WT_WITHCD | Allow NULL? |
| 13 | WT_QSSHH | Withholding tax base amount (local currency) | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS | |
| 14 | WT_QSSHB | Withholding tax base amount in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS1 | |
| 15 | WT_QSSH2 | Withholding tax base amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS2 | |
| 16 | WT_QSSH3 | Withholding tax base amount in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_BS3 | |
| 17 | WT_QBUIHH | Enter withholding tax amount in local currency manually | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_QBUIHH | |
| 18 | WT_QBUIHB | Enter withholding tax amount in document currency manually | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_QBUIHB | |
| 19 | WT_QBUIH2 | Manually entered with/tax amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_QBUIH2 | |
| 20 | WT_QBUIH3 | With/tax amount in 3rd local currency entered manually | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_QBUIH3 | |
| 21 | WT_WDMBTR | Withholding tax amount (in local currency) already withheld | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_AWT | |
| 22 | WT_WWRBTR | Withholding tax amount already withheld in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_AWT1 | |
| 23 | WT_WDMBT2 | Withholding tax amount already withheld in 2nd local curr. | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_AWT2 | |
| 24 | WT_WDMBT3 | With/tax amount already withheld in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_AWT3 | |
| 25 | WT_BASMAN | Indicator: Withholding tax base amount entered manually | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_BASMAN | Allow NULL? |
| 26 | WT_AMNMAN | Indicator: Withholding tax amount entered manually | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_AMNMAN | Allow NULL? |
| 27 | WT_QBSHH | Withholding tax amount (in local currency) | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT | |
| 28 | WT_QBSHB | Withholding tax amount in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT1 | |
| 29 | WT_QBSH2 | Withholding tax amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT2 | |
| 30 | WT_QBSH3 | Withholding tax amount in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WT3 | |
| 31 | WT_QBSHHA | W/tax auxiliary amount for reversal (in local currency) | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WTA | |
| 32 | WT_QBSHHB | W/tax auxiliary amount 2 in local currency for reversal | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_WTB | |
| 33 | WT_STAT | Line item status | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_STAT | Allow NULL? |
| 34 | WT_QSFHH | Amount exempt from withholding tax in local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_EXMP | |
| 35 | WT_QSFHB | Amount exempt from withholding tax in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_EXMP1 | |
| 36 | WT_QSFH2 | Withholding tax exempt amount in 2nd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_EXMP2 | |
| 37 | WT_QSFH3 | Withholding tax exempt amount in 3rd local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WT_EXMP3 | |
| 38 | WT_WTEXMN | Exemption certificate number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | WT_EXNR | Allow NULL? |
| 39 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOART | Allow NULL? |
| 40 | WT_ACCO | Vendor/customer account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WT_ACNO | Allow NULL? |
| 41 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 42 | HKONT_OPP | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 43 | QSREC | Type of recipient | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WT_QSREC | Allow NULL? |
| 44 | AUGBL | Document Number of the Clearing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AUGBL | Allow NULL? |
| 45 | AUGDT | Clearing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGDT | Allow NULL? |
| 46 | WT_QSZRT | Exemption rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | WT_EXRT | |
| 47 | TEXT15 | Text (15 characters) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TEXT15 | Allow NULL? |
| 48 | QSATZ | Withholding tax rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | WT_QSATZ | |
| 49 | WT_SLFWTPD | Indicator: Entry posted as self-withholding tax | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_SLFWTPD | Allow NULL? |
| 50 | WT_GRUWTPD | Indicator: Entry posted as "Grossing up" | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_GRUWTPD | Allow NULL? |
| 51 | WT_OPOWTPD | Indicator: Entry posted as a debit/credit | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_OPOWTPD | Allow NULL? |
| 52 | WT_GIVENPD | Indicator: Withholding tax amount entered manually with pmnt | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_GIVENPD | Allow NULL? |
| 53 | CTNUMBER | Withholding Tax Certificate Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CTNUMBER | Allow NULL? |
| 54 | WT_DOWNC | Indicator: Entry belongs to a down payment clearing item | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_DOWNC | Allow NULL? |
| 55 | WT_RESITEM | Indicator: Entry belongs to a residual item | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_RESITEM | Allow NULL? |
| 56 | CTISSUEDATE | Issue or Print Date of Withholding Tax Certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CTISSUEDATE | Allow NULL? |
| 57 | WT_CALC | Withholding Tax Already Calculated/Determined? | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WT_CALC | Allow NULL? |
| 58 | WT_LOGSYS | Logical System in Which the Withholding Tax Was Calculated | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WT_LOGSYS | Allow NULL? |
