PK �>�\9�Z�;�;process_bill.py#!/usr/bin/env python3 import pandas as pd import sys import os from datetime import datetime

完整的透视表字段顺序列表

ALL_FIELDS = ["账务账期", "Payer账号ID", "Payer ID", "Owner账号ID", "账号 ID", "产品", "商品", "计费模式", "账单类型", "配置名称", "计费单元", "单价", "单价单位", "优惠类型", "优惠内容", "用量", "原价", "折后价", "代金券抵扣", "应付金额"]

需要居中对齐的字段

CENTER_COLUMNS = ["账务账期", "计费模式", "账单类型", "单价", "单价单位", "优惠类型", "优惠内容"]

需要金额格式的字段

AMOUNT_FIELDS = ["原价", "折后价", "代金券抵扣", "应付金额"]

需要聚合求和的字段

AGG_FIELDS = ["用量", "原价", "折后价", "代金券抵扣", "应付金额"]