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_ArchiveSeq 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
['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'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 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'].SLPRSNID4 UPSZONE UPS Zone STR3 String 3 5 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 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'].SHIPMTHD6 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
['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'].TAXSCHID7 CNTCPRSN Contact Person STR60 String 60 8 ADDRESS1 Address 1 STR60 String 60 9 ADDRESS2 Address 2 STR60 String 60 10 ADDRESS3 Address 3 STR60 String 60 11 COUNTRY Country STR60 String 60 12 CITY City STR35 String 35 13 STATE State STR30_State String 29 14 ZIP Zip STR10 String 10 15 PHONE1 Phone 1 Phone_Number String 14 16 PHONE2 Phone 2 Phone_Number String 14 17 PHONE3 Phone 3 Phone_Number3 String 14 18 FAX Fax STR14_FAX String 14 19 MODIFDT Modified Date DT Date 8 20 CREATDDT Created Date DT Date 8 21 GPSFOINTEGRATIONID GPSFO Integration ID STR30 String 30 22 INTEGRATIONSOURCE Integration Source INT Integer 0 23 INTEGRATIONID Integration ID STR30 String 30 24 CCode Country Code STR6_VAT String 6 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'].CCode25 DECLID Declarant ID STR15_Address_Code String 15 26 LOCNCODE Location Code STR10_Location_Code String 10 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'].LOCNCODE27 SALSTERR Sales Territory STR15_Sales_Territory String 15 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'].SALSTERR28 USERDEF1 User Defined 1 STR20 String 20 29 USERDEF2 User Defined 2 STR20 String 20