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

Tabs3 Client Ledger Allocation File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID Number  
MAIN_REF_NUM Reference Number of Payment

If WIP_SW = 1, this is a reference number in the payment file,

if WIP_SW = 0, this is the ledger reference number.
WIP_SW Payment Work in Progress Switch 0=ledger payment, 1 = WIP payment
ALLOC_TYPE Allocation Type C=credit, P=payment, W=write-off
RECORD_TYPE Record Type (1-1026)

1=Fees

1003=Expenses

1013=Advances

1023=Finance Charge

1024=Fee Tax

1025=Expense Tax

1026=Advance Tax
AMOUNT Amount Amount Applied
APPLYTO_SEQNO Apply To Sequence Number Sequence Number of Ledger record that the record applies to.
DATE Date of Allocation  
MANUAL_SW Manual Allocation Switch 0=automatically allocated, 1 = manually allocated
PROGRESS_SW Progress Billing Switch 0=unchecked, 1 = checked