<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="com.eapt.vo.EaptFtcontractheader"
table="EAPT_FTCONTRACTHEADER"
dynamic-insert="true"
dynamic-update="true"
>
<id
name="ftcontractno"
type="java.lang.Long"
column="FTCONTRACTNO"
>
<generator class="sequence">
<param name="sequence">SEQ_FTCONTRACTHEADER</param>
</generator>
</id>
<property
name="ftcontractcode"
type="java.lang.String"
column="FTCONTRACTCODE"
not-null="true"
length="40"
/>
<property
name="ftcontractcode2"
type="java.lang.String"
column="FTCONTRACTCODE2"
length="40"
/>
<property
name="bindarticletype"
type="java.lang.String"
column="BINDARTICLETYPE"
length="3"
/>
<property
name="ftcpre"
type="java.lang.String"
column="FTCPRE"
length="2"
/>
<property
name="agentorself"
type="java.lang.String"
column="AGENTORSELF"
length="1"
/>
<property
name="needship"
type="java.lang.String"
column="NEEDSHIP"
length="1"
/>
<property
name="needpklist"
type="java.lang.String"
column="NEEDPKLIST"
length="1"
/>
<property
name="contractype2"
type="java.lang.String"
column="CONTRACTYPE2"
length="3"
/>
<property
name="pocurrency"
type="java.lang.String"
column="POCURRENCY"
length="4"
/>
<property
name="ftccurrency"
type="java.lang.String"
column="FTCCURRENCY"
length="4"
/>
<property
name="tradeterm"
type="java.lang.String"
column="TRADETERM"
length="20"
/>
<property
name="paymentmark"
type="java.lang.String"
column="PAYMENTMARK"
length="20"
/>
<property
name="customdate"
type="java.util.Date"
column="CUSTOMDATE"
length="7"
/>
<property
name="ftcstatus"
type="java.lang.String"
column="FTCSTATUS"
length="3"
/>
<property
name="deliverystatus"
type="java.lang.String"
column="DELIVERYSTATUS"
length="3"
/>
<property
name="customstatus"
type="java.lang.String"
column="CUSTOMSTATUS"
length="3"
/>
<property
name="isfinish"
type="java.lang.String"
column="ISFINISH"
length="1"
/>
<property
name="ishkfinish"
type="java.lang.String"
column="ISHKFINISH"
length="1"
/>
<property
name="ishkfinish2"
type="java.lang.String"
column="ISHKFINISH2"
length="1"
/>
<property
name="isfeefinish"
type="java.lang.String"
column="ISFEEFINISH "
length="1"
/>
<property
name="totalftcqty"
type="java.math.BigDecimal"
column="TOTALFTCQTY"
length="14"
/>
<property
name="totalftcamount"
type="java.math.BigDecimal"
column="TOTALFTCAMOUNT"
length="12"
/>
<property
name="totalpoamount"
type="java.math.BigDecimal"
column="TOTALPOAMOUNT"
length="12"
/>
<property
name="totalpayamount"
type="java.math.BigDecimal"
column="TOTALPAYAMOUNT"
length="12"
/>
<property
name="totalpage"
type="java.lang.Long"
column="TOTALPAGE"
length="22"
/>
<property
name="contractlinecount"
type="java.lang.Long"
column="CONTRACTLINECOUNT"
length="22"
/>
<property
name="prelinecount"
type="java.lang.Long"
column="PRELINECOUNT"
length="22"
/>
<property
name="ntcontractqty"
type="java.math.BigDecimal"
column="NTCONTRACTQTY"
length="14"
/>
<property
name="dispatchlistqty"
type="java.math.BigDecimal"
column="DISPATCHLISTQTY"
length="14"
/>
<property
name="remainforeign"
type="java.math.BigDecimal"
column="REMAINFOREIGN"
length="12"
/>
<property
name="createdby"
type="java.lang.Long"
column="CREATEDBY"
length="22"
/>
<property
name="createdat"
type="java.util.Date"
column="CREATEDAT"
length="7"
/>
<property
name="createdbyname"
type="java.lang.String"
column="CREATEDBYNAME"
length="100"
/>
<property
name="mainregion"
type="java.lang.String"
column="MAINREGION"
length="20"
/>
<property
name="category1"
type="java.lang.String"
column="CATEGORY1"
length="100"
/>
<property
name="category2"
type="java.lang.String"
column="CATEGORY2"
length="100"
/>
<property
name="ftcremarks"
type="java.lang.String"
column="FTCREMARKS"
length="200"
/>
<property
name="operationdept"
type="java.lang.Long"
column="OPERATIONDEPT"
length="22"
/>
<property
name="principal"
type="java.lang.Long"
column="PRINCIPAL"
length="22"
/>
<property
name="relationheader"
type="java.lang.Integer"
column="RELATIONHEADER"
length="22"
/>
<property
name="cifrate"
type="java.math.BigDecimal"
column="CIFRATE"
length="10"
/>
<property
name="isdispatchclose"
type="java.lang.String"
column="ISDISPATCHCLOSE"
length="1"
/>
<property
name="agentinvoiceno"
type="java.lang.Long"
column="AGENTINVOICENO"
length="22"
/>
<property
name="dbnotesno"
type="java.lang.Long"
column="DBNOTESNO"
length="22"
/>
<property
name="needcustome"
type="java.lang.String"
column="NEEDCUSTOME"
length="1"
/>
<property
name="totaltakeamount"
type="java.math.BigDecimal"
column="TOTALTAKEAMOUNT"
length="14"
/>
<property
name="isftcinfo"
type="java.lang.String"
column="ISFTCINFO"
length="1"
/>
<property
name="relationcontractype2"
type="java.lang.String"
column="RELATIONCONTRACTYPE2"
length="3"
/>
<property
name="commitdate"
type="java.util.Date"
column="COMMITDATE"
length="7"
/>
<property
name="commitbyname"
type="java.lang.String"
column="COMMITBYNAME"
length="100"
/>
<property
name="iscisco"
type="java.lang.String"
column="ISCISCO"
length="1"
/>
<property
name="warehouseid2"
type="java.lang.Long"
column="WAREHOUSEID2"
length="22"
/>
<property
name="bommoney"
type="java.math.BigDecimal"
column="BOMMONEY"
length="14"
/>
<property
name="needinsurance"
type="java.lang.String"
column="NEEDINSURANCE"
length="1"
/>
<property
name="receiverclient2"
type="java.lang.String"
column="RECEIVERCLIENT2"
length="200"
/>
<property
name="desctype"
type="java.lang.Long"
column="DESCTYPE"
length="22"
/>
<property
name="shipport"
type="java.lang.String"
column="SHIPPORT"
length="40"
/>
<property
name="targeport"
type="java.lang.String"
column="TARGEPORT"
length="40"
/>
<property
name="outreferenceno"
type="java.lang.Long"
column="OUTREFERENCENO"
length="22"
/>
<!-- Associations -->
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="vendor"
class="com.eapt.vo.EaptCustomer"
not-null="true"
>
<column name="VENDOR" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="receiverclient"
class="com.eapt.vo.EaptCustomer"
not-null="true"
fetch="join"
>
<column name="RECEIVERCLIENT" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="paymentcustomer"
class="com.eapt.vo.EaptCustomer"
not-null="true"
>
<column name="PAYMENTCUSTOMER" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="paymentseller"
class="com.eapt.vo.EaptCustomer"
not-null="true"
>
<column name="PAYMENTSELLER" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="seller"
class="com.eapt.vo.EaptCustomer"
not-null="true"
>
<column name="SELLER" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptCustomer -->
<many-to-one
name="buyer"
class="com.eapt.vo.EaptCustomer"
not-null="true"
>
<column name="BUYER" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptBindarticle -->
<many-to-one
name="eaptBindarticle"
class="com.eapt.vo.EaptBindarticle"
not-null="true"
>
<column name="BINDARTICLENO" />
</many-to-one>
<!-- bi-directional one-to-many association to EaptPaymentapportion -->
<set
name="eaptPaymentapportions"
lazy="true"
inverse="true"
cascade="none"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<one-to-many
class="com.eapt.vo.EaptPaymentapportion"
/>
</set>
<!-- bi-directional one-to-many association to EaptFtcontractline -->
<set
name="eaptFtcontractlines"
lazy="true"
inverse="true"
order-by="FTCONTRACTLINENO2 asc, FTCONTRACTLINENO asc"
cascade="all-delete-orphan"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<one-to-many
class="com.eapt.vo.EaptFtcontractline"
/>
</set>
<!-- bi-directional one-to-many association to EaptAgentinvoiceline -->
<set
name="eaptAgentinvoicelines"
lazy="true"
inverse="true"
cascade="none"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<one-to-many
class="com.eapt.vo.EaptAgentinvoiceline"
/>
</set>
<!-- bi-directional many-to-many association to EaptDispatchlistheader -->
<set
name="eaptDispatchlistheaders"
lazy="true"
inverse="true"
cascade="none"
table="EAPT_FTCONTRACT_DISPATCHLIST"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<many-to-many
class="com.eapt.vo.EaptDispatchlistheader"
>
<column name="DISPATCHLISTNO" />
</many-to-many>
</set>
<!-- bi-directional many-to-many association to EaptPoheader -->
<set
name="eaptPoheaders"
lazy="true"
inverse="true"
cascade="none"
table="EAPT_FTCONTRACT_POHEADER"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<many-to-many
class="com.eapt.vo.EaptPoheader"
>
<column name="PONO" />
</many-to-many>
</set>
<!-- bi-directional many-to-many association to EaptNtcontractheader -->
<set
name="eaptNtcontractheaders"
lazy="true"
inverse="true"
cascade="none"
table="EAPT_FTC_NTC"
>
<key>
<column name="FTCONTRACTNO" />
</key>
<many-to-many
class="com.eapt.vo.EaptNtcontractheader"
>
<column name="NTCONTRACTNO" />
</many-to-many>
</set>
<!-- bi-directional many-to-one association to EaptFtcontractheader2 -->
<many-to-one
name="ftcontractheader2"
class="com.eapt.vo.EaptFtcontractheader2"
not-null="true"
insert="false"
update="false"
>
<column name="FTCONTRACTNO" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptFtcontractheader4 -->
<many-to-one
name="ftcontractheader4"
class="com.eapt.vo.EaptFtcontractheader4"
not-null="true"
insert="false"
update="false"
>
<column name="FTCONTRACTNO" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptFtcontractheader5 -->
<many-to-one
name="ftcontractheader5"
class="com.eapt.vo.EaptFtcontractheader5"
not-null="true"
insert="false"
update="false"
>
<column name="FTCONTRACTNO" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptFtcontractheader5 -->
<many-to-one
name="ftcontractheader6"
class="com.eapt.vo.EaptFtcontractheader6"
not-null="true"
insert="false"
update="false"
>
<column name="FTCONTRACTNO" />
</many-to-one>
<!-- bi-directional many-to-one association to EaptFtcontractheader -->
<many-to-one
name="relationftcontract"
class="com.eapt.vo.EaptFtcontractheader"
fetch="join"
>
<column name="RELATIONFTCONTRACTNO" />
</many-to-one>
</class>
</hibernate-mapping>