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 Split Billing file.

Tabs3 Split Billing File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
MAIN_CLIENT_ID Main Client ID  
MAIN_RECORD_SW Main Record Switch

M=Main

S=Split
SPLIT_CLIENT_ID Split Fee Client ID  
FEE_PERCENT % of Fees  
EXPENSE_PERCENT % of Expenses  
ADVANCE_PERCENT % of Advances  
FEE_REMAINDER Remainder of Fees Switch 0=unchecked, 1 = checked
EXPENSE_REMAINDER Remainder of Expenses Switch 0=unchecked, 1 = checked
ADVANCE_REMAINDER Remainder of Advances Switch 0=unchecked, 1 = checked
PRE_SPLIT_ON_STMTS *  
STMT_SPLIT_SUMMARY *  
SPLIT_SUMMARY_TYPE *  

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