CM Receipt History (CM30300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM30300

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: CM Receipt History
Physical Name: CM30300
Technical Name: CM_Receipt_History

Group Display Name: CM Transaction
Group Technical Name: CM Transaction

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency1019
2sRecNum SearchRecord Number StringSTR20String2220
3CNTRLTYP SearchControl TypeINT1Integer21
4DEPOSITED SearchDepositedBooleanBoolean20
5MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['CM Receipt History'].MDFUSRID AS 'CM Receipt History-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['CM Receipt History'].MDFUSRID = ['Users Master'].USERID
6MODIFDT SearchModified DateDTDate48
7CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CM Receipt History'].CHEKBKID AS 'CM Receipt History-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CM Receipt History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
8depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
9RCPTNMBR SearchReceipt NumberSTR20_Document_NumberString2220
10receiptdate SearchReceipt DateDTDate48
11RCPTAMT SearchReceipt AmountDLR19_RBS0_STR$Currency1019
12RcpType SearchReceipt TypeDDL_Document_TypeInteger20
13CARDNAME SearchCard NameSTR15_Card_NameString1615
14CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CM Receipt History'].CURNCYID AS 'CM Receipt History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CM Receipt History'].CURNCYID = ['Currency Setup'].CURNCYID
15BANKNAME SearchBank NameSTR30String3230
16BNKBRNCH SearchBank BranchSTR20String2220
17GLPOSTDT SearchGL Posting DateDTDate48
18POSTEDDT SearchPosted DateDATEDate46
19PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['CM Receipt History'].PTDUSRID AS 'CM Receipt History-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['CM Receipt History'].PTDUSRID = ['Users Master'].USERID
20CMLinkID SearchCMLinkIDSTR15_LBUString1615
21RcvdFrom SearchReceived FromSTR30String3230
22DSCRIPTN SearchDescriptionSTR30String3230
23VOIDED SearchVoidedCBBoolean20
24VOIDDATE SearchVoid DateDTDate48
25VOIDPDATE SearchVoid GL Posting DateDTDate48
26VOIDDESC SearchVoid DescriptionSTR30String3230
27USERDEF1 SearchUser Defined 1STR20String2220
28USERDEF2 SearchUser Defined 2STR20String2220
29NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['CM Receipt History'].NOTEINDX AS 'CM Receipt History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['CM Receipt History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
30RCRDSTTS SearchRecord StatusINTInteger20
31SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['CM Receipt History'].SOURCDOC AS 'CM Receipt History-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['CM Receipt History'].SOURCDOC = ['Source Document Master'].SOURCDOC
32SRCDOCNUM SearchSource Doc NumberSTR20String2220
33SRCDOCTYP SearchSource Doc TypeINTInteger20
34AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString1413
35ORIGAMT SearchOriginating AmountDLR19_$S2Currency1019
36Checkbook_Amount SearchCheckbook AmountDLR19_$S2Currency1019
37RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['CM Receipt History'].RATETPID AS 'CM Receipt History-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['CM Receipt History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
38RCVGRATETPID SearchReceiving Rate Type IDSTR15_Rate_Type_IDString1615
39EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['CM Receipt History'].EXGTBLID AS 'CM Receipt History-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['CM Receipt History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
40XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
41Receiving_Exchange_Rate SearchReceiving Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
42EXCHDATE SearchExchange DateDT_DateDate46
43TIME1 SearchTimeTM6Time46
44RTCLCMTD SearchRate Calculation MethodGBInteger20
45RCVGRTCLCMTD SearchReceiving Rate Calc MethodGBInteger20
46EXPNDATE SearchExpiration DateDT_DateDate46
47CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CM Receipt History'].CURRNIDX AS 'CM Receipt History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CM30300 AS ['CM Receipt History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CM Receipt History'].CURRNIDX = ['Currency Setup'].CURRNIDX
48DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
49RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
50Cash_Account_Index SearchCash Account IndexLI_14Long Integer414
51Realized_GL_Account_Inde SearchRealized GL Account IndexLI_14Long Integer414
52DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
53MCTRXSTT SearchMC Transaction StateINT1Integer21
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.
54Receiving_DenomEXRate SearchReceiving Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
55Receiving_MC_Transaction SearchReceiving MC Transaction StateINT1Integer21
56PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
57EFTFLAG SearchEFT FlagCB_EFTBoolean20
58DEX_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.

Leave a Reply

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