Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV90119
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Customer_Billing_View
Physical Name: SV90119
Technical Name: SV_Customer_Billing_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Customer_Billing_View'].CUSTNMBR AS 'SV_Customer_Billing_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV90119 AS ['SV_Customer_Billing_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Customer_Billing_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 CUSTNAME Customer Name STR64_Customer_Name String 64 3 CUSTCLAS Customer Class STR15_Customer_Class String 15 4 SOP_Custom_Billing SOP Custom Billing CB Boolean 0 5 CITY City STR35 String 35 6 STATE State STR30_State String 29 7 ZIP Zip STR10 String 10 8 USERDEF1 User Defined 1 STR20 String 20 9 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SV_Customer_Billing_View'].SLPRSNID AS 'SV_Customer_Billing_View-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SV90119 AS ['SV_Customer_Billing_View']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SV_Customer_Billing_View'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID10 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['SV_Customer_Billing_View'].SALSTERR AS 'SV_Customer_Billing_View-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
SV90119 AS ['SV_Customer_Billing_View']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['SV_Customer_Billing_View'].SALSTERR = ['Sales Territory Master File'].SALSTERR