结算系统表关系小结
结算系统表关系总结
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 应付--P private 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; }