Checkbook Transaction Electronic Funds Transfer (CM20202)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook Transaction Electronic Funds Transfer (CM20202)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Checkbook Transaction Electronic Funds Transfer
Physical Name: CM20202
Technical Name: cmTransactionEFT

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
2SERIES SearchSeriesDDL_SeriesInteger0
3EFTType SearchEFT TypeDDL_EFTTypeInteger0
4EFTFileFormat SearchEFT File FormatDDL_EFTFileFormatInteger0
5TRXDATE SearchTRX DateDT_DateDate6
6Checkbook_Amount SearchCheckbook AmountDLR19_$S2Currency19
7CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Checkbook Transaction Electronic Funds Transfer'].CURNCYID AS 'Checkbook Transaction Electronic Funds Transfer-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CM20202 AS ['Checkbook Transaction Electronic Funds Transfer']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Checkbook Transaction Electronic Funds Transfer'].CURNCYID = ['Currency Setup'].CURNCYID
8ISOCURRC SearchISO Currency CodeSTR3_ISO_Currency_CodeString3
9BACHNUMB SearchBatch NumberSTR15_LBAUString15
10BCHSOURC SearchBatch SourceSTR15String15
11BCHCOMNT SearchBatch CommentSTR60String60
12paidtorcvdfrom SearchPaid ToRcvd FromSTR64String64
13COMMENT1 SearchComment1STR30String30
14SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Checkbook Transaction Electronic Funds Transfer'].SOURCDOC AS 'Checkbook Transaction Electronic Funds Transfer-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       CM20202 AS ['Checkbook Transaction Electronic Funds Transfer']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Checkbook Transaction Electronic Funds Transfer'].SOURCDOC = ['Source Document Master'].SOURCDOC
15VOIDDATE SearchVoid DateDTDate8
16AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString13
17ExecDate SearchExecution DateDTDate8
18RefNum SearchReference NumberSTR40String40
19CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Checkbook Transaction Electronic Funds Transfer'].CHEKBKID AS 'Checkbook Transaction Electronic Funds Transfer-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CM20202 AS ['Checkbook Transaction Electronic Funds Transfer']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Checkbook Transaction Electronic Funds Transfer'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
20EFTBankTypeCB SearchEFT Bank Type CheckbookDDL_EFTBankTypeInteger0
21EFTBankAcctCB SearchEFT Bank Account CheckbookSTR34String34
22EFTBankBranchCB SearchEFT Bank Branch CheckbookSTR15String15
23EFTBankCodeCB SearchEFT Bank Code CheckbookSTR15String15
24EFTBankBranchCodeCB SearchEFT Bank Branch Code CheckbookSTR5_GPAString5
25EFTBankCheckDigitCB SearchEFT Bank Check Digit CheckbookSTR2_LBAString2
26IntlBankAcctNum SearchInternational Bank Account NumberSTR34String34
27TXRGNNUM SearchTax Registration NumberSTR25String25
28USERDEF1 SearchUser Defined 1STR20String20
29USERDEF2 SearchUser Defined 2STR20String20
30CustomerVendor_ID SearchCustomer/Vendor IDSTR15String15
31ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
32EFTBankType SearchEFT Bank TypeDDL_EFTBankTypeInteger0
33EFTBankAcct SearchEFT Bank AccountSTR34String34
34EFTBankBranch SearchEFT Bank BranchSTR15String15
35EFTBankCode SearchEFT Bank CodeSTR15String15
36EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString5
37EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString2
38CustVendIBAN SearchCustomer/Vendor IBANSTR34String34
39SWIFTADDR SearchSwift AddressSTR11String11
40CustVendCountryCode SearchCustomer/Vendor Country CodeCountry CodeString3
41DeliveryCountryCode SearchDelivery Country CodeCountry CodeString3
42BNKCTRCD SearchBank Country CodeCountry CodeString3
43CBANKCD SearchCentral Bank CodeCentral Bank CodeString8
44GIROPostType SearchGIRO Post TypeDDL_GIROPostTypeInteger0
45RegCode1 SearchRegulatory Code 1STR30String30
46RegCode2 SearchRegulatory Code 2STR30String30
47BankInfo1 SearchBank Info 1DDLInteger0
48BankInfo2 SearchBank Info 2DDLInteger0
49BankInfo3 SearchBank Info 3DDLInteger0
50BankInfo4 SearchBank Info 4DDLInteger0
51BankInfo5 SearchBank Info 5DDLInteger0
52BankInfo6 SearchBank Info 6DDLInteger0
53BankInfo7 SearchBank Info 7DDLInteger0
54FedResBankNum SearchFederal Reserve Bank NumberSTR2_LBNString2
55FedResClient SearchFederal Reserve ClientSTR5_LBNString5
56FedResBranch SearchFederal Reserve BranchSTR3_LBNString3
57DEX_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)FinancialCheckbook Transaction Electronic Funds Transfer (CM20202)

Leave a Reply

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