Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM00401
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Key File Group Display Name: Receivables System Keys Files
Physical Name: RM00401
Technical Name: RM_Keys_MSTR
Group Technical Name: RM_System_Control_ID_Keys_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | DOCNUMBR  | Document Number | String | STR20_Document_Number | 20 | |
| 2 | RMDTYPAL | RM Document Type-All | Integer | INT2 | 2 | |
Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments | ||||||
| 3 | DCSTATUS | Document Status | Integer | DDL_Doc_Status | 0 | |
| 4 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 5 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 6 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['RM Key File'].CUSTNMBR AS 'RM Key File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM00401 AS ['RM Key File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Key File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 7 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 8 | DOCDATE | Document Date | Date | DT | 8 | |
| 9 | NEGQTYSOPINV | IsNegQtySOPInvoice | Boolean | Boolean | 0 | |