Customer Master Address File Archive (SVRMA102)

azurecurveProductsWennSoft Products (131)SalesCustomer Master Address File Archive (SVRMA102)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA102

Product: WennSoft Products (131)
Series: Sales

Display Name: Customer Master Address File Archive
Physical Name: SVRMA102
Technical Name: RM_Customer_MSTR_ADDR_Archive

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].CUSTNMBR AS 'Customer Master Address File Archive-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Customer Master Address File Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
3SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].SLPRSNID AS 'Customer Master Address File Archive-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Customer Master Address File Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
4UPSZONE SearchUPS ZoneSTR3String3
5SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].SHIPMTHD AS 'Customer Master Address File Archive-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Customer Master Address File Archive'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
6TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].TAXSCHID AS 'Customer Master Address File Archive-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Customer Master Address File Archive'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
7CNTCPRSN SearchContact PersonSTR60String60
8ADDRESS1 SearchAddress 1STR60String60
9ADDRESS2 SearchAddress 2STR60String60
10ADDRESS3 SearchAddress 3STR60String60
11COUNTRY SearchCountrySTR60String60
12CITY SearchCitySTR35String35
13STATE SearchStateSTR30_StateString29
14ZIP SearchZipSTR10String10
15PHONE1 SearchPhone 1Phone_NumberString14
16PHONE2 SearchPhone 2Phone_NumberString14
17PHONE3 SearchPhone 3Phone_Number3String14
18FAX SearchFaxSTR14_FAXString14
19MODIFDT SearchModified DateDTDate8
20CREATDDT SearchCreated DateDTDate8
21GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String30
22INTEGRATIONSOURCE SearchIntegration SourceINTInteger0
23INTEGRATIONID SearchIntegration IDSTR30String30
24CCode SearchCountry CodeSTR6_VATString6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].CCode AS 'Customer Master Address File Archive-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Customer Master Address File Archive'].CCode = ['VAT Country Code MSTR'].CCode
25DECLID SearchDeclarant IDSTR15_Address_CodeString15
26LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].LOCNCODE AS 'Customer Master Address File Archive-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Customer Master Address File Archive'].LOCNCODE = ['Site Setup'].LOCNCODE
27SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Customer Master Address File Archive'].SALSTERR AS 'Customer Master Address File Archive-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SVRMA102 AS ['Customer Master Address File Archive']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Customer Master Address File Archive'].SALSTERR = ['Sales Territory Master File'].SALSTERR
28USERDEF1 SearchUser Defined 1STR20String20
29USERDEF2 SearchUser Defined 2STR20String20
azurecurveProductsWennSoft Products (131)SalesCustomer Master Address File Archive (SVRMA102)

Leave a Reply

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