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 TypeLength
1TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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_TypeInteger0
3Wennsoft_Tax_Sched_ID_1 SearchWennsoft Tax Schedule ID 1STR15_Tax_Schedule_IDString15
4Wennsoft_Tax_Sched_ID_2 SearchWennsoft Tax Schedule ID 2STR15_Tax_Schedule_IDString15
5Wennsoft_Tax_Sched_ID_3 SearchWennsoft Tax Schedule ID 3STR15_Tax_Schedule_IDString15
6Wennsoft_Tax_Sched_ID_4 SearchWennsoft Tax Schedule ID 4STR15_Tax_Schedule_IDString15
7Wennsoft_Tax_Sched_ID_5 SearchWennsoft Tax Schedule ID 5STR15_Tax_Schedule_IDString15
8Wennsoft_Tax_Sched_ID_6 SearchWennsoft Tax Schedule ID 6STR15_Tax_Schedule_IDString15
9Wennsoft_Tax_Sched_ID_7 SearchWennsoft Tax Schedule ID 7STR15_Tax_Schedule_IDString15
10Wennsoft_Tax_Sched_ID_8 SearchWennsoft Tax Schedule ID 8STR15_Tax_Schedule_IDString15
11Wennsoft_Tax_Sched_ID_9 SearchWennsoft Tax Schedule ID 9STR15_Tax_Schedule_IDString15
12WS_Checkbox1 SearchWS Checkbox1CBBoolean0
13WS_Checkbox_2 SearchWS Checkbox 2CBBoolean0
14WS_Checkbox_3 SearchWS Checkbox 3CBBoolean0
15WS_Checkbox_4 SearchWS Checkbox 4CBBoolean0
16WS_Checkbox_5 SearchWS Checkbox 5CBBoolean0
17WS_Checkbox_6 SearchWS Checkbox 6CBBoolean0
18WS_Checkbox_7 SearchWS Checkbox 7CBBoolean0
19WS_Checkbox_8 SearchWS Checkbox 8CBBoolean0
20WS_Checkbox_9 SearchWS Checkbox 9CBBoolean0
21WS_Checkbox_10 SearchWS Checkbox 10CBBoolean0
22WS_String_1 SearchWS String 1STR20String20
23WS_String_2 SearchWS String 2STR20String20
24WS_String_3 SearchWS String 3STR20String20
25WS_String_4 SearchWS String 4STR20String20
26WS_String_5 SearchWS String 5STR20String20
27Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
28Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
29Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
30MODIFDT SearchModified DateDTDate8
31Modified_Time SearchModified TimeTM6Time6
32MDFUSRID SearchModified User IDSTR15String15
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 ZoneSTR3String3

Leave a Reply

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