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 TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2PAYRCORD SearchPay RecordSTR6_Payroll_CodeString86
3INACTIVE SearchInactiveCB_InactiveBoolean20
4PAYTYPE SearchPay TypeDDL_Pay_TypesInteger20
5BSPAYRCD SearchBase Pay RecordSTR6_Payroll_CodeString86
6PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency1014
7PAYUNIT SearchPay UnitSTR25String2625
8PAYUNPER SearchPay Unit PeriodDDL_Pay_PeriodsInteger20
9RPTASWGS SearchReport As WagesCB_Report_As_WagesBoolean20
10TAXABLE SearchTaxableCB_TaxableBoolean20
11SBJTFDTX SearchSubject To Federal TaxCB_FederalBoolean20
12SBJTSSEC SearchSubject To Social SecurityCB_FICA_Social_SecurityBoolean20
13SBJTMCAR SearchSubject To MedicareCB_FICA_MedicareBoolean20
14SBJTSTTX SearchSubject To State TaxCB_StateBoolean20
15SBJTLTAX SearchSubject To Local TaxCB_LocalBoolean20
16SBJTFUTA SearchSubject To FutaCB_FutaBoolean20
17SBJTSUTA SearchSubject To SutaCB_SutaBoolean20
18SUTASTAT SearchSuta StateSTR2_State_CodeString42
19FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer24
20FLSTTXRT SearchFlat State Tax RateINT4_%2Integer24
21PAYPEROD SearchPay PeriodDDL_Pay_PeriodsInteger20
22PAYPRPRD SearchPay Per PeriodDLR11_$S2Currency1014
23MXPYPPER SearchMax Pay Per PeriodDLR11_$U2Currency1014
24TipType SearchTip TypeDDL_Type_of_TipsInteger20
25PAYADVNC SearchPay AdvanceDLR11_$U2Currency1014
26ACRUVACN SearchAccrue VacationCB_VacationBoolean20
27ACRUSTIM SearchAccrue Sick TimeCB_Sick_TimeBoolean20
28WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
29W2BXNMBR SearchW2 Box NumberINT2_U0Integer22
30W2BXLABL SearchW2 Box LabelSTR6String86
31PYADVTKN SearchPay Advance TakenDLR11_$U2Currency1014
32NOTEINDX SearchNote IndexDLR14Currency1014
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 DefaultCB_DataEntryDefaultBoolean20
34SHFTCODE SearchShift CodeSTR6_Payroll_CodeString86
35PAYFACTR SearchPay FactorDLR5_U2Currency108
36BSDONRTE SearchBased On RateDLR11_$S2Currency1014
37PYSTPTBLID SearchPay Step Table IDSTR15_LBUString1615
38Base_Step_Increased_On SearchBase Step Increases OnDDL_BaseStepIncreasesOnInteger20
39Step SearchStepINT3_RB0_UInteger23
40Step_Effective_Date SearchStep Effective DateDTDate48
41Step_FTE SearchStep FTEDLR4_U2Currency109
42W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer22
43W2BXLABL2 SearchW2 Box Label 2STR6String86
44W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer22
45W2BXLABL3 SearchW2 Box Label 3STR6String86
46W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer22
47W2BXLABL4 SearchW2 Box Label 4STR6String86
48Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
49Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
50Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
51DEX_ROW_ID Searchintint1010

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 Pay Code Master (UPR00400)

Leave a Reply

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