Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD016
Product: Payment Document Management (2150)
Series:
Display Name: Sales Payment Document User Preferences Master
Physical Name: RVLPD016
Technical Name: rvlrmPmntDocUserPrefMSTR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 |
| Key to the Users Master (SY01400).
SELECT
['Sales Payment Document User Preferences Master'].USERID AS 'Sales Payment Document User Preferences Master-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RVLPD016 AS ['Sales Payment Document User Preferences Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Payment Document User Preferences Master'].USERID = ['Users Master'].USERID |
| 2 | NonUsedFieldsViewMode | NonUsedFieldsViewMode | Integer | NonUsedFieldsViewMode | 0 |
| 3 | NOTEINDX | Note Index | Currency | DLR14 | 14 |
| Key to the Record Notes Master (SY03900).
SELECT
['Sales Payment Document User Preferences Master'].NOTEINDX AS 'Sales Payment Document User Preferences Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD016 AS ['Sales Payment Document User Preferences Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Payment Document User Preferences Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX |
