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_PRB2.xsd < prev    next >
Extensible Markup Language  |  2013-06-07  |  42KB  |  797 lines
  1. ∩╗┐<?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="DS_PRINT_PRB2" 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" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" 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="TB_PRB_PRINTTableAdapter" Name="TB_PRB_PRINT">
  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_car_brand, c_pol_web.c_bun, 
  24.                       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, 
  25.                       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, 
  26.                       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, 
  27.                       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, 
  28.                       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, 
  29.                       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, 
  30.                       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, 
  31.                       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, 
  32.                       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, 
  33.                       MO_TYPE_USAGE.TU_Type_Code, MO_TYPE_USAGE.TU_Usage_Code, MO_TYPE_USAGE.TU_Desc, MO_TYPE_USAGE.TU_Usage_Desc, 
  34.                       MO_TYPE_USAGE.TU_Pol_Txt, MO_TYPE_USAGE.TU_No_Seat, MO_TYPE_USAGE.s_type AS Expr7, b_agent.name, 
  35.                       c_stick_web.i_agen_code# AS i_agen_code_, c_stick_web.i_agen_code, CAST(ref_province.Prov_Name AS varchar(50)) AS c_province_name, 
  36.                       b_initial.i_initial AS i_initial, b_initial.n_initial AS n_initial, b_changwat.n_changwat
  37. FROM         b_agency_web INNER JOIN
  38.                       c_pol_web ON b_agency_web.i_ag = c_pol_web.i_ag INNER JOIN
  39.                       c_stick_web ON c_pol_web.e_pol_no = c_stick_web.e_pol_no INNER JOIN
  40.                       b_agent ON b_agency_web.c_taxagen = b_agent.agcd INNER JOIN
  41.                       ref_province ON c_pol_web.i_province = ref_province.Pro_Id_Risc INNER JOIN
  42.                       b_initial ON c_pol_web.i_initial = b_initial.n_no INNER JOIN
  43.                       b_id_car_brand ON c_pol_web.i_car_make = b_id_car_brand.i_car_brand INNER JOIN
  44.                       MO_TYPE_USAGE ON c_pol_web.i_usage = MO_TYPE_USAGE.TU_Type_Code AND c_pol_web.i_veh = MO_TYPE_USAGE.TU_Usage_Code INNER JOIN
  45.                       b_changwat ON c_pol_web.i_province = b_changwat.i_changwat</CommandText>
  46.                     <Parameters />
  47.                   </DbCommand>
  48.                 </SelectCommand>
  49.               </DbSource>
  50.             </MainSource>
  51.             <Mappings>
  52.               <Mapping SourceColumn="i_ag" DataSetColumn="i_ag" />
  53.               <Mapping SourceColumn="c_initial" DataSetColumn="c_initial" />
  54.               <Mapping SourceColumn="c_ag_name" DataSetColumn="c_ag_name" />
  55.               <Mapping SourceColumn="c_ag_lastname" DataSetColumn="c_ag_lastname" />
  56.               <Mapping SourceColumn="c_add1" DataSetColumn="c_add1" />
  57.               <Mapping SourceColumn="c_add2" DataSetColumn="c_add2" />
  58.               <Mapping SourceColumn="c_tel" DataSetColumn="c_tel" />
  59.               <Mapping SourceColumn="d_born" DataSetColumn="d_born" />
  60.               <Mapping SourceColumn="c_idcard" DataSetColumn="c_idcard" />
  61.               <Mapping SourceColumn="c_idcard_b" DataSetColumn="c_idcard_b" />
  62.               <Mapping SourceColumn="d_idcard_st" DataSetColumn="d_idcard_st" />
  63.               <Mapping SourceColumn="d_idcard_exp" DataSetColumn="d_idcard_exp" />
  64.               <Mapping SourceColumn="f_sale_prb" DataSetColumn="f_sale_prb" />
  65.               <Mapping SourceColumn="m_cash" DataSetColumn="m_cash" />
  66.               <Mapping SourceColumn="i_cheque_no" DataSetColumn="i_cheque_no" />
  67.               <Mapping SourceColumn="d_cheque_due" DataSetColumn="d_cheque_due" />
  68.               <Mapping SourceColumn="m_cheque" DataSetColumn="m_cheque" />
  69.               <Mapping SourceColumn="i_bank" DataSetColumn="i_bank" />
  70.               <Mapping SourceColumn="i_branch" DataSetColumn="i_branch" />
  71.               <Mapping SourceColumn="i_lg_code" DataSetColumn="i_lg_code" />
  72.               <Mapping SourceColumn="d_lg" DataSetColumn="d_lg" />
  73.               <Mapping SourceColumn="m_lg" DataSetColumn="m_lg" />
  74.               <Mapping SourceColumn="d_lg_due" DataSetColumn="d_lg_due" />
  75.               <Mapping SourceColumn="c_lg_bank" DataSetColumn="c_lg_bank" />
  76.               <Mapping SourceColumn="c_lg_branch" DataSetColumn="c_lg_branch" />
  77.               <Mapping SourceColumn="i_land_code" DataSetColumn="i_land_code" />
  78.               <Mapping SourceColumn="i_land_no" DataSetColumn="i_land_no" />
  79.               <Mapping SourceColumn="c_land_area" DataSetColumn="c_land_area" />
  80.               <Mapping SourceColumn="c_land_add" DataSetColumn="c_land_add" />
  81.               <Mapping SourceColumn="c_subdistrict" DataSetColumn="c_subdistrict" />
  82.               <Mapping SourceColumn="i_district" DataSetColumn="i_district" />
  83.               <Mapping SourceColumn="prov_id" DataSetColumn="prov_id" />
  84.               <Mapping SourceColumn="m_land" DataSetColumn="m_land" />
  85.               <Mapping SourceColumn="c_pa_name" DataSetColumn="c_pa_name" />
  86.               <Mapping SourceColumn="d_update" DataSetColumn="d_update" />
  87.               <Mapping SourceColumn="n_ratio_m" DataSetColumn="n_ratio_m" />
  88.               <Mapping SourceColumn="n_ratio_o" DataSetColumn="n_ratio_o" />
  89.               <Mapping SourceColumn="c_ag_licence" DataSetColumn="c_ag_licence" />
  90.               <Mapping SourceColumn="c_taxagen" DataSetColumn="c_taxagen" />
  91.               <Mapping SourceColumn="F_RecUserID" DataSetColumn="F_RecUserID" />
  92.               <Mapping SourceColumn="F_RecClient" DataSetColumn="F_RecClient" />
  93.               <Mapping SourceColumn="F_RecDateTime" DataSetColumn="F_RecDateTime" />
  94.               <Mapping SourceColumn="F_RecStatus" DataSetColumn="F_RecStatus" />
  95.               <Mapping SourceColumn="F_ag_type" DataSetColumn="F_ag_type" />
  96.               <Mapping SourceColumn="i_car_brand" DataSetColumn="i_car_brand" />
  97.               <Mapping SourceColumn="c_car_brand" DataSetColumn="c_car_brand" />
  98.               <Mapping SourceColumn="c_bun" DataSetColumn="c_bun" />
  99.               <Mapping SourceColumn="s_type" DataSetColumn="s_type" />
  100.               <Mapping SourceColumn="e_pol_no" DataSetColumn="e_pol_no" />
  101.               <Mapping SourceColumn="e_barcode" DataSetColumn="e_barcode" />
  102.               <Mapping SourceColumn="f_calc_type" DataSetColumn="f_calc_type" />
  103.               <Mapping SourceColumn="d_begin" DataSetColumn="d_begin" />
  104.               <Mapping SourceColumn="d_end" DataSetColumn="d_end" />
  105.               <Mapping SourceColumn="d_issue" DataSetColumn="d_issue" />
  106.               <Mapping SourceColumn="d_agree" DataSetColumn="d_agree" />
  107.               <Mapping SourceColumn="f_agen_type" DataSetColumn="f_agen_type" />
  108.               <Mapping SourceColumn="c_name" DataSetColumn="c_name" />
  109.               <Mapping SourceColumn="c_lastname" DataSetColumn="c_lastname" />
  110.               <Mapping SourceColumn="c_address1" DataSetColumn="c_address1" />
  111.               <Mapping SourceColumn="c_address2" DataSetColumn="c_address2" />
  112.               <Mapping SourceColumn="i_province" DataSetColumn="i_province" />
  113.               <Mapping SourceColumn="i_zipcode" DataSetColumn="i_zipcode" />
  114.               <Mapping SourceColumn="c_licence" DataSetColumn="c_licence" />
  115.               <Mapping SourceColumn="i_prov_licence" DataSetColumn="i_prov_licence" />
  116.               <Mapping SourceColumn="i_car_make" DataSetColumn="i_car_make" />
  117.               <Mapping SourceColumn="i_car_model" DataSetColumn="i_car_model" />
  118.               <Mapping SourceColumn="c_chassis" DataSetColumn="c_chassis" />
  119.               <Mapping SourceColumn="c_body" DataSetColumn="c_body" />
  120.               <Mapping SourceColumn="c_engine" DataSetColumn="c_engine" />
  121.               <Mapping SourceColumn="c_color" DataSetColumn="c_color" />
  122.               <Mapping SourceColumn="i_veh" DataSetColumn="i_veh" />
  123.               <Mapping SourceColumn="i_usage" DataSetColumn="i_usage" />
  124.               <Mapping SourceColumn="i_veh_size" DataSetColumn="i_veh_size" />
  125.               <Mapping SourceColumn="q_disp" DataSetColumn="q_disp" />
  126.               <Mapping SourceColumn="q_seat" DataSetColumn="q_seat" />
  127.               <Mapping SourceColumn="q_gvw" DataSetColumn="q_gvw" />
  128.               <Mapping SourceColumn="m_pm" DataSetColumn="m_pm" />
  129.               <Mapping SourceColumn="p_disc_direct" DataSetColumn="p_disc_direct" />
  130.               <Mapping SourceColumn="m_disc_direct" DataSetColumn="m_disc_direct" />
  131.               <Mapping SourceColumn="m_duty" DataSetColumn="m_duty" />
  132.               <Mapping SourceColumn="p_vat" DataSetColumn="p_vat" />
  133.               <Mapping SourceColumn="m_tax" DataSetColumn="m_tax" />
  134.               <Mapping SourceColumn="m_gross" DataSetColumn="m_gross" />
  135.               <Mapping SourceColumn="e_bookno" DataSetColumn="e_bookno" />
  136.               <Mapping SourceColumn="e_receipt" DataSetColumn="e_receipt" />
  137.               <Mapping SourceColumn="d_key" DataSetColumn="d_key" />
  138.               <Mapping SourceColumn="i_key" DataSetColumn="i_key" />
  139.               <Mapping SourceColumn="d_send_pol" DataSetColumn="d_send_pol" />
  140.               <Mapping SourceColumn="i_send_pol" DataSetColumn="i_send_pol" />
  141.               <Mapping SourceColumn="n_usage" DataSetColumn="n_usage" />
  142.               <Mapping SourceColumn="i_ag_main" DataSetColumn="i_ag_main" />
  143.               <Mapping SourceColumn="f_transfer" DataSetColumn="f_transfer" />
  144.               <Mapping SourceColumn="d_transfer" DataSetColumn="d_transfer" />
  145.               <Mapping SourceColumn="f_Export" DataSetColumn="f_Export" />
  146.               <Mapping SourceColumn="d_Export" DataSetColumn="d_Export" />
  147.               <Mapping SourceColumn="TU_Eff_Date" DataSetColumn="TU_Eff_Date" />
  148.               <Mapping SourceColumn="TU_Type_Code" DataSetColumn="TU_Type_Code" />
  149.               <Mapping SourceColumn="TU_Usage_Code" DataSetColumn="TU_Usage_Code" />
  150.               <Mapping SourceColumn="TU_Desc" DataSetColumn="TU_Desc" />
  151.               <Mapping SourceColumn="TU_Usage_Desc" DataSetColumn="TU_Usage_Desc" />
  152.               <Mapping SourceColumn="TU_Pol_Txt" DataSetColumn="TU_Pol_Txt" />
  153.               <Mapping SourceColumn="TU_No_Seat" DataSetColumn="TU_No_Seat" />
  154.               <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  155.               <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
  156.               <Mapping SourceColumn="Expr3" DataSetColumn="Expr3" />
  157.               <Mapping SourceColumn="Expr4" DataSetColumn="Expr4" />
  158.               <Mapping SourceColumn="Expr5" DataSetColumn="Expr5" />
  159.               <Mapping SourceColumn="Expr6" DataSetColumn="Expr6" />
  160.               <Mapping SourceColumn="Expr7" DataSetColumn="Expr7" />
  161.               <Mapping SourceColumn="name" DataSetColumn="name" />
  162.               <Mapping SourceColumn="i_agen_code" DataSetColumn="i_agen_code" />
  163.               <Mapping SourceColumn="c_province_name" DataSetColumn="c_province_name" />
  164.               <Mapping SourceColumn="n_changwat" DataSetColumn="n_changwat" />
  165.               <Mapping SourceColumn="i_agen_code_" DataSetColumn="i_agen_code_" />
  166.               <Mapping SourceColumn="i_initial" DataSetColumn="i_initial" />
  167.               <Mapping SourceColumn="n_initial" DataSetColumn="n_initial" />
  168.             </Mappings>
  169.             <Sources />
  170.           </TableAdapter>
  171.         </Tables>
  172.         <Sources />
  173.       </DataSource>
  174.     </xs:appinfo>
  175.   </xs:annotation>
  176.   <xs:element name="DS_PRINT_PRB2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
  177.     <xs:complexType>
  178.       <xs:choice minOccurs="0" maxOccurs="unbounded">
  179.         <xs:element name="TB_PRB_PRINT">
  180.           <xs:complexType>
  181.             <xs:sequence>
  182.               <xs:element name="i_ag">
  183.                 <xs:simpleType>
  184.                   <xs:restriction base="xs:string">
  185.                     <xs:maxLength value="6" />
  186.                   </xs:restriction>
  187.                 </xs:simpleType>
  188.               </xs:element>
  189.               <xs:element name="c_initial" minOccurs="0">
  190.                 <xs:simpleType>
  191.                   <xs:restriction base="xs:string">
  192.                     <xs:maxLength value="10" />
  193.                   </xs:restriction>
  194.                 </xs:simpleType>
  195.               </xs:element>
  196.               <xs:element name="c_ag_name" minOccurs="0">
  197.                 <xs:simpleType>
  198.                   <xs:restriction base="xs:string">
  199.                     <xs:maxLength value="60" />
  200.                   </xs:restriction>
  201.                 </xs:simpleType>
  202.               </xs:element>
  203.               <xs:element name="c_ag_lastname" minOccurs="0">
  204.                 <xs:simpleType>
  205.                   <xs:restriction base="xs:string">
  206.                     <xs:maxLength value="30" />
  207.                   </xs:restriction>
  208.                 </xs:simpleType>
  209.               </xs:element>
  210.               <xs:element name="c_add1" minOccurs="0">
  211.                 <xs:simpleType>
  212.                   <xs:restriction base="xs:string">
  213.                     <xs:maxLength value="200" />
  214.                   </xs:restriction>
  215.                 </xs:simpleType>
  216.               </xs:element>
  217.               <xs:element name="c_add2" minOccurs="0">
  218.                 <xs:simpleType>
  219.                   <xs:restriction base="xs:string">
  220.                     <xs:maxLength value="60" />
  221.                   </xs:restriction>
  222.                 </xs:simpleType>
  223.               </xs:element>
  224.               <xs:element name="c_tel" minOccurs="0">
  225.                 <xs:simpleType>
  226.                   <xs:restriction base="xs:string">
  227.                     <xs:maxLength value="30" />
  228.                   </xs:restriction>
  229.                 </xs:simpleType>
  230.               </xs:element>
  231.               <xs:element name="d_born" type="xs:dateTime" minOccurs="0" />
  232.               <xs:element name="c_idcard" minOccurs="0">
  233.                 <xs:simpleType>
  234.                   <xs:restriction base="xs:string">
  235.                     <xs:maxLength value="13" />
  236.                   </xs:restriction>
  237.                 </xs:simpleType>
  238.               </xs:element>
  239.               <xs:element name="c_idcard_b" minOccurs="0">
  240.                 <xs:simpleType>
  241.                   <xs:restriction base="xs:string">
  242.                     <xs:maxLength value="30" />
  243.                   </xs:restriction>
  244.                 </xs:simpleType>
  245.               </xs:element>
  246.               <xs:element name="d_idcard_st" type="xs:dateTime" minOccurs="0" />
  247.               <xs:element name="d_idcard_exp" type="xs:dateTime" minOccurs="0" />
  248.               <xs:element name="f_sale_prb" minOccurs="0">
  249.                 <xs:simpleType>
  250.                   <xs:restriction base="xs:string">
  251.                     <xs:maxLength value="1" />
  252.                   </xs:restriction>
  253.                 </xs:simpleType>
  254.               </xs:element>
  255.               <xs:element name="m_cash" type="xs:decimal" minOccurs="0" />
  256.               <xs:element name="i_cheque_no" minOccurs="0">
  257.                 <xs:simpleType>
  258.                   <xs:restriction base="xs:string">
  259.                     <xs:maxLength value="10" />
  260.                   </xs:restriction>
  261.                 </xs:simpleType>
  262.               </xs:element>
  263.               <xs:element name="d_cheque_due" type="xs:dateTime" minOccurs="0" />
  264.               <xs:element name="m_cheque" type="xs:decimal" minOccurs="0" />
  265.               <xs:element name="i_bank" minOccurs="0">
  266.                 <xs:simpleType>
  267.                   <xs:restriction base="xs:string">
  268.                     <xs:maxLength value="6" />
  269.                   </xs:restriction>
  270.                 </xs:simpleType>
  271.               </xs:element>
  272.               <xs:element name="i_branch" minOccurs="0">
  273.                 <xs:simpleType>
  274.                   <xs:restriction base="xs:string">
  275.                     <xs:maxLength value="30" />
  276.                   </xs:restriction>
  277.                 </xs:simpleType>
  278.               </xs:element>
  279.               <xs:element name="i_lg_code" minOccurs="0">
  280.                 <xs:simpleType>
  281.                   <xs:restriction base="xs:string">
  282.                     <xs:maxLength value="20" />
  283.                   </xs:restriction>
  284.                 </xs:simpleType>
  285.               </xs:element>
  286.               <xs:element name="d_lg" type="xs:dateTime" minOccurs="0" />
  287.               <xs:element name="m_lg" type="xs:decimal" minOccurs="0" />
  288.               <xs:element name="d_lg_due" type="xs:dateTime" minOccurs="0" />
  289.               <xs:element name="c_lg_bank" minOccurs="0">
  290.                 <xs:simpleType>
  291.                   <xs:restriction base="xs:string">
  292.                     <xs:maxLength value="6" />
  293.                   </xs:restriction>
  294.                 </xs:simpleType>
  295.               </xs:element>
  296.               <xs:element name="c_lg_branch" minOccurs="0">
  297.                 <xs:simpleType>
  298.                   <xs:restriction base="xs:string">
  299.                     <xs:maxLength value="30" />
  300.                   </xs:restriction>
  301.                 </xs:simpleType>
  302.               </xs:element>
  303.               <xs:element name="i_land_code" minOccurs="0">
  304.                 <xs:simpleType>
  305.                   <xs:restriction base="xs:string">
  306.                     <xs:maxLength value="30" />
  307.                   </xs:restriction>
  308.                 </xs:simpleType>
  309.               </xs:element>
  310.               <xs:element name="i_land_no" minOccurs="0">
  311.                 <xs:simpleType>
  312.                   <xs:restriction base="xs:string">
  313.                     <xs:maxLength value="30" />
  314.                   </xs:restriction>
  315.                 </xs:simpleType>
  316.               </xs:element>
  317.               <xs:element name="c_land_area" minOccurs="0">
  318.                 <xs:simpleType>
  319.                   <xs:restriction base="xs:string">
  320.                     <xs:maxLength value="30" />
  321.                   </xs:restriction>
  322.                 </xs:simpleType>
  323.               </xs:element>
  324.               <xs:element name="c_land_add" minOccurs="0">
  325.                 <xs:simpleType>
  326.                   <xs:restriction base="xs:string">
  327.                     <xs:maxLength value="70" />
  328.                   </xs:restriction>
  329.                 </xs:simpleType>
  330.               </xs:element>
  331.               <xs:element name="c_subdistrict" minOccurs="0">
  332.                 <xs:simpleType>
  333.                   <xs:restriction base="xs:string">
  334.                     <xs:maxLength value="30" />
  335.                   </xs:restriction>
  336.                 </xs:simpleType>
  337.               </xs:element>
  338.               <xs:element name="i_district" minOccurs="0">
  339.                 <xs:simpleType>
  340.                   <xs:restriction base="xs:string">
  341.                     <xs:maxLength value="2" />
  342.                   </xs:restriction>
  343.                 </xs:simpleType>
  344.               </xs:element>
  345.               <xs:element name="prov_id" minOccurs="0">
  346.                 <xs:simpleType>
  347.                   <xs:restriction base="xs:string">
  348.                     <xs:maxLength value="10" />
  349.                   </xs:restriction>
  350.                 </xs:simpleType>
  351.               </xs:element>
  352.               <xs:element name="m_land" type="xs:decimal" minOccurs="0" />
  353.               <xs:element name="c_pa_name" minOccurs="0">
  354.                 <xs:simpleType>
  355.                   <xs:restriction base="xs:string">
  356.                     <xs:maxLength value="50" />
  357.                   </xs:restriction>
  358.                 </xs:simpleType>
  359.               </xs:element>
  360.               <xs:element name="d_update" type="xs:dateTime" minOccurs="0" />
  361.               <xs:element name="n_ratio_m" type="xs:int" minOccurs="0" />
  362.               <xs:element name="n_ratio_o" type="xs:int" minOccurs="0" />
  363.               <xs:element name="c_ag_licence" minOccurs="0">
  364.                 <xs:simpleType>
  365.                   <xs:restriction base="xs:string">
  366.                     <xs:maxLength value="15" />
  367.                   </xs:restriction>
  368.                 </xs:simpleType>
  369.               </xs:element>
  370.               <xs:element name="c_taxagen" minOccurs="0">
  371.                 <xs:simpleType>
  372.                   <xs:restriction base="xs:string">
  373.                     <xs:maxLength value="15" />
  374.                   </xs:restriction>
  375.                 </xs:simpleType>
  376.               </xs:element>
  377.               <xs:element name="F_RecUserID" minOccurs="0">
  378.                 <xs:simpleType>
  379.                   <xs:restriction base="xs:string">
  380.                     <xs:maxLength value="15" />
  381.                   </xs:restriction>
  382.                 </xs:simpleType>
  383.               </xs:element>
  384.               <xs:element name="F_RecClient" minOccurs="0">
  385.                 <xs:simpleType>
  386.                   <xs:restriction base="xs:string">
  387.                     <xs:maxLength value="50" />
  388.                   </xs:restriction>
  389.                 </xs:simpleType>
  390.               </xs:element>
  391.               <xs:element name="F_RecDateTime" type="xs:dateTime" minOccurs="0" />
  392.               <xs:element name="F_RecStatus" minOccurs="0">
  393.                 <xs:simpleType>
  394.                   <xs:restriction base="xs:string">
  395.                     <xs:maxLength value="1" />
  396.                   </xs:restriction>
  397.                 </xs:simpleType>
  398.               </xs:element>
  399.               <xs:element name="F_ag_type" minOccurs="0">
  400.                 <xs:simpleType>
  401.                   <xs:restriction base="xs:string">
  402.                     <xs:maxLength value="1" />
  403.                   </xs:restriction>
  404.                 </xs:simpleType>
  405.               </xs:element>
  406.               <xs:element name="i_car_brand">
  407.                 <xs:simpleType>
  408.                   <xs:restriction base="xs:string">
  409.                     <xs:maxLength value="4" />
  410.                   </xs:restriction>
  411.                 </xs:simpleType>
  412.               </xs:element>
  413.               <xs:element name="c_car_brand">
  414.                 <xs:simpleType>
  415.                   <xs:restriction base="xs:string">
  416.                     <xs:maxLength value="50" />
  417.                   </xs:restriction>
  418.                 </xs:simpleType>
  419.               </xs:element>
  420.               <xs:element name="c_bun">
  421.                 <xs:simpleType>
  422.                   <xs:restriction base="xs:string">
  423.                     <xs:maxLength value="5" />
  424.                   </xs:restriction>
  425.                 </xs:simpleType>
  426.               </xs:element>
  427.               <xs:element name="s_type">
  428.                 <xs:simpleType>
  429.                   <xs:restriction base="xs:string">
  430.                     <xs:maxLength value="1" />
  431.                   </xs:restriction>
  432.                 </xs:simpleType>
  433.               </xs:element>
  434.               <xs:element name="e_pol_no">
  435.                 <xs:simpleType>
  436.                   <xs:restriction base="xs:string">
  437.                     <xs:maxLength value="25" />
  438.                   </xs:restriction>
  439.                 </xs:simpleType>
  440.               </xs:element>
  441.               <xs:element name="e_barcode">
  442.                 <xs:simpleType>
  443.                   <xs:restriction base="xs:string">
  444.                     <xs:maxLength value="15" />
  445.                   </xs:restriction>
  446.                 </xs:simpleType>
  447.               </xs:element>
  448.               <xs:element name="f_calc_type">
  449.                 <xs:simpleType>
  450.                   <xs:restriction base="xs:string">
  451.                     <xs:maxLength value="1" />
  452.                   </xs:restriction>
  453.                 </xs:simpleType>
  454.               </xs:element>
  455.               <xs:element name="d_begin" type="xs:dateTime" />
  456.               <xs:element name="d_end" type="xs:dateTime" />
  457.               <xs:element name="d_issue" type="xs:dateTime" />
  458.               <xs:element name="d_agree" type="xs:dateTime" />
  459.               <xs:element name="f_agen_type">
  460.                 <xs:simpleType>
  461.                   <xs:restriction base="xs:string">
  462.                     <xs:maxLength value="1" />
  463.                   </xs:restriction>
  464.                 </xs:simpleType>
  465.               </xs:element>
  466.               <xs:element name="c_name">
  467.                 <xs:simpleType>
  468.                   <xs:restriction base="xs:string">
  469.                     <xs:maxLength value="100" />
  470.                   </xs:restriction>
  471.                 </xs:simpleType>
  472.               </xs:element>
  473.               <xs:element name="c_lastname" minOccurs="0">
  474.                 <xs:simpleType>
  475.                   <xs:restriction base="xs:string">
  476.                     <xs:maxLength value="100" />
  477.                   </xs:restriction>
  478.                 </xs:simpleType>
  479.               </xs:element>
  480.               <xs:element name="c_address1" minOccurs="0">
  481.                 <xs:simpleType>
  482.                   <xs:restriction base="xs:string">
  483.                     <xs:maxLength value="100" />
  484.                   </xs:restriction>
  485.                 </xs:simpleType>
  486.               </xs:element>
  487.               <xs:element name="c_address2" minOccurs="0">
  488.                 <xs:simpleType>
  489.                   <xs:restriction base="xs:string">
  490.                     <xs:maxLength value="100" />
  491.                   </xs:restriction>
  492.                 </xs:simpleType>
  493.               </xs:element>
  494.               <xs:element name="i_province">
  495.                 <xs:simpleType>
  496.                   <xs:restriction base="xs:string">
  497.                     <xs:maxLength value="3" />
  498.                   </xs:restriction>
  499.                 </xs:simpleType>
  500.               </xs:element>
  501.               <xs:element name="i_zipcode" minOccurs="0">
  502.                 <xs:simpleType>
  503.                   <xs:restriction base="xs:string">
  504.                     <xs:maxLength value="5" />
  505.                   </xs:restriction>
  506.                 </xs:simpleType>
  507.               </xs:element>
  508.               <xs:element name="c_licence">
  509.                 <xs:simpleType>
  510.                   <xs:restriction base="xs:string">
  511.                     <xs:maxLength value="10" />
  512.                   </xs:restriction>
  513.                 </xs:simpleType>
  514.               </xs:element>
  515.               <xs:element name="i_prov_licence">
  516.                 <xs:simpleType>
  517.                   <xs:restriction base="xs:string">
  518.                     <xs:maxLength value="2" />
  519.                   </xs:restriction>
  520.                 </xs:simpleType>
  521.               </xs:element>
  522.               <xs:element name="i_car_make">
  523.                 <xs:simpleType>
  524.                   <xs:restriction base="xs:string">
  525.                     <xs:maxLength value="10" />
  526.                   </xs:restriction>
  527.                 </xs:simpleType>
  528.               </xs:element>
  529.               <xs:element name="i_car_model">
  530.                 <xs:simpleType>
  531.                   <xs:restriction base="xs:string">
  532.                     <xs:maxLength value="10" />
  533.                   </xs:restriction>
  534.                 </xs:simpleType>
  535.               </xs:element>
  536.               <xs:element name="c_chassis">
  537.                 <xs:simpleType>
  538.                   <xs:restriction base="xs:string">
  539.                     <xs:maxLength value="35" />
  540.                   </xs:restriction>
  541.                 </xs:simpleType>
  542.               </xs:element>
  543.               <xs:element name="c_body">
  544.                 <xs:simpleType>
  545.                   <xs:restriction base="xs:string">
  546.                     <xs:maxLength value="35" />
  547.                   </xs:restriction>
  548.                 </xs:simpleType>
  549.               </xs:element>
  550.               <xs:element name="c_engine" minOccurs="0">
  551.                 <xs:simpleType>
  552.                   <xs:restriction base="xs:string">
  553.                     <xs:maxLength value="35" />
  554.                   </xs:restriction>
  555.                 </xs:simpleType>
  556.               </xs:element>
  557.               <xs:element name="c_color">
  558.                 <xs:simpleType>
  559.                   <xs:restriction base="xs:string">
  560.                     <xs:maxLength value="20" />
  561.                   </xs:restriction>
  562.                 </xs:simpleType>
  563.               </xs:element>
  564.               <xs:element name="i_veh">
  565.                 <xs:simpleType>
  566.                   <xs:restriction base="xs:string">
  567.                     <xs:maxLength value="2" />
  568.                   </xs:restriction>
  569.                 </xs:simpleType>
  570.               </xs:element>
  571.               <xs:element name="i_usage">
  572.                 <xs:simpleType>
  573.                   <xs:restriction base="xs:string">
  574.                     <xs:maxLength value="2" />
  575.                   </xs:restriction>
  576.                 </xs:simpleType>
  577.               </xs:element>
  578.               <xs:element name="i_veh_size">
  579.                 <xs:simpleType>
  580.                   <xs:restriction base="xs:string">
  581.                     <xs:maxLength value="1" />
  582.                   </xs:restriction>
  583.                 </xs:simpleType>
  584.               </xs:element>
  585.               <xs:element name="q_disp" type="xs:int" />
  586.               <xs:element name="q_seat" type="xs:int" />
  587.               <xs:element name="q_gvw" type="xs:decimal" />
  588.               <xs:element name="m_pm" type="xs:decimal" />
  589.               <xs:element name="p_disc_direct" type="xs:decimal" />
  590.               <xs:element name="m_disc_direct" type="xs:decimal" />
  591.               <xs:element name="m_duty" type="xs:decimal" />
  592.               <xs:element name="p_vat" type="xs:decimal" />
  593.               <xs:element name="m_tax" type="xs:decimal" />
  594.               <xs:element name="m_gross" type="xs:decimal" />
  595.               <xs:element name="e_bookno">
  596.                 <xs:simpleType>
  597.                   <xs:restriction base="xs:string">
  598.                     <xs:maxLength value="15" />
  599.                   </xs:restriction>
  600.                 </xs:simpleType>
  601.               </xs:element>
  602.               <xs:element name="e_receipt">
  603.                 <xs:simpleType>
  604.                   <xs:restriction base="xs:string">
  605.                     <xs:maxLength value="15" />
  606.                   </xs:restriction>
  607.                 </xs:simpleType>
  608.               </xs:element>
  609.               <xs:element name="d_key" type="xs:dateTime" />
  610.               <xs:element name="i_key">
  611.                 <xs:simpleType>
  612.                   <xs:restriction base="xs:string">
  613.                     <xs:maxLength value="15" />
  614.                   </xs:restriction>
  615.                 </xs:simpleType>
  616.               </xs:element>
  617.               <xs:element name="d_send_pol" type="xs:dateTime" />
  618.               <xs:element name="i_send_pol">
  619.                 <xs:simpleType>
  620.                   <xs:restriction base="xs:string">
  621.                     <xs:maxLength value="15" />
  622.                   </xs:restriction>
  623.                 </xs:simpleType>
  624.               </xs:element>
  625.               <xs:element name="n_usage">
  626.                 <xs:simpleType>
  627.                   <xs:restriction base="xs:string">
  628.                     <xs:maxLength value="100" />
  629.                   </xs:restriction>
  630.                 </xs:simpleType>
  631.               </xs:element>
  632.               <xs:element name="i_ag_main">
  633.                 <xs:simpleType>
  634.                   <xs:restriction base="xs:string">
  635.                     <xs:maxLength value="15" />
  636.                   </xs:restriction>
  637.                 </xs:simpleType>
  638.               </xs:element>
  639.               <xs:element name="f_transfer">
  640.                 <xs:simpleType>
  641.                   <xs:restriction base="xs:string">
  642.                     <xs:maxLength value="3" />
  643.                   </xs:restriction>
  644.                 </xs:simpleType>
  645.               </xs:element>
  646.               <xs:element name="d_transfer" type="xs:dateTime" />
  647.               <xs:element name="f_Export" minOccurs="0">
  648.                 <xs:simpleType>
  649.                   <xs:restriction base="xs:string">
  650.                     <xs:maxLength value="1" />
  651.                   </xs:restriction>
  652.                 </xs:simpleType>
  653.               </xs:element>
  654.               <xs:element name="d_Export" type="xs:dateTime" minOccurs="0" />
  655.               <xs:element name="TU_Eff_Date" minOccurs="0">
  656.                 <xs:simpleType>
  657.                   <xs:restriction base="xs:string">
  658.                     <xs:maxLength value="8" />
  659.                   </xs:restriction>
  660.                 </xs:simpleType>
  661.               </xs:element>
  662.               <xs:element name="TU_Type_Code">
  663.                 <xs:simpleType>
  664.                   <xs:restriction base="xs:string">
  665.                     <xs:maxLength value="2" />
  666.                   </xs:restriction>
  667.                 </xs:simpleType>
  668.               </xs:element>
  669.               <xs:element name="TU_Usage_Code">
  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="TU_Desc" minOccurs="0">
  677.                 <xs:simpleType>
  678.                   <xs:restriction base="xs:string">
  679.                     <xs:maxLength value="50" />
  680.                   </xs:restriction>
  681.                 </xs:simpleType>
  682.               </xs:element>
  683.               <xs:element name="TU_Usage_Desc" minOccurs="0">
  684.                 <xs:simpleType>
  685.                   <xs:restriction base="xs:string">
  686.                     <xs:maxLength value="50" />
  687.                   </xs:restriction>
  688.                 </xs:simpleType>
  689.               </xs:element>
  690.               <xs:element name="TU_Pol_Txt" minOccurs="0">
  691.                 <xs:simpleType>
  692.                   <xs:restriction base="xs:string">
  693.                     <xs:maxLength value="120" />
  694.                   </xs:restriction>
  695.                 </xs:simpleType>
  696.               </xs:element>
  697.               <xs:element name="TU_No_Seat" type="xs:unsignedByte" minOccurs="0" />
  698.               <xs:element name="Expr1">
  699.                 <xs:simpleType>
  700.                   <xs:restriction base="xs:string">
  701.                     <xs:maxLength value="15" />
  702.                   </xs:restriction>
  703.                 </xs:simpleType>
  704.               </xs:element>
  705.               <xs:element name="Expr2">
  706.                 <xs:simpleType>
  707.                   <xs:restriction base="xs:string">
  708.                     <xs:maxLength value="100" />
  709.                   </xs:restriction>
  710.                 </xs:simpleType>
  711.               </xs:element>
  712.               <xs:element name="Expr3" minOccurs="0">
  713.                 <xs:simpleType>
  714.                   <xs:restriction base="xs:string">
  715.                     <xs:maxLength value="100" />
  716.                   </xs:restriction>
  717.                 </xs:simpleType>
  718.               </xs:element>
  719.               <xs:element name="Expr4">
  720.                 <xs:simpleType>
  721.                   <xs:restriction base="xs:string">
  722.                     <xs:maxLength value="15" />
  723.                   </xs:restriction>
  724.                 </xs:simpleType>
  725.               </xs:element>
  726.               <xs:element name="Expr5">
  727.                 <xs:simpleType>
  728.                   <xs:restriction base="xs:string">
  729.                     <xs:maxLength value="3" />
  730.                   </xs:restriction>
  731.                 </xs:simpleType>
  732.               </xs:element>
  733.               <xs:element name="Expr6" type="xs:int" />
  734.               <xs:element name="Expr7" minOccurs="0">
  735.                 <xs:simpleType>
  736.                   <xs:restriction base="xs:string">
  737.                     <xs:maxLength value="1" />
  738.                   </xs:restriction>
  739.                 </xs:simpleType>
  740.               </xs:element>
  741.               <xs:element name="name" minOccurs="0">
  742.                 <xs:simpleType>
  743.                   <xs:restriction base="xs:string">
  744.                     <xs:maxLength value="30" />
  745.                   </xs:restriction>
  746.                 </xs:simpleType>
  747.               </xs:element>
  748.               <xs:element name="i_agen_code" minOccurs="0">
  749.                 <xs:simpleType>
  750.                   <xs:restriction base="xs:string">
  751.                     <xs:maxLength value="2" />
  752.                   </xs:restriction>
  753.                 </xs:simpleType>
  754.               </xs:element>
  755.               <xs:element name="c_province_name" minOccurs="0">
  756.                 <xs:simpleType>
  757.                   <xs:restriction base="xs:string">
  758.                     <xs:maxLength value="255" />
  759.                   </xs:restriction>
  760.                 </xs:simpleType>
  761.               </xs:element>
  762.               <xs:element name="n_changwat">
  763.                 <xs:simpleType>
  764.                   <xs:restriction base="xs:string">
  765.                     <xs:maxLength value="15" />
  766.                   </xs:restriction>
  767.                 </xs:simpleType>
  768.               </xs:element>
  769.               <xs:element name="i_agen_code_" minOccurs="0">
  770.                 <xs:simpleType>
  771.                   <xs:restriction base="xs:string">
  772.                     <xs:maxLength value="20" />
  773.                   </xs:restriction>
  774.                 </xs:simpleType>
  775.               </xs:element>
  776.               <xs:element name="i_initial">
  777.                 <xs:simpleType>
  778.                   <xs:restriction base="xs:string">
  779.                     <xs:maxLength value="8" />
  780.                   </xs:restriction>
  781.                 </xs:simpleType>
  782.               </xs:element>
  783.               <xs:element name="n_initial">
  784.                 <xs:simpleType>
  785.                   <xs:restriction base="xs:string">
  786.                     <xs:maxLength value="30" />
  787.                   </xs:restriction>
  788.                 </xs:simpleType>
  789.               </xs:element>
  790.               <xs:element name="f_copy" msprop:nullValue="_empty" type="xs:string" default="" minOccurs="0" />
  791.             </xs:sequence>
  792.           </xs:complexType>
  793.         </xs:element>
  794.       </xs:choice>
  795.     </xs:complexType>
  796.   </xs:element>
  797. </xs:schema>