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 Statement Detail file.

Tabs3 Statement Detail File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID Number  
LEDGER_REF_NUM *  
RECORD_TYPE *  
AMOUNT Amount Billed  
AMOUNT_DUE Amount Due  
BILLED_HOURS Hours Billed  
WORKED_HOURS Hours Worked  
WORKED_VALUE Worked Value  

 

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