| ODBC File List |
The following Tabs3 Billing data files are accessible via an ODBC driver and are included in the data dictionary file created by the Initialize Tabs3 ODBC program:
| CLIENT | Client file includes client related information. |
| CONTACT | Contact file includes contact related information. |
| FEE | Fee file includes all fee transactions. |
| COST | Cost file includes all cost transactions. |
| PAYMENT | Payment file includes all payment transactions. |
| FUND | Client Funds file includes all client funds transactions. |
| LEDGER | Client ledger file includes all statement and payment client ledger records. |
| ARCHIVE | Archive file includes all billed fee, cost, payment and client funds transactions. |
| APCOSTLINK | APS Cost Integration file. |
| AUTOPAYMENTS | Autopayments file includes automatic payments via Tabs3 Pay®. |
| BILLFREQ | Billing frequency file. |
| BILLTO | Bill To file includes address information regarding the Bill To Address option. |
| CATEGORY | Category file. |
| CLIENTCUSTOM | Custom Fields file. |
| CLIENTNOTE | Client Notes file includes all beginning statement notes, ending statement notes and client notes. |
| CLIENTPORTAL | Client Portal file. |
| CLIENTRATE | Client Rate file includes fee rate information from the client fee rate table. |
| COSTRATE | Cost Rate file includes rate information from the client cost rate table. |
| EMAILTEMPLATE | Email Template file include email statement template information. |
| EMPLOYEE | Employee file includes all timekeeper information (not System Configuration User ID information). |
| EMPLRULE | Fee Compensation Rules. |
| GLACCTMAP | GLS Integration Setup file. |
| LEDGALLOC | Client ledger detail file includes detailed information for write offs, payments and credits. |
| LOCATION | Location file includes location IDs and descriptions. |
| MACRO | Macro file includes text macro IDs and definitions. |
| SECCLT | Secure Client file. |
| SPLITBILLING | Split Billing file includes information regarding main clients, matters and percentages. |
| STMTCODE | Statement Code file includes statement template information. |
| STMTDET | Statement Detail file. |
| STMTDETALLOC | Statement Allocation file. |
| STMTREVCOMMENT | Statement Review Comment file includes Comments added to pre-bills and statements. |
| STMTTRAK | Statement Tracking file includes pre-bill tracking and email statement information. |
| TASKBILLCODE | The Task Bill Code file includes information regarding the various task codes defined. |
| TASKBUDGET | Task Code Budget file. This file includes Task Code budget figures; it does not include client budget figures used in the Client Budget Report. |
| TCODE | Transaction Code file. |
| TRUSTREQUEST | Trust Request file includes requests sent with email statements and manually via the Tabs3 Billing Matter Manager. |