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

Leave a Reply

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