JC_Vendor_Master_Dates (JC01505)

azurecurve Products WennSoft Products (131)3rd PartyJC_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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	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
2	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
3	Ins_Cert_on_File	Insurance Certificate on File	CB	Boolean	0
4	Insurance_Starting_Date_1	Insurance Starting Date[1]	Date	Date	10
5	Insurance_Starting_Date_2	Insurance Starting Date[2]	Date	Date	10
6	Insurance_Starting_Date_3	Insurance Starting Date[3]	Date	Date	10
7	Insurance_Starting_Date_4	Insurance Starting Date[4]	Date	Date	10
8	Insurance_Starting_Date_5	Insurance Starting Date[5]	Date	Date	10
9	Insurance_Starting_Date_6	Insurance Starting Date[6]	Date	Date	10
10	Insurance_Starting_Date_7	Insurance Starting Date[7]	Date	Date	10
11	Insurance_Starting_Date_8	Insurance Starting Date[8]	Date	Date	10
12	Insurance_Starting_Date_9	Insurance Starting Date[9]	Date	Date	10
13	Insurance_Starting_Date_10	Insurance Starting Date[10]	Date	Date	10
14	Insurance_Ending_Date_1	Insurance Ending Date[1]	Date	Date	10
15	Insurance_Ending_Date_2	Insurance Ending Date[2]	Date	Date	10
16	Insurance_Ending_Date_3	Insurance Ending Date[3]	Date	Date	10
17	Insurance_Ending_Date_4	Insurance Ending Date[4]	Date	Date	10
18	Insurance_Ending_Date_5	Insurance Ending Date[5]	Date	Date	10
19	Insurance_Ending_Date_6	Insurance Ending Date[6]	Date	Date	10
20	Insurance_Ending_Date_7	Insurance Ending Date[7]	Date	Date	10
21	Insurance_Ending_Date_8	Insurance Ending Date[8]	Date	Date	10
22	Insurance_Ending_Date_9	Insurance Ending Date[9]	Date	Date	10
23	Insurance_Ending_Date_10	Insurance Ending Date[10]	Date	Date	10
24	Insurance_Company_1	Insurance Company[1]	STR30	String	30
25	Insurance_Company_2	Insurance Company[2]	STR30	String	30
26	Insurance_Company_3	Insurance Company[3]	STR30	String	30
27	Insurance_Company_4	Insurance Company[4]	STR30	String	30
28	Insurance_Company_5	Insurance Company[5]	STR30	String	30
29	Insurance_Company_6	Insurance Company[6]	STR30	String	30
30	Insurance_Company_7	Insurance Company[7]	STR30	String	30
31	Insurance_Company_8	Insurance Company[8]	STR30	String	30
32	Insurance_Company_9	Insurance Company[9]	STR30	String	30
33	Insurance_Company_10	Insurance Company[10]	STR30	String	30
34	Insurance_Policy_Number_1	Insurance Policy Number[1]	STR30	String	30
35	Insurance_Policy_Number_2	Insurance Policy Number[2]	STR30	String	30
36	Insurance_Policy_Number_3	Insurance Policy Number[3]	STR30	String	30
37	Insurance_Policy_Number_4	Insurance Policy Number[4]	STR30	String	30
38	Insurance_Policy_Number_5	Insurance Policy Number[5]	STR30	String	30
39	Insurance_Policy_Number_6	Insurance Policy Number[6]	STR30	String	30
40	Insurance_Policy_Number_7	Insurance Policy Number[7]	STR30	String	30
41	Insurance_Policy_Number_8	Insurance Policy Number[8]	STR30	String	30
42	Insurance_Policy_Number_9	Insurance Policy Number[9]	STR30	String	30
43	Insurance_Policy_Number_10	Insurance Policy Number[10]	STR30	String	30
44	Coverage_Amount_Availabl_1	Coverage Amount Available[1]	DLR19_$S2	Currency	19
45	Coverage_Amount_Availabl_2	Coverage Amount Available[2]	DLR19_$S2	Currency	19
46	Coverage_Amount_Availabl_3	Coverage Amount Available[3]	DLR19_$S2	Currency	19
47	Coverage_Amount_Availabl_4	Coverage Amount Available[4]	DLR19_$S2	Currency	19
48	Coverage_Amount_Availabl_5	Coverage Amount Available[5]	DLR19_$S2	Currency	19
49	Coverage_Amount_Availabl_6	Coverage Amount Available[6]	DLR19_$S2	Currency	19
50	Coverage_Amount_Availabl_7	Coverage Amount Available[7]	DLR19_$S2	Currency	19
51	Coverage_Amount_Availabl_8	Coverage Amount Available[8]	DLR19_$S2	Currency	19
52	Coverage_Amount_Availabl_9	Coverage Amount Available[9]	DLR19_$S2	Currency	19
53	Coverage_Amount_Availabl_10	Coverage Amount Available[10]	DLR19_$S2	Currency	19
54	Coverage_Amount_Required_1	Coverage Amount Required[1]	DLR19_$S2	Currency	19
55	Coverage_Amount_Required_2	Coverage Amount Required[2]	DLR19_$S2	Currency	19
56	Coverage_Amount_Required_3	Coverage Amount Required[3]	DLR19_$S2	Currency	19
57	Coverage_Amount_Required_4	Coverage Amount Required[4]	DLR19_$S2	Currency	19
58	Coverage_Amount_Required_5	Coverage Amount Required[5]	DLR19_$S2	Currency	19
59	Coverage_Amount_Required_6	Coverage Amount Required[6]	DLR19_$S2	Currency	19
60	Coverage_Amount_Required_7	Coverage Amount Required[7]	DLR19_$S2	Currency	19
61	Coverage_Amount_Required_8	Coverage Amount Required[8]	DLR19_$S2	Currency	19
62	Coverage_Amount_Required_9	Coverage Amount Required[9]	DLR19_$S2	Currency	19
63	Coverage_Amount_Required_10	Coverage Amount Required[10]	DLR19_$S2	Currency	19
64	Lien_Waiver_on_File	Lien Waiver on File	CB	Boolean	0
65	O_M_Manuals	O & M Manuals	CB	Boolean	0
66	Payment_Bond	Payment Bond	CB	Boolean	0
67	Performance_Bond	Performance Bond	CB	Boolean	0
68	JC_Required_CB_1	JC Required CB 1	CB	Boolean	0
69	JC_Required_CB_2	JC Required CB 2	CB	Boolean	0
70	JC_Required_CB_3	JC Required CB 3	CB	Boolean	0
71	JC_Required_CB_4	JC Required CB 4	CB	Boolean	0
72	JC_Required_CB_5	JC Required CB 5	CB	Boolean	0
73	JC_Required_CB_6	JC Required CB 6	CB	Boolean	0
74	JC_Required_CB_7	JC Required CB 7	CB	Boolean	0
75	JC_Required_CB_8	JC Required CB 8	CB	Boolean	0
76	JC_Required_CB_9	JC Required CB 9	CB	Boolean	0
77	JC_Required_CB_10	JC Required CB 10	CB	Boolean	0
78	JC_Required_CB_11	JC Required CB 11	CB	Boolean	0
79	JC_Required_CB_12	JC Required CB 12	CB	Boolean	0
80	JC_Required_CB_13	JC Required CB 13	CB	Boolean	0
81	JC_Required_CB_14	JC Required CB 14	CB	Boolean	0
82	JC_Required_CB_15	JC Required CB 15	CB	Boolean	0
83	JC_Required_CB_16	JC Required CB 16	CB	Boolean	0
84	JC_Required_CB_17	JC Required CB 17	CB	Boolean	0
85	JC_Required_CB_18	JC Required CB 18	CB	Boolean	0
86	JC_Required_CB_19	JC Required CB 19	CB	Boolean	0
87	JC_Required_CB_20	JC Required CB 20	CB	Boolean	0
88	Ins_Expiration_Date	Insurance Expiration Date	DT	Date	8
89	Lien_Waiver_Req_Date	Lien Waiver Required Date	DT	Date	8
90	O_M_Manuals_Req_Date	O & M Manuals Required Date	DT	Date	8
91	Payment_Bond_Req_Date	Payment Bond Required Date	DT	Date	8
92	Performance_Bond_Req_DT	Performance Bond Required Date	DT	Date	8
93	JC_Required_Date_1	JC Required Date 1	DT	Date	8
94	JC_Required_Date_2	JC Required Date 2	DT	Date	8
95	JC_Required_Date_3	JC Required Date 3	DT	Date	8
96	JC_Required_Date_4	JC Required Date 4	DT	Date	8
97	JC_Required_Date_5	JC Required Date 5	DT	Date	8
98	JC_Required_Date_6	JC Required Date 6	DT	Date	8
99	JC_Required_Date_7	JC Required Date 7	DT	Date	8
100	JC_Required_Date_8	JC Required Date 8	DT	Date	8
101	JC_Required_Date_9	JC Required Date 9	DT	Date	8
102	JC_Required_Date_10	JC Required Date 10	DT	Date	8
103	JC_Required_Date_11	JC Required Date 11	DT	Date	8
104	JC_Required_Date_12	JC Required Date 12	DT	Date	8
105	JC_Required_Date_13	JC Required Date 13	DT	Date	8
106	JC_Required_Date_14	JC Required Date 14	DT	Date	8
107	JC_Required_Date_15	JC Required Date 15	DT	Date	8
108	JC_Required_Date_16	JC Required Date 16	DT	Date	8
109	JC_Required_Date_17	JC Required Date 17	DT	Date	8
110	JC_Required_Date_18	JC Required Date 18	DT	Date	8
111	JC_Required_Date_19	JC Required Date 19	DT	Date	8
112	JC_Required_Date_20	JC Required Date 20	DT	Date	8
113	Ins_Cert_Date_Recd	Insurance Certificate Date Received	DT	Date	8
114	Lien_Waiver_Date_Recd	Lien Waiver Date Received	DT	Date	8
115	O_M_Manuals_Date_Recd	O & M Manuals Date Received	DT	Date	8
116	Payment_Bond_Date_Recd	Payment Bond Date Received	DT	Date	8
117	Performance_Bond_DT_Recd	Performance Bond Date Received	DT	Date	8
118	JC_Date_Received_1	JC Date Received 1	DT	Date	8
119	JC_Date_Received_2	JC Date Received 2	DT	Date	8
120	JC_Date_Received_3	JC Date Received 3	DT	Date	8
121	JC_Date_Received_4	JC Date Received 4	DT	Date	8
122	JC_Date_Received_5	JC Date Received 5	DT	Date	8
123	JC_Date_Received_6	JC Date Received 6	DT	Date	8
124	JC_Date_Received_7	JC Date Received 7	DT	Date	8
125	JC_Date_Received_8	JC Date Received 8	DT	Date	8
126	JC_Date_Received_9	JC Date Received 9	DT	Date	8
127	JC_Date_Received_10	JC Date Received 10	DT	Date	8
128	JC_Date_Received_11	JC Date Received 11	DT	Date	8
129	JC_Date_Received_12	JC Date Received 12	DT	Date	8
130	JC_Date_Received_13	JC Date Received 13	DT	Date	8
131	JC_Date_Received_14	JC Date Received 14	DT	Date	8
132	JC_Date_Received_15	JC Date Received 15	DT	Date	8
133	JC_Date_Received_16	JC Date Received 16	DT	Date	8
134	JC_Date_Received_17	JC Date Received 17	DT	Date	8
135	JC_Date_Received_18	JC Date Received 18	DT	Date	8
136	JC_Date_Received_19	JC Date Received 19	DT	Date	8
137	JC_Date_Received_20	JC Date Received 20	DT	Date	8
138	Ins_Cert_Received	Insurance Certificate Received	CB	Boolean	0
139	Lien_Waiver_Received	Lien Waiver Received	CB	Boolean	0
140	O_M_Manuals_Received	O & M Manuals Received	CB	Boolean	0
141	Payment_Bond_Received	Payment Bond Received	CB	Boolean	0
142	Performance_Bond_Receive	Performance Bond Received	CB	Boolean	0
143	JC_Required_Received_1	JC Required Received 1	CB	Boolean	0
144	JC_Required_Received_2	JC Required Received 2	CB	Boolean	0
145	JC_Required_Received_3	JC Required Received 3	CB	Boolean	0
146	JC_Required_Received_4	JC Required Received 4	CB	Boolean	0
147	JC_Required_Received_5	JC Required Received 5	CB	Boolean	0
148	JC_Required_Received_6	JC Required Received 6	CB	Boolean	0
149	JC_Required_Received_7	JC Required Received 7	CB	Boolean	0
150	JC_Required_Received_8	JC Required Received 8	CB	Boolean	0
151	JC_Required_Received_9	JC Required Received 9	CB	Boolean	0
152	JC_Required_Received_10	JC Required Received 10	CB	Boolean	0
153	JC_Required_Received_11	JC Required Received 11	CB	Boolean	0
154	JC_Required_Received_12	JC Required Received 12	CB	Boolean	0
155	JC_Required_Received_13	JC Required Received 13	CB	Boolean	0
156	JC_Required_Received_14	JC Required Received 14	CB	Boolean	0
157	JC_Required_Received_15	JC Required Received 15	CB	Boolean	0
158	JC_Required_Received_16	JC Required Received 16	CB	Boolean	0
159	JC_Required_Received_17	JC Required Received 17	CB	Boolean	0
160	JC_Required_Received_18	JC Required Received 18	CB	Boolean	0
161	JC_Required_Received_19	JC Required Received 19	CB	Boolean	0
162	JC_Required_Received_20	JC Required Received 20	CB	Boolean	0
163	USERID	User ID	STR15_User_ID	String	15
	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
164	User_Define_1	User Define 1	STR30	String	30
165	User_Define_2	User Define 2	STR30	String	30
166	USERDEF1	User Defined 1	STR20	String	20
167	USERDEF2	User Defined 2	STR20	String	20
168	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
169	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
170	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
171	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
172	USRDAT01	User Defined Date 1	DT	Date	8
173	USRDAT02	User Defined Date 2	DT	Date	8
174	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
175	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
176	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
177	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
178	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
179	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
180	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
181	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
182	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
183	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
184	MDFUSRID	Modified User ID	STR15	String	15
	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
185	MODIFDT	Modified Date	DT	Date	8
186	Modified_Time	Modified Time	TM6	Time	6
187	SV_Language_ID	SV Language ID	INT2	Integer	2
188	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
189	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
190	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
191	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
192	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
193	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
194	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
195	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
196	WSReserved_STR1	WSReserved STR1	STR10	String	10
197	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartyJC_Vendor_Master_Dates (JC01505)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply