Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA101
Product: WennSoft Products (131)
Series: Sales
Display Name: RM Customer MSTR Archive
Physical Name: SVRMA101
Technical Name: RM_Customer_MSTR_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
['RM Customer MSTR Archive'].CUSTNMBR AS 'RM Customer MSTR Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Customer MSTR Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 CUSTNAME Customer Name STR64_Customer_Name String 64 3 CUSTCLAS Customer Class STR15_Customer_Class String 15 4 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 5 CNTCPRSN Contact Person STR60 String 60 6 STMTNAME Statement Name STR64 String 64 7 SHRTNAME Short Name STR15 String 15 8 ADRSCODE Address Code STR15_Address_Code String 15 9 UPSZONE UPS Zone STR3 String 3 10 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].SHIPMTHD AS 'RM Customer MSTR Archive-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Customer MSTR Archive'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD11 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
['RM Customer MSTR Archive'].TAXSCHID AS 'RM Customer MSTR Archive-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Customer MSTR Archive'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID12 ADDRESS1 Address 1 STR60 String 60 13 ADDRESS2 Address 2 STR60 String 60 14 ADDRESS3 Address 3 STR60 String 60 15 COUNTRY Country STR60 String 60 16 CITY City STR35 String 35 17 STATE State STR30_State String 29 18 ZIP Zip STR10 String 10 19 PHONE1 Phone 1 Phone_Number String 14 20 PHONE2 Phone 2 Phone_Number String 14 21 PHONE3 Phone 3 Phone_Number3 String 14 22 FAX Fax STR14_FAX String 14 23 PRBTADCD Primary Billto Address Code STR15_LBAU String 15 24 PRSTADCD Primary Shipto Address Code STR15_LBAU String 15 25 STADDRCD Statement Address Code STR15_LBAU String 15 26 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].SLPRSNID AS 'RM Customer MSTR Archive-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Customer MSTR Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID27 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].CHEKBKID AS 'RM Customer MSTR Archive-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['RM Customer MSTR Archive'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID28 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].PYMTRMID AS 'RM Customer MSTR Archive-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Customer MSTR Archive'].PYMTRMID = ['Payment Terms Master'].PYMTRMID29 CRLMTTYP Credit Limit Type GB_Amt_Type Integer 0 30 CRLMTAMT Credit Limit Amount DLR17_RBS0_UTR$ Currency 17 31 CRLMTPER Credit Limit Period DDL Integer 0 32 CRLMTPAM Credit Limit Period Amount DLR17_RBS0_UTR$ Currency 17 33 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].CURNCYID AS 'RM Customer MSTR Archive-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Customer MSTR Archive'].CURNCYID = ['Currency Setup'].CURNCYID34 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].RATETPID AS 'RM Customer MSTR Archive-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['RM Customer MSTR Archive'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID35 CUSTDISC Customer Discount INT5_%2 Integer 5 36 PRCLEVEL PriceLevel STR10_LBAU String 10 37 MINPYTYP Minimum Payment Type GB_Amt_Type Integer 0 38 MINPYDLR Minimum Payment Dollar DLR17_RBS0_UTR$ Currency 17 39 MINPYPCT Minimum Payment Percent INT5_%2 Integer 5 40 FNCHATYP Finance Charge Amt Type GB_Amt_Type Integer 0 41 FNCHPCNT Finance Charge Percent INT5_%2 Integer 5 42 FINCHDLR Finance Charge Dollar DLR17_RBS0_UTR$ Currency 17 43 MXWOFTYP Maximum Writeoff Type GP_Max_Writeoff Integer 0 44 MXWROFAM Max Writeoff Amount DLR17_RBS0_UTR$ Currency 17 45 COMMENT1 Comment1 STR30 String 30 46 COMMENT2 Comment2 STR30 String 30 47 USERDEF1 User Defined 1 STR20 String 20 48 USERDEF2 User Defined 2 STR20 String 20 49 TAXEXMT1 Tax Exempt 1 STR25 String 25 50 TAXEXMT2 Tax Exempt 2 STR25 String 25 51 TXRGNNUM Tax Registration Number STR25 String 25 52 BALNCTYP Balance Type GB_Bal_Type Integer 0 53 STMTCYCL Statement Cycle DDL_Stmt_Cycle Integer 0 54 BANKNAME Bank Name STR30 String 30 55 BNKBRNCH Bank Branch STR20 String 20 56 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].SALSTERR AS 'RM Customer MSTR Archive-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['RM Customer MSTR Archive'].SALSTERR = ['Sales Territory Master File'].SALSTERR57 DEFCACTY Default Cash Account Type GB Integer 0 58 RMCSHACC RM Cash Account Index LI_14 Long Integer 14 59 RMARACC RM AR Account Index LI_14 Long Integer 14 60 RMSLSACC RM Sales Account Index LI_14 Long Integer 14 61 RMIVACC RM IV Account Index LI_14 Long Integer 14 62 RMCOSACC RM Cost Of Sales Account Index LI_14 Long Integer 14 63 RMTAKACC RM Discounts Taken Account Index LI_14 Long Integer 14 64 RMAVACC RM Discounts Avail Account Index LI_14 Long Integer 14 65 RMFCGACC RM Finance Charge Account Index LI_14 Long Integer 14 66 RMWRACC RM Writeoff Account Index LI_14 Long Integer 14 67 RMSORACC RM Sales Order Returns Account Index LI_14 Long Integer 14 68 FRSTINDT First Invoice Date DT_Date Date 6 69 INACTIVE Inactive CB_Inactive Boolean 0 70 HOLD Hold CB_Hold Boolean 0 71 CRCARDID Credit Card ID STR15 String 15 72 CRCRDNUM Credit Card Number STR20 String 20 73 CCRDXPDT Credit Card Exp Date DT_Date Date 6 74 KPDSTHST Keep Distribution History CB_Keep_Dist_History Boolean 0 75 KPCALHST Keep Calendar History CB_Keep_Calendar_History Boolean 0 76 KPERHIST Keep Period History CB_Keep_Period_History Boolean 0 77 KPTRXHST Keep Trx History CB_Keep_Trx_History Boolean 0 78 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].NOTEINDX AS 'RM Customer MSTR Archive-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Customer MSTR Archive'].NOTEINDX = ['Record Notes Master'].NOTEINDX79 CREATDDT Created Date DT Date 8 80 MODIFDT Modified Date DT Date 8 81 Revalue_Customer Revalue Customer CB Revalue Customer Boolean 0 82 Post_Results_To Post Results To GB Integer 0 83 FINCHID Finance Charge ID STR15_Charge_ID String 15 84 GOVCRPID Governmental Corporate ID STR30_Gov_Corp_ID String 30 85 GOVINDID Governmental Individual ID STR30_Gov_Indiv_ID String 30 86 DISGRPER Discount Grace Period INT2_U0 Integer 2 87 DUEGRPER Due Date Grace Period INT2_U0 Integer 2 88 DOCFMTID Document Format ID STR15_LBU String 15 89 Send_Email_Statements Send Email Statements CB Boolean 0 90 USERLANG User Language ID INT Integer 0 91 GPSFOINTEGRATIONID GPSFO Integration ID STR30 String 30 92 INTEGRATIONSOURCE Integration Source INT Integer 0 93 INTEGRATIONID Integration ID STR30 String 30 94 ORDERFULFILLDEFAULT Order Fulfillment Shortage Default DDL_OrderFulfillDefault Integer 0 95 CUSTPRIORITY Customer Priority DDL_CustomerPriority Integer 0 96 CCode Country Code STR6_VAT String 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['RM Customer MSTR Archive'].CCode AS 'RM Customer MSTR Archive-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
SVRMA101 AS ['RM Customer MSTR Archive']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['RM Customer MSTR Archive'].CCode = ['VAT Country Code MSTR'].CCode97 DECLID Declarant ID STR15_Address_Code String 15 98 RMOvrpymtWrtoffAcctIdx RM Overpayment Writeoff Account Index LI_14 Long Integer 14 99 SHIPCOMPLETE Ship Complete Document CB_ShipComplete Boolean 0 100 CBVAT Cash Based VAT CB_CashBasedVAT Boolean 0 101 INCLUDEINDP Include in Demand Planning CB_IncludeInDemandPlanning Boolean 0