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:

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_ByLong IntegerLI_1414
2EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
3EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
4INACTIVE SearchInactiveBooleanCB_Inactive0
5LASTNAME SearchLast NameStringSTR2020
6FRSTNAME SearchFirst NameStringSTR1515
7MIDLNAME SearchMiddle NameStringSTR1515
8ADDRESS1 SearchAddress 1StringSTR6060
9ADDRESS2 SearchAddress 2StringSTR6060
10ADDRESS3 SearchAddress 3StringSTR6060
11CITY SearchCityStringSTR3535
12STATE SearchStateStringSTR30_State29
13COUNTRY SearchCountryStringSTR6060
14ZIPCODE SearchZip CodeStringSTR1010
15SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
16BRTHDATE SearchBirth DateDateDT8
17GENDER SearchGenderIntegerDDL_Gender0
18ETHNORGN SearchEthnic OriginIntegerDDL_Ethnic Origin0
19Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
20DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
21JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
22WCACFPAY SearchWhich Cash Account For PayIntegerGB0
23ACTINDX SearchAccount IndexLong IntegerLI_1414
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 YearIntegerINT4_U04
25STRTDATE SearchStart DateDateDT8
26DEMPINAC SearchDate Employee InactivatedDateDT8
27RSNEMPIN SearchReason Employee InactivatedStringSTR3030
28MINETPAY SearchMinimum Net PayCurrencyDLR11_$U214
29SUTASTAT SearchSuta StateStringSTR2_State_Code2
30WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
31ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
32VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
33VACCRMTH SearchVacation Accrual MethodIntegerGB0
34VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
35VACAVLBL SearchVacation AvailableLong IntegerLI6_S26
36ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
37STMACMTH SearchSick Time Accrual MethodIntegerGB0
38SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
39SIKTIMAV SearchSick Time AvailableLong IntegerLI6_S26
40SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
41USERDEF1 SearchUser Defined 1StringSTR2020
42USERDEF2 SearchUser Defined 2StringSTR2020
43NOTEINDX SearchNote IndexCurrencyDLR1414
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 FederalBooleanCB_Exempt_From_Federal_Withholding0
45FDFLGSTS SearchFederal Filing StatusStringSTR6_Payroll_Code6
46FEDEXMPT SearchFederal ExemptionsIntegerINT2_U02
47ADFDWHDG SearchAdditional Federal WithholdingCurrencyDLR11_$S214
48ESTFEDWH SearchEstimated Federal WithholdingCurrencyDLR11_$U214
49STATECD SearchState CodeStringSTR2_State_Code2
50LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
51W2BF942E SearchW2 Box For 942 EmployeeBooleanCB_942_Employee0
52W2BFDCSD SearchW2 Box For DeceasedBooleanCB_Deceased0
53W2BFDCMP SearchW2 Box For Deferred CompensationBooleanCB_Deferred_Compensation0
54W2BFLREP SearchW2 Box For Legal RepresentativeBooleanCB_Legal_Representative0
55W2BFPPLN SearchW2 Box For Pension PlanBooleanCB_Pension_Plan0
56W2BFSTEM SearchW2 Box For Statutory EmployeeBooleanCB_Statutory_Employee0
57MCRQGEMP SearchMedicare Qualified Govt EmployeeBooleanCB_Medicare_Qualified_Govt_Employee0
58EICFLGST SearchEIC Filing StatusStringSTR6_Payroll_Code6
59NYTXDiff SearchWithhold NY Tax DiffBooleanCB_Withhold_NY_Diff0
60ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
61ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
62ALTERNATENAME SearchAlternate NameStringSTR2020
63BENADJDATE SearchBen Adj DateDateDT8
64BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
65BIRTHDAY SearchBirth DayIntegerINT0
66BIRTHMONTH SearchBirth MonthIntegerINT0
67CHANGEBY_I SearchChange ByStringSTR15_User_ID15
68CHANGEDATE_I SearchChange DateDateDT8
69CITIZEN SearchCitizenBooleanCB_Citizen0
70DATEOFLASTREVIEW_I SearchDate Of Last ReviewDateDT8
71DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDateDT8
72DISABLEDVETERAN SearchDisabled VeteranBooleanCB_DisableVet0
73DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
74FEDCLSSCD SearchFederal Classification CodeStringSTR10_LBAU10
75HANDICAPPED SearchHandicappedBooleanCB_Handicap0
76HRSTATUS SearchHR StatusIntegerDDL_HRStatus0
77I9RENEW SearchI9renewDateDT8
78LASTDAYWORKED_I SearchLast Day WorkedDateDT8
79LOCATNID SearchLocation IDStringSTR15_Location_ID15
80MARITALSTATUS SearchMaritalStatusIntegerDDL_MaritalStatus0
81NICKNAME SearchNickNameStringSTR2020
82NOTEINDX2 SearchNote Index2CurrencyDLR1414
83Primary_Pay_Record SearchPrimary Pay RecordStringSTR6_Payroll_Code6
84RATECLSS SearchRate ClassStringSTR1515
85SMOKER_I SearchSmokerBooleanCB_Smoker0
86SPOUSE SearchSpouseStringSTR1515
87SPOUSESSN SearchSpouse SSNStringSTR15_Social_Security_Number15
88SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
89EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
90UNIONCD SearchUnion CodeStringSTR66
91UNIONEMPLOYEE SearchUnion EmployeeBooleanCB_Union_Emp0
92VERIFIED SearchVerifiedBooleanCB_Verifed0
93VETERAN SearchVeteranBooleanCB_Military0
94VIETNAMVETERAN SearchVietnam VeteranBooleanCB_Vietnam0
95WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
96WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
97COUNTY SearchCountyStringSTR6060
98PHONE1 SearchPhone 1StringPhone_Number14
99PHONE2 SearchPhone 2StringPhone_Number14
100PHONE3 SearchPhone 3StringPhone_Number314
101FAX SearchFaxStringSTR14_FAX14
102Foreign_Address SearchForeign AddressBooleanCB_Foreign_Address0
103Foreign_StateProvince SearchForeign State/ProvinceStringSTR2323
104Foreign_Postal_Code SearchForeign Postal CodeStringSTR15_LBAU15
105CCode SearchCountry CodeStringSTR6_VAT6
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 VeteransBooleanCB_OtherVet0
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

Leave a Reply

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