Payroll Master (UPR00100)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Master
Physical Name: UPR00100
Technical Name: UPR_MSTR

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
2EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
3INACTIVE SearchInactiveBooleanCB_Inactive0
4LASTNAME SearchLast NameStringSTR2020
5FRSTNAME SearchFirst NameStringSTR1515
6MIDLNAME SearchMiddle NameStringSTR1515
7ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
8SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
9BRTHDATE SearchBirth DateDateDT8
10GENDER SearchGenderIntegerDDL_Gender0
11ETHNORGN SearchEthnic OriginIntegerDDL_Ethnic Origin0
12Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
13DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
14DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
15JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
16SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
17LOCATNID SearchLocation IDStringSTR15_Location_ID15
18WCACFPAY SearchWhich Cash Account For PayIntegerGB0
19ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payroll Master'].ACTINDX AS 'Payroll Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       UPR00100 AS ['Payroll Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payroll Master'].ACTINDX = ['Account Index Master'].ACTINDX
20WKHRPRYR SearchWork Hours Per YearIntegerINT4_U04
21STRTDATE SearchStart DateDateDT8
22DEMPINAC SearchDate Employee InactivatedDateDT8
23RSNEMPIN SearchReason Employee InactivatedStringSTR3030
24MINETPAY SearchMinimum Net PayCurrencyDLR11_$U214
25SUTASTAT SearchSuta StateStringSTR2_State_Code2
26WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
27ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
28VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
29VACCRMTH SearchVacation Accrual MethodIntegerGB0
30VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
31VACAVLBL SearchVacation AvailableLong IntegerLI6_S26
32WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
33ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
34STMACMTH SearchSick Time Accrual MethodIntegerGB0
35SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
36SIKTIMAV SearchSick Time AvailableLong IntegerLI6_S26
37SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
38WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
39USERDEF1 SearchUser Defined 1StringSTR2020
40USERDEF2 SearchUser Defined 2StringSTR2020
41EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
42MARITALSTATUS SearchMaritalStatusIntegerDDL_MaritalStatus0
43BENADJDATE SearchBen Adj DateDateDT8
44LASTDAYWORKED_I SearchLast Day WorkedDateDT8
45BIRTHDAY SearchBirth DayIntegerINT0
46BIRTHMONTH SearchBirth MonthIntegerINT0
47SPOUSE SearchSpouseStringSTR1515
48SPOUSESSN SearchSpouse SSNStringSTR15_Social_Security_Number15
49NICKNAME SearchNickNameStringSTR2020
50ALTERNATENAME SearchAlternate NameStringSTR2020
51HRSTATUS SearchHR StatusIntegerDDL_HRStatus0
52DATEOFLASTREVIEW_I SearchDate Of Last ReviewDateDT8
53DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDateDT8
54BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
55HANDICAPPED SearchHandicappedBooleanCB_Handicap0
56VETERAN SearchVeteranBooleanCB_Military0
57VIETNAMVETERAN SearchVietnam VeteranBooleanCB_Vietnam0
58DISABLEDVETERAN SearchDisabled VeteranBooleanCB_DisableVet0
59UNIONEMPLOYEE SearchUnion EmployeeBooleanCB_Union_Emp0
60SMOKER_I SearchSmokerBooleanCB_Smoker0
61CITIZEN SearchCitizenBooleanCB_Citizen0
62VERIFIED SearchVerifiedBooleanCB_Verifed0
63I9RENEW SearchI9renewDateDT8
64Primary_Pay_Record SearchPrimary Pay RecordStringSTR6_Payroll_Code6
65CHANGEBY_I SearchChange ByStringSTR15_User_ID15
66CHANGEDATE_I SearchChange DateDateDT8
67NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Master'].NOTEINDX AS 'Payroll Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR00100 AS ['Payroll Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
68NOTEINDX2 SearchNote Index2CurrencyDLR1414
69UNIONCD SearchUnion CodeStringSTR66
70RATECLSS SearchRate ClassStringSTR1515
71FEDCLSSCD SearchFederal Classification CodeStringSTR10_LBAU10
72OTHERVET SearchOther VeteransBooleanCB_OtherVet0
73Military_Discharge_Date SearchMilitary Discharge DateDateDT8
74EMPLSUFF SearchEmployee SuffixStringSTR4_Employee_Suffix4
75STATUSCD SearchStatus CodeStringSTR15_LBU15
76Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
77Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
78Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
79AFSMVET SearchArmed Forces Service Medal VeteranBooleanCB_Armed_Forces0
80RECSEPVET SearchRecently-Separated VeteranBooleanCB_Recently_Sep_Vet0
81USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Master'].USERID AS 'Payroll Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR00100 AS ['Payroll Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Master'].USERID = ['Users Master'].USERID

Leave a Reply

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