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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
3EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString1615
4INACTIVE SearchInactiveCB_InactiveBoolean20
5LASTNAME SearchLast NameSTR20String2220
6FRSTNAME SearchFirst NameSTR15String1615
7MIDLNAME SearchMiddle NameSTR15String1615
8ADDRESS1 SearchAddress 1STR60String6260
9ADDRESS2 SearchAddress 2STR60String6260
10ADDRESS3 SearchAddress 3STR60String6260
11CITY SearchCitySTR35String3635
12STATE SearchStateSTR30_StateString3029
13COUNTRY SearchCountrySTR60String6260
14ZIPCODE SearchZip CodeSTR10String1210
15SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
16BRTHDATE SearchBirth DateDTDate48
17GENDER SearchGenderDDL_GenderInteger20
18ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger20
19Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean20
20DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
21JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
22WCACFPAY SearchWhich Cash Account For PayGBInteger20
23ACTINDX SearchAccount IndexLI_14Long Integer414
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_U0Integer24
25STRTDATE SearchStart DateDTDate48
26DEMPINAC SearchDate Employee InactivatedDTDate48
27RSNEMPIN SearchReason Employee InactivatedSTR30String3230
28MINETPAY SearchMinimum Net PayDLR11_$U2Currency1014
29SUTASTAT SearchSuta StateSTR2_State_CodeString42
30WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
31ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean20
32VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer46
33VACCRMTH SearchVacation Accrual MethodGBInteger20
34VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer46
35VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
36ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean20
37STMACMTH SearchSick Time Accrual MethodGBInteger20
38SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer46
39SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
40SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer46
41USERDEF1 SearchUser Defined 1STR20String2220
42USERDEF2 SearchUser Defined 2STR20String2220
43NOTEINDX SearchNote IndexDLR14Currency1014
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_WithholdingBoolean20
45FDFLGSTS SearchFederal Filing StatusSTR6_Payroll_CodeString86
46FEDEXMPT SearchFederal ExemptionsINT2_U0Integer22
47ADFDWHDG SearchAdditional Federal WithholdingDLR11_$S2Currency1014
48ESTFEDWH SearchEstimated Federal WithholdingDLR11_$U2Currency1014
49STATECD SearchState CodeSTR2_State_CodeString42
50LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
51W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean20
52W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean20
53W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean20
54W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean20
55W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean20
56W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean20
57MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean20
58EICFLGST SearchEIC Filing StatusSTR6_Payroll_CodeString86
59NYTXDiff SearchWithhold NY Tax DiffCB_Withhold_NY_DiffBoolean20
60ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
61ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
62ALTERNATENAME SearchAlternate NameSTR20String2220
63BENADJDATE SearchBen Adj DateDTDate48
64BENEFITEXPIRE_I SearchBenefit ExpireDTDate48
65BIRTHDAY SearchBirth DayINTInteger20
66BIRTHMONTH SearchBirth MonthINTInteger20
67CHANGEBY_I SearchChange BySTR15_User_IDString1615
68CHANGEDATE_I SearchChange DateDTDate48
69CITIZEN SearchCitizenCB_CitizenBoolean20
70DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate48
71DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate48
72DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean20
73DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
74FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
75HANDICAPPED SearchHandicappedCB_HandicapBoolean20
76HRSTATUS SearchHR StatusDDL_HRStatusInteger20
77I9RENEW SearchI9renewDTDate48
78LASTDAYWORKED_I SearchLast Day WorkedDTDate48
79LOCATNID SearchLocation IDSTR15_Location_IDString1615
80MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger20
81NICKNAME SearchNickNameSTR20String2220
82NOTEINDX2 SearchNote Index2DLR14Currency1014
83Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString86
84RATECLSS SearchRate ClassSTR15String1615
85SMOKER_I SearchSmokerCB_SmokerBoolean20
86SPOUSE SearchSpouseSTR15String1615
87SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString1615
88SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString86
89EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger20
90UNIONCD SearchUnion CodeSTR6String86
91UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean20
92VERIFIED SearchVerifiedCB_VerifedBoolean20
93VETERAN SearchVeteranCB_MilitaryBoolean20
94VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean20
95WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean20
96WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean20
97COUNTY SearchCountySTR60String6260
98PHONE1 SearchPhone 1Phone_NumberString2214
99PHONE2 SearchPhone 2Phone_NumberString2214
100PHONE3 SearchPhone 3Phone_Number3String2214
101FAX SearchFaxSTR14_FAXString2214
102Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean20
103Foreign_StateProvince SearchForeign State/ProvinceSTR23String2423
104Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString1615
105CCode SearchCountry CodeSTR6_VATString86
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_OtherVetBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

Leave a Reply

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