18. Reports

14.1 Overview

Field	Sub-field	Type	Description
aggregations		Object	Total Aggregate amount of the records fetched
	totalAmount value	Object Integer	Total Amount Total Amount value
totalRecords		Integer	Total number of records available
totalType		String	Whether the records returned are an exact or in range
recordCount		Integer	Number of records fetched
records		Array of objects	Details of the records fetched
	id	String	Id of Fee transaction
	acl	Array	Access control list Id of Fee transaction
	tags	Array	Tags associated with Fee transaction
	buyer id ach billing delayDays debitMethod bankAccountId exposureTracking days limit enabled lastUpdateDate currentExposureAmount bid name status creditLimit address street1 street2 city state country postalCode vcnHost vcnHostConfig braves companyNumber falcons paymentReferenceNumber LDG/PPD/VCN/VWA id name value passport account da id customerId syncError addressId buyerWallet id walletId bankAccount id achEnabled virtualCard billing bankAccountId exposureTracking enabled achRequested wireEnabled wireRequested externalStatus dualPifApproval enabled failOverPayment enabled associatedInstitutionId managedCheckRequested managedCheckEnabled invoiceUploadEnabled expeditedShippingEnabled plastiqPayEnabled dxcModelFromAccountNumber customRemittanceEnabled lodgePaymentEnabled checkInsertsEnabled checkEnabled virtualCardEnabled virtualCardRequested isEnhancedManagedCheck checkIssuingRequested checkIssuingEnabled wire billing walletId delayDays debitMethod plastiq payerId syncError wallet id	Object String Object String Integer Enum String Object Integer Number Boolean String Number String String Enum Number Object String String String String String String String Object Object String Object String Object String String String Object Object Object String String String String Object String String Object String String Object Object String String Boolean Object String String Object Boolean Boolean Boolean Enum Object Boolean Object Boolean String Boolean String String Boolean Boolean Boolean Boolean String Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Boolean Object String String Integer Enum Object String String Object String	Buyer associated to wallet transaction Id of buyer Ach billing information Billing method set for ACH Delay days set for ACH Debit Method set for ACH Id of Bank account set for ACH Exposure tracking for ACH Number of days for tracking Limit set for tracking If exposure tracking is enabled Last updated on Current exposure amount BID of the Buyer Name of the Buyer Status of the Buyer Credit limit set for buyer Address of the Buyer Street1 of the address Street2 of the address city of the address state of the address country of the address Postal Code of address VCN host of the Buyer VCN Host configuration for buyer Braves configuration Company Number for braves Falcons configuration of buyer Payment Reference Number for falcons Product set for falcon - LDG/PPD/VCN/VWA Id of Product Name of Product Value of Product Passport customer details for the buyer Passport Account details Deposit account Id of deposit account Customer ID of buyer in Passport Sync error if any Wallet details Id of wallet WalletID assigned by CPX Bank Account Id of Bank Account in Passport If ACH enabled for buyer Virtual Card details set for Buyer Billing method for Virtual Card Bank account ID set for VC Exposure tracking set for VC Whether Exposure tracking is enabled If ACH requested for buyer If wire is enabled for buyer If Wire toggle has been enabled External Status for Buyer Dual PIF approval If Dual PIF approval is enabled Fail Over payment setting If Fail Over payment is enabled ID of Institution associated to Buyer If managed check is requested for buyer If managed Check is enabled for Buyer If invoice upload is enabled for Buyer If expedited shipping is enabled for Buyer If Plastiq Pay is enabled for Buyer DXC Model account number If Custom check remittance is enabled for Buyer If Lodge Payment is enabled for Buyer If check inserts are enabled for Buyer If check is enabled for Buyer If virtual card is enabled for Buyer If virtual card is requested for Buyer pending underwriting If enhanced managed Check is enabled for Buyer If check issuing is requested for buyer If Check issuing enabled for buyer Wire details for buyer Billing details for wire walletId for wire delayDays set for wire debitMethod set for wire Plastiq sync details for buyer Payer ID of buyer in plastiq Sync error message if any Wallet details Id of wallet
	amount	String	Amount of Fee
	fileId	String	Id of File associated
	created	String	Fee transaction created date and time
	creator id username	Object String String	Creator of fee transaction Id of creator Username of creator
	network id nid name status externalStatus	Object String String String String String	Network details associated to Fee Id of Network NID of network Name of Network Status of Network External Status of Network
	institution id fid name status fees bankAccountId revenue bankAccountId goodFunds bankAccountId achDelayDays vcnValidDays externalStatus paymentFileType bankAccountNumber hash mask bankRoutingNumber hash mask associatedNetworkId	Object String String String String Object String Object String Object String String String String String Object String String Object String String String	Institution details associated to Fee Id of Institution FID of Institution Name of Institution Status of Institution Fee account details of Institution BankAccount set for Fee Revenue account details BankAccount set for Revenue Good fund account details BankAccount set for Goodfunds ACH Delay days set at Institution VCN Valid days set at Institution External Status of Institution Payment File Type set at Institution Bank Account Number Hash of account number Mask of account number Bank Routing Number Hash of account number Mask of account number Id of associated Network
	fileDate	String	Date of file creation
	filePath	String	Path of File
	modified	String	When was the fee transaction last modified
	modifier id username	Object String String	Modifier details Id of Modifier Username of modifier
	replayId	String	External ID for ACH Payment
	ready	String	Date and time when transaction moved to ready
	supplier id mcc code description sid name status address street 1 street 2 city state country postalCode variance amount payeeType expirePreAuths externalStatus paymentTypes id type enabled accountType feeType flatFee netFees discountRate payableTo additionalPayableTo payableToLine3 lowTermDays highTermDays prepaidDebitId prepaidDebitBalance fax emails deliveryMethod noNotification virtualWalletId virtualWalletBalance address street1 street2 city state country postalCode phone contacts id name phone email primary passport addressId customerId externalAccount wire accountId checkIssuingAddressId syncError plastiq ACH syncError recipientId CHK syncError recipientId	Object String Object String String String String String Object String String String String String String Object String String String String Object String String Boolean String String String String String String String String String String String String String String Boolean String Boolean String String Object String String String String String String String Object String String String String String Object String String Object Object String String String Object Object String String Object String String	Supplier details Id of supplier Mcc of supplier Code of MCC Description of MCC Sid of supplier Name of supplier Status of supplier Address of supplier street 1 of supplier street 2 of supplier City of supplier State of supplier Country of supplier postalCode of supplier Variance of supplier Amount of supplier payeeType of supplier expirePreAuths of supplier externalStatus of supplier paymentTypes of supplier Id of payment type Type of payment type If payment type is Enabled accountType of payment type feeType of payment type If flatFee enabled If netFees enabled If discountRate enabled payableTo for check payments lowTermDays set for payment method highTermDays set for payment method prepaidDebitId for payment method prepaidDebitBalance for payment method Fax number for payment method deliveryMethod for payment method If noNotification is enabled Id of virtual Wallet Balance of virtual Wallet If Pin is required to access VC Proxy Payment enabled for supplier Address set for payment method Street1 Of address Street2 of address City of address State of address Country of address Postal Code of address Phone number for wire Contact details set for supplier Id of contact Name of contact Phone of contact Email of contact If contact is set as primary Passport details for supplier Id of Address in Passport Id of customer in Passport External Account details Wire details Id of account for wire Check issuing address Id Sync error message if any Plastiq details for supplier ACH details in Plastiq Sync error message if any Id of ACH recipient in plastiq Check details in Plastiq Sync error message if any Id of Check recipient in plastiq
	isNetFees	Boolean	If Netfees is enabled for the supplier
	achDebitId	String	Id of debit created for ACH payment
	importDate	String	Date and time when fee was imported in CPX
	statusDate	String	Date and time when Status was updated
	accountType	String	Account Type associated with fee
	createdFrom	String	Payment created from which platform
	hasInvoices	Boolean	If Payment has associated invoices
	invoiceCount	String	Count of associated invoices
	paymentMethod	String	Payment method associated with fee
	paymentStatus	String	Status of Payment
	transactionId	String	Id of Payment transaction
	originalAmount	String	Original amount of payment
	hasPendingDebit	Boolean	Whether associated debit is pending
	tranactionDate	String	Date of payment transaction
	awaitingApproval	String	Date and time when transaction moved to awaiting approval
	isNewTransaction	Boolean	If transaction is new in CPX
	bankAccountNumber hash mask	Object String String	Bank account details associated to fee Hash of bank account Mask of bank account
	bankRoutingtNumber hash mask	Object String String	Routing account details associated to fee Hash of Routing account Mask of Routing account
	achTransactionType	String	Whether transaction is credit or debit
	paymentProcessDate	String	Date of payment processing
	buyerBillingProduct	String	Buyer billing Product for fee
	transactionCategory	String	Category for transaction
	isAchPlusInstitutionCredit	Boolean	If category is AchPlusInstitutionCredit
	paymentAccountNumber	String	Last 4 of Bank account number
	associatedSupplierCreditIds	Array	Supplier credit ids associated with fee
	paymentAuthMessage	String	Payment authorization message
	denied	String	Date and time of payment being denied
	netFees	Boolean	Whether net fees is applicable
	transactionType	String	Type of transaction

14.2 Operations

14.2.1. Get ACH Fee Report for Institution