JC10302 - JC_Job_TRX_LINE_WORK | 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
SQNCLINE		numeric(19,5)	15 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
WS_Job_Number		char(17)	90 tables
Project_Number		char(17)	52 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_Code_Description		char(31)	25 tables
Cost_Element		smallint	45 tables
TRXAMNT		numeric(19,5)	15 tables
DSCRIPTN		char(31)	46 tables
Profit_Type_Number		smallint	25 tables
Profit_Amount		numeric(19,5)	24 tables
TRXQTY		numeric(19,5)	25 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
GLLINMSG		binary(4)	4 tables
GLLINMS2		binary(4)	3 tables
GLLINVAL		binary(4)	2 tables
ACCTTYPE		smallint	13 tables
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account
FXDORVAR		smallint	6 tables
Fixed or Variable Allocation values (2) 1 = Fixed Allocation2 = Variable Allocation
BALFRCLC		smallint	9 tables
PSTNGTYP		smallint	5 tables
Posting Type values (2) 0 = Balance Sheet1 = Profit and Loss
DECPLACS		smallint	13 tables
PORDNMBR		char(21)	31 tables
Rate_Per_Unit		numeric(19,5)	2 tables
VENDORID		char(15)	107 tables
EMPLOYID		char(15)	63 tables
ITEMNMBR		char(31)	87 tables
USERID		char(15)	338 tables
WS_Transaction_Date		datetime	6 tables
Payroll_Pay_Type		smallint	7 tables
DEPRTMNT		char(7)	12 tables
JOBTITLE		char(7)	15 tables
PAYRTAMT		numeric(19,5)	9 tables
UPRTRXCD		char(7)	9 tables
UOFM		char(9)	47 tables
User_Define_1		char(31)	103 tables
User_Define_2		char(31)	104 tables
USERDEF1		char(21)	138 tables
USERDEF2		char(21)	138 tables
User_Def_Integer_1		int	97 tables
User_Def_Integer_2		int	97 tables
User_Defined_Integer_3		int	92 tables
User_Defined_Integer_4		int	92 tables
User_Defined_Dollar_1		numeric(19,5)	97 tables
User_Defined_Dollar_2		numeric(19,5)	97 tables
User_Defined_Dollar_3		numeric(19,5)	92 tables
User_Defined_Dollar_4		numeric(19,5)	92 tables
USRDAT01		datetime	100 tables
USRDAT02		datetime	98 tables
User_Defined_Date_3		datetime	87 tables
User_Defined_Date_4		datetime	87 tables
User_Defined_CB_1		tinyint	97 tables
User_Defined_CB_2		tinyint	97 tables
User_Defined_CB_3		tinyint	92 tables
User_Defined_CB_4		tinyint	92 tables
Wennsoft_Affiliate		char(15)	289 tables
Wennsoft_Branch		char(15)	288 tables
Wennsoft_Region		char(15)	289 tables
MODIFDT		datetime	394 tables
Modified_Time		datetime	326 tables
MDFUSRID		char(15)	349 tables
SV_Language_ID		smallint	245 tables
Time_Zone		char(3)	273 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_STR1		char(11)	253 tables
WSReserved_STR2		char(11)	253 tables
DEX_ROW_ID		int auto number (1,1)	608 tables