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

Tabs3 Billing Contact File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
RP_Key Contact Key  
Name Full Name  
Alt_Name *  
Calc_Name_Sw Update Full Name based on First, Middle, and Last Name fields

0=Cleared

1=Selected
First_Name First Name  
Middle_Name Middle Name  
Last_Name Last Name  
Initials Initials  
Organization Organization Name  
Org_Sw Organization Switch

0=Individual

1=Organization
Inactive Inactive

0=Active

1=Inactive
Addr_No Default Address Selector

1=Home
2=Business
3=Other
Phone1_Src Phone Number Selector (top-left)

Assistant_Phone

Callback

Car_Phone

Cellular_Phone

Company_Phone

Home_Fax

Home_Phone

Home_Phone2

ISDN

Other_Fax

Other_Phone

Pager

Primary_Phone

Radio_Phone

Telex

TTY_TDD_Phone

Work_Fax

Work_Phone

Work_Phone2
Phone2_Src Phone Number Selector (bottom-left) Same types as PHONE1_SRC
Phone3_Src Phone Number Selector (top-right) Same types as PHONE1_SRC
Phone4_Src Phone Number Selector (bottom-right) Same types as PHONE1_SRC
Addr1_Line1 Business Address Line 1  
Addr1_Line2 Business Address Line 2  
Addr1_Line3 Business Address Line 3  
Addr1_City Business Address City  
Addr1_State Business Address State  
Addr1_Zip Business Address Zip  
Addr1_Country Business Address Country  
Addr2_Line1 Home Address Line 1  
Addr2_Line2 Home Address Line 2  
Addr2_Line3 Home Address Line 3  
Addr2_City Home Address City  
Addr2_State Home Address State  
Addr2_Zip Home Address Zip  
Addr2_Country Home Address Country  
Addr3_Line1 Other Address Line 1  
Addr3_Line2 Other Address Line 2  
Addr3_Line3 Other Address Line 3  
Addr3_City Other Address City  
Addr3_State Other Address State  
Addr3_Zip Other Address Zip  
Addr3_Country Other Address Country  
Assistant_Phone Assistant Phone Number  
Work_Phone Business Phone Number  
Work_Phone2 Business 2 Phone Number  
Work_Fax Business Fax Number  
Callback Callback Phone Number  
Car_Phone Car Phone Number  
Company_Phone Company Phone Number  
Home_Phone Home Phone Number  
Home_Phone2 Home 2 Phone Number  
Home_Fax Home Fax Number  
ISDN ISDN Number  
Cellular_Phone Mobile Phone Number  
Other_Phone Other Phone Number  
Other_Fax Other Fax Number  
Pager Pager Number  
Primary_Phone Primary Phone Number  
Radio_Phone Radio Phone Number  
Telex Telex Number  
TTY_TDD_Phone TTY/TDD Phone Number  
Addr1 Default Address Line 1 Virtual field linking to the currently specified default address.
Addr2 Default Address Line 2 Same as Addr1
Addr3 Default Address Line 3 Same as Addr1
City Default City Same as Addr1
State Default State Same as Addr1
Zip Default Zip Same as Addr1
Country Default Country Same as Addr1
Phone1 Phone Number Displayed (top-left) Virtual field linking to the phone record currently displayed.
Phone2 Phone Number Displayed (bottom-left) Same as Phone 1
Phone3 Phone Number Displayed (top-right) Same as Phone 1
Phone4 Phone Number Displayed (bottom-right) Same as Phone 1
PM_Integration *  
IsClientSw *  
IsVendorSw *  
IsPayeeSw *  
IsUserSw *  
Portal_LinkSentDate Client Portal Link Sent Date  
Portal_LinkSentTime Client Portal Link Sent Time  
Portal_Status Client Portal Status  
Email_Address1 Email 1 Address  
Email_Address2 Email 2 Address  
Email_Address3 Email 3 Address  
Web_Page Web Page URL  
Comments Comments  
LP_CONTACT_ID LawPay Contact ID  
Portal_Email Client Portal Email  
Portal_Password *  
Portal_LinkGuid *  
TwoFASecret *  

 

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