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 TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NumberString20
3APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
4APPTOAMT SearchApply To AmountDLR17_RBS0_UTR$Currency17
5APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString20
6APFRDCTY SearchApply From Document TypeINT2Integer2
7APFRDCDT SearchApply From Document DateDTDate8
8TRXSORCE SearchTRX SourceSTR13String13
9DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
10WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
11DATE1 SearchDateDT6Date6
12GLPOSTDT SearchGL Posting DateDTDate8
13POSTED SearchPostedTrue/FalseBoolean0
14GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
15PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
16TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
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$Currency17
18ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
19ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
20ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
21RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
22DEX_ROW_ID Searchintint10

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 *