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 GLS Integration Setup file.

Tabs3 GLS Integration Setup File
Field Name Description Notes
_SEQUENCE_NO Internal Sequence Number  
MAP_NO Table line number  
PRIMARY_KEY_TYPE Primary

1=Category

2=Location

3=Tcode

4=Timekeeper/Cost Type
SECONDARY_KEY_TYPE Secondary

0=None

or as PRIMARY_KEY_TYPE
PRIMARY_KEY Value of Primary Key

0=All

1023=Finance Charge

1024=Fee Tax

1025=Expense Tax

1026=Advance Tax

1027=Unapplied Payments

or as PRIMARY_KEY_TYPE
SECONDARY_KEY Value of Secondary Key  
JOURNAL G/L Journal #  
DEBIT_ACCT G/L Debit Account #  
CREDIT_ACCT G/L Credit Account #  
DESC Description maximum 40 characters