Payroll Cross Company Report Options (UPR70501)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Cross Company Report Options (UPR70501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR70501

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Cross Company Report Options
Physical Name: UPR70501
Technical Name: uprCrossCompanyROPT

Group Display Name: Payroll Report Options
Group Technical Name: Payroll Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RPTGRIND SearchReport Group IndexINTInteger0
2RTPACHIN SearchReport Palette Choice IndexINTInteger0
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
4CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Payroll Cross Company Report Options'].CMPANYID AS 'Payroll Cross Company Report Options-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       UPR70501 AS ['Payroll Cross Company Report Options']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Payroll Cross Company Report Options'].CMPANYID = ['Company Master'].CMPANYID
5DEX_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)PayrollPayroll Cross Company Report Options (UPR70501)

Leave a Reply

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