CM00101 - Checkbook Electronic Funds Transfer Master | Prospr

CM00101 - Checkbook Electronic Funds Transfer Master

Query Builder

Select * from CM00101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CHEKBKID	Checkbook ID	String	16	View
EFTBankType	EFT Bank Type	Integer	2	View
AcctHolder	Account Holder	String	22	View
EFTBankAcct	EFT Bank Account	String	36	View
EFTBankBranch	EFT Bank Branch	String	16	View
EFTBankCode	EFT Bank Code	String	16	View
EFTBankBranchCode	EFT Bank Branch Code	String	6	View
EFTBankCheckDigit	EFT Bank Check Digit	String	4	View
IntlBankAcctNum	International Bank Account Number	String	36	View
TXRGNNUM	Tax Registration Number	String	26	View
DomPmtsFile	Domestic Payments File	String	256	View
ForeignPmtsFile	Foreign Payments File	String	256	View
DomDirDbtCollectFile	Domestic Direct Debit Collections File	String	256	View
DomDirDbtRefundFile	Domestic Direct Debit Refunds File	String	256	View
BankIDNum	Bank Identification Number	String	32	View
BankInfo1	Bank Info 1	Integer	2	View
BankInfo2	Bank Info 2	Integer	2	View
BankInfo3	Bank Info 3	Integer	2	View
BankInfo4	Bank Info 4	Integer	2	View
BankInfo5	Bank Info 5	Integer	2	View
BankInfo6	Bank Info 6	Integer	2	View
FedResBankNum	Federal Reserve Bank Number	String	4	View
FedResClient	Federal Reserve Client	String	6	View
FedResBranch	Federal Reserve Branch	String	4	View
EFTTransitRoutingNo	EFT Transit Routing Number	String	12	View
EFTPreTransitDigit	EFT Pre Transit Digit	String	2	View
EFTPriorityCode	EFT Priority Code	String	4	View
EFTBlockingFactor	EFT Blocking Factor	String	4	View
EFTFormatCode	EFT Format Code	String	2	View
EFTReference	EFT Reference	String	10	View
EFTCompanyID	EFT Company ID	String	12	View
EFTBankCoName	EFT Bank Company Name	String	24	View
EFTSmallCoName	EFT Small Company Name	String	18	View
EFTServiceClassCode	EFT Service Class Code	Integer	2	View
EFTCommunicationType	EFT Communication Type	Integer	2	View
EFTCommunicationFile	EFT Communication File	String	82	View
EFTUseOriginatingCur	EFT Use Originating Currency	Boolean	2	View
CCode	Country Code	String	8	View
ISOCURRC	ISO Currency Code	String	4	View
EFTDataCentreCode	EFT Data Centre Code	Long Integer	4	View
EFTNextFileNo	EFT Next File Number	Integer	2	View
EFTPMServClassAll	EFT PM ServClass All	String	16	View
EFTPMServClassBus	EFT PM ServClass Business	String	16	View
EFTPMServClassCorp	EFT PM ServClass Corporate	String	16	View
EFTPMServClassForeign	EFT PM ServClass Foreign	String	16	View
EFTPMServClassPersonal	EFT PM ServClass Personal	String	16	View
EFTPMNextNumber	EFT PM Next Number	String	22	View
EFTPMPrenoteRequired	EFT PM Prenote Required	Boolean	2	View
EFTPMPrenoteGracePeriod	EFT PM Prenote Grace Period	Integer	2	View
EFTPMPrenoteFile	EFT PM Prenote File	String	256	View
EFTPMReconcile	EFT PM Reconcile	Boolean	2	View
EFTPMTrxNumbers	EFT PM Trx Numbers	Integer	2	View
EFTRMBankFormat	EFT RM Bank Format	Integer	2	View
EFTRMServClassAll	EFT RM ServClass All	String	16	View
EFTRMServClassBus	EFT RM ServClass Business	String	16	View
EFTRMServiceClassCorp	EFT RM ServClass Corporate	String	16	View
EFTRMServClassForeign	EFT RM ServClass Foreign	String	16	View
EFTRMServClassPersonal	EFT RM ServClass Personal	String	16	View
EFTRMNextNumber	EFT RM Next Number	String	22	View
EFTRMPrenoteRequired	EFT RM Prenote Required	Boolean	2	View
EFTRMPrenoteGracePeriod	EFT RM Prenote Grace Period	Integer	2	View
EFTRMPrenoteFile	EFT RM Prenote File	String	256	View
EFTRMReconcile	EFT RM Reconcile	Boolean	2	View
RMUSEEFTNUM	RM Use EFT Numbering	Boolean	2	View
EFTRMPostBankRecSummary	EFT RM Post to Bank Rec in Summary	Boolean	2	View
EFTPMPostBankRecSummary	EFT PM Post to Bank Rec in Summary	Boolean	2	View

CM00101 - Checkbook Electronic Funds Transfer Master

Query Builder

Customer Service

Information

My Account

Contact Us