| 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 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | LAND1 | Allow NULL? |
| 3 | WITHT | Indicator for withholding tax type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WITHT | Allow NULL? |
| 4 | WT_TPNR | Sequential number of a withholding tax type | nvarchar | 3 | 0 | NUMC | (N'000') | No | | WT_TPNR | Allow NULL? |
| 5 | WT_ACCPT | Accumulation period | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_ACCPT | Allow NULL? |
| 6 | WT_ACCALL | Indicator: Accum. several cust./vend. and CoCdes together? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_ACCALL | Allow NULL? |
| 7 | WT_ACCTMAX | Indicator: Withhold accumulated withholding tax to maximum? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_ACCTMAX | Allow NULL? |
| 8 | WT_WTRD | Rounding Rule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WT_WTRD | Allow NULL? |
| 9 | WT_CEINV | Central invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_CEINV | Allow NULL? |
| 10 | WT_BASE | Type of withholding tax base amount | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_BASE | Allow NULL? |
| 11 | WT_DOPOST | Post withholding tax amount | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_DOPOST | Allow NULL? |
| 12 | WT_POSTM | Posting time | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_POSTM | Allow NULL? |
| 13 | WT_ALWT | Indicator: Withholding tax already withheld? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_ALWT | Allow NULL? |
| 14 | WT_WTDSC | Indicator: Calculate w/tax prior to cash discount deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_WTDSC | Allow NULL? |
| 15 | WT_SLFWT | Self-withholding possible? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_SLFWT | Allow NULL? |
| 16 | WT_WTDP | Withholding tax type number on which this w/tax type depends | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WT_WTDP | Allow NULL? |
| 17 | WT_MANUAL | Indicator: Allow manual entry of withholding tax amount | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_MANUAL | Allow NULL? |
| 18 | WT_MAINTB | Maintenance of minimum base amount | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_MAINTB | Allow NULL? |
| 19 | WT_MAINTA | Maintenance of minimum/maximum withholding tax amount | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_MAINTA | Allow NULL? |
| 20 | WT_REDBAS | Indicator: Reduce base amount by withholding tax amount? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_REDBAS | Allow NULL? |
| 21 | WT_WTINV | Indicator: Enter w/tax amount manually for payments? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_WTINV | Allow NULL? |
| 22 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 23 | TDFORM | Form Name | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TDFORM | Allow NULL? |
| 24 | WT_BCPLVL | Minimum Check at Document Level | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_BCPLVL | Allow NULL? |
| 25 | WT_CTNBRL | Indicator: Type not relevant for certificate numbering? | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_CTNBRL | Allow NULL? |
| 26 | WT_MANBAS | Indicator: Allow manual entry of withholding tax base amnt | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_MANBAS | Allow NULL? |
| 27 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685A | KSCHL | Allow NULL? |
| 28 | J_1BSUMVAL | Transfer to Nota Fiscal | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BSUMVAL | Allow NULL? |
| 29 | J_1BTEXKEY | MM: Text key for automatic text determination | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BMMNFTT | J_1BTEXKEY | Allow NULL? |
| 30 | WT_KURST | Ex.Rate Type for Determining Ex.Rate for W/holding Tax Calc. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | WT_KURST | Allow NULL? |
| 31 | WT_INHERITBASE | Indicator: Base Amount Equals Amount of Other Type | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_INHERITBASE | Allow NULL? |
| 32 | WT_NOREDUCTION | Indicator: Vendor Line Item Not Reduced by W/holding Tax Amt | char | 1 | 0 | CHAR | (N' ') | Yes | | WT_NOREDUCTION | Allow NULL? |
| 33 | J_1AFORMAT | Certificate Format | char | 1 | 0 | CHAR | (N' ') | Yes | | TYP_FORMAT | Allow NULL? |
| 34 | KSCHL_TX | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KSCHL | Allow NULL? |
| 35 | J_1BWHTBASE_NF | Origin of Real Withholding Tax Calculation Base | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BWHTBASE_NF | Allow NULL? |
| 36 | ALL_TAX_CODES | Consider All Tax Codes | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1A_ALL_TAX_CODES | Allow NULL? |
