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 NumberCurrencyDLR_Document_Number19
2sRecNum SearchRecord Number StringStringSTR2020
3CNTRLTYP SearchControl TypeIntegerINT11
4DEPOSITED SearchDepositedBooleanBoolean0
5MDFUSRID SearchModified User IDStringSTR1515
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 DateDateDT8
7CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 NumberStringSTR20_Document_Number20
9RCPTNMBR SearchReceipt NumberStringSTR20_Document_Number20
10receiptdate SearchReceipt DateDateDT8
11RCPTAMT SearchReceipt AmountCurrencyDLR19_RBS0_STR$19
12RcpType SearchReceipt TypeIntegerDDL_Document_Type0
13CARDNAME SearchCard NameStringSTR15_Card_Name15
14CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 NameStringSTR3030
16BNKBRNCH SearchBank BranchStringSTR2020
17GLPOSTDT SearchGL Posting DateDateDT8
18POSTEDDT SearchPosted DateDateDATE6
19PTDUSRID SearchPosted User IDStringSTR1515
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 SearchCMLinkIDStringSTR15_LBU15
21RcvdFrom SearchReceived FromStringSTR3030
22DSCRIPTN SearchDescriptionStringSTR3030
23VOIDED SearchVoidedBooleanCB0
24VOIDDATE SearchVoid DateDateDT8
25VOIDPDATE SearchVoid GL Posting DateDateDT8
26VOIDDESC SearchVoid DescriptionStringSTR3030
27USERDEF1 SearchUser Defined 1StringSTR2020
28USERDEF2 SearchUser Defined 2StringSTR2020
29NOTEINDX SearchNote IndexCurrencyDLR1414
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 StatusIntegerINT0
31SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
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 NumberStringSTR2020
33SRCDOCTYP SearchSource Doc TypeIntegerINT0
34AUDITTRAIL SearchAudit Trail CodeStringSTR13_LBAU13
35ORIGAMT SearchOriginating AmountCurrencyDLR19_$S219
36Checkbook_Amount SearchCheckbook AmountCurrencyDLR19_$S219
37RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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 IDStringSTR15_Rate_Type_ID15
39EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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 RateCurrency (Variable)DLR14_Exchange_Rate14
41Receiving_Exchange_Rate SearchReceiving Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
42EXCHDATE SearchExchange DateDateDT_Date6
43TIME1 SearchTimeTimeTM66
44RTCLCMTD SearchRate Calculation MethodIntegerGB0
45RCVGRTCLCMTD SearchReceiving Rate Calc MethodIntegerGB0
46EXPNDATE SearchExpiration DateDateDT_Date6
47CURRNIDX SearchCurrency IndexIntegerINT33
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 CurrencyIntegerDDL_Decimal_Places_Dollars0
49RLGANLOS SearchRealized Gain-Loss AmountCurrencyDLR19_$S219
50Cash_Account_Index SearchCash Account IndexLong IntegerLI_1414
51Realized_GL_Account_Inde SearchRealized GL Account IndexLong IntegerLI_1414
52DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
53MCTRXSTT SearchMC Transaction StateIntegerINT11
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 RateCurrency (Variable)DLR14_Exchange_Rate14
55Receiving_MC_Transaction SearchReceiving MC Transaction StateIntegerINT11
56PMNTNMBR SearchPayment NumberStringSTR20_LBAU20
57EFTFLAG SearchEFT FlagBooleanCB_EFT0
58HISTINDX SearchHistory IndexIntegerINT0

Leave a Reply

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