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 TypeLength
1ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger0
2ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger0
3ASI_Field_Sequence SearchASI_Field_SequenceINTInteger0
4ASI_Field_Number SearchASI_Field_NumberINTInteger0
5ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger0
6ASI_Field_Name SearchASI_Field_NameSTR80String80
7ASI_Field_Display_Name SearchASI_Field_Display_NameSTR80String80
8ASI_Field_Physical_Name SearchASI_Field_Physical_NameSTR30String30
9ASI_Field_Use_UsrDef_Prm SearchASI_Field_Use_User_Defined_PromptASI_Field_Use_User_Defined_PromptBoolean0
10ASI_Field_DDL_Type SearchASI_Field_DDL_TypeASI_Field_DDL_TypeInteger0
11ASI_Field_Datatype SearchASI_Field_DatatypeASI_Field_DatatypeInteger0
12ASI_Field_Format_String SearchASI_Field_Format_StringSTR50String50
13ASI_Field_In_Lookup_Tabl SearchASI_Field_In_Lookup_TablebooleanBoolean0
14ASI_Include_Column SearchASI_Include_ColumnASI_CB_Include_ColumnBoolean0
15ASI_Display_Column SearchASI_Display_ColumnASI_CB_Display_ColumnBoolean0
16ASI_Field_Description SearchASI_Field_DescriptionSTR255String255
17ASI_Field_Custom_Query SearchASI_Field_Custom_QuerySTR255String255
18ASI_Table_Technical_Name SearchASI_Table_Technical_NameSTR80String80
19DEX_ROW_ID Searchintint10

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 *