| 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 | TAXAU | Tax authority | nvarchar | 4 | 0 | CHAR | (N' ') | No | | TAXAT | Allow NULL? |
| 3 | STATE | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005S | REGIO | Allow NULL? |
| 4 | TAXLV | Tax level | char | 1 | 0 | CHAR | (N' ') | No | | TXLEV | Allow NULL? |
| 5 | CONTY | Text length 25 | nvarchar | 25 | 0 | CHAR | (N' ') | No | | TEXT25 | Allow NULL? |
| 6 | LTEXT | Description | nvarchar | 30 | 0 | CHAR | (N' ') | No | | DESC30 | Allow NULL? |
| 7 | SRTNO | Sort number for tax authorities | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | SRTNO | Allow NULL? |
| 8 | W4IND | W-4 indicator | char | 1 | 0 | CHAR | (N' ') | No | | W4IND | Allow NULL? |
| 9 | IRSID | IRS limit ID | char | 1 | 0 | CHAR | (N' ') | No | | IRSID | Allow NULL? |
| 10 | NONUS | Territory indicator | char | 1 | 0 | CHAR | (N' ') | No | | NONUS | Allow NULL? |
| 11 | DEFAW | Default number of allowances | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PB10_DEFAW | Allow NULL? |
| 12 | DEFMS | Default filing status | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | PB10_DEFMS | Allow NULL? |
| 13 | AWLMT | Number of allowances limit | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PB10_AWLMT | Allow NULL? |
| 14 | AWFED | Allowance not greater than Federal | char | 1 | 0 | CHAR | (N' ') | No | | PB10_AWFED | Allow NULL? |
| 15 | AAPBT | Additional Amount Prohibited | char | 1 | 0 | CHAR | (N' ') | No | | PB10_AAPBT | Allow NULL? |
| 16 | TEPBT | Tax exemption prohibited | char | 1 | 0 | CHAR | (N' ') | No | | PB10_TEPBT | Allow NULL? |
| 17 | EXMEM | Exemption expiration month | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PB10_EXMEM | Allow NULL? |
| 18 | EXMED | Exemption expiration day | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PB10_EXMED | Allow NULL? |
| 19 | RFBEGDA | Reciprocal Formula Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RFBEGDA | Allow NULL? |
| 20 | RFENDDA | Reciprocal Formula End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RFENDDA | Allow NULL? |