JC_Estimate_Detail_TEMP (JC00702)

azurecurve Products WennSoft Products (131)3rd PartyJC_Estimate_Detail_TEMP (JC00702)

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

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

Display Name: JC_Estimate_Detail_TEMP
Physical Name: JC00702
Technical Name: JC_Estimate_Detail_TEMP

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	Inactive_CC	Inactive CC	Boolean	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	Account_Index_Array_2_1	Account Index Array 2[1]	LI_14	Long Integer	14
17	Account_Index_Array_2_2	Account Index Array 2[2]	LI_14	Long Integer	14
18	Account_Index_Array_2_3	Account Index Array 2[3]	LI_14	Long Integer	14
19	Account_Index_Array_2_4	Account Index Array 2[4]	LI_14	Long Integer	14
20	Account_Index_Array_2_5	Account Index Array 2[5]	LI_14	Long Integer	14
21	ACTALIAS	Account Alias	STR20_Account_Alias	String	20
22	Added_By_CO_Module	Added By CO Module	Boolean	Boolean	0
23	Track_Production_Qty	Track Production Qty	CB	Boolean	0
24	Cost_Code_Act_Cost_TTD	Cost Code Actual Cost TTD	DLR14_STR	Currency	14
25	Cost_Code_Act_Cost_YTD	Cost Code Actual Cost YTD	DLR14_RBS0_STR$	Currency	14
26	Actual_Units_TTD	Actual Units TTD	DLR14_TS	Currency	14
27	Cost_Code_Estimated_Cst	Cost Code Estimated Cost	DLR19_TS	Currency	19
28	Change_Order_Est_Cost	Change Order Estimated Cost	DLR19_TS	Currency	19
29	Cost_Code_Rvsd_Est_Cost	Cost Code Rvsd Estimated Cost	DLR19_TS	Currency	19
30	Cost_Code_Forecast_Cost	Cost Code Forecasted Cost	DLR19_TS	Currency	19
31	Cost_Code_Rvsd_Forecast	Cost Code Rvsd Forecast	DLR19_TS	Currency	19
32	Forecasted_Units	Forecasted Units	DLR14_TS	Currency	14
33	Committed_Cost	Committed Cost	DLR19_TS	Currency	19
34	Committed_Units	Committed Units	DLR14_U2	Currency	14
35	Cost_Code_Est_Unit	Cost Code Estimated Units	DLR14_TS2	Currency	14
36	Estimated_Amt_Units	Estimated Amt/Units	DLR19_TS	Currency	19
37	Production_Estimate_Qty	Production Estimate Qty	DLR14_TS	Currency	14
38	Production_Actual_Qty	Production Actual Qty	DLR14_TS	Currency	14
39	Production_Qty_Unit	Production Qty/Unit	DLR14_TS	Currency	14
40	Production_Qty_Curr_Per	Production Qty Current Period	DLR12_TS	Currency	12
41	Production_Best	Production Best	DLR12_TS	Currency	12
42	Production_Best_Date	Production Best Date	DT	Date	8
43	Production_Measure_Code	Production Measure Code	STR6	String	6
44	OVHD1_UOM	OVHD1 UOM	STR20	String	20
45	OVHD1_Type	OVHD1 Type	DDL_Overhead_Type	Integer	0
46	OVHD1_Percent	OVHD1 Percent	INT5_%2	Integer	5
47	OVHD1_Estimated_Units	OVHD1 Estimated Units	DLR14_TS	Currency	14
48	OVHD1_Actual_Units	OVHD1 Actual Units	DLR14_TS	Currency	14
49	OVHD1_Forecasted_Units	OVHD1 Forecasted Units	DLR14_TS	Currency	14
50	OVHD1_Amt_Per_Unit	OVHD1 Amt Per Unit	DLR14_TS	Currency	14
51	OVHD1_Estimated_Amount	OVHD1 Estimated Amount	DLR14_TS	Currency	14
52	OVHD1_Actual_Amount	OVHD1 Actual Amount	DLR14_TS	Currency	14
53	OVHD1_Profit_Type	OVHD1 Profit Type	DDL_Overhead_Type	Integer	0
54	OVHD1_Profit_Amount	OVHD1 Profit Amount	DLR14_TS	Currency	14
55	OVHD2_UOM	OVHD2 UOM	STR20	String	20
56	OVHD2_Type	OVHD2 Type	DDL_Overhead_Type	Integer	0
57	OVHD2_Percent	OVHD2 Percent	INT5_%2	Integer	5
58	OVHD2_Estimated_Units	OVHD2 Estimated Units	DLR14_TS	Currency	14
59	OVHD2_Actual_Units	OVHD2 Actual Units	DLR14_TS	Currency	14
60	OVHD2_Forecasted_Units	OVHD2 Forecasted Units	DLR14_TS	Currency	14
61	OVHD2_Amt_Per_Unit	OVHD2 Amt Per Unit	DLR14_TS	Currency	14
62	OVHD2_Estimated_Amount	OVHD2 Estimated Amount	DLR14_TS	Currency	14
63	OVHD2_Actual_Amount	OVHD2 Actual Amount	DLR14_TS	Currency	14
64	OVHD2_Profit_Type	OVHD2 Profit Type	DDL_Overhead_Type	Integer	0
65	OVHD2_Profit_Amount	OVHD2 Profit Amount	DLR14_TS	Currency	14
66	Bill_Type	Bill Type	DDL_Overhead_Type	Integer	0
67	Sched_Completion_Date	Scheduled Completion Date	DATE	Date	6
68	ACTCOMPDATE	Actual Completion Date	DT	Date	8
69	Schedule_Start_Date	Schedule Start Date	DATE	Date	6
70	ACTSTARTDATE	Actual Start Date	DT	Date	8
71	Billing_Schedule_Line	Billing Schedule Line	STR9	String	9
72	Estimated_Measure_Code	Estimated Measure Code	STR6	String	6
73	Amount_Pct_Complete	Amount % Complete	INT5_%2	Integer	5
74	Units_Pct_Complete	Units % Complete	INT5_%2	Integer	5
75	Production_Pct_Complete	Production % Complete	INT5_%2	Integer	5
76	Field_Pct_Complete	Field % Complete	INT5_%2	Integer	5
77	Posted_To	Posted To	CB	Boolean	0
78	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Estimate_Detail_TEMP'].USERID AS 'JC_Estimate_Detail_TEMP-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC00702 AS ['JC_Estimate_Detail_TEMP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Estimate_Detail_TEMP'].USERID = ['Users Master'].USERID
79	User_Define_1	User Define 1	STR30	String	30
80	User_Define_2	User Define 2	STR30	String	30
81	USERDEF1	User Defined 1	STR20	String	20
82	USERDEF2	User Defined 2	STR20	String	20
83	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
84	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
85	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
86	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
87	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
88	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
89	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
90	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
91	USRDAT01	User Defined Date 1	DT	Date	8
92	USRDAT02	User Defined Date 2	DT	Date	8
93	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
94	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
95	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
96	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
97	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
98	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
99	VNDRNMBR	Vendor Number	Vendor_Number	String	25
100	Inventory_Item_Number	Inventory Item Number	STR20	String	20
101	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
102	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
103	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
104	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
105	MODIFDT	Modified Date	DT	Date	8
106	Modified_Time	Modified Time	TM6	Time	6
107	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Estimate_Detail_TEMP'].MDFUSRID AS 'JC_Estimate_Detail_TEMP-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC00702 AS ['JC_Estimate_Detail_TEMP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Estimate_Detail_TEMP'].MDFUSRID = ['Users Master'].USERID
108	SV_Language_ID	SV Language ID	INT2	Integer	2
109	Time_Zone	Time Zone	STR3	String	3
110	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
111	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
112	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
113	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
114	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
115	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
116	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
117	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
118	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
119	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
120	WSReserved_STR1	WSReserved STR1	STR10	String	10
121	WSReserved_STR2	WSReserved STR2	STR10	String	10
122	Import_Record_Status	Import Record Status	STR10	String	10
123	Import_Record_Status_Des	Import Record Status Description	STR50	String	50

azurecurve Products WennSoft Products (131)3rd PartyJC_Estimate_Detail_TEMP (JC00702)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply