JC_Job_Detail_MSTR (JC00701)

azurecurve Products WennSoft Products (131)3rd PartyJC_Job_Detail_MSTR (JC00701)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC00701

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Job_Detail_MSTR
Physical Name: JC00701
Technical Name: JC_Job_Detail_MSTR

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	WS_Job_Number	WS Job Number	STR17_LBAU	String	17
2	Project_Number	WS Project Number	STR170	String	17
3	Cost_Code_Number_1	Cost Code Number:CC_Phase	STR6_CC_Phase	String	6
4	Cost_Code_Number_2	Cost Code Number:CC_Step	STR6_CC_Steps	String	6
5	Cost_Code_Number_3	Cost Code Number:CC_Detail	STR6_CC_Detail	String	6
6	Cost_Code_Number_4	Cost Code Number:CC_Component	STR6_CC_Component	String	6
7	Cost_Code_Alias	Cost Code Alias	STR26	String	26
8	Cost_Code_Description	Cost Code Description	STR30	String	30
9	Cost_Element	Cost Element	INT3_RB0_U	Integer	3
10	WS_Manager_ID	WS Manager ID	STR15_Employee_ID	String	15
11	WS_Inactive	WS Inactive	CB	Boolean	0
12	Profit_Type_Number	Profit Type Number	INT2	Integer	2
13	Profit_Amount	Profit Amount	DLR14_TS	Currency	14
14	Type_of_Transaction	Type of Transaction	DDL	Integer	0
15	Next_Subdivision_Type	Next Subdivision Type	DDL_Next_Subdivision	Integer	0
16	WS_Account_Index_1	WS Account Index 1	LI_14	Long Integer	14
17	WS_Account_Index_2	WS Account Index 2	LI_14	Long Integer	14
18	Added_By_CO_Module	Added By CO Module	Boolean	Boolean	0
19	Track_Production_Qty	Track Production Qty	CB	Boolean	0
20	Cost_Code_Act_Cost_TTD	Cost Code Actual Cost TTD	DLR14_STR	Currency	14
21	Cost_Code_Act_Cost_YTD	Cost Code Actual Cost YTD	DLR14_RBS0_STR$	Currency	14
22	Actual_Units_TTD	Actual Units TTD	DLR14_TS	Currency	14
23	Cost_Code_Estimated_Cst	Cost Code Estimated Cost	DLR19_TS	Currency	19
24	Change_Order_Est_Cost	Change Order Estimated Cost	DLR19_TS	Currency	19
25	Cost_Code_Rvsd_Est_Cost	Cost Code Rvsd Estimated Cost	DLR19_TS	Currency	19
26	Cost_Code_Forecast_Cost	Cost Code Forecasted Cost	DLR19_TS	Currency	19
27	Cost_Code_Rvsd_Forecast	Cost Code Rvsd Forecast	DLR19_TS	Currency	19
28	Forecasted_Units	Forecasted Units	DLR14_TS	Currency	14
29	Committed_Cost	Committed Cost	DLR19_TS	Currency	19
30	Committed_Units	Committed Units	DLR14_U2	Currency	14
31	Cost_Code_Est_Unit	Cost Code Estimated Units	DLR14_TS2	Currency	14
32	Estimated_Amt_Units	Estimated Amt/Units	DLR19_TS	Currency	19
33	Production_Estimate_Qty	Production Estimate Qty	DLR14_TS	Currency	14
34	Production_Actual_Qty	Production Actual Qty	DLR14_TS	Currency	14
35	Production_Qty_Unit	Production Qty/Unit	DLR14_TS	Currency	14
36	Production_Qty_Curr_Per	Production Qty Current Period	DLR12_TS	Currency	12
37	Production_Best	Production Best	DLR12_TS	Currency	12
38	Production_Best_Date	Production Best Date	DT	Date	8
39	Production_Measure_Code	Production Measure Code	STR6	String	6
40	OVHD1_UOM	OVHD1 UOM	STR20	String	20
41	OVHD1_Type	OVHD1 Type	DDL_Overhead_Type	Integer	0
42	OVHD1_Percent	OVHD1 Percent	INT5_%2	Integer	5
43	OVHD1_Estimated_Units	OVHD1 Estimated Units	DLR14_TS	Currency	14
44	OVHD1_Actual_Units	OVHD1 Actual Units	DLR14_TS	Currency	14
45	OVHD1_Forecasted_Units	OVHD1 Forecasted Units	DLR14_TS	Currency	14
46	OVHD1_Amt_Per_Unit	OVHD1 Amt Per Unit	DLR14_TS	Currency	14
47	OVHD1_Estimated_Amount	OVHD1 Estimated Amount	DLR14_TS	Currency	14
48	OVHD1_Actual_Amount	OVHD1 Actual Amount	DLR14_TS	Currency	14
49	OVHD1_Profit_Type	OVHD1 Profit Type	DDL_Overhead_Type	Integer	0
50	OVHD1_Profit_Amount	OVHD1 Profit Amount	DLR14_TS	Currency	14
51	OVHD2_UOM	OVHD2 UOM	STR20	String	20
52	OVHD2_Type	OVHD2 Type	DDL_Overhead_Type	Integer	0
53	OVHD2_Percent	OVHD2 Percent	INT5_%2	Integer	5
54	OVHD2_Estimated_Units	OVHD2 Estimated Units	DLR14_TS	Currency	14
55	OVHD2_Actual_Units	OVHD2 Actual Units	DLR14_TS	Currency	14
56	OVHD2_Forecasted_Units	OVHD2 Forecasted Units	DLR14_TS	Currency	14
57	OVHD2_Amt_Per_Unit	OVHD2 Amt Per Unit	DLR14_TS	Currency	14
58	OVHD2_Estimated_Amount	OVHD2 Estimated Amount	DLR14_TS	Currency	14
59	OVHD2_Actual_Amount	OVHD2 Actual Amount	DLR14_TS	Currency	14
60	OVHD2_Profit_Type	OVHD2 Profit Type	DDL_Overhead_Type	Integer	0
61	OVHD2_Profit_Amount	OVHD2 Profit Amount	DLR14_TS	Currency	14
62	Bill_Type	Bill Type	DDL_Overhead_Type	Integer	0
63	Sched_Completion_Date	Scheduled Completion Date	DATE	Date	6
64	ACTCOMPDATE	Actual Completion Date	DT	Date	8
65	Schedule_Start_Date	Schedule Start Date	DATE	Date	6
66	ACTSTARTDATE	Actual Start Date	DT	Date	8
67	Billing_Schedule_Line	Billing Schedule Line	STR9	String	9
68	Estimated_Measure_Code	Estimated Measure Code	STR6	String	6
69	Amount_Pct_Complete	Amount % Complete	INT5_%2	Integer	5
70	Units_Pct_Complete	Units % Complete	INT5_%2	Integer	5
71	Production_Pct_Complete	Production % Complete	INT5_%2	Integer	5
72	Field_Pct_Complete	Field % Complete	INT5_%2	Integer	5
73	Posted_To	Posted To	CB	Boolean	0
74	WRKRCOMP	Workers Comp	STR6_Payroll_Code	String	6
75	Change_Order_Est_Units	Change Order Estimated Units	DLR14_TS2	Currency	14
76	Labor_Group_Name	Labor Group Name	STR15_RM_Customer_Number	String	15
77	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Job_Detail_MSTR'].USERID AS 'JC_Job_Detail_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC00701 AS ['JC_Job_Detail_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Job_Detail_MSTR'].USERID = ['Users Master'].USERID
78	User_Define_1	User Define 1	STR30	String	30
79	User_Define_2	User Define 2	STR30	String	30
80	USERDEF1	User Defined 1	STR20	String	20
81	USERDEF2	User Defined 2	STR20	String	20
82	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
83	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
84	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
85	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
86	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
87	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
88	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
89	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
90	USRDAT01	User Defined Date 1	DT	Date	8
91	USRDAT02	User Defined Date 2	DT	Date	8
92	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
93	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
94	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
95	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
96	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
97	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
98	VNDRNMBR	Vendor Number	Vendor_Number	String	25
99	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['JC_Job_Detail_MSTR'].ITEMNMBR AS 'JC_Job_Detail_MSTR-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM JC00701 AS ['JC_Job_Detail_MSTR'] INNER JOIN IV00101 AS ['Item Master'] ON ['JC_Job_Detail_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR
100	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
101	CC_Rvsd_Forecast_Units	Cost Code Rvsd Forecast Units	DLR14_TS2	Currency	14
102	Rate_Per_Unit	Rate Per Unit	DLR14_TS	Currency	14
103	Original_Estimate_Units	Original Estimate Units	DLR14_TS2	Currency	14
104	Original_Forecast_Units	Original Forecast Units	DLR14_TS2	Currency	14
105	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
106	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
107	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
108	MODIFDT	Modified Date	DT	Date	8
109	Modified_Time	Modified Time	TM6	Time	6
110	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Job_Detail_MSTR'].MDFUSRID AS 'JC_Job_Detail_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC00701 AS ['JC_Job_Detail_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Job_Detail_MSTR'].MDFUSRID = ['Users Master'].USERID
111	SV_Language_ID	SV Language ID	INT2	Integer	2
112	Time_Zone	Time Zone	STR3	String	3
113	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
114	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
115	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
116	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
117	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
118	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
119	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
120	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
121	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
122	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
123	WSReserved_STR1	WSReserved STR1	STR10	String	10
124	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartyJC_Job_Detail_MSTR (JC00701)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply