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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2COMPTRNM SearchComputer TRX NumberLI8_U0Long Integer8
3BACHNUMB SearchBatch NumberSTR15_LBAUString15
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
5COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger0
6UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString6
7TRXBEGDT SearchTRX Beginning DateDTDate8
8TRXENDDT SearchTRX Ending DateDTDate8
9TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
10HRLYPYRT SearchHourly Pay RateDLR11_$U2Currency14
11PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency14
12VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency14
13VARDBPCT SearchVariable Ded/Ben PercentLI8_S5%Long Integer8
14RECEIPTS SearchReceiptsDLR11_$S2Currency14
15DAYSWRDK SearchDays WorkedLI6_S2Long Integer6
16WKSWRKD SearchWeeks WorkedLI6_S2Long Integer6
17DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
18JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
19STATECD SearchState CodeSTR2_State_CodeString2
20LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
21SUTASTAT SearchSuta StateSTR2_State_CodeString2
22WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
23LASTUSER SearchLast UserUser_IDString15
24LSTDTEDT SearchLast Date EditedDT_DateDate6
25TRXSORCE SearchTRX SourceSTR13String13
26DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
27VOIDED SearchVoidedCBBoolean0
28NOTEINDX SearchNote IndexDLR14Currency14
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 Integer10
30EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString15
31INACTIVE SearchInactiveCB_InactiveBoolean0
32LASTNAME SearchLast NameSTR20String20
33FRSTNAME SearchFirst NameSTR15String15
34MIDLNAME SearchMiddle NameSTR15String15
35ADDRESS1 SearchAddress 1STR60String60
36ADDRESS2 SearchAddress 2STR60String60
37ADDRESS3 SearchAddress 3STR60String60
38CITY SearchCitySTR35String35
39STATE SearchStateSTR30_StateString29
40COUNTRY SearchCountrySTR60String60
41ZIPCODE SearchZip CodeSTR10String10
42PHONNAME SearchPhone NumberPhone_NumberString14
43SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
44BRTHDATE SearchBirth DateDTDate8
45GENDER SearchGenderDDL_GenderInteger0
46ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger0
47Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean0
48WCACFPAY SearchWhich Cash Account For PayGBInteger0
49ACTINDX SearchAccount IndexLI_14Long Integer14
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_U0Integer4
51STRTDATE SearchStart DateDTDate8
52DEMPINAC SearchDate Employee InactivatedDTDate8
53RSNEMPIN SearchReason Employee InactivatedSTR30String30
54MINETPAY SearchMinimum Net PayDLR11_$U2Currency14
55ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean0
56VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer6
57VACCRMTH SearchVacation Accrual MethodGBInteger0
58VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer6
59VACAVLBL SearchVacation AvailableLI6_S2Long Integer6
60ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean0
61STMACMTH SearchSick Time Accrual MethodGBInteger0
62SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer6
63SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer6
64SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer6
65USERDEF1 SearchUser Defined 1STR20String20
66USERDEF2 SearchUser Defined 2STR20String20
67EXMFRFED SearchExempt From FederalCB_Exempt_From_Federal_WithholdingBoolean0
68FDFLGSTS SearchFederal Filing StatusSTR6_Payroll_CodeString6
69FEDEXMPT SearchFederal ExemptionsINT2_U0Integer2
70ADFDWHDG SearchAdditional Federal WithholdingDLR11_$S2Currency14
71ESTFEDWH SearchEstimated Federal WithholdingDLR11_$U2Currency14
72W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean0
73W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean0
74W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean0
75W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean0
76W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean0
77W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean0
78MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean0
79EICFLGST SearchEIC Filing StatusSTR6_Payroll_CodeString6
80NYTXDiff SearchWithhold NY Tax DiffCB_Withhold_NY_DiffBoolean0
81ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
82ALTERNATENAME SearchAlternate NameSTR20String20
83BENADJDATE SearchBen Adj DateDTDate8
84BENEFITEXPIRE_I SearchBenefit ExpireDTDate8
85BIRTHDAY SearchBirth DayINTInteger0
86BIRTHMONTH SearchBirth MonthINTInteger0
87CHANGEBY_I SearchChange BySTR15_User_IDString15
88CHANGEDATE_I SearchChange DateDTDate8
89CITIZEN SearchCitizenCB_CitizenBoolean0
90DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate8
91DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate8
92DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean0
93DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
94FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString10
95HANDICAPPED SearchHandicappedCB_HandicapBoolean0
96HRSTATUS SearchHR StatusDDL_HRStatusInteger0
97I9RENEW SearchI9renewDTDate8
98LASTDAYWORKED_I SearchLast Day WorkedDTDate8
99LOCATNID SearchLocation IDSTR15_Location_IDString15
100MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger0
101NICKNAME SearchNickNameSTR20String20
102NOTEINDX2 SearchNote Index2DLR14Currency14
103Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString6
104RATECLSS SearchRate ClassSTR15String15
105SMOKER_I SearchSmokerCB_SmokerBoolean0
106SPOUSE SearchSpouseSTR15String15
107SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString15
108SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString6
109EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger0
110UNIONCD SearchUnion CodeSTR6String6
111UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean0
112VERIFIED SearchVerifiedCB_VerifedBoolean0
113VETERAN SearchVeteranCB_MilitaryBoolean0
114VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean0
115WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean0
116WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean0
117INADDNTOSAL SearchIn Addition To SalaryCB_In_Addition_To_SalaryBoolean0
118JOBNUMBR SearchJob NumberSTR17_LBAUString17
119SALCHG SearchSalary ChangeDDL_Salary_ChangeInteger0
120COUNTY SearchCountySTR60String60
121PHONE1 SearchPhone 1Phone_NumberString14
122PHONE2 SearchPhone 2Phone_NumberString14
123PHONE3 SearchPhone 3Phone_Number3String14
124FAX SearchFaxSTR14_FAXString14
125Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean0
126Foreign_StateProvince SearchForeign State/ProvinceSTR23String23
127Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString15
128CCode SearchCountry CodeSTR6_VATString6
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_CodeString6
130SHFTPREM SearchShift PremiumDLR11_$S2Currency14
131DEPRTMNT1 SearchASI_DepartmentSTR6_Payroll_CodeString6
132JOBTITLE1 SearchASI_Job_TitleSTR6_Payroll_CodeString6
133SUTASTAT1 SearchASI_Suta_StateSTR2_State_CodeString2
134WRKRCOMP1 SearchASI_Workers_CompSTR6_Payroll_CodeString6
135NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
136STATECD3 SearchASI_State_CodeSTR2_State_CodeString2
137LOCALTAX1 SearchASI_Local_TaxSTR6_Payroll_CodeString6
138UNIONCD1 SearchASI_Union_CodeSTR6String6
139OTHERVET SearchOther VeteransCB_OtherVetBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Transactions (ASIEXP10)

Leave a Reply

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