ap_balance_flow.sql 486 B

12345678
  1. CREATE TABLE ap_balance_flow (
  2. ABF_ID VARCHAR(20) NOT NULL COMMENT '流水号',
  3. ABF_CREDIT_ID VARCHAR(20) COMMENT '公司信用表主键 ap_credit_inf.ACI_ID',
  4. ABF_TYPE VARCHAR(2) COMMENT '类型:00收款;01出库',
  5. ABF_TYPE_ID VARCHAR(20) COMMENT '收款表或出库表的主键',
  6. ABF_AMOUNT VARCHAR(2) COMMENT '金额',
  7. PRIMARY KEY (ABF_ID)
  8. ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='公司额度流水表';