1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- <?php
- /**
- * '菜单ID' => [
- * '字段英文名' =》 '字段中文名'
- * ]
- */
- return [
- [
- 'key' =>'order_number',
- 'value' => '关联单据号',
- ],
- [
- 'key' =>'voucher_type_title',
- 'value' => '单据类型',
- ],
- [
- 'key' =>'customer_code',
- 'value' => '结算客户编码',
- ],
- [
- 'key' =>'customer_title',
- 'value' => '结算客户',
- ],
- [
- 'key' =>'channel_finance',
- 'value' => '渠道财务',
- ],
- [
- 'key' =>'customer_profit_rate',
- 'value' => '客户毛利率',
- ],
- [
- 'key' =>'product_code',
- 'value' => '存货编码',
- ],
- [
- 'key' =>'product_title',
- 'value' => '存货名称',
- ],
- [
- 'key' =>'product_size',
- 'value' => '规格型号',
- ],
- [
- 'key' =>'unit',
- 'value' => '计量单位',
- ],
- [
- 'key' =>'quantity',
- 'value' => '开票数量',
- 'sum' => 1,
- ],
- [
- 'key' =>'price_1',
- 'value' => '单价',
- ],
- [
- 'key' =>'payment_amount',
- 'value' => '回款金额',
- 'sum' => 1,
- ],
- [
- 'key' =>'price_1_total',
- 'value' => '开票金额',
- 'sum' => 1,
- ],
- [
- 'key' =>'price_4',
- 'value' => '业务成本单价',
- 'sum' => 1,
- ],
- [
- 'key' =>'price_4_total',
- 'value' => '业务成本金额',
- 'sum' => 1,
- ],
- [
- 'key' =>'profit',
- 'value' => '毛利',
- 'value1' => '回款金额 - 业务成本金额',
- 'sum' => 2,
- 'formula' => 'payment_amount - price_4_total',
- ],
- [
- 'key' =>'profit_rate',
- 'value' => '毛利率%',
- 'value1' => '毛利 / 回款金额',
- 'sum' => 2,
- 'formula' => 'profit / payment_amount * 100',
- ],
- ];
|