GP Tables

ASIEXP18 - Payroll Transaction History SmartList

Dynamics GP table ASIEXP18 (Payroll Transaction History SmartList) contains 144 columns including ASI_Order_By, AUCTRLCD, EMPLOYID....

SQL Query Builder

144 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
AUCTRLCD Audit Control Code String 14
EMPLOYID Employee ID String 16
CHEKNMBR Check Number String 22
PYADNMBR Payment/Adjustment Number Long Integer 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
DEPRTMNT Department String 8
JOBTITLE Job Title String 8
PYRLRTYP Payroll Record Type1 = Regular Pay Codes2 = Deductions3 = Benefits4 = Taxes5 = LocalTax Integer 2
PAYROLCD Payroll Code String 8
TRXBEGDT TRX Beginning Date Date 4
TRXENDDT TRX Ending Date Date 4
UNTSTOPY Units To Pay Currency 10
PAYRATE Pay Rate Currency 10
UPRTRXAM UPR TRX Amount Currency 10
TipType Tip Type Integer 2
RECEIPTS Receipts Currency 10
PAYADVNC Pay Advance Currency 10
STATECD State Code String 4
LOCALTAX Local Tax String 8
WRKRCOMP Workers Comp String 8
CHEKDATE Check Date Date 4
USWHPSTD User Who Posted String 16
LSTDTEDT Last Date Edited Date 4
LASTUSER Last User 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
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
PARTTIME Part Time Boolean 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
SUTASTAT Suta State String 4
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
ATACRSCK Auto Accrue Sick 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
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
SHFTCODE Shift Code String 8
SHFTPREM Shift Premium Currency 10
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
DEPRTMNT1 ASI_Department String 8
JOBTITLE1 ASI_Job_Title String 8
WRKRCOMP1 ASI_Workers_Comp String 8
STATECD3 ASI_State_Code String 4
LOCALTAX1 ASI_Local_Tax String 8
ATACRSTM Auto Accrue Sick Time Boolean 2
SUTASTAT1 ASI_Suta_State String 4
TXBLWAGS Taxable Wages Currency 10
DAYSWRDK Days Worked Long Integer 4
WKSWRKD Weeks Worked Long Integer 4
SBJTFUTA Subject To Futa Boolean 2
BSDONRTE Based On Rate Currency 10
YEAR1 Year Integer 2
OTHERVET Other Veterans Boolean 2
TIMEAVAILABLE Time Available Currency 10
CMRECNUM Record Number Currency 10

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20

DOCTYPE

ASIEXP09 ASIEXP10 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

EMPLOYID

AAG10001 AAG20001 AAG30001 AAG40001 AHPSLH01 ASIEXP05 ASIEXP10 ASIEXP32