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 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
       ['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_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
8WS_Checkbox1 SearchWS Checkbox1CBBoolean20
9WS_Checkbox_2 SearchWS Checkbox 2CBBoolean20
10WS_Checkbox_3 SearchWS Checkbox 3CBBoolean20
11WS_Checkbox_4 SearchWS Checkbox 4CBBoolean20
12WS_Checkbox_5 SearchWS Checkbox 5CBBoolean20
13WS_Checkbox_6 SearchWS Checkbox 6CBBoolean20
14WS_Checkbox_7 SearchWS Checkbox 7CBBoolean20
15WS_Checkbox_8 SearchWS Checkbox 8CBBoolean20
16WS_Checkbox_9 SearchWS Checkbox 9CBBoolean20
17WS_Checkbox_10 SearchWS Checkbox 10CBBoolean20
18WS_String_1 SearchWS String 1STR20String2220
19WS_String_2 SearchWS String 2STR20String2220
20WS_String_3 SearchWS String 3STR20String2220
21WS_String_4 SearchWS String 4STR20String2220
22WS_String_5 SearchWS String 5STR20String2220
23WS_Percent_1 SearchWS Percent 1INT5_%2Integer25
24WS_Percent_2 SearchWS Percent 2INT5_%2Integer25
25WS_Percent_3 SearchWS Percent 3INT5_%2Integer25
26WS_Percent_4 SearchWS Percent 4INT5_%2Integer25
27WS_Percent_5 SearchWS Percent 5INT5_%2Integer25
28Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
29Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
30Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
31MODIFDT SearchModified DateDTDate48
32Modified_Time SearchModified TimeTM6Time46
33MDFUSRID SearchModified User IDSTR15String1615
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 ZoneSTR3String43
azurecurveProductsWennSoft Products (131)3rd PartySV_Invoice_Tax_Option_MSTR (SV000789)

Leave a Reply

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