Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD032
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document User Preferences Master
Physical Name: RVLPD032
Technical Name: rvlpmPmntDocUserPrefMSTR
| 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
['Purchasing Payment Document User Preferences Master'].USERID AS 'Purchasing Payment Document User Preferences Master-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RVLPD032 AS ['Purchasing Payment Document User Preferences Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Purchasing 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
['Purchasing Payment Document User Preferences Master'].NOTEINDX AS 'Purchasing Payment Document User Preferences Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD032 AS ['Purchasing Payment Document User Preferences Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Payment Document User Preferences Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX |
