CM20202 - Checkbook Transaction Electronic Funds Transfer | Prospr

CM20202 - Checkbook Transaction Electronic Funds Transfer

Query Builder

Select * from CM20202

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCNUMBR	Document Number	String	22	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
EFTType	EFT Type	Integer	2	View
EFTFileFormat	EFT File Format	Integer	2	View
TRXDATE	TRX Date	Date	4	View
Checkbook_Amount	Checkbook Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
ISOCURRC	ISO Currency Code	String	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
BCHCOMNT	Batch Comment	String	62	View
paidtorcvdfrom	Paid ToRcvd From	String	66	View
COMMENT1	Comment1	String	32	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
VOIDDATE	Void Date	Date	4	View
AUDITTRAIL	Audit Trail Code	String	14	View
ExecDate	Execution Date	Date	4	View
RefNum	Reference Number	String	42	View
CHEKBKID	Checkbook ID	String	16	View
EFTBankTypeCB	EFT Bank Type Checkbook	Integer	2	View
EFTBankAcctCB	EFT Bank Account Checkbook	String	36	View
EFTBankBranchCB	EFT Bank Branch Checkbook	String	16	View
EFTBankCodeCB	EFT Bank Code Checkbook	String	16	View
EFTBankBranchCodeCB	EFT Bank Branch Code Checkbook	String	6	View
EFTBankCheckDigitCB	EFT Bank Check Digit Checkbook	String	4	View
IntlBankAcctNum	International Bank Account Number	String	36	View
TXRGNNUM	Tax Registration Number	String	26	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
CustomerVendor_ID	Customer/Vendor ID	String	16	View
ADRSCODE	Address Code	String	16	View
EFTBankType	EFT Bank Type	Integer	2	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
CustVendIBAN	Customer/Vendor IBAN	String	36	View
SWIFTADDR	Swift Address	String	12	View
CustVendCountryCode	Customer/Vendor Country Code	String	4	View
DeliveryCountryCode	Delivery Country Code	String	4	View
BNKCTRCD	Bank Country Code	String	4	View
CBANKCD	Central Bank Code	String	10	View
GIROPostType	GIRO Post Type	Integer	2	View
RegCode1	Regulatory Code 1	String	32	View
RegCode2	Regulatory Code 2	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
BankInfo7	Bank Info 7	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

CM20202 - Checkbook Transaction Electronic Funds Transfer

Query Builder

Customer Service

Information

My Account

Contact Us