<?xml version="1.0"?>

<!-- Contribution Import Utility XmlFormatFile - This file is used to define which columns will be used in the file import process. -->

<!-- Fields can be assigned in any order and fields may be omitted provided the minimum data requirements are met to create a -->

<!-- new constituent record within the system. Where possible, system defaults and configuration apply to the creation. -->

<!-- If you wish to omit certain columns from the import format specification, it is best to comment out the element -->

<!-- (using comment XML tags) over removing the element entirely.-->

<BCPFORMAT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format">


<RECORD>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="100" TERMINATOR="\t" xsi:type="CharTerm" ID="import_account_id"/> -->
 
<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="100" TERMINATOR="\t" xsi:type="CharTerm" ID="import_ref_no"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="cust_type"/>

<FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="customer_no"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="prefix"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="fname"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="mname"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="55" TERMINATOR="\t" xsi:type="CharTerm" ID="lname"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="suffix"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="prefix2"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="fname2"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="mname2"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="55" TERMINATOR="\t" xsi:type="CharTerm" ID="lname2"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="suffix2"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="64" TERMINATOR="\t" xsi:type="CharTerm" ID="street1"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="64" TERMINATOR="\t" xsi:type="CharTerm" ID="street2"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="64" TERMINATOR="\t" xsi:type="CharTerm" ID="street3"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="city"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="state"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="postal_code"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="country"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="32" TERMINATOR="\t" xsi:type="CharTerm" ID="phone1"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="32" TERMINATOR="\t" xsi:type="CharTerm" ID="phone2"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="80" TERMINATOR="\t" xsi:type="CharTerm" ID="eaddress"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="pmt_method"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="account_name"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="account_number"/> -->

<!-- <FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="exp_date"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="check_number"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="campaign"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="fund"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="designation"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="source"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="channel"/> -->

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="notes"/>

<FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="cont_dt"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="billing_type"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="30" TERMINATOR="\t" xsi:type="CharTerm" ID="billing_schedule"/> -->

<!-- <FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="billing_start_dt"/> -->

<!-- <FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="billing_end_dt"/> -->

<!-- <FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="num_payments"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="10" TERMINATOR="\t" xsi:type="CharTerm" ID="decline_ben_ind"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="3" TERMINATOR="\t" xsi:type="CharTerm" ID="memb_level"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="creditee"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="20" TERMINATOR="\t" xsi:type="CharTerm" ID="creditee_type"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_1"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_2"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_3"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_4"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_5"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_6"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_7"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_8"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_9"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="custom_0"/> -->

<FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="cont_amt"/>

<FIELD TERMINATOR="\t" xsi:type="CharTerm" ID="recd_amt"/>

<FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\r\n" xsi:type="CharTerm" ID="local_use0"/>

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use1"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use2"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\r\n" xsi:type="CharTerm" ID="local_use3"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use4"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use5"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use6"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use7"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\t" xsi:type="CharTerm" ID="local_use8"/> -->

<!-- <FIELD COLLATION="SQL_Latin1_General_CP1_CI_AS" MAX_LENGTH="255" TERMINATOR="\r\n" xsi:type="CharTerm" ID="local_use9"/> -->

<!-- The last line of the record node should have a TERMINATOR="\r\n" to indicate the end of the import row. -->


</RECORD>


<ROW>

<!-- These columns are mapped using the SOURCE attribute value, not by order. -->


<!-- The Source attribute value must match the "ID" attribute from the Record section above. -->


<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="import_account_id" SOURCE="import_account_id"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="import_ref_no" SOURCE="import_ref_no"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="cust_type" SOURCE="cust_type"/>

<COLUMN xsi:type="SQLINT" NAME="customer_no" SOURCE="customer_no"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="prefix" SOURCE="prefix"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="fname" SOURCE="fname"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="mname" SOURCE="mname"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="lname" SOURCE="lname"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="suffix" SOURCE="suffix"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="prefix2" SOURCE="prefix2"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="fname2" SOURCE="fname2"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="mname2" SOURCE="mname2"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="lname2" SOURCE="lname2"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="suffix2" SOURCE="suffix2"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="street1" SOURCE="street1"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="street2" SOURCE="street2"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="street3" SOURCE="street3"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="city" SOURCE="city"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="state" SOURCE="state"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="postal_code" SOURCE="postal_code"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="country" SOURCE="country"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="phone1" SOURCE="phone1"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="phone2" SOURCE="phone2"/>

<COLUMN xsi:type="SQLVARYCHAR" NAME="eaddress" SOURCE="eaddress"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="pmt_method" SOURCE="pmt_method"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="account_name" SOURCE="account_name"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="account_number" SOURCE="account_number"/> -->

<!-- <COLUMN xsi:type="SQLDATETIME" NAME="exp_date" SOURCE="exp_date"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="check_number" SOURCE="check_number"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="campaign" SOURCE="campaign"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="fund" SOURCE="fund"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="designation" SOURCE="designation"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="source" SOURCE="source"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="channel" SOURCE="channel"/> -->

<COLUMN xsi:type="SQLVARYCHAR" NAME="notes" SOURCE="notes"/>

<COLUMN xsi:type="SQLDATETIME" NAME="cont_dt" SOURCE="cont_dt"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="billing_type" SOURCE="billing_type"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="billing_schedule" SOURCE="billing_schedule"/> -->

<!-- <COLUMN xsi:type="SQLDATETIME" NAME="billing_start_dt" SOURCE="billing_start_dt"/> -->

<!-- <COLUMN xsi:type="SQLDATETIME" NAME="billing_end_dt" SOURCE="billing_end_dt"/> -->

<!-- <COLUMN xsi:type="SQLINT" NAME="num_payments" SOURCE="num_payments"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="decline_ben_ind" SOURCE="decline_ben_ind"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="memb_level" SOURCE="memb_level"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="creditee" SOURCE="creditee"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="creditee_type" SOURCE="creditee_type"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_1" SOURCE="custom_1"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_2" SOURCE="custom_2"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_3" SOURCE="custom_3"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_4" SOURCE="custom_4"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_5" SOURCE="custom_5"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_6" SOURCE="custom_6"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_7" SOURCE="custom_7"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_8" SOURCE="custom_8"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_9" SOURCE="custom_9"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="custom_0" SOURCE="custom_0"/> -->

<COLUMN xsi:type="SQLMONEY" NAME="cont_amt" SOURCE="cont_amt"/>

<COLUMN xsi:type="SQLMONEY" NAME="recd_amt" SOURCE="recd_amt"/>

<COLUMN xsi:type="SQLINT" NAME="local_use0" SOURCE="local_use0"/>

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use1" SOURCE="local_use1"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use2" SOURCE="local_use2"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use3" SOURCE="local_use3"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use4" SOURCE="local_use4"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use5" SOURCE="local_use5"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use6" SOURCE="local_use6"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use7" SOURCE="local_use7"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use8" SOURCE="local_use8"/> -->

<!-- <COLUMN xsi:type="SQLVARYCHAR" NAME="local_use9" SOURCE="local_use9"/> -->

</ROW>

</BCPFORMAT>