Data Access - This file and its fields are accessible via the Tabs3 ODBC driver.

 

Platinum SQL

Assign SQL Access Rights

   

R11943 - Accessing the Platinum SQL Database via ODBC

 

Legacy ODBC

Initialize Tabs3 Billing ODBC

   

R10017 - Working with ODBC

The following is a list of fields found in the Fee Compensation Rules file.

Tabs3 Fee Compensation Rules File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID  
SHARED_CLIENT_ID Shared Table Client ID  
FIRST_RECORD *  
FIRM_RULE_SW Firm 0=unselected, 1=selected
TIMEKEEPER Timekeeper Number  
TK_DESIGNATOR Timekeeper Type

P=primary

S=secondary

O=originating
ALLOCATION_PERC Receipt %  
EFFECTIVE_DATE Beginning Date  
END_RULE_DATE Ending Date  
BEG_ALLOCATION_AMT From Amount  
END_ALLOCATION_AMT To Amount  
ALLOCATION_TK Taken From  

 

* Indicates the field is not applicable for ODBC applications. This field is used for internal processing only.