Payroll Pay Code Master (UPR00400)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Pay Code Master (UPR00400)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Pay Code Master
Physical Name: UPR00400
Technical Name: UPR_MSTR_Pay_Type

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
3INACTIVE SearchInactiveBooleanCB_Inactive0
4PAYTYPE SearchPay TypeIntegerDDL_Pay_Types0
5BSPAYRCD SearchBase Pay RecordStringSTR6_Payroll_Code6
6PAYRTAMT SearchPay Rate AmountCurrencyDLR11_$S214
7PAYUNIT SearchPay UnitStringSTR2525
8PAYUNPER SearchPay Unit PeriodIntegerDDL_Pay_Periods0
9RPTASWGS SearchReport As WagesBooleanCB_Report_As_Wages0
10TAXABLE SearchTaxableBooleanCB_Taxable0
11SBJTFDTX SearchSubject To Federal TaxBooleanCB_Federal0
12SBJTSSEC SearchSubject To Social SecurityBooleanCB_FICA_Social_Security0
13SBJTMCAR SearchSubject To MedicareBooleanCB_FICA_Medicare0
14SBJTSTTX SearchSubject To State TaxBooleanCB_State0
15SBJTLTAX SearchSubject To Local TaxBooleanCB_Local0
16SBJTFUTA SearchSubject To FutaBooleanCB_Futa0
17SBJTSUTA SearchSubject To SutaBooleanCB_Suta0
18SUTASTAT SearchSuta StateStringSTR2_State_Code2
19FFEDTXRT SearchFlat Federal Tax RateIntegerINT4_%24
20FLSTTXRT SearchFlat State Tax RateIntegerINT4_%24
21PAYPEROD SearchPay PeriodIntegerDDL_Pay_Periods0
22PAYPRPRD SearchPay Per PeriodCurrencyDLR11_$S214
23MXPYPPER SearchMax Pay Per PeriodCurrencyDLR11_$U214
24TipType SearchTip TypeIntegerDDL_Type_of_Tips0
25PAYADVNC SearchPay AdvanceCurrencyDLR11_$U214
26ACRUVACN SearchAccrue VacationBooleanCB_Vacation0
27ACRUSTIM SearchAccrue Sick TimeBooleanCB_Sick_Time0
28WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
29W2BXNMBR SearchW2 Box NumberIntegerINT2_U02
30W2BXLABL SearchW2 Box LabelStringSTR66
31PYADVTKN SearchPay Advance TakenCurrencyDLR11_$U214
32NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Pay Code Master'].NOTEINDX AS 'Payroll Pay Code Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR00400 AS ['Payroll Pay Code Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Pay Code Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
33DATAENTDFLT SearchData Entry DefaultBooleanCB_DataEntryDefault0
34SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
35PAYFACTR SearchPay FactorCurrencyDLR5_U28
36BSDONRTE SearchBased On RateCurrencyDLR11_$S214
37PYSTPTBLID SearchPay Step Table IDStringSTR15_LBU15
38Base_Step_Increased_On SearchBase Step Increases OnIntegerDDL_BaseStepIncreasesOn0
39Step SearchStepIntegerINT3_RB0_U3
40Step_Effective_Date SearchStep Effective DateDateDT8
41Step_FTE SearchStep FTECurrencyDLR4_U29
42W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
43W2BXLABL2 SearchW2 Box Label 2StringSTR66
44W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
45W2BXLABL3 SearchW2 Box Label 3StringSTR66
46W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
47W2BXLABL4 SearchW2 Box Label 4StringSTR66
48Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
49Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
50Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
51STRTDATE SearchStart DateDateDT8
52ENDDATE SearchEnd DateDateDT8
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Pay Code Master (UPR00400)

Leave a Reply

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