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 Group Display Name: Receivable Transaction History Files
Physical Name: RM30701
Technical Name: rmReprintStmtsHDR
Group Technical Name: RM_Transaction_History_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | RNNMBR ![]() | Run Number | Long Int | Long Integer | 8 | |
2 | DSCRIPTN ![]() | Description | STR30 | String | 30 | |
3 | STMNTID ![]() | Statement ID | STR15_LBAU | String | 15 | |
4 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
5 | STMTNAME ![]() | Statement Name | STR64 | String | 64 | |
6 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
7 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
8 | CNTCPRSN ![]() | Contact Person | STR60 | String | 60 | |
9 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
10 | ADDRESS2 ![]() | Address 2 | STR60 | String | 60 | |
11 | ADDRESS3 ![]() | Address 3 | STR60 | String | 60 | |
12 | PHONE1 ![]() | Phone 1 | Phone_Number | String | 14 | |
13 | PHONE2 ![]() | Phone 2 | Phone_Number | String | 14 | |
14 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 14 | |
15 | CITY ![]() | City | STR35 | String | 35 | |
16 | STATE ![]() | State | STR30_State | String | 29 | |
17 | ZIP ![]() | Zip | STR10 | String | 10 | |
18 | DATE1 ![]() | Date | DT6 | Date | 6 | |
19 | MINPYDUE ![]() | Minimum Payment Due | DLR11_$S2 | Currency | 14 | |
20 | CUSTMSGS ![]() | Customer Messages | STR40 | String | 40 | |
21 | CUSTMSGS_1 ![]() | Customer Messages[1] | STR40 | String | 40 | |
22 | CUSTMSGS_2 ![]() | Customer Messages[2] | STR40 | String | 40 | |
23 | CUSTMSGS_3 ![]() | Customer Messages[3] | STR40 | String | 40 | |
24 | AMNTDUE ![]() | Amount Due | DLR11_$S2 | Currency | 14 | |
25 | STMTMSGS ![]() | Statement Messages | STR50 | String | 50 | |
26 | STMTMSGS_1 ![]() | Statement Messages[1] | STR50 | String | 50 | |
27 | STMTMSGS_2 ![]() | Statement Messages[2] | STR50 | String | 50 | |
28 | STMTMSGS_3 ![]() | Statement Messages[3] | STR50 | String | 50 | |
29 | STMTMSGS_4 ![]() | Statement Messages[4] | STR50 | String | 50 | |
30 | STMTMSGS_5 ![]() | Statement Messages[5] | STR50 | String | 50 | |
31 | STMTMSGS_6 ![]() | Statement Messages[6] | STR50 | String | 50 | |
32 | STMTMSGS_7 ![]() | Statement Messages[7] | STR50 | String | 50 | |
33 | STMTMSGS_8 ![]() | Statement Messages[8] | STR50 | String | 50 | |
34 | STMTMSGS_9 ![]() | Statement Messages[9] | STR50 | String | 50 | |
35 | STMTMSGS_10 ![]() | Statement Messages[10] | STR50 | String | 50 | |
36 | STMTMSGS_11 ![]() | Statement Messages[11] | STR50 | String | 50 | |
37 | STMTMSGS_12 ![]() | Statement Messages[12] | STR50 | String | 50 | |
38 | STMTMSGS_13 ![]() | Statement Messages[13] | STR50 | String | 50 | |
39 | STMTMSGS_14 ![]() | Statement Messages[14] | STR50 | String | 50 | |
40 | STMTMSGS_15 ![]() | Statement Messages[15] | STR50 | String | 50 | |
41 | DOCARABR ![]() | Document Array Abbreviation | STR3 | String | 3 | |
42 | DOCARABR_1 ![]() | Document Array Abbreviation[1] | STR3 | String | 3 | |
43 | DOCARABR_2 ![]() | Document Array Abbreviation[2] | STR3 | String | 3 | |
44 | DOCARABR_3 ![]() | Document Array Abbreviation[3] | STR3 | String | 3 | |
45 | DOCARABR_4 ![]() | Document Array Abbreviation[4] | STR3 | String | 3 | |
46 | DOCARABR_5 ![]() | Document Array Abbreviation[5] | STR3 | String | 3 | |
47 | DOCARABR_6 ![]() | Document Array Abbreviation[6] | STR3 | String | 3 | |
48 | DOCARABR_7 ![]() | Document Array Abbreviation[7] | STR3 | String | 3 | |
49 | DOCARABR_8 ![]() | Document Array Abbreviation[8] | STR3 | String | 3 | |
50 | DOCARABR_9 ![]() | Document Array Abbreviation[9] | STR3 | String | 3 | |
51 | DOCARDSC ![]() | Document Array Description | STR20 | String | 20 | |
52 | DOCARDSC_1 ![]() | Document Array Description[1] | STR20 | String | 20 | |
53 | DOCARDSC_2 ![]() | Document Array Description[2] | STR20 | String | 20 | |
54 | DOCARDSC_3 ![]() | Document Array Description[3] | STR20 | String | 20 | |
55 | DOCARDSC_4 ![]() | Document Array Description[4] | STR20 | String | 20 | |
56 | DOCARDSC_5 ![]() | Document Array Description[5] | STR20 | String | 20 | |
57 | DOCARDSC_6 ![]() | Document Array Description[6] | STR20 | String | 20 | |
58 | DOCARDSC_7 ![]() | Document Array Description[7] | STR20 | String | 20 | |
59 | DOCARDSC_8 ![]() | Document Array Description[8] | STR20 | String | 20 | |
60 | DOCARDSC_9 ![]() | Document Array Description[9] | STR20 | String | 20 | |
61 | AGPERAMT ![]() | Aging Period Amounts | DLR17_RBSO_STR$ | Currency | 17 | |
62 | AGPERAMT_1 ![]() | Aging Period Amounts[1] | DLR17_RBSO_STR$ | Currency | 17 | |
63 | AGPERAMT_2 ![]() | Aging Period Amounts[2] | DLR17_RBSO_STR$ | Currency | 17 | |
64 | AGPERAMT_3 ![]() | Aging Period Amounts[3] | DLR17_RBSO_STR$ | Currency | 17 | |
65 | AGPERAMT_4 ![]() | Aging Period Amounts[4] | DLR17_RBSO_STR$ | Currency | 17 | |
66 | AGPERAMT_5 ![]() | Aging Period Amounts[5] | DLR17_RBSO_STR$ | Currency | 17 | |
67 | AGPERAMT_6 ![]() | Aging Period Amounts[6] | DLR17_RBSO_STR$ | Currency | 17 | |
68 | AGPERAMT_7 ![]() | Aging Period Amounts[7] | DLR17_RBSO_STR$ | Currency | 17 | |
69 | AGPERDSC ![]() | Aging Periods Descriptions | STR15 | String | 15 | |
70 | AGPERDSC_1 ![]() | Aging Periods Descriptions[1] | STR15 | String | 15 | |
71 | AGPERDSC_2 ![]() | Aging Periods Descriptions[2] | STR15 | String | 15 | |
72 | AGPERDSC_3 ![]() | Aging Periods Descriptions[3] | STR15 | String | 15 | |
73 | AGPERDSC_4 ![]() | Aging Periods Descriptions[4] | STR15 | String | 15 | |
74 | AGPERDSC_5 ![]() | Aging Periods Descriptions[5] | STR15 | String | 15 | |
75 | AGPERDSC_6 ![]() | Aging Periods Descriptions[6] | STR15 | String | 15 | |
76 | AGPERDSC_7 ![]() | Aging Periods Descriptions[7] | STR15 | String | 15 | |
77 | CMPANYID ![]() | Company ID | INT5 | Integer | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['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 | ||||||
78 | LOCATNID ![]() | Location ID | STR15_Location_ID | String | 15 | |
79 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['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 | ||||||
80 | CUSTBLNC ![]() | Customer Balance | DLR19_RBS0_STR$ | Currency | 19 | |
81 | DEPRECV ![]() | Deposits Received | DLR19_RBS0_STR$ | Currency | 19 | |
82 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |