WS_SOP_Warranty_Parts_SETP (WS40400)

azurecurveProductsWennSoft Products (131)3rd PartyWS_SOP_Warranty_Parts_SETP (WS40400)

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

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

Display Name: WS_SOP_Warranty_Parts_SETP
Physical Name: WS40400
Technical Name: WS_SOP_Warranty_Parts_SETP

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

Click to show/hide

SELECT
       ['WS_SOP_Warranty_Parts_SETP'].TAXSCHID AS 'WS_SOP_Warranty_Parts_SETP-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       WS40400 AS ['WS_SOP_Warranty_Parts_SETP']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['WS_SOP_Warranty_Parts_SETP'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
3WS_Sales_Mask_1 SearchWS Sales Mask:Account_Mask_Pool1Account_Mask_Pool1String86
4WS_Sales_Mask_2 SearchWS Sales Mask:Account_Mask_Pool2Account_Mask_Pool2String86
5WS_Sales_Mask_3 SearchWS Sales Mask:Account_Mask_Pool3Account_Mask_Pool3String86
6WS_Sales_Mask_4 SearchWS Sales Mask:Account_Mask_Pool4Account_Mask_Pool4String86
7WS_Sales_Mask_5 SearchWS Sales Mask:Account_Mask_Pool5Account_Mask_Pool5String86
8WS_Sales_Mask_6 SearchWS Sales Mask:Account_Mask_Pool6Account_Mask_Pool6String86
9WS_Sales_Mask_7 SearchWS Sales Mask:Account_Mask_Pool7Account_Mask_Pool7String86
10WS_Sales_Mask_8 SearchWS Sales Mask:Account_Mask_Pool8Account_Mask_Pool8String86
11WS_Sales_Mask_9 SearchWS Sales Mask:Account_Mask_Pool9Account_Mask_Pool9String86
12WS_Sales_Mask_10 SearchWS Sales Mask:Account_Mask_Pool10Account_Mask_Pool10String86
13WS_Receivables_Mask_1 SearchWS Receivables Mask:Account_Mask_Pool1Account_Mask_Pool1String86
14WS_Receivables_Mask_2 SearchWS Receivables Mask:Account_Mask_Pool2Account_Mask_Pool2String86
15WS_Receivables_Mask_3 SearchWS Receivables Mask:Account_Mask_Pool3Account_Mask_Pool3String86
16WS_Receivables_Mask_4 SearchWS Receivables Mask:Account_Mask_Pool4Account_Mask_Pool4String86
17WS_Receivables_Mask_5 SearchWS Receivables Mask:Account_Mask_Pool5Account_Mask_Pool5String86
18WS_Receivables_Mask_6 SearchWS Receivables Mask:Account_Mask_Pool6Account_Mask_Pool6String86
19WS_Receivables_Mask_7 SearchWS Receivables Mask:Account_Mask_Pool7Account_Mask_Pool7String86
20WS_Receivables_Mask_8 SearchWS Receivables Mask:Account_Mask_Pool8Account_Mask_Pool8String86
21WS_Receivables_Mask_9 SearchWS Receivables Mask:Account_Mask_Pool9Account_Mask_Pool9String86
22WS_Receivables_Mask_10 SearchWS Receivables Mask:Account_Mask_Pool10Account_Mask_Pool10String86
23WS_COGS_Mask_1 SearchWS COGS Mask:Account_Mask_Pool1Account_Mask_Pool1String86
24WS_COGS_Mask_2 SearchWS COGS Mask:Account_Mask_Pool2Account_Mask_Pool2String86
25WS_COGS_Mask_3 SearchWS COGS Mask:Account_Mask_Pool3Account_Mask_Pool3String86
26WS_COGS_Mask_4 SearchWS COGS Mask:Account_Mask_Pool4Account_Mask_Pool4String86
27WS_COGS_Mask_5 SearchWS COGS Mask:Account_Mask_Pool5Account_Mask_Pool5String86
28WS_COGS_Mask_6 SearchWS COGS Mask:Account_Mask_Pool6Account_Mask_Pool6String86
29WS_COGS_Mask_7 SearchWS COGS Mask:Account_Mask_Pool7Account_Mask_Pool7String86
30WS_COGS_Mask_8 SearchWS COGS Mask:Account_Mask_Pool8Account_Mask_Pool8String86
31WS_COGS_Mask_9 SearchWS COGS Mask:Account_Mask_Pool9Account_Mask_Pool9String86
32WS_COGS_Mask_10 SearchWS COGS Mask:Account_Mask_Pool10Account_Mask_Pool10String86
33CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['WS_SOP_Warranty_Parts_SETP'].CUSTNMBR AS 'WS_SOP_Warranty_Parts_SETP-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       WS40400 AS ['WS_SOP_Warranty_Parts_SETP']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['WS_SOP_Warranty_Parts_SETP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
34PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
35CREATDDT SearchCreated DateDTDate48
36LSTUSRED SearchLast User to EditSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_SOP_Warranty_Parts_SETP'].LSTUSRED AS 'WS_SOP_Warranty_Parts_SETP-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS40400 AS ['WS_SOP_Warranty_Parts_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_SOP_Warranty_Parts_SETP'].LSTUSRED = ['Users Master'].USERID
37MODIFDT SearchModified DateDTDate48
azurecurveProductsWennSoft Products (131)3rd PartyWS_SOP_Warranty_Parts_SETP (WS40400)

Leave a Reply

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