Card_Catalog (CARD40)

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

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 TypeLength
1INTERNALCODIVCB_I SearchInternal CoDiv CBCB_InternalCoDivBoolean0
2DSCRIPTN SearchDescriptionSTR30String30
3ADDRESS1 SearchAddress 1STR60String60
4ADDRESS2 SearchAddress 2STR60String60
5CITY SearchCitySTR35String35
6STATE SearchStateSTR30_StateString29
7ZIPCODE_I SearchIZip CodeSTR10String10
8IZIPCODE_I SearchIZip CodeSTR10String10
9WORKPHONE SearchWork PhoneSTR10_PhoneString10
10EXT_I SearchExtSTR4_IString4
11EXT_I SearchExtSTR4String4
12IFAX_I SearchIFaxSTR10_LZN_PhoneString10
13EXT2_I SearchExt2STR4_IString4
14EXT2_I SearchExt2STR4String4
15FFIRSTNAME_I SearchFFirst NameSTR15String15
16FFIRSTNAME_I SearchFFirst NameSTR15_IString15
17EMAILADDRESS_I SearchEmail AddressSTR1000String100
18EMAILADDRESS_I SearchEmail AddressSTR100String100
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.

Leave a Reply

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