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 Group Display Name: Receivables Setup Files
Physical Name: RM40101
Technical Name: RM_Module_SETP
Group Technical Name: RM_Setup_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | SETUPKEY  | Setup Key | Integer | INT | 0 | |
| 2 | AGEBY | Age By | Integer | GB_Age_By | 0 | |
| 3 | AGPEREND | Aging Periods End | INT3 | Integer | 3 | |
| 4 | AGPEREND_1 | Aging Periods End[1] | Integer | INT3 | 3 | |
| 5 | AGPEREND_2 | Aging Periods End[2] | Integer | INT3 | 3 | |
| 6 | AGPEREND_3 | Aging Periods End[3] | Integer | INT3 | 3 | |
| 7 | AGPEREND_4 | Aging Periods End[4] | Integer | INT3 | 3 | |
| 8 | AGPEREND_5 | Aging Periods End[5] | Integer | INT3 | 3 | |
| 9 | AGPEREND_6 | Aging Periods End[6] | Integer | INT3 | 3 | |
| 10 | AGPEREND_7 | Aging Periods End[7] | Integer | INT3 | 3 | |
| 11 | AGPERUSD | Aging Periods Used | Integer | INT2 | 2 | |
| 12 | CRLMPSWD | Credit Limit Password | String | STR10_LBU | 10 | |
| 13 | CUSTHPWD | Customer Hold Password | String | STR10_LBU | 10 | |
| 14 | WRTFPSWD | Writeoff Password | String | STR10_LBU | 10 | |
| 15 | WVFCHPWD | Waived Finance Charge Password | String | STR10_LBU | 10 | |
| 16 | PRTHATRB | Print Historical Aged Trial Balance | Boolean | CB_Print_Historical_Aged_Trial_Balance | 0 | |
| 17 | CPDFINCH | Compound Finance Charge | Boolean | CB_Compound_Finance_Charge | 0 | |
| 18 | RMTRKDAV | RM Track Discounts Available | Boolean | CB_Track_Discounts_Available | 0 | |
| 19 | RMPCAIPD | RM Pay Commissions After Invoice Paid | Boolean | CB_Pay_Commissions_After_Invoice_Paid | 0 | |
| 20 | NSFCHDEF | NSF Charge Default | Currency | DLR17_RBS0_UTR$ | 17 | |
| 21 | APLBYDEF | Apply By Default | Integer | GB | 0 | |
| 22 | LDFNCHGD | Last Date Finance Charged | Date | DT_Date | 6 | |
| 23 | LDSTPRTD | Last Date Statements Printed | Date | DT_Date | 6 | |
| 24 | LDBLFAGD | Last Date Balance Forward Aged | Date | DT_Date | 6 | |
| 25 | LDOITAGD | Last Date Open Items Aged | Date | DT_Date | 6 | |
| 26 | LDPTRRMV | Last Date Paid Transactions Removal | Date | DT_Date | 6 | |
| 27 | LSTYECAL | Last Year End Calendar | Date | DT | 8 | |
| 28 | LSTYEFSC | Last Year End Fiscal | Date | DT | 8 | |
| 29 | USRDFPR1 | User Defined Prompt 1 | String | STR15 | 15 | |
| 30 | USRDRPR2 | User Defined Prompt 2 | String | STR15 | 15 | |
| 31 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 32 | SLSCHDID | Sales Schedule ID | String | STR15_LBU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 33 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 34 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
| 35 | SALESCB | Sales CB | Boolean | CB_Sales | 0 | |
| 36 | DISCNTCB | Discount CB | Boolean | CB_Discount | 0 | |
| 37 | FREIGHT | Freight | Boolean | CB_Freight | 0 | |
| 38 | MISC | Misc | Boolean | CB_Misc | 0 | |
| 39 | TAX | Tax | Boolean | CB_Tax | 0 | |
| 40 | RMVDSTTY_1 | RM Valid Dist Types[1] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 41 | RMVDSTTY_2 | RM Valid Dist Types[2] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 42 | RMVDSTTY | RM Valid Dist Types | ML_RM_Valid_Dist_Types | Long Integer | 0 | |
| 43 | RMVDSTTY_3 | RM Valid Dist Types[3] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 44 | RMVDSTTY_4 | RM Valid Dist Types[4] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 45 | RMVDSTTY_5 | RM Valid Dist Types[5] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 46 | RMVDSTTY_6 | RM Valid Dist Types[6] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 47 | RMVDSTTY_7 | RM Valid Dist Types[7] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 48 | RMVDSTTY_8 | RM Valid Dist Types[8] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 49 | RMVDSTTY_9 | RM Valid Dist Types[9] | Long Integer | ML_RM_Valid_Dist_Types | 0 | |
| 50 | LDCMTRNS | Last Date Commissions Transferred | Date | DT_Date | 6 | |
| 51 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
| 52 | RMDFTyp | RM Document Format Type | Integer | DDL_RM_Document_Format_Type | 0 | |
| 53 | DelUPDoc | Delete Unposted Printed Docs | Boolean | CB_Delete_Unposted_Printed_Docs | 0 | |
| 54 | PrntTaxDetDoc | Print Tax Details On Documents | Boolean | CB_Print_Tax_Details | 0 | |
| 55 | RPRNTSTTMNTS | Reprint Statements | Boolean | CB_Reprint_Statements | 0 | |
| 56 | ATAPPLFNNCCHRGSFRST | Auto Apply Finance Charges First | Boolean | CB_Auto_Apply_FC_First | 0 | |
| 57 | EmailStmtStatusRecipient | Email Statements Status Recipient | String | STR80 | 80 | |
| 58 | DateSensitivitySumView | Date Sensitivity Summary View | Integer | DDL_Date_Sensitivity_Summary_View | 0 | |
| 59 | PRNTDCUR | Print Dual Currencies | Boolean | CB_Print_Dual_Currencies | 0 | |
| 60 | AGEUNAPPLDCR | Age Unapplied Credit Amounts | Boolean | CB_AgeUnappliedCreditAmounts | 0 | |
| 61 | WriteoffCreditMemoNumber | Writeoff Credit Memo Number | String | STR20_Document_Number | 20 | |
| 62 | WriteoffDebitMemoNumber | Writeoff Debit Memo Number | String | STR20_Document_Number | 20 | |
| 63 | USRDRPR3 | User Defined Prompt 3 | String | STR15 | 15 | |
| 64 | USRDRPR4 | User Defined Prompt 4 | String | STR15 | 15 | |
| 65 | DisplayOverCreditIcon | Display Over Credit Icon | Boolean | CB_DisplayOverCreditIcon | 0 | |
| 66 | DisplayOverCreditWarning | Display Over Credit Warning | Boolean | CB_DisplayOverCreditWarning | 0 | |