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 Client Ledger file.

Tabs3 Client Ledger File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID  
REFERENCE_NUMBER Reference Number  
RECORD_TYPE Record Type

S=Statement

P=Payment

W=Write Off
DATE Date  
STATEMENT_NUMBER Statement Number  
STATEMENT_ID Sequence Number of statement record is included on  
APPLYTO_STMT_ID Sequence Number of statement record is applied to  
STATEMENT_TYPE *  
PAID_SW    
FEE_AMOUNT_DUE Fees Billed (statement and write off records) Amount Left to Apply (payment record)
FEE_BALANCE Fees Due  
NONBILL_FEES Non-billable Fees  
FEE_WRITEUP Fee Write-Up Amount  
FEE_WRITEDOWN Fee Write-Down Amount  
FEE_TAX_AMOUNT_DUE Fee Tax Billed  
FEE_TAX_BALANCE Fee Tax Due  
FEE_COURTESY_DISCNT Fee Courtesy Discount  
BILLABLE_HOURS Billable Hours  
NONBILLABLE_HOURS Non-billable Hours  
WORKED_BILL_HOURS Worked Billable Hours  
WORKED_NONBILL_HOURS Worked Non-Billable Hours  
FEE_WRITEUP_HOURS Fee Write-Up Hours  
FEE_WRITEDOWN_HOURS Fee Write-Down Hours  
FEE_WUP_HRS_VALUE Fee Write-Up Hours Value  
FEE_WDN_HRS_VALUE Fee Write-Down Hours Value  
EXPENSE_AMOUNT_DUE Expenses Billed  
EXPENSE_BALANCE Expenses Due  
NONBILL_EXPENSES Non-billable Expenses  
EXPENSE_WRITEUP Expense Write-Up  
EXPENSE_WRITEDOWN Expense Write-Down  
EXP_TAX_AMOUNT_DUE Expense Tax Billed  
EXP_TAX_BALANCE Expense Tax Due  
ADVANCE_AMOUNT_DUE Advances Billed  
ADVANCE_BALANCE Advances due  
NONBILL_ADVANCES Non-billable Advances  
ADVANCE_WRITEUP Advance Write-Up  
ADVANCE_WRITEDOWN Advance Write-Down  
ADV_TAX_AMOUNT_DUE Advance Tax Billed  
ADV_TAX_BALANCE Advance Tax Due  
FINCHG_AMOUNT_DUE Finance Charge Billed  
FINCHG_BALANCE Finance Charge Due  
TOTAL_BALANCE Balance Due  
PAYMENT_TYPE Payment Type

R=Regular

F=Fee

E=Expense

A=Advance
PAYMENT_AMOUNT Payment Amount  
PAYMENT_LEFT Payment Amount Unapplied  
REFUND_AMOUNT Refund Amount  
UNAPPLIED_REFUND_AMT Refund Amount Unapplied  
PYMT_LINK Sequence Number of Payment Ledger record in Work-in-Process  
FUND_SW *  
FEE_AMOUNT Amount of Fees  
EXPENSE_AMOUNT Expenses  
ADVANCE_AMOUNT Advances  
FEE_TAX_AMOUNT Fee Tax Amount  
EXP_TAX_AMOUNT Expense Tax Amount  
ADV_TAX_AMOUNT Advance Tax Amount  
FINCHG_AMOUNT Finance Charge Amount  
TOTAL_AMOUNT Amount Billed  
APPLYTO_TKPR_NUM Timekeeper Number ledger record applies to  
APPLYTO_STMT_NUM Statement Number ledger record applies to  
REVERSED_SW Reversed Payment Switch 0=unchecked, 1 = checked
FEE_DESC_LINK *  
PREVIOUS_BALANCE Previous Balance  
UPDATE_MONTH Reporting Month Statement Updated In 1-12
UPDATE_YEAR Reporting Year Statement Updated In 00-99 (26 = 2026, 97 = 1997, etc.)


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