You are here: Reference Guide > Table Structures > System > SY_SearchColumns

SY_SearchColumns

Purpose    

Records the field name details for searches in the different forms

Name

Type

Linked To/Supplied

SearchColumnID char (36)

 

SearchQueryID char (36)

 

Name varchar (255)

 

DataType tinyint  
FormatString varchar (50)  
Width int  
Visible bit  
ColumnNo tinyint  
DatabaseFieldName varchar (255)  
DecimalPlaces varchar (255)  

Copyright © 2012 Jiwa Financials. All rights reserved.