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 TypeLength
1DOCID SearchDocument IDSTR15_LBAUString15
2TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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_Pool1String6
4WS_Sales_Mask_2 SearchWS Sales Mask:Account_Mask_Pool2Account_Mask_Pool2String6
5WS_Sales_Mask_3 SearchWS Sales Mask:Account_Mask_Pool3Account_Mask_Pool3String6
6WS_Sales_Mask_4 SearchWS Sales Mask:Account_Mask_Pool4Account_Mask_Pool4String6
7WS_Sales_Mask_5 SearchWS Sales Mask:Account_Mask_Pool5Account_Mask_Pool5String6
8WS_Sales_Mask_6 SearchWS Sales Mask:Account_Mask_Pool6Account_Mask_Pool6String6
9WS_Sales_Mask_7 SearchWS Sales Mask:Account_Mask_Pool7Account_Mask_Pool7String6
10WS_Sales_Mask_8 SearchWS Sales Mask:Account_Mask_Pool8Account_Mask_Pool8String6
11WS_Sales_Mask_9 SearchWS Sales Mask:Account_Mask_Pool9Account_Mask_Pool9String6
12WS_Sales_Mask_10 SearchWS Sales Mask:Account_Mask_Pool10Account_Mask_Pool10String6
13WS_Receivables_Mask_1 SearchWS Receivables Mask:Account_Mask_Pool1Account_Mask_Pool1String6
14WS_Receivables_Mask_2 SearchWS Receivables Mask:Account_Mask_Pool2Account_Mask_Pool2String6
15WS_Receivables_Mask_3 SearchWS Receivables Mask:Account_Mask_Pool3Account_Mask_Pool3String6
16WS_Receivables_Mask_4 SearchWS Receivables Mask:Account_Mask_Pool4Account_Mask_Pool4String6
17WS_Receivables_Mask_5 SearchWS Receivables Mask:Account_Mask_Pool5Account_Mask_Pool5String6
18WS_Receivables_Mask_6 SearchWS Receivables Mask:Account_Mask_Pool6Account_Mask_Pool6String6
19WS_Receivables_Mask_7 SearchWS Receivables Mask:Account_Mask_Pool7Account_Mask_Pool7String6
20WS_Receivables_Mask_8 SearchWS Receivables Mask:Account_Mask_Pool8Account_Mask_Pool8String6
21WS_Receivables_Mask_9 SearchWS Receivables Mask:Account_Mask_Pool9Account_Mask_Pool9String6
22WS_Receivables_Mask_10 SearchWS Receivables Mask:Account_Mask_Pool10Account_Mask_Pool10String6
23WS_COGS_Mask_1 SearchWS COGS Mask:Account_Mask_Pool1Account_Mask_Pool1String6
24WS_COGS_Mask_2 SearchWS COGS Mask:Account_Mask_Pool2Account_Mask_Pool2String6
25WS_COGS_Mask_3 SearchWS COGS Mask:Account_Mask_Pool3Account_Mask_Pool3String6
26WS_COGS_Mask_4 SearchWS COGS Mask:Account_Mask_Pool4Account_Mask_Pool4String6
27WS_COGS_Mask_5 SearchWS COGS Mask:Account_Mask_Pool5Account_Mask_Pool5String6
28WS_COGS_Mask_6 SearchWS COGS Mask:Account_Mask_Pool6Account_Mask_Pool6String6
29WS_COGS_Mask_7 SearchWS COGS Mask:Account_Mask_Pool7Account_Mask_Pool7String6
30WS_COGS_Mask_8 SearchWS COGS Mask:Account_Mask_Pool8Account_Mask_Pool8String6
31WS_COGS_Mask_9 SearchWS COGS Mask:Account_Mask_Pool9Account_Mask_Pool9String6
32WS_COGS_Mask_10 SearchWS COGS Mask:Account_Mask_Pool10Account_Mask_Pool10String6
33CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_LBAUString15
35CREATDDT SearchCreated DateDTDate8
36LSTUSRED SearchLast User to EditSTR15String15
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 DateDTDate8
azurecurveProductsWennSoft Products (131)3rd PartyWS_SOP_Warranty_Parts_SETP (WS40400)

Leave a Reply

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