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 TypeLength
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
2Project_Number SearchWS Project NumberSTR170String17
3Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
4Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
5Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
6Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
7Cost_Code_Alias SearchCost Code AliasSTR26String26
8Cost_Code_Description SearchCost Code DescriptionSTR30String30
9Cost_Element SearchCost ElementINT3_RB0_UInteger3
10WS_Manager_ID SearchWS Manager IDSTR15_Employee_IDString15
11Inactive_CC SearchInactive CCBooleanBoolean0
12Profit_Type_Number SearchProfit Type NumberINT2Integer2
13Profit_Amount SearchProfit AmountDLR14_TSCurrency14
14Type_of_Transaction SearchType of TransactionDDLInteger0
15Next_Subdivision_Type SearchNext Subdivision TypeDDL_Next_SubdivisionInteger0
16Account_Index_Array_2_1 SearchAccount Index Array 2[1]LI_14Long Integer14
17Account_Index_Array_2_2 SearchAccount Index Array 2[2]LI_14Long Integer14
18Account_Index_Array_2_3 SearchAccount Index Array 2[3]LI_14Long Integer14
19Account_Index_Array_2_4 SearchAccount Index Array 2[4]LI_14Long Integer14
20Account_Index_Array_2_5 SearchAccount Index Array 2[5]LI_14Long Integer14
21ACTALIAS SearchAccount AliasSTR20_Account_AliasString20
22Added_By_CO_Module SearchAdded By CO ModuleBooleanBoolean0
23Track_Production_Qty SearchTrack Production QtyCBBoolean0
24Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency14
25Cost_Code_Act_Cost_YTD SearchCost Code Actual Cost YTDDLR14_RBS0_STR$Currency14
26Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency14
27Cost_Code_Estimated_Cst SearchCost Code Estimated CostDLR19_TSCurrency19
28Change_Order_Est_Cost SearchChange Order Estimated CostDLR19_TSCurrency19
29Cost_Code_Rvsd_Est_Cost SearchCost Code Rvsd Estimated CostDLR19_TSCurrency19
30Cost_Code_Forecast_Cost SearchCost Code Forecasted CostDLR19_TSCurrency19
31Cost_Code_Rvsd_Forecast SearchCost Code Rvsd ForecastDLR19_TSCurrency19
32Forecasted_Units SearchForecasted UnitsDLR14_TSCurrency14
33Committed_Cost SearchCommitted CostDLR19_TSCurrency19
34Committed_Units SearchCommitted UnitsDLR14_U2Currency14
35Cost_Code_Est_Unit SearchCost Code Estimated UnitsDLR14_TS2Currency14
36Estimated_Amt_Units SearchEstimated Amt/UnitsDLR19_TSCurrency19
37Production_Estimate_Qty SearchProduction Estimate QtyDLR14_TSCurrency14
38Production_Actual_Qty SearchProduction Actual QtyDLR14_TSCurrency14
39Production_Qty_Unit SearchProduction Qty/UnitDLR14_TSCurrency14
40Production_Qty_Curr_Per SearchProduction Qty Current PeriodDLR12_TSCurrency12
41Production_Best SearchProduction BestDLR12_TSCurrency12
42Production_Best_Date SearchProduction Best DateDTDate8
43Production_Measure_Code SearchProduction Measure CodeSTR6String6
44OVHD1_UOM SearchOVHD1 UOMSTR20String20
45OVHD1_Type SearchOVHD1 TypeDDL_Overhead_TypeInteger0
46OVHD1_Percent SearchOVHD1 PercentINT5_%2Integer5
47OVHD1_Estimated_Units SearchOVHD1 Estimated UnitsDLR14_TSCurrency14
48OVHD1_Actual_Units SearchOVHD1 Actual UnitsDLR14_TSCurrency14
49OVHD1_Forecasted_Units SearchOVHD1 Forecasted UnitsDLR14_TSCurrency14
50OVHD1_Amt_Per_Unit SearchOVHD1 Amt Per UnitDLR14_TSCurrency14
51OVHD1_Estimated_Amount SearchOVHD1 Estimated AmountDLR14_TSCurrency14
52OVHD1_Actual_Amount SearchOVHD1 Actual AmountDLR14_TSCurrency14
53OVHD1_Profit_Type SearchOVHD1 Profit TypeDDL_Overhead_TypeInteger0
54OVHD1_Profit_Amount SearchOVHD1 Profit AmountDLR14_TSCurrency14
55OVHD2_UOM SearchOVHD2 UOMSTR20String20
56OVHD2_Type SearchOVHD2 TypeDDL_Overhead_TypeInteger0
57OVHD2_Percent SearchOVHD2 PercentINT5_%2Integer5
58OVHD2_Estimated_Units SearchOVHD2 Estimated UnitsDLR14_TSCurrency14
59OVHD2_Actual_Units SearchOVHD2 Actual UnitsDLR14_TSCurrency14
60OVHD2_Forecasted_Units SearchOVHD2 Forecasted UnitsDLR14_TSCurrency14
61OVHD2_Amt_Per_Unit SearchOVHD2 Amt Per UnitDLR14_TSCurrency14
62OVHD2_Estimated_Amount SearchOVHD2 Estimated AmountDLR14_TSCurrency14
63OVHD2_Actual_Amount SearchOVHD2 Actual AmountDLR14_TSCurrency14
64OVHD2_Profit_Type SearchOVHD2 Profit TypeDDL_Overhead_TypeInteger0
65OVHD2_Profit_Amount SearchOVHD2 Profit AmountDLR14_TSCurrency14
66Bill_Type SearchBill TypeDDL_Overhead_TypeInteger0
67Sched_Completion_Date SearchScheduled Completion DateDATEDate6
68ACTCOMPDATE SearchActual Completion DateDTDate8
69Schedule_Start_Date SearchSchedule Start DateDATEDate6
70ACTSTARTDATE SearchActual Start DateDTDate8
71Billing_Schedule_Line SearchBilling Schedule LineSTR9String9
72Estimated_Measure_Code SearchEstimated Measure CodeSTR6String6
73Amount_Pct_Complete SearchAmount % CompleteINT5_%2Integer5
74Units_Pct_Complete SearchUnits % CompleteINT5_%2Integer5
75Production_Pct_Complete SearchProduction % CompleteINT5_%2Integer5
76Field_Pct_Complete SearchField % CompleteINT5_%2Integer5
77Posted_To SearchPosted ToCBBoolean0
78USERID SearchUser IDSTR15_User_IDString15
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 1STR30String30
80User_Define_2 SearchUser Define 2STR30String30
81USERDEF1 SearchUser Defined 1STR20String20
82USERDEF2 SearchUser Defined 2STR20String20
83User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
84User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
85User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
86User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
87User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
88User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
89User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
90User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
91USRDAT01 SearchUser Defined Date 1DTDate8
92USRDAT02 SearchUser Defined Date 2DTDate8
93User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
94User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
95User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
96User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
97User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
98User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
99VNDRNMBR SearchVendor NumberVendor_NumberString25
100Inventory_Item_Number SearchInventory Item NumberSTR20String20
101PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
102Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
103Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
104Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
105MODIFDT SearchModified DateDTDate8
106Modified_Time SearchModified TimeTM6Time6
107MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
109Time_Zone SearchTime ZoneSTR3String3
110WSReserved_CB1 SearchWSReserved CB1CBBoolean0
111WSReserved_CB2 SearchWSReserved CB2CBBoolean0
112WSReserved_CB3 SearchWSReserved CB3CBBoolean0
113WSReserved_CB4 SearchWSReserved CB4CBBoolean0
114WSReserved_CB5 SearchWSReserved CB5CBBoolean0
115WSReserved_CB6 SearchWSReserved CB6CBBoolean0
116WSReserved_CB7 SearchWSReserved CB7CBBoolean0
117WSReserved_CB8 SearchWSReserved CB8CBBoolean0
118WSReserved_CB9 SearchWSReserved CB9CBBoolean0
119WSReserved_CB10 SearchWSReserved CB10CBBoolean0
120WSReserved_STR1 SearchWSReserved STR1STR10String10
121WSReserved_STR2 SearchWSReserved STR2STR10String10
122Import_Record_Status SearchImport Record StatusSTR10String10
123Import_Record_Status_Des SearchImport Record Status DescriptionSTR50String50

Leave a Reply

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