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 TypeSQL DB LengthKeyable Length
1SETUPKEY SearchSetup KeyINTInteger20
2AGEBY SearchAge ByGB_Age_ByInteger20
3AGPEREND SearchAging Periods EndINT3Integer23
4AGPEREND_1 SearchAging Periods End[1]INT3Integer23
5AGPEREND_2 SearchAging Periods End[2]INT3Integer23
6AGPEREND_3 SearchAging Periods End[3]INT3Integer23
7AGPEREND_4 SearchAging Periods End[4]INT3Integer23
8AGPEREND_5 SearchAging Periods End[5]INT3Integer23
9AGPEREND_6 SearchAging Periods End[6]INT3Integer23
10AGPEREND_7 SearchAging Periods End[7]INT3Integer23
11AGPERUSD SearchAging Periods UsedINT2Integer22
12CRLMPSWD SearchCredit Limit PasswordSTR10_LBUString1210
13CUSTHPWD SearchCustomer Hold PasswordSTR10_LBUString1210
14WRTFPSWD SearchWriteoff PasswordSTR10_LBUString1210
15WVFCHPWD SearchWaived Finance Charge PasswordSTR10_LBUString1210
16PRTHATRB SearchPrint Historical Aged Trial BalanceCB_Print_Historical_Aged_Trial_BalanceBoolean20
17CPDFINCH SearchCompound Finance ChargeCB_Compound_Finance_ChargeBoolean20
18RMTRKDAV SearchRM Track Discounts AvailableCB_Track_Discounts_AvailableBoolean20
19RMPCAIPD SearchRM Pay Commissions After Invoice PaidCB_Pay_Commissions_After_Invoice_PaidBoolean20
20NSFCHDEF SearchNSF Charge DefaultDLR17_RBS0_UTR$Currency1017
21APLBYDEF SearchApply By DefaultGBInteger20
22LDFNCHGD SearchLast Date Finance ChargedDT_DateDate46
23LDSTPRTD SearchLast Date Statements PrintedDT_DateDate46
24LDBLFAGD SearchLast Date Balance Forward AgedDT_DateDate46
25LDOITAGD SearchLast Date Open Items AgedDT_DateDate46
26LDPTRRMV SearchLast Date Paid Transactions RemovalDT_DateDate46
27LSTYECAL SearchLast Year End CalendarDTDate48
28LSTYEFSC SearchLast Year End FiscalDTDate48
29USRDFPR1 SearchUser Defined Prompt 1STR15String1615
30USRDRPR2 SearchUser Defined Prompt 2STR15String1615
31FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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 IDSTR15_LBUString1615
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 IDSTR15_LBAUString1615
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 IDSTR15_Checkbook_IDString1615
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 CBCB_SalesBoolean20
36DISCNTCB SearchDiscount CBCB_DiscountBoolean20
37FREIGHT SearchFreightCB_FreightBoolean20
38MISC SearchMiscCB_MiscBoolean20
39TAX SearchTaxCB_TaxBoolean20
40RMVDSTTY SearchRM Valid Dist TypesML_RM_Valid_Dist_TypesLong Integer40
41RMVDSTTY_1 SearchRM Valid Dist Types[1]ML_RM_Valid_Dist_TypesLong Integer40
42RMVDSTTY_2 SearchRM Valid Dist Types[2]ML_RM_Valid_Dist_TypesLong Integer40
43RMVDSTTY_3 SearchRM Valid Dist Types[3]ML_RM_Valid_Dist_TypesLong Integer40
44RMVDSTTY_4 SearchRM Valid Dist Types[4]ML_RM_Valid_Dist_TypesLong Integer40
45RMVDSTTY_5 SearchRM Valid Dist Types[5]ML_RM_Valid_Dist_TypesLong Integer40
46RMVDSTTY_6 SearchRM Valid Dist Types[6]ML_RM_Valid_Dist_TypesLong Integer40
47RMVDSTTY_7 SearchRM Valid Dist Types[7]ML_RM_Valid_Dist_TypesLong Integer40
48RMVDSTTY_8 SearchRM Valid Dist Types[8]ML_RM_Valid_Dist_TypesLong Integer40
49RMVDSTTY_9 SearchRM Valid Dist Types[9]ML_RM_Valid_Dist_TypesLong Integer40
50LDCMTRNS SearchLast Date Commissions TransferredDT_DateDate46
51PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
52RMDFTyp SearchRM Document Format TypeDDL_RM_Document_Format_TypeInteger20
53DelUPDoc SearchDelete Unposted Printed DocsCB_Delete_Unposted_Printed_DocsBoolean20
54PrntTaxDetDoc SearchPrint Tax Details On DocumentsCB_Print_Tax_DetailsBoolean20
55RPRNTSTTMNTS SearchReprint StatementsCB_Reprint_StatementsBoolean20
56ATAPPLFNNCCHRGSFRST SearchAuto Apply Finance Charges FirstCB_Auto_Apply_FC_FirstBoolean20
57EmailStmtStatusRecipient SearchEmail Statements Status RecipientSTR80String8280
58DateSensitivitySumView SearchDate Sensitivity Summary ViewDDL_Date_Sensitivity_Summary_ViewInteger20
59PRNTDCUR SearchPrint Dual CurrenciesCB_Print_Dual_CurrenciesBoolean20
60AGEUNAPPLDCR SearchAge Unapplied Credit AmountsCB_AgeUnappliedCreditAmountsBoolean20
61WriteoffCreditMemoNumber SearchWriteoff Credit Memo NumberSTR20_Document_NumberString2220
62WriteoffDebitMemoNumber SearchWriteoff Debit Memo NumberSTR20_Document_NumberString2220
63USRDRPR3 SearchUser Defined Prompt 3STR15String1615
64USRDRPR4 SearchUser Defined Prompt 4STR15String1615
65DisplayOverCreditIcon SearchDisplay Over Credit IconCB_DisplayOverCreditIconBoolean20
66DisplayOverCreditWarning SearchDisplay Over Credit WarningCB_DisplayOverCreditWarningBoolean20
67DEX_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.

Leave a Reply

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