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 TypeLength
1RNNMBR SearchRun NumberLong IntegerLong Int8
2DSCRIPTN SearchDescriptionStringSTR3030
3STMNTID SearchStatement IDStringSTR15_LBAU15
4CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 NameStringSTR6464
6CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 IndexIntegerINT33
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 PersonStringSTR6060
9ADDRESS1 SearchAddress 1StringSTR6060
10ADDRESS2 SearchAddress 2StringSTR6060
11ADDRESS3 SearchAddress 3StringSTR6060
12PHONE1 SearchPhone 1StringPhone_Number14
13PHONE2 SearchPhone 2StringPhone_Number14
14PHONE3 SearchPhone 3StringPhone_Number314
15CITY SearchCityStringSTR3535
16STATE SearchStateStringSTR30_State29
17ZIP SearchZipStringSTR1010
18DATE1 SearchDateDateDT66
19MINPYDUE SearchMinimum Payment DueCurrencyDLR11_$S214
20CUSTMSGS SearchCustomer MessagesSTR40String40
21CUSTMSGS_1 SearchCustomer Messages[1]StringSTR4040
22CUSTMSGS_2 SearchCustomer Messages[2]StringSTR4040
23CUSTMSGS_3 SearchCustomer Messages[3]StringSTR4040
24AMNTDUE SearchAmount DueCurrencyDLR11_$S214
25STMTMSGS_1 SearchStatement Messages[1]StringSTR5050
26STMTMSGS_2 SearchStatement Messages[2]StringSTR5050
27STMTMSGS SearchStatement MessagesSTR50String50
28STMTMSGS_3 SearchStatement Messages[3]StringSTR5050
29STMTMSGS_4 SearchStatement Messages[4]StringSTR5050
30STMTMSGS_5 SearchStatement Messages[5]StringSTR5050
31STMTMSGS_6 SearchStatement Messages[6]StringSTR5050
32STMTMSGS_7 SearchStatement Messages[7]StringSTR5050
33STMTMSGS_8 SearchStatement Messages[8]StringSTR5050
34STMTMSGS_9 SearchStatement Messages[9]StringSTR5050
35STMTMSGS_10 SearchStatement Messages[10]StringSTR5050
36STMTMSGS_11 SearchStatement Messages[11]StringSTR5050
37STMTMSGS_12 SearchStatement Messages[12]StringSTR5050
38STMTMSGS_13 SearchStatement Messages[13]StringSTR5050
39STMTMSGS_14 SearchStatement Messages[14]StringSTR5050
40STMTMSGS_15 SearchStatement Messages[15]StringSTR5050
41DOCARABR_1 SearchDocument Array Abbreviation[1]StringSTR33
42DOCARABR_2 SearchDocument Array Abbreviation[2]StringSTR33
43DOCARABR SearchDocument Array AbbreviationSTR3String3
44DOCARABR_3 SearchDocument Array Abbreviation[3]StringSTR33
45DOCARABR_4 SearchDocument Array Abbreviation[4]StringSTR33
46DOCARABR_5 SearchDocument Array Abbreviation[5]StringSTR33
47DOCARABR_6 SearchDocument Array Abbreviation[6]StringSTR33
48DOCARABR_7 SearchDocument Array Abbreviation[7]StringSTR33
49DOCARABR_8 SearchDocument Array Abbreviation[8]StringSTR33
50DOCARABR_9 SearchDocument Array Abbreviation[9]StringSTR33
51DOCARDSC_1 SearchDocument Array Description[1]StringSTR2020
52DOCARDSC_2 SearchDocument Array Description[2]StringSTR2020
53DOCARDSC_3 SearchDocument Array Description[3]StringSTR2020
54DOCARDSC SearchDocument Array DescriptionSTR20String20
55DOCARDSC_4 SearchDocument Array Description[4]StringSTR2020
56DOCARDSC_5 SearchDocument Array Description[5]StringSTR2020
57DOCARDSC_6 SearchDocument Array Description[6]StringSTR2020
58DOCARDSC_7 SearchDocument Array Description[7]StringSTR2020
59DOCARDSC_8 SearchDocument Array Description[8]StringSTR2020
60DOCARDSC_9 SearchDocument Array Description[9]StringSTR2020
61AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
62AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
63AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
64AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
65AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency17
66AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
67AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
68AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
69AGPERDSC_1 SearchAging Periods Descriptions[1]StringSTR1515
70AGPERDSC_2 SearchAging Periods Descriptions[2]StringSTR1515
71AGPERDSC_3 SearchAging Periods Descriptions[3]StringSTR1515
72AGPERDSC_4 SearchAging Periods Descriptions[4]StringSTR1515
73AGPERDSC_5 SearchAging Periods Descriptions[5]StringSTR1515
74AGPERDSC SearchAging Periods DescriptionsSTR15String15
75AGPERDSC_6 SearchAging Periods Descriptions[6]StringSTR1515
76AGPERDSC_7 SearchAging Periods Descriptions[7]StringSTR1515
77CMPANYID SearchCompany IDIntegerINT54
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 IDStringSTR15_Location_ID15
79PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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 BalanceCurrencyDLR19_RBS0_STR$19
81DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Reprint Statements Header File (RM30701)

Leave a Reply

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