CLM00100 - CLM Certification Master | Prospr - Dynamics GP Table Reference

CLM00100 - CLM Certification Master

Query Builder

Select * from CLM00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
CLM_Cert_Code	CLM Cert Code	String	8	View
CLM_Cert_Number	CLM Cert Number	String	32	View
CLM_Issued_By	CLM Issued By	String	16	View
CLM_Org_Issue_Date	CLM Org Issue Date	Date	4	View
CLM_Date_Renewed	CLM Date Renewed	Date	4	View
EXPNDATE	Expiration Date	Date	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDEF03	User Defined 3	String	22	View
USRDEF04	User Defined 4	String	22	View
INACTIVE	Inactive	Boolean	2	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
TIME1	Time	Time	4	View
NOTEINDX	Note Index	Currency	10	View