| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SmartList_ID | SmartList ID |
String | 16 | View | |
| Table_Number | Table Number |
Integer | 2 | View | |
| Field_Number | Field Number |
Integer | 2 | View | |
| SmartList_Field_Name | SmartList Field Name |
String | 82 | View | |
| SmartList_Display_Name | SmartList Display Name |
String | 82 | View | |
| Default_Display | Default Display |
Boolean | 2 | View | |
| Display_Field | Display Field |
Boolean | 2 | View | |
| FIELDTYPE | Field Type |
Long Integer | 4 | View | |
| SLB_Field_String_Format | SmartList Field String Format |
Integer | 2 | View | |
| String_Mask | String Mask |
String | 32 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| Show_Currency_Symbol | Show Currency Symbol |
Boolean | 2 | View | |
| Show_Percentage_Symbol | Show Percentage Symbol |
Boolean | 2 | View | |
| Show_Thousands_Separator | Show Thousands Separator |
Boolean | 2 | View | |
| Summary_Method | Summary Method |
Integer | 2 | View | |
| Display_As_Account | Display As Account |
Boolean | 2 | View | |
| TBLPHYSNM | Table Physical Name |
String | 52 | View | |
| Date_Display_Option | Date Display Option |
Integer | 2 | View | |
| Display_Blank_Dates | Display Blank Dates |
Boolean | 2 | View | |
| Display_As_Negative | Display As Negative |
Boolean | 2 | View | |
| Display_As_Note | Display As Note |
Boolean | 2 | View | |
| Negative_Table | Negative Table |
Integer | 2 | View | |
| Negative_Field | Negative Field |
Integer | 2 | View | |
| Decimal_Table | Decimal Table |
Integer | 2 | View | |
| Decimal_Field | Decimal Field |
Integer | 2 | View | |
| Decimal_Places_Method | Decimal Places Method |
Integer | 2 | View | |
| Column_Order | Column Order |
Integer | 2 | View | |
| TXTFIELD | Text Field |
Text | 2 | View |