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 IDSTR15_Checkbook_IDString15
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_EFTBankTypeInteger0
3AcctHolder SearchAccount HolderSTR20String20
4EFTBankAcct SearchEFT Bank AccountSTR34String34
5EFTBankBranch SearchEFT Bank BranchSTR15String15
6EFTBankCode SearchEFT Bank CodeSTR15String15
7EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString5
8EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString2
9IntlBankAcctNum SearchInternational Bank Account NumberSTR34String34
10TXRGNNUM SearchTax Registration NumberSTR25String25
11DomPmtsFile SearchDomestic Payments FileSTR255String255
12ForeignPmtsFile SearchForeign Payments FileSTR255String255
13DomDirDbtCollectFile SearchDomestic Direct Debit Collections FileSTR255String255
14DomDirDbtRefundFile SearchDomestic Direct Debit Refunds FileSTR255String255
15BankIDNum SearchBank Identification NumberSTR30String30
16BankInfo1 SearchBank Info 1DDLInteger0
17BankInfo2 SearchBank Info 2DDLInteger0
18BankInfo3 SearchBank Info 3DDLInteger0
19BankInfo4 SearchBank Info 4DDLInteger0
20BankInfo5 SearchBank Info 5DDLInteger0
21BankInfo6 SearchBank Info 6DDLInteger0
22FedResBankNum SearchFederal Reserve Bank NumberSTR2_LBNString2
23FedResClient SearchFederal Reserve ClientSTR5_LBNString5
24FedResBranch SearchFederal Reserve BranchSTR3_LBNString3
25EFTTransitRoutingNo SearchEFT Transit Routing NumberSTR10_LBNString10
26EFTPreTransitDigit SearchEFT Pre Transit DigitSTR1_LBNString1
27EFTPriorityCode SearchEFT Priority CodeSTR2_LBNString2
28EFTBlockingFactor SearchEFT Blocking FactorSTR2_LBNString2
29EFTFormatCode SearchEFT Format CodeSTR1_LBUString1
30EFTReference SearchEFT ReferenceSTR8_LBAUString8
31EFTCompanyID SearchEFT Company IDSTR10_LBAUString10
32EFTBankCoName SearchEFT Bank Company NameSTR23_LBAUString23
33EFTSmallCoName SearchEFT Small Company NameSTR16_LBAUString16
34EFTServiceClassCode SearchEFT Service Class CodeINT3Integer3
35EFTCommunicationType SearchEFT Communication TypeEFT_Communication_TypeInteger0
36EFTCommunicationFile SearchEFT Communication FileSTR80String80
37EFTUseOriginatingCur SearchEFT Use Originating CurrencyEFT_CB_Use_Originating_CurrencyBoolean0
38CCode SearchCountry CodeSTR6_VATString6
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_CodeString3
40EFTDataCentreCode SearchEFT Data Centre CodeLONG5_R00ULong Integer5
41EFTNextFileNo SearchEFT Next File NumberINT4Integer4
42EFTPMServClassAll SearchEFT PM ServClass AllSTR15_EFTFormatIDString15
43EFTPMServClassBus SearchEFT PM ServClass BusinessSTR15_EFTFormatIDString15
44EFTPMServClassCorp SearchEFT PM ServClass CorporateSTR15_EFTFormatIDString15
45EFTPMServClassForeign SearchEFT PM ServClass ForeignSTR15_EFTFormatIDString15
46EFTPMServClassPersonal SearchEFT PM ServClass PersonalSTR15_EFTFormatIDString15
47EFTPMNextNumber SearchEFT PM Next NumberEFT_NumberString20
48EFTPMPrenoteRequired SearchEFT PM Prenote RequiredEFT_CB_PM_Prenote_RequiredBoolean0
49EFTPMPrenoteGracePeriod SearchEFT PM Prenote Grace PeriodINT3Integer3
50EFTPMPrenoteFile SearchEFT PM Prenote FileSTR255String255
51EFTPMReconcile SearchEFT PM ReconcileEFT_CB_PM_ReconcileBoolean0
52EFTPMTrxNumbers SearchEFT PM Trx NumbersGBInteger0
53EFTRMBankFormat SearchEFT RM Bank FormatEFT_DDL_RM_Bank_ForamtInteger0
54EFTRMServClassAll SearchEFT RM ServClass AllSTR15_EFTFormatIDString15
55EFTRMServClassBus SearchEFT RM ServClass BusinessSTR15_EFTFormatIDString15
56EFTRMServiceClassCorp SearchEFT RM ServClass CorporateSTR15_EFTFormatIDString15
57EFTRMServClassForeign SearchEFT RM ServClass ForeignSTR15_EFTFormatIDString15
58EFTRMServClassPersonal SearchEFT RM ServClass PersonalSTR15_EFTFormatIDString15
59EFTRMNextNumber SearchEFT RM Next NumberEFT_NumberString20
60EFTRMPrenoteRequired SearchEFT RM Prenote RequiredEFT_CB_RM_Prenote_RequiredBoolean0
61EFTRMPrenoteGracePeriod SearchEFT RM Prenote Grace PeriodINT3Integer3
62EFTRMPrenoteFile SearchEFT RM Prenote FileSTR255String255
63EFTRMReconcile SearchEFT RM ReconcileEFT_CB_RM_ReconcileBoolean0
64RMUSEEFTNUM SearchRM Use EFT NumberingCB_RM_Use_EFT_NumberingBoolean0
65EFTRMPostBankRecSummary SearchEFT RM Post to Bank Rec in SummaryCB_Post_Bank_Rec_SummaryBoolean0
66EFTPMPostBankRecSummary SearchEFT PM Post to Bank Rec in SummaryCB_Post_Bank_Rec_SummaryBoolean0
67DEX_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 Electronic Funds Transfer Master (CM00101)

Leave a Reply

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