Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SLB10200
Product: SmartList Builder (3830)
Series: System
Display Name: SmartList Builder Fields Group Display Name: SmartList Builder Setup Tables
Physical Name: SLB10200
Technical Name: SLB_Fields
Group Technical Name: SmartList Builder Setup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|---|---|---|---|---|
| 1 | SmartList_ID  | SmartList ID | STR15_LBAU | String | 15 |
| 2 | Table_Number | Table Number | INT5 | Integer | 4 |
| 3 | Field_Number | Field Number | INT2 | Integer | 2 |
| 4 | SmartList_Field_Name | SmartList Field Name | STR80 | String | 80 |
| 5 | SmartList_Display_Name | SmartList Display Name | STR80 | String | 80 |
| 6 | Default_Display | Default Display | CB | Boolean | 0 |
| 7 | Display_Field | Display Field | CB | Boolean | 0 |
| 8 | FIELDTYPE | Field Type | Long Int | Long Integer | 8 |
| 9 | SLB_Field_String_Format | SmartList Field String Format | SmartList Field String Format | Integer | 0 |
| 10 | String_Mask | String Mask | STR30 | String | 30 |
| 11 | DECPLCUR | Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 0 |
| 12 | Show_Currency_Symbol | Show Currency Symbol | Show Currency Symbol | Boolean | 0 |
| 13 | Show_Percentage_Symbol | Show Percentage Symbol | Show Percentage Symbol | Boolean | 0 |
| 14 | Show_Thousands_Separator | Show Thousands Separator | Show Thousands Separator | Boolean | 0 |
| 15 | Summary_Method | Summary Method | INT5 | Integer | 4 |
| 16 | Display_As_Account | Display As Account | Display As Account | Boolean | 0 |
| 17 | TBLPHYSNM | Table Physical Name | STR50 | String | 50 |
| 18 | Date_Display_Option | Date Display Option | Date Display Option | Integer | 0 |
| 19 | Display_Blank_Dates | Display Blank Dates | Display Blank Dates | Boolean | 0 |
| 20 | Display_As_Negative | Display As Negative | Display As Negative | Boolean | 0 |
| 21 | Display_As_Note | Display As Note | Display As Note | Boolean | 0 |
| 22 | Negative_Table | Negative Table | INT5 | Integer | 4 |
| 23 | Negative_Field | Negative Field | INT5 | Integer | 4 |
| 24 | Decimal_Table | Decimal Table | INT5 | Integer | 4 |
| 25 | Decimal_Field | Decimal Field | INT5 | Integer | 4 |
| 26 | Decimal_Places_Method | Decimal Places Method | Decimal Places Method | Integer | 0 |
| 27 | Column_Order | Column Order | INT5 | Integer | 4 |
| 28 | TXTFIELD | Text Field | TX32000 | Text | 32000 |