RM Statements Options File (RM40501)

azurecurve Products Microsoft Dynamics GP (0)SalesRM Statements Options File (RM40501)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Statements Options File
Physical Name: RM40501
Technical Name: RM_Statements_ROPT

Group Display Name: Receivables Statements Files
Group Technical Name: RM_Statements_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	STMNTID	Statement ID	String	STR15_LBAU	15
2	DSCRIPTN	Description	String	STR30	30
3	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['RM Statements Options File'].NOTEINDX AS 'RM Statements Options File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM RM40501 AS ['RM Statements Options File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['RM Statements Options File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	STMTFORM	Statement Form	Integer	DDL	0
5	PRTCRLMT	Print Credit Limit	Boolean	CB_Credit_Limits	0
6	PRTPYTRM	Print Payment Terms	Boolean	CB_Payment_Terms	0
7	PRNTFNCH	Print Finance Charge	Boolean	CB_Finance_Charge	0
8	PRNTMSGS	Print Messages	Boolean	CB_Messages	0
9	STMNTFOR	Statement For	Long Integer	ML_Statements_For	0
10	RSTRACTY	Restrict Account Type	Integer	GB	0
11	CUSTSORT	Customer Sorts	Integer	DDL_Statement_Sorts	0
12	DOCSORTS	Document Sorts	Integer	DDL_Document_Sorts	0
13	AGPERAMT	Aging Period Amounts	DLR17_RBSO_STR$	Currency	17
14	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
15	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
16	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
17	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
18	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
19	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
20	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
21	STMTRSTR	Statement Restricts	Integer	DDL	0
22	RSTRFRID	Restrict From ID	String	STR15_Customer_Number	15
23	RSTRTOID	Restrict To ID	String	STR15_Customer_Number	15
24	RSTRFNAM	Restrict From Name	String	STR64_Customer_Name	64
25	RSTRTNAM	Restrict To Name	String	STR64_Customer_Name	64
26	RSTRFCLS	Restrict From Class	String	STR15_LBAU	15
27	RSTRTCLS	Restrict To Class	String	STR15_LBAU	15
28	RSTRFRUD	Restrict From User Defined	String	STR20	20
29	RSTRTOUD	Restrict To User Defined	String	STR20	20
30	RSTFSPSN	Restrict From Salesperson	String	STR15_LBAU	15
31	RSTTSPSN	Restrict To Salesperson	String	STR15_LBAU	15
32	RSTRFTER	Restrict From Territory	String	STR15_LBAU	15
33	RSTTOTER	Restrict To Territory	String	STR15_LBAU	15
34	RSTRFZIP	Restrict From Zip	String	STR10	10
35	RSTRTZIP	Restrict To Zip	String	STR10	10
36	RSTFSTCY	Restrict From Statement Cycle	Integer	DDL_Stmt_Cycle	0
37	RSTTSTCY	Restrict To Statement Cycle	Integer	DDL_Stmt_Cycle	0
38	STMTLPTD	Statement Last Printed	Date	DT	8
39	PRTDTTKN	Print Date Token	Integer	INT	0
40	SUMDTTKN	Summary Date Token	Integer	INT	0
41	COFDTOKN	Cut-Off Date Token	Integer	INT	0
42	STMTPRDT	Statement Print Date	Date	DT	8
43	SMRYDATE	Summary Date	Date	DT	8
44	CUTOFDAT	Cutoff Date	Date	DT	8
45	ASKECHTM	Ask Each Time	Boolean	CB_Ask_Each_Time	0
46	EXPTTYPE	Export Type	Integer	INT	0
47	FILEXPNM	File Export Name	String	STR255	255
48	IFFILXST	If File Existing	Integer	GB	0
49	PRNTOFIL	Print to File	Boolean	CB_Print_to_File	0
50	PRTOPRTR	Print to Printer	Boolean	CB_Print_to_Printer	0
51	PRTOSCRN	Print to Screen	Boolean	CB_Print_to_Screen	0
52	LOCATNID	Location ID	String	STR15_Location_ID	15
53	INDCHLDSTMT	Individual Child Statements	Boolean	CB_Individual_Child_Statements	0
54	Email_Statements_Options	Email Statements Options	Integer	GB	0
55	Email_Statements_Form	Email Statements Form	Integer	DDL	0
56	EmailStmtsSubjectLine	Email Statements Subject Line	String	STR130	130
57	RDCOLDPDBYUNAPPLDCR	Reduce Oldest Period by Unapplied Credit	Boolean	CB_ReduceOldestPeriodByUnappliedCredit	0
58	PrintRemainingDocs	Print Remaining Docs	Boolean	CB_PrintRemainingDocs	0

azurecurve Products Microsoft Dynamics GP (0)SalesRM Statements Options File (RM40501)

Click to show/hide

Leave a Reply Cancel reply