Payroll Batches (UPR10301)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Batches
Physical Name: UPR10301
Technical Name: UPR_TRX_Batch_HDR

Group Display Name: Payroll Transactions
Group Technical Name: Payroll Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberStringSTR15_LBAU15
2UPRBCHOR SearchUPR Batch OriginIntegerDDL_UPR_Batch_Origin0
3BCHCOMNT SearchBatch CommentStringSTR6060
4UPRBCHFR SearchUPR Batch FrequencyIntegerDDL_UPR_Batch_Frequency0
5POSTEDDT SearchPosted DateDateDATE6
6UPRBCHMK SearchUPR Batch MarkedBooleanCB0
7MKDBYUSR SearchMarked By UserStringSTR1515
8MSCBDINC SearchMisc Batch Days To IncrementIntegerINT3_U03
9RECPSTGS SearchRecurring PostingsIntegerINT3_U03
10RCLPSTDT SearchRecurring Last Posted DateDateDT8
11NOFPSTGS SearchNumber of PostingsIntegerINT3_S03
12CNTRLTRX SearchControl TRX CountLong IntegerLI6_U06
13CTRLEMPCT SearchControl Employee CountIntegerINT5_S05
14APPROVL SearchApprovalBooleanCB_Approval0
15APPRVLDT SearchApproval DateDateDATE6
16APRVLUSERID SearchApproval User IDStringSTR15_User_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Batches'].APRVLUSERID AS 'Payroll Batches-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10301 AS ['Payroll Batches']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Batches'].APRVLUSERID = ['Users Master'].USERID
17NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Batches'].NOTEINDX AS 'Payroll Batches-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR10301 AS ['Payroll Batches']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Batches'].NOTEINDX = ['Record Notes Master'].NOTEINDX
18TRXBEGDT SearchTRX Beginning DateDateDT8
19TRXENDDT SearchTRX Ending DateDateDT8
20Days_Worked SearchDaysWorkedCurrencyDLR9_U29
21Weeks_Worked SearchWeeksWorkedCurrencyDLR9_U29

Leave a Reply

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