SV_Invoice_Tax_Option_MSTR (SV000789)

azurecurveProductsWennSoft Products (131)3rd PartySV_Invoice_Tax_Option_MSTR (SV000789)

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

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

Display Name: SV_Invoice_Tax_Option_MSTR
Physical Name: SV000789
Technical Name: SV_Invoice_Tax_Option_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

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
       ['SV_Invoice_Tax_Option_MSTR'].TAXSCHID AS 'SV_Invoice_Tax_Option_MSTR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SV000789 AS ['SV_Invoice_Tax_Option_MSTR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SV_Invoice_Tax_Option_MSTR'].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
8WS_Checkbox1 SearchWS Checkbox1CBBoolean0
9WS_Checkbox_2 SearchWS Checkbox 2CBBoolean0
10WS_Checkbox_3 SearchWS Checkbox 3CBBoolean0
11WS_Checkbox_4 SearchWS Checkbox 4CBBoolean0
12WS_Checkbox_5 SearchWS Checkbox 5CBBoolean0
13WS_Checkbox_6 SearchWS Checkbox 6CBBoolean0
14WS_Checkbox_7 SearchWS Checkbox 7CBBoolean0
15WS_Checkbox_8 SearchWS Checkbox 8CBBoolean0
16WS_Checkbox_9 SearchWS Checkbox 9CBBoolean0
17WS_Checkbox_10 SearchWS Checkbox 10CBBoolean0
18WS_String_1 SearchWS String 1STR20String20
19WS_String_2 SearchWS String 2STR20String20
20WS_String_3 SearchWS String 3STR20String20
21WS_String_4 SearchWS String 4STR20String20
22WS_String_5 SearchWS String 5STR20String20
23WS_Percent_1 SearchWS Percent 1INT5_%2Integer5
24WS_Percent_2 SearchWS Percent 2INT5_%2Integer5
25WS_Percent_3 SearchWS Percent 3INT5_%2Integer5
26WS_Percent_4 SearchWS Percent 4INT5_%2Integer5
27WS_Percent_5 SearchWS Percent 5INT5_%2Integer5
28Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
29Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
30Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
31MODIFDT SearchModified DateDTDate8
32Modified_Time SearchModified TimeTM6Time6
33MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Invoice_Tax_Option_MSTR'].MDFUSRID AS 'SV_Invoice_Tax_Option_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV000789 AS ['SV_Invoice_Tax_Option_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Invoice_Tax_Option_MSTR'].MDFUSRID = ['Users Master'].USERID
34Time_Zone SearchTime ZoneSTR3String3
azurecurveProductsWennSoft Products (131)3rd PartySV_Invoice_Tax_Option_MSTR (SV000789)

Leave a Reply

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