JC_Subs_Option_SETP (JC40701)

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

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

Display Name: JC_Subs_Option_SETP
Physical Name: JC40701
Technical Name: JC_Subs_Option_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
2Paid_When_Paid SearchPaid When PaidCBBoolean20
3Reminder SearchReminderCB_ReminderBoolean20
4Days_To_Reminder_Notes SearchDays To Reminder NotesINT2Integer22
5JCCIS_Standard_Rate SearchJCCIS Standard RateSTR10String1210
6JCCIS_Higher_Rate SearchJCCIS Higher RateSTR10String1210
7JCCIS_UTR SearchJCCIS UTRSTR10String1210
8JCCIS_AORef SearchJCCIS AORefSTR20String2220
9JCCIS_GatewayTest SearchJCCIS GatewayTestCBBoolean20
10Document_URL SearchWS Document URLSTR255String256255
11JC_CheckBox_1 SearchJC CheckBox 1CBBoolean20
12JC_CheckBox_2 SearchJC CheckBox 2CBBoolean20
13JC_CheckBox_3 SearchJC CheckBox 3CBBoolean20
14JC_CheckBox_4 SearchJC CheckBox 4CBBoolean20
15JC_CheckBox_5 SearchJC CheckBox 5CBBoolean20
16JC_CheckBox_6 SearchJC CheckBox 6CBBoolean20
17JC_CheckBox_7 SearchJC CheckBox 7CBBoolean20
18JC_CheckBox_8 SearchJC CheckBox 8CBBoolean20
19JC_CheckBox_9 SearchJC CheckBox 9CBBoolean20
20JC_CheckBox_10 SearchJC CheckBox 10CBBoolean20
21WSReserved_CB1 SearchWSReserved CB1CBBoolean20
22WSReserved_CB2 SearchWSReserved CB2CBBoolean20
23WSReserved_CB3 SearchWSReserved CB3CBBoolean20
24WSReserved_CB4 SearchWSReserved CB4CBBoolean20
25WSReserved_CB5 SearchWSReserved CB5CBBoolean20
26WSReserved_CB6 SearchWSReserved CB6CBBoolean20
27WSReserved_CB7 SearchWSReserved CB7CBBoolean20
28WSReserved_CB8 SearchWSReserved CB8CBBoolean20
29WSReserved_CB9 SearchWSReserved CB9CBBoolean20
30WSReserved_CB10 SearchWSReserved CB10CBBoolean20
31WSReserved_STR1 SearchWSReserved STR1STR10String1210
32WSReserved_STR2 SearchWSReserved STR2STR10String1210
33MODIFDT SearchModified DateDTDate48
34Modified_Time SearchModified TimeTM6Time46
35MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Subs_Option_SETP'].MDFUSRID AS 'JC_Subs_Option_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC40701 AS ['JC_Subs_Option_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Subs_Option_SETP'].MDFUSRID = ['Users Master'].USERID
36Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
37Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
38Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
39Time_Zone SearchTime ZoneSTR3String43

Leave a Reply

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