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 TypeLength
1STMNTID SearchStatement IDSTR15_LBAUString15
2DSCRIPTN SearchDescriptionSTR30String30
3NOTEINDX SearchNote IndexDLR14Currency14
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 FormDDLInteger0
5PRTCRLMT SearchPrint Credit LimitCB_Credit_LimitsBoolean0
6PRTPYTRM SearchPrint Payment TermsCB_Payment_TermsBoolean0
7PRNTFNCH SearchPrint Finance ChargeCB_Finance_ChargeBoolean0
8PRNTMSGS SearchPrint MessagesCB_MessagesBoolean0
9STMNTFOR SearchStatement ForML_Statements_ForLong Integer0
10RSTRACTY SearchRestrict Account TypeGBInteger0
11CUSTSORT SearchCustomer SortsDDL_Statement_SortsInteger0
12DOCSORTS SearchDocument SortsDDL_Document_SortsInteger0
13AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency17
14AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
15AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
16AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
17AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
18AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
19AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
20AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
21STMTRSTR SearchStatement RestrictsDDLInteger0
22RSTRFRID SearchRestrict From IDSTR15_Customer_NumberString15
23RSTRTOID SearchRestrict To IDSTR15_Customer_NumberString15
24RSTRFNAM SearchRestrict From NameSTR64_Customer_NameString64
25RSTRTNAM SearchRestrict To NameSTR64_Customer_NameString64
26RSTRFCLS SearchRestrict From ClassSTR15_LBAUString15
27RSTRTCLS SearchRestrict To ClassSTR15_LBAUString15
28RSTRFRUD SearchRestrict From User DefinedSTR20String20
29RSTRTOUD SearchRestrict To User DefinedSTR20String20
30RSTFSPSN SearchRestrict From SalespersonSTR15_LBAUString15
31RSTTSPSN SearchRestrict To SalespersonSTR15_LBAUString15
32RSTRFTER SearchRestrict From TerritorySTR15_LBAUString15
33RSTTOTER SearchRestrict To TerritorySTR15_LBAUString15
34RSTRFZIP SearchRestrict From ZipSTR10String10
35RSTRTZIP SearchRestrict To ZipSTR10String10
36RSTFSTCY SearchRestrict From Statement CycleDDL_Stmt_CycleInteger0
37RSTTSTCY SearchRestrict To Statement CycleDDL_Stmt_CycleInteger0
38STMTLPTD SearchStatement Last PrintedDTDate8
39PRTDTTKN SearchPrint Date TokenINTInteger0
40SUMDTTKN SearchSummary Date TokenINTInteger0
41COFDTOKN SearchCut-Off Date TokenINTInteger0
42STMTPRDT SearchStatement Print DateDTDate8
43SMRYDATE SearchSummary DateDTDate8
44CUTOFDAT SearchCutoff DateDTDate8
45ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
46EXPTTYPE SearchExport TypeINTInteger0
47FILEXPNM SearchFile Export NameSTR255String255
48IFFILXST SearchIf File ExistingGBInteger0
49PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
50PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
51PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
52LOCATNID SearchLocation IDSTR15_Location_IDString15
53INDCHLDSTMT SearchIndividual Child StatementsCB_Individual_Child_StatementsBoolean0
54Email_Statements_Options SearchEmail Statements OptionsGBInteger0
55Email_Statements_Form SearchEmail Statements FormDDLInteger0
56EmailStmtsSubjectLine SearchEmail Statements Subject LineSTR130String130
57RDCOLDPDBYUNAPPLDCR SearchReduce Oldest Period by Unapplied CreditCB_ReduceOldestPeriodByUnappliedCreditBoolean0
58PrintRemainingDocs SearchPrint Remaining DocsCB_PrintRemainingDocsBoolean0
59DEX_ROW_ID Searchintint10

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 *