GP Tables

ASIEXP05 - SmartList Payroll Master

Dynamics GP table ASIEXP05 (SmartList Payroll Master) contains 106 columns including ASI_Order_By, EMPLOYID, EMPLCLAS....

SQL Query Builder

106 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
EMPLOYID Employee ID String 16
EMPLCLAS Employee Class String 16
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
LASTNAME Last Name String 22
FRSTNAME First Name String 16
MIDLNAME Middle Name String 16
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
COUNTRY Country String 62
ZIPCODE Zip Code String 12
SOCSCNUM Social Security Number String 16
BRTHDATE Birth Date Date 4
GENDER Gender1 is male2 is female3 is N/A. Integer 2
ETHNORGN Ethnic Origin1. White2. American Indian or Alaskan Native3. Black or African American4. Asian 5. Hispanic or Latino6. Two or more races7. N/A8. Native Hawaiian or Pacific Islander Integer 2
Calc_Min_Wage_Bal Calc Min Wage Bal Boolean 2
DEPRTMNT Department String 8
JOBTITLE Job Title String 8
WCACFPAY Which Cash Account For Pay Integer 2
ACTINDX Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. Long Integer 4
WKHRPRYR Work Hours Per Year Integer 2
STRTDATE Start Date Date 4
DEMPINAC Date Employee Inactivated Date 4
RSNEMPIN Reason Employee Inactivated String 32
MINETPAY Minimum Net Pay Currency 10
SUTASTAT Suta State String 4
WRKRCOMP Workers Comp String 8
ATACRVAC Auto Accrue Vacation Boolean 2
VACCRAMT Vacation Accrual Amount Long Integer 4
VACCRMTH Vacation Accrual Method Integer 2
VACAPRYR Vacation Hours Per Year Long Integer 4
VACAVLBL Vacation Available Long Integer 4
ATACRSTM Auto Accrue Sick Time Boolean 2
STMACMTH Sick Time Accrual Method0 is by Hours Worked1 is by Amount. Integer 2
SKTMACAM Sick Time Accrual Amount Long Integer 4
SIKTIMAV Sick Time Available Long Integer 4
SKTMHPYR Sick Time Hours Per Year Long Integer 4
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
NOTEINDX Note Index Currency 10
EXMFRFED Exempt From Federal Boolean 2
FDFLGSTS Federal Filing Status String 8
FEDEXMPT Federal Exemptions Integer 2
ADFDWHDG Additional Federal Withholding Currency 10
ESTFEDWH Estimated Federal Withholding Currency 10
STATECD State Code String 4
LOCALTAX Local Tax String 8
W2BF942E W2 Box For 942 Employee Boolean 2
W2BFDCSD W2 Box For Deceased Boolean 2
W2BFDCMP W2 Box For Deferred Compensation Boolean 2
W2BFLREP W2 Box For Legal Representative Boolean 2
W2BFPPLN W2 Box For Pension Plan Boolean 2
W2BFSTEM W2 Box For Statutory Employee Boolean 2
MCRQGEMP Medicare Qualified Govt Employee Boolean 2
EICFLGST EIC Filing Status String 8
NYTXDiff Withhold NY Tax Diff Boolean 2
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
ADRSCODE Address Code String 16
ALTERNATENAME Alternate Name String 22
BENADJDATE Ben Adj Date Date 4
BENEFITEXPIRE_I Benefit Expire Date 4
BIRTHDAY Birth Day Integer 2
BIRTHMONTH Birth Month Integer 2
CHANGEBY_I Change By String 16
CHANGEDATE_I Change Date Date 4
CITIZEN Citizen Boolean 2
DATEOFLASTREVIEW_I Date Of Last Review Date 4
DATEOFNEXTREVIEW_I Date Of Next Review Date 4
DISABLEDVETERAN Disabled Veteran Boolean 2
DIVISIONCODE_I Division Code String 8
FEDCLSSCD Federal Classification Code String 12
HANDICAPPED Handicapped Boolean 2
HRSTATUS HR Status1. Active2. Family Leave3. Leave of Absence4. Maternity5. Retired6. Separated7. Suspended8. Terminated9. Other In SBM, this field is not available. Integer 2
I9RENEW I9renew Date 4
LASTDAYWORKED_I Last Day Worked Date 4
LOCATNID Location ID String 16
MARITALSTATUS MaritalStatus1. Married2. Single3. N/A Integer 2
NICKNAME NickName String 22
NOTEINDX2 Note Index2 Currency 10
Primary_Pay_Record Primary Pay Record String 8
RATECLSS Rate Class String 16
SMOKER_I Smoker Boolean 2
SPOUSE Spouse String 16
SPOUSESSN Spouse SSN String 16
SUPERVISORCODE_I Supervisor Code String 8
EMPLOYMENTTYPE Type of Employment1. Full Time Regular2. Full Time Temp3. Part Time Regular4. Part Time Temp5. Intern In SBM, this field is not available.6. Other Integer 2
UNIONCD Union Code String 8
UNIONEMPLOYEE Union Employee Boolean 2
VERIFIED Verified Boolean 2
VETERAN Veteran Boolean 2
VIETNAMVETERAN Vietnam Veteran Boolean 2
WRNSTFLSBLWZR Warn Sick Time Falls Below Zero Boolean 2
WRNVCNFLSBLWZR Warn Vacation Falls Below Zero Boolean 2
COUNTY County String 62
PHONE1 Phone 1 String 22
PHONE2 Phone 2 String 22
PHONE3 Phone 3 String 22
FAX Fax String 22
Foreign_Address Foreign Address Boolean 2
Foreign_StateProvince Foreign State/Province String 24
Foreign_Postal_Code Foreign Postal Code String 16
CCode Country Code String 8
OTHERVET Other Veterans Boolean 2

Related Tables

Tables that share columns with ASIEXP05. Click "Join" to add to your query.

ADRSCODE

ASIEXP02 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18 ASIEXP20

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

USERDEF1

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10

USERDEF2

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10

ACTINDX

AAG00200 AAG10001 AAG20001 AAG20011 AAG30001 AAG40001 AAG50001 AAG60001

EMPLOYID

AAG10001 AAG20001 AAG30001 AAG40001 AHPSLH01 APR_DIA30100 ASIEXP10 ASIEXP18

CITY

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

STATE

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

ADDRESS2

AHR2AP12 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10