JC_Tax_Schedule_SETP (JC40901)

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

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

Display Name: JC_Tax_Schedule_SETP
Physical Name: JC40901
Technical Name: JC_Tax_Schedule_SETP

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['JC_Tax_Schedule_SETP'].TAXSCHID AS 'JC_Tax_Schedule_SETP-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       JC40901 AS ['JC_Tax_Schedule_SETP']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['JC_Tax_Schedule_SETP'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
2TXDTLTYP SearchTax Detail TypeDDL_Tax_Detail_TypeInteger20
3Wennsoft_Tax_Sched_ID_1 SearchWennsoft Tax Schedule ID 1STR15_Tax_Schedule_IDString1615
4Wennsoft_Tax_Sched_ID_2 SearchWennsoft Tax Schedule ID 2STR15_Tax_Schedule_IDString1615
5Wennsoft_Tax_Sched_ID_3 SearchWennsoft Tax Schedule ID 3STR15_Tax_Schedule_IDString1615
6Wennsoft_Tax_Sched_ID_4 SearchWennsoft Tax Schedule ID 4STR15_Tax_Schedule_IDString1615
7Wennsoft_Tax_Sched_ID_5 SearchWennsoft Tax Schedule ID 5STR15_Tax_Schedule_IDString1615
8Wennsoft_Tax_Sched_ID_6 SearchWennsoft Tax Schedule ID 6STR15_Tax_Schedule_IDString1615
9Wennsoft_Tax_Sched_ID_7 SearchWennsoft Tax Schedule ID 7STR15_Tax_Schedule_IDString1615
10Wennsoft_Tax_Sched_ID_8 SearchWennsoft Tax Schedule ID 8STR15_Tax_Schedule_IDString1615
11Wennsoft_Tax_Sched_ID_9 SearchWennsoft Tax Schedule ID 9STR15_Tax_Schedule_IDString1615
12WS_Checkbox1 SearchWS Checkbox1CBBoolean20
13WS_Checkbox_2 SearchWS Checkbox 2CBBoolean20
14WS_Checkbox_3 SearchWS Checkbox 3CBBoolean20
15WS_Checkbox_4 SearchWS Checkbox 4CBBoolean20
16WS_Checkbox_5 SearchWS Checkbox 5CBBoolean20
17WS_Checkbox_6 SearchWS Checkbox 6CBBoolean20
18WS_Checkbox_7 SearchWS Checkbox 7CBBoolean20
19WS_Checkbox_8 SearchWS Checkbox 8CBBoolean20
20WS_Checkbox_9 SearchWS Checkbox 9CBBoolean20
21WS_Checkbox_10 SearchWS Checkbox 10CBBoolean20
22WS_String_1 SearchWS String 1STR20String2220
23WS_String_2 SearchWS String 2STR20String2220
24WS_String_3 SearchWS String 3STR20String2220
25WS_String_4 SearchWS String 4STR20String2220
26WS_String_5 SearchWS String 5STR20String2220
27Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
28Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
29Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
30MODIFDT SearchModified DateDTDate48
31Modified_Time SearchModified TimeTM6Time46
32MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Tax_Schedule_SETP'].MDFUSRID AS 'JC_Tax_Schedule_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC40901 AS ['JC_Tax_Schedule_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Tax_Schedule_SETP'].MDFUSRID = ['Users Master'].USERID
33Time_Zone SearchTime ZoneSTR3String43

Leave a Reply

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