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 TypeSQL DB LengthKeyable Length
1CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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 TypeDDL_EFTBankTypeInteger20
3AcctHolder SearchAccount HolderSTR20String2220
4EFTBankAcct SearchEFT Bank AccountSTR34String3634
5EFTBankBranch SearchEFT Bank BranchSTR15String1615
6EFTBankCode SearchEFT Bank CodeSTR15String1615
7EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString65
8EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString42
9IntlBankAcctNum SearchInternational Bank Account NumberSTR34String3634
10TXRGNNUM SearchTax Registration NumberSTR25String2625
11DomPmtsFile SearchDomestic Payments FileSTR255String256255
12ForeignPmtsFile SearchForeign Payments FileSTR255String256255
13DomDirDbtCollectFile SearchDomestic Direct Debit Collections FileSTR255String256255
14DomDirDbtRefundFile SearchDomestic Direct Debit Refunds FileSTR255String256255
15BankIDNum SearchBank Identification NumberSTR30String3230
16BankInfo1 SearchBank Info 1DDLInteger20
17BankInfo2 SearchBank Info 2DDLInteger20
18BankInfo3 SearchBank Info 3DDLInteger20
19BankInfo4 SearchBank Info 4DDLInteger20
20BankInfo5 SearchBank Info 5DDLInteger20
21BankInfo6 SearchBank Info 6DDLInteger20
22FedResBankNum SearchFederal Reserve Bank NumberSTR2_LBNString42
23FedResClient SearchFederal Reserve ClientSTR5_LBNString65
24FedResBranch SearchFederal Reserve BranchSTR3_LBNString43
25EFTTransitRoutingNo SearchEFT Transit Routing NumberSTR10_LBNString1210
26EFTPreTransitDigit SearchEFT Pre Transit DigitSTR1_LBNString21
27EFTPriorityCode SearchEFT Priority CodeSTR2_LBNString42
28EFTBlockingFactor SearchEFT Blocking FactorSTR2_LBNString42
29EFTFormatCode SearchEFT Format CodeSTR1_LBUString21
30EFTReference SearchEFT ReferenceSTR8_LBAUString108
31EFTCompanyID SearchEFT Company IDSTR10_LBAUString1210
32EFTBankCoName SearchEFT Bank Company NameSTR23_LBAUString2423
33EFTSmallCoName SearchEFT Small Company NameSTR16_LBAUString1816
34EFTServiceClassCode SearchEFT Service Class CodeINT3Integer23
35EFTCommunicationType SearchEFT Communication TypeEFT_Communication_TypeInteger20
36EFTCommunicationFile SearchEFT Communication FileSTR80String8280
37EFTUseOriginatingCur SearchEFT Use Originating CurrencyEFT_CB_Use_Originating_CurrencyBoolean20
38CCode SearchCountry CodeSTR6_VATString86
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 CodeSTR3_ISO_Currency_CodeString43
40EFTDataCentreCode SearchEFT Data Centre CodeLONG5_R00ULong Integer45
41EFTNextFileNo SearchEFT Next File NumberINT4Integer24
42EFTPMServClassAll SearchEFT PM ServClass AllSTR15_EFTFormatIDString1615
43EFTPMServClassBus SearchEFT PM ServClass BusinessSTR15_EFTFormatIDString1615
44EFTPMServClassCorp SearchEFT PM ServClass CorporateSTR15_EFTFormatIDString1615
45EFTPMServClassForeign SearchEFT PM ServClass ForeignSTR15_EFTFormatIDString1615
46EFTPMServClassPersonal SearchEFT PM ServClass PersonalSTR15_EFTFormatIDString1615
47EFTPMNextNumber SearchEFT PM Next NumberEFT_NumberString2220
48EFTPMPrenoteRequired SearchEFT PM Prenote RequiredEFT_CB_PM_Prenote_RequiredBoolean20
49EFTPMPrenoteGracePeriod SearchEFT PM Prenote Grace PeriodINT3Integer23
50EFTPMPrenoteFile SearchEFT PM Prenote FileSTR255String256255
51EFTPMReconcile SearchEFT PM ReconcileEFT_CB_PM_ReconcileBoolean20
52EFTPMTrxNumbers SearchEFT PM Trx NumbersGBInteger20
53EFTRMBankFormat SearchEFT RM Bank FormatEFT_DDL_RM_Bank_ForamtInteger20
54EFTRMServClassAll SearchEFT RM ServClass AllSTR15_EFTFormatIDString1615
55EFTRMServClassBus SearchEFT RM ServClass BusinessSTR15_EFTFormatIDString1615
56EFTRMServiceClassCorp SearchEFT RM ServClass CorporateSTR15_EFTFormatIDString1615
57EFTRMServClassForeign SearchEFT RM ServClass ForeignSTR15_EFTFormatIDString1615
58EFTRMServClassPersonal SearchEFT RM ServClass PersonalSTR15_EFTFormatIDString1615
59EFTRMNextNumber SearchEFT RM Next NumberEFT_NumberString2220
60EFTRMPrenoteRequired SearchEFT RM Prenote RequiredEFT_CB_RM_Prenote_RequiredBoolean20
61EFTRMPrenoteGracePeriod SearchEFT RM Prenote Grace PeriodINT3Integer23
62EFTRMPrenoteFile SearchEFT RM Prenote FileSTR255String256255
63EFTRMReconcile SearchEFT RM ReconcileEFT_CB_RM_ReconcileBoolean20
64RMUSEEFTNUM SearchRM Use EFT NumberingCB_RM_Use_EFT_NumberingBoolean20
65EFTRMPostBankRecSummary SearchEFT RM Post to Bank Rec in SummaryCB_Post_Bank_Rec_SummaryBoolean20
66EFTPMPostBankRecSummary SearchEFT PM Post to Bank Rec in SummaryCB_Post_Bank_Rec_SummaryBoolean20
67DEX_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 Electronic Funds Transfer Master (CM00101)

Leave a Reply

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