A. Hero Plan 1499 Promo 1. 有效期：2026-08-12 至 2026-10-15，按 SR Created Date 判断（含起止日）。 2. 条件：Postpaid 且 MSF = 1499；奖励 385 PHP。 / Period: Aug 12, 2026 – Oct 15, 2026, inclusive, determined by SR Created Date. Postpaid + MSF 1499: 385 PHP.
B. Switch Promo Incentive 1. 有效期：2026-07-16 至 2026-12-31，按 SR Created Date 判断（含起止日）。 2. 条件：PROMO_CODE 为 ANTICOMPETITOR PROMO、ANTICOMPETITOR SB 或 Switch Modem No SOA；奖励 200 PHP。 3. FSE：SR Created Date在2026-10-05之前沿用同周至少3笔Postpaid门槛；从2026-10-05起无需最低单量，后续继续沿用直至新规则发布。Cluster Leader仍从当月合计第9单起计算。 / Period: Jul 16, 2026 – Dec 31, 2026, inclusive, determined by SR Created Date. For FSE, the same-week 3-Postpaid gate applies through Oct 4, 2026; from Oct 5, 2026 onward there is no minimum-volume gate. Qualifying PROMO_CODE: 200 PHP.
C. 单笔SR互斥 / Per-SR Exclusivity 同一笔 SR 同时满足两项时，只发较高的 385 PHP，不可叠加；同一账号的不同 SR 仍分别独立判断。 / If both apply to the same SR, grant only the higher 385 PHP. Different SRs under the same account are evaluated independently.
📅 激励日期字段 / Incentive Date Field：仅使用 SR Created Date 判断活动期；不使用订单日期 / Date，也不使用其通常匹配的 COMPLETION_DATE。/ Use SR Created Date only; do not use Order Date / Date or its commonly mapped COMPLETION_DATE.
两项订单激励均不参与月度阶梯和月度补差。/ Both order incentives are excluded from monthly tiers and settlement.
📞 Postpaid
📱 Prepaid
📞 Postpaid — 周阶梯费率 / Weekly Tiered Rate
Cluster Leader · Postpaid固定规则 / Fixed Rule
CBC · Postpaid固定规则 / Fixed Rule
FSE · Postpaid
ABA Tier 1 · Postpaid
ABA Tier 2 · Postpaid
CBA_FLA · Postpaid（月度阶梯结算 / Monthly Downpayment）
CBA_Leadstore · Postpaid（70% × 套餐价 / Fixed % Per Order）
为 BP_BRGY Agent_Subline · Postpaid 单独配置代理、区域、月目标、预付比例和达成比例；计算公式与 BP_BGY AGENT 保持一致。 / Configure agents, regions, monthly targets and rates separately for BP_BRGY Agent_Subline Postpaid; the commission formula remains the same as BP_BGY AGENT.
CBC团队归属来自上传文件的 CBC 列；此区域可维护CBC编号、姓名和月度目标，佣金公式仍为只读。/ Team ownership comes from the uploaded CBC column; CBC code, name and monthly target are editable here, while commission formulas remain read-only.
CBC编号 / Code
姓名 / Name
月度目标 / Target
75%奖励 / Reward
100%奖励 / Reward
操作 / Actions
📋 全部角色已实现 / All Roles Implemented
当前支持包括 Cluster Leader、CBC、BP_BGY AGENT、BP_BRGY Agent_Subline 在内的全部销售角色，Postpaid 与 Prepaid 规则均按角色独立识别。 / All implemented sales roles, including Cluster Leader, CBC, BP_BGY AGENT and BP_BRGY Agent_Subline, are identified independently for Postpaid and Prepaid.
📁 上传销售订单数据 / Upload Sales Order Data
📤
点击上传或拖拽文件到此处 / Click or drag files here
支持 .csv / .xlsx / .xls · 单个文件最大 20MB · 中英文列名自动识别 / Supports .csv/.xlsx/.xls · max 20MB per file
必需列：Username、销售角色、销售姓名、Region、Area、产品套餐/Package、Plan Tagging（Postpaid/Prepaid）、订单日期；Cluster Leader订单还必须映射Payment Status（PAID/UNPAID）。Username必须匹配管理员后台Active人员，姓名、角色、Region和Area必须全部一致；FSE的Area必须映射具体区域（例如CSCR_TMS_ZONE）。角色和Package必须与系统目录精确匹配。Postpaid必须填写套餐月费，Prepaid可为空或为0。 / Required: Username, Position, Name, Region, Area, Package, Plan Tagging and Date; Cluster Leader orders also require Payment Status (PAID/UNPAID). Username must match an Active Admin record with matching Name, Position, Region and Area; for FSE, Area must map to the specific zone such as CSCR_TMS_ZONE. Position and Package must exactly match the catalogues. Postpaid requires Plan Fee / MSF; Prepaid may be blank or 0.
✅已加载 / Loaded 0 条记录 / records
📝 文件列说明 / Column Reference
列名-中 / Column (CN)
列名-英 / Column (EN)
示例 / Example
说明 / Note
销售角色
Position / Sales Role
FSE
必填，必须与角色目录精确匹配 / Required; must exactly match the Sales Roles catalogue
销售姓名
Name / Sales Name
Zhang San
必填 / Required
产品套餐
Package
ECDN
必填，必须与 Package 目录精确匹配 / Required; must exactly match the Package catalogue
Plan Tagging
Plan Tagging
Postpaid
Postpaid 或 Prepaid / Postpaid or Prepaid
付款状态
Payment Status
PAID / UNPAID
Cluster Leader必填；PAID才具备佣金或激励资格，但PAID与UNPAID都计入Posted数量 / Required for Cluster Leader; only PAID can earn commission or incentives, while both statuses count as posted
套餐月费
Plan Fee / MSF
1999 / 0 / 空白
Postpaid 必填；Prepaid 可为 0 或空白，单位 PHP / Required for Postpaid; 0 or blank allowed for Prepaid, unit: PHP
📦 按产品套餐 & Plan Tagging 汇总 / By Package & Plan Tagging
产品套餐 / Package
Plan Tagging
订单数 / Orders
套餐总额 / Plan Fee
佣金总额 / Commission
🎁 订单级固定激励报表 / Order-level Fixed Incentive Report
💡 当前统计跟随上方批次和筛选条件。资格按 SR Created Date 判断。 A. Hero Plan 1499：2026-08-12 至 2026-10-15，符合条件为385 PHP。 B. Switch Promo：2026-07-16 至 2026-12-31，符合条件为200 PHP；FSE更新规则自2026-10-05生效，暂定有效至2026-12-31。 C. FSE区域规则：新规则适用于2026-10-05至2026-12-31的订单；2026-10-05之前沿用旧FSE规则。 D. 互斥：同一笔SR同时满足两项时只发最高的385 PHP；同一账号的不同SR分别计算。 / Eligibility uses SR Created Date. FSE regional rules apply to orders from Oct 5 through Dec 31, 2026; earlier orders use the legacy FSE rule. If both incentives apply to one SR, grant only the higher 385 PHP; different SRs under the same account are evaluated independently.
激励规则 / Incentive Rule
适用条件 / Condition
订单数 / Orders
销售角色 / Roles
销售人员 / Persons
基础佣金 / Base Commission
激励金额 / Incentive
订单应付 / Order Payable
👥 CBC 团队Override与月度奖励 / CBC Team Override & Monthly Reward
💡 FSE新区域规则有效期：2026-10-05 至 2026-12-31（含起止日）；此前订单沿用旧FSE规则。仅统计 Posted、MSF ≥1299 的 Postpaid 订单，Payment Status 不参与 FSE 佣金校验；周度佣金不重复计算。NCR 从第18单、NLZ+Cagayan Valley North 从第11单、SLZ+Batangas 从第11单、SLZ+Cavite 从第14单、VIS 从第16单起，额外增加60%。 / FSE regional rules are effective from Oct 5 through Dec 31, 2026 inclusive; earlier orders use the legacy FSE rule. Only Posted Postpaid orders with MSF ≥1299 qualify; Payment Status is not used for FSE commission validation. Weekly commission is not duplicated.