RM Reprint Statements Header File (RM30701)

azurecurve Products Microsoft 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 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/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
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/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
7	CURRNIDX	Currency Index	INT3	Integer	3
	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
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/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
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/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
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.

azurecurve Products Microsoft Dynamics GP (0)SalesRM Reprint Statements Header File (RM30701)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply