SmartList Payroll Master (ASIEXP05)

azurecurveProductsSmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Payroll Master
Physical Name: ASIEXP05
Technical Name: ASI_UPR_MSTR_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
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
3EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString15
4INACTIVE SearchInactiveCB_InactiveBoolean0
5LASTNAME SearchLast NameSTR20String20
6FRSTNAME SearchFirst NameSTR15String15
7MIDLNAME SearchMiddle NameSTR15String15
8ADDRESS1 SearchAddress 1STR60String60
9ADDRESS2 SearchAddress 2STR60String60
10ADDRESS3 SearchAddress 3STR60String60
11CITY SearchCitySTR35String35
12STATE SearchStateSTR30_StateString29
13COUNTRY SearchCountrySTR60String60
14ZIPCODE SearchZip CodeSTR10String10
15SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
16BRTHDATE SearchBirth DateDTDate8
17GENDER SearchGenderDDL_GenderInteger0
18ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger0
19Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean0
20DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
21JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
22WCACFPAY SearchWhich Cash Account For PayGBInteger0
23ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payroll Master'].ACTINDX AS 'SmartList Payroll Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP05 AS ['SmartList Payroll Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payroll Master'].ACTINDX = ['Account Index Master'].ACTINDX
24WKHRPRYR SearchWork Hours Per YearINT4_U0Integer4
25STRTDATE SearchStart DateDTDate8
26DEMPINAC SearchDate Employee InactivatedDTDate8
27RSNEMPIN SearchReason Employee InactivatedSTR30String30
28MINETPAY SearchMinimum Net PayDLR11_$U2Currency14
29SUTASTAT SearchSuta StateSTR2_State_CodeString2
30WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
31ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean0
32VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer6
33VACCRMTH SearchVacation Accrual MethodGBInteger0
34VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer6
35VACAVLBL SearchVacation AvailableLI6_S2Long Integer6
36ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean0
37STMACMTH SearchSick Time Accrual MethodGBInteger0
38SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer6
39SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer6
40SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer6
41USERDEF1 SearchUser Defined 1STR20String20
42USERDEF2 SearchUser Defined 2STR20String20
43NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Payroll Master'].NOTEINDX AS 'SmartList Payroll Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP05 AS ['SmartList Payroll Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Payroll Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
44EXMFRFED SearchExempt From FederalCB_Exempt_From_Federal_WithholdingBoolean0
45FDFLGSTS SearchFederal Filing StatusSTR6_Payroll_CodeString6
46FEDEXMPT SearchFederal ExemptionsINT2_U0Integer2
47ADFDWHDG SearchAdditional Federal WithholdingDLR11_$S2Currency14
48ESTFEDWH SearchEstimated Federal WithholdingDLR11_$U2Currency14
49STATECD SearchState CodeSTR2_State_CodeString2
50LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
51W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean0
52W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean0
53W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean0
54W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean0
55W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean0
56W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean0
57MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean0
58EICFLGST SearchEIC Filing StatusSTR6_Payroll_CodeString6
59NYTXDiff SearchWithhold NY Tax DiffCB_Withhold_NY_DiffBoolean0
60ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
61ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
62ALTERNATENAME SearchAlternate NameSTR20String20
63BENADJDATE SearchBen Adj DateDTDate8
64BENEFITEXPIRE_I SearchBenefit ExpireDTDate8
65BIRTHDAY SearchBirth DayINTInteger0
66BIRTHMONTH SearchBirth MonthINTInteger0
67CHANGEBY_I SearchChange BySTR15_User_IDString15
68CHANGEDATE_I SearchChange DateDTDate8
69CITIZEN SearchCitizenCB_CitizenBoolean0
70DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate8
71DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate8
72DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean0
73DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
74FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString10
75HANDICAPPED SearchHandicappedCB_HandicapBoolean0
76HRSTATUS SearchHR StatusDDL_HRStatusInteger0
77I9RENEW SearchI9renewDTDate8
78LASTDAYWORKED_I SearchLast Day WorkedDTDate8
79LOCATNID SearchLocation IDSTR15_Location_IDString15
80MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger0
81NICKNAME SearchNickNameSTR20String20
82NOTEINDX2 SearchNote Index2DLR14Currency14
83Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString6
84RATECLSS SearchRate ClassSTR15String15
85SMOKER_I SearchSmokerCB_SmokerBoolean0
86SPOUSE SearchSpouseSTR15String15
87SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString15
88SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString6
89EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger0
90UNIONCD SearchUnion CodeSTR6String6
91UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean0
92VERIFIED SearchVerifiedCB_VerifedBoolean0
93VETERAN SearchVeteranCB_MilitaryBoolean0
94VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean0
95WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean0
96WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean0
97COUNTY SearchCountySTR60String60
98PHONE1 SearchPhone 1Phone_NumberString14
99PHONE2 SearchPhone 2Phone_NumberString14
100PHONE3 SearchPhone 3Phone_Number3String14
101FAX SearchFaxSTR14_FAXString14
102Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean0
103Foreign_StateProvince SearchForeign State/ProvinceSTR23String23
104Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString15
105CCode SearchCountry CodeSTR6_VATString6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['SmartList Payroll Master'].CCode AS 'SmartList Payroll Master-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       ASIEXP05 AS ['SmartList Payroll Master']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['SmartList Payroll Master'].CCode = ['VAT Country Code MSTR'].CCode
106OTHERVET SearchOther VeteransCB_OtherVetBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

Leave a Reply

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