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 Bill To file.

Tabs3 Bill To File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
Client_ID Client ID  
Record_No *  
Contact Contact  
Description Description  
Print_Sw Print Statement Switch 0=not selected, 1=selected
Email_Sw Email Statement Switch 0=not selected, 1=selected
Addr_No Address Selector

1=Business

2=Home

3=Other
Email_Addr_No Email Address Selector 1-3
Email_Template Email Template  
Attn_Sw Attention Line Switch

1=Include

2=Exclude
Attn_Type Attention Type Switch

1=Contact Name

2=Other Name
Attn_Override Other Name  
Contact_Lookup_Sw *  
Alt_Addr1 Address Line 1 Secure/Matter Mode only
Alt_Addr2 Address Line 2 Secure/Matter Mode only
Alt_Addr3 Address Line 3 Secure/Matter Mode only
Alt_City Address City Secure/Matter Mode only
Alt_State Address State Secure/Matter Mode only
Alt_Zip Address Zip Secure/Matter Mode only
Alt_Country Address Country Secure/Matter Mode only
Alt_Email_Address Email Address Secure/Matter Mode only

 

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