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 Cost Rate file.

Tabs3 Billing Cost Rate File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID  
SHARED_SWITCH Shared Switch 0=unchecked, 1=checked
SHARED_CLIENT_ID Shared Client ID  
FIRST_RECORD First Switch 0=false, 1=true
TCODE Transaction Code  
ACTIVITY Activity Code  
RATE Rate  
NEW_RATE New Rate  
COST_DATE Effective Date of New Rate  
BILLABLE Billable