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 Allocation file.

Tabs3 Statement Allocation File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID Number  
MAIN_REF_NUM *  
WIP_SW Work-in-Progress Indicator

0=WIP

1=Billed
ALLOC_TYPE *  
RECORD_TYPE *  
AMOUNT Allocation Amount  
APPLYTO_SEQNO *  
DATE Statement Date  
MANUAL_SW *  
SOURCE_TKPR Timekeeper Number  
DESIGNATOR Timekeeper Type

F=Firm

W=Working

P=Primary

S=Secondary

O=Originating
NET_PAID Net Amount Paid  

 

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