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