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

Tabs3 Statement Tracking File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
CLIENT_ID Client ID  
BATCH_NUMBER Batch Number  
DRAFT_RUN_DATE Pre-Bill Run Date  
FINAL_RUN_DATE Final Statement Run Date  
REVIEWED_BILL_SW Reviewed Pre-Bill Switch 0=unchecked, 1 = checked
HOLD_BILL_SW Hold Bill Switch 0=unchecked, 1 = checked
PRINT_STMT_SW Print Statement Switch 0=unchecked, 1 = checked
STATEMENT_NUMBER Statement Number  
STATEMENT_ID *  
COMBINE_ID *  
UPDATE_RUN_DATE Statement Update Run Date  
EMAIL_SW Email Statement Switch 0=unchecked, 1 = checked
EMAIL_RUN_DATE Email Run Date  
EMAIL_RUN_USER_ID Email sent by User ID  
BILLTO_CONTACT Bill-To Contact  
BILLTO_NAME Bill-To Name  
FROM_NAME Email From Name  
SUBJECT Email Subject  
PDF_FILE_NAME PDF Statement file name  
COVER_SW Cover statement 0=unchecked, 1 = checked
UNUPDATED_SW Statement has been unupdated 0=unchecked, 1 = checked
BILLTO_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