| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | YIT_DATATYPES | Infobase: Application Data Types | 1 | DATYP | Infobase: Application Data Types | nvarchar | 3 | 0 | | |
| 2 | YIT_DATATYPESL | Infobase: Application Data Types | 1 | DATYP | Infobase: Application Data Types | nvarchar | 3 | 0 | | |
| 3 | YIT_DATYP | IDA: Application Data Types | 1 | DATYP | IDA: Type of data (material,costcenter,standardnet,..) | nvarchar | 3 | 0 | | |
| 4 | YIT_DATYPL | IDA: Data Types | 1 | DATYP | IDA: Type of data (material,costcenter,standardnet,..) | nvarchar | 3 | 0 | | |
| 5 | YIT_INFOBASE_XD | IDES Infobase: Application Data Assignments | 3 | DATYP | Infobase: Application Data Types | nvarchar | 3 | 0 | | |
| 6 | YIT_PROT | IDA: Change log | 2 | DATYP | IDA: Type of data (material,costcenter,standardnet,..) | nvarchar | 3 | 0 | | |
| 7 | YIT_STATU | IDA: Status | 3 | DATYP | IDA: Type of data (material,costcenter,standardnet,..) | nvarchar | 3 | 0 | | |
| TOPAllocation |
| 8 | T620 | Allocation Table Document Types | 13 | DATYP | External date type | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 9 | T035 | Planning groups | 3 | DATYP | Cash Management: Control Planning Date for Planning Groups | nvarchar | 2 | 0 | | |
| TOPCompensation Management |
| 10 | T71C5 | Eligibility Rule for Compensation | 11 | DATYP | Date type | nvarchar | 2 | 0 | | |
| TOPLoans Management |
| 11 | VDSTAT | Status table for loan CATT procedures | 7 | DATYP | Loan category | nvarchar | 2 | 0 | | |
| TOPPayroll |
| 12 | T5T4D | Configuration of parameters of reports | 6 | DATYP | Data type for parameter of HR report | nvarchar | 1 | 0 | | |
| 13 | T7RO4D | Reporting engine - Parameters | 6 | DATYP | Data type for parameter of HR report | nvarchar | 1 | 0 | | |
| 14 | T7SI4D | Configuration of parameters of reports | 6 | DATYP | Data type for parameter of HR report | nvarchar | 1 | 0 | | |
| 15 | T7SK4D | Configuration of parameters of reports | 6 | DATYP | Data type for parameter of HR report | nvarchar | 1 | 0 | | |
| TOPPortugal |
| 16 | T5PV1 | HR-PT: Assignment of quota type selection rule group | 10 | DATYP | Date type for deduction start date (created in IT0019) | nvarchar | 2 | 0 | | |
| TOPWarehouse Management |
| 17 | T328 | Warehouse Activity Monitor: Defin. of Critical Parameters | 10 | DATYP | Date reference in reference document | nvarchar | 1 | 0 | | |
