JC_Change_Orders_MSTR (JC01001)

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

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

Display Name: JC_Change_Orders_MSTR
Physical Name: JC01001
Technical Name: JC_Change_Orders_MSTR

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
3Change_Order_Nbr SearchChange Order #STR14String1614
4Change_Order_Status SearchChange Order StatusDDLInteger20
5Chg_Order_Description SearchChange Order DescriptionSTR30_LBAUString3230
6Change_Order_Type SearchChange Order TypeDDL_Contract_TypeInteger20
7Change_Order_Est_Cost SearchChange Order Estimated CostDLR19_TSCurrency1019
8Confirmed_Modified_Date SearchConfirmed Modified DateDTDate48
9Orig_Change_Order_Amt SearchOriginating Change Order AmountDLR19_RBS0_STR$Currency1019
10XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
11EXCHDATE SearchExchange DateDT_DateDate46
12RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['JC_Change_Orders_MSTR'].RATETPID AS 'JC_Change_Orders_MSTR-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       JC01001 AS ['JC_Change_Orders_MSTR']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['JC_Change_Orders_MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
13EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['JC_Change_Orders_MSTR'].EXGTBLID AS 'JC_Change_Orders_MSTR-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       JC01001 AS ['JC_Change_Orders_MSTR']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['JC_Change_Orders_MSTR'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
14TIME1 SearchTimeTM6Time46
15Confirmed_Modified_Time SearchConfirmed Modified TimeTM6Time46
16Confirmed_Mod_UserID SearchConfirmed Modified User IDSTR15String1615
17In_Process_Mod_Date SearchIn-Process Modified DateDTDate48
18In_Process_Mod_Time SearchIn-Process Modified TimeTM6Time46
19In_Process_Mod_User_ID SearchIn-Process Modified User IDSTR15String1615
20CO_UD1_Modified_Date SearchCO UD1 Modified DateDTDate48
21CO_UD1_Modified_Time SearchCO UD1 Modified TimeTM6Time46
22CO_UD1_Modified_UserID SearchCO UD1 Modified User IDSTR15String1615
23CO_UD2_Modified_Date SearchCO UD2 Modified DateDTDate48
24CO_UD2_Modified_Time SearchCO UD2 Modified TimeTM6Time46
25CO_UD2_Modified_UserID SearchCO UD2 Modified User IDSTR15String1615
26CO_UD3_Modified_Date SearchCO UD3 Modified DateDTDate48
27CO_UD3_Modified_Time SearchCO UD3 Modified TimeTM6Time46
28CO_UD3_Modified_UserID SearchCO UD3 Modified User IDSTR15String1615
29User_Defined_CO_1 SearchUser Defined CO 1STR15_LBAUString1615
30User_Defined_CO_2 SearchUser Defined CO 2STR15_LBAUString1615
31User_Defined_CO_3 SearchUser Defined CO 3STR15_LBAUString1615
32User_Defined_CO_4 SearchUser Defined CO 4STR15_LBAUString1615
33USRDAT01 SearchUser Defined Date 1DTDate48
34USRDAT02 SearchUser Defined Date 2DTDate48
35User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
36User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
37Est_Equipment_Cost SearchEst Equipment CostDLR14_TSCurrency1014
38Est_Labor_Cost SearchEst Labor CostDLR14_TSCurrency1014
39Est_Labor_Units_TTD SearchEst Labor Units TTDDLR14_TS2Currency1014
40PAYRATE SearchPay RateDLR11_$S2Currency1014
41Est_Material_Cost SearchEst Material CostDLR14_TSCurrency1014
42Est_Misc_Other_Cost SearchEst Misc (Other) CostDLR14_TSCurrency1014
43Est_Subs_Cost SearchEst Subs CostDLR14_TSCurrency1014
44Est_Cost_UserDef1 SearchEst Cost User Defined 1DLR14_TSCurrency1014
45Est_Cost_UserDef2 SearchEst Cost User Defined 2DLR14_TSCurrency1014
46Est_Cost_UserDef3 SearchEst Cost User Defined 3DLR14_TSCurrency1014
47Est_Cost_UserDef4 SearchEst Cost User Defined 4DLR14_TSCurrency1014
48Total_Estimated_Cost SearchTotal Estimated CostDLR14_TSCurrency1014
49Production_Estimate_Qty SearchProduction Estimate QtyDLR14_TSCurrency1014
50Estimated_Markup SearchEstimated MarkupDLR14_TSCurrency1014
51WS_Markup_Percent SearchWS Markup PercentLI10_%2Long Integer410
52PSTGSTUS SearchPosting StatusINTInteger20
53PSTGDATE SearchPosting DateDTDate48
54Change_Order_Maximum_Amt SearchChange Order Maximum AmountDLR19_TSCurrency1019
55USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Change_Orders_MSTR'].USERID AS 'JC_Change_Orders_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01001 AS ['JC_Change_Orders_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Change_Orders_MSTR'].USERID = ['Users Master'].USERID
56User_Define_1 SearchUser Define 1STR30String3230
57User_Define_2 SearchUser Define 2STR30String3230
58USERDEF1 SearchUser Defined 1STR20String2220
59USERDEF2 SearchUser Defined 2STR20String2220
60User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
61User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
62User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
63User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
64User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
65User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
66User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
67User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
68User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
69User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
70User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
71User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
72Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
73Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
74Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
75MODIFDT SearchModified DateDTDate48
76Modified_Time SearchModified TimeTM6Time46
77MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Change_Orders_MSTR'].MDFUSRID AS 'JC_Change_Orders_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01001 AS ['JC_Change_Orders_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Change_Orders_MSTR'].MDFUSRID = ['Users Master'].USERID
78SV_Language_ID SearchSV Language IDINT2Integer22
79Time_Zone SearchTime ZoneSTR3String43
80WSReserved_CB1 SearchWSReserved CB1CBBoolean20
81WSReserved_CB2 SearchWSReserved CB2CBBoolean20
82WSReserved_CB3 SearchWSReserved CB3CBBoolean20
83WSReserved_CB4 SearchWSReserved CB4CBBoolean20
84WSReserved_CB5 SearchWSReserved CB5CBBoolean20
85WSReserved_STR1 SearchWSReserved STR1STR10String1210
86WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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