GP Tables

ASIEXP10 - SmartList Payroll Transactions

Dynamics GP table ASIEXP10 (SmartList Payroll Transactions) contains 139 columns including ASI_Order_By, COMPTRNM, BACHNUMB....

SQL Query Builder

139 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
COMPTRNM Computer TRX Number Long Integer 4
BACHNUMB Batch Number String 16
EMPLOYID Employee ID String 16
COMPTRTP Computer TRX Type Integer 2
UPRTRXCD UPR TRX Code String 8
TRXBEGDT TRX Beginning Date Date 4
TRXENDDT TRX Ending Date Date 4
TRXHRUNT TRX Hours/Units Long Integer 4
HRLYPYRT Hourly Pay Rate Currency 10
PAYRTAMT Pay Rate Amount Currency 10
VARDBAMT Variable Ded/Ben Amount Currency 10
VARDBPCT Variable Ded/Ben Percent Long Integer 4
RECEIPTS Receipts Currency 10
DAYSWRDK Days Worked Long Integer 4
WKSWRKD Weeks Worked Long Integer 4
DEPRTMNT Department String 8
JOBTITLE Job Title String 8
STATECD State Code String 4
LOCALTAX Local Tax String 8
SUTASTAT Suta State String 4
WRKRCOMP Workers Comp String 8
LASTUSER Last User String 16
LSTDTEDT Last Date Edited Date 4
TRXSORCE TRX Source String 14
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
VOIDED Voided Boolean 2
NOTEINDX Note Index Currency 10
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
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
PHONNAME Phone Number String 22
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
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
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
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
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
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
INADDNTOSAL In Addition To Salary Boolean 2
JOBNUMBR Job Number String 18
SALCHG Salary Change Integer 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
SHFTCODE Shift Code String 8
SHFTPREM Shift Premium Currency 10
DEPRTMNT1 ASI_Department String 8
JOBTITLE1 ASI_Job_Title String 8
SUTASTAT1 ASI_Suta_State String 4
WRKRCOMP1 ASI_Workers_Comp String 8
NOTEINDX1 ASI_Note_Index Currency 10
STATECD3 ASI_State_Code String 4
LOCALTAX1 ASI_Local_Tax String 8
UNIONCD1 ASI_Union_Code String 8
OTHERVET Other Veterans Boolean 2

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP18 ASIEXP19 ASIEXP20

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27

DOCTYPE

ASIEXP09 ASIEXP18 ASIEXP21 ASIEXP25 ASIEXP26 ASIEXP29 EDCEI016 EDCEI021

ACTINDX

AAG10001 AAG20001 AAG20011 AAG30001 AAG40001 AAG50001 AAG60001 AAG70001

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

CITY

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

STATE

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

USERDEF1

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

USERDEF2

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09