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: Pathname

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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2COMPTRNM SearchComputer TRX NumberLI8_U0Long Integer48
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
5COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger20
6UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
7TRXBEGDT SearchTRX Beginning DateDTDate48
8TRXENDDT SearchTRX Ending DateDTDate48
9TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
10HRLYPYRT SearchHourly Pay RateDLR11_$U2Currency1014
11PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency1014
12VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency1014
13VARDBPCT SearchVariable Ded/Ben PercentLI8_S5%Long Integer48
14RECEIPTS SearchReceiptsDLR11_$S2Currency1014
15DAYSWRDK SearchDays WorkedLI6_S2Long Integer46
16WKSWRKD SearchWeeks WorkedLI6_S2Long Integer46
17DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
18JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
19STATECD SearchState CodeSTR2_State_CodeString42
20LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
21SUTASTAT SearchSuta StateSTR2_State_CodeString42
22WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
23LASTUSER SearchLast UserUser_IDString1615
24LSTDTEDT SearchLast Date EditedDT_DateDate46
25TRXSORCE SearchTRX SourceSTR13String1413
26DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
27VOIDED SearchVoidedCBBoolean20
28NOTEINDX SearchNote IndexDLR14Currency1014
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_SequenceASI_LI_10_RULong Integer410
30EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString1615
31INACTIVE SearchInactiveCB_InactiveBoolean20
32LASTNAME SearchLast NameSTR20String2220
33FRSTNAME SearchFirst NameSTR15String1615
34MIDLNAME SearchMiddle NameSTR15String1615
35ADDRESS1 SearchAddress 1STR60String6260
36ADDRESS2 SearchAddress 2STR60String6260
37ADDRESS3 SearchAddress 3STR60String6260
38CITY SearchCitySTR35String3635
39STATE SearchStateSTR30_StateString3029
40COUNTRY SearchCountrySTR60String6260
41ZIPCODE SearchZip CodeSTR10String1210
42PHONNAME SearchPhone NumberPhone_NumberString2214
43SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
44BRTHDATE SearchBirth DateDTDate48
45GENDER SearchGenderDDL_GenderInteger20
46ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger20
47Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean20
48WCACFPAY SearchWhich Cash Account For PayGBInteger20
49ACTINDX SearchAccount IndexLI_14Long Integer414
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 YearINT4_U0Integer24
51STRTDATE SearchStart DateDTDate48
52DEMPINAC SearchDate Employee InactivatedDTDate48
53RSNEMPIN SearchReason Employee InactivatedSTR30String3230
54MINETPAY SearchMinimum Net PayDLR11_$U2Currency1014
55ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean20
56VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer46
57VACCRMTH SearchVacation Accrual MethodGBInteger20
58VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer46
59VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
60ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean20
61STMACMTH SearchSick Time Accrual MethodGBInteger20
62SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer46
63SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
64SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer46
65USERDEF1 SearchUser Defined 1STR20String2220
66USERDEF2 SearchUser Defined 2STR20String2220
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
81ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
82ALTERNATENAME SearchAlternate NameSTR20String2220
83BENADJDATE SearchBen Adj DateDTDate48
84BENEFITEXPIRE_I SearchBenefit ExpireDTDate48
85BIRTHDAY SearchBirth DayINTInteger20
86BIRTHMONTH SearchBirth MonthINTInteger20
87CHANGEBY_I SearchChange BySTR15_User_IDString1615
88CHANGEDATE_I SearchChange DateDTDate48
89CITIZEN SearchCitizenCB_CitizenBoolean20
90DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate48
91DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate48
92DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean20
93DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
94FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
95HANDICAPPED SearchHandicappedCB_HandicapBoolean20
96HRSTATUS SearchHR StatusDDL_HRStatusInteger20
97I9RENEW SearchI9renewDTDate48
98LASTDAYWORKED_I SearchLast Day WorkedDTDate48
99LOCATNID SearchLocation IDSTR15_Location_IDString1615
100MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger20
101NICKNAME SearchNickNameSTR20String2220
102NOTEINDX2 SearchNote Index2DLR14Currency1014
103Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString86
104RATECLSS SearchRate ClassSTR15String1615
105SMOKER_I SearchSmokerCB_SmokerBoolean20
106SPOUSE SearchSpouseSTR15String1615
107SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString1615
108SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString86
109EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger20
110UNIONCD SearchUnion CodeSTR6String86
111UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean20
112VERIFIED SearchVerifiedCB_VerifedBoolean20
113VETERAN SearchVeteranCB_MilitaryBoolean20
114VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean20
115WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean20
116WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean20
117INADDNTOSAL SearchIn Addition To SalaryCB_In_Addition_To_SalaryBoolean20
118JOBNUMBR SearchJob NumberSTR17_LBAUString1817
119SALCHG SearchSalary ChangeDDL_Salary_ChangeInteger20
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
       ['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 CodeSTR6_Payroll_CodeString86
130SHFTPREM SearchShift PremiumDLR11_$S2Currency1014
131DEPRTMNT1 SearchASI_DepartmentSTR6_Payroll_CodeString86
132JOBTITLE1 SearchASI_Job_TitleSTR6_Payroll_CodeString86
133SUTASTAT1 SearchASI_Suta_StateSTR2_State_CodeString42
134WRKRCOMP1 SearchASI_Workers_CompSTR6_Payroll_CodeString86
135NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
136STATECD3 SearchASI_State_CodeSTR2_State_CodeString42
137LOCALTAX1 SearchASI_Local_TaxSTR6_Payroll_CodeString86
138UNIONCD1 SearchASI_Union_CodeSTR6String86
139OTHERVET SearchOther VeteransCB_OtherVetBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Transactions (ASIEXP10)

Leave a Reply

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