JC_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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Record_Sequence SearchRecord SequenceINT5_RZ_U0Integer25
2Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean20
3Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean20
4O_M_Manuals SearchO & M ManualsCBBoolean20
5Payment_Bond SearchPayment BondCBBoolean20
6Performance_Bond SearchPerformance BondCBBoolean20
7Ins_Certificate_Reminder SearchInsurance Certificate ReminderCBBoolean20
8Lien_Waiver_Reminder SearchLien Waiver ReminderCBBoolean20
9O_M_Manuals_Reminder SearchO & M Manuals ReminderCBBoolean20
10Payment_Bond_Reminder SearchPayment Bond ReminderCBBoolean20
11Performance_Bond_Reminde SearchPerformance Bond ReminderCBBoolean20
12Ins_Certificate_Days SearchInsurance Certificate DaysINT2Integer22
13Lien_Waiver_Days_Notice SearchLien Waiver Days NoticeINT2Integer22
14O_M_Manuals_Days SearchO & M Manuals DaysINT2Integer22
15Payment_Bond_Days_Notice SearchPayment Bond Days NoticeINT2Integer22
16Perform_Bond_Days_Notice SearchPerformance Bond Days NoticeINT2Integer22
17JC_Required_CB_1 SearchJC Required CB 1CBBoolean20
18JC_Required_CB_2 SearchJC Required CB 2CBBoolean20
19JC_Required_CB_3 SearchJC Required CB 3CBBoolean20
20JC_Required_CB_4 SearchJC Required CB 4CBBoolean20
21JC_Required_CB_5 SearchJC Required CB 5CBBoolean20
22JC_Required_CB_6 SearchJC Required CB 6CBBoolean20
23JC_Required_CB_7 SearchJC Required CB 7CBBoolean20
24JC_Required_CB_8 SearchJC Required CB 8CBBoolean20
25JC_Required_CB_9 SearchJC Required CB 9CBBoolean20
26JC_Required_CB_10 SearchJC Required CB 10CBBoolean20
27JC_Required_CB_11 SearchJC Required CB 11CBBoolean20
28JC_Required_CB_12 SearchJC Required CB 12CBBoolean20
29JC_Required_CB_13 SearchJC Required CB 13CBBoolean20
30JC_Required_CB_14 SearchJC Required CB 14CBBoolean20
31JC_Required_CB_15 SearchJC Required CB 15CBBoolean20
32JC_Required_CB_16 SearchJC Required CB 16CBBoolean20
33JC_Required_CB_17 SearchJC Required CB 17CBBoolean20
34JC_Required_CB_18 SearchJC Required CB 18CBBoolean20
35JC_Required_CB_19 SearchJC Required CB 19CBBoolean20
36JC_Required_CB_20 SearchJC Required CB 20CBBoolean20
37JC_Reminder_CB_1 SearchJC Reminder CB 1CBBoolean20
38JC_Reminder_CB_2 SearchJC Reminder CB 2CBBoolean20
39JC_Reminder_CB_3 SearchJC Reminder CB 3CBBoolean20
40JC_Reminder_CB_4 SearchJC Reminder CB 4CBBoolean20
41JC_Reminder_CB_5 SearchJC Reminder CB 5CBBoolean20
42JC_Reminder_CB_6 SearchJC Reminder CB 6CBBoolean20
43JC_Reminder_CB_7 SearchJC Reminder CB 7CBBoolean20
44JC_Reminder_CB_8 SearchJC Reminder CB 8CBBoolean20
45JC_Reminder_CB_9 SearchJC Reminder CB 9CBBoolean20
46JC_Reminder_CB_10 SearchJC Reminder CB 10CBBoolean20
47JC_Reminder_CB_11 SearchJC Reminder CB 11CBBoolean20
48JC_Reminder_CB_12 SearchJC Reminder CB 12CBBoolean20
49JC_Reminder_CB_13 SearchJC Reminder CB 13CBBoolean20
50JC_Reminder_CB_14 SearchJC Reminder CB 14CBBoolean20
51JC_Reminder_CB_15 SearchJC Reminder CB 15CBBoolean20
52JC_Reminder_CB_16 SearchJC Reminder CB 16CBBoolean20
53JC_Reminder_CB_17 SearchJC Reminder CB 17CBBoolean20
54JC_Reminder_CB_18 SearchJC Reminder CB 18CBBoolean20
55JC_Reminder_CB_19 SearchJC Reminder CB 19CBBoolean20
56JC_Reminder_CB_20 SearchJC Reminder CB 20CBBoolean20
57JC_Days_Notice_1 SearchJC Days Notice 1INT2Integer22
58JC_Days_Notice_2 SearchJC Days Notice 2INT2Integer22
59JC_Days_Notice_3 SearchJC Days Notice 3INT2Integer22
60JC_Days_Notice_4 SearchJC Days Notice 4INT2Integer22
61JC_Days_Notice_5 SearchJC Days Notice 5INT2Integer22
62JC_Days_Notice_6 SearchJC Days Notice 6INT2Integer22
63JC_Days_Notice_7 SearchJC Days Notice 7INT2Integer22
64JC_Days_Notice_8 SearchJC Days Notice 8INT2Integer22
65JC_Days_Notice_9 SearchJC Days Notice 9INT2Integer22
66JC_Days_Notice_10 SearchJC Days Notice 10INT2Integer22
67JC_Days_Notice_11 SearchJC Days Notice 11INT2Integer22
68JC_Days_Notice_12 SearchJC Days Notice 12INT2Integer22
69JC_Days_Notice_13 SearchJC Days Notice 13INT2Integer22
70JC_Days_Notice_14 SearchJC Days Notice 14INT2Integer22
71JC_Days_Notice_15 SearchJC Days Notice 15INT2Integer22
72JC_Days_Notice_16 SearchJC Days Notice 16INT2Integer22
73JC_Days_Notice_17 SearchJC Days Notice 17INT2Integer22
74JC_Days_Notice_18 SearchJC Days Notice 18INT2Integer22
75JC_Days_Notice_19 SearchJC Days Notice 19INT2Integer22
76JC_Days_Notice_20 SearchJC Days Notice 20INT2Integer22
77USERID SearchUser IDSTR15_User_IDString1615
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
78User_Define_1 SearchUser Define 1STR30String3230
79User_Define_2 SearchUser Define 2STR30String3230
80USERDEF1 SearchUser Defined 1STR20String2220
81USERDEF2 SearchUser Defined 2STR20String2220
82User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
83User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
84User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
85User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
86User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
87User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
88User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
89User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
90User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
91User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
92User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
93User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
94Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
95Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
96Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
97MODIFDT SearchModified DateDTDate48
98Modified_Time SearchModified TimeTM6Time46
99MDFUSRID SearchModified User IDSTR15String1615
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
100SV_Language_ID SearchSV Language IDINT2Integer22
101Time_Zone SearchTime ZoneSTR3String43
102WSReserved_CB1 SearchWSReserved CB1CBBoolean20
103WSReserved_CB2 SearchWSReserved CB2CBBoolean20
104WSReserved_CB3 SearchWSReserved CB3CBBoolean20
105WSReserved_CB4 SearchWSReserved CB4CBBoolean20
106WSReserved_CB5 SearchWSReserved CB5CBBoolean20

Leave a Reply

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