HR2REQ01 - HR_Requisition | Prospr - Dynamics GP Table Reference

HR2REQ01 - HR_Requisition

Query Builder

Select * from HR2REQ01

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
REQUISITIONNUMBER_I	Requisition Number	Long Integer	4	View
REQSTATUS_I	Req Status	Integer	2	View
COMPANYCODE_I	Company Code	String	8	View
DIVISIONCODE_I	Division Code	String	8	View
DEPARTMENTCODE_I	Department Code	String	8	View
POSITIONCODE_I	Position Code	String	8	View
MANAGER_I	Manager	String	32	View
SUPERVISORCODE_I	Supervisor Code	String	8	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
OPENINGDATE_I	Opening Date	Date	4	View
RECRUITER_I	Recruiter	String	32	View
RECRUITMENT_I	Recruitment	Integer	2	View
ADVERTISINGLIST_I_1	Advertising List[1]	String	16	View
ADVERTISINGLIST_I_2	Advertising List[2]	String	16	View
ADVERTISINGLIST_I_3	Advertising List[3]	String	16	View
ADVERTISINGLIST_I_4	Advertising List[4]	String	16	View
ADVERTISINGLIST_I_5	Advertising List[5]	String	16	View
POSITIONSAVAILABLE_I	Positions Availiable	Integer	2	View
POSITIONSFILLED_I	Positions Filled	Integer	2	View
APPLICANTSAPPLIED_I	Applicants Applied	Integer	2	View
APPSINTERVIEWED_I	Applicants Interviewed	Integer	2	View
ADVERTISINGCOSTS_I	Advertising Costs	Currency	10	View
RECRUITERSFEES_I	Recruiters Fees	Currency	10	View
TRAVELCOSTS_I	Travel Costs	Currency	10	View
LODGINGCOSTS_I	Lodging Costs	Currency	10	View
MOVINGEXPENSES_I	Moving Expenses	Currency	10	View
OTHERCOSTS_I	Other Costs	Currency	10	View
NOTESINDEX_I	Notes Index	Currency	10	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View