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 Group Display Name: Checkbook Master
Physical Name: CM00101
Technical Name: cmCheckbookEFT
Group Technical Name: Checkbook Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CHEKBKID ![]() | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
2 | EFTBankType ![]() | EFT Bank Type | Integer | DDL_EFTBankType | 0 | |
3 | AcctHolder ![]() | Account Holder | String | STR20 | 20 | |
4 | EFTBankAcct ![]() | EFT Bank Account | String | STR34 | 34 | |
5 | EFTBankBranch ![]() | EFT Bank Branch | String | STR15 | 15 | |
6 | EFTBankCode ![]() | EFT Bank Code | String | STR15 | 15 | |
7 | EFTBankBranchCode ![]() | EFT Bank Branch Code | String | STR5_GPA | 5 | |
8 | EFTBankCheckDigit ![]() | EFT Bank Check Digit | String | STR2_LBA | 2 | |
9 | IntlBankAcctNum ![]() | International Bank Account Number | String | STR34 | 34 | |
10 | TXRGNNUM ![]() | Tax Registration Number | String | STR25 | 25 | |
11 | DomPmtsFile ![]() | Domestic Payments File | String | STR255 | 255 | |
12 | ForeignPmtsFile ![]() | Foreign Payments File | String | STR255 | 255 | |
13 | DomDirDbtCollectFile ![]() | Domestic Direct Debit Collections File | String | STR255 | 255 | |
14 | DomDirDbtRefundFile ![]() | Domestic Direct Debit Refunds File | String | STR255 | 255 | |
15 | BankIDNum ![]() | Bank Identification Number | String | STR30 | 30 | |
16 | BankInfo1 ![]() | Bank Info 1 | Integer | DDL | 0 | |
17 | BankInfo2 ![]() | Bank Info 2 | Integer | DDL | 0 | |
18 | BankInfo3 ![]() | Bank Info 3 | Integer | DDL | 0 | |
19 | BankInfo4 ![]() | Bank Info 4 | Integer | DDL | 0 | |
20 | BankInfo5 ![]() | Bank Info 5 | Integer | DDL | 0 | |
21 | BankInfo6 ![]() | Bank Info 6 | Integer | DDL | 0 | |
22 | FedResBankNum ![]() | Federal Reserve Bank Number | String | STR2_LBN | 2 | |
23 | FedResClient ![]() | Federal Reserve Client | String | STR5_LBN | 5 | |
24 | FedResBranch ![]() | Federal Reserve Branch | String | STR3_LBN | 3 | |
25 | EFTTransitRoutingNo ![]() | EFT Transit Routing Number | String | STR10_LBN | 10 | |
26 | EFTPreTransitDigit ![]() | EFT Pre Transit Digit | String | STR1_LBN | 1 | |
27 | EFTPriorityCode ![]() | EFT Priority Code | String | STR2_LBN | 2 | |
28 | EFTBlockingFactor ![]() | EFT Blocking Factor | String | STR2_LBN | 2 | |
29 | EFTFormatCode ![]() | EFT Format Code | String | STR1_LBU | 1 | |
30 | EFTReference ![]() | EFT Reference | String | STR8_LBAU | 8 | |
31 | EFTCompanyID ![]() | EFT Company ID | String | STR10_LBAU | 10 | |
32 | EFTBankCoName ![]() | EFT Bank Company Name | String | STR23_LBAU | 23 | |
33 | EFTSmallCoName ![]() | EFT Small Company Name | String | STR16_LBAU | 16 | |
34 | EFTServiceClassCode ![]() | EFT Service Class Code | Integer | INT3 | 3 | |
35 | EFTCommunicationType ![]() | EFT Communication Type | Integer | EFT_Communication_Type | 0 | |
36 | EFTCommunicationFile ![]() | EFT Communication File | String | STR80 | 80 | |
37 | EFTUseOriginatingCur ![]() | EFT Use Originating Currency | Boolean | EFT_CB_Use_Originating_Currency | 0 | |
38 | CCode ![]() | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['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 | ||||||
39 | ISOCURRC ![]() | ISO Currency Code | String | STR3_ISO_Currency_Code | 3 | |
40 | EFTDataCentreCode ![]() | EFT Data Centre Code | Long Integer | LONG5_R00U | 5 | |
41 | EFTNextFileNo ![]() | EFT Next File Number | Integer | INT4 | 4 | |
42 | EFTPMServClassAll ![]() | EFT PM ServClass All | String | STR15_EFTFormatID | 15 | |
43 | EFTPMServClassBus ![]() | EFT PM ServClass Business | String | STR15_EFTFormatID | 15 | |
44 | EFTPMServClassCorp ![]() | EFT PM ServClass Corporate | String | STR15_EFTFormatID | 15 | |
45 | EFTPMServClassForeign ![]() | EFT PM ServClass Foreign | String | STR15_EFTFormatID | 15 | |
46 | EFTPMServClassPersonal ![]() | EFT PM ServClass Personal | String | STR15_EFTFormatID | 15 | |
47 | EFTPMNextNumber ![]() | EFT PM Next Number | String | EFT_Number | 20 | |
48 | EFTPMPrenoteRequired ![]() | EFT PM Prenote Required | Boolean | EFT_CB_PM_Prenote_Required | 0 | |
49 | EFTPMPrenoteGracePeriod ![]() | EFT PM Prenote Grace Period | Integer | INT3 | 3 | |
50 | EFTPMPrenoteFile ![]() | EFT PM Prenote File | String | STR255 | 255 | |
51 | EFTPMReconcile ![]() | EFT PM Reconcile | Boolean | EFT_CB_PM_Reconcile | 0 | |
52 | EFTPMTrxNumbers ![]() | EFT PM Trx Numbers | Integer | GB | 0 | |
53 | EFTRMBankFormat ![]() | EFT RM Bank Format | Integer | EFT_DDL_RM_Bank_Foramt | 0 | |
54 | EFTRMServClassAll ![]() | EFT RM ServClass All | String | STR15_EFTFormatID | 15 | |
55 | EFTRMServClassBus ![]() | EFT RM ServClass Business | String | STR15_EFTFormatID | 15 | |
56 | EFTRMServiceClassCorp ![]() | EFT RM ServClass Corporate | String | STR15_EFTFormatID | 15 | |
57 | EFTRMServClassForeign ![]() | EFT RM ServClass Foreign | String | STR15_EFTFormatID | 15 | |
58 | EFTRMServClassPersonal ![]() | EFT RM ServClass Personal | String | STR15_EFTFormatID | 15 | |
59 | EFTRMNextNumber ![]() | EFT RM Next Number | String | EFT_Number | 20 | |
60 | EFTRMPrenoteRequired ![]() | EFT RM Prenote Required | Boolean | EFT_CB_RM_Prenote_Required | 0 | |
61 | EFTRMPrenoteGracePeriod ![]() | EFT RM Prenote Grace Period | Integer | INT3 | 3 | |
62 | EFTRMPrenoteFile ![]() | EFT RM Prenote File | String | STR255 | 255 | |
63 | EFTRMReconcile ![]() | EFT RM Reconcile | Boolean | EFT_CB_RM_Reconcile | 0 | |
64 | RMUSEEFTNUM ![]() | RM Use EFT Numbering | Boolean | CB_RM_Use_EFT_Numbering | 0 | |
65 | EFTRMPostBankRecSummary ![]() | EFT RM Post to Bank Rec in Summary | Boolean | CB_Post_Bank_Rec_Summary | 0 | |
66 | EFTPMPostBankRecSummary ![]() | EFT PM Post to Bank Rec in Summary | Boolean | CB_Post_Bank_Rec_Summary | 0 |