SV_Customer_Billing_View (SV90119)

azurecurveProductsWennSoft Products (131)3rd PartySV_Customer_Billing_View (SV90119)

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_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
2CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
3CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
4SOP_Custom_Billing SearchSOP Custom BillingCBBoolean20
5CITY SearchCitySTR35String3635
6STATE SearchStateSTR30_StateString3029
7ZIP SearchZipSTR10String1210
8USERDEF1 SearchUser Defined 1STR20String2220
9SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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'].SLPRSNID
10SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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
azurecurveProductsWennSoft Products (131)3rd PartySV_Customer_Billing_View (SV90119)

Leave a Reply

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