JC10211 - JC_SOP_LINE_WORK | GP Tables - Dynamics GP Table Reference

Column	Type	Shared With
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
Account_Index_Array_2_1	int	5 tables
Account_Index_Array_2_2	int	5 tables
Account_Index_Array_2_3	int	5 tables
Account_Index_Array_2_4	int	5 tables
Account_Index_Array_2_5	int	5 tables
Document_Source	char(3)	22 tables
TRXDSCRN	char(31)	37 tables
Cost_Code_Act_Cost_TTD	numeric(19,5)	14 tables
Committed_Cost	numeric(19,5)	9 tables
Committed_Units	numeric(19,5)	4 tables
Profit_Type_Number	smallint	25 tables
Profit_Amount	numeric(19,5)	24 tables
DOCDATE	datetime	106 tables
GLPOSTDT	datetime	66 tables
DOCAMNT	numeric(19,5)	63 tables
Job_Type	char(7)	4 tables
SOPTYPE	smallint	23 tables
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order
SOPNUMBE	char(21)	20 tables
LNITMSEQ	int	74 tables
CMPNTSEQ	int	11 tables
Job_TRX_Number	char(21)	17 tables
ITEMNMBR	char(31)	87 tables
ITEMDESC	char(101)	42 tables
IVIVOFIX	int	14 tables
VENDORID	char(15)	107 tables
UOFM	char(9)	47 tables
TRXQTY	numeric(19,5)	25 tables
TRXLOCTN	char(11)	9 tables
UNITCOST	numeric(19,5)	30 tables
BACHNUMB	char(15)	122 tables
BCHSOURC	char(15)	104 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
USERID	char(15)	338 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
SV_SOP_Invoiced	tinyint	-
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_CB8	tinyint	169 tables
WSReserved_CB9	tinyint	169 tables
WSReserved_CB10	tinyint	172 tables
WSReserved_STR1	char(11)	253 tables
WSReserved_STR2	char(11)	253 tables
DEX_ROW_ID	int auto number (1,1)	608 tables