Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM50103
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Email Statements Header Temporary File
Physical Name: RM50103
Technical Name: rmEmailStmtsHDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DSCRIPTN 
Description String STR30 30 2 STMNTID Statement ID String STR15_LBAU 15 3 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].CUSTNMBR AS 'RM Email Statements Header Temporary File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Email Statements Header Temporary File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR4 STMTNAME Statement Name String STR64 64 5 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].CURNCYID AS 'RM Email Statements Header Temporary File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Email Statements Header Temporary File'].CURNCYID = ['Currency Setup'].CURNCYID6 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].CURRNIDX AS 'RM Email Statements Header Temporary File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Email Statements Header Temporary File'].CURRNIDX = ['Currency Setup'].CURRNIDX7 CNTCPRSN Contact Person String STR60 60 8 ADDRESS1 Address 1 String STR60 60 9 ADDRESS2 Address 2 String STR60 60 10 ADDRESS3 Address 3 String STR60 60 11 PHONE1 Phone 1 String Phone_Number 14 12 PHONE2 Phone 2 String Phone_Number 14 13 PHONE3 Phone 3 String Phone_Number3 14 14 CITY City String STR35 35 15 STATE State String STR30_State 29 16 ZIP Zip String STR10 10 17 DATE1 Date Date DT6 6 18 MINPYDUE Minimum Payment Due Currency DLR11_$S2 14 19 CUSTMSGS_1 Customer Messages[1] String STR40 40 20 CUSTMSGS_2 Customer Messages[2] String STR40 40 21 CUSTMSGS_3 Customer Messages[3] String STR40 40 22 AMNTDUE Amount Due Currency DLR11_$S2 14 23 STMTMSGS_1 Statement Messages[1] String STR50 50 24 STMTMSGS_2 Statement Messages[2] String STR50 50 25 STMTMSGS_3 Statement Messages[3] String STR50 50 26 STMTMSGS_4 Statement Messages[4] String STR50 50 27 STMTMSGS_5 Statement Messages[5] String STR50 50 28 STMTMSGS_6 Statement Messages[6] String STR50 50 29 STMTMSGS_7 Statement Messages[7] String STR50 50 30 STMTMSGS_8 Statement Messages[8] String STR50 50 31 STMTMSGS_9 Statement Messages[9] String STR50 50 32 STMTMSGS_10 Statement Messages[10] String STR50 50 33 STMTMSGS_11 Statement Messages[11] String STR50 50 34 STMTMSGS_12 Statement Messages[12] String STR50 50 35 STMTMSGS_13 Statement Messages[13] String STR50 50 36 STMTMSGS_14 Statement Messages[14] String STR50 50 37 STMTMSGS_15 Statement Messages[15] String STR50 50 38 DOCARABR_1 Document Array Abbreviation[1] String STR3 3 39 DOCARABR_2 Document Array Abbreviation[2] String STR3 3 40 DOCARABR_3 Document Array Abbreviation[3] String STR3 3 41 DOCARABR_4 Document Array Abbreviation[4] String STR3 3 42 DOCARABR_5 Document Array Abbreviation[5] String STR3 3 43 DOCARABR_6 Document Array Abbreviation[6] String STR3 3 44 DOCARABR_7 Document Array Abbreviation[7] String STR3 3 45 DOCARABR_8 Document Array Abbreviation[8] String STR3 3 46 DOCARABR_9 Document Array Abbreviation[9] String STR3 3 47 DOCARDSC_1 Document Array Description[1] String STR20 20 48 DOCARDSC_2 Document Array Description[2] String STR20 20 49 DOCARDSC_3 Document Array Description[3] String STR20 20 50 DOCARDSC_4 Document Array Description[4] String STR20 20 51 DOCARDSC_5 Document Array Description[5] String STR20 20 52 DOCARDSC_6 Document Array Description[6] String STR20 20 53 DOCARDSC_7 Document Array Description[7] String STR20 20 54 DOCARDSC_8 Document Array Description[8] String STR20 20 55 DOCARDSC_9 Document Array Description[9] String STR20 20 56 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 57 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 58 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 59 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 60 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 61 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 62 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 63 AGPERDSC_1 Aging Periods Descriptions[1] String STR15 15 64 AGPERDSC_2 Aging Periods Descriptions[2] String STR15 15 65 AGPERDSC_3 Aging Periods Descriptions[3] String STR15 15 66 AGPERDSC_4 Aging Periods Descriptions[4] String STR15 15 67 AGPERDSC_5 Aging Periods Descriptions[5] String STR15 15 68 AGPERDSC_6 Aging Periods Descriptions[6] String STR15 15 69 AGPERDSC_7 Aging Periods Descriptions[7] String STR15 15 70 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].CMPANYID AS 'RM Email Statements Header Temporary File-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['RM Email Statements Header Temporary File'].CMPANYID = ['Company Master'].CMPANYID71 LOCATNID Location ID String STR15_Location_ID 15 72 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].PYMTRMID AS 'RM Email Statements Header Temporary File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Email Statements Header Temporary File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID73 CUSTBLNC Customer Balance Currency DLR19_RBS0_STR$ 19 74 DEPRECV Deposits Received Currency DLR19_RBS0_STR$ 19 75 RNNMBR Run Number Long Integer Long Int 8 76 PRNTSTUS Printing Status Integer INT 0 77 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RM Email Statements Header Temporary File'].USERID AS 'RM Email Statements Header Temporary File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Email Statements Header Temporary File'].USERID = ['Users Master'].USERID78 Process_Index Process Index Long Integer long 8