Checkbook Electronic Funds Transfer Master (CM00101)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook Electronic Funds Transfer Master (CM00101)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Checkbook Electronic Funds Transfer Master
Physical Name: CM00101
Technical Name: cmCheckbookEFT

Group Display Name: Checkbook Master
Group Technical Name: Checkbook Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Checkbook Electronic Funds Transfer Master'].CHEKBKID AS 'Checkbook Electronic Funds Transfer Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CM00101 AS ['Checkbook Electronic Funds Transfer Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Checkbook Electronic Funds Transfer Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2EFTBankType SearchEFT Bank TypeIntegerDDL_EFTBankType0
3AcctHolder SearchAccount HolderStringSTR2020
4EFTBankAcct SearchEFT Bank AccountStringSTR3434
5EFTBankBranch SearchEFT Bank BranchStringSTR1515
6EFTBankCode SearchEFT Bank CodeStringSTR1515
7EFTBankBranchCode SearchEFT Bank Branch CodeStringSTR5_GPA5
8EFTBankCheckDigit SearchEFT Bank Check DigitStringSTR2_LBA2
9IntlBankAcctNum SearchInternational Bank Account NumberStringSTR3434
10TXRGNNUM SearchTax Registration NumberStringSTR2525
11DomPmtsFile SearchDomestic Payments FileStringSTR255255
12ForeignPmtsFile SearchForeign Payments FileStringSTR255255
13DomDirDbtCollectFile SearchDomestic Direct Debit Collections FileStringSTR255255
14DomDirDbtRefundFile SearchDomestic Direct Debit Refunds FileStringSTR255255
15BankIDNum SearchBank Identification NumberStringSTR3030
16BankInfo1 SearchBank Info 1IntegerDDL0
17BankInfo2 SearchBank Info 2IntegerDDL0
18BankInfo3 SearchBank Info 3IntegerDDL0
19BankInfo4 SearchBank Info 4IntegerDDL0
20BankInfo5 SearchBank Info 5IntegerDDL0
21BankInfo6 SearchBank Info 6IntegerDDL0
22FedResBankNum SearchFederal Reserve Bank NumberStringSTR2_LBN2
23FedResClient SearchFederal Reserve ClientStringSTR5_LBN5
24FedResBranch SearchFederal Reserve BranchStringSTR3_LBN3
25EFTTransitRoutingNo SearchEFT Transit Routing NumberStringSTR10_LBN10
26EFTPreTransitDigit SearchEFT Pre Transit DigitStringSTR1_LBN1
27EFTPriorityCode SearchEFT Priority CodeStringSTR2_LBN2
28EFTBlockingFactor SearchEFT Blocking FactorStringSTR2_LBN2
29EFTFormatCode SearchEFT Format CodeStringSTR1_LBU1
30EFTReference SearchEFT ReferenceStringSTR8_LBAU8
31EFTCompanyID SearchEFT Company IDStringSTR10_LBAU10
32EFTBankCoName SearchEFT Bank Company NameStringSTR23_LBAU23
33EFTSmallCoName SearchEFT Small Company NameStringSTR16_LBAU16
34EFTServiceClassCode SearchEFT Service Class CodeIntegerINT33
35EFTCommunicationType SearchEFT Communication TypeIntegerEFT_Communication_Type0
36EFTCommunicationFile SearchEFT Communication FileStringSTR8080
37EFTUseOriginatingCur SearchEFT Use Originating CurrencyBooleanEFT_CB_Use_Originating_Currency0
38CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Checkbook Electronic Funds Transfer Master'].CCode AS 'Checkbook Electronic Funds Transfer Master-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       CM00101 AS ['Checkbook Electronic Funds Transfer Master']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Checkbook Electronic Funds Transfer Master'].CCode = ['VAT Country Code MSTR'].CCode
39ISOCURRC SearchISO Currency CodeStringSTR3_ISO_Currency_Code3
40EFTDataCentreCode SearchEFT Data Centre CodeLong IntegerLONG5_R00U5
41EFTNextFileNo SearchEFT Next File NumberIntegerINT44
42EFTPMServClassAll SearchEFT PM ServClass AllStringSTR15_EFTFormatID15
43EFTPMServClassBus SearchEFT PM ServClass BusinessStringSTR15_EFTFormatID15
44EFTPMServClassCorp SearchEFT PM ServClass CorporateStringSTR15_EFTFormatID15
45EFTPMServClassForeign SearchEFT PM ServClass ForeignStringSTR15_EFTFormatID15
46EFTPMServClassPersonal SearchEFT PM ServClass PersonalStringSTR15_EFTFormatID15
47EFTPMNextNumber SearchEFT PM Next NumberStringEFT_Number20
48EFTPMPrenoteRequired SearchEFT PM Prenote RequiredBooleanEFT_CB_PM_Prenote_Required0
49EFTPMPrenoteGracePeriod SearchEFT PM Prenote Grace PeriodIntegerINT33
50EFTPMPrenoteFile SearchEFT PM Prenote FileStringSTR255255
51EFTPMReconcile SearchEFT PM ReconcileBooleanEFT_CB_PM_Reconcile0
52EFTPMTrxNumbers SearchEFT PM Trx NumbersIntegerGB0
53EFTRMBankFormat SearchEFT RM Bank FormatIntegerEFT_DDL_RM_Bank_Foramt0
54EFTRMServClassAll SearchEFT RM ServClass AllStringSTR15_EFTFormatID15
55EFTRMServClassBus SearchEFT RM ServClass BusinessStringSTR15_EFTFormatID15
56EFTRMServiceClassCorp SearchEFT RM ServClass CorporateStringSTR15_EFTFormatID15
57EFTRMServClassForeign SearchEFT RM ServClass ForeignStringSTR15_EFTFormatID15
58EFTRMServClassPersonal SearchEFT RM ServClass PersonalStringSTR15_EFTFormatID15
59EFTRMNextNumber SearchEFT RM Next NumberStringEFT_Number20
60EFTRMPrenoteRequired SearchEFT RM Prenote RequiredBooleanEFT_CB_RM_Prenote_Required0
61EFTRMPrenoteGracePeriod SearchEFT RM Prenote Grace PeriodIntegerINT33
62EFTRMPrenoteFile SearchEFT RM Prenote FileStringSTR255255
63EFTRMReconcile SearchEFT RM ReconcileBooleanEFT_CB_RM_Reconcile0
64RMUSEEFTNUM SearchRM Use EFT NumberingBooleanCB_RM_Use_EFT_Numbering0
65EFTRMPostBankRecSummary SearchEFT RM Post to Bank Rec in SummaryBooleanCB_Post_Bank_Rec_Summary0
66EFTPMPostBankRecSummary SearchEFT PM Post to Bank Rec in SummaryBooleanCB_Post_Bank_Rec_Summary0
azurecurveProductsMicrosoft Dynamics GP (0)FinancialCheckbook Electronic Funds Transfer Master (CM00101)

Leave a Reply

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