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 TypeSQL DB LengthKeyable Length
1DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
2SERIES SearchSeriesDDL_SeriesInteger20
3EFTType SearchEFT TypeDDL_EFTTypeInteger20
4EFTFileFormat SearchEFT File FormatDDL_EFTFileFormatInteger20
5TRXDATE SearchTRX DateDT_DateDate46
6Checkbook_Amount SearchCheckbook AmountDLR19_$S2Currency1019
7CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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_CodeString43
9BACHNUMB SearchBatch NumberSTR15_LBAUString1615
10BCHSOURC SearchBatch SourceSTR15String1615
11BCHCOMNT SearchBatch CommentSTR60String6260
12paidtorcvdfrom SearchPaid ToRcvd FromSTR64String6664
13COMMENT1 SearchComment1STR30String3230
14SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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 DateDTDate48
16AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString1413
17ExecDate SearchExecution DateDTDate48
18RefNum SearchReference NumberSTR40String4240
19CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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_EFTBankTypeInteger20
21EFTBankAcctCB SearchEFT Bank Account CheckbookSTR34String3634
22EFTBankBranchCB SearchEFT Bank Branch CheckbookSTR15String1615
23EFTBankCodeCB SearchEFT Bank Code CheckbookSTR15String1615
24EFTBankBranchCodeCB SearchEFT Bank Branch Code CheckbookSTR5_GPAString65
25EFTBankCheckDigitCB SearchEFT Bank Check Digit CheckbookSTR2_LBAString42
26IntlBankAcctNum SearchInternational Bank Account NumberSTR34String3634
27TXRGNNUM SearchTax Registration NumberSTR25String2625
28USERDEF1 SearchUser Defined 1STR20String2220
29USERDEF2 SearchUser Defined 2STR20String2220
30CustomerVendor_ID SearchCustomer/Vendor IDSTR15String1615
31ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
32EFTBankType SearchEFT Bank TypeDDL_EFTBankTypeInteger20
33EFTBankAcct SearchEFT Bank AccountSTR34String3634
34EFTBankBranch SearchEFT Bank BranchSTR15String1615
35EFTBankCode SearchEFT Bank CodeSTR15String1615
36EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString65
37EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString42
38CustVendIBAN SearchCustomer/Vendor IBANSTR34String3634
39SWIFTADDR SearchSwift AddressSTR11String1211
40CustVendCountryCode SearchCustomer/Vendor Country CodeCountry CodeString43
41DeliveryCountryCode SearchDelivery Country CodeCountry CodeString43
42BNKCTRCD SearchBank Country CodeCountry CodeString43
43CBANKCD SearchCentral Bank CodeCentral Bank CodeString108
44GIROPostType SearchGIRO Post TypeDDL_GIROPostTypeInteger20
45RegCode1 SearchRegulatory Code 1STR30String3230
46RegCode2 SearchRegulatory Code 2STR30String3230
47BankInfo1 SearchBank Info 1DDLInteger20
48BankInfo2 SearchBank Info 2DDLInteger20
49BankInfo3 SearchBank Info 3DDLInteger20
50BankInfo4 SearchBank Info 4DDLInteger20
51BankInfo5 SearchBank Info 5DDLInteger20
52BankInfo6 SearchBank Info 6DDLInteger20
53BankInfo7 SearchBank Info 7DDLInteger20
54FedResBankNum SearchFederal Reserve Bank NumberSTR2_LBNString42
55FedResClient SearchFederal Reserve ClientSTR5_LBNString65
56FedResBranch SearchFederal Reserve BranchSTR3_LBNString43
57DEX_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.

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

Leave a Reply

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