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_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCID 
Document ID STR15_LBAU String 15 2 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 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'].TAXSCHID3 WS_Sales_Mask_1 WS Sales Mask:Account_Mask_Pool1 Account_Mask_Pool1 String 6 4 WS_Sales_Mask_2 WS Sales Mask:Account_Mask_Pool2 Account_Mask_Pool2 String 6 5 WS_Sales_Mask_3 WS Sales Mask:Account_Mask_Pool3 Account_Mask_Pool3 String 6 6 WS_Sales_Mask_4 WS Sales Mask:Account_Mask_Pool4 Account_Mask_Pool4 String 6 7 WS_Sales_Mask_5 WS Sales Mask:Account_Mask_Pool5 Account_Mask_Pool5 String 6 8 WS_Sales_Mask_6 WS Sales Mask:Account_Mask_Pool6 Account_Mask_Pool6 String 6 9 WS_Sales_Mask_7 WS Sales Mask:Account_Mask_Pool7 Account_Mask_Pool7 String 6 10 WS_Sales_Mask_8 WS Sales Mask:Account_Mask_Pool8 Account_Mask_Pool8 String 6 11 WS_Sales_Mask_9 WS Sales Mask:Account_Mask_Pool9 Account_Mask_Pool9 String 6 12 WS_Sales_Mask_10 WS Sales Mask:Account_Mask_Pool10 Account_Mask_Pool10 String 6 13 WS_Receivables_Mask_1 WS Receivables Mask:Account_Mask_Pool1 Account_Mask_Pool1 String 6 14 WS_Receivables_Mask_2 WS Receivables Mask:Account_Mask_Pool2 Account_Mask_Pool2 String 6 15 WS_Receivables_Mask_3 WS Receivables Mask:Account_Mask_Pool3 Account_Mask_Pool3 String 6 16 WS_Receivables_Mask_4 WS Receivables Mask:Account_Mask_Pool4 Account_Mask_Pool4 String 6 17 WS_Receivables_Mask_5 WS Receivables Mask:Account_Mask_Pool5 Account_Mask_Pool5 String 6 18 WS_Receivables_Mask_6 WS Receivables Mask:Account_Mask_Pool6 Account_Mask_Pool6 String 6 19 WS_Receivables_Mask_7 WS Receivables Mask:Account_Mask_Pool7 Account_Mask_Pool7 String 6 20 WS_Receivables_Mask_8 WS Receivables Mask:Account_Mask_Pool8 Account_Mask_Pool8 String 6 21 WS_Receivables_Mask_9 WS Receivables Mask:Account_Mask_Pool9 Account_Mask_Pool9 String 6 22 WS_Receivables_Mask_10 WS Receivables Mask:Account_Mask_Pool10 Account_Mask_Pool10 String 6 23 WS_COGS_Mask_1 WS COGS Mask:Account_Mask_Pool1 Account_Mask_Pool1 String 6 24 WS_COGS_Mask_2 WS COGS Mask:Account_Mask_Pool2 Account_Mask_Pool2 String 6 25 WS_COGS_Mask_3 WS COGS Mask:Account_Mask_Pool3 Account_Mask_Pool3 String 6 26 WS_COGS_Mask_4 WS COGS Mask:Account_Mask_Pool4 Account_Mask_Pool4 String 6 27 WS_COGS_Mask_5 WS COGS Mask:Account_Mask_Pool5 Account_Mask_Pool5 String 6 28 WS_COGS_Mask_6 WS COGS Mask:Account_Mask_Pool6 Account_Mask_Pool6 String 6 29 WS_COGS_Mask_7 WS COGS Mask:Account_Mask_Pool7 Account_Mask_Pool7 String 6 30 WS_COGS_Mask_8 WS COGS Mask:Account_Mask_Pool8 Account_Mask_Pool8 String 6 31 WS_COGS_Mask_9 WS COGS Mask:Account_Mask_Pool9 Account_Mask_Pool9 String 6 32 WS_COGS_Mask_10 WS COGS Mask:Account_Mask_Pool10 Account_Mask_Pool10 String 6 33 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR34 PRBTADCD Primary Billto Address Code STR15_LBAU String 15 35 CREATDDT Created Date DT Date 8 36 LSTUSRED Last User to Edit STR15 String 15 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'].USERID37 MODIFDT Modified Date DT Date 8