| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T021 | Fields for Line Item and Document Line Layout | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| 2 | TKSBS | Fields for Line Structure | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| TOPAccount Determination |
| 3 | T180S | Reporting: Display Variants: Fields | 7 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| TOPBasic Functions |
| 4 | T857A | Column layout of data entry form | 6 | COLUM | Column where data is to be printed | nvarchar | 3 | 0 | | |
| 5 | T862S | Standard reports: Column layout | 5 | COLUM | Column where data is to be printed | nvarchar | 4 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 6 | TFK021 | Line layout variants: Fields | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| 7 | TRM021 | Account Balance: Line-Layout Variant for Display Level 1 | 3 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| 8 | TRM021T | Text Table for TRM021 (Acc Ovw Line Variants Level 1) | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| 9 | TRM022 | Account Balance: Line Layout Variant for Display Level 2 | 3 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| 10 | TRM022T | Text Table for TRM022 (Acc. Ovw Line Variants Level 2) | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| TOPFinancial Accounting |
| 11 | ICRC00_XBLNR_RLS | Balance Sheet Recon.: Rules for Determining Reference Number | 4 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| TOPGeneral Ledger Accounting |
| 12 | FAGL_TCMAP | Customer Fields in Entry Variants for G/L Account Items | 3 | COLUM | Column Number | nvarchar | 2 | 0 | | |
| TOPPayroll |
| 13 | T7BG4B | Forms - field properties | 5 | COLUM | Display in column | nvarchar | 2 | 0 | | |
| TOPPortugal |
| 14 | T5P1P | HR-PT: Table of tax rates | 2 | COLUM | Tax table column | nvarchar | 1 | 0 | | |
| 15 | T5P1R | HR-PT: Tax rates table | 2 | COLUM | Tax table column | nvarchar | 1 | 0 | | |
| 16 | T5P1S | HR-PT: Tax status table | 11 | COLUM | Tax table column | nvarchar | 1 | 0 | | |
