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:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2AUCTRLCD SearchAudit Control CodeStringSTR13_LBAU13
3EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
4CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
5PYADNMBR SearchPayment/Adjustment NumberLong IntegerLI8_U08
6TRXSORCE SearchTRX SourceStringSTR1313
7DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
8DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
9JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
10PYRLRTYP SearchPayroll Record TypeIntegerDDL_Payroll_Record_Type0
11PAYROLCD SearchPayroll CodeStringSTR6_Payroll_Code6
12TRXBEGDT SearchTRX Beginning DateDateDT8
13TRXENDDT SearchTRX Ending DateDateDT8
14UNTSTOPY SearchUnits To PayCurrencyDLR11_S211
15PAYRATE SearchPay RateCurrencyDLR11_$S214
16UPRTRXAM SearchUPR TRX AmountCurrencyDLR11_$S214
17TipType SearchTip TypeIntegerDDL_Type_of_Tips0
18RECEIPTS SearchReceiptsCurrencyDLR11_$S214
19PAYADVNC SearchPay AdvanceCurrencyDLR11_$U214
20STATECD SearchState CodeStringSTR2_State_Code2
21LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
22WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
23CHEKDATE SearchCheck DateDateDATE6
24USWHPSTD SearchUser Who PostedStringUser_ID15
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 EditedDateDT_Date6
26LASTUSER SearchLast UserStringUser_ID15
27EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
28INACTIVE SearchInactiveBooleanCB_Inactive0
29LASTNAME SearchLast NameStringSTR2020
30FRSTNAME SearchFirst NameStringSTR1515
31MIDLNAME SearchMiddle NameStringSTR1515
32ADDRESS1 SearchAddress 1StringSTR6060
33ADDRESS2 SearchAddress 2StringSTR6060
34ADDRESS3 SearchAddress 3StringSTR6060
35CITY SearchCityStringSTR3535
36STATE SearchStateStringSTR30_State29
37COUNTRY SearchCountryStringSTR6060
38ZIPCODE SearchZip CodeStringSTR1010
39PHONNAME SearchPhone NumberStringPhone_Number14
40SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
41BRTHDATE SearchBirth DateDateDT8
42GENDER SearchGenderIntegerDDL_Gender0
43ETHNORGN SearchEthnic OriginIntegerDDL_Ethnic Origin0
44PARTTIME SearchPart TimeBooleanCB_Part_Time0
45Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
46WCACFPAY SearchWhich Cash Account For PayIntegerGB0
47ACTINDX SearchAccount IndexLong IntegerLI_1414
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 YearIntegerINT4_U04
49STRTDATE SearchStart DateDateDT8
50DEMPINAC SearchDate Employee InactivatedDateDT8
51RSNEMPIN SearchReason Employee InactivatedStringSTR3030
52MINETPAY SearchMinimum Net PayCurrencyDLR11_$U214
53SUTASTAT SearchSuta StateStringSTR2_State_Code2
54ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
55VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
56VACCRMTH SearchVacation Accrual MethodIntegerGB0
57VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
58VACAVLBL SearchVacation AvailableLong IntegerLI6_S26
59ATACRSCK SearchAuto Accrue SickBooleanCB_Accrue_Sick0
60STMACMTH SearchSick Time Accrual MethodIntegerGB0
61SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
62SIKTIMAV SearchSick Time AvailableLong IntegerLI6_S26
63SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
64USERDEF1 SearchUser Defined 1StringSTR2020
65USERDEF2 SearchUser Defined 2StringSTR2020
66NOTEINDX SearchNote IndexCurrencyDLR1414
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 FederalBooleanCB_Exempt_From_Federal_Withholding0
68FDFLGSTS SearchFederal Filing StatusStringSTR6_Payroll_Code6
69FEDEXMPT SearchFederal ExemptionsIntegerINT2_U02
70ADFDWHDG SearchAdditional Federal WithholdingCurrencyDLR11_$S214
71ESTFEDWH SearchEstimated Federal WithholdingCurrencyDLR11_$U214
72W2BF942E SearchW2 Box For 942 EmployeeBooleanCB_942_Employee0
73W2BFDCSD SearchW2 Box For DeceasedBooleanCB_Deceased0
74W2BFDCMP SearchW2 Box For Deferred CompensationBooleanCB_Deferred_Compensation0
75W2BFLREP SearchW2 Box For Legal RepresentativeBooleanCB_Legal_Representative0
76W2BFPPLN SearchW2 Box For Pension PlanBooleanCB_Pension_Plan0
77W2BFSTEM SearchW2 Box For Statutory EmployeeBooleanCB_Statutory_Employee0
78MCRQGEMP SearchMedicare Qualified Govt EmployeeBooleanCB_Medicare_Qualified_Govt_Employee0
79EICFLGST SearchEIC Filing StatusStringSTR6_Payroll_Code6
80NYTXDiff SearchWithhold NY Tax DiffBooleanCB_Withhold_NY_Diff0
81ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
82ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
83ALTERNATENAME SearchAlternate NameStringSTR2020
84BENADJDATE SearchBen Adj DateDateDT8
85BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
86BIRTHDAY SearchBirth DayIntegerINT0
87BIRTHMONTH SearchBirth MonthIntegerINT0
88CHANGEBY_I SearchChange ByStringSTR15_User_ID15
89CHANGEDATE_I SearchChange DateDateDT8
90CITIZEN SearchCitizenBooleanCB_Citizen0
91DATEOFLASTREVIEW_I SearchDate Of Last ReviewDateDT8
92DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDateDT8
93DISABLEDVETERAN SearchDisabled VeteranBooleanCB_DisableVet0
94DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
95FEDCLSSCD SearchFederal Classification CodeStringSTR10_LBAU10
96HANDICAPPED SearchHandicappedBooleanCB_Handicap0
97HRSTATUS SearchHR StatusIntegerDDL_HRStatus0
98I9RENEW SearchI9renewDateDT8
99LASTDAYWORKED_I SearchLast Day WorkedDateDT8
100LOCATNID SearchLocation IDStringSTR15_Location_ID15
101MARITALSTATUS SearchMaritalStatusIntegerDDL_MaritalStatus0
102NICKNAME SearchNickNameStringSTR2020
103NOTEINDX2 SearchNote Index2CurrencyDLR1414
104Primary_Pay_Record SearchPrimary Pay RecordStringSTR6_Payroll_Code6
105RATECLSS SearchRate ClassStringSTR1515
106SMOKER_I SearchSmokerBooleanCB_Smoker0
107SPOUSE SearchSpouseStringSTR1515
108SPOUSESSN SearchSpouse SSNStringSTR15_Social_Security_Number15
109SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
110EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
111UNIONCD SearchUnion CodeStringSTR66
112UNIONEMPLOYEE SearchUnion EmployeeBooleanCB_Union_Emp0
113VERIFIED SearchVerifiedBooleanCB_Verifed0
114VETERAN SearchVeteranBooleanCB_Military0
115VIETNAMVETERAN SearchVietnam VeteranBooleanCB_Vietnam0
116WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
117WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
118SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
119SHFTPREM SearchShift PremiumCurrencyDLR11_$S214
120COUNTY SearchCountyStringSTR6060
121PHONE1 SearchPhone 1StringPhone_Number14
122PHONE2 SearchPhone 2StringPhone_Number14
123PHONE3 SearchPhone 3StringPhone_Number314
124FAX SearchFaxStringSTR14_FAX14
125Foreign_Address SearchForeign AddressBooleanCB_Foreign_Address0
126Foreign_StateProvince SearchForeign State/ProvinceStringSTR2323
127Foreign_Postal_Code SearchForeign Postal CodeStringSTR15_LBAU15
128CCode SearchCountry CodeStringSTR6_VAT6
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_DepartmentStringSTR6_Payroll_Code6
130JOBTITLE1 SearchASI_Job_TitleStringSTR6_Payroll_Code6
131WRKRCOMP1 SearchASI_Workers_CompStringSTR6_Payroll_Code6
132STATECD3 SearchASI_State_CodeStringSTR2_State_Code2
133LOCALTAX1 SearchASI_Local_TaxStringSTR6_Payroll_Code6
134ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
135SUTASTAT1 SearchASI_Suta_StateStringSTR2_State_Code2
136TXBLWAGS SearchTaxable WagesCurrencyDLR11_$S214
137DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
138WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
139SBJTFUTA SearchSubject To FutaBooleanCB_Futa0
140BSDONRTE SearchBased On RateCurrencyDLR11_$S214
141YEAR1 SearchYearIntegerYear4
142OTHERVET SearchOther VeteransBooleanCB_OtherVet0
143TIMEAVAILABLE SearchTime AvailableCurrencyDLR11_S211
144CMRECNUM SearchRecord NumberCurrencyDLR_Document_Number19
azurecurveProductsSmartList (1493)PathnamePayroll Transaction History SmartList (ASIEXP18)

Leave a Reply

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