JC_Certified_Payroll_VIEW (JC90200)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Certified_Payroll_VIEW (JC90200)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Certified_Payroll_VIEW
Physical Name: JC90200
Technical Name: JC_Certified_Payroll_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
3TRXBEGDT SearchTRX Beginning DateDTDate48
4TRXENDDT SearchTRX Ending DateDTDate48
5UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
6PAYTYPE SearchPay TypeDDL_Pay_TypesInteger20
7TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
8UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
9TRX_QTY_PR SearchTRX QTY PRLI6_S2Long Integer46
10Monday SearchMondayLI6_S2Long Integer46
11Tuesday SearchTuesdayLI6_S2Long Integer46
12Wednesday SearchWednesdayLI6_S2Long Integer46
13Thursday SearchThursdayLI6_S2Long Integer46
14Friday SearchFridayLI6_S2Long Integer46
15Saturday SearchSaturdayLI6_S2Long Integer46
16Sunday SearchSundayLI6_S2Long Integer46
17NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency1014
18FCASWPR SearchFICA/Social Security Withholding/Pay RunDLR11_$S2Currency1014
19GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency1014
20FDWDGPRN SearchFederal Withholding/Pay RunDLR11_$S2Currency1014
21FICAMWPR SearchFICA/Medicare Withholding/Pay RunDLR11_$S2Currency1014
22TTLDDTNS SearchTotal DeductionsDLR11_$S2Currency1014
23SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
24State_and_Local_Taxes SearchState and Local TaxesDLR11_$S2Currency1014
25Total_Deductions_CP SearchTotal Deductions CPDLR11_$S2Currency1014
26ADDRESS1 SearchAddress 1STR60String6260
27ADDRESS2 SearchAddress 2STR60String6260
28CITY SearchCitySTR35String3635
29STATE SearchStateSTR30_StateString3029
30ZIPCODE SearchZip CodeSTR10String1210
31FRSTNAME SearchFirst NameSTR15String1615
32MIDLNAME SearchMiddle NameSTR15String1615
33LASTNAME SearchLast NameSTR20String2220
34Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency1014
azurecurveProductsWennSoft Products (131)3rd PartyJC_Certified_Payroll_VIEW (JC90200)

Leave a Reply

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