Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM20101
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Open File Group Display Name: Receivables Open Transaction Files
Physical Name: RM20101
Technical Name: RM_OPEN
Group Technical Name: RM_Open_Transaction_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CUSTNMBR  | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['RM Open File'].CUSTNMBR AS 'RM Open File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 2 | CPRCSTNM | Corporate Customer Number | String | STR15_RM_Customer_Number | 15 | |
| 3 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 4 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 5 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 6 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 7 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 8 | 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 | ||||||
| 9 | CSHRCTYP | Cash Receipt Type | Integer | GB | 0 | |
| 10 | CBKIDCRD | Checkbook ID Credit Card | String | STR15_Checkbook_ID | 15 | |
| 11 | CBKIDCSH | Checkbook ID Cash | String | STR15_Checkbook_ID | 15 | |
| 12 | CBKIDCHK | Checkbook ID Check | String | STR15_Checkbook_ID | 15 | |
| 13 | DUEDATE | Due Date | Date | DT | 8 | |
| 14 | DOCDATE | Document Date | Date | DT | 8 | |
| 15 | POSTDATE | Post Date | Date | DT_Date | 6 | |
| 16 | PSTUSRID | Post User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Open File'].PSTUSRID AS 'RM Open File-Post User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open File'].PSTUSRID = ['Users Master'].USERID | ||||||
| 17 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 18 | LSTEDTDT | Last Edit Date | Date | DT_Date | 6 | |
| 19 | LSTUSRED | Last User to Edit | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Open File'].LSTUSRED AS 'RM Open File-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open File'].LSTUSRED = ['Users Master'].USERID | ||||||
| 20 | ORTRXAMT | Original Trx Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 21 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 22 | SLSAMNT | Sales Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 23 | COSTAMNT | Cost Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 24 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 25 | MISCAMNT | Misc Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 26 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 27 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 28 | CASHAMNT | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 29 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | DISAVAMT | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | DISCRTND | Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
| 33 | DISCDATE | Discount Date | Date | DT | 8 | |
| 34 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 35 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 36 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 37 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
| 38 | CSPORNBR | Customer Purchase Order Number | String | Document_Number | 20 | |
| 39 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['RM Open File'].SLPRSNID AS 'RM Open File-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Open File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 40 | SLSTERCD | Sales Territory Code | String | STR15 | 15 | |
| 41 | DINVPDOF | Date Invoice Paid Off | Date | DT | 8 | |
| 42 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 44 | DELETE1 | Delete | Boolean | YN | 0 | |
| 45 | AGNGBUKT | Aging Bucket | Integer | INT1_U0 | 1 | |
| 46 | VOIDSTTS | Void Status | Integer | INT | 0 | |
| 47 | VOIDDATE | Void Date | Date | DT | 8 | |
| 48 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].TAXSCHID AS 'RM Open File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 49 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['RM Open File'].CURNCYID AS 'RM Open File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Open File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 50 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['RM Open File'].PYMTRMID AS 'RM Open File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Open File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 51 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['RM Open File'].SHIPMTHD AS 'RM Open File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Open File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 52 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 53 | SLSCHDID | Sales Schedule ID | String | STR15_LBU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].SLSCHDID AS 'RM Open File-Sales Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 54 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].FRTSCHID AS 'RM Open File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 55 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].MSCSCHID AS 'RM Open File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 56 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['RM Open File'].NOTEINDX AS 'RM Open File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Open File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 57 | Tax_Date | Tax Date | Date | DT | 8 | |
| 58 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 59 | SALEDATE | Sale Date | Date | DT | 8 | |
| 60 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 61 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 62 | Electronic | Electronic | Boolean | CB_Electronic | 0 | |
| 63 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
| 64 | BKTSLSAM | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 65 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 66 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 67 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 68 | Factoring | Factoring | Boolean | boolean | 0 | |
| 69 | DIRECTDEBIT | Direct Debit | Boolean | CB_DirectDebit | 0 | |
| 70 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
| 71 | EFTFLAG | EFT Flag | Boolean | CB_EFT | 0 | |