RM Reprint Statements Header File (RM30701)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Reprint Statements Header File (RM30701)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM30701

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Reprint Statements Header File
Physical Name: RM30701
Technical Name: rmReprintStmtsHDR

Group Display Name: Receivable Transaction History Files
Group Technical Name: RM_Transaction_History_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RNNMBR SearchRun NumberLong IntLong Integer48
2DSCRIPTN SearchDescriptionSTR30String3230
3STMNTID SearchStatement IDSTR15_LBAUString1615
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['RM Reprint Statements Header File'].CUSTNMBR AS 'RM Reprint Statements Header File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM30701 AS ['RM Reprint Statements Header File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Reprint Statements Header File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5STMTNAME SearchStatement NameSTR64String6664
6CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Reprint Statements Header File'].CURNCYID AS 'RM Reprint Statements Header File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM30701 AS ['RM Reprint Statements Header File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Reprint Statements Header File'].CURNCYID = ['Currency Setup'].CURNCYID
7CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Reprint Statements Header File'].CURRNIDX AS 'RM Reprint Statements Header File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       RM30701 AS ['RM Reprint Statements Header File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Reprint Statements Header File'].CURRNIDX = ['Currency Setup'].CURRNIDX
8CNTCPRSN SearchContact PersonSTR60String6260
9ADDRESS1 SearchAddress 1STR60String6260
10ADDRESS2 SearchAddress 2STR60String6260
11ADDRESS3 SearchAddress 3STR60String6260
12PHONE1 SearchPhone 1Phone_NumberString2214
13PHONE2 SearchPhone 2Phone_NumberString2214
14PHONE3 SearchPhone 3Phone_Number3String2214
15CITY SearchCitySTR35String3635
16STATE SearchStateSTR30_StateString3029
17ZIP SearchZipSTR10String1210
18DATE1 SearchDateDT6Date46
19MINPYDUE SearchMinimum Payment DueDLR11_$S2Currency1014
20CUSTMSGS SearchCustomer MessagesSTR40String4240
21CUSTMSGS_1 SearchCustomer Messages[1]STR40String4240
22CUSTMSGS_2 SearchCustomer Messages[2]STR40String4240
23CUSTMSGS_3 SearchCustomer Messages[3]STR40String4240
24AMNTDUE SearchAmount DueDLR11_$S2Currency1014
25STMTMSGS SearchStatement MessagesSTR50String5250
26STMTMSGS_1 SearchStatement Messages[1]STR50String5250
27STMTMSGS_2 SearchStatement Messages[2]STR50String5250
28STMTMSGS_3 SearchStatement Messages[3]STR50String5250
29STMTMSGS_4 SearchStatement Messages[4]STR50String5250
30STMTMSGS_5 SearchStatement Messages[5]STR50String5250
31STMTMSGS_6 SearchStatement Messages[6]STR50String5250
32STMTMSGS_7 SearchStatement Messages[7]STR50String5250
33STMTMSGS_8 SearchStatement Messages[8]STR50String5250
34STMTMSGS_9 SearchStatement Messages[9]STR50String5250
35STMTMSGS_10 SearchStatement Messages[10]STR50String5250
36STMTMSGS_11 SearchStatement Messages[11]STR50String5250
37STMTMSGS_12 SearchStatement Messages[12]STR50String5250
38STMTMSGS_13 SearchStatement Messages[13]STR50String5250
39STMTMSGS_14 SearchStatement Messages[14]STR50String5250
40STMTMSGS_15 SearchStatement Messages[15]STR50String5250
41DOCARABR SearchDocument Array AbbreviationSTR3String43
42DOCARABR_1 SearchDocument Array Abbreviation[1]STR3String43
43DOCARABR_2 SearchDocument Array Abbreviation[2]STR3String43
44DOCARABR_3 SearchDocument Array Abbreviation[3]STR3String43
45DOCARABR_4 SearchDocument Array Abbreviation[4]STR3String43
46DOCARABR_5 SearchDocument Array Abbreviation[5]STR3String43
47DOCARABR_6 SearchDocument Array Abbreviation[6]STR3String43
48DOCARABR_7 SearchDocument Array Abbreviation[7]STR3String43
49DOCARABR_8 SearchDocument Array Abbreviation[8]STR3String43
50DOCARABR_9 SearchDocument Array Abbreviation[9]STR3String43
51DOCARDSC SearchDocument Array DescriptionSTR20String2220
52DOCARDSC_1 SearchDocument Array Description[1]STR20String2220
53DOCARDSC_2 SearchDocument Array Description[2]STR20String2220
54DOCARDSC_3 SearchDocument Array Description[3]STR20String2220
55DOCARDSC_4 SearchDocument Array Description[4]STR20String2220
56DOCARDSC_5 SearchDocument Array Description[5]STR20String2220
57DOCARDSC_6 SearchDocument Array Description[6]STR20String2220
58DOCARDSC_7 SearchDocument Array Description[7]STR20String2220
59DOCARDSC_8 SearchDocument Array Description[8]STR20String2220
60DOCARDSC_9 SearchDocument Array Description[9]STR20String2220
61AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency1017
62AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
63AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
64AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
65AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
66AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
67AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
68AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
69AGPERDSC SearchAging Periods DescriptionsSTR15String1615
70AGPERDSC_1 SearchAging Periods Descriptions[1]STR15String1615
71AGPERDSC_2 SearchAging Periods Descriptions[2]STR15String1615
72AGPERDSC_3 SearchAging Periods Descriptions[3]STR15String1615
73AGPERDSC_4 SearchAging Periods Descriptions[4]STR15String1615
74AGPERDSC_5 SearchAging Periods Descriptions[5]STR15String1615
75AGPERDSC_6 SearchAging Periods Descriptions[6]STR15String1615
76AGPERDSC_7 SearchAging Periods Descriptions[7]STR15String1615
77CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['RM Reprint Statements Header File'].CMPANYID AS 'RM Reprint Statements Header File-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       RM30701 AS ['RM Reprint Statements Header File']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['RM Reprint Statements Header File'].CMPANYID = ['Company Master'].CMPANYID
78LOCATNID SearchLocation IDSTR15_Location_IDString1615
79PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['RM Reprint Statements Header File'].PYMTRMID AS 'RM Reprint Statements Header File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       RM30701 AS ['RM Reprint Statements Header File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['RM Reprint Statements Header File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
80CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
81DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
82DEX_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 Reprint Statements Header File (RM30701)

Leave a Reply

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