JC30202 - JC_Job_TRX_HDR_HIST | GP Tables - Dynamics GP Table Reference

Column	Description	Type	Shared With
BACHNUMB		char(15)	122 tables
BCHSOURC		char(15)	104 tables
JRNENTRY		int	37 tables
RCTRXSEQ		numeric(19,5)	9 tables
SOURCDOC		char(11)	27 tables
REFRENCE		char(31)	24 tables
TRXDATE		datetime	26 tables
RVRSNGDT		datetime	6 tables
RCRNGTRX		tinyint	4 tables
BALFRCLC		smallint	9 tables
PSTGSTUS		smallint	50 tables
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
LASTUSER		char(15)	8 tables
LSTDTEDT		datetime	8 tables
USWHPSTD		char(15)	7 tables
TRXTYPE		smallint	8 tables
Transaction Type values (2) 0 = Standard1 = Reversing
SQNCLINE		numeric(19,5)	15 tables
GLHDRMSG		binary(4)	4 tables
GLHDRMS2		binary(4)	4 tables
TRXSORCE		char(13)	93 tables
SERIES		smallint	23 tables
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party
ORTRXTYP		smallint	7 tables
ORCTRNUM		char(21)	7 tables
ORMSTRID		char(31)	7 tables
ORMSTRNM		char(65)	7 tables
ORDOCNUM		char(21)	7 tables
ORPSTDDT		datetime	6 tables
ORTRXSRC		char(13) 0	7 tables
CURNCYID	Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions.	char(15)	136 tables
NOTEINDX		numeric(19,5)	160 tables
WSReserved_CB1		tinyint	326 tables
WSReserved_CB2		tinyint	325 tables
WSReserved_CB3		tinyint	320 tables
WSReserved_CB4		tinyint	317 tables
WSReserved_CB5		tinyint	318 tables
WSReserved_CB6		tinyint	172 tables
WSReserved_CB7		tinyint	172 tables
WSReserved_CB10		tinyint	172 tables
OPENYEAR		smallint	8 tables
DEX_ROW_ID		int auto number (1,1)	608 tables