| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPLease Accounting |
| 1 | TFILA_GF_003M | For Later Use of Value IDs for Retrieval | 6 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 2 | TFILA_GF_003R | Value IDs Referenced from Method | 8 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 3 | TFILA_GF_004 | Assignment Value ID -> Accrual Method | 6 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 4 | TFILA_GF_004CF | Assignment of Payment Schedule for Accrual Postings | 6 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 5 | TFILA_GF_005 | Specifications for One-Time Postings per Value ID | 6 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 6 | TFILA_GF_009 | Assignment of Value IDs to Structure Field | 7 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 7 | TFILA_GF_009V | Mapping Table for Structure Fields in Value IDs | 7 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 8 | TFILA_GF_020S | Assign Value IDs for Determining Residual Value | 4 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| 9 | TFILA_GF_020T | Fill New Residual Values in Conditions | 4 | ACCKEY | Classification Key | nvarchar | 8 | 0 | | |
| TOPTransaction Tax Engine |
| 10 | TTE2C_RETLVL | Jurisdiction Level | 6 | ACCKEY | Account Determination Key | nvarchar | 3 | 0 | | |
| 11 | TTEC_ACCKEY | Accounting Key | 2 | ACCKEY | Account Determination Key | nvarchar | 3 | 0 | | |
| 12 | TTEC_ACCKEY_T | Accounting Key | 3 | ACCKEY | Account Determination Key | nvarchar | 3 | 0 | | |
| 13 | TTEC_TAXCODE_3 | Assign TTE Entities to Tax Code | 9 | ACCKEY | Account Determination Key | nvarchar | 3 | 0 | | |
| 14 | TTEM_ACCKEY | Mapping: Account Determination Key | 5 | ACCKEY | Account Determination Key | nvarchar | 3 | 0 | | |
