| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | TABTY | Taxation table type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | LWLMT | Lower limit of amount | decimal | 9 | 2 | | | | |
| 5 | UPLMT | Upper limit of amount | decimal | 9 | 2 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | AMT0P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 8 | AMT1P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 9 | AMT2P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 10 | AMT3P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 11 | AMT4P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 12 | AMT5P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 13 | AMT6P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 14 | AMT7P | Tax Amount Depend on Number of Dependents: zero | decimal | 9 | 2 | | | | |
| 15 | CTFLG | Control flag for operation | char | 1 | 0 | | | | Allow NULL? |
| 16 | CTAMT | Basis Amount for Calculation | decimal | 9 | 2 | | | | |
| 17 | PRCNT | Rate of additional tax on basis amount | decimal | 5 | 2 | | | | |