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 TypeLength
1Record_Sequence SearchRecord SequenceINT5_RZ_U0Integer5
2Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean0
3Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean0
4O_M_Manuals SearchO & M ManualsCBBoolean0
5Payment_Bond SearchPayment BondCBBoolean0
6Performance_Bond SearchPerformance BondCBBoolean0
7Ins_Certificate_Reminder SearchInsurance Certificate ReminderCBBoolean0
8Lien_Waiver_Reminder SearchLien Waiver ReminderCBBoolean0
9O_M_Manuals_Reminder SearchO & M Manuals ReminderCBBoolean0
10Payment_Bond_Reminder SearchPayment Bond ReminderCBBoolean0
11Performance_Bond_Reminde SearchPerformance Bond ReminderCBBoolean0
12Ins_Certificate_Days SearchInsurance Certificate DaysINT2Integer2
13Lien_Waiver_Days_Notice SearchLien Waiver Days NoticeINT2Integer2
14O_M_Manuals_Days SearchO & M Manuals DaysINT2Integer2
15Payment_Bond_Days_Notice SearchPayment Bond Days NoticeINT2Integer2
16Perform_Bond_Days_Notice SearchPerformance Bond Days NoticeINT2Integer2
17JC_Required_CB_1 SearchJC Required CB 1CBBoolean0
18JC_Required_CB_2 SearchJC Required CB 2CBBoolean0
19JC_Required_CB_3 SearchJC Required CB 3CBBoolean0
20JC_Required_CB_4 SearchJC Required CB 4CBBoolean0
21JC_Required_CB_5 SearchJC Required CB 5CBBoolean0
22JC_Required_CB_6 SearchJC Required CB 6CBBoolean0
23JC_Required_CB_7 SearchJC Required CB 7CBBoolean0
24JC_Required_CB_8 SearchJC Required CB 8CBBoolean0
25JC_Required_CB_9 SearchJC Required CB 9CBBoolean0
26JC_Required_CB_10 SearchJC Required CB 10CBBoolean0
27JC_Required_CB_11 SearchJC Required CB 11CBBoolean0
28JC_Required_CB_12 SearchJC Required CB 12CBBoolean0
29JC_Required_CB_13 SearchJC Required CB 13CBBoolean0
30JC_Required_CB_14 SearchJC Required CB 14CBBoolean0
31JC_Required_CB_15 SearchJC Required CB 15CBBoolean0
32JC_Required_CB_16 SearchJC Required CB 16CBBoolean0
33JC_Required_CB_17 SearchJC Required CB 17CBBoolean0
34JC_Required_CB_18 SearchJC Required CB 18CBBoolean0
35JC_Required_CB_19 SearchJC Required CB 19CBBoolean0
36JC_Required_CB_20 SearchJC Required CB 20CBBoolean0
37JC_Reminder_CB_1 SearchJC Reminder CB 1CBBoolean0
38JC_Reminder_CB_2 SearchJC Reminder CB 2CBBoolean0
39JC_Reminder_CB_3 SearchJC Reminder CB 3CBBoolean0
40JC_Reminder_CB_4 SearchJC Reminder CB 4CBBoolean0
41JC_Reminder_CB_5 SearchJC Reminder CB 5CBBoolean0
42JC_Reminder_CB_6 SearchJC Reminder CB 6CBBoolean0
43JC_Reminder_CB_7 SearchJC Reminder CB 7CBBoolean0
44JC_Reminder_CB_8 SearchJC Reminder CB 8CBBoolean0
45JC_Reminder_CB_9 SearchJC Reminder CB 9CBBoolean0
46JC_Reminder_CB_10 SearchJC Reminder CB 10CBBoolean0
47JC_Reminder_CB_11 SearchJC Reminder CB 11CBBoolean0
48JC_Reminder_CB_12 SearchJC Reminder CB 12CBBoolean0
49JC_Reminder_CB_13 SearchJC Reminder CB 13CBBoolean0
50JC_Reminder_CB_14 SearchJC Reminder CB 14CBBoolean0
51JC_Reminder_CB_15 SearchJC Reminder CB 15CBBoolean0
52JC_Reminder_CB_16 SearchJC Reminder CB 16CBBoolean0
53JC_Reminder_CB_17 SearchJC Reminder CB 17CBBoolean0
54JC_Reminder_CB_18 SearchJC Reminder CB 18CBBoolean0
55JC_Reminder_CB_19 SearchJC Reminder CB 19CBBoolean0
56JC_Reminder_CB_20 SearchJC Reminder CB 20CBBoolean0
57JC_Days_Notice_1 SearchJC Days Notice 1INT2Integer2
58JC_Days_Notice_2 SearchJC Days Notice 2INT2Integer2
59JC_Days_Notice_3 SearchJC Days Notice 3INT2Integer2
60JC_Days_Notice_4 SearchJC Days Notice 4INT2Integer2
61JC_Days_Notice_5 SearchJC Days Notice 5INT2Integer2
62JC_Days_Notice_6 SearchJC Days Notice 6INT2Integer2
63JC_Days_Notice_7 SearchJC Days Notice 7INT2Integer2
64JC_Days_Notice_8 SearchJC Days Notice 8INT2Integer2
65JC_Days_Notice_9 SearchJC Days Notice 9INT2Integer2
66JC_Days_Notice_10 SearchJC Days Notice 10INT2Integer2
67JC_Days_Notice_11 SearchJC Days Notice 11INT2Integer2
68JC_Days_Notice_12 SearchJC Days Notice 12INT2Integer2
69JC_Days_Notice_13 SearchJC Days Notice 13INT2Integer2
70JC_Days_Notice_14 SearchJC Days Notice 14INT2Integer2
71JC_Days_Notice_15 SearchJC Days Notice 15INT2Integer2
72JC_Days_Notice_16 SearchJC Days Notice 16INT2Integer2
73JC_Days_Notice_17 SearchJC Days Notice 17INT2Integer2
74JC_Days_Notice_18 SearchJC Days Notice 18INT2Integer2
75JC_Days_Notice_19 SearchJC Days Notice 19INT2Integer2
76JC_Days_Notice_20 SearchJC Days Notice 20INT2Integer2
77USERID SearchUser IDSTR15_User_IDString15
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 1STR30String30
79User_Define_2 SearchUser Define 2STR30String30
80USERDEF1 SearchUser Defined 1STR20String20
81USERDEF2 SearchUser Defined 2STR20String20
82User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
83User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
84User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
85User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
86User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
87User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
88User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
89User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
90User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
91User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
92User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
93User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
94Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
95Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
96Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
97MODIFDT SearchModified DateDTDate8
98Modified_Time SearchModified TimeTM6Time6
99MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
101Time_Zone SearchTime ZoneSTR3String3
102WSReserved_CB1 SearchWSReserved CB1CBBoolean0
103WSReserved_CB2 SearchWSReserved CB2CBBoolean0
104WSReserved_CB3 SearchWSReserved CB3CBBoolean0
105WSReserved_CB4 SearchWSReserved CB4CBBoolean0
106WSReserved_CB5 SearchWSReserved CB5CBBoolean0

Leave a Reply

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