home *** CD-ROM | disk | FTP | other *** search
/ 61.19.244.139 / 61.19.244.139.zip / 61.19.244.139 / wsCompulTransfer / RT / DS / DS_PRINT_PRB.xsd next >
Extensible Markup Language  |  2013-06-07  |  48KB  |  919 lines
  1. ∩╗┐<?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="DS_PRINT_PRB" targetNamespace="http://tempuri.org/DS_PRINT_PRB.xsd" xmlns:mstns="http://tempuri.org/DS_PRINT_PRB.xsd" xmlns="http://tempuri.org/DS_PRINT_PRB.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  3.   <xs:annotation>
  4.     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5.       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6.         <Connections>
  7.           <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="wCompulWeb" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="wCompulWeb (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.wCompulWeb.ConnectionString" Provider="System.Data.SqlClient" />
  8.         </Connections>
  9.         <Tables>
  10.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" Name="DataTable1">
  11.             <MainSource>
  12.               <DbSource ConnectionRef="wCompulWeb (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false">
  13.                 <SelectCommand>
  14.                   <DbCommand CommandType="Text" ModifiedByUser="true">
  15.                     <CommandText>SELECT     b_agency_web.i_ag, b_agency_web.c_initial, b_agency_web.c_ag_name, b_agency_web.c_ag_lastname, b_agency_web.c_add1, 
  16.                       b_agency_web.c_add2, b_agency_web.c_tel, b_agency_web.d_born, b_agency_web.c_idcard, b_agency_web.c_idcard_b, b_agency_web.d_idcard_st, 
  17.                       b_agency_web.d_idcard_exp, b_agency_web.f_sale_prb, b_agency_web.m_cash, b_agency_web.i_cheque_no, b_agency_web.d_cheque_due, 
  18.                       b_agency_web.m_cheque, b_agency_web.i_bank, b_agency_web.i_branch, b_agency_web.i_lg_code, b_agency_web.d_lg, b_agency_web.m_lg, 
  19.                       b_agency_web.d_lg_due, b_agency_web.c_lg_bank, b_agency_web.c_lg_branch, b_agency_web.i_land_code, b_agency_web.i_land_no, 
  20.                       b_agency_web.c_land_area, b_agency_web.c_land_add, b_agency_web.c_subdistrict, b_agency_web.i_district, b_agency_web.prov_id, 
  21.                       b_agency_web.m_land, b_agency_web.c_pa_name, b_agency_web.d_update, b_agency_web.n_ratio_m, b_agency_web.n_ratio_o, 
  22.                       b_agency_web.c_ag_licence, b_agency_web.c_taxagen, b_agency_web.F_RecUserID, b_agency_web.F_RecClient, b_agency_web.F_RecDateTime, 
  23.                       b_agency_web.F_RecStatus, b_agency_web.F_ag_type, b_id_car_brand.i_car_brand, b_id_car_brand.c_brand_code, b_id_car_brand.c_car_brand, 
  24.                       b_id_car_brand.i_userid, b_id_car_brand.d_updated, b_id_car_brand.i_car_brand_ref, b_id_car_brand.f_status, b_id_car_brand.d_status, 
  25.                       b_id_car_brand.i_status, b_id_car_brand.d_create, b_id_car_brand.i_create, b_id_car_brand.d_approve, b_id_car_brand.i_approve, 
  26.                       b_id_car_brand.d_used, b_id_car_brand.d_expire, b_id_car_brand.f_tranf_risc, b_initial.i_initial, b_initial.n_initial, b_initial.n_no, c_pol_web.c_bun, 
  27.                       c_pol_web.s_type, c_pol_web.e_pol_no, c_pol_web.e_barcode, c_pol_web.f_calc_type, c_pol_web.d_begin, c_pol_web.d_end, c_pol_web.d_issue, 
  28.                       c_pol_web.d_agree, c_pol_web.f_agen_type, c_pol_web.i_ag AS Expr1, c_pol_web.c_ag_name AS Expr2, c_pol_web.c_ag_lastname AS Expr3, 
  29.                       c_pol_web.c_ag_licence AS Expr4, c_pol_web.i_initial AS Expr5, c_pol_web.c_name, c_pol_web.c_lastname, c_pol_web.c_address1, 
  30.                       c_pol_web.c_address2, c_pol_web.i_province, c_pol_web.i_zipcode, c_pol_web.c_licence, c_pol_web.i_prov_licence, c_pol_web.i_car_make, 
  31.                       c_pol_web.i_car_model, c_pol_web.c_chassis, c_pol_web.c_body, c_pol_web.c_engine, c_pol_web.c_color, c_pol_web.i_veh, c_pol_web.i_usage, 
  32.                       c_pol_web.i_veh_size, c_pol_web.q_disp, c_pol_web.q_seat, c_pol_web.q_gvw, c_pol_web.m_pm, c_pol_web.p_disc_direct, 
  33.                       c_pol_web.m_disc_direct, c_pol_web.m_duty, c_pol_web.p_vat, c_pol_web.m_tax, c_pol_web.m_gross, c_pol_web.e_bookno, c_pol_web.e_receipt, 
  34.                       c_pol_web.f_status AS Expr6, c_pol_web.d_key, c_pol_web.i_key, c_pol_web.d_send_pol, c_pol_web.i_send_pol, c_pol_web.n_usage, 
  35.                       c_pol_web.i_ag_main, c_pol_web.f_transfer, c_pol_web.d_transfer, c_pol_web.f_Export, c_pol_web.d_Export, MO_TYPE_USAGE.TU_Eff_Date, 
  36.                       MO_TYPE_USAGE.TU_Type_Code, MO_TYPE_USAGE.TU_Usage_Code, MO_TYPE_USAGE.TU_Desc, MO_TYPE_USAGE.TU_Usage_Desc, 
  37.                       MO_TYPE_USAGE.TU_Pol_Txt, MO_TYPE_USAGE.TU_No_Seat, MO_TYPE_USAGE.TU_Create_Date, MO_TYPE_USAGE.TU_Update_Date, 
  38.                       MO_TYPE_USAGE.s_type AS Expr7, b_changwat.i_changwat, b_changwat.n_changwat, b_changwat.i_group, b_changwat.i_changwat2, 
  39.                       b_changwat.i_zone, b_agent.name, c_stick_web.i_agen_code# AS i_agen_code2, c_stick_web.i_agen_code
  40. FROM         b_agency_web INNER JOIN
  41.                       c_pol_web ON b_agency_web.i_ag = c_pol_web.i_ag INNER JOIN
  42.                       c_stick_web ON c_pol_web.e_pol_no = c_stick_web.e_pol_no INNER JOIN
  43.                       b_agent ON b_agency_web.c_taxagen = b_agent.agcd CROSS JOIN
  44.                       MO_TYPE_USAGE CROSS JOIN
  45.                       b_changwat CROSS JOIN
  46.                       b_initial CROSS JOIN
  47.                       b_id_car_brand</CommandText>
  48.                     <Parameters />
  49.                   </DbCommand>
  50.                 </SelectCommand>
  51.               </DbSource>
  52.             </MainSource>
  53.             <Mappings>
  54.               <Mapping SourceColumn="i_ag" DataSetColumn="i_ag" />
  55.               <Mapping SourceColumn="c_initial" DataSetColumn="c_initial" />
  56.               <Mapping SourceColumn="c_ag_name" DataSetColumn="c_ag_name" />
  57.               <Mapping SourceColumn="c_ag_lastname" DataSetColumn="c_ag_lastname" />
  58.               <Mapping SourceColumn="c_add1" DataSetColumn="c_add1" />
  59.               <Mapping SourceColumn="c_add2" DataSetColumn="c_add2" />
  60.               <Mapping SourceColumn="c_tel" DataSetColumn="c_tel" />
  61.               <Mapping SourceColumn="d_born" DataSetColumn="d_born" />
  62.               <Mapping SourceColumn="c_idcard" DataSetColumn="c_idcard" />
  63.               <Mapping SourceColumn="c_idcard_b" DataSetColumn="c_idcard_b" />
  64.               <Mapping SourceColumn="d_idcard_st" DataSetColumn="d_idcard_st" />
  65.               <Mapping SourceColumn="d_idcard_exp" DataSetColumn="d_idcard_exp" />
  66.               <Mapping SourceColumn="f_sale_prb" DataSetColumn="f_sale_prb" />
  67.               <Mapping SourceColumn="m_cash" DataSetColumn="m_cash" />
  68.               <Mapping SourceColumn="i_cheque_no" DataSetColumn="i_cheque_no" />
  69.               <Mapping SourceColumn="d_cheque_due" DataSetColumn="d_cheque_due" />
  70.               <Mapping SourceColumn="m_cheque" DataSetColumn="m_cheque" />
  71.               <Mapping SourceColumn="i_bank" DataSetColumn="i_bank" />
  72.               <Mapping SourceColumn="i_branch" DataSetColumn="i_branch" />
  73.               <Mapping SourceColumn="i_lg_code" DataSetColumn="i_lg_code" />
  74.               <Mapping SourceColumn="d_lg" DataSetColumn="d_lg" />
  75.               <Mapping SourceColumn="m_lg" DataSetColumn="m_lg" />
  76.               <Mapping SourceColumn="d_lg_due" DataSetColumn="d_lg_due" />
  77.               <Mapping SourceColumn="c_lg_bank" DataSetColumn="c_lg_bank" />
  78.               <Mapping SourceColumn="c_lg_branch" DataSetColumn="c_lg_branch" />
  79.               <Mapping SourceColumn="i_land_code" DataSetColumn="i_land_code" />
  80.               <Mapping SourceColumn="i_land_no" DataSetColumn="i_land_no" />
  81.               <Mapping SourceColumn="c_land_area" DataSetColumn="c_land_area" />
  82.               <Mapping SourceColumn="c_land_add" DataSetColumn="c_land_add" />
  83.               <Mapping SourceColumn="c_subdistrict" DataSetColumn="c_subdistrict" />
  84.               <Mapping SourceColumn="i_district" DataSetColumn="i_district" />
  85.               <Mapping SourceColumn="prov_id" DataSetColumn="prov_id" />
  86.               <Mapping SourceColumn="m_land" DataSetColumn="m_land" />
  87.               <Mapping SourceColumn="c_pa_name" DataSetColumn="c_pa_name" />
  88.               <Mapping SourceColumn="d_update" DataSetColumn="d_update" />
  89.               <Mapping SourceColumn="n_ratio_m" DataSetColumn="n_ratio_m" />
  90.               <Mapping SourceColumn="n_ratio_o" DataSetColumn="n_ratio_o" />
  91.               <Mapping SourceColumn="c_ag_licence" DataSetColumn="c_ag_licence" />
  92.               <Mapping SourceColumn="c_taxagen" DataSetColumn="c_taxagen" />
  93.               <Mapping SourceColumn="F_RecUserID" DataSetColumn="F_RecUserID" />
  94.               <Mapping SourceColumn="F_RecClient" DataSetColumn="F_RecClient" />
  95.               <Mapping SourceColumn="F_RecDateTime" DataSetColumn="F_RecDateTime" />
  96.               <Mapping SourceColumn="F_RecStatus" DataSetColumn="F_RecStatus" />
  97.               <Mapping SourceColumn="F_ag_type" DataSetColumn="F_ag_type" />
  98.               <Mapping SourceColumn="i_car_brand" DataSetColumn="i_car_brand" />
  99.               <Mapping SourceColumn="c_brand_code" DataSetColumn="c_brand_code" />
  100.               <Mapping SourceColumn="c_car_brand" DataSetColumn="c_car_brand" />
  101.               <Mapping SourceColumn="i_userid" DataSetColumn="i_userid" />
  102.               <Mapping SourceColumn="d_updated" DataSetColumn="d_updated" />
  103.               <Mapping SourceColumn="i_car_brand_ref" DataSetColumn="i_car_brand_ref" />
  104.               <Mapping SourceColumn="f_status" DataSetColumn="f_status" />
  105.               <Mapping SourceColumn="d_status" DataSetColumn="d_status" />
  106.               <Mapping SourceColumn="i_status" DataSetColumn="i_status" />
  107.               <Mapping SourceColumn="d_create" DataSetColumn="d_create" />
  108.               <Mapping SourceColumn="i_create" DataSetColumn="i_create" />
  109.               <Mapping SourceColumn="d_approve" DataSetColumn="d_approve" />
  110.               <Mapping SourceColumn="i_approve" DataSetColumn="i_approve" />
  111.               <Mapping SourceColumn="d_used" DataSetColumn="d_used" />
  112.               <Mapping SourceColumn="d_expire" DataSetColumn="d_expire" />
  113.               <Mapping SourceColumn="f_tranf_risc" DataSetColumn="f_tranf_risc" />
  114.               <Mapping SourceColumn="i_initial" DataSetColumn="i_initial" />
  115.               <Mapping SourceColumn="n_initial" DataSetColumn="n_initial" />
  116.               <Mapping SourceColumn="n_no" DataSetColumn="n_no" />
  117.               <Mapping SourceColumn="c_bun" DataSetColumn="c_bun" />
  118.               <Mapping SourceColumn="s_type" DataSetColumn="s_type" />
  119.               <Mapping SourceColumn="e_pol_no" DataSetColumn="e_pol_no" />
  120.               <Mapping SourceColumn="e_barcode" DataSetColumn="e_barcode" />
  121.               <Mapping SourceColumn="f_calc_type" DataSetColumn="f_calc_type" />
  122.               <Mapping SourceColumn="d_begin" DataSetColumn="d_begin" />
  123.               <Mapping SourceColumn="d_end" DataSetColumn="d_end" />
  124.               <Mapping SourceColumn="d_issue" DataSetColumn="d_issue" />
  125.               <Mapping SourceColumn="d_agree" DataSetColumn="d_agree" />
  126.               <Mapping SourceColumn="f_agen_type" DataSetColumn="f_agen_type" />
  127.               <Mapping SourceColumn="c_name" DataSetColumn="c_name" />
  128.               <Mapping SourceColumn="c_lastname" DataSetColumn="c_lastname" />
  129.               <Mapping SourceColumn="c_address1" DataSetColumn="c_address1" />
  130.               <Mapping SourceColumn="c_address2" DataSetColumn="c_address2" />
  131.               <Mapping SourceColumn="i_province" DataSetColumn="i_province" />
  132.               <Mapping SourceColumn="i_zipcode" DataSetColumn="i_zipcode" />
  133.               <Mapping SourceColumn="c_licence" DataSetColumn="c_licence" />
  134.               <Mapping SourceColumn="i_prov_licence" DataSetColumn="i_prov_licence" />
  135.               <Mapping SourceColumn="i_car_make" DataSetColumn="i_car_make" />
  136.               <Mapping SourceColumn="i_car_model" DataSetColumn="i_car_model" />
  137.               <Mapping SourceColumn="c_chassis" DataSetColumn="c_chassis" />
  138.               <Mapping SourceColumn="c_body" DataSetColumn="c_body" />
  139.               <Mapping SourceColumn="c_engine" DataSetColumn="c_engine" />
  140.               <Mapping SourceColumn="c_color" DataSetColumn="c_color" />
  141.               <Mapping SourceColumn="i_veh" DataSetColumn="i_veh" />
  142.               <Mapping SourceColumn="i_usage" DataSetColumn="i_usage" />
  143.               <Mapping SourceColumn="i_veh_size" DataSetColumn="i_veh_size" />
  144.               <Mapping SourceColumn="q_disp" DataSetColumn="q_disp" />
  145.               <Mapping SourceColumn="q_seat" DataSetColumn="q_seat" />
  146.               <Mapping SourceColumn="q_gvw" DataSetColumn="q_gvw" />
  147.               <Mapping SourceColumn="m_pm" DataSetColumn="m_pm" />
  148.               <Mapping SourceColumn="p_disc_direct" DataSetColumn="p_disc_direct" />
  149.               <Mapping SourceColumn="m_disc_direct" DataSetColumn="m_disc_direct" />
  150.               <Mapping SourceColumn="m_duty" DataSetColumn="m_duty" />
  151.               <Mapping SourceColumn="p_vat" DataSetColumn="p_vat" />
  152.               <Mapping SourceColumn="m_tax" DataSetColumn="m_tax" />
  153.               <Mapping SourceColumn="m_gross" DataSetColumn="m_gross" />
  154.               <Mapping SourceColumn="e_bookno" DataSetColumn="e_bookno" />
  155.               <Mapping SourceColumn="e_receipt" DataSetColumn="e_receipt" />
  156.               <Mapping SourceColumn="d_key" DataSetColumn="d_key" />
  157.               <Mapping SourceColumn="i_key" DataSetColumn="i_key" />
  158.               <Mapping SourceColumn="d_send_pol" DataSetColumn="d_send_pol" />
  159.               <Mapping SourceColumn="i_send_pol" DataSetColumn="i_send_pol" />
  160.               <Mapping SourceColumn="n_usage" DataSetColumn="n_usage" />
  161.               <Mapping SourceColumn="i_ag_main" DataSetColumn="i_ag_main" />
  162.               <Mapping SourceColumn="f_transfer" DataSetColumn="f_transfer" />
  163.               <Mapping SourceColumn="d_transfer" DataSetColumn="d_transfer" />
  164.               <Mapping SourceColumn="f_Export" DataSetColumn="f_Export" />
  165.               <Mapping SourceColumn="d_Export" DataSetColumn="d_Export" />
  166.               <Mapping SourceColumn="TU_Eff_Date" DataSetColumn="TU_Eff_Date" />
  167.               <Mapping SourceColumn="TU_Type_Code" DataSetColumn="TU_Type_Code" />
  168.               <Mapping SourceColumn="TU_Usage_Code" DataSetColumn="TU_Usage_Code" />
  169.               <Mapping SourceColumn="TU_Desc" DataSetColumn="TU_Desc" />
  170.               <Mapping SourceColumn="TU_Usage_Desc" DataSetColumn="TU_Usage_Desc" />
  171.               <Mapping SourceColumn="TU_Pol_Txt" DataSetColumn="TU_Pol_Txt" />
  172.               <Mapping SourceColumn="TU_No_Seat" DataSetColumn="TU_No_Seat" />
  173.               <Mapping SourceColumn="TU_Create_Date" DataSetColumn="TU_Create_Date" />
  174.               <Mapping SourceColumn="TU_Update_Date" DataSetColumn="TU_Update_Date" />
  175.               <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  176.               <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
  177.               <Mapping SourceColumn="Expr3" DataSetColumn="Expr3" />
  178.               <Mapping SourceColumn="Expr4" DataSetColumn="Expr4" />
  179.               <Mapping SourceColumn="Expr5" DataSetColumn="Expr5" />
  180.               <Mapping SourceColumn="Expr6" DataSetColumn="Expr6" />
  181.               <Mapping SourceColumn="Expr7" DataSetColumn="Expr7" />
  182.               <Mapping SourceColumn="i_changwat" DataSetColumn="i_changwat" />
  183.               <Mapping SourceColumn="n_changwat" DataSetColumn="n_changwat" />
  184.               <Mapping SourceColumn="i_group" DataSetColumn="i_group" />
  185.               <Mapping SourceColumn="i_changwat2" DataSetColumn="i_changwat2" />
  186.               <Mapping SourceColumn="i_zone" DataSetColumn="i_zone" />
  187.               <Mapping SourceColumn="name" DataSetColumn="name" />
  188.               <Mapping SourceColumn="i_agen_code" DataSetColumn="i_agen_code" />
  189.               <Mapping SourceColumn="i_agen_code2" DataSetColumn="i_agen_code2" />
  190.             </Mappings>
  191.             <Sources />
  192.           </TableAdapter>
  193.         </Tables>
  194.         <Sources />
  195.       </DataSource>
  196.     </xs:appinfo>
  197.   </xs:annotation>
  198.   <xs:element name="DS_PRINT_PRB" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
  199.     <xs:complexType>
  200.       <xs:choice minOccurs="0" maxOccurs="unbounded">
  201.         <xs:element name="DataTable1">
  202.           <xs:complexType>
  203.             <xs:sequence>
  204.               <xs:element name="i_ag">
  205.                 <xs:simpleType>
  206.                   <xs:restriction base="xs:string">
  207.                     <xs:maxLength value="6" />
  208.                   </xs:restriction>
  209.                 </xs:simpleType>
  210.               </xs:element>
  211.               <xs:element name="c_initial" minOccurs="0">
  212.                 <xs:simpleType>
  213.                   <xs:restriction base="xs:string">
  214.                     <xs:maxLength value="10" />
  215.                   </xs:restriction>
  216.                 </xs:simpleType>
  217.               </xs:element>
  218.               <xs:element name="c_ag_name" minOccurs="0">
  219.                 <xs:simpleType>
  220.                   <xs:restriction base="xs:string">
  221.                     <xs:maxLength value="60" />
  222.                   </xs:restriction>
  223.                 </xs:simpleType>
  224.               </xs:element>
  225.               <xs:element name="c_ag_lastname" minOccurs="0">
  226.                 <xs:simpleType>
  227.                   <xs:restriction base="xs:string">
  228.                     <xs:maxLength value="30" />
  229.                   </xs:restriction>
  230.                 </xs:simpleType>
  231.               </xs:element>
  232.               <xs:element name="c_add1" minOccurs="0">
  233.                 <xs:simpleType>
  234.                   <xs:restriction base="xs:string">
  235.                     <xs:maxLength value="200" />
  236.                   </xs:restriction>
  237.                 </xs:simpleType>
  238.               </xs:element>
  239.               <xs:element name="c_add2" minOccurs="0">
  240.                 <xs:simpleType>
  241.                   <xs:restriction base="xs:string">
  242.                     <xs:maxLength value="60" />
  243.                   </xs:restriction>
  244.                 </xs:simpleType>
  245.               </xs:element>
  246.               <xs:element name="c_tel" minOccurs="0">
  247.                 <xs:simpleType>
  248.                   <xs:restriction base="xs:string">
  249.                     <xs:maxLength value="30" />
  250.                   </xs:restriction>
  251.                 </xs:simpleType>
  252.               </xs:element>
  253.               <xs:element name="d_born" type="xs:dateTime" minOccurs="0" />
  254.               <xs:element name="c_idcard" minOccurs="0">
  255.                 <xs:simpleType>
  256.                   <xs:restriction base="xs:string">
  257.                     <xs:maxLength value="13" />
  258.                   </xs:restriction>
  259.                 </xs:simpleType>
  260.               </xs:element>
  261.               <xs:element name="c_idcard_b" minOccurs="0">
  262.                 <xs:simpleType>
  263.                   <xs:restriction base="xs:string">
  264.                     <xs:maxLength value="30" />
  265.                   </xs:restriction>
  266.                 </xs:simpleType>
  267.               </xs:element>
  268.               <xs:element name="d_idcard_st" type="xs:dateTime" minOccurs="0" />
  269.               <xs:element name="d_idcard_exp" type="xs:dateTime" minOccurs="0" />
  270.               <xs:element name="f_sale_prb" minOccurs="0">
  271.                 <xs:simpleType>
  272.                   <xs:restriction base="xs:string">
  273.                     <xs:maxLength value="1" />
  274.                   </xs:restriction>
  275.                 </xs:simpleType>
  276.               </xs:element>
  277.               <xs:element name="m_cash" type="xs:decimal" minOccurs="0" />
  278.               <xs:element name="i_cheque_no" minOccurs="0">
  279.                 <xs:simpleType>
  280.                   <xs:restriction base="xs:string">
  281.                     <xs:maxLength value="10" />
  282.                   </xs:restriction>
  283.                 </xs:simpleType>
  284.               </xs:element>
  285.               <xs:element name="d_cheque_due" type="xs:dateTime" minOccurs="0" />
  286.               <xs:element name="m_cheque" type="xs:decimal" minOccurs="0" />
  287.               <xs:element name="i_bank" minOccurs="0">
  288.                 <xs:simpleType>
  289.                   <xs:restriction base="xs:string">
  290.                     <xs:maxLength value="6" />
  291.                   </xs:restriction>
  292.                 </xs:simpleType>
  293.               </xs:element>
  294.               <xs:element name="i_branch" minOccurs="0">
  295.                 <xs:simpleType>
  296.                   <xs:restriction base="xs:string">
  297.                     <xs:maxLength value="30" />
  298.                   </xs:restriction>
  299.                 </xs:simpleType>
  300.               </xs:element>
  301.               <xs:element name="i_lg_code" minOccurs="0">
  302.                 <xs:simpleType>
  303.                   <xs:restriction base="xs:string">
  304.                     <xs:maxLength value="20" />
  305.                   </xs:restriction>
  306.                 </xs:simpleType>
  307.               </xs:element>
  308.               <xs:element name="d_lg" type="xs:dateTime" minOccurs="0" />
  309.               <xs:element name="m_lg" type="xs:decimal" minOccurs="0" />
  310.               <xs:element name="d_lg_due" type="xs:dateTime" minOccurs="0" />
  311.               <xs:element name="c_lg_bank" minOccurs="0">
  312.                 <xs:simpleType>
  313.                   <xs:restriction base="xs:string">
  314.                     <xs:maxLength value="6" />
  315.                   </xs:restriction>
  316.                 </xs:simpleType>
  317.               </xs:element>
  318.               <xs:element name="c_lg_branch" minOccurs="0">
  319.                 <xs:simpleType>
  320.                   <xs:restriction base="xs:string">
  321.                     <xs:maxLength value="30" />
  322.                   </xs:restriction>
  323.                 </xs:simpleType>
  324.               </xs:element>
  325.               <xs:element name="i_land_code" minOccurs="0">
  326.                 <xs:simpleType>
  327.                   <xs:restriction base="xs:string">
  328.                     <xs:maxLength value="30" />
  329.                   </xs:restriction>
  330.                 </xs:simpleType>
  331.               </xs:element>
  332.               <xs:element name="i_land_no" minOccurs="0">
  333.                 <xs:simpleType>
  334.                   <xs:restriction base="xs:string">
  335.                     <xs:maxLength value="30" />
  336.                   </xs:restriction>
  337.                 </xs:simpleType>
  338.               </xs:element>
  339.               <xs:element name="c_land_area" minOccurs="0">
  340.                 <xs:simpleType>
  341.                   <xs:restriction base="xs:string">
  342.                     <xs:maxLength value="30" />
  343.                   </xs:restriction>
  344.                 </xs:simpleType>
  345.               </xs:element>
  346.               <xs:element name="c_land_add" minOccurs="0">
  347.                 <xs:simpleType>
  348.                   <xs:restriction base="xs:string">
  349.                     <xs:maxLength value="70" />
  350.                   </xs:restriction>
  351.                 </xs:simpleType>
  352.               </xs:element>
  353.               <xs:element name="c_subdistrict" minOccurs="0">
  354.                 <xs:simpleType>
  355.                   <xs:restriction base="xs:string">
  356.                     <xs:maxLength value="30" />
  357.                   </xs:restriction>
  358.                 </xs:simpleType>
  359.               </xs:element>
  360.               <xs:element name="i_district" minOccurs="0">
  361.                 <xs:simpleType>
  362.                   <xs:restriction base="xs:string">
  363.                     <xs:maxLength value="2" />
  364.                   </xs:restriction>
  365.                 </xs:simpleType>
  366.               </xs:element>
  367.               <xs:element name="prov_id" minOccurs="0">
  368.                 <xs:simpleType>
  369.                   <xs:restriction base="xs:string">
  370.                     <xs:maxLength value="10" />
  371.                   </xs:restriction>
  372.                 </xs:simpleType>
  373.               </xs:element>
  374.               <xs:element name="m_land" type="xs:decimal" minOccurs="0" />
  375.               <xs:element name="c_pa_name" minOccurs="0">
  376.                 <xs:simpleType>
  377.                   <xs:restriction base="xs:string">
  378.                     <xs:maxLength value="50" />
  379.                   </xs:restriction>
  380.                 </xs:simpleType>
  381.               </xs:element>
  382.               <xs:element name="d_update" type="xs:dateTime" minOccurs="0" />
  383.               <xs:element name="n_ratio_m" type="xs:int" minOccurs="0" />
  384.               <xs:element name="n_ratio_o" type="xs:int" minOccurs="0" />
  385.               <xs:element name="c_ag_licence" minOccurs="0">
  386.                 <xs:simpleType>
  387.                   <xs:restriction base="xs:string">
  388.                     <xs:maxLength value="15" />
  389.                   </xs:restriction>
  390.                 </xs:simpleType>
  391.               </xs:element>
  392.               <xs:element name="c_taxagen" minOccurs="0">
  393.                 <xs:simpleType>
  394.                   <xs:restriction base="xs:string">
  395.                     <xs:maxLength value="15" />
  396.                   </xs:restriction>
  397.                 </xs:simpleType>
  398.               </xs:element>
  399.               <xs:element name="F_RecUserID" minOccurs="0">
  400.                 <xs:simpleType>
  401.                   <xs:restriction base="xs:string">
  402.                     <xs:maxLength value="15" />
  403.                   </xs:restriction>
  404.                 </xs:simpleType>
  405.               </xs:element>
  406.               <xs:element name="F_RecClient" minOccurs="0">
  407.                 <xs:simpleType>
  408.                   <xs:restriction base="xs:string">
  409.                     <xs:maxLength value="50" />
  410.                   </xs:restriction>
  411.                 </xs:simpleType>
  412.               </xs:element>
  413.               <xs:element name="F_RecDateTime" type="xs:dateTime" minOccurs="0" />
  414.               <xs:element name="F_RecStatus" minOccurs="0">
  415.                 <xs:simpleType>
  416.                   <xs:restriction base="xs:string">
  417.                     <xs:maxLength value="1" />
  418.                   </xs:restriction>
  419.                 </xs:simpleType>
  420.               </xs:element>
  421.               <xs:element name="F_ag_type" minOccurs="0">
  422.                 <xs:simpleType>
  423.                   <xs:restriction base="xs:string">
  424.                     <xs:maxLength value="1" />
  425.                   </xs:restriction>
  426.                 </xs:simpleType>
  427.               </xs:element>
  428.               <xs:element name="i_car_brand">
  429.                 <xs:simpleType>
  430.                   <xs:restriction base="xs:string">
  431.                     <xs:maxLength value="4" />
  432.                   </xs:restriction>
  433.                 </xs:simpleType>
  434.               </xs:element>
  435.               <xs:element name="c_brand_code" minOccurs="0">
  436.                 <xs:simpleType>
  437.                   <xs:restriction base="xs:string">
  438.                     <xs:maxLength value="4" />
  439.                   </xs:restriction>
  440.                 </xs:simpleType>
  441.               </xs:element>
  442.               <xs:element name="c_car_brand">
  443.                 <xs:simpleType>
  444.                   <xs:restriction base="xs:string">
  445.                     <xs:maxLength value="50" />
  446.                   </xs:restriction>
  447.                 </xs:simpleType>
  448.               </xs:element>
  449.               <xs:element name="i_userid">
  450.                 <xs:simpleType>
  451.                   <xs:restriction base="xs:string">
  452.                     <xs:maxLength value="10" />
  453.                   </xs:restriction>
  454.                 </xs:simpleType>
  455.               </xs:element>
  456.               <xs:element name="d_updated" type="xs:dateTime" />
  457.               <xs:element name="i_car_brand_ref" minOccurs="0">
  458.                 <xs:simpleType>
  459.                   <xs:restriction base="xs:string">
  460.                     <xs:maxLength value="4" />
  461.                   </xs:restriction>
  462.                 </xs:simpleType>
  463.               </xs:element>
  464.               <xs:element name="f_status">
  465.                 <xs:simpleType>
  466.                   <xs:restriction base="xs:string">
  467.                     <xs:maxLength value="3" />
  468.                   </xs:restriction>
  469.                 </xs:simpleType>
  470.               </xs:element>
  471.               <xs:element name="d_status" type="xs:dateTime" />
  472.               <xs:element name="i_status">
  473.                 <xs:simpleType>
  474.                   <xs:restriction base="xs:string">
  475.                     <xs:maxLength value="10" />
  476.                   </xs:restriction>
  477.                 </xs:simpleType>
  478.               </xs:element>
  479.               <xs:element name="d_create" type="xs:dateTime" />
  480.               <xs:element name="i_create">
  481.                 <xs:simpleType>
  482.                   <xs:restriction base="xs:string">
  483.                     <xs:maxLength value="10" />
  484.                   </xs:restriction>
  485.                 </xs:simpleType>
  486.               </xs:element>
  487.               <xs:element name="d_approve" type="xs:dateTime" minOccurs="0" />
  488.               <xs:element name="i_approve" minOccurs="0">
  489.                 <xs:simpleType>
  490.                   <xs:restriction base="xs:string">
  491.                     <xs:maxLength value="10" />
  492.                   </xs:restriction>
  493.                 </xs:simpleType>
  494.               </xs:element>
  495.               <xs:element name="d_used" type="xs:dateTime" minOccurs="0" />
  496.               <xs:element name="d_expire" type="xs:dateTime" minOccurs="0" />
  497.               <xs:element name="f_tranf_risc" minOccurs="0">
  498.                 <xs:simpleType>
  499.                   <xs:restriction base="xs:string">
  500.                     <xs:maxLength value="1" />
  501.                   </xs:restriction>
  502.                 </xs:simpleType>
  503.               </xs:element>
  504.               <xs:element name="i_initial">
  505.                 <xs:simpleType>
  506.                   <xs:restriction base="xs:string">
  507.                     <xs:maxLength value="8" />
  508.                   </xs:restriction>
  509.                 </xs:simpleType>
  510.               </xs:element>
  511.               <xs:element name="n_initial">
  512.                 <xs:simpleType>
  513.                   <xs:restriction base="xs:string">
  514.                     <xs:maxLength value="30" />
  515.                   </xs:restriction>
  516.                 </xs:simpleType>
  517.               </xs:element>
  518.               <xs:element name="n_no">
  519.                 <xs:simpleType>
  520.                   <xs:restriction base="xs:string">
  521.                     <xs:maxLength value="3" />
  522.                   </xs:restriction>
  523.                 </xs:simpleType>
  524.               </xs:element>
  525.               <xs:element name="c_bun">
  526.                 <xs:simpleType>
  527.                   <xs:restriction base="xs:string">
  528.                     <xs:maxLength value="5" />
  529.                   </xs:restriction>
  530.                 </xs:simpleType>
  531.               </xs:element>
  532.               <xs:element name="s_type">
  533.                 <xs:simpleType>
  534.                   <xs:restriction base="xs:string">
  535.                     <xs:maxLength value="1" />
  536.                   </xs:restriction>
  537.                 </xs:simpleType>
  538.               </xs:element>
  539.               <xs:element name="e_pol_no">
  540.                 <xs:simpleType>
  541.                   <xs:restriction base="xs:string">
  542.                     <xs:maxLength value="25" />
  543.                   </xs:restriction>
  544.                 </xs:simpleType>
  545.               </xs:element>
  546.               <xs:element name="e_barcode">
  547.                 <xs:simpleType>
  548.                   <xs:restriction base="xs:string">
  549.                     <xs:maxLength value="15" />
  550.                   </xs:restriction>
  551.                 </xs:simpleType>
  552.               </xs:element>
  553.               <xs:element name="f_calc_type">
  554.                 <xs:simpleType>
  555.                   <xs:restriction base="xs:string">
  556.                     <xs:maxLength value="1" />
  557.                   </xs:restriction>
  558.                 </xs:simpleType>
  559.               </xs:element>
  560.               <xs:element name="d_begin" type="xs:dateTime" />
  561.               <xs:element name="d_end" type="xs:dateTime" />
  562.               <xs:element name="d_issue" type="xs:dateTime" />
  563.               <xs:element name="d_agree" type="xs:dateTime" />
  564.               <xs:element name="f_agen_type">
  565.                 <xs:simpleType>
  566.                   <xs:restriction base="xs:string">
  567.                     <xs:maxLength value="1" />
  568.                   </xs:restriction>
  569.                 </xs:simpleType>
  570.               </xs:element>
  571.               <xs:element name="c_name">
  572.                 <xs:simpleType>
  573.                   <xs:restriction base="xs:string">
  574.                     <xs:maxLength value="100" />
  575.                   </xs:restriction>
  576.                 </xs:simpleType>
  577.               </xs:element>
  578.               <xs:element name="c_lastname" minOccurs="0">
  579.                 <xs:simpleType>
  580.                   <xs:restriction base="xs:string">
  581.                     <xs:maxLength value="100" />
  582.                   </xs:restriction>
  583.                 </xs:simpleType>
  584.               </xs:element>
  585.               <xs:element name="c_address1" minOccurs="0">
  586.                 <xs:simpleType>
  587.                   <xs:restriction base="xs:string">
  588.                     <xs:maxLength value="100" />
  589.                   </xs:restriction>
  590.                 </xs:simpleType>
  591.               </xs:element>
  592.               <xs:element name="c_address2" minOccurs="0">
  593.                 <xs:simpleType>
  594.                   <xs:restriction base="xs:string">
  595.                     <xs:maxLength value="100" />
  596.                   </xs:restriction>
  597.                 </xs:simpleType>
  598.               </xs:element>
  599.               <xs:element name="i_province">
  600.                 <xs:simpleType>
  601.                   <xs:restriction base="xs:string">
  602.                     <xs:maxLength value="3" />
  603.                   </xs:restriction>
  604.                 </xs:simpleType>
  605.               </xs:element>
  606.               <xs:element name="i_zipcode" minOccurs="0">
  607.                 <xs:simpleType>
  608.                   <xs:restriction base="xs:string">
  609.                     <xs:maxLength value="5" />
  610.                   </xs:restriction>
  611.                 </xs:simpleType>
  612.               </xs:element>
  613.               <xs:element name="c_licence">
  614.                 <xs:simpleType>
  615.                   <xs:restriction base="xs:string">
  616.                     <xs:maxLength value="10" />
  617.                   </xs:restriction>
  618.                 </xs:simpleType>
  619.               </xs:element>
  620.               <xs:element name="i_prov_licence">
  621.                 <xs:simpleType>
  622.                   <xs:restriction base="xs:string">
  623.                     <xs:maxLength value="2" />
  624.                   </xs:restriction>
  625.                 </xs:simpleType>
  626.               </xs:element>
  627.               <xs:element name="i_car_make">
  628.                 <xs:simpleType>
  629.                   <xs:restriction base="xs:string">
  630.                     <xs:maxLength value="10" />
  631.                   </xs:restriction>
  632.                 </xs:simpleType>
  633.               </xs:element>
  634.               <xs:element name="i_car_model">
  635.                 <xs:simpleType>
  636.                   <xs:restriction base="xs:string">
  637.                     <xs:maxLength value="10" />
  638.                   </xs:restriction>
  639.                 </xs:simpleType>
  640.               </xs:element>
  641.               <xs:element name="c_chassis">
  642.                 <xs:simpleType>
  643.                   <xs:restriction base="xs:string">
  644.                     <xs:maxLength value="35" />
  645.                   </xs:restriction>
  646.                 </xs:simpleType>
  647.               </xs:element>
  648.               <xs:element name="c_body">
  649.                 <xs:simpleType>
  650.                   <xs:restriction base="xs:string">
  651.                     <xs:maxLength value="35" />
  652.                   </xs:restriction>
  653.                 </xs:simpleType>
  654.               </xs:element>
  655.               <xs:element name="c_engine" minOccurs="0">
  656.                 <xs:simpleType>
  657.                   <xs:restriction base="xs:string">
  658.                     <xs:maxLength value="35" />
  659.                   </xs:restriction>
  660.                 </xs:simpleType>
  661.               </xs:element>
  662.               <xs:element name="c_color">
  663.                 <xs:simpleType>
  664.                   <xs:restriction base="xs:string">
  665.                     <xs:maxLength value="20" />
  666.                   </xs:restriction>
  667.                 </xs:simpleType>
  668.               </xs:element>
  669.               <xs:element name="i_veh">
  670.                 <xs:simpleType>
  671.                   <xs:restriction base="xs:string">
  672.                     <xs:maxLength value="2" />
  673.                   </xs:restriction>
  674.                 </xs:simpleType>
  675.               </xs:element>
  676.               <xs:element name="i_usage">
  677.                 <xs:simpleType>
  678.                   <xs:restriction base="xs:string">
  679.                     <xs:maxLength value="2" />
  680.                   </xs:restriction>
  681.                 </xs:simpleType>
  682.               </xs:element>
  683.               <xs:element name="i_veh_size">
  684.                 <xs:simpleType>
  685.                   <xs:restriction base="xs:string">
  686.                     <xs:maxLength value="1" />
  687.                   </xs:restriction>
  688.                 </xs:simpleType>
  689.               </xs:element>
  690.               <xs:element name="q_disp" type="xs:int" />
  691.               <xs:element name="q_seat" type="xs:int" />
  692.               <xs:element name="q_gvw" type="xs:decimal" />
  693.               <xs:element name="m_pm" type="xs:decimal" />
  694.               <xs:element name="p_disc_direct" type="xs:decimal" />
  695.               <xs:element name="m_disc_direct" type="xs:decimal" />
  696.               <xs:element name="m_duty" type="xs:decimal" />
  697.               <xs:element name="p_vat" type="xs:decimal" />
  698.               <xs:element name="m_tax" type="xs:decimal" />
  699.               <xs:element name="m_gross" type="xs:decimal" />
  700.               <xs:element name="e_bookno">
  701.                 <xs:simpleType>
  702.                   <xs:restriction base="xs:string">
  703.                     <xs:maxLength value="15" />
  704.                   </xs:restriction>
  705.                 </xs:simpleType>
  706.               </xs:element>
  707.               <xs:element name="e_receipt">
  708.                 <xs:simpleType>
  709.                   <xs:restriction base="xs:string">
  710.                     <xs:maxLength value="15" />
  711.                   </xs:restriction>
  712.                 </xs:simpleType>
  713.               </xs:element>
  714.               <xs:element name="d_key" type="xs:dateTime" />
  715.               <xs:element name="i_key">
  716.                 <xs:simpleType>
  717.                   <xs:restriction base="xs:string">
  718.                     <xs:maxLength value="15" />
  719.                   </xs:restriction>
  720.                 </xs:simpleType>
  721.               </xs:element>
  722.               <xs:element name="d_send_pol" type="xs:dateTime" />
  723.               <xs:element name="i_send_pol">
  724.                 <xs:simpleType>
  725.                   <xs:restriction base="xs:string">
  726.                     <xs:maxLength value="15" />
  727.                   </xs:restriction>
  728.                 </xs:simpleType>
  729.               </xs:element>
  730.               <xs:element name="n_usage">
  731.                 <xs:simpleType>
  732.                   <xs:restriction base="xs:string">
  733.                     <xs:maxLength value="100" />
  734.                   </xs:restriction>
  735.                 </xs:simpleType>
  736.               </xs:element>
  737.               <xs:element name="i_ag_main">
  738.                 <xs:simpleType>
  739.                   <xs:restriction base="xs:string">
  740.                     <xs:maxLength value="15" />
  741.                   </xs:restriction>
  742.                 </xs:simpleType>
  743.               </xs:element>
  744.               <xs:element name="f_transfer">
  745.                 <xs:simpleType>
  746.                   <xs:restriction base="xs:string">
  747.                     <xs:maxLength value="3" />
  748.                   </xs:restriction>
  749.                 </xs:simpleType>
  750.               </xs:element>
  751.               <xs:element name="d_transfer" type="xs:dateTime" />
  752.               <xs:element name="f_Export" minOccurs="0">
  753.                 <xs:simpleType>
  754.                   <xs:restriction base="xs:string">
  755.                     <xs:maxLength value="1" />
  756.                   </xs:restriction>
  757.                 </xs:simpleType>
  758.               </xs:element>
  759.               <xs:element name="d_Export" type="xs:dateTime" minOccurs="0" />
  760.               <xs:element name="TU_Eff_Date" minOccurs="0">
  761.                 <xs:simpleType>
  762.                   <xs:restriction base="xs:string">
  763.                     <xs:maxLength value="8" />
  764.                   </xs:restriction>
  765.                 </xs:simpleType>
  766.               </xs:element>
  767.               <xs:element name="TU_Type_Code">
  768.                 <xs:simpleType>
  769.                   <xs:restriction base="xs:string">
  770.                     <xs:maxLength value="2" />
  771.                   </xs:restriction>
  772.                 </xs:simpleType>
  773.               </xs:element>
  774.               <xs:element name="TU_Usage_Code">
  775.                 <xs:simpleType>
  776.                   <xs:restriction base="xs:string">
  777.                     <xs:maxLength value="2" />
  778.                   </xs:restriction>
  779.                 </xs:simpleType>
  780.               </xs:element>
  781.               <xs:element name="TU_Desc" minOccurs="0">
  782.                 <xs:simpleType>
  783.                   <xs:restriction base="xs:string">
  784.                     <xs:maxLength value="50" />
  785.                   </xs:restriction>
  786.                 </xs:simpleType>
  787.               </xs:element>
  788.               <xs:element name="TU_Usage_Desc" minOccurs="0">
  789.                 <xs:simpleType>
  790.                   <xs:restriction base="xs:string">
  791.                     <xs:maxLength value="50" />
  792.                   </xs:restriction>
  793.                 </xs:simpleType>
  794.               </xs:element>
  795.               <xs:element name="TU_Pol_Txt" minOccurs="0">
  796.                 <xs:simpleType>
  797.                   <xs:restriction base="xs:string">
  798.                     <xs:maxLength value="120" />
  799.                   </xs:restriction>
  800.                 </xs:simpleType>
  801.               </xs:element>
  802.               <xs:element name="TU_No_Seat" type="xs:unsignedByte" minOccurs="0" />
  803.               <xs:element name="TU_Create_Date" type="xs:dateTime" minOccurs="0" />
  804.               <xs:element name="TU_Update_Date" type="xs:dateTime" minOccurs="0" />
  805.               <xs:element name="Expr1">
  806.                 <xs:simpleType>
  807.                   <xs:restriction base="xs:string">
  808.                     <xs:maxLength value="15" />
  809.                   </xs:restriction>
  810.                 </xs:simpleType>
  811.               </xs:element>
  812.               <xs:element name="Expr2">
  813.                 <xs:simpleType>
  814.                   <xs:restriction base="xs:string">
  815.                     <xs:maxLength value="100" />
  816.                   </xs:restriction>
  817.                 </xs:simpleType>
  818.               </xs:element>
  819.               <xs:element name="Expr3" minOccurs="0">
  820.                 <xs:simpleType>
  821.                   <xs:restriction base="xs:string">
  822.                     <xs:maxLength value="100" />
  823.                   </xs:restriction>
  824.                 </xs:simpleType>
  825.               </xs:element>
  826.               <xs:element name="Expr4">
  827.                 <xs:simpleType>
  828.                   <xs:restriction base="xs:string">
  829.                     <xs:maxLength value="15" />
  830.                   </xs:restriction>
  831.                 </xs:simpleType>
  832.               </xs:element>
  833.               <xs:element name="Expr5">
  834.                 <xs:simpleType>
  835.                   <xs:restriction base="xs:string">
  836.                     <xs:maxLength value="3" />
  837.                   </xs:restriction>
  838.                 </xs:simpleType>
  839.               </xs:element>
  840.               <xs:element name="Expr6" type="xs:int" />
  841.               <xs:element name="Expr7" minOccurs="0">
  842.                 <xs:simpleType>
  843.                   <xs:restriction base="xs:string">
  844.                     <xs:maxLength value="1" />
  845.                   </xs:restriction>
  846.                 </xs:simpleType>
  847.               </xs:element>
  848.               <xs:element name="i_changwat">
  849.                 <xs:simpleType>
  850.                   <xs:restriction base="xs:string">
  851.                     <xs:maxLength value="3" />
  852.                   </xs:restriction>
  853.                 </xs:simpleType>
  854.               </xs:element>
  855.               <xs:element name="n_changwat">
  856.                 <xs:simpleType>
  857.                   <xs:restriction base="xs:string">
  858.                     <xs:maxLength value="15" />
  859.                   </xs:restriction>
  860.                 </xs:simpleType>
  861.               </xs:element>
  862.               <xs:element name="i_group">
  863.                 <xs:simpleType>
  864.                   <xs:restriction base="xs:string">
  865.                     <xs:maxLength value="2" />
  866.                   </xs:restriction>
  867.                 </xs:simpleType>
  868.               </xs:element>
  869.               <xs:element name="i_changwat2">
  870.                 <xs:simpleType>
  871.                   <xs:restriction base="xs:string">
  872.                     <xs:maxLength value="2" />
  873.                   </xs:restriction>
  874.                 </xs:simpleType>
  875.               </xs:element>
  876.               <xs:element name="i_zone">
  877.                 <xs:simpleType>
  878.                   <xs:restriction base="xs:string">
  879.                     <xs:maxLength value="1" />
  880.                   </xs:restriction>
  881.                 </xs:simpleType>
  882.               </xs:element>
  883.               <xs:element name="name" minOccurs="0">
  884.                 <xs:simpleType>
  885.                   <xs:restriction base="xs:string">
  886.                     <xs:maxLength value="30" />
  887.                   </xs:restriction>
  888.                 </xs:simpleType>
  889.               </xs:element>
  890.               <xs:element name="i_agen_code" minOccurs="0">
  891.                 <xs:simpleType>
  892.                   <xs:restriction base="xs:string">
  893.                     <xs:maxLength value="2" />
  894.                   </xs:restriction>
  895.                 </xs:simpleType>
  896.               </xs:element>
  897.               <xs:element name="i_agen_code2" minOccurs="0">
  898.                 <xs:simpleType>
  899.                   <xs:restriction base="xs:string">
  900.                     <xs:maxLength value="20" />
  901.                   </xs:restriction>
  902.                 </xs:simpleType>
  903.               </xs:element>
  904.             </xs:sequence>
  905.           </xs:complexType>
  906.         </xs:element>
  907.       </xs:choice>
  908.     </xs:complexType>
  909.     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  910.       <xs:selector xpath=".//mstns:DataTable1" />
  911.       <xs:field xpath="mstns:i_ag" />
  912.       <xs:field xpath="mstns:i_car_brand" />
  913.       <xs:field xpath="mstns:i_initial" />
  914.       <xs:field xpath="mstns:e_pol_no" />
  915.       <xs:field xpath="mstns:TU_Type_Code" />
  916.       <xs:field xpath="mstns:TU_Usage_Code" />
  917.     </xs:unique>
  918.   </xs:element>
  919. </xs:schema>