ECM_ReqItemList (ECM10005)

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

Product: Enhanced Commitment Management (2547)
Series: System

Display Name: ECM_ReqItemList
Physical Name: ECM10005
Technical Name: ECM_ReqItemList

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CompanyID SearchECM_CompanyIDLI_Sequence_NumberLong Integer410
2ReqID SearchECM_ReqIDSTR22String2422
3SequenceID SearchECM_SequenceIDLI_Sequence_NumberLong Integer410
4Item SearchECM_ItemSTR30_Item_NumberString3230
5GenericDescription SearchECM_GenericDescriptionSTR53String5453
6Quantity SearchECM_QuantitySTR12String1412
7Price SearchECM_PriceSTR32String3432
8ExtPrice SearchECM_ExtPriceDLR17_RBS0_STR$Currency1017
9QuantityDecimals SearchECM_QuantityDecimalsINT4Integer24
10PriceDecimals SearchECM_PriceDecimalsINT4Integer24
11AccountIndex SearchECM_AccountIndexLI_Sequence_NumberLong Integer410
12ReqVendor SearchECM_ReqVendorSTR20String2220
13VendorName SearchECM_VendorNameSTR32String3432
14SiteID SearchECM_SiteIDSTR12String1412
15PONumber SearchECM_PONumberSTR32String3432
16POOrd SearchECM_POOrdINT4Integer24
17ConsolidatedReq SearchECM_ConsolidatedReqSTR22String2422
18ItemComment SearchECM_ItemCommentSTR255String256255
19ErrorMsg SearchECM_ErrorMsgSTR53String5453
20RequiredBy SearchECM_RequiredByDATE_LONGDate48
21UofM SearchECM_UofMU_Of_MString108
22ItemText SearchECM_ItemTextECM_Text16Text216
23DEX_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 *