| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T169E | Tolerance Limit Keys | 1 | TOLSL | Tolerance key | nvarchar | 2 | 0 | | |
2 | T169G | Tolerance Limits, Invoice Verification | 3 | TOLSL | Tolerance key | nvarchar | 2 | 0 | | |
3 | T169S | Tolerance Limit Keys | 2 | TOLSL | Tolerance key | nvarchar | 2 | 0 | | |
4 | T169T | Text Table for Tolerance Limits | 4 | TOLSL | Tolerance key | nvarchar | 2 | 0 | | |
TOPFunds Management |
5 | FMFGTOLDCTYP | Document types for US Federal MM tolerances | 3 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | | |
6 | FMR_TOL | Tolerance Limits for Earmarked Funds | 2 | TOLSL | Tolerance Key for Overrun Tolerance | nvarchar | 4 | 0 | | |
7 | FMR_TOLS | Tolerance Key for Overrun Tolerance | 2 | TOLSL | Tolerance Key for Overrun Tolerance | nvarchar | 4 | 0 | | |
8 | FMR_TOLST | Tolerance Key for Overrun Tolerance: Texts | 2 | TOLSL | Tolerance Key for Overrun Tolerance | nvarchar | 4 | 0 | | |
9 | TKBBA | Document Types | 15 | TOLSL | Tolerance Key for Overrun Tolerance | nvarchar | 4 | 0 | | |
10 | TME_TOL | Overdraw tolerance for Purchase Order / Requisition | 2 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | | |
11 | TME_TOLS | Tolerance Key for overdraw tolerance | 2 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | | |
12 | TME_TOLST | Tolerance Key for overdraw tolerance TEXT | 2 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | | |
TOPNon-Ferrous Metal enhancements |
13 | /NFM/TTOL | NF Metal Settings for Invoice Verification | 3 | TOLSL | Tolerance key | nvarchar | 2 | 0 | | |
TOPPurchasing |
14 | T161 | Purchasing Document Types | 45 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | | |