PTO00101 - PTO Pending Master | Prospr - Dynamics GP Table Reference

PTO00101 - PTO Pending Master

Query Builder

Select * from PTO00101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
AUCTRLCD	Audit Control Code	String	14	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View
CHEKNMBR	Check Number	String	22	View
TRXDSCRN	Transaction Description	String	32	View
ID_Vacation_Hours_Pendin	ID Vacation Hours Pending	Currency	10	View
ID_Sick_Hours_Pending	ID Sick Hours Pending	Currency	10	View
ID_End_Date	ID End Date	Date	4	View
ID_End_Sick_Date	ID End Sick Date	Date	4	View
ID_Next_Anniv_Date	ID Next Anniv Date	Date	4	View
ID_Vac_Carryover_Date	ID Vac Carryover Date	Date	4	View
ID_Sick_Carryover_Date	ID Sick Carryover Date	Date	4	View