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 Group Display Name: Payroll Pay Code Setup
Physical Name: UPR40600
Technical Name: UPR_SETP_Pay_Type
Group Technical Name: Payroll Pay Code Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PAYRCORD | Pay Record | String | STR6_Payroll_Code | 6 | |
2 | DSCRIPTN | Description | String | STR30 | 30 | |
3 | INACTIVE | Inactive | Boolean | CB_Inactive | 0 | |
4 | PAYTYPE | Pay Type | Integer | DDL_Pay_Types | 0 | |
5 | BSPAYRCD | Base Pay Record | String | STR6_Payroll_Code | 6 | |
6 | PAYRTAMT | Pay Rate Amount | Currency | DLR11_$S2 | 14 | |
7 | PAYUNIT | Pay Unit | String | STR25 | 25 | |
8 | PAYUNPER | Pay Unit Period | Integer | DDL_Pay_Periods | 0 | |
9 | PAYPEROD | Pay Period | Integer | DDL_Pay_Periods | 0 | |
10 | PAYPRPRD | Pay Per Period | Currency | DLR11_$S2 | 14 | |
11 | MXPYPPER | Max Pay Per Period | Currency | DLR11_$U2 | 14 | |
12 | TipType | Tip Type | Integer | DDL_Type_of_Tips | 0 | |
13 | PAYADVNC | Pay Advance | Currency | DLR11_$U2 | 14 | |
14 | RPTASWGS | Report As Wages | Boolean | CB_Report_As_Wages | 0 | |
15 | W2BXNMBR | W2 Box Number | Integer | INT2_U0 | 2 | |
16 | W2BXLABL | W2 Box Label | String | STR6 | 6 | |
17 | TAXABLE | Taxable | Boolean | CB_Taxable | 0 | |
18 | SBJTFDTX | Subject To Federal Tax | Boolean | CB_Federal | 0 | |
19 | SBJTSSEC | Subject To Social Security | Boolean | CB_FICA_Social_Security | 0 | |
20 | SBJTMCAR | Subject To Medicare | Boolean | CB_FICA_Medicare | 0 | |
21 | SBJTSTTX | Subject To State Tax | Boolean | CB_State | 0 | |
22 | SBJTLTAX | Subject To Local Tax | Boolean | CB_Local | 0 | |
23 | SBJTFUTA | Subject To Futa | Boolean | CB_Futa | 0 | |
24 | SBJTSUTA | Subject To Suta | Boolean | CB_Suta | 0 | |
25 | FFEDTXRT | Flat Federal Tax Rate | Integer | INT4_%2 | 4 | |
26 | FLSTTXRT | Flat State Tax Rate | Integer | INT4_%2 | 4 | |
27 | ACRUVACN | Accrue Vacation | Boolean | CB_Vacation | 0 | |
28 | ACRUSTIM | Accrue Sick Time | Boolean | CB_Sick_Time | 0 | |
29 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
30 | DATAENTDFLT | Data Entry Default | Boolean | CB_DataEntryDefault | 0 | |
31 | SHFTCODE | Shift Code | String | STR6_Payroll_Code | 6 | |
32 | PAYFACTR | Pay Factor | Currency | DLR5_U2 | 8 | |
33 | BSDONRTE | Based On Rate | Currency | DLR11_$S2 | 14 | |
34 | W2BXNMBR2 | W2 Box Number 2 | Integer | INT2_U0 | 2 | |
35 | W2BXLABL2 | W2 Box Label 2 | String | STR6 | 6 | |
36 | W2BXNMBR3 | W2 Box Number 3 | Integer | INT2_U0 | 2 | |
37 | W2BXLABL3 | W2 Box Label 3 | String | STR6 | 6 | |
38 | W2BXNMBR4 | W2 Box Number 4 | Integer | INT2_U0 | 2 | |
39 | W2BXLABL4 | W2 Box Label 4 | String | STR6 | 6 |