CM Receipt History temp (CM30500)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: CM Receipt History temp
Physical Name: CM30500
Technical Name: CM_Receipt_History_Temp

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency19
2sRecNum SearchRecord Number StringSTR20String20
3CNTRLTYP SearchControl TypeINT1Integer1
4DEPOSITED SearchDepositedBooleanBoolean0
5MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['CM Receipt History temp'].CHEKBKID AS 'CM Receipt History temp-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CM30500 AS ['CM Receipt History temp']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CM Receipt History temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
8depositnumber SearchDeposit NumberSTR20_Document_NumberString20
9RCPTNMBR SearchReceipt NumberSTR20_Document_NumberString20
10receiptdate SearchReceipt DateDTDate8
11RCPTAMT SearchReceipt AmountDLR19_RBS0_STR$Currency19
12RcpType SearchReceipt TypeDDL_Document_TypeInteger0
13CARDNAME SearchCard NameSTR15_Card_NameString15
14CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CM Receipt History temp'].CURNCYID AS 'CM Receipt History temp-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CM30500 AS ['CM Receipt History temp']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CM Receipt History temp'].CURNCYID = ['Currency Setup'].CURNCYID
15BANKNAME SearchBank NameSTR30String30
16BNKBRNCH SearchBank BranchSTR20String20
17GLPOSTDT SearchGL Posting DateDTDate8
18POSTEDDT SearchPosted DateDATEDate6
19PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['CM Receipt History temp'].PTDUSRID AS 'CM Receipt History temp-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CM30500 AS ['CM Receipt History temp']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['CM Receipt History temp'].PTDUSRID = ['Users Master'].USERID
20CMLinkID SearchCMLinkIDSTR15_LBUString15
21RcvdFrom SearchReceived FromSTR30String30
22DSCRIPTN SearchDescriptionSTR30String30
23VOIDED SearchVoidedCBBoolean0
24VOIDDATE SearchVoid DateDTDate8
25VOIDPDATE SearchVoid GL Posting DateDTDate8
26VOIDDESC SearchVoid DescriptionSTR30String30
27USERDEF1 SearchUser Defined 1STR20String20
28USERDEF2 SearchUser Defined 2STR20String20
29NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['CM Receipt History temp'].CURRNIDX AS 'CM Receipt History temp-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CM30500 AS ['CM Receipt History temp']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CM Receipt History temp'].CURRNIDX = ['Currency Setup'].CURRNIDX
48DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
49RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
50Cash_Account_Index SearchCash Account IndexLI_14Long Integer14
51Realized_GL_Account_Inde SearchRealized GL Account IndexLI_14Long Integer14
52DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
53MCTRXSTT SearchMC Transaction StateINT1Integer1
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)14
55Receiving_MC_Transaction SearchReceiving MC Transaction StateINT1Integer1
56PMNTNMBR SearchPayment NumberSTR20_LBAUString20
57EFTFLAG SearchEFT FlagCB_EFTBoolean0
58HISTINDX SearchHistory IndexINTInteger0

Leave a Reply

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