Card_Catalog (CARD40)

Easily find this page again using the shortlink:

Product: Human Resources (414)
Series: System

Display Name: Card_Catalog
Physical Name: CARD40
Technical Name: Card_Catalog

Group Display Name: HR Multi-Company
Group Technical Name: HR_MultiCmp_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1INTERNALCODIVCB_I SearchInternal CoDiv CBCB_InternalCoDivBoolean20
2DSCRIPTN SearchDescriptionSTR30String3230
3ADDRESS1 SearchAddress 1STR60String6260
4ADDRESS2 SearchAddress 2STR60String6260
5CITY SearchCitySTR35String3635
6STATE SearchStateSTR30_StateString3029
7ZIPCODE_I SearchIZip CodeSTR10String1210
8IZIPCODE_I SearchIZip CodeSTR10String1210
9WORKPHONE SearchWork PhoneSTR10_PhoneString2210
10EXT_I SearchExtSTR4_IString64
11EXT_I SearchExtSTR4String64
12IFAX_I SearchIFaxSTR10_LZN_PhoneString1210
13EXT2_I SearchExt2STR4_IString64
14EXT2_I SearchExt2STR4String64
15FFIRSTNAME_I SearchFFirst NameSTR15String1615
16FFIRSTNAME_I SearchFFirst NameSTR15_IString1615
17EMAILADDRESS_I SearchEmail AddressSTR1000String102100
18EMAILADDRESS_I SearchEmail AddressSTR100String102100
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.

Leave a Reply

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