JC_Subs_Dates_SETP (JC40702)

azurecurve Products WennSoft Products (131)3rd PartyJC_Subs_Dates_SETP (JC40702)

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

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

Display Name: JC_Subs_Dates_SETP
Physical Name: JC40702
Technical Name: JC_Subs_Dates_SETP

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Record_Sequence	Record Sequence	INT5_RZ_U0	Integer	5
2	Ins_Cert_on_File	Insurance Certificate on File	CB	Boolean	0
3	Lien_Waiver_on_File	Lien Waiver on File	CB	Boolean	0
4	O_M_Manuals	O & M Manuals	CB	Boolean	0
5	Payment_Bond	Payment Bond	CB	Boolean	0
6	Performance_Bond	Performance Bond	CB	Boolean	0
7	Ins_Certificate_Reminder	Insurance Certificate Reminder	CB	Boolean	0
8	Lien_Waiver_Reminder	Lien Waiver Reminder	CB	Boolean	0
9	O_M_Manuals_Reminder	O & M Manuals Reminder	CB	Boolean	0
10	Payment_Bond_Reminder	Payment Bond Reminder	CB	Boolean	0
11	Performance_Bond_Reminde	Performance Bond Reminder	CB	Boolean	0
12	Ins_Certificate_Days	Insurance Certificate Days	INT2	Integer	2
13	Lien_Waiver_Days_Notice	Lien Waiver Days Notice	INT2	Integer	2
14	O_M_Manuals_Days	O & M Manuals Days	INT2	Integer	2
15	Payment_Bond_Days_Notice	Payment Bond Days Notice	INT2	Integer	2
16	Perform_Bond_Days_Notice	Performance Bond Days Notice	INT2	Integer	2
17	JC_Required_CB_1	JC Required CB 1	CB	Boolean	0
18	JC_Required_CB_2	JC Required CB 2	CB	Boolean	0
19	JC_Required_CB_3	JC Required CB 3	CB	Boolean	0
20	JC_Required_CB_4	JC Required CB 4	CB	Boolean	0
21	JC_Required_CB_5	JC Required CB 5	CB	Boolean	0
22	JC_Required_CB_6	JC Required CB 6	CB	Boolean	0
23	JC_Required_CB_7	JC Required CB 7	CB	Boolean	0
24	JC_Required_CB_8	JC Required CB 8	CB	Boolean	0
25	JC_Required_CB_9	JC Required CB 9	CB	Boolean	0
26	JC_Required_CB_10	JC Required CB 10	CB	Boolean	0
27	JC_Required_CB_11	JC Required CB 11	CB	Boolean	0
28	JC_Required_CB_12	JC Required CB 12	CB	Boolean	0
29	JC_Required_CB_13	JC Required CB 13	CB	Boolean	0
30	JC_Required_CB_14	JC Required CB 14	CB	Boolean	0
31	JC_Required_CB_15	JC Required CB 15	CB	Boolean	0
32	JC_Required_CB_16	JC Required CB 16	CB	Boolean	0
33	JC_Required_CB_17	JC Required CB 17	CB	Boolean	0
34	JC_Required_CB_18	JC Required CB 18	CB	Boolean	0
35	JC_Required_CB_19	JC Required CB 19	CB	Boolean	0
36	JC_Required_CB_20	JC Required CB 20	CB	Boolean	0
37	JC_Reminder_CB_1	JC Reminder CB 1	CB	Boolean	0
38	JC_Reminder_CB_2	JC Reminder CB 2	CB	Boolean	0
39	JC_Reminder_CB_3	JC Reminder CB 3	CB	Boolean	0
40	JC_Reminder_CB_4	JC Reminder CB 4	CB	Boolean	0
41	JC_Reminder_CB_5	JC Reminder CB 5	CB	Boolean	0
42	JC_Reminder_CB_6	JC Reminder CB 6	CB	Boolean	0
43	JC_Reminder_CB_7	JC Reminder CB 7	CB	Boolean	0
44	JC_Reminder_CB_8	JC Reminder CB 8	CB	Boolean	0
45	JC_Reminder_CB_9	JC Reminder CB 9	CB	Boolean	0
46	JC_Reminder_CB_10	JC Reminder CB 10	CB	Boolean	0
47	JC_Reminder_CB_11	JC Reminder CB 11	CB	Boolean	0
48	JC_Reminder_CB_12	JC Reminder CB 12	CB	Boolean	0
49	JC_Reminder_CB_13	JC Reminder CB 13	CB	Boolean	0
50	JC_Reminder_CB_14	JC Reminder CB 14	CB	Boolean	0
51	JC_Reminder_CB_15	JC Reminder CB 15	CB	Boolean	0
52	JC_Reminder_CB_16	JC Reminder CB 16	CB	Boolean	0
53	JC_Reminder_CB_17	JC Reminder CB 17	CB	Boolean	0
54	JC_Reminder_CB_18	JC Reminder CB 18	CB	Boolean	0
55	JC_Reminder_CB_19	JC Reminder CB 19	CB	Boolean	0
56	JC_Reminder_CB_20	JC Reminder CB 20	CB	Boolean	0
57	JC_Days_Notice_1	JC Days Notice 1	INT2	Integer	2
58	JC_Days_Notice_2	JC Days Notice 2	INT2	Integer	2
59	JC_Days_Notice_3	JC Days Notice 3	INT2	Integer	2
60	JC_Days_Notice_4	JC Days Notice 4	INT2	Integer	2
61	JC_Days_Notice_5	JC Days Notice 5	INT2	Integer	2
62	JC_Days_Notice_6	JC Days Notice 6	INT2	Integer	2
63	JC_Days_Notice_7	JC Days Notice 7	INT2	Integer	2
64	JC_Days_Notice_8	JC Days Notice 8	INT2	Integer	2
65	JC_Days_Notice_9	JC Days Notice 9	INT2	Integer	2
66	JC_Days_Notice_10	JC Days Notice 10	INT2	Integer	2
67	JC_Days_Notice_11	JC Days Notice 11	INT2	Integer	2
68	JC_Days_Notice_12	JC Days Notice 12	INT2	Integer	2
69	JC_Days_Notice_13	JC Days Notice 13	INT2	Integer	2
70	JC_Days_Notice_14	JC Days Notice 14	INT2	Integer	2
71	JC_Days_Notice_15	JC Days Notice 15	INT2	Integer	2
72	JC_Days_Notice_16	JC Days Notice 16	INT2	Integer	2
73	JC_Days_Notice_17	JC Days Notice 17	INT2	Integer	2
74	JC_Days_Notice_18	JC Days Notice 18	INT2	Integer	2
75	JC_Days_Notice_19	JC Days Notice 19	INT2	Integer	2
76	JC_Days_Notice_20	JC Days Notice 20	INT2	Integer	2
77	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Subs_Dates_SETP'].USERID AS 'JC_Subs_Dates_SETP-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC40702 AS ['JC_Subs_Dates_SETP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Subs_Dates_SETP'].USERID = ['Users Master'].USERID
78	User_Define_1	User Define 1	STR30	String	30
79	User_Define_2	User Define 2	STR30	String	30
80	USERDEF1	User Defined 1	STR20	String	20
81	USERDEF2	User Defined 2	STR20	String	20
82	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
83	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
84	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
85	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
86	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
87	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
88	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
89	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
90	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
91	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
92	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
93	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
94	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
95	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
96	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
97	MODIFDT	Modified Date	DT	Date	8
98	Modified_Time	Modified Time	TM6	Time	6
99	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Subs_Dates_SETP'].MDFUSRID AS 'JC_Subs_Dates_SETP-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC40702 AS ['JC_Subs_Dates_SETP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Subs_Dates_SETP'].MDFUSRID = ['Users Master'].USERID
100	SV_Language_ID	SV Language ID	INT2	Integer	2
101	Time_Zone	Time Zone	STR3	String	3
102	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
103	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
104	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
105	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
106	WSReserved_CB5	WSReserved CB5	CB	Boolean	0

azurecurve Products WennSoft Products (131)3rd PartyJC_Subs_Dates_SETP (JC40702)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply