Subversion Repositories SmartDukaan

           </partitioning>

           </partitioning>

    <connection>transactionDC_Prod</connection>

    <connection>transactionDC_Prod</connection>

    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status, 

    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status, 

l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days, 

l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days, 

datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days, 

datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days, 

from `order` o 

from `order` o 

left join lineitem l on (o.id = l.order_id) 

left join lineitem l on (o.id = l.order_id) 

where o.status not in (0, 1)</sql>

where o.status not in (0, 1)</sql>

    <limit>0</limit>

    <limit>0</limit>

    <lookup/>

    <lookup/>

        <precision>-2</precision>

        <precision>-2</precision>

      </field>      <field>        <name>actual_estimate_diff</name>

      </field>      <field>        <name>actual_estimate_diff</name>

        <rename/>

        <rename/>

        <length>-2</length>

        <length>-2</length>

        <precision>-2</precision>

        <precision>-2</precision>

      </field>        <select_unspecified>N</select_unspecified>

      </field>        <select_unspecified>N</select_unspecified>

    </fields>     <cluster_schema/>

    </fields>     <cluster_schema/>

 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

      <xloc>371</xloc>

      <xloc>371</xloc>

      <yloc>160</yloc>

      <yloc>160</yloc>