<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: qianming  
    $Date: 2015-7-6 下午3:39:34  
    $Revision: 1.0  
    $Purpose: 北京国资租赁-发票开票导出
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="BGFL_ACR_INVOICE_INTERFACE_V" defaultOrderBy="invoice_hd_id,line_number">
    <bm:fields>
        <bm:field name="invoice_hd_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INVOICE_HD_ID"/>
        <bm:field name="document_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_NUMBER" prompt="单据号"/>
        <bm:field name="line_number" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LINE_NUMBER" prompt="商品行数"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="购方名称"/>
        <bm:field name="tax_registry_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TAX_REGISTRY_NUM" prompt="购方税号"/>
        <bm:field name="invoice_bp_address_phone_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_ADDRESS_PHONE_NUM" prompt="购方地址电话"/>
        <bm:field name="invoice_bp_bank_account" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_BANK_ACCOUNT" prompt="购方银行帐号"/>
        <bm:field name="note" databaseType="CHAR" datatype="java.lang.String" physicalName="NOTE" prompt="备注"/>
        <bm:field name="confirm_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIRM_NAME" prompt="复核人"/>
        <bm:field name="csh_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_NAME" prompt="收款人"/>
        <bm:field name="line_goods_name" databaseType="CHAR" datatype="java.lang.String" physicalName="LINE_GOODS_NAME" prompt="清单行商品名称"/>
        <bm:field name="invoice_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_DATE" prompt="单据日期"/>
        <bm:field name="invoice_com_bank_account" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_COM_BANK_ACCOUNT" prompt="销方银行帐号"/>
        <bm:field name="invoice_com_address_phone_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_COM_ADDRESS_PHONE_NUM" prompt="销方地址电话"/>
        <bm:field name="document_number_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_NUMBER_2" prompt="单据号"/>
        <bm:field name="line_number_2" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LINE_NUMBER_2" prompt="序号"/>
        <bm:field name="goods_name" databaseType="CHAR" datatype="java.lang.String" physicalName="GOODS_NAME" prompt="货物名称"/>
        <bm:field name="unit" databaseType="CHAR" datatype="java.lang.String" physicalName="UNIT" prompt="计量单位"/>
        <bm:field name="format" databaseType="CHAR" datatype="java.lang.String" physicalName="FORMAT" prompt="规格"/>
        <bm:field name="goods_number" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GOODS_NUMBER" prompt="数量"/>
        <bm:field name="net_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_AMOUNT" prompt="金额"/>
        <bm:field name="tax_type_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TAX_TYPE_RATE" prompt="税率"/>
        <bm:field name="goods_tax_type" databaseType="CHAR" datatype="java.lang.String" physicalName="GOODS_TAX_TYPE" prompt="商品税目"/>
        <bm:field name="discount_amount" databaseType="CHAR" datatype="java.lang.String" physicalName="DISCOUNT_AMOUNT" prompt="折扣金额"/>
        <bm:field name="tax_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_AMOUNT" prompt="税额"/>
        <bm:field name="discount_tax_amount" databaseType="CHAR" datatype="java.lang.String" physicalName="DISCOUNT_TAX_AMOUNT" prompt="折扣税额"/>
        <bm:field name="discount_rate" databaseType="CHAR" datatype="java.lang.String" physicalName="DISCOUNT_RATE" prompt="折扣率"/>
        <bm:field name="unit_price" databaseType="CHAR" datatype="java.lang.String" physicalName="UNIT_PRICE" prompt="单价"/>
        <bm:field name="price_type" databaseType="CHAR" datatype="java.lang.String" physicalName="PRICE_TYPE" prompt="价格方式"/>
    </bm:fields>
    <bm:data-filters>
        <bm:data-filter name="1" enforceOperations="query" expression="t1.invoice_hd_id in ${:@invoice_hd_id}"/>
    </bm:data-filters>
</bm:model>
