JC_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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
2Project_Number SearchWS Project NumberSTR170String1817
3Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
4Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
5Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
6Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
7Cost_Code_Alias SearchCost Code AliasSTR26String2826
8Cost_Code_Description SearchCost Code DescriptionSTR30String3230
9Cost_Element SearchCost ElementINT3_RB0_UInteger23
10WS_Manager_ID SearchWS Manager IDSTR15_Employee_IDString1615
11Inactive_CC SearchInactive CCBooleanBoolean20
12Profit_Type_Number SearchProfit Type NumberINT2Integer22
13Profit_Amount SearchProfit AmountDLR14_TSCurrency1014
14Type_of_Transaction SearchType of TransactionDDLInteger20
15Next_Subdivision_Type SearchNext Subdivision TypeDDL_Next_SubdivisionInteger20
16Account_Index_Array_2_1 SearchAccount Index Array 2[1]LI_14Long Integer414
17Account_Index_Array_2_2 SearchAccount Index Array 2[2]LI_14Long Integer414
18Account_Index_Array_2_3 SearchAccount Index Array 2[3]LI_14Long Integer414
19Account_Index_Array_2_4 SearchAccount Index Array 2[4]LI_14Long Integer414
20Account_Index_Array_2_5 SearchAccount Index Array 2[5]LI_14Long Integer414
21ACTALIAS SearchAccount AliasSTR20_Account_AliasString2220
22Added_By_CO_Module SearchAdded By CO ModuleBooleanBoolean20
23Track_Production_Qty SearchTrack Production QtyCBBoolean20
24Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency1014
25Cost_Code_Act_Cost_YTD SearchCost Code Actual Cost YTDDLR14_RBS0_STR$Currency1014
26Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency1014
27Cost_Code_Estimated_Cst SearchCost Code Estimated CostDLR19_TSCurrency1019
28Change_Order_Est_Cost SearchChange Order Estimated CostDLR19_TSCurrency1019
29Cost_Code_Rvsd_Est_Cost SearchCost Code Rvsd Estimated CostDLR19_TSCurrency1019
30Cost_Code_Forecast_Cost SearchCost Code Forecasted CostDLR19_TSCurrency1019
31Cost_Code_Rvsd_Forecast SearchCost Code Rvsd ForecastDLR19_TSCurrency1019
32Forecasted_Units SearchForecasted UnitsDLR14_TSCurrency1014
33Committed_Cost SearchCommitted CostDLR19_TSCurrency1019
34Committed_Units SearchCommitted UnitsDLR14_U2Currency1014
35Cost_Code_Est_Unit SearchCost Code Estimated UnitsDLR14_TS2Currency1014
36Estimated_Amt_Units SearchEstimated Amt/UnitsDLR19_TSCurrency1019
37Production_Estimate_Qty SearchProduction Estimate QtyDLR14_TSCurrency1014
38Production_Actual_Qty SearchProduction Actual QtyDLR14_TSCurrency1014
39Production_Qty_Unit SearchProduction Qty/UnitDLR14_TSCurrency1014
40Production_Qty_Curr_Per SearchProduction Qty Current PeriodDLR12_TSCurrency1012
41Production_Best SearchProduction BestDLR12_TSCurrency1012
42Production_Best_Date SearchProduction Best DateDTDate48
43Production_Measure_Code SearchProduction Measure CodeSTR6String86
44OVHD1_UOM SearchOVHD1 UOMSTR20String2220
45OVHD1_Type SearchOVHD1 TypeDDL_Overhead_TypeInteger20
46OVHD1_Percent SearchOVHD1 PercentINT5_%2Integer25
47OVHD1_Estimated_Units SearchOVHD1 Estimated UnitsDLR14_TSCurrency1014
48OVHD1_Actual_Units SearchOVHD1 Actual UnitsDLR14_TSCurrency1014
49OVHD1_Forecasted_Units SearchOVHD1 Forecasted UnitsDLR14_TSCurrency1014
50OVHD1_Amt_Per_Unit SearchOVHD1 Amt Per UnitDLR14_TSCurrency1014
51OVHD1_Estimated_Amount SearchOVHD1 Estimated AmountDLR14_TSCurrency1014
52OVHD1_Actual_Amount SearchOVHD1 Actual AmountDLR14_TSCurrency1014
53OVHD1_Profit_Type SearchOVHD1 Profit TypeDDL_Overhead_TypeInteger20
54OVHD1_Profit_Amount SearchOVHD1 Profit AmountDLR14_TSCurrency1014
55OVHD2_UOM SearchOVHD2 UOMSTR20String2220
56OVHD2_Type SearchOVHD2 TypeDDL_Overhead_TypeInteger20
57OVHD2_Percent SearchOVHD2 PercentINT5_%2Integer25
58OVHD2_Estimated_Units SearchOVHD2 Estimated UnitsDLR14_TSCurrency1014
59OVHD2_Actual_Units SearchOVHD2 Actual UnitsDLR14_TSCurrency1014
60OVHD2_Forecasted_Units SearchOVHD2 Forecasted UnitsDLR14_TSCurrency1014
61OVHD2_Amt_Per_Unit SearchOVHD2 Amt Per UnitDLR14_TSCurrency1014
62OVHD2_Estimated_Amount SearchOVHD2 Estimated AmountDLR14_TSCurrency1014
63OVHD2_Actual_Amount SearchOVHD2 Actual AmountDLR14_TSCurrency1014
64OVHD2_Profit_Type SearchOVHD2 Profit TypeDDL_Overhead_TypeInteger20
65OVHD2_Profit_Amount SearchOVHD2 Profit AmountDLR14_TSCurrency1014
66Bill_Type SearchBill TypeDDL_Overhead_TypeInteger20
67Sched_Completion_Date SearchScheduled Completion DateDATEDate46
68ACTCOMPDATE SearchActual Completion DateDTDate48
69Schedule_Start_Date SearchSchedule Start DateDATEDate46
70ACTSTARTDATE SearchActual Start DateDTDate48
71Billing_Schedule_Line SearchBilling Schedule LineSTR9String109
72Estimated_Measure_Code SearchEstimated Measure CodeSTR6String86
73Amount_Pct_Complete SearchAmount % CompleteINT5_%2Integer25
74Units_Pct_Complete SearchUnits % CompleteINT5_%2Integer25
75Production_Pct_Complete SearchProduction % CompleteINT5_%2Integer25
76Field_Pct_Complete SearchField % CompleteINT5_%2Integer25
77Posted_To SearchPosted ToCBBoolean20
78USERID SearchUser IDSTR15_User_IDString1615
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
79User_Define_1 SearchUser Define 1STR30String3230
80User_Define_2 SearchUser Define 2STR30String3230
81USERDEF1 SearchUser Defined 1STR20String2220
82USERDEF2 SearchUser Defined 2STR20String2220
83User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
84User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
85User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
86User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
87User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
88User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
89User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
90User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
91USRDAT01 SearchUser Defined Date 1DTDate48
92USRDAT02 SearchUser Defined Date 2DTDate48
93User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
94User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
95User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
96User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
97User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
98User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
99VNDRNMBR SearchVendor NumberVendor_NumberString2625
100Inventory_Item_Number SearchInventory Item NumberSTR20String2220
101PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
102Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
103Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
104Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
105MODIFDT SearchModified DateDTDate48
106Modified_Time SearchModified TimeTM6Time46
107MDFUSRID SearchModified User IDSTR15String1615
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
108SV_Language_ID SearchSV Language IDINT2Integer22
109Time_Zone SearchTime ZoneSTR3String43
110WSReserved_CB1 SearchWSReserved CB1CBBoolean20
111WSReserved_CB2 SearchWSReserved CB2CBBoolean20
112WSReserved_CB3 SearchWSReserved CB3CBBoolean20
113WSReserved_CB4 SearchWSReserved CB4CBBoolean20
114WSReserved_CB5 SearchWSReserved CB5CBBoolean20
115WSReserved_CB6 SearchWSReserved CB6CBBoolean20
116WSReserved_CB7 SearchWSReserved CB7CBBoolean20
117WSReserved_CB8 SearchWSReserved CB8CBBoolean20
118WSReserved_CB9 SearchWSReserved CB9CBBoolean20
119WSReserved_CB10 SearchWSReserved CB10CBBoolean20
120WSReserved_STR1 SearchWSReserved STR1STR10String1210
121WSReserved_STR2 SearchWSReserved STR2STR10String1210
122Import_Record_Status SearchImport Record StatusSTR10String1210
123Import_Record_Status_Des SearchImport Record Status DescriptionSTR50String5250

Leave a Reply

Your email address will not be published. Required fields are marked *