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 TypeLength
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
2Project_Number SearchWS Project NumberSTR170String17
3Change_Order_Nbr SearchChange Order #STR14String14
4Change_Order_Status SearchChange Order StatusDDLInteger0
5Chg_Order_Description SearchChange Order DescriptionSTR30_LBAUString30
6Change_Order_Type SearchChange Order TypeDDL_Contract_TypeInteger0
7Change_Order_Est_Cost SearchChange Order Estimated CostDLR19_TSCurrency19
8Confirmed_Modified_Date SearchConfirmed Modified DateDTDate8
9Orig_Change_Order_Amt SearchOriginating Change Order AmountDLR19_RBS0_STR$Currency19
10XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
11EXCHDATE SearchExchange DateDT_DateDate6
12RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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_IDString15
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 SearchTimeTM6Time6
15Confirmed_Modified_Time SearchConfirmed Modified TimeTM6Time6
16Confirmed_Mod_UserID SearchConfirmed Modified User IDSTR15String15
17In_Process_Mod_Date SearchIn-Process Modified DateDTDate8
18In_Process_Mod_Time SearchIn-Process Modified TimeTM6Time6
19In_Process_Mod_User_ID SearchIn-Process Modified User IDSTR15String15
20CO_UD1_Modified_Date SearchCO UD1 Modified DateDTDate8
21CO_UD1_Modified_Time SearchCO UD1 Modified TimeTM6Time6
22CO_UD1_Modified_UserID SearchCO UD1 Modified User IDSTR15String15
23CO_UD2_Modified_Date SearchCO UD2 Modified DateDTDate8
24CO_UD2_Modified_Time SearchCO UD2 Modified TimeTM6Time6
25CO_UD2_Modified_UserID SearchCO UD2 Modified User IDSTR15String15
26CO_UD3_Modified_Date SearchCO UD3 Modified DateDTDate8
27CO_UD3_Modified_Time SearchCO UD3 Modified TimeTM6Time6
28CO_UD3_Modified_UserID SearchCO UD3 Modified User IDSTR15String15
29User_Defined_CO_1 SearchUser Defined CO 1STR15_LBAUString15
30User_Defined_CO_2 SearchUser Defined CO 2STR15_LBAUString15
31User_Defined_CO_3 SearchUser Defined CO 3STR15_LBAUString15
32User_Defined_CO_4 SearchUser Defined CO 4STR15_LBAUString15
33USRDAT01 SearchUser Defined Date 1DTDate8
34USRDAT02 SearchUser Defined Date 2DTDate8
35User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
36User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
37Est_Equipment_Cost SearchEst Equipment CostDLR14_TSCurrency14
38Est_Labor_Cost SearchEst Labor CostDLR14_TSCurrency14
39Est_Labor_Units_TTD SearchEst Labor Units TTDDLR14_TS2Currency14
40PAYRATE SearchPay RateDLR11_$S2Currency14
41Est_Material_Cost SearchEst Material CostDLR14_TSCurrency14
42Est_Misc_Other_Cost SearchEst Misc (Other) CostDLR14_TSCurrency14
43Est_Subs_Cost SearchEst Subs CostDLR14_TSCurrency14
44Est_Cost_UserDef1 SearchEst Cost User Defined 1DLR14_TSCurrency14
45Est_Cost_UserDef2 SearchEst Cost User Defined 2DLR14_TSCurrency14
46Est_Cost_UserDef3 SearchEst Cost User Defined 3DLR14_TSCurrency14
47Est_Cost_UserDef4 SearchEst Cost User Defined 4DLR14_TSCurrency14
48Total_Estimated_Cost SearchTotal Estimated CostDLR14_TSCurrency14
49Production_Estimate_Qty SearchProduction Estimate QtyDLR14_TSCurrency14
50Estimated_Markup SearchEstimated MarkupDLR14_TSCurrency14
51WS_Markup_Percent SearchWS Markup PercentLI10_%2Long Integer10
52PSTGSTUS SearchPosting StatusINTInteger0
53PSTGDATE SearchPosting DateDTDate8
54Change_Order_Maximum_Amt SearchChange Order Maximum AmountDLR19_TSCurrency19
55USERID SearchUser IDSTR15_User_IDString15
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 1STR30String30
57User_Define_2 SearchUser Define 2STR30String30
58USERDEF1 SearchUser Defined 1STR20String20
59USERDEF2 SearchUser Defined 2STR20String20
60User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
61User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
62User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
63User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
64User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
65User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
66User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
67User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
68User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
69User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
70User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
71User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
72Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
73Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
74Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
75MODIFDT SearchModified DateDTDate8
76Modified_Time SearchModified TimeTM6Time6
77MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
79Time_Zone SearchTime ZoneSTR3String3
80WSReserved_CB1 SearchWSReserved CB1CBBoolean0
81WSReserved_CB2 SearchWSReserved CB2CBBoolean0
82WSReserved_CB3 SearchWSReserved CB3CBBoolean0
83WSReserved_CB4 SearchWSReserved CB4CBBoolean0
84WSReserved_CB5 SearchWSReserved CB5CBBoolean0
85WSReserved_STR1 SearchWSReserved STR1STR10String10
86WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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