Search

Invoice Aggregate Demographic Data

Date Range: Current month / year (monthly billing period)

Description

Sub-merchant demographic and fee schedule information for the current billing period. Each row represents one sub-merchant and includes their address, configured fee rates, and the invoice period start/end dates.

Columns

Column	Type	Description
`MID`	text(10)	Merchant number.
`Comp_Num`	text(10)	Merchant number (same as MID).
`Comp_Name`	text(60)	Legal company name.
`MerchantName`	text(60)	Merchant name (same as `Comp_Name`).
`Comp_Discret`	text	Company discretionary data.
`CompanyDiscretionaryData`	text	Company discretionary data (same as `Comp_Discret`).
`Address_1`	text(60)	Merchant address line 1.
`Address_2`	text(60)	Merchant address line 2. May be blank.
`City`	text(30)	Merchant city.
`State`	text(2)	Merchant state (2-letter abbreviation).
`ZIP`	text(9)	Merchant ZIP code.
`Origination`	currency	Per-transaction origination fee rate.
`Discount`	decimal	Discount fee rate (percentage).
`MonthlyMaintenance`	currency	Monthly maintenance fee.
`Return`	currency	Per-return fee.
`NOC`	currency	NOC fee.
`Chargeback`	currency	Chargeback fee.
`Authorization`	currency	Per-authorization fee.
`ReturnedDisbursement`	currency	Returned disbursement fee.
`POAInquiry`	currency	Proof of Authorization inquiry fee.
`POAFailure`	currency	Proof of Authorization failure fee.
`OverChargebackPercentageDiscount`	decimal	Discount rate applied when chargeback percentage is exceeded.
`OverReturnPercentageDiscount`	decimal	Discount rate applied when return percentage is exceeded.
`OverDailyThresholdPenalty`	currency	Penalty for exceeding the daily transaction threshold.
`OverMonthlyThresholdPenalty`	currency	Penalty for exceeding the monthly transaction threshold.
`ManualIntervention`	currency	Manual intervention fee.
`QuarterlyComplianceFee`	currency	Quarterly compliance fee.
`ManualReport`	currency	Manual report fee.
`ExcessiveSupport`	currency	Excessive support fee.
`CashManagement`	currency	Cash management fee.
`CashManagementDiscount`	decimal	Cash management discount rate.
`OverChargebackPenalty`	currency	Penalty fee for exceeding chargeback thresholds.
`OverReturnPenalty`	currency	Penalty fee for exceeding return thresholds.
`SameDayOrigination`	currency	Same-day origination fee.
`SameDayDiscount`	decimal	Same-day origination discount rate.
`Application`	currency	Application fee.
`InvoiceBegin`	date	Start date of the billing period. Format: `M/D/YYYY`.
`InvoiceEnd`	date	End date of the billing period. Format: `M/D/YYYY`.