Payroll Transaction History SmartList (ASIEXP18)

azurecurveProductsSmartList (1493)PathnamePayroll Transaction History SmartList (ASIEXP18)

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

Product: SmartList (1493)
Series: Pathname

Display Name: Payroll Transaction History SmartList
Physical Name: ASIEXP18
Technical Name: ASI_UPR_Transaction_HIST_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2AUCTRLCD SearchAudit Control CodeSTR13_LBAUString1413
3EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
4CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
5PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer48
6TRXSORCE SearchTRX SourceSTR13String1413
7DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
8DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
9JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
10PYRLRTYP SearchPayroll Record TypeDDL_Payroll_Record_TypeInteger20
11PAYROLCD SearchPayroll CodeSTR6_Payroll_CodeString86
12TRXBEGDT SearchTRX Beginning DateDTDate48
13TRXENDDT SearchTRX Ending DateDTDate48
14UNTSTOPY SearchUnits To PayDLR11_S2Currency1011
15PAYRATE SearchPay RateDLR11_$S2Currency1014
16UPRTRXAM SearchUPR TRX AmountDLR11_$S2Currency1014
17TipType SearchTip TypeDDL_Type_of_TipsInteger20
18RECEIPTS SearchReceiptsDLR11_$S2Currency1014
19PAYADVNC SearchPay AdvanceDLR11_$U2Currency1014
20STATECD SearchState CodeSTR2_State_CodeString42
21LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
22WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
23CHEKDATE SearchCheck DateDATEDate46
24USWHPSTD SearchUser Who PostedUser_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Transaction History SmartList'].USWHPSTD AS 'Payroll Transaction History SmartList-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Transaction History SmartList'].USWHPSTD = ['Users Master'].USERID
25LSTDTEDT SearchLast Date EditedDT_DateDate46
26LASTUSER SearchLast UserUser_IDString1615
27EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString1615
28INACTIVE SearchInactiveCB_InactiveBoolean20
29LASTNAME SearchLast NameSTR20String2220
30FRSTNAME SearchFirst NameSTR15String1615
31MIDLNAME SearchMiddle NameSTR15String1615
32ADDRESS1 SearchAddress 1STR60String6260
33ADDRESS2 SearchAddress 2STR60String6260
34ADDRESS3 SearchAddress 3STR60String6260
35CITY SearchCitySTR35String3635
36STATE SearchStateSTR30_StateString3029
37COUNTRY SearchCountrySTR60String6260
38ZIPCODE SearchZip CodeSTR10String1210
39PHONNAME SearchPhone NumberPhone_NumberString2214
40SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
41BRTHDATE SearchBirth DateDTDate48
42GENDER SearchGenderDDL_GenderInteger20
43ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger20
44PARTTIME SearchPart TimeCB_Part_TimeBoolean20
45Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean20
46WCACFPAY SearchWhich Cash Account For PayGBInteger20
47ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payroll Transaction History SmartList'].ACTINDX AS 'Payroll Transaction History SmartList-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payroll Transaction History SmartList'].ACTINDX = ['Account Index Master'].ACTINDX
48WKHRPRYR SearchWork Hours Per YearINT4_U0Integer24
49STRTDATE SearchStart DateDTDate48
50DEMPINAC SearchDate Employee InactivatedDTDate48
51RSNEMPIN SearchReason Employee InactivatedSTR30String3230
52MINETPAY SearchMinimum Net PayDLR11_$U2Currency1014
53SUTASTAT SearchSuta StateSTR2_State_CodeString42
54ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean20
55VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer46
56VACCRMTH SearchVacation Accrual MethodGBInteger20
57VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer46
58VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
59ATACRSCK SearchAuto Accrue SickCB_Accrue_SickBoolean20
60STMACMTH SearchSick Time Accrual MethodGBInteger20
61SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer46
62SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
63SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer46
64USERDEF1 SearchUser Defined 1STR20String2220
65USERDEF2 SearchUser Defined 2STR20String2220
66NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Transaction History SmartList'].NOTEINDX AS 'Payroll Transaction History SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Transaction History SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
67EXMFRFED SearchExempt From FederalCB_Exempt_From_Federal_WithholdingBoolean20
68FDFLGSTS SearchFederal Filing StatusSTR6_Payroll_CodeString86
69FEDEXMPT SearchFederal ExemptionsINT2_U0Integer22
70ADFDWHDG SearchAdditional Federal WithholdingDLR11_$S2Currency1014
71ESTFEDWH SearchEstimated Federal WithholdingDLR11_$U2Currency1014
72W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean20
73W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean20
74W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean20
75W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean20
76W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean20
77W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean20
78MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean20
79EICFLGST SearchEIC Filing StatusSTR6_Payroll_CodeString86
80NYTXDiff SearchWithhold NY Tax DiffCB_Withhold_NY_DiffBoolean20
81ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
82ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
83ALTERNATENAME SearchAlternate NameSTR20String2220
84BENADJDATE SearchBen Adj DateDTDate48
85BENEFITEXPIRE_I SearchBenefit ExpireDTDate48
86BIRTHDAY SearchBirth DayINTInteger20
87BIRTHMONTH SearchBirth MonthINTInteger20
88CHANGEBY_I SearchChange BySTR15_User_IDString1615
89CHANGEDATE_I SearchChange DateDTDate48
90CITIZEN SearchCitizenCB_CitizenBoolean20
91DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate48
92DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate48
93DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean20
94DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
95FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
96HANDICAPPED SearchHandicappedCB_HandicapBoolean20
97HRSTATUS SearchHR StatusDDL_HRStatusInteger20
98I9RENEW SearchI9renewDTDate48
99LASTDAYWORKED_I SearchLast Day WorkedDTDate48
100LOCATNID SearchLocation IDSTR15_Location_IDString1615
101MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger20
102NICKNAME SearchNickNameSTR20String2220
103NOTEINDX2 SearchNote Index2DLR14Currency1014
104Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString86
105RATECLSS SearchRate ClassSTR15String1615
106SMOKER_I SearchSmokerCB_SmokerBoolean20
107SPOUSE SearchSpouseSTR15String1615
108SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString1615
109SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString86
110EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger20
111UNIONCD SearchUnion CodeSTR6String86
112UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean20
113VERIFIED SearchVerifiedCB_VerifedBoolean20
114VETERAN SearchVeteranCB_MilitaryBoolean20
115VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean20
116WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean20
117WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean20
118SHFTCODE SearchShift CodeSTR6_Payroll_CodeString86
119SHFTPREM SearchShift PremiumDLR11_$S2Currency1014
120COUNTY SearchCountySTR60String6260
121PHONE1 SearchPhone 1Phone_NumberString2214
122PHONE2 SearchPhone 2Phone_NumberString2214
123PHONE3 SearchPhone 3Phone_Number3String2214
124FAX SearchFaxSTR14_FAXString2214
125Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean20
126Foreign_StateProvince SearchForeign State/ProvinceSTR23String2423
127Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString1615
128CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Payroll Transaction History SmartList'].CCode AS 'Payroll Transaction History SmartList-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Payroll Transaction History SmartList'].CCode = ['VAT Country Code MSTR'].CCode
129DEPRTMNT1 SearchASI_DepartmentSTR6_Payroll_CodeString86
130JOBTITLE1 SearchASI_Job_TitleSTR6_Payroll_CodeString86
131WRKRCOMP1 SearchASI_Workers_CompSTR6_Payroll_CodeString86
132STATECD3 SearchASI_State_CodeSTR2_State_CodeString42
133LOCALTAX1 SearchASI_Local_TaxSTR6_Payroll_CodeString86
134ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean20
135SUTASTAT1 SearchASI_Suta_StateSTR2_State_CodeString42
136TXBLWAGS SearchTaxable WagesDLR11_$S2Currency1014
137DAYSWRDK SearchDays WorkedLI6_S2Long Integer46
138WKSWRKD SearchWeeks WorkedLI6_S2Long Integer46
139SBJTFUTA SearchSubject To FutaCB_FutaBoolean20
140BSDONRTE SearchBased On RateDLR11_$S2Currency1014
141YEAR1 SearchYearYearInteger24
142OTHERVET SearchOther VeteransCB_OtherVetBoolean20
143TIMEAVAILABLE SearchTime AvailableDLR11_S2Currency1011
144CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency1019
azurecurveProductsSmartList (1493)PathnamePayroll Transaction History SmartList (ASIEXP18)

Leave a Reply

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