RM Email Statements Header Temporary File (RM50103)

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

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: rmEmailStmtsHDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DSCRIPTN SearchDescriptionSTR30String30
2STMNTID SearchStatement IDSTR15_LBAUString15
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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'].CUSTNMBR
4STMTNAME SearchStatement NameSTR64String64
5CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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'].CURNCYID
6CURRNIDX SearchCurrency IndexINT3Integer3
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'].CURRNIDX
7CNTCPRSN SearchContact PersonSTR60String60
8ADDRESS1 SearchAddress 1STR60String60
9ADDRESS2 SearchAddress 2STR60String60
10ADDRESS3 SearchAddress 3STR60String60
11PHONE1 SearchPhone 1Phone_NumberString14
12PHONE2 SearchPhone 2Phone_NumberString14
13PHONE3 SearchPhone 3Phone_Number3String14
14CITY SearchCitySTR35String35
15STATE SearchStateSTR30_StateString29
16ZIP SearchZipSTR10String10
17DATE1 SearchDateDT6Date6
18MINPYDUE SearchMinimum Payment DueDLR11_$S2Currency14
19CUSTMSGS_1 SearchCustomer Messages[1]STR40String40
20CUSTMSGS_2 SearchCustomer Messages[2]STR40String40
21CUSTMSGS_3 SearchCustomer Messages[3]STR40String40
22AMNTDUE SearchAmount DueDLR11_$S2Currency14
23STMTMSGS_1 SearchStatement Messages[1]STR50String50
24STMTMSGS_2 SearchStatement Messages[2]STR50String50
25STMTMSGS_3 SearchStatement Messages[3]STR50String50
26STMTMSGS_4 SearchStatement Messages[4]STR50String50
27STMTMSGS_5 SearchStatement Messages[5]STR50String50
28STMTMSGS_6 SearchStatement Messages[6]STR50String50
29STMTMSGS_7 SearchStatement Messages[7]STR50String50
30STMTMSGS_8 SearchStatement Messages[8]STR50String50
31STMTMSGS_9 SearchStatement Messages[9]STR50String50
32STMTMSGS_10 SearchStatement Messages[10]STR50String50
33STMTMSGS_11 SearchStatement Messages[11]STR50String50
34STMTMSGS_12 SearchStatement Messages[12]STR50String50
35STMTMSGS_13 SearchStatement Messages[13]STR50String50
36STMTMSGS_14 SearchStatement Messages[14]STR50String50
37STMTMSGS_15 SearchStatement Messages[15]STR50String50
38DOCARABR_1 SearchDocument Array Abbreviation[1]STR3String3
39DOCARABR_2 SearchDocument Array Abbreviation[2]STR3String3
40DOCARABR_3 SearchDocument Array Abbreviation[3]STR3String3
41DOCARABR_4 SearchDocument Array Abbreviation[4]STR3String3
42DOCARABR_5 SearchDocument Array Abbreviation[5]STR3String3
43DOCARABR_6 SearchDocument Array Abbreviation[6]STR3String3
44DOCARABR_7 SearchDocument Array Abbreviation[7]STR3String3
45DOCARABR_8 SearchDocument Array Abbreviation[8]STR3String3
46DOCARABR_9 SearchDocument Array Abbreviation[9]STR3String3
47DOCARDSC_1 SearchDocument Array Description[1]STR20String20
48DOCARDSC_2 SearchDocument Array Description[2]STR20String20
49DOCARDSC_3 SearchDocument Array Description[3]STR20String20
50DOCARDSC_4 SearchDocument Array Description[4]STR20String20
51DOCARDSC_5 SearchDocument Array Description[5]STR20String20
52DOCARDSC_6 SearchDocument Array Description[6]STR20String20
53DOCARDSC_7 SearchDocument Array Description[7]STR20String20
54DOCARDSC_8 SearchDocument Array Description[8]STR20String20
55DOCARDSC_9 SearchDocument Array Description[9]STR20String20
56AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
57AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
58AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
59AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
60AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
61AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
62AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
63AGPERDSC_1 SearchAging Periods Descriptions[1]STR15String15
64AGPERDSC_2 SearchAging Periods Descriptions[2]STR15String15
65AGPERDSC_3 SearchAging Periods Descriptions[3]STR15String15
66AGPERDSC_4 SearchAging Periods Descriptions[4]STR15String15
67AGPERDSC_5 SearchAging Periods Descriptions[5]STR15String15
68AGPERDSC_6 SearchAging Periods Descriptions[6]STR15String15
69AGPERDSC_7 SearchAging Periods Descriptions[7]STR15String15
70CMPANYID SearchCompany IDINT5Integer4
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'].CMPANYID
71LOCATNID SearchLocation IDSTR15_Location_IDString15
72PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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'].PYMTRMID
73CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
74DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
75RNNMBR SearchRun NumberLong IntLong Integer8
76PRNTSTUS SearchPrinting StatusINTInteger0
77USERID SearchUser IDSTR15_User_IDString15
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'].USERID
78Process_Index SearchProcess IndexlongLong Integer8
79DEX_ROW_ID Searchintint10

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 (RM50103)

Leave a Reply

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