| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | TFK047H | Charges Categories | 2 | CHGTY | Charge Category | nvarchar | 2 | 0 | | |
2 | TFK047HT | Text for dunning charges type | 3 | CHGTY | Charge Category | nvarchar | 2 | 0 | | |
3 | TFK047I | Charges | 4 | CHGTY | Charge Category | nvarchar | 2 | 0 | | |
4 | TFK047K | Charge Categories Per Schedule | 3 | CHGTY | Charge Category | nvarchar | 2 | 0 | | |
5 | TFK062A | Categories for Installment Plan | 7 | CHGTY | Charge Category for Installment Plan Surcharge | nvarchar | 2 | 0 | | |
6 | TFK063A | Charge Categories for Installment Plan Surcharges | 2 | CHGTY | Charge Category for Installment Plan Surcharge | nvarchar | 2 | 0 | | |
7 | TFK063AT | Charge Schema for Installment Plan Surcharges (Text Table) | 3 | CHGTY | Charge Category for Installment Plan Surcharge | nvarchar | 2 | 0 | | |
TOPLease Accounting |
8 | /LSIERP/LATE_FEE | Leasing Late Fee Matrix: Calc. Based on Responsibility Area | 14 | CHGTY | Charge Category | nvarchar | 2 | 0 | | |