新版订单消耗系统

columns_note.php 6.5KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. <?php
  2. //字段解释
  3. return [
  4. 'PROJECT' =>[
  5. #项目
  6. 'title' => '项目名称',
  7. 'advertiser_account' => '所属账户',
  8. 'advertiser_id' => '所属账户id',
  9. 'company' => '签约公司',
  10. 'month' => '所属月份',
  11. 'sales_name' => '销售人员',
  12. 'handle_user' => '经手人',
  13. 'customer_name' => '客户全称',
  14. 'platform_name' => '投放平台',
  15. 'media_name' => '媒体名称',
  16. #订单
  17. 'salesman' => '销售人员',
  18. 'handler' => '经手人',
  19. 'launch_platform' => '投放平台',
  20. 'cost_company_name' => '成本公司全称',
  21. 'cost_owner' => '成本负责人',
  22. 'internet_celebrity_name' => '网红名',
  23. 'internet_celebrity_id' => '网红id',
  24. 'amount' => '订单金额',
  25. 'final_amount' => '订单最终收入金额',
  26. 'launch_start_date' => '投放起始日期',
  27. 'launch_end_date' => '投放截止日期',
  28. 'billing_date' => '开票日期',
  29. 'ratio_of_consumption_to_top_rebate' => '消耗与置顶返点比例',
  30. 'flow_boost_rebate_ratio' => '流量助推返点比例',
  31. 'sr_rate' => '上饶易效比例',
  32. 'project_name_second' => '项目名称2',
  33. 'project_name' => '项目名称',
  34. 'if_public' => '是否对公',
  35. 'cost' => '订单成本金额消耗',
  36. 'traffic_boost_sum' => '流量助推合计',
  37. 'traffic_boost_refund' => '流量助推(使用返货)',
  38. 'traffic_boost_money' => '流量助推(使用现金)',
  39. 'top_fee' => '置顶费',
  40. 'offline_subsidy_amount' => '线下补款金额',
  41. 'cost_invoice_status' => '成本发票情况',
  42. 'rebate_spending_ratio' => '返点支出比例',
  43. 'rebate_expense_receiving_unit' => '返点支出收款单位',
  44. 'note' => '备注',
  45. 'actual_cost_sum' => '后台实付成本合计金额',
  46. 'rebate' => '上饶易效金额',
  47. 'ratio_of_consumption_to_top_income' => '消耗与置顶返点收入',
  48. 'flow_boost_rebate_income' => '流量助推返点收入',
  49. 'rebate_spending_amount' => '返点支出金额',
  50. 'final_rebate_spending_amount' => '返点支出确认金额',
  51. 'actual_cost' => '当月实际消耗成本金额',
  52. 'profit' => '当月毛利',
  53. 'gross_margin' => '毛利率',
  54. 'rebate_amount_receivable' => '应收返点金额',
  55. 'rebate_amount_payable' => '应付返点金额',
  56. 'payment_date' => '回款日期',
  57. 'document_number_first' => '凭证号1',
  58. 'document_number_second' => '凭证号2',
  59. 'document_number_third' => '凭证号3',
  60. 'document_number_four' => '凭证号4',
  61. 'document_number_five' => '凭证号5',
  62. 'document_number_six' => '凭证号6',
  63. 'document_number_seven' => '凭证号7',
  64. 'status' => '订单状态',
  65. 'offline_subsidy_company' => '线下补款公司',
  66. 'payes' => '收款人',
  67. 'payment_time' => '收款时间',
  68. 'uninvoiced_amount' => '未开票金额',
  69. 'unbilled_voucher' => '未开票凭证',
  70. 'invoice_amount' => '开票金额',
  71. 'tax_free_amount' => '不含税金额',
  72. 'confirmation_certificate' => '确认凭证',
  73. 'confirmed_cost_includes_tax' => '确认成本(含税)',
  74. 'confirmed_cost' => '确认成本(不含税)',
  75. 'rebate_total' => '返点合计',
  76. 'estimate_cost' => '暂估成本金额',
  77. 'estimate_traffic_boost_refund' => '暂估流量助推(返货)成本',
  78. 'cost_invoice_date' => '成本开票日期',
  79. 'final_ratio_of_consumption_to_top_rebate' => '最终确定季度返点比例',
  80. 'final_ratio_of_consumption_to_top_income' => '消耗与置顶返点收入-确认金额',
  81. 'final_flow_boost_rebate_ratio' => '最终确定季度返点比例-流量助推',
  82. 'final_flow_boost_rebate_income' => '流量助推返点收入-确认金额',
  83. 'red_invoice_date' => '红字发票日期',
  84. 'refund_invoice_date' => '返点发票日期',
  85. 'estimate_rebate_total' => '暂估返点合计',
  86. 'offline_invoice_date' => '线下补款开票日期',
  87. 'offline_confirmed_cost_includes_tax' => '线下确认成本(含税)发票金额',
  88. 'offline_confirmed_cost' => '线下确认成本(不含税)',
  89. 'offline_celeb_name' => '线下补款收款人姓名',
  90. 'offline_pay_date' => '线下付款日期',
  91. 'actual_consumption_after' => '实际消耗(收入折分后项)',
  92. 'actual_consumption_before' => '实际消耗(收入折分前项)',
  93. 'actual_consumption_rebate_ratio' => '实际消耗返点比例(客户折扣比例)',
  94. 'agreed_rebate_percentage' => '约定的返点比例',
  95. 'before_folding_combined' => '折前合计',
  96. 'cpa_single_quantity' => 'cpa单量',
  97. 'cpa_unit_income_price' => 'cpa收入单价',
  98. 'customer_rebate' => '客户返点(净额)',
  99. 'discounted_combined' => '折后合计',
  100. 'estimated_amount' => '暂估收入金额',
  101. 'final_customer_name' => '穿透最终客户名称',
  102. 'flow_boost_back_point_after' => '流量助推(收入折后项)',
  103. 'flow_boost_back_point_before' => '流量助推(收入折分前项)',
  104. 'flow_boost_back_point_ratio' => '流量助推返点比例(客户折扣比例)',
  105. 'income_red_invoice_amount' => '开具红字发票金额',
  106. 'income_red_invoice_date' => '开具红字发票日期',
  107. 'link_fee_after' => '链接费(收入折分后项)',
  108. 'link_fee_before' => '链接费(收入折分前项)',
  109. 'link_fee_rebate_ratio' => '链接费返点比例(客户折扣比例)',
  110. 'mcn_final_amount' => 'mcn最终收入金额',
  111. 'organization_amount' => '机构到手金额',
  112. 'top_fee_after' => '置顶费(收入折后项)',
  113. 'top_fee_before' => '置顶费(收入折分前项)',
  114. 'top_fee_rebate_proportion' => '置顶费返点比例(客户折扣比例)',
  115. 'saler_note' => '利润异常原因',
  116. 'mcn_name' => 'mcn机构名称',
  117. 'mcn_rebate' => 'mcn返点收入',
  118. 'mcn_handler' => 'mcn经手人',
  119. 'mcn_user' => 'mcn负责人',
  120. 'customer_rebate_amount' => '客户后返返点金额',
  121. 'offline_cost_invoice_date' => '线下成本开票日期',
  122. 'offline_cost_invoice_amount' => '线下成本开票金额',
  123. ],
  124. #订单
  125. 'ORDER' => [
  126. ],
  127. 'CONFIG' => [
  128. 'rebate' => '返点比例',
  129. 'month' => '月份',
  130. 'media_name' => '媒体名称',
  131. 'advertiser_account' => '账户名称',
  132. 'advertiser_id' => '账户ID',
  133. 'account_budget' => '账户消耗金额',
  134. 'company_name' => '公司名称',
  135. 'is_default' => '是否默认',
  136. 'customer_name' => '客户名称',
  137. 'name' => 'mcn机构名称',
  138. 'company' => '对应公司名称',
  139. 'cost_owner' => '成本负责人',
  140. 'platform_name' => '平台名称',
  141. 'title' => '项目名称'
  142. ]
  143. ];