Sales User-Defined Work History (SOP10106)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales User-Defined Work History (SOP10106)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales User-Defined Work History
Physical Name: SOP10106
Technical Name: sopUsrDefWorkHist

Group Display Name: Sales Distribution
Group Technical Name: Sales Distribution

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
3USRDAT01 SearchUser Defined Date 1DTDate8
4USRDAT02 SearchUser Defined Date 2DTDate8
5USRTAB01 SearchUser Defined Table 1STR20String20
6USRTAB09 SearchUser Defined Table 2STR20String20
7USRTAB03 SearchUser Defined Table 3STR20String20
8USERDEF1 SearchUser Defined 1STR20String20
9USERDEF2 SearchUser Defined 2STR20String20
10USRDEF03 SearchUser Defined 3STR20String20
11USRDEF04 SearchUser Defined 4STR20String20
12USRDEF05 SearchUser Defined 5STR20String20
13COMMENT SearchCommentSTR50String50
14COMMENT_1 SearchComment[1]STR50String50
15COMMENT_2 SearchComment[2]STR50String50
16COMMENT_3 SearchComment[3]STR50String50
17COMMENT_4 SearchComment[4]STR50String50
18CMMTTEXT SearchComment TextTX500Text500
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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales User-Defined Work History (SOP10106)

Leave a Reply

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