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