Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM30202
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Apply Reprint Journal File Group Display Name: Receivables Batch History
Physical Name: RM30202
Technical Name: RM_Applied_Journal_Reprint
Group Technical Name: RM_Batch_History_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 Apply Reprint Journal File'].CUSTNMBR AS 'RM Apply Reprint Journal File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM30202 AS ['RM Apply Reprint Journal File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Apply Reprint Journal File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 2 | APTODCNM | Apply To Document Number | String | STR20_Document_Number | 20 | |
| 3 | APTODCTY | Apply To Document Type | Integer | DDL_Document_Type | 0 | |
| 4 | APPTOAMT | Apply To Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 5 | APFRDCNM | Apply From Document Number | String | STR20_Document_Number | 20 | |
| 6 | APFRDCTY | Apply From Document Type | Integer | INT2 | 2 | |
| 7 | APFRDCDT | Apply From Document Date | Date | DT | 8 | |
| 8 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 9 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 10 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 11 | DATE1 | Date | Date | DT6 | 6 | |
| 12 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 13 | POSTED | Posted | Boolean | True/False | 0 | |
| 14 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 15 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 16 | TAXDTLID | Tax Detail ID | String | STR15_Tax_Detail_ID | 15 | |
Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hideSELECT
['RM Apply Reprint Journal File'].TAXDTLID AS 'RM Apply Reprint Journal File-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
RM30202 AS ['RM Apply Reprint Journal File']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['RM Apply Reprint Journal File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 17 | ORAPTOAM | Originating Apply To Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 20 | ORWROFAM | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 21 | RLGANLOS | Realized Gain-Loss Amount | Currency | DLR19_$S2 | 19 | |