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