JC_Master_Vendor_Dates_MSTR (JC01514)

azurecurve Products WennSoft 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 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_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
2	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
3	Ins_Cert_on_File	Insurance Certificate on File	CB	Boolean	0
4	Lien_Waiver_on_File	Lien Waiver on File	CB	Boolean	0
5	O_M_Manuals	O & M Manuals	CB	Boolean	0
6	Payment_Bond	Payment Bond	CB	Boolean	0
7	Performance_Bond	Performance Bond	CB	Boolean	0
8	JC_Required_CB_1	JC Required CB 1	CB	Boolean	0
9	JC_Required_CB_2	JC Required CB 2	CB	Boolean	0
10	JC_Required_CB_3	JC Required CB 3	CB	Boolean	0
11	JC_Required_CB_4	JC Required CB 4	CB	Boolean	0
12	JC_Required_CB_5	JC Required CB 5	CB	Boolean	0
13	JC_Required_CB_6	JC Required CB 6	CB	Boolean	0
14	JC_Required_CB_7	JC Required CB 7	CB	Boolean	0
15	JC_Required_CB_8	JC Required CB 8	CB	Boolean	0
16	JC_Required_CB_9	JC Required CB 9	CB	Boolean	0
17	JC_Required_CB_10	JC Required CB 10	CB	Boolean	0
18	JC_Required_CB_11	JC Required CB 11	CB	Boolean	0
19	JC_Required_CB_12	JC Required CB 12	CB	Boolean	0
20	JC_Required_CB_13	JC Required CB 13	CB	Boolean	0
21	JC_Required_CB_14	JC Required CB 14	CB	Boolean	0
22	JC_Required_CB_15	JC Required CB 15	CB	Boolean	0
23	JC_Required_CB_16	JC Required CB 16	CB	Boolean	0
24	JC_Required_CB_17	JC Required CB 17	CB	Boolean	0
25	JC_Required_CB_18	JC Required CB 18	CB	Boolean	0
26	JC_Required_CB_19	JC Required CB 19	CB	Boolean	0
27	JC_Required_CB_20	JC Required CB 20	CB	Boolean	0
28	Ins_Expiration_Date	Insurance Expiration Date	DT	Date	8
29	Lien_Waiver_Req_Date	Lien Waiver Required Date	DT	Date	8
30	O_M_Manuals_Req_Date	O & M Manuals Required Date	DT	Date	8
31	Payment_Bond_Req_Date	Payment Bond Required Date	DT	Date	8
32	Performance_Bond_Req_DT	Performance Bond Required Date	DT	Date	8
33	JC_Required_Date_1	JC Required Date 1	DT	Date	8
34	JC_Required_Date_2	JC Required Date 2	DT	Date	8
35	JC_Required_Date_3	JC Required Date 3	DT	Date	8
36	JC_Required_Date_4	JC Required Date 4	DT	Date	8
37	JC_Required_Date_5	JC Required Date 5	DT	Date	8
38	JC_Required_Date_6	JC Required Date 6	DT	Date	8
39	JC_Required_Date_7	JC Required Date 7	DT	Date	8
40	JC_Required_Date_8	JC Required Date 8	DT	Date	8
41	JC_Required_Date_9	JC Required Date 9	DT	Date	8
42	JC_Required_Date_10	JC Required Date 10	DT	Date	8
43	JC_Required_Date_11	JC Required Date 11	DT	Date	8
44	JC_Required_Date_12	JC Required Date 12	DT	Date	8
45	JC_Required_Date_13	JC Required Date 13	DT	Date	8
46	JC_Required_Date_14	JC Required Date 14	DT	Date	8
47	JC_Required_Date_15	JC Required Date 15	DT	Date	8
48	JC_Required_Date_16	JC Required Date 16	DT	Date	8
49	JC_Required_Date_17	JC Required Date 17	DT	Date	8
50	JC_Required_Date_18	JC Required Date 18	DT	Date	8
51	JC_Required_Date_19	JC Required Date 19	DT	Date	8
52	JC_Required_Date_20	JC Required Date 20	DT	Date	8
53	Ins_Cert_Date_Recd	Insurance Certificate Date Received	DT	Date	8
54	Lien_Waiver_Date_Recd	Lien Waiver Date Received	DT	Date	8
55	O_M_Manuals_Date_Recd	O & M Manuals Date Received	DT	Date	8
56	Payment_Bond_Date_Recd	Payment Bond Date Received	DT	Date	8
57	Performance_Bond_DT_Recd	Performance Bond Date Received	DT	Date	8
58	JC_Date_Received_1	JC Date Received 1	DT	Date	8
59	JC_Date_Received_2	JC Date Received 2	DT	Date	8
60	JC_Date_Received_3	JC Date Received 3	DT	Date	8
61	JC_Date_Received_4	JC Date Received 4	DT	Date	8
62	JC_Date_Received_5	JC Date Received 5	DT	Date	8
63	JC_Date_Received_6	JC Date Received 6	DT	Date	8
64	JC_Date_Received_7	JC Date Received 7	DT	Date	8
65	JC_Date_Received_8	JC Date Received 8	DT	Date	8
66	JC_Date_Received_9	JC Date Received 9	DT	Date	8
67	JC_Date_Received_10	JC Date Received 10	DT	Date	8
68	JC_Date_Received_11	JC Date Received 11	DT	Date	8
69	JC_Date_Received_12	JC Date Received 12	DT	Date	8
70	JC_Date_Received_13	JC Date Received 13	DT	Date	8
71	JC_Date_Received_14	JC Date Received 14	DT	Date	8
72	JC_Date_Received_15	JC Date Received 15	DT	Date	8
73	JC_Date_Received_16	JC Date Received 16	DT	Date	8
74	JC_Date_Received_17	JC Date Received 17	DT	Date	8
75	JC_Date_Received_18	JC Date Received 18	DT	Date	8
76	JC_Date_Received_19	JC Date Received 19	DT	Date	8
77	JC_Date_Received_20	JC Date Received 20	DT	Date	8
78	Ins_Cert_Received	Insurance Certificate Received	CB	Boolean	0
79	Lien_Waiver_Received	Lien Waiver Received	CB	Boolean	0
80	O_M_Manuals_Received	O & M Manuals Received	CB	Boolean	0
81	Payment_Bond_Received	Payment Bond Received	CB	Boolean	0
82	Performance_Bond_Receive	Performance Bond Received	CB	Boolean	0
83	JC_Required_Received_1	JC Required Received 1	CB	Boolean	0
84	JC_Required_Received_2	JC Required Received 2	CB	Boolean	0
85	JC_Required_Received_3	JC Required Received 3	CB	Boolean	0
86	JC_Required_Received_4	JC Required Received 4	CB	Boolean	0
87	JC_Required_Received_5	JC Required Received 5	CB	Boolean	0
88	JC_Required_Received_6	JC Required Received 6	CB	Boolean	0
89	JC_Required_Received_7	JC Required Received 7	CB	Boolean	0
90	JC_Required_Received_8	JC Required Received 8	CB	Boolean	0
91	JC_Required_Received_9	JC Required Received 9	CB	Boolean	0
92	JC_Required_Received_10	JC Required Received 10	CB	Boolean	0
93	JC_Required_Received_11	JC Required Received 11	CB	Boolean	0
94	JC_Required_Received_12	JC Required Received 12	CB	Boolean	0
95	JC_Required_Received_13	JC Required Received 13	CB	Boolean	0
96	JC_Required_Received_14	JC Required Received 14	CB	Boolean	0
97	JC_Required_Received_15	JC Required Received 15	CB	Boolean	0
98	JC_Required_Received_16	JC Required Received 16	CB	Boolean	0
99	JC_Required_Received_17	JC Required Received 17	CB	Boolean	0
100	JC_Required_Received_18	JC Required Received 18	CB	Boolean	0
101	JC_Required_Received_19	JC Required Received 19	CB	Boolean	0
102	JC_Required_Received_20	JC Required Received 20	CB	Boolean	0
103	USERID	User ID	STR15_User_ID	String	15
	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
104	User_Define_1	User Define 1	STR30	String	30
105	User_Define_2	User Define 2	STR30	String	30
106	USERDEF1	User Defined 1	STR20	String	20
107	USERDEF2	User Defined 2	STR20	String	20
108	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
109	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
110	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
111	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
112	USRDAT01	User Defined Date 1	DT	Date	8
113	USRDAT02	User Defined Date 2	DT	Date	8
114	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
115	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
116	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
117	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
118	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
119	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
120	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
121	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
122	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
123	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
124	MDFUSRID	Modified User ID	STR15	String	15
	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
125	MODIFDT	Modified Date	DT	Date	8
126	Modified_Time	Modified Time	TM6	Time	6
127	SV_Language_ID	SV Language ID	INT2	Integer	2
128	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
129	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
130	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
131	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
132	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
133	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
134	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
135	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
136	WSReserved_STR1	WSReserved STR1	STR10	String	10
137	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartyJC_Master_Vendor_Dates_MSTR (JC01514)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply