RM40101 - RM Module Setup File

Dynamics GP table RM40101 (RM Module Setup File) contains 62 columns including SETUPKEY, AGEBY, AGPEREND_1....

SQL Query Builder

SELECT * FROM RM40101

62 Columns

Select all

Column	Description	Type	Length	Shared With
SETUPKEY	Setup Key	Integer	2	4 tables
AGEBY	Age By	Integer	2	-
AGPEREND_1	Aging Periods End[1]	Integer	2	-
AGPEREND_2	Aging Periods End[2]	Integer	2	-
AGPEREND_3	Aging Periods End[3]	Integer	2	-
AGPEREND_4	Aging Periods End[4]	Integer	2	-
AGPEREND_5	Aging Periods End[5]	Integer	2	-
AGPEREND_6	Aging Periods End[6]	Integer	2	-
AGPEREND_7	Aging Periods End[7]	Integer	2	-
AGPERUSD	Aging Periods Used	Integer	2	-
CRLMPSWD	Credit Limit Password	String	12	-
CUSTHPWD	Customer Hold Password	String	12	-
WRTFPSWD	Writeoff Password	String	12	-
WVFCHPWD	Waived Finance Charge Password	String	12	-
PRTHATRB	Print Historical Aged Trial Balance	Boolean	2	-
CPDFINCH	Compound Finance Charge	Boolean	2	-
RMTRKDAV	RM Track Discounts Available	Boolean	2	-
RMPCAIPD	RM Pay Commissions After Invoice Paid	Boolean	2	-
NSFCHDEF	NSF Charge Default	Currency	10	-
APLBYDEF	Apply By Default	Integer	2	-
LDFNCHGD	Last Date Finance Charged	Date	4	-
LDSTPRTD	Last Date Statements Printed	Date	4	-
LDBLFAGD	Last Date Balance Forward Aged	Date	4	-
LDOITAGD	Last Date Open Items Aged	Date	4	-
LDPTRRMV	Last Date Paid Transactions Removal	Date	4	-
LSTYECAL	Last Year End Calendar	Date	4	-
LSTYEFSC	Last Year End Fiscal	Date	4	-
USRDFPR1	User Defined Prompt 1	String	16	1 tables
USRDRPR2	User Defined Prompt 2	String	16	1 tables
FRTSCHID	Freight Schedule ID	String	16	30 tables
SLSCHDID	Sales Schedule ID	String	16	6 tables
MSCSCHID	Misc Schedule ID	String	16	30 tables
CHEKBKID	Checkbook ID	String	16	37 tables
SALESCB	Sales CB	Boolean	2	-
DISCNTCB	Discount CB	Boolean	2	-
FREIGHT	Freight	Boolean	2	-
MISC	Misc	Boolean	2	-
TAX	Tax	Boolean	2	-
RMVDSTTY_1	RM Valid Dist Types[1]	Long Integer	4	-
RMVDSTTY_2	RM Valid Dist Types[2]	Long Integer	4	-
RMVDSTTY_3	RM Valid Dist Types[3]	Long Integer	4	-
RMVDSTTY_4	RM Valid Dist Types[4]	Long Integer	4	-
RMVDSTTY_5	RM Valid Dist Types[5]	Long Integer	4	-
RMVDSTTY_6	RM Valid Dist Types[6]	Long Integer	4	-
RMVDSTTY_7	RM Valid Dist Types[7]	Long Integer	4	-
RMVDSTTY_8	RM Valid Dist Types[8]	Long Integer	4	-
RMVDSTTY_9	RM Valid Dist Types[9]	Long Integer	4	-
LDCMTRNS	Last Date Commissions Transferred	Date	4	-
PRCLEVEL	PriceLevel	String	12	26 tables
RMDFTyp	RM Document Format Type	Integer	2	-
DelUPDoc	Delete Unposted Printed Docs	Boolean	2	-
PrntTaxDetDoc	Print Tax Details On Documents	Boolean	2	-
RPRNTSTTMNTS	Reprint Statements	Boolean	2	-
ATAPPLFNNCCHRGSFRST	Auto Apply Finance Charges First	Boolean	2	-
EmailStmtStatusRecipient	Email Statements Status Recipient	String	82	-
DateSensitivitySumView	Date Sensitivity Summary View	Integer	2	-
PRNTDCUR	Print Dual Currencies	Boolean	2	-
AGEUNAPPLDCR	Age Unapplied Credit Amounts	Boolean	2	-
WriteoffCreditMemoNumber	Writeoff Credit Memo Number	String	22	-
WriteoffDebitMemoNumber	Writeoff Debit Memo Number	String	22	-
USRDRPR3	User Defined Prompt 3	String	16	1 tables
USRDRPR4	User Defined Prompt 4	String	16	1 tables

Related Tables

Tables that share columns with RM40101. Click "Join" to add to your query.

SLSCHDID

ASIEXP08 ICJC9000 RM10301 RM20101 RM30101 RM50100

SETUPKEY

BM40100 IV41000 RM40401 ReportSetup

USRDFPR1

BM40100

USRDRPR2

BM40100

USRDRPR3

BM40100

USRDRPR4

BM40100