JC_Vendor_Master_Dates (JC01505)

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

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

Display Name: JC_Vendor_Master_Dates
Physical Name: JC01505
Technical Name: JC_Vendor_Master_Dates

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_Vendor_Master_Dates'].VENDORID AS 'JC_Vendor_Master_Dates-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC01505 AS ['JC_Vendor_Master_Dates']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Vendor_Master_Dates'].VENDORID = ['PM Vendor Master File'].VENDORID
2PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
3Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean20
4Insurance_Starting_Date_1 SearchInsurance Starting Date[1]DateDate410
5Insurance_Starting_Date_2 SearchInsurance Starting Date[2]DateDate410
6Insurance_Starting_Date_3 SearchInsurance Starting Date[3]DateDate410
7Insurance_Starting_Date_4 SearchInsurance Starting Date[4]DateDate410
8Insurance_Starting_Date_5 SearchInsurance Starting Date[5]DateDate410
9Insurance_Starting_Date_6 SearchInsurance Starting Date[6]DateDate410
10Insurance_Starting_Date_7 SearchInsurance Starting Date[7]DateDate410
11Insurance_Starting_Date_8 SearchInsurance Starting Date[8]DateDate410
12Insurance_Starting_Date_9 SearchInsurance Starting Date[9]DateDate410
13Insurance_Starting_Date_10 SearchInsurance Starting Date[10]DateDate410
14Insurance_Ending_Date_1 SearchInsurance Ending Date[1]DateDate410
15Insurance_Ending_Date_2 SearchInsurance Ending Date[2]DateDate410
16Insurance_Ending_Date_3 SearchInsurance Ending Date[3]DateDate410
17Insurance_Ending_Date_4 SearchInsurance Ending Date[4]DateDate410
18Insurance_Ending_Date_5 SearchInsurance Ending Date[5]DateDate410
19Insurance_Ending_Date_6 SearchInsurance Ending Date[6]DateDate410
20Insurance_Ending_Date_7 SearchInsurance Ending Date[7]DateDate410
21Insurance_Ending_Date_8 SearchInsurance Ending Date[8]DateDate410
22Insurance_Ending_Date_9 SearchInsurance Ending Date[9]DateDate410
23Insurance_Ending_Date_10 SearchInsurance Ending Date[10]DateDate410
24Insurance_Company_1 SearchInsurance Company[1]STR30String3230
25Insurance_Company_2 SearchInsurance Company[2]STR30String3230
26Insurance_Company_3 SearchInsurance Company[3]STR30String3230
27Insurance_Company_4 SearchInsurance Company[4]STR30String3230
28Insurance_Company_5 SearchInsurance Company[5]STR30String3230
29Insurance_Company_6 SearchInsurance Company[6]STR30String3230
30Insurance_Company_7 SearchInsurance Company[7]STR30String3230
31Insurance_Company_8 SearchInsurance Company[8]STR30String3230
32Insurance_Company_9 SearchInsurance Company[9]STR30String3230
33Insurance_Company_10 SearchInsurance Company[10]STR30String3230
34Insurance_Policy_Number_1 SearchInsurance Policy Number[1]STR30String3230
35Insurance_Policy_Number_2 SearchInsurance Policy Number[2]STR30String3230
36Insurance_Policy_Number_3 SearchInsurance Policy Number[3]STR30String3230
37Insurance_Policy_Number_4 SearchInsurance Policy Number[4]STR30String3230
38Insurance_Policy_Number_5 SearchInsurance Policy Number[5]STR30String3230
39Insurance_Policy_Number_6 SearchInsurance Policy Number[6]STR30String3230
40Insurance_Policy_Number_7 SearchInsurance Policy Number[7]STR30String3230
41Insurance_Policy_Number_8 SearchInsurance Policy Number[8]STR30String3230
42Insurance_Policy_Number_9 SearchInsurance Policy Number[9]STR30String3230
43Insurance_Policy_Number_10 SearchInsurance Policy Number[10]STR30String3230
44Coverage_Amount_Availabl_1 SearchCoverage Amount Available[1]DLR19_$S2Currency1019
45Coverage_Amount_Availabl_2 SearchCoverage Amount Available[2]DLR19_$S2Currency1019
46Coverage_Amount_Availabl_3 SearchCoverage Amount Available[3]DLR19_$S2Currency1019
47Coverage_Amount_Availabl_4 SearchCoverage Amount Available[4]DLR19_$S2Currency1019
48Coverage_Amount_Availabl_5 SearchCoverage Amount Available[5]DLR19_$S2Currency1019
49Coverage_Amount_Availabl_6 SearchCoverage Amount Available[6]DLR19_$S2Currency1019
50Coverage_Amount_Availabl_7 SearchCoverage Amount Available[7]DLR19_$S2Currency1019
51Coverage_Amount_Availabl_8 SearchCoverage Amount Available[8]DLR19_$S2Currency1019
52Coverage_Amount_Availabl_9 SearchCoverage Amount Available[9]DLR19_$S2Currency1019
53Coverage_Amount_Availabl_10 SearchCoverage Amount Available[10]DLR19_$S2Currency1019
54Coverage_Amount_Required_1 SearchCoverage Amount Required[1]DLR19_$S2Currency1019
55Coverage_Amount_Required_2 SearchCoverage Amount Required[2]DLR19_$S2Currency1019
56Coverage_Amount_Required_3 SearchCoverage Amount Required[3]DLR19_$S2Currency1019
57Coverage_Amount_Required_4 SearchCoverage Amount Required[4]DLR19_$S2Currency1019
58Coverage_Amount_Required_5 SearchCoverage Amount Required[5]DLR19_$S2Currency1019
59Coverage_Amount_Required_6 SearchCoverage Amount Required[6]DLR19_$S2Currency1019
60Coverage_Amount_Required_7 SearchCoverage Amount Required[7]DLR19_$S2Currency1019
61Coverage_Amount_Required_8 SearchCoverage Amount Required[8]DLR19_$S2Currency1019
62Coverage_Amount_Required_9 SearchCoverage Amount Required[9]DLR19_$S2Currency1019
63Coverage_Amount_Required_10 SearchCoverage Amount Required[10]DLR19_$S2Currency1019
64Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean20
65O_M_Manuals SearchO & M ManualsCBBoolean20
66Payment_Bond SearchPayment BondCBBoolean20
67Performance_Bond SearchPerformance BondCBBoolean20
68JC_Required_CB_1 SearchJC Required CB 1CBBoolean20
69JC_Required_CB_2 SearchJC Required CB 2CBBoolean20
70JC_Required_CB_3 SearchJC Required CB 3CBBoolean20
71JC_Required_CB_4 SearchJC Required CB 4CBBoolean20
72JC_Required_CB_5 SearchJC Required CB 5CBBoolean20
73JC_Required_CB_6 SearchJC Required CB 6CBBoolean20
74JC_Required_CB_7 SearchJC Required CB 7CBBoolean20
75JC_Required_CB_8 SearchJC Required CB 8CBBoolean20
76JC_Required_CB_9 SearchJC Required CB 9CBBoolean20
77JC_Required_CB_10 SearchJC Required CB 10CBBoolean20
78JC_Required_CB_11 SearchJC Required CB 11CBBoolean20
79JC_Required_CB_12 SearchJC Required CB 12CBBoolean20
80JC_Required_CB_13 SearchJC Required CB 13CBBoolean20
81JC_Required_CB_14 SearchJC Required CB 14CBBoolean20
82JC_Required_CB_15 SearchJC Required CB 15CBBoolean20
83JC_Required_CB_16 SearchJC Required CB 16CBBoolean20
84JC_Required_CB_17 SearchJC Required CB 17CBBoolean20
85JC_Required_CB_18 SearchJC Required CB 18CBBoolean20
86JC_Required_CB_19 SearchJC Required CB 19CBBoolean20
87JC_Required_CB_20 SearchJC Required CB 20CBBoolean20
88Ins_Expiration_Date SearchInsurance Expiration DateDTDate48
89Lien_Waiver_Req_Date SearchLien Waiver Required DateDTDate48
90O_M_Manuals_Req_Date SearchO & M Manuals Required DateDTDate48
91Payment_Bond_Req_Date SearchPayment Bond Required DateDTDate48
92Performance_Bond_Req_DT SearchPerformance Bond Required DateDTDate48
93JC_Required_Date_1 SearchJC Required Date 1DTDate48
94JC_Required_Date_2 SearchJC Required Date 2DTDate48
95JC_Required_Date_3 SearchJC Required Date 3DTDate48
96JC_Required_Date_4 SearchJC Required Date 4DTDate48
97JC_Required_Date_5 SearchJC Required Date 5DTDate48
98JC_Required_Date_6 SearchJC Required Date 6DTDate48
99JC_Required_Date_7 SearchJC Required Date 7DTDate48
100JC_Required_Date_8 SearchJC Required Date 8DTDate48
101JC_Required_Date_9 SearchJC Required Date 9DTDate48
102JC_Required_Date_10 SearchJC Required Date 10DTDate48
103JC_Required_Date_11 SearchJC Required Date 11DTDate48
104JC_Required_Date_12 SearchJC Required Date 12DTDate48
105JC_Required_Date_13 SearchJC Required Date 13DTDate48
106JC_Required_Date_14 SearchJC Required Date 14DTDate48
107JC_Required_Date_15 SearchJC Required Date 15DTDate48
108JC_Required_Date_16 SearchJC Required Date 16DTDate48
109JC_Required_Date_17 SearchJC Required Date 17DTDate48
110JC_Required_Date_18 SearchJC Required Date 18DTDate48
111JC_Required_Date_19 SearchJC Required Date 19DTDate48
112JC_Required_Date_20 SearchJC Required Date 20DTDate48
113Ins_Cert_Date_Recd SearchInsurance Certificate Date ReceivedDTDate48
114Lien_Waiver_Date_Recd SearchLien Waiver Date ReceivedDTDate48
115O_M_Manuals_Date_Recd SearchO & M Manuals Date ReceivedDTDate48
116Payment_Bond_Date_Recd SearchPayment Bond Date ReceivedDTDate48
117Performance_Bond_DT_Recd SearchPerformance Bond Date ReceivedDTDate48
118JC_Date_Received_1 SearchJC Date Received 1DTDate48
119JC_Date_Received_2 SearchJC Date Received 2DTDate48
120JC_Date_Received_3 SearchJC Date Received 3DTDate48
121JC_Date_Received_4 SearchJC Date Received 4DTDate48
122JC_Date_Received_5 SearchJC Date Received 5DTDate48
123JC_Date_Received_6 SearchJC Date Received 6DTDate48
124JC_Date_Received_7 SearchJC Date Received 7DTDate48
125JC_Date_Received_8 SearchJC Date Received 8DTDate48
126JC_Date_Received_9 SearchJC Date Received 9DTDate48
127JC_Date_Received_10 SearchJC Date Received 10DTDate48
128JC_Date_Received_11 SearchJC Date Received 11DTDate48
129JC_Date_Received_12 SearchJC Date Received 12DTDate48
130JC_Date_Received_13 SearchJC Date Received 13DTDate48
131JC_Date_Received_14 SearchJC Date Received 14DTDate48
132JC_Date_Received_15 SearchJC Date Received 15DTDate48
133JC_Date_Received_16 SearchJC Date Received 16DTDate48
134JC_Date_Received_17 SearchJC Date Received 17DTDate48
135JC_Date_Received_18 SearchJC Date Received 18DTDate48
136JC_Date_Received_19 SearchJC Date Received 19DTDate48
137JC_Date_Received_20 SearchJC Date Received 20DTDate48
138Ins_Cert_Received SearchInsurance Certificate ReceivedCBBoolean20
139Lien_Waiver_Received SearchLien Waiver ReceivedCBBoolean20
140O_M_Manuals_Received SearchO & M Manuals ReceivedCBBoolean20
141Payment_Bond_Received SearchPayment Bond ReceivedCBBoolean20
142Performance_Bond_Receive SearchPerformance Bond ReceivedCBBoolean20
143JC_Required_Received_1 SearchJC Required Received 1CBBoolean20
144JC_Required_Received_2 SearchJC Required Received 2CBBoolean20
145JC_Required_Received_3 SearchJC Required Received 3CBBoolean20
146JC_Required_Received_4 SearchJC Required Received 4CBBoolean20
147JC_Required_Received_5 SearchJC Required Received 5CBBoolean20
148JC_Required_Received_6 SearchJC Required Received 6CBBoolean20
149JC_Required_Received_7 SearchJC Required Received 7CBBoolean20
150JC_Required_Received_8 SearchJC Required Received 8CBBoolean20
151JC_Required_Received_9 SearchJC Required Received 9CBBoolean20
152JC_Required_Received_10 SearchJC Required Received 10CBBoolean20
153JC_Required_Received_11 SearchJC Required Received 11CBBoolean20
154JC_Required_Received_12 SearchJC Required Received 12CBBoolean20
155JC_Required_Received_13 SearchJC Required Received 13CBBoolean20
156JC_Required_Received_14 SearchJC Required Received 14CBBoolean20
157JC_Required_Received_15 SearchJC Required Received 15CBBoolean20
158JC_Required_Received_16 SearchJC Required Received 16CBBoolean20
159JC_Required_Received_17 SearchJC Required Received 17CBBoolean20
160JC_Required_Received_18 SearchJC Required Received 18CBBoolean20
161JC_Required_Received_19 SearchJC Required Received 19CBBoolean20
162JC_Required_Received_20 SearchJC Required Received 20CBBoolean20
163USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Vendor_Master_Dates'].USERID AS 'JC_Vendor_Master_Dates-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01505 AS ['JC_Vendor_Master_Dates']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Vendor_Master_Dates'].USERID = ['Users Master'].USERID
164User_Define_1 SearchUser Define 1STR30String3230
165User_Define_2 SearchUser Define 2STR30String3230
166USERDEF1 SearchUser Defined 1STR20String2220
167USERDEF2 SearchUser Defined 2STR20String2220
168User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
169User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
170User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
171User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
172USRDAT01 SearchUser Defined Date 1DTDate48
173USRDAT02 SearchUser Defined Date 2DTDate48
174User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
175User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
176User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
177User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
178User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
179User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
180User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
181User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
182User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
183User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
184MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Vendor_Master_Dates'].MDFUSRID AS 'JC_Vendor_Master_Dates-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01505 AS ['JC_Vendor_Master_Dates']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Vendor_Master_Dates'].MDFUSRID = ['Users Master'].USERID
185MODIFDT SearchModified DateDTDate48
186Modified_Time SearchModified TimeTM6Time46
187SV_Language_ID SearchSV Language IDINT2Integer22
188Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
189Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
190Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
191WSReserved_CB1 SearchWSReserved CB1CBBoolean20
192WSReserved_CB2 SearchWSReserved CB2CBBoolean20
193WSReserved_CB3 SearchWSReserved CB3CBBoolean20
194WSReserved_CB4 SearchWSReserved CB4CBBoolean20
195WSReserved_CB5 SearchWSReserved CB5CBBoolean20
196WSReserved_STR1 SearchWSReserved STR1STR10String1210
197WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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