# Matriz normativa Affilka

APC-4 publica estas secuencias textuales sin ingerir archivos ni calcular comisiones. Una columna faltante, extra, duplicada o reordenada debe cambiar el fingerprint y rechazar el batch futuro.

## affiliates_info — 17 headers

`ID`, `Name`, `Emails`, `Created at`, `Last seen at`, `Address`, `Phone`, `Microsoft Teams`, `Telegram`, `Players count`, `Balance amount`, `Dedicated operator`, `State`, `Block reason`, `Partners traffic sources`, `Promos traffic sources`, `Tags`.

## player_detail — 30 headers

`ID`, `User ID in casino`, `Email`, `Brand ID`, `Brand name`, `Partner ID`, `Partner name`, `Campaign ID`, `Promo ID`, `Promo code`, `Dynamic tags`, `First name`, `Last name`, `Country`, `Created at`, `FTD processed at`, `FTD amount`, `FTD amount cents`, `FTD currency`, `Total deposits count`, `Total deposits sums`, `Disabled at`, `Duplicated at`, `Qualified at`, `Sign up at`, `Self-excluded at`, `Disabled`, `Duplicate`, `Qualified`, `Access limit`.

## monthly_partner_financial_aggregate — 27 headers

`Partner ID`, `Company name`, `Email`, `Visits`, `Registrations`, `Currency`, `FTD count`, `FTD sum`, `Deposits count`, `Deposits sum`, `Cashouts count`, `Cashouts sum`, `Casino GGR`, `Casino bonuses`, `Casino balance corrections`, `Casino Real NGR`, `Casino NGR`, `SB settled bets sum`, `SB real GGR`, `SB GGR`, `SB bonuses sum`, `SB balance corrections sum`, `SB third party fees sum`, `SB Real NGR`, `SB NGR`, `Clean net revenue`, `Net deposits`.

`Visits` no sustituye al click ledger. Los campos `requires_definition` no se calculan ni participan en comisiones hasta contar con definición verificable del proveedor.