| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | KODFU | Tax Office Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | XACTGJAHR | | char | 1 | 0 | | | | Allow NULL? |
| 6 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | X54_O | Total land tax - till 2008 | decimal | 11 | 2 | | | | |
| 8 | X54 | Total Amount of Land Tax | decimal | 11 | 2 | | | | |
| 9 | X54_B | Total Amount of Land Tax | decimal | 11 | 2 | | | | |
| 10 | X55_O | Total building tax - till 2008 | decimal | 11 | 2 | | | | |
| 11 | X55 | Total Amount of Building Tax | decimal | 11 | 2 | | | | |
| 12 | X55_B | Total Amount of Building Tax | decimal | 11 | 2 | | | | |
| 13 | X56_O | Total property tax - till 2008 | decimal | 11 | 2 | | | | |
| 14 | X56 | Total Amount of Property Tax | decimal | 11 | 2 | | | | |
| 15 | X56_B | Total Amount of Property Tax | decimal | 11 | 2 | | | | |
| 16 | XKO12 | Municipality Coefficient (Par. 12) | tinyint | 3 | 0 | | | | |
| 17 | X58_1 | Installment 1 | decimal | 11 | 2 | | | | |
| 18 | X58_2 | Installment 2 | decimal | 11 | 2 | | | | |
| 19 | X59_1 | Installment 1 | decimal | 11 | 2 | | | | |
| 20 | X59_2 | Installment 2 | decimal | 11 | 2 | | | | |
| 21 | X59_3 | Installment 3 | decimal | 11 | 2 | | | | |
| 22 | X59_4 | Installment 4 | decimal | 11 | 2 | | | | |
| 23 | DATVYPOCTU | Calculation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | CASVYPOCTU | Calculation Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | STAVYPOCTU | Calculation status | char | 1 | 0 | | | | Allow NULL? |
| 26 | STAVVYPOCTU_OP | Calculation status | char | 1 | 0 | | | | Allow NULL? |
| 27 | STAVVYPOCTU_DO | Calculation status | char | 1 | 0 | | | | Allow NULL? |
| 28 | USERVYPOCTU | Calculation Executed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 29 | LOG_HNDL | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
| 30 | BLOCKVYPOCTU | Flag whether blocking tax calculation | char | 1 | 0 | | | | Allow NULL? |
| 31 | ZMENAKMEN | | char | 1 | 0 | | | | Allow NULL? |
| 32 | DATZMENYKMEN | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | CASZMENYKMEN | Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | USERZMENYKMEN | Changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 35 | PRIZNANI | | char | 1 | 0 | | | | Allow NULL? |
| 36 | DATPRIZNANI | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | CASPRIZNANI | Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | USERPRIZNANI | Changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 39 | ZJIST_TEXT | | nvarchar | 100 | 0 | | | | Allow NULL? |
| 40 | ZJIST_DATE | | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | OPR_PRIJMENI | Last Name | nvarchar | 36 | 0 | | | | Allow NULL? |
| 42 | OPR_JMENO | First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 43 | OPR_TITUL | Title | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | OPR_TELEF | Phone Number | nvarchar | 14 | 0 | | | | Allow NULL? |
| 45 | OPR_EMAIL | E-Mail Address | nvarchar | 50 | 0 | | | | Allow NULL? |
| 46 | OPR_TYP | Code of Representative | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | OPR_SET | Use Data of Representative | char | 1 | 0 | | | | Allow NULL? |
| 48 | OPR_POSTAVENI | Relationship with Taxpayer | nvarchar | 20 | 0 | | | | Allow NULL? |
| 49 | MBUKR | Indicator: Dominant Company Code | char | 1 | 0 | | | | Allow NULL? |
| 50 | SEST_PRIJMENI | Last Name | nvarchar | 36 | 0 | | | | Allow NULL? |
| 51 | SEST_JMENO | First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 52 | SEST_TITUL | Title | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | SEST_TELEF | Phone Number | nvarchar | 14 | 0 | | | | Allow NULL? |
| 54 | SEST_EMAIL | E-Mail Address | nvarchar | 50 | 0 | | | | Allow NULL? |
| 55 | SEST_UMRTI | Date of Death | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | ZAST_DAT_NAR | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 57 | ZAST_EV_CISLO | Registration Number | nvarchar | 36 | 0 | | | | Allow NULL? |
| 58 | ZAST_JMENO | Representative: First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 59 | ZAST_PRIJMENI | Representative: Last Name | nvarchar | 36 | 0 | | | | Allow NULL? |
| 60 | ZAST_IC | ICO Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 61 | ZAST_TYP | Type of Representative | char | 1 | 0 | | | | Allow NULL? |