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

Tabs3 Billing Autopayments File
Field Name Description Notes
_Sequence_No Internal Sequence Number  
CLIENT_ID Client ID  
STATUS Status  
SCHEDULED_DATE Scheduled Date  
AMOUNT Amount  
STMTTRACK_ID *  
SCHEDULED_PAYMENT_ID *  
MERCHANT_ID *  
PAYMENT_METHOD_ID *  
BANK Bank Account 0 = operating account,
1-99 = trust bank account
PAYMENT_METHOD_DESC Payment Method  

 

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