ASIEXP05 - SmartList Payroll Master | Prospr - Dynamics GP Table Reference

ASIEXP05 - SmartList Payroll Master

Query Builder

Select * from ASIEXP05

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
EMPLOYID	Employee ID	String	16	View
EMPLCLAS	Employee Class	String	16	View
INACTIVE	Inactive	Boolean	2	View
LASTNAME	Last Name	String	22	View
FRSTNAME	First Name	String	16	View
MIDLNAME	Middle Name	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
COUNTRY	Country	String	62	View
ZIPCODE	Zip Code	String	12	View
SOCSCNUM	Social Security Number	String	16	View
BRTHDATE	Birth Date	Date	4	View
GENDER	Gender 1 is male 2 is female 3 is N/A.	Integer	2	View
ETHNORGN	Ethnic Origin 1. White 2. American Indian or Alaskan Native 3. Black or African American 4. Asian 5. Hispanic or Latino 6. Two or more races 7. N/A 8. Native Hawaiian or Pacific Islander	Integer	2	View
Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	2	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
WCACFPAY	Which Cash Account For Pay	Integer	2	View
ACTINDX	Account Index	Long Integer	4	View
WKHRPRYR	Work Hours Per Year	Integer	2	View
STRTDATE	Start Date	Date	4	View
DEMPINAC	Date Employee Inactivated	Date	4	View
RSNEMPIN	Reason Employee Inactivated	String	32	View
MINETPAY	Minimum Net Pay	Currency	10	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
ATACRVAC	Auto Accrue Vacation	Boolean	2	View
VACCRAMT	Vacation Accrual Amount	Long Integer	4	View
VACCRMTH	Vacation Accrual Method	Integer	2	View
VACAPRYR	Vacation Hours Per Year	Long Integer	4	View
VACAVLBL	Vacation Available	Long Integer	4	View
ATACRSTM	Auto Accrue Sick Time	Boolean	2	View
STMACMTH	Sick Time Accrual Method 0 is by Hours Worked 1 is by Amount.	Integer	2	View
SKTMACAM	Sick Time Accrual Amount	Long Integer	4	View
SIKTIMAV	Sick Time Available	Long Integer	4	View
SKTMHPYR	Sick Time Hours Per Year	Long Integer	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
NOTEINDX	Note Index	Currency	10	View
EXMFRFED	Exempt From Federal	Boolean	2	View
FDFLGSTS	Federal Filing Status	String	8	View
FEDEXMPT	Federal Exemptions	Integer	2	View
ADFDWHDG	Additional Federal Withholding	Currency	10	View
ESTFEDWH	Estimated Federal Withholding	Currency	10	View
STATECD	State Code	String	4	View
LOCALTAX	Local Tax	String	8	View
W2BF942E	W2 Box For 942 Employee	Boolean	2	View
W2BFDCSD	W2 Box For Deceased	Boolean	2	View
W2BFDCMP	W2 Box For Deferred Compensation	Boolean	2	View
W2BFLREP	W2 Box For Legal Representative	Boolean	2	View
W2BFPPLN	W2 Box For Pension Plan	Boolean	2	View
W2BFSTEM	W2 Box For Statutory Employee	Boolean	2	View
MCRQGEMP	Medicare Qualified Govt Employee	Boolean	2	View
EICFLGST	EIC Filing Status	String	8	View
NYTXDiff	Withhold NY Tax Diff	Boolean	2	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ADRSCODE	Address Code	String	16	View
ALTERNATENAME	Alternate Name	String	22	View
BENADJDATE	Ben Adj Date	Date	4	View
BENEFITEXPIRE_I	Benefit Expire	Date	4	View
BIRTHDAY	Birth Day	Integer	2	View
BIRTHMONTH	Birth Month	Integer	2	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
CITIZEN	Citizen	Boolean	2	View
DATEOFLASTREVIEW_I	Date Of Last Review	Date	4	View
DATEOFNEXTREVIEW_I	Date Of Next Review	Date	4	View
DISABLEDVETERAN	Disabled Veteran	Boolean	2	View
DIVISIONCODE_I	Division Code	String	8	View
FEDCLSSCD	Federal Classification Code	String	12	View
HANDICAPPED	Handicapped	Boolean	2	View
HRSTATUS	HR Status 1. Active 2. Family Leave 3. Leave of Absence 4. Maternity 5. Retired 6. Separated 7. Suspended 8. Terminated 9. Other In SBM, this field is not available.	Integer	2	View
I9RENEW	I9renew	Date	4	View
LASTDAYWORKED_I	Last Day Worked	Date	4	View
LOCATNID	Location ID	String	16	View
MARITALSTATUS	MaritalStatus 1. Married 2. Single 3. N/A	Integer	2	View
NICKNAME	NickName	String	22	View
NOTEINDX2	Note Index2	Currency	10	View
Primary_Pay_Record	Primary Pay Record	String	8	View
RATECLSS	Rate Class	String	16	View
SMOKER_I	Smoker	Boolean	2	View
SPOUSE	Spouse	String	16	View
SPOUSESSN	Spouse SSN	String	16	View
SUPERVISORCODE_I	Supervisor Code	String	8	View
EMPLOYMENTTYPE	Type of Employment 1. Full Time Regular 2. Full Time Temp 3. Part Time Regular 4. Part Time Temp 5. Intern In SBM, this field is not available. 6. Other	Integer	2	View
UNIONCD	Union Code	String	8	View
UNIONEMPLOYEE	Union Employee	Boolean	2	View
VERIFIED	Verified	Boolean	2	View
VETERAN	Veteran	Boolean	2	View
VIETNAMVETERAN	Vietnam Veteran	Boolean	2	View
WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	2	View
WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	2	View
COUNTY	County	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
Foreign_Address	Foreign Address	Boolean	2	View
Foreign_StateProvince	Foreign State/Province	String	24	View
Foreign_Postal_Code	Foreign Postal Code	String	16	View
CCode	Country Code	String	8	View
OTHERVET	Other Veterans	Boolean	2	View

ASIEXP05 - SmartList Payroll Master

Query Builder

Customer Service

Information

My Account

Contact Us