| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | RENTO | Whether house rented out | char | 1 | 0 | | | | Allow NULL? |
| 8 | LETVL | Final lettable value | decimal | 12 | 2 | | | | |
| 9 | SEC23 | Deductions- section 23(municipal taxes+re-constr alowance) | decimal | 9 | 2 | | | | |
| 10 | INT24 | Deduction towards Interest Under Section 24 | decimal | 9 | 2 | | | | |
| 11 | REP24 | Deductions for house repairs under section 24 | decimal | 9 | 2 | | | | |
| 12 | OTH24 | Deductions - 'others' under section 24 | decimal | 9 | 2 | | | | |
| 13 | BSPFT | Profits from business and profession | decimal | 12 | 2 | | | | |
| 14 | CPGLN | Income from long term capital gains(normal rate) | decimal | 12 | 2 | | | | |
| 15 | CPGLS | Income from long term capital gains(special rate) | decimal | 12 | 2 | | | | |
| 16 | CPGNS | Income from short term capital gains | decimal | 12 | 2 | | | | |
| 17 | DVDND | Income from dividends | decimal | 9 | 2 | | | | |
| 18 | INTRS | Income from interest ( from fixed deposits etc ) | decimal | 9 | 2 | | | | |
| 19 | UNSPI | Income from other sources | decimal | 12 | 2 | | | | |
| 20 | TDSOT | Tax deducted at source for income other than salary | decimal | 9 | 2 | | | | |
| 21 | WAEHI | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | INTYP | Income Type From Other Sources | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | DLART | Loan type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | DLARN | Loan Sequence No | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | LSPER | Dedn. Int. Start Accounting Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | LEPER | Dedn. Int. End Accounting Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | LLMIT | Section 24 Deduction Interest Limit | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | CPGSS | Income from short term capital gains(Listed Sec) | decimal | 13 | 2 | | | | |
| 29 | TDSAT | Tax deducted at source for income other than salary | decimal | 13 | 2 | | | | |
