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 Trust Request file.

Tabs3 Billing Trust Request File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID/Trust Account  
BANK Trust Bank  
AMOUNT Trust Request Amount  
SENT_SW Sent 1 = Sent, 0 = Pending
SENT_DATE Date Sent  
STMT_TRACK_SEQNO Statement Tracking Sequence Number  
PAID_SW Paid 1 = Paid, 0 = Unpaid
TYPE Type M = Manual, S = Statement
TO_NAME To Name  
FROM_NAME Email From Name  
SUBJECT Email Subject  
PDF_FILENAME PDF file name  
TO_EMAIL_ADDRESS Email To Address  
FROM_ADDRESS Email From Address  
REPLY_TO_ADDRESS Email Reply Address  
CC_ADDRESS Email Cc Addresses  
BCC_ADDRESS Email Bcc Addresses  
BODY Email Body  
ATTACHMENTS Email Attachments