Payroll Distribution History Header (UPR30400)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Distribution History Header (UPR30400)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Distribution History Header
Physical Name: UPR30400
Technical Name: UPR_Distribution_HIST_HDR

Group Display Name: Payroll Distribution History
Group Technical Name: Payroll Distribution History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1AUCTRLCD SearchAudit Control CodeStringSTR13_LBAU13
2POSTEDDT SearchPosted DateDateDATE6
3USWHPSTD SearchUser Who PostedStringUser_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Distribution History Header'].USWHPSTD AS 'Payroll Distribution History Header-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR30400 AS ['Payroll Distribution History Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Distribution History Header'].USWHPSTD = ['Users Master'].USERID
4HISTRMVD SearchHistory RemovedBooleanTrue/False0
5BACHNUMB SearchBatch NumberStringSTR15_LBAU15
6NUMOFTRX SearchNumber Of TRXLong IntegerLI6_U06
7NUMOFEMP SearchNumber of EmployeesIntegerINT5_U05
8CNTRLTRX SearchControl TRX CountLong IntegerLI6_U06
9CTRLEMPCT SearchControl Employee CountIntegerINT5_S05
10APPROVL SearchApprovalBooleanCB_Approval0
11APRVLUSERID SearchApproval User IDStringSTR15_User_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Distribution History Header'].APRVLUSERID AS 'Payroll Distribution History Header-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR30400 AS ['Payroll Distribution History Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Distribution History Header'].APRVLUSERID = ['Users Master'].USERID
12APPRVLDT SearchApproval DateDateDATE6
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Distribution History Header (UPR30400)

Leave a Reply

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