Checkbook Electronic Funds Transfer Master (CM00101)

azurecurve Products Microsoft 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 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/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
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/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
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

azurecurve Products Microsoft Dynamics GP (0)FinancialCheckbook Electronic Funds Transfer Master (CM00101)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply