结算系统表关系总结
public class BillDetail extends ModelT {private Bill bill;//账单外键private Double totalAmt;//合计金额private Double invoiceAmt;//发票金额private Double verifiedAmt;//核销金额private Double noVerifiedAmt;//未核销金额private String status="NEW";//核销状态private String feeType;//费用类型}
public class Bill extends ModelT { private String billCode;//账单号: 2为年+2位月+3为流水号,如果 12030001,表示是 2012年3月份的第一份账单',private String clientName;//客户名称private String billToCode;//结算方代码private String chargeCodeType;//类型 应收/应付private Date startDate;//账单开始日期private Date endDate;//账单结束日期private double amount=0d;//账单金额private double invoiceAmt=0d;//开票金额private double noInvoiceAmt=0d;//开票金额private double receiptAmt=0d;//收款金额private double notReceiptAmt=0d;private String status=BillStatus.NEW.name();//账单状态private String receiptStatus=BillReceiptStatus.NOT_RECEIPT.name();//收款状态private Date billDate;//账单日期private Integer verfiTimes=0;//核销次数private String auditUser;//审核用户private Date auditDate;//审核时间private String whseNo;private Party billTo;//客户外键private String remark;//账单备注private String warehouse;//仓库private String billChargeStatus;//费用单状态 不做持久化处理private String orderNo;private String orderType;private String paymentStatus=BillReceiptStatus.NOT_RECEIPT.name();private String createUser;//制单人private Date createTime;//制单日期private String editUser;//修改用户private Date editTime;//修改时间private String billType;private String storerKey;//货主private String item;private String itemDesc;private String chargeCode;//费用代码private String uc1;//进库单号}
public class BicCharge extends ModelT{private Date chargeDate; //费用日期private Date busDate; //业务日期private Date settlementDate; //结算日期private String chargeSeq; //费用单号private String billNo; //费用单号private String facilityId; //仓库private String custCode; //往来户private String billTo; //结算方private String orderNo; //业务单号private String orderObject; //业务对象private String orderType; //业务类型private String chargeCode; //收费代码private String chargeCodeType;//费用属性,应收--R 应付--Pprivate String chargeGroup;//费用组private double chargeQty; //计费量private String chargeUom; //计费单位private double chargeRate;//费率private String rateGroup; //费率组private double discount = 1.0; //折扣private String chargeCurrCode = "RMB"; //货币private double chargeAmt; //金额private String minFlag = "N";//最小值private String maxFlag = "N";//最大值private String genmethod; //生成方式private Date fromDate; //包租开始日期private Date toDate; //包租结束日期private Integer days; //期数private String istc;//是否试算private String status;//状态//1录入//2作废//3确认//4关帐private String invoiceType ;//发票类型private String incomeType; //收入类型private double taxRate;private double taxAmt;//税额private double AfterTaxAmt;//税后金额private BillDetail billDetail;private String item;private String itemDesc;private String storerKey;private String chargeType;//费用类型private double verifiedAmt;//核销金额private String verfiedRuningNo;//核销流水号private Date verfiedDate;//核销日期private String uc1;}