ASI_Field_Definition (ASITAB20)

azurecurveProductsSmartList (1493)SystemASI_Field_Definition (ASITAB20)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASITAB20

Product: SmartList (1493)
Series: System

Display Name: ASI_Field_Definition
Physical Name: ASITAB20
Technical Name: ASI_Field_Definition

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger20
2ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger20
3ASI_Field_Sequence SearchASI_Field_SequenceINTInteger20
4ASI_Field_Number SearchASI_Field_NumberINTInteger20
5ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger20
6ASI_Field_Name SearchASI_Field_NameSTR80String8280
7ASI_Field_Display_Name SearchASI_Field_Display_NameSTR80String8280
8ASI_Field_Physical_Name SearchASI_Field_Physical_NameSTR30String3230
9ASI_Field_Use_UsrDef_Prm SearchASI_Field_Use_User_Defined_PromptASI_Field_Use_User_Defined_PromptBoolean20
10ASI_Field_DDL_Type SearchASI_Field_DDL_TypeASI_Field_DDL_TypeInteger20
11ASI_Field_Datatype SearchASI_Field_DatatypeASI_Field_DatatypeInteger20
12ASI_Field_Format_String SearchASI_Field_Format_StringSTR50String5250
13ASI_Field_In_Lookup_Tabl SearchASI_Field_In_Lookup_TablebooleanBoolean20
14ASI_Include_Column SearchASI_Include_ColumnASI_CB_Include_ColumnBoolean20
15ASI_Display_Column SearchASI_Display_ColumnASI_CB_Display_ColumnBoolean20
16ASI_Field_Description SearchASI_Field_DescriptionSTR255String256255
17ASI_Field_Custom_Query SearchASI_Field_Custom_QuerySTR255String256255
18ASI_Table_Technical_Name SearchASI_Table_Technical_NameSTR80String8280
19DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsSmartList (1493)SystemASI_Field_Definition (ASITAB20)

Leave a Reply

Your email address will not be published. Required fields are marked *