Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SC020430
Product: Manufacturing (346)
Series: 3rd Party
Display Name: Sales Forecast Salespeople
Physical Name: SC020430
Technical Name: SF_Salespeople
Group Display Name: Manufacturing Sales Fcst.
Group Technical Name: Manufacturing SFC
|Seq No||Physical Name||Display Name||Dexterity Data Type||SQL Data Type||Length|
|1||PLANNAME_I ||Plan Name||STR15||String||15|
|2||SLPRSNID ||Salesperson ID||STR15_Salesperson_ID||String||15|
|Key to the RM Salesperson Master (RM00301).
['Sales Forecast Salespeople'].SLPRSNID AS 'Sales Forecast Salespeople-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
SC020430 AS ['Sales Forecast Salespeople']
RM00301 AS ['RM Salesperson Master']
['Sales Forecast Salespeople'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
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.