JC20401 - JC_Job_Transaction_Entry_POST | GP Tables

Column	Description	Type	Shared With
USERID		char(15)	338 tables
BCHSOURC		char(15)	104 tables
BACHNUMB		char(15)	122 tables
JRNENTRY		int	37 tables
SQNCLINE		numeric(19,5)	15 tables
WS_Job_Number		char(17)	90 tables
WS_Job_Name		char(31)	10 tables
Cost_Code_Number_1		char(7)	38 tables
Cost_Code_Number_2		char(7)	38 tables
Cost_Code_Number_3		char(7)	38 tables
Cost_Code_Number_4		char(7)	38 tables
Cost_Element		smallint	45 tables
Cost_Code_Description		char(31)	25 tables
ACTINDX	Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules.	int	91 tables
OFFINDX		int	4 tables
TRXAMNT		numeric(19,5)	15 tables
TRXQTY		numeric(19,5)	25 tables
GLLINMSG		binary(4)	4 tables
TRXDATE		datetime	26 tables
ACCTTYPE		smallint	13 tables
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account
DSCRIPTN		char(31)	46 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
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_STR1		char(11)	253 tables
WSReserved_STR2		char(11)	253 tables
DEX_ROW_ID		int auto number (1,1)	608 tables