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 IDStringSTR15_LBAU15
2DSCRIPTN SearchDescriptionStringSTR3030
3NOTEINDX SearchNote IndexCurrencyDLR1414
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 FormIntegerDDL0
5PRTCRLMT SearchPrint Credit LimitBooleanCB_Credit_Limits0
6PRTPYTRM SearchPrint Payment TermsBooleanCB_Payment_Terms0
7PRNTFNCH SearchPrint Finance ChargeBooleanCB_Finance_Charge0
8PRNTMSGS SearchPrint MessagesBooleanCB_Messages0
9STMNTFOR SearchStatement ForLong IntegerML_Statements_For0
10RSTRACTY SearchRestrict Account TypeIntegerGB0
11CUSTSORT SearchCustomer SortsIntegerDDL_Statement_Sorts0
12DOCSORTS SearchDocument SortsIntegerDDL_Document_Sorts0
13AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency17
14AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
15AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
16AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
17AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
18AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
19AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
20AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
21STMTRSTR SearchStatement RestrictsIntegerDDL0
22RSTRFRID SearchRestrict From IDStringSTR15_Customer_Number15
23RSTRTOID SearchRestrict To IDStringSTR15_Customer_Number15
24RSTRFNAM SearchRestrict From NameStringSTR64_Customer_Name64
25RSTRTNAM SearchRestrict To NameStringSTR64_Customer_Name64
26RSTRFCLS SearchRestrict From ClassStringSTR15_LBAU15
27RSTRTCLS SearchRestrict To ClassStringSTR15_LBAU15
28RSTRFRUD SearchRestrict From User DefinedStringSTR2020
29RSTRTOUD SearchRestrict To User DefinedStringSTR2020
30RSTFSPSN SearchRestrict From SalespersonStringSTR15_LBAU15
31RSTTSPSN SearchRestrict To SalespersonStringSTR15_LBAU15
32RSTRFTER SearchRestrict From TerritoryStringSTR15_LBAU15
33RSTTOTER SearchRestrict To TerritoryStringSTR15_LBAU15
34RSTRFZIP SearchRestrict From ZipStringSTR1010
35RSTRTZIP SearchRestrict To ZipStringSTR1010
36RSTFSTCY SearchRestrict From Statement CycleIntegerDDL_Stmt_Cycle0
37RSTTSTCY SearchRestrict To Statement CycleIntegerDDL_Stmt_Cycle0
38STMTLPTD SearchStatement Last PrintedDateDT8
39PRTDTTKN SearchPrint Date TokenIntegerINT0
40SUMDTTKN SearchSummary Date TokenIntegerINT0
41COFDTOKN SearchCut-Off Date TokenIntegerINT0
42STMTPRDT SearchStatement Print DateDateDT8
43SMRYDATE SearchSummary DateDateDT8
44CUTOFDAT SearchCutoff DateDateDT8
45ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
46EXPTTYPE SearchExport TypeIntegerINT0
47FILEXPNM SearchFile Export NameStringSTR255255
48IFFILXST SearchIf File ExistingIntegerGB0
49PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
50PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
51PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
52LOCATNID SearchLocation IDStringSTR15_Location_ID15
53INDCHLDSTMT SearchIndividual Child StatementsBooleanCB_Individual_Child_Statements0
54Email_Statements_Options SearchEmail Statements OptionsIntegerGB0
55Email_Statements_Form SearchEmail Statements FormIntegerDDL0
56EmailStmtsSubjectLine SearchEmail Statements Subject LineStringSTR130130
57RDCOLDPDBYUNAPPLDCR SearchReduce Oldest Period by Unapplied CreditBooleanCB_ReduceOldestPeriodByUnappliedCredit0
58PrintRemainingDocs SearchPrint Remaining DocsBooleanCB_PrintRemainingDocs0
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Statements Options File (RM40501)

Leave a Reply

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