RM Statements Options File (RM40501)

azurecurveProductsMicrosoft 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1STMNTID SearchStatement IDSTR15_LBAUString1615
2DSCRIPTN SearchDescriptionSTR30String3230
3NOTEINDX SearchNote IndexDLR14Currency1014
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
4STMTFORM SearchStatement FormDDLInteger20
5PRTCRLMT SearchPrint Credit LimitCB_Credit_LimitsBoolean20
6PRTPYTRM SearchPrint Payment TermsCB_Payment_TermsBoolean20
7PRNTFNCH SearchPrint Finance ChargeCB_Finance_ChargeBoolean20
8PRNTMSGS SearchPrint MessagesCB_MessagesBoolean20
9STMNTFOR SearchStatement ForML_Statements_ForLong Integer40
10RSTRACTY SearchRestrict Account TypeGBInteger20
11CUSTSORT SearchCustomer SortsDDL_Statement_SortsInteger20
12DOCSORTS SearchDocument SortsDDL_Document_SortsInteger20
13AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency1017
14AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
15AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
16AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
17AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
18AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
19AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
20AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
21STMTRSTR SearchStatement RestrictsDDLInteger20
22RSTRFRID SearchRestrict From IDSTR15_Customer_NumberString1615
23RSTRTOID SearchRestrict To IDSTR15_Customer_NumberString1615
24RSTRFNAM SearchRestrict From NameSTR64_Customer_NameString6664
25RSTRTNAM SearchRestrict To NameSTR64_Customer_NameString6664
26RSTRFCLS SearchRestrict From ClassSTR15_LBAUString1615
27RSTRTCLS SearchRestrict To ClassSTR15_LBAUString1615
28RSTRFRUD SearchRestrict From User DefinedSTR20String2220
29RSTRTOUD SearchRestrict To User DefinedSTR20String2220
30RSTFSPSN SearchRestrict From SalespersonSTR15_LBAUString1615
31RSTTSPSN SearchRestrict To SalespersonSTR15_LBAUString1615
32RSTRFTER SearchRestrict From TerritorySTR15_LBAUString1615
33RSTTOTER SearchRestrict To TerritorySTR15_LBAUString1615
34RSTRFZIP SearchRestrict From ZipSTR10String1210
35RSTRTZIP SearchRestrict To ZipSTR10String1210
36RSTFSTCY SearchRestrict From Statement CycleDDL_Stmt_CycleInteger20
37RSTTSTCY SearchRestrict To Statement CycleDDL_Stmt_CycleInteger20
38STMTLPTD SearchStatement Last PrintedDTDate48
39PRTDTTKN SearchPrint Date TokenINTInteger20
40SUMDTTKN SearchSummary Date TokenINTInteger20
41COFDTOKN SearchCut-Off Date TokenINTInteger20
42STMTPRDT SearchStatement Print DateDTDate48
43SMRYDATE SearchSummary DateDTDate48
44CUTOFDAT SearchCutoff DateDTDate48
45ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
46EXPTTYPE SearchExport TypeINTInteger20
47FILEXPNM SearchFile Export NameSTR255String256255
48IFFILXST SearchIf File ExistingGBInteger20
49PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
50PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
51PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
52LOCATNID SearchLocation IDSTR15_Location_IDString1615
53INDCHLDSTMT SearchIndividual Child StatementsCB_Individual_Child_StatementsBoolean20
54Email_Statements_Options SearchEmail Statements OptionsGBInteger20
55Email_Statements_Form SearchEmail Statements FormDDLInteger20
56EmailStmtsSubjectLine SearchEmail Statements Subject LineSTR130String132130
57RDCOLDPDBYUNAPPLDCR SearchReduce Oldest Period by Unapplied CreditCB_ReduceOldestPeriodByUnappliedCreditBoolean20
58PrintRemainingDocs SearchPrint Remaining DocsCB_PrintRemainingDocsBoolean20
59DEX_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 Statements Options File (RM40501)

Leave a Reply

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