JC_Master_Vendor_Dates_MSTR (JC01514)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Vendor_Dates_MSTR (JC01514)

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

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

Display Name: JC_Master_Vendor_Dates_MSTR
Physical Name: JC01514
Technical Name: JC_Master_Vendor_Dates_MSTR

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC_Master_Vendor_Dates_MSTR'].VENDORID AS 'JC_Master_Vendor_Dates_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC01514 AS ['JC_Master_Vendor_Dates_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Master_Vendor_Dates_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
2PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
3Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean0
4Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean0
5O_M_Manuals SearchO & M ManualsCBBoolean0
6Payment_Bond SearchPayment BondCBBoolean0
7Performance_Bond SearchPerformance BondCBBoolean0
8JC_Required_CB_1 SearchJC Required CB 1CBBoolean0
9JC_Required_CB_2 SearchJC Required CB 2CBBoolean0
10JC_Required_CB_3 SearchJC Required CB 3CBBoolean0
11JC_Required_CB_4 SearchJC Required CB 4CBBoolean0
12JC_Required_CB_5 SearchJC Required CB 5CBBoolean0
13JC_Required_CB_6 SearchJC Required CB 6CBBoolean0
14JC_Required_CB_7 SearchJC Required CB 7CBBoolean0
15JC_Required_CB_8 SearchJC Required CB 8CBBoolean0
16JC_Required_CB_9 SearchJC Required CB 9CBBoolean0
17JC_Required_CB_10 SearchJC Required CB 10CBBoolean0
18JC_Required_CB_11 SearchJC Required CB 11CBBoolean0
19JC_Required_CB_12 SearchJC Required CB 12CBBoolean0
20JC_Required_CB_13 SearchJC Required CB 13CBBoolean0
21JC_Required_CB_14 SearchJC Required CB 14CBBoolean0
22JC_Required_CB_15 SearchJC Required CB 15CBBoolean0
23JC_Required_CB_16 SearchJC Required CB 16CBBoolean0
24JC_Required_CB_17 SearchJC Required CB 17CBBoolean0
25JC_Required_CB_18 SearchJC Required CB 18CBBoolean0
26JC_Required_CB_19 SearchJC Required CB 19CBBoolean0
27JC_Required_CB_20 SearchJC Required CB 20CBBoolean0
28Ins_Expiration_Date SearchInsurance Expiration DateDTDate8
29Lien_Waiver_Req_Date SearchLien Waiver Required DateDTDate8
30O_M_Manuals_Req_Date SearchO & M Manuals Required DateDTDate8
31Payment_Bond_Req_Date SearchPayment Bond Required DateDTDate8
32Performance_Bond_Req_DT SearchPerformance Bond Required DateDTDate8
33JC_Required_Date_1 SearchJC Required Date 1DTDate8
34JC_Required_Date_2 SearchJC Required Date 2DTDate8
35JC_Required_Date_3 SearchJC Required Date 3DTDate8
36JC_Required_Date_4 SearchJC Required Date 4DTDate8
37JC_Required_Date_5 SearchJC Required Date 5DTDate8
38JC_Required_Date_6 SearchJC Required Date 6DTDate8
39JC_Required_Date_7 SearchJC Required Date 7DTDate8
40JC_Required_Date_8 SearchJC Required Date 8DTDate8
41JC_Required_Date_9 SearchJC Required Date 9DTDate8
42JC_Required_Date_10 SearchJC Required Date 10DTDate8
43JC_Required_Date_11 SearchJC Required Date 11DTDate8
44JC_Required_Date_12 SearchJC Required Date 12DTDate8
45JC_Required_Date_13 SearchJC Required Date 13DTDate8
46JC_Required_Date_14 SearchJC Required Date 14DTDate8
47JC_Required_Date_15 SearchJC Required Date 15DTDate8
48JC_Required_Date_16 SearchJC Required Date 16DTDate8
49JC_Required_Date_17 SearchJC Required Date 17DTDate8
50JC_Required_Date_18 SearchJC Required Date 18DTDate8
51JC_Required_Date_19 SearchJC Required Date 19DTDate8
52JC_Required_Date_20 SearchJC Required Date 20DTDate8
53Ins_Cert_Date_Recd SearchInsurance Certificate Date ReceivedDTDate8
54Lien_Waiver_Date_Recd SearchLien Waiver Date ReceivedDTDate8
55O_M_Manuals_Date_Recd SearchO & M Manuals Date ReceivedDTDate8
56Payment_Bond_Date_Recd SearchPayment Bond Date ReceivedDTDate8
57Performance_Bond_DT_Recd SearchPerformance Bond Date ReceivedDTDate8
58JC_Date_Received_1 SearchJC Date Received 1DTDate8
59JC_Date_Received_2 SearchJC Date Received 2DTDate8
60JC_Date_Received_3 SearchJC Date Received 3DTDate8
61JC_Date_Received_4 SearchJC Date Received 4DTDate8
62JC_Date_Received_5 SearchJC Date Received 5DTDate8
63JC_Date_Received_6 SearchJC Date Received 6DTDate8
64JC_Date_Received_7 SearchJC Date Received 7DTDate8
65JC_Date_Received_8 SearchJC Date Received 8DTDate8
66JC_Date_Received_9 SearchJC Date Received 9DTDate8
67JC_Date_Received_10 SearchJC Date Received 10DTDate8
68JC_Date_Received_11 SearchJC Date Received 11DTDate8
69JC_Date_Received_12 SearchJC Date Received 12DTDate8
70JC_Date_Received_13 SearchJC Date Received 13DTDate8
71JC_Date_Received_14 SearchJC Date Received 14DTDate8
72JC_Date_Received_15 SearchJC Date Received 15DTDate8
73JC_Date_Received_16 SearchJC Date Received 16DTDate8
74JC_Date_Received_17 SearchJC Date Received 17DTDate8
75JC_Date_Received_18 SearchJC Date Received 18DTDate8
76JC_Date_Received_19 SearchJC Date Received 19DTDate8
77JC_Date_Received_20 SearchJC Date Received 20DTDate8
78Ins_Cert_Received SearchInsurance Certificate ReceivedCBBoolean0
79Lien_Waiver_Received SearchLien Waiver ReceivedCBBoolean0
80O_M_Manuals_Received SearchO & M Manuals ReceivedCBBoolean0
81Payment_Bond_Received SearchPayment Bond ReceivedCBBoolean0
82Performance_Bond_Receive SearchPerformance Bond ReceivedCBBoolean0
83JC_Required_Received_1 SearchJC Required Received 1CBBoolean0
84JC_Required_Received_2 SearchJC Required Received 2CBBoolean0
85JC_Required_Received_3 SearchJC Required Received 3CBBoolean0
86JC_Required_Received_4 SearchJC Required Received 4CBBoolean0
87JC_Required_Received_5 SearchJC Required Received 5CBBoolean0
88JC_Required_Received_6 SearchJC Required Received 6CBBoolean0
89JC_Required_Received_7 SearchJC Required Received 7CBBoolean0
90JC_Required_Received_8 SearchJC Required Received 8CBBoolean0
91JC_Required_Received_9 SearchJC Required Received 9CBBoolean0
92JC_Required_Received_10 SearchJC Required Received 10CBBoolean0
93JC_Required_Received_11 SearchJC Required Received 11CBBoolean0
94JC_Required_Received_12 SearchJC Required Received 12CBBoolean0
95JC_Required_Received_13 SearchJC Required Received 13CBBoolean0
96JC_Required_Received_14 SearchJC Required Received 14CBBoolean0
97JC_Required_Received_15 SearchJC Required Received 15CBBoolean0
98JC_Required_Received_16 SearchJC Required Received 16CBBoolean0
99JC_Required_Received_17 SearchJC Required Received 17CBBoolean0
100JC_Required_Received_18 SearchJC Required Received 18CBBoolean0
101JC_Required_Received_19 SearchJC Required Received 19CBBoolean0
102JC_Required_Received_20 SearchJC Required Received 20CBBoolean0
103USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Master_Vendor_Dates_MSTR'].USERID AS 'JC_Master_Vendor_Dates_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01514 AS ['JC_Master_Vendor_Dates_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Master_Vendor_Dates_MSTR'].USERID = ['Users Master'].USERID
104User_Define_1 SearchUser Define 1STR30String30
105User_Define_2 SearchUser Define 2STR30String30
106USERDEF1 SearchUser Defined 1STR20String20
107USERDEF2 SearchUser Defined 2STR20String20
108User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
109User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
110User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
111User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
112USRDAT01 SearchUser Defined Date 1DTDate8
113USRDAT02 SearchUser Defined Date 2DTDate8
114User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
115User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
116User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
117User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
118User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
119User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
120User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
121User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
122User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
123User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
124MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Master_Vendor_Dates_MSTR'].MDFUSRID AS 'JC_Master_Vendor_Dates_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01514 AS ['JC_Master_Vendor_Dates_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Master_Vendor_Dates_MSTR'].MDFUSRID = ['Users Master'].USERID
125MODIFDT SearchModified DateDTDate8
126Modified_Time SearchModified TimeTM6Time6
127SV_Language_ID SearchSV Language IDINT2Integer2
128Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
129Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
130Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
131WSReserved_CB1 SearchWSReserved CB1CBBoolean0
132WSReserved_CB2 SearchWSReserved CB2CBBoolean0
133WSReserved_CB3 SearchWSReserved CB3CBBoolean0
134WSReserved_CB4 SearchWSReserved CB4CBBoolean0
135WSReserved_CB5 SearchWSReserved CB5CBBoolean0
136WSReserved_STR1 SearchWSReserved STR1STR10String10
137WSReserved_STR2 SearchWSReserved STR2STR10String10
azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Vendor_Dates_MSTR (JC01514)

Leave a Reply

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