SmartList Payroll Transactions (ASIEXP10)

azurecurveProductsSmartList (1493)PathnameSmartList Payroll Transactions (ASIEXP10)

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

Product: SmartList (1493)
Series:

Display Name: SmartList Payroll Transactions
Physical Name: ASIEXP10
Technical Name: ASI_US_Payroll_Transaction_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2COMPTRNM SearchComputer TRX NumberLong IntegerLI8_U08
3BACHNUMB SearchBatch NumberStringSTR15_LBAU15
4EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
5COMPTRTP SearchComputer TRX TypeIntegerDDL_TRX_Type0
6UPRTRXCD SearchUPR TRX CodeStringSTR6_Payroll_Code6
7TRXBEGDT SearchTRX Beginning DateDateDT8
8TRXENDDT SearchTRX Ending DateDateDT8
9TRXHRUNT SearchTRX Hours/UnitsLong IntegerLI6_S26
10HRLYPYRT SearchHourly Pay RateCurrencyDLR11_$U214
11PAYRTAMT SearchPay Rate AmountCurrencyDLR11_$S214
12VARDBAMT SearchVariable Ded/Ben AmountCurrencyDLR11_$S214
13VARDBPCT SearchVariable Ded/Ben PercentLong IntegerLI8_S5%8
14RECEIPTS SearchReceiptsCurrencyDLR11_$S214
15DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
16WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
17DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
18JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
19STATECD SearchState CodeStringSTR2_State_Code2
20LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
21SUTASTAT SearchSuta StateStringSTR2_State_Code2
22WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
23LASTUSER SearchLast UserStringUser_ID15
24LSTDTEDT SearchLast Date EditedDateDT_Date6
25TRXSORCE SearchTRX SourceStringSTR1313
26DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
27VOIDED SearchVoidedBooleanCB0
28NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Payroll Transactions'].NOTEINDX AS 'SmartList Payroll Transactions-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP10 AS ['SmartList Payroll Transactions']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Payroll Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
30EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
31INACTIVE SearchInactiveBooleanCB_Inactive0
32LASTNAME SearchLast NameStringSTR2020
33FRSTNAME SearchFirst NameStringSTR1515
34MIDLNAME SearchMiddle NameStringSTR1515
35ADDRESS1 SearchAddress 1StringSTR6060
36ADDRESS2 SearchAddress 2StringSTR6060
37ADDRESS3 SearchAddress 3StringSTR6060
38CITY SearchCityStringSTR3535
39STATE SearchStateStringSTR30_State29
40COUNTRY SearchCountryStringSTR6060
41ZIPCODE SearchZip CodeStringSTR1010
42PHONNAME SearchPhone NumberStringPhone_Number14
43SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
44BRTHDATE SearchBirth DateDateDT8
45GENDER SearchGenderIntegerDDL_Gender0
46ETHNORGN SearchEthnic OriginIntegerDDL_Ethnic Origin0
47Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
48WCACFPAY SearchWhich Cash Account For PayIntegerGB0
49ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payroll Transactions'].ACTINDX AS 'SmartList Payroll Transactions-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP10 AS ['SmartList Payroll Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payroll Transactions'].ACTINDX = ['Account Index Master'].ACTINDX
50WKHRPRYR SearchWork Hours Per YearIntegerINT4_U04
51STRTDATE SearchStart DateDateDT8
52DEMPINAC SearchDate Employee InactivatedDateDT8
53RSNEMPIN SearchReason Employee InactivatedStringSTR3030
54MINETPAY SearchMinimum Net PayCurrencyDLR11_$U214
55ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
56VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
57VACCRMTH SearchVacation Accrual MethodIntegerGB0
58VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
59VACAVLBL SearchVacation AvailableLong IntegerLI6_S26
60ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
61STMACMTH SearchSick Time Accrual MethodIntegerGB0
62SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
63SIKTIMAV SearchSick Time AvailableLong IntegerLI6_S26
64SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
65USERDEF1 SearchUser Defined 1StringSTR2020
66USERDEF2 SearchUser Defined 2StringSTR2020
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
81ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
82ALTERNATENAME SearchAlternate NameStringSTR2020
83BENADJDATE SearchBen Adj DateDateDT8
84BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
85BIRTHDAY SearchBirth DayIntegerINT0
86BIRTHMONTH SearchBirth MonthIntegerINT0
87CHANGEBY_I SearchChange ByStringSTR15_User_ID15
88CHANGEDATE_I SearchChange DateDateDT8
89CITIZEN SearchCitizenBooleanCB_Citizen0
90DATEOFLASTREVIEW_I SearchDate Of Last ReviewDateDT8
91DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDateDT8
92DISABLEDVETERAN SearchDisabled VeteranBooleanCB_DisableVet0
93DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
94FEDCLSSCD SearchFederal Classification CodeStringSTR10_LBAU10
95HANDICAPPED SearchHandicappedBooleanCB_Handicap0
96HRSTATUS SearchHR StatusIntegerDDL_HRStatus0
97I9RENEW SearchI9renewDateDT8
98LASTDAYWORKED_I SearchLast Day WorkedDateDT8
99LOCATNID SearchLocation IDStringSTR15_Location_ID15
100MARITALSTATUS SearchMaritalStatusIntegerDDL_MaritalStatus0
101NICKNAME SearchNickNameStringSTR2020
102NOTEINDX2 SearchNote Index2CurrencyDLR1414
103Primary_Pay_Record SearchPrimary Pay RecordStringSTR6_Payroll_Code6
104RATECLSS SearchRate ClassStringSTR1515
105SMOKER_I SearchSmokerBooleanCB_Smoker0
106SPOUSE SearchSpouseStringSTR1515
107SPOUSESSN SearchSpouse SSNStringSTR15_Social_Security_Number15
108SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
109EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
110UNIONCD SearchUnion CodeStringSTR66
111UNIONEMPLOYEE SearchUnion EmployeeBooleanCB_Union_Emp0
112VERIFIED SearchVerifiedBooleanCB_Verifed0
113VETERAN SearchVeteranBooleanCB_Military0
114VIETNAMVETERAN SearchVietnam VeteranBooleanCB_Vietnam0
115WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
116WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
117INADDNTOSAL SearchIn Addition To SalaryBooleanCB_In_Addition_To_Salary0
118JOBNUMBR SearchJob NumberStringSTR17_LBAU17
119SALCHG SearchSalary ChangeIntegerDDL_Salary_Change0
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
       ['SmartList Payroll Transactions'].CCode AS 'SmartList Payroll Transactions-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       ASIEXP10 AS ['SmartList Payroll Transactions']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['SmartList Payroll Transactions'].CCode = ['VAT Country Code MSTR'].CCode
129SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
130SHFTPREM SearchShift PremiumCurrencyDLR11_$S214
131DEPRTMNT1 SearchASI_DepartmentStringSTR6_Payroll_Code6
132JOBTITLE1 SearchASI_Job_TitleStringSTR6_Payroll_Code6
133SUTASTAT1 SearchASI_Suta_StateStringSTR2_State_Code2
134WRKRCOMP1 SearchASI_Workers_CompStringSTR6_Payroll_Code6
135NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
136STATECD3 SearchASI_State_CodeStringSTR2_State_Code2
137LOCALTAX1 SearchASI_Local_TaxStringSTR6_Payroll_Code6
138UNIONCD1 SearchASI_Union_CodeStringSTR66
139OTHERVET SearchOther VeteransBooleanCB_OtherVet0
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Transactions (ASIEXP10)

Leave a Reply

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