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 NumberStringSTR20_Document_Number20
2SERIES SearchSeriesIntegerDDL_Series0
3EFTType SearchEFT TypeIntegerDDL_EFTType0
4EFTFileFormat SearchEFT File FormatIntegerDDL_EFTFileFormat0
5TRXDATE SearchTRX DateDateDT_Date6
6Checkbook_Amount SearchCheckbook AmountCurrencyDLR19_$S219
7CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 CodeStringSTR3_ISO_Currency_Code3
9BACHNUMB SearchBatch NumberStringSTR15_LBAU15
10BCHSOURC SearchBatch SourceStringSTR1515
11BCHCOMNT SearchBatch CommentStringSTR6060
12paidtorcvdfrom SearchPaid ToRcvd FromStringSTR6464
13COMMENT1 SearchComment1StringSTR3030
14SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
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 DateDateDT8
16AUDITTRAIL SearchAudit Trail CodeStringSTR13_LBAU13
17ExecDate SearchExecution DateDateDT8
18RefNum SearchReference NumberStringSTR4040
19CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 CheckbookIntegerDDL_EFTBankType0
21EFTBankAcctCB SearchEFT Bank Account CheckbookStringSTR3434
22EFTBankBranchCB SearchEFT Bank Branch CheckbookStringSTR1515
23EFTBankCodeCB SearchEFT Bank Code CheckbookStringSTR1515
24EFTBankBranchCodeCB SearchEFT Bank Branch Code CheckbookStringSTR5_GPA5
25EFTBankCheckDigitCB SearchEFT Bank Check Digit CheckbookStringSTR2_LBA2
26IntlBankAcctNum SearchInternational Bank Account NumberStringSTR3434
27TXRGNNUM SearchTax Registration NumberStringSTR2525
28USERDEF1 SearchUser Defined 1StringSTR2020
29USERDEF2 SearchUser Defined 2StringSTR2020
30CustomerVendor_ID SearchCustomer/Vendor IDStringSTR1515
31ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
32EFTBankType SearchEFT Bank TypeIntegerDDL_EFTBankType0
33EFTBankAcct SearchEFT Bank AccountStringSTR3434
34EFTBankBranch SearchEFT Bank BranchStringSTR1515
35EFTBankCode SearchEFT Bank CodeStringSTR1515
36EFTBankBranchCode SearchEFT Bank Branch CodeStringSTR5_GPA5
37EFTBankCheckDigit SearchEFT Bank Check DigitStringSTR2_LBA2
38CustVendIBAN SearchCustomer/Vendor IBANStringSTR3434
39SWIFTADDR SearchSwift AddressStringSTR1111
40CustVendCountryCode SearchCustomer/Vendor Country CodeStringCountry Code3
41DeliveryCountryCode SearchDelivery Country CodeStringCountry Code3
42BNKCTRCD SearchBank Country CodeStringCountry Code3
43CBANKCD SearchCentral Bank CodeStringCentral Bank Code8
44GIROPostType SearchGIRO Post TypeIntegerDDL_GIROPostType0
45RegCode1 SearchRegulatory Code 1StringSTR3030
46RegCode2 SearchRegulatory Code 2StringSTR3030
47BankInfo1 SearchBank Info 1IntegerDDL0
48BankInfo2 SearchBank Info 2IntegerDDL0
49BankInfo3 SearchBank Info 3IntegerDDL0
50BankInfo4 SearchBank Info 4IntegerDDL0
51BankInfo5 SearchBank Info 5IntegerDDL0
52BankInfo6 SearchBank Info 6IntegerDDL0
53BankInfo7 SearchBank Info 7IntegerDDL0
54FedResBankNum SearchFederal Reserve Bank NumberStringSTR2_LBN2
55FedResClient SearchFederal Reserve ClientStringSTR5_LBN5
56FedResBranch SearchFederal Reserve BranchStringSTR3_LBN3
azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook Transaction Electronic Funds Transfer (CM20202)

Leave a Reply

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