JC_Vendor_Dates_MSTR (JC01504)

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

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

Display Name: JC_Vendor_Dates_MSTR
Physical Name: JC01504
Technical Name: JC_Vendor_Dates_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
2VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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