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 TypeLength
1CompanyID SearchECM_CompanyIDLI_Sequence_NumberLong Integer10
2ReqID SearchECM_ReqIDSTR22String22
3SequenceID SearchECM_SequenceIDLI_Sequence_NumberLong Integer10
4Item SearchECM_ItemSTR30_Item_NumberString30
5GenericDescription SearchECM_GenericDescriptionSTR53String53
6Quantity SearchECM_QuantitySTR12String12
7Price SearchECM_PriceSTR32String32
8ExtPrice SearchECM_ExtPriceDLR17_RBS0_STR$Currency17
9QuantityDecimals SearchECM_QuantityDecimalsINT4Integer4
10PriceDecimals SearchECM_PriceDecimalsINT4Integer4
11AccountIndex SearchECM_AccountIndexLI_Sequence_NumberLong Integer10
12ReqVendor SearchECM_ReqVendorSTR20String20
13VendorName SearchECM_VendorNameSTR32String32
14SiteID SearchECM_SiteIDSTR12String12
15PONumber SearchECM_PONumberSTR32String32
16POOrd SearchECM_POOrdINT4Integer4
17ConsolidatedReq SearchECM_ConsolidatedReqSTR22String22
18ItemComment SearchECM_ItemCommentSTR255String255
19ErrorMsg SearchECM_ErrorMsgSTR53String53
20RequiredBy SearchECM_RequiredByDATE_LONGDate8
21UofM SearchECM_UofMU_Of_MString8
22ItemText SearchECM_ItemTextECM_Text16Text16
23DEX_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 *