RM Module Setup File (RM40101)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Module Setup File
Physical Name: RM40101
Technical Name: RM_Module_SETP

Group Display Name: Receivables Setup Files
Group Technical Name: RM_Setup_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SETUPKEY SearchSetup KeyIntegerINT0
2AGEBY SearchAge ByIntegerGB_Age_By0
3AGPEREND SearchAging Periods EndINT3Integer3
4AGPEREND_1 SearchAging Periods End[1]IntegerINT33
5AGPEREND_2 SearchAging Periods End[2]IntegerINT33
6AGPEREND_3 SearchAging Periods End[3]IntegerINT33
7AGPEREND_4 SearchAging Periods End[4]IntegerINT33
8AGPEREND_5 SearchAging Periods End[5]IntegerINT33
9AGPEREND_6 SearchAging Periods End[6]IntegerINT33
10AGPEREND_7 SearchAging Periods End[7]IntegerINT33
11AGPERUSD SearchAging Periods UsedIntegerINT22
12CRLMPSWD SearchCredit Limit PasswordStringSTR10_LBU10
13CUSTHPWD SearchCustomer Hold PasswordStringSTR10_LBU10
14WRTFPSWD SearchWriteoff PasswordStringSTR10_LBU10
15WVFCHPWD SearchWaived Finance Charge PasswordStringSTR10_LBU10
16PRTHATRB SearchPrint Historical Aged Trial BalanceBooleanCB_Print_Historical_Aged_Trial_Balance0
17CPDFINCH SearchCompound Finance ChargeBooleanCB_Compound_Finance_Charge0
18RMTRKDAV SearchRM Track Discounts AvailableBooleanCB_Track_Discounts_Available0
19RMPCAIPD SearchRM Pay Commissions After Invoice PaidBooleanCB_Pay_Commissions_After_Invoice_Paid0
20NSFCHDEF SearchNSF Charge DefaultCurrencyDLR17_RBS0_UTR$17
21APLBYDEF SearchApply By DefaultIntegerGB0
22LDFNCHGD SearchLast Date Finance ChargedDateDT_Date6
23LDSTPRTD SearchLast Date Statements PrintedDateDT_Date6
24LDBLFAGD SearchLast Date Balance Forward AgedDateDT_Date6
25LDOITAGD SearchLast Date Open Items AgedDateDT_Date6
26LDPTRRMV SearchLast Date Paid Transactions RemovalDateDT_Date6
27LSTYECAL SearchLast Year End CalendarDateDT8
28LSTYEFSC SearchLast Year End FiscalDateDT8
29USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
30USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
31FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Module Setup File'].FRTSCHID AS 'RM Module Setup File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM40101 AS ['RM Module Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Module Setup File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
32SLSCHDID SearchSales Schedule IDStringSTR15_LBU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Module Setup File'].SLSCHDID AS 'RM Module Setup File-Sales Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM40101 AS ['RM Module Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Module Setup File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
33MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Module Setup File'].MSCSCHID AS 'RM Module Setup File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM40101 AS ['RM Module Setup File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Module Setup File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['RM Module Setup File'].CHEKBKID AS 'RM Module Setup File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RM40101 AS ['RM Module Setup File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['RM Module Setup File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
35SALESCB SearchSales CBBooleanCB_Sales0
36DISCNTCB SearchDiscount CBBooleanCB_Discount0
37FREIGHT SearchFreightBooleanCB_Freight0
38MISC SearchMiscBooleanCB_Misc0
39TAX SearchTaxBooleanCB_Tax0
40RMVDSTTY_1 SearchRM Valid Dist Types[1]Long IntegerML_RM_Valid_Dist_Types0
41RMVDSTTY_2 SearchRM Valid Dist Types[2]Long IntegerML_RM_Valid_Dist_Types0
42RMVDSTTY SearchRM Valid Dist TypesML_RM_Valid_Dist_TypesLong Integer0
43RMVDSTTY_3 SearchRM Valid Dist Types[3]Long IntegerML_RM_Valid_Dist_Types0
44RMVDSTTY_4 SearchRM Valid Dist Types[4]Long IntegerML_RM_Valid_Dist_Types0
45RMVDSTTY_5 SearchRM Valid Dist Types[5]Long IntegerML_RM_Valid_Dist_Types0
46RMVDSTTY_6 SearchRM Valid Dist Types[6]Long IntegerML_RM_Valid_Dist_Types0
47RMVDSTTY_7 SearchRM Valid Dist Types[7]Long IntegerML_RM_Valid_Dist_Types0
48RMVDSTTY_8 SearchRM Valid Dist Types[8]Long IntegerML_RM_Valid_Dist_Types0
49RMVDSTTY_9 SearchRM Valid Dist Types[9]Long IntegerML_RM_Valid_Dist_Types0
50LDCMTRNS SearchLast Date Commissions TransferredDateDT_Date6
51PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
52RMDFTyp SearchRM Document Format TypeIntegerDDL_RM_Document_Format_Type0
53DelUPDoc SearchDelete Unposted Printed DocsBooleanCB_Delete_Unposted_Printed_Docs0
54PrntTaxDetDoc SearchPrint Tax Details On DocumentsBooleanCB_Print_Tax_Details0
55RPRNTSTTMNTS SearchReprint StatementsBooleanCB_Reprint_Statements0
56ATAPPLFNNCCHRGSFRST SearchAuto Apply Finance Charges FirstBooleanCB_Auto_Apply_FC_First0
57EmailStmtStatusRecipient SearchEmail Statements Status RecipientStringSTR8080
58DateSensitivitySumView SearchDate Sensitivity Summary ViewIntegerDDL_Date_Sensitivity_Summary_View0
59PRNTDCUR SearchPrint Dual CurrenciesBooleanCB_Print_Dual_Currencies0
60AGEUNAPPLDCR SearchAge Unapplied Credit AmountsBooleanCB_AgeUnappliedCreditAmounts0
61WriteoffCreditMemoNumber SearchWriteoff Credit Memo NumberStringSTR20_Document_Number20
62WriteoffDebitMemoNumber SearchWriteoff Debit Memo NumberStringSTR20_Document_Number20
63USRDRPR3 SearchUser Defined Prompt 3StringSTR1515
64USRDRPR4 SearchUser Defined Prompt 4StringSTR1515
65DisplayOverCreditIcon SearchDisplay Over Credit IconBooleanCB_DisplayOverCreditIcon0
66DisplayOverCreditWarning SearchDisplay Over Credit WarningBooleanCB_DisplayOverCreditWarning0

Leave a Reply

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