Payroll Pay Code Setup (UPR40600)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Pay Code Setup
Physical Name: UPR40600
Technical Name: UPR_SETP_Pay_Type

Group Display Name: Payroll Pay Code Setup
Group Technical Name: Payroll Pay Code Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAYRCORD SearchPay RecordSTR6_Payroll_CodeString6
2DSCRIPTN SearchDescriptionSTR30String30
3INACTIVE SearchInactiveCB_InactiveBoolean0
4PAYTYPE SearchPay TypeDDL_Pay_TypesInteger0
5BSPAYRCD SearchBase Pay RecordSTR6_Payroll_CodeString6
6PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency14
7PAYUNIT SearchPay UnitSTR25String25
8PAYUNPER SearchPay Unit PeriodDDL_Pay_PeriodsInteger0
9PAYPEROD SearchPay PeriodDDL_Pay_PeriodsInteger0
10PAYPRPRD SearchPay Per PeriodDLR11_$S2Currency14
11MXPYPPER SearchMax Pay Per PeriodDLR11_$U2Currency14
12TipType SearchTip TypeDDL_Type_of_TipsInteger0
13PAYADVNC SearchPay AdvanceDLR11_$U2Currency14
14RPTASWGS SearchReport As WagesCB_Report_As_WagesBoolean0
15W2BXNMBR SearchW2 Box NumberINT2_U0Integer2
16W2BXLABL SearchW2 Box LabelSTR6String6
17TAXABLE SearchTaxableCB_TaxableBoolean0
18SBJTFDTX SearchSubject To Federal TaxCB_FederalBoolean0
19SBJTSSEC SearchSubject To Social SecurityCB_FICA_Social_SecurityBoolean0
20SBJTMCAR SearchSubject To MedicareCB_FICA_MedicareBoolean0
21SBJTSTTX SearchSubject To State TaxCB_StateBoolean0
22SBJTLTAX SearchSubject To Local TaxCB_LocalBoolean0
23SBJTFUTA SearchSubject To FutaCB_FutaBoolean0
24SBJTSUTA SearchSubject To SutaCB_SutaBoolean0
25FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer4
26FLSTTXRT SearchFlat State Tax RateINT4_%2Integer4
27ACRUVACN SearchAccrue VacationCB_VacationBoolean0
28ACRUSTIM SearchAccrue Sick TimeCB_Sick_TimeBoolean0
29NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Pay Code Setup'].NOTEINDX AS 'Payroll Pay Code Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR40600 AS ['Payroll Pay Code Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Pay Code Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
30DATAENTDFLT SearchData Entry DefaultCB_DataEntryDefaultBoolean0
31SHFTCODE SearchShift CodeSTR6_Payroll_CodeString6
32PAYFACTR SearchPay FactorDLR5_U2Currency8
33BSDONRTE SearchBased On RateDLR11_$S2Currency14
34W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer2
35W2BXLABL2 SearchW2 Box Label 2STR6String6
36W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer2
37W2BXLABL3 SearchW2 Box Label 3STR6String6
38W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer2
39W2BXLABL4 SearchW2 Box Label 4STR6String6
40DEX_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.

Leave a Reply

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