WS_SOP_Warranty_Parts_SETP (WS40400)

azurecurve Products WennSoft 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 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'].TAXSCHID
3	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'].CUSTNMBR
34	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'].USERID
37	MODIFDT	Modified Date	DT	Date	8

azurecurve Products WennSoft Products (131)3rd PartyWS_SOP_Warranty_Parts_SETP (WS40400)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply