Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP18
Product: SmartList (1493)
Series:
Display Name: Payroll Transaction History SmartList
Physical Name: ASIEXP18
Technical Name: ASI_UPR_Transaction_HIST_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Order_By 
ASI_Order_By Long Integer LI_14 14 2 AUCTRLCD Audit Control Code String STR13_LBAU 13 3 EMPLOYID Employee ID String STR15_Employee_ID 15 4 CHEKNMBR Check Number String STR20_Document_Number 20 5 PYADNMBR Payment/Adjustment Number Long Integer LI8_U0 8 6 TRXSORCE TRX Source String STR13 13 7 DOCTYPE Document Type Integer DDL_Document_Type 0 8 DEPRTMNT Department String STR6_Payroll_Code 6 9 JOBTITLE Job Title String STR6_Payroll_Code 6 10 PYRLRTYP Payroll Record Type Integer DDL_Payroll_Record_Type 0 11 PAYROLCD Payroll Code String STR6_Payroll_Code 6 12 TRXBEGDT TRX Beginning Date Date DT 8 13 TRXENDDT TRX Ending Date Date DT 8 14 UNTSTOPY Units To Pay Currency DLR11_S2 11 15 PAYRATE Pay Rate Currency DLR11_$S2 14 16 UPRTRXAM UPR TRX Amount Currency DLR11_$S2 14 17 TipType Tip Type Integer DDL_Type_of_Tips 0 18 RECEIPTS Receipts Currency DLR11_$S2 14 19 PAYADVNC Pay Advance Currency DLR11_$U2 14 20 STATECD State Code String STR2_State_Code 2 21 LOCALTAX Local Tax String STR6_Payroll_Code 6 22 WRKRCOMP Workers Comp String STR6_Payroll_Code 6 23 CHEKDATE Check Date Date DATE 6 24 USWHPSTD User Who Posted String User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Payroll Transaction History SmartList'].USWHPSTD AS 'Payroll Transaction History SmartList-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Payroll Transaction History SmartList'].USWHPSTD = ['Users Master'].USERID25 LSTDTEDT Last Date Edited Date DT_Date 6 26 LASTUSER Last User String User_ID 15 27 EMPLCLAS Employee Class String STR15_Employee_Class 15 28 INACTIVE Inactive Boolean CB_Inactive 0 29 LASTNAME Last Name String STR20 20 30 FRSTNAME First Name String STR15 15 31 MIDLNAME Middle Name String STR15 15 32 ADDRESS1 Address 1 String STR60 60 33 ADDRESS2 Address 2 String STR60 60 34 ADDRESS3 Address 3 String STR60 60 35 CITY City String STR35 35 36 STATE State String STR30_State 29 37 COUNTRY Country String STR60 60 38 ZIPCODE Zip Code String STR10 10 39 PHONNAME Phone Number String Phone_Number 14 40 SOCSCNUM Social Security Number String STR15_Social_Security_Number 15 41 BRTHDATE Birth Date Date DT 8 42 GENDER Gender Integer DDL_Gender 0 43 ETHNORGN Ethnic Origin Integer DDL_Ethnic Origin 0 44 PARTTIME Part Time Boolean CB_Part_Time 0 45 Calc_Min_Wage_Bal Calc Min Wage Bal Boolean CB_CalcMinWageBal 0 46 WCACFPAY Which Cash Account For Pay Integer GB 0 47 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Payroll Transaction History SmartList'].ACTINDX AS 'Payroll Transaction History SmartList-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Payroll Transaction History SmartList'].ACTINDX = ['Account Index Master'].ACTINDX48 WKHRPRYR Work Hours Per Year Integer INT4_U0 4 49 STRTDATE Start Date Date DT 8 50 DEMPINAC Date Employee Inactivated Date DT 8 51 RSNEMPIN Reason Employee Inactivated String STR30 30 52 MINETPAY Minimum Net Pay Currency DLR11_$U2 14 53 SUTASTAT Suta State String STR2_State_Code 2 54 ATACRVAC Auto Accrue Vacation Boolean CB_Accrue_Vacation: 0 55 VACCRAMT Vacation Accrual Amount Long Integer LI6_U2 6 56 VACCRMTH Vacation Accrual Method Integer GB 0 57 VACAPRYR Vacation Hours Per Year Long Integer LI6_U2 6 58 VACAVLBL Vacation Available Long Integer LI6_S2 6 59 ATACRSCK Auto Accrue Sick Boolean CB_Accrue_Sick 0 60 STMACMTH Sick Time Accrual Method Integer GB 0 61 SKTMACAM Sick Time Accrual Amount Long Integer LI6_U2 6 62 SIKTIMAV Sick Time Available Long Integer LI6_S2 6 63 SKTMHPYR Sick Time Hours Per Year Long Integer LI6_U2 6 64 USERDEF1 User Defined 1 String STR20 20 65 USERDEF2 User Defined 2 String STR20 20 66 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Payroll Transaction History SmartList'].NOTEINDX AS 'Payroll Transaction History SmartList-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Transaction History SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX67 EXMFRFED Exempt From Federal Boolean CB_Exempt_From_Federal_Withholding 0 68 FDFLGSTS Federal Filing Status String STR6_Payroll_Code 6 69 FEDEXMPT Federal Exemptions Integer INT2_U0 2 70 ADFDWHDG Additional Federal Withholding Currency DLR11_$S2 14 71 ESTFEDWH Estimated Federal Withholding Currency DLR11_$U2 14 72 W2BF942E W2 Box For 942 Employee Boolean CB_942_Employee 0 73 W2BFDCSD W2 Box For Deceased Boolean CB_Deceased 0 74 W2BFDCMP W2 Box For Deferred Compensation Boolean CB_Deferred_Compensation 0 75 W2BFLREP W2 Box For Legal Representative Boolean CB_Legal_Representative 0 76 W2BFPPLN W2 Box For Pension Plan Boolean CB_Pension_Plan 0 77 W2BFSTEM W2 Box For Statutory Employee Boolean CB_Statutory_Employee 0 78 MCRQGEMP Medicare Qualified Govt Employee Boolean CB_Medicare_Qualified_Govt_Employee 0 79 EICFLGST EIC Filing Status String STR6_Payroll_Code 6 80 NYTXDiff Withhold NY Tax Diff Boolean CB_Withhold_NY_Diff 0 81 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 82 ADRSCODE Address Code String STR15_Address_Code 15 83 ALTERNATENAME Alternate Name String STR20 20 84 BENADJDATE Ben Adj Date Date DT 8 85 BENEFITEXPIRE_I Benefit Expire Date DT 8 86 BIRTHDAY Birth Day Integer INT 0 87 BIRTHMONTH Birth Month Integer INT 0 88 CHANGEBY_I Change By String STR15_User_ID 15 89 CHANGEDATE_I Change Date Date DT 8 90 CITIZEN Citizen Boolean CB_Citizen 0 91 DATEOFLASTREVIEW_I Date Of Last Review Date DT 8 92 DATEOFNEXTREVIEW_I Date Of Next Review Date DT 8 93 DISABLEDVETERAN Disabled Veteran Boolean CB_DisableVet 0 94 DIVISIONCODE_I Division Code String STR6_Payroll_Code 6 95 FEDCLSSCD Federal Classification Code String STR10_LBAU 10 96 HANDICAPPED Handicapped Boolean CB_Handicap 0 97 HRSTATUS HR Status Integer DDL_HRStatus 0 98 I9RENEW I9renew Date DT 8 99 LASTDAYWORKED_I Last Day Worked Date DT 8 100 LOCATNID Location ID String STR15_Location_ID 15 101 MARITALSTATUS MaritalStatus Integer DDL_MaritalStatus 0 102 NICKNAME NickName String STR20 20 103 NOTEINDX2 Note Index2 Currency DLR14 14 104 Primary_Pay_Record Primary Pay Record String STR6_Payroll_Code 6 105 RATECLSS Rate Class String STR15 15 106 SMOKER_I Smoker Boolean CB_Smoker 0 107 SPOUSE Spouse String STR15 15 108 SPOUSESSN Spouse SSN String STR15_Social_Security_Number 15 109 SUPERVISORCODE_I Supervisor Code String STR6_U 6 110 EMPLOYMENTTYPE Type of Employment Integer DDL_Employment_Type 0 111 UNIONCD Union Code String STR6 6 112 UNIONEMPLOYEE Union Employee Boolean CB_Union_Emp 0 113 VERIFIED Verified Boolean CB_Verifed 0 114 VETERAN Veteran Boolean CB_Military 0 115 VIETNAMVETERAN Vietnam Veteran Boolean CB_Vietnam 0 116 WRNSTFLSBLWZR Warn Sick Time Falls Below Zero Boolean CB_WarnSickTimeFallsBelowZero 0 117 WRNVCNFLSBLWZR Warn Vacation Falls Below Zero Boolean CB_WarnVacationFallsBelowZero 0 118 SHFTCODE Shift Code String STR6_Payroll_Code 6 119 SHFTPREM Shift Premium Currency DLR11_$S2 14 120 COUNTY County String STR60 60 121 PHONE1 Phone 1 String Phone_Number 14 122 PHONE2 Phone 2 String Phone_Number 14 123 PHONE3 Phone 3 String Phone_Number3 14 124 FAX Fax String STR14_FAX 14 125 Foreign_Address Foreign Address Boolean CB_Foreign_Address 0 126 Foreign_StateProvince Foreign State/Province String STR23 23 127 Foreign_Postal_Code Foreign Postal Code String STR15_LBAU 15 128 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Payroll Transaction History SmartList'].CCode AS 'Payroll Transaction History SmartList-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
ASIEXP18 AS ['Payroll Transaction History SmartList']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Payroll Transaction History SmartList'].CCode = ['VAT Country Code MSTR'].CCode129 DEPRTMNT1 ASI_Department String STR6_Payroll_Code 6 130 JOBTITLE1 ASI_Job_Title String STR6_Payroll_Code 6 131 WRKRCOMP1 ASI_Workers_Comp String STR6_Payroll_Code 6 132 STATECD3 ASI_State_Code String STR2_State_Code 2 133 LOCALTAX1 ASI_Local_Tax String STR6_Payroll_Code 6 134 ATACRSTM Auto Accrue Sick Time Boolean CB_Accrue_Sick_Time: 0 135 SUTASTAT1 ASI_Suta_State String STR2_State_Code 2 136 TXBLWAGS Taxable Wages Currency DLR11_$S2 14 137 DAYSWRDK Days Worked Long Integer LI6_S2 6 138 WKSWRKD Weeks Worked Long Integer LI6_S2 6 139 SBJTFUTA Subject To Futa Boolean CB_Futa 0 140 BSDONRTE Based On Rate Currency DLR11_$S2 14 141 YEAR1 Year Integer Year 4 142 OTHERVET Other Veterans Boolean CB_OtherVet 0 143 TIMEAVAILABLE Time Available Currency DLR11_S2 11 144 CMRECNUM Record Number Currency DLR_Document_Number 19