RM Email Statements Header Temporary File 2 (RM50105)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Email Statements Header Temporary File 2 (RM50105)

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
Physical Name: RM50105
Technical Name: rmEmailStmtsHDRTemp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DSCRIPTN SearchDescriptionSTR30String3230
2STMNTID SearchStatement IDSTR15_LBAUString1615
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
4STMTNAME SearchStatement NameSTR64String6664
5CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
6CURRNIDX SearchCurrency IndexINT3Integer23
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'].CURRNIDX
7CNTCPRSN SearchContact PersonSTR60String6260
8ADDRESS1 SearchAddress 1STR60String6260
9ADDRESS2 SearchAddress 2STR60String6260
10ADDRESS3 SearchAddress 3STR60String6260
11PHONE1 SearchPhone 1Phone_NumberString2214
12PHONE2 SearchPhone 2Phone_NumberString2214
13PHONE3 SearchPhone 3Phone_Number3String2214
14CITY SearchCitySTR35String3635
15STATE SearchStateSTR30_StateString3029
16ZIP SearchZipSTR10String1210
17DATE1 SearchDateDT6Date46
18MINPYDUE SearchMinimum Payment DueDLR11_$S2Currency1014
19CUSTMSGS_1 SearchCustomer Messages[1]STR40String4240
20CUSTMSGS_2 SearchCustomer Messages[2]STR40String4240
21CUSTMSGS_3 SearchCustomer Messages[3]STR40String4240
22AMNTDUE SearchAmount DueDLR11_$S2Currency1014
23STMTMSGS_1 SearchStatement Messages[1]STR50String5250
24STMTMSGS_2 SearchStatement Messages[2]STR50String5250
25STMTMSGS_3 SearchStatement Messages[3]STR50String5250
26STMTMSGS_4 SearchStatement Messages[4]STR50String5250
27STMTMSGS_5 SearchStatement Messages[5]STR50String5250
28STMTMSGS_6 SearchStatement Messages[6]STR50String5250
29STMTMSGS_7 SearchStatement Messages[7]STR50String5250
30STMTMSGS_8 SearchStatement Messages[8]STR50String5250
31STMTMSGS_9 SearchStatement Messages[9]STR50String5250
32STMTMSGS_10 SearchStatement Messages[10]STR50String5250
33STMTMSGS_11 SearchStatement Messages[11]STR50String5250
34STMTMSGS_12 SearchStatement Messages[12]STR50String5250
35STMTMSGS_13 SearchStatement Messages[13]STR50String5250
36STMTMSGS_14 SearchStatement Messages[14]STR50String5250
37STMTMSGS_15 SearchStatement Messages[15]STR50String5250
38DOCARABR_1 SearchDocument Array Abbreviation[1]STR3String43
39DOCARABR_2 SearchDocument Array Abbreviation[2]STR3String43
40DOCARABR_3 SearchDocument Array Abbreviation[3]STR3String43
41DOCARABR_4 SearchDocument Array Abbreviation[4]STR3String43
42DOCARABR_5 SearchDocument Array Abbreviation[5]STR3String43
43DOCARABR_6 SearchDocument Array Abbreviation[6]STR3String43
44DOCARABR_7 SearchDocument Array Abbreviation[7]STR3String43
45DOCARABR_8 SearchDocument Array Abbreviation[8]STR3String43
46DOCARABR_9 SearchDocument Array Abbreviation[9]STR3String43
47DOCARDSC_1 SearchDocument Array Description[1]STR20String2220
48DOCARDSC_2 SearchDocument Array Description[2]STR20String2220
49DOCARDSC_3 SearchDocument Array Description[3]STR20String2220
50DOCARDSC_4 SearchDocument Array Description[4]STR20String2220
51DOCARDSC_5 SearchDocument Array Description[5]STR20String2220
52DOCARDSC_6 SearchDocument Array Description[6]STR20String2220
53DOCARDSC_7 SearchDocument Array Description[7]STR20String2220
54DOCARDSC_8 SearchDocument Array Description[8]STR20String2220
55DOCARDSC_9 SearchDocument Array Description[9]STR20String2220
56AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
57AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
58AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
59AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
60AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
61AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
62AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
63AGPERDSC_1 SearchAging Periods Descriptions[1]STR15String1615
64AGPERDSC_2 SearchAging Periods Descriptions[2]STR15String1615
65AGPERDSC_3 SearchAging Periods Descriptions[3]STR15String1615
66AGPERDSC_4 SearchAging Periods Descriptions[4]STR15String1615
67AGPERDSC_5 SearchAging Periods Descriptions[5]STR15String1615
68AGPERDSC_6 SearchAging Periods Descriptions[6]STR15String1615
69AGPERDSC_7 SearchAging Periods Descriptions[7]STR15String1615
70CMPANYID SearchCompany IDINT5Integer24
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'].CMPANYID
71LOCATNID SearchLocation IDSTR15_Location_IDString1615
72PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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'].PYMTRMID
73CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
74DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
75RNNMBR SearchRun NumberLong IntLong Integer48
76PRNTSTUS SearchPrinting StatusINTInteger20
77USERID SearchUser IDSTR15_User_IDString1615
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'].USERID
78Process_Index SearchProcess IndexlongLong Integer48
79DEX_ROW_ID Searchintint1010

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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Email Statements Header Temporary File 2 (RM50105)

Leave a Reply

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