Revision History

You must provide TaxYear and ReturnType in Connection string as given below:  

---

Lacerte Software Development Kit Developer Instructions 
pg. 15
“driver=LacerteDSIIDriver; DataDir=c:\Lacerte\18tax\idata; TaxYear=2019; ReturnType=Individual”
ReturnType values can be following: 
Module  
ReturnType  
Individual
Individual
Corporate
Corporate
Partnership
Partnership
S-Corporation
SCorporate
Fiduciary
Fiduciary
Exempt
Exempt
Estate
Estate
Gift
Gift
Benefit
Benefit
Working with Detail Files
Each client’s detail file will be its own table. The detail file consists of multiple series and codes, where a 
series is typically associated with an input screen in Lacerte and a code is associated to an input field.
For a complete list of series and codes, please refer to the GL Bridge documentation or the blank input 
sheets in Lacerte.
The columns within the detail file table are as follows:
Column Name  Required  Type  
Constraints  
Series
X
Integer
NOTE: See input sheets in Lacerte for the Series number
Prefix
X
Integer
Code
X
Integer
NOTE: See input sheets in Lacerte for the code numbers
Suffix
X
Integer
Start at 1000 for standard fields. 1 for suffixed fields
StateAbbr
X
String
Length=2
CityAbbr
String
Length=3
Source
String
Must be equal to blank, Nonsource, Source
TSJ
String
Must be equal to Joint (or blank), Taxpayer, Spouse
ImportSrc
String
Read Only
Amount
X
Double
• Variable Length (Based on field property)
• >= -999,999,999 and <=999,999,999
• Max decimal precision = 12

---

Lacerte Software Development Kit Developer Instructions 
pg. 16
Description
String
Variable Length usually noted on input sheets as: ‘(40)’