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 TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NumberString2220
3Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean20
4Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean20
5O_M_Manuals SearchO & M ManualsCBBoolean20
6Payment_Bond SearchPayment BondCBBoolean20
7Performance_Bond SearchPerformance BondCBBoolean20
8JC_Required_CB_1 SearchJC Required CB 1CBBoolean20
9JC_Required_CB_2 SearchJC Required CB 2CBBoolean20
10JC_Required_CB_3 SearchJC Required CB 3CBBoolean20
11JC_Required_CB_4 SearchJC Required CB 4CBBoolean20
12JC_Required_CB_5 SearchJC Required CB 5CBBoolean20
13JC_Required_CB_6 SearchJC Required CB 6CBBoolean20
14JC_Required_CB_7 SearchJC Required CB 7CBBoolean20
15JC_Required_CB_8 SearchJC Required CB 8CBBoolean20
16JC_Required_CB_9 SearchJC Required CB 9CBBoolean20
17JC_Required_CB_10 SearchJC Required CB 10CBBoolean20
18JC_Required_CB_11 SearchJC Required CB 11CBBoolean20
19JC_Required_CB_12 SearchJC Required CB 12CBBoolean20
20JC_Required_CB_13 SearchJC Required CB 13CBBoolean20
21JC_Required_CB_14 SearchJC Required CB 14CBBoolean20
22JC_Required_CB_15 SearchJC Required CB 15CBBoolean20
23JC_Required_CB_16 SearchJC Required CB 16CBBoolean20
24JC_Required_CB_17 SearchJC Required CB 17CBBoolean20
25JC_Required_CB_18 SearchJC Required CB 18CBBoolean20
26JC_Required_CB_19 SearchJC Required CB 19CBBoolean20
27JC_Required_CB_20 SearchJC Required CB 20CBBoolean20
28Ins_Expiration_Date SearchInsurance Expiration DateDTDate48
29Lien_Waiver_Req_Date SearchLien Waiver Required DateDTDate48
30O_M_Manuals_Req_Date SearchO & M Manuals Required DateDTDate48
31Payment_Bond_Req_Date SearchPayment Bond Required DateDTDate48
32Performance_Bond_Req_DT SearchPerformance Bond Required DateDTDate48
33JC_Required_Date_1 SearchJC Required Date 1DTDate48
34JC_Required_Date_2 SearchJC Required Date 2DTDate48
35JC_Required_Date_3 SearchJC Required Date 3DTDate48
36JC_Required_Date_4 SearchJC Required Date 4DTDate48
37JC_Required_Date_5 SearchJC Required Date 5DTDate48
38JC_Required_Date_6 SearchJC Required Date 6DTDate48
39JC_Required_Date_7 SearchJC Required Date 7DTDate48
40JC_Required_Date_8 SearchJC Required Date 8DTDate48
41JC_Required_Date_9 SearchJC Required Date 9DTDate48
42JC_Required_Date_10 SearchJC Required Date 10DTDate48
43JC_Required_Date_11 SearchJC Required Date 11DTDate48
44JC_Required_Date_12 SearchJC Required Date 12DTDate48
45JC_Required_Date_13 SearchJC Required Date 13DTDate48
46JC_Required_Date_14 SearchJC Required Date 14DTDate48
47JC_Required_Date_15 SearchJC Required Date 15DTDate48
48JC_Required_Date_16 SearchJC Required Date 16DTDate48
49JC_Required_Date_17 SearchJC Required Date 17DTDate48
50JC_Required_Date_18 SearchJC Required Date 18DTDate48
51JC_Required_Date_19 SearchJC Required Date 19DTDate48
52JC_Required_Date_20 SearchJC Required Date 20DTDate48
53Ins_Cert_Date_Recd SearchInsurance Certificate Date ReceivedDTDate48
54Lien_Waiver_Date_Recd SearchLien Waiver Date ReceivedDTDate48
55O_M_Manuals_Date_Recd SearchO & M Manuals Date ReceivedDTDate48
56Payment_Bond_Date_Recd SearchPayment Bond Date ReceivedDTDate48
57Performance_Bond_DT_Recd SearchPerformance Bond Date ReceivedDTDate48
58JC_Date_Received_1 SearchJC Date Received 1DTDate48
59JC_Date_Received_2 SearchJC Date Received 2DTDate48
60JC_Date_Received_3 SearchJC Date Received 3DTDate48
61JC_Date_Received_4 SearchJC Date Received 4DTDate48
62JC_Date_Received_5 SearchJC Date Received 5DTDate48
63JC_Date_Received_6 SearchJC Date Received 6DTDate48
64JC_Date_Received_7 SearchJC Date Received 7DTDate48
65JC_Date_Received_8 SearchJC Date Received 8DTDate48
66JC_Date_Received_9 SearchJC Date Received 9DTDate48
67JC_Date_Received_10 SearchJC Date Received 10DTDate48
68JC_Date_Received_11 SearchJC Date Received 11DTDate48
69JC_Date_Received_12 SearchJC Date Received 12DTDate48
70JC_Date_Received_13 SearchJC Date Received 13DTDate48
71JC_Date_Received_14 SearchJC Date Received 14DTDate48
72JC_Date_Received_15 SearchJC Date Received 15DTDate48
73JC_Date_Received_16 SearchJC Date Received 16DTDate48
74JC_Date_Received_17 SearchJC Date Received 17DTDate48
75JC_Date_Received_18 SearchJC Date Received 18DTDate48
76JC_Date_Received_19 SearchJC Date Received 19DTDate48
77JC_Date_Received_20 SearchJC Date Received 20DTDate48
78Ins_Cert_Received SearchInsurance Certificate ReceivedCBBoolean20
79Lien_Waiver_Received SearchLien Waiver ReceivedCBBoolean20
80O_M_Manuals_Received SearchO & M Manuals ReceivedCBBoolean20
81Payment_Bond_Received SearchPayment Bond ReceivedCBBoolean20
82Performance_Bond_Receive SearchPerformance Bond ReceivedCBBoolean20
83JC_Required_Received_1 SearchJC Required Received 1CBBoolean20
84JC_Required_Received_2 SearchJC Required Received 2CBBoolean20
85JC_Required_Received_3 SearchJC Required Received 3CBBoolean20
86JC_Required_Received_4 SearchJC Required Received 4CBBoolean20
87JC_Required_Received_5 SearchJC Required Received 5CBBoolean20
88JC_Required_Received_6 SearchJC Required Received 6CBBoolean20
89JC_Required_Received_7 SearchJC Required Received 7CBBoolean20
90JC_Required_Received_8 SearchJC Required Received 8CBBoolean20
91JC_Required_Received_9 SearchJC Required Received 9CBBoolean20
92JC_Required_Received_10 SearchJC Required Received 10CBBoolean20
93JC_Required_Received_11 SearchJC Required Received 11CBBoolean20
94JC_Required_Received_12 SearchJC Required Received 12CBBoolean20
95JC_Required_Received_13 SearchJC Required Received 13CBBoolean20
96JC_Required_Received_14 SearchJC Required Received 14CBBoolean20
97JC_Required_Received_15 SearchJC Required Received 15CBBoolean20
98JC_Required_Received_16 SearchJC Required Received 16CBBoolean20
99JC_Required_Received_17 SearchJC Required Received 17CBBoolean20
100JC_Required_Received_18 SearchJC Required Received 18CBBoolean20
101JC_Required_Received_19 SearchJC Required Received 19CBBoolean20
102JC_Required_Received_20 SearchJC Required Received 20CBBoolean20
103USERID SearchUser IDSTR15_User_IDString1615
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 1STR30String3230
105User_Define_2 SearchUser Define 2STR30String3230
106USERDEF1 SearchUser Defined 1STR20String2220
107USERDEF2 SearchUser Defined 2STR20String2220
108User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
109User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
110User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
111User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
112USRDAT01 SearchUser Defined Date 1DTDate48
113USRDAT02 SearchUser Defined Date 2DTDate48
114User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
115User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
116User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
117User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
118User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
119User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
120User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
121User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
122User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
123User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
124MDFUSRID SearchModified User IDSTR15String1615
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 DateDTDate48
126Modified_Time SearchModified TimeTM6Time46
127SV_Language_ID SearchSV Language IDINT2Integer22
128Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
129Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
130Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
131WSReserved_CB1 SearchWSReserved CB1CBBoolean20
132WSReserved_CB2 SearchWSReserved CB2CBBoolean20
133WSReserved_CB3 SearchWSReserved CB3CBBoolean20
134WSReserved_CB4 SearchWSReserved CB4CBBoolean20
135WSReserved_CB5 SearchWSReserved CB5CBBoolean20
136WSReserved_STR1 SearchWSReserved STR1STR10String1210
137WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Vendor_Dates_MSTR (JC01514)

Leave a Reply

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