RM Apply Reprint Journal File (RM30202)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Apply Reprint Journal File (RM30202)

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
Physical Name: RM30202
Technical Name: RM_Applied_Journal_Reprint

Group Display Name: Receivables Batch History
Group Technical Name: RM_Batch_History_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['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
2APTODCNM SearchApply To Document NumberSTR20_Document_NumberString2220
3APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
4APPTOAMT SearchApply To AmountDLR17_RBS0_UTR$Currency1017
5APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
6APFRDCTY SearchApply From Document TypeINT2Integer22
7APFRDCDT SearchApply From Document DateDTDate48
8TRXSORCE SearchTRX SourceSTR13String1413
9DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
10WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
11DATE1 SearchDateDT6Date46
12GLPOSTDT SearchGL Posting DateDTDate48
13POSTED SearchPostedTrue/FalseBoolean20
14GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
15PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
16TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['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
17ORAPTOAM SearchOriginating Apply To AmountDLR17_RBS0_UTR$Currency1017
18ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
19ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
20ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
21RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
22DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Apply Reprint Journal File (RM30202)

Leave a Reply

Your email address will not be published. Required fields are marked *