src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
changeset 799 fef2c5e2feb7
parent 597 284cd726c37c
child 895 ae9ae8e8c9cc
equal deleted inserted replaced
798:4994e5a604bb 799:fef2c5e2feb7
    67     <Sql>
    67     <Sql>
    68       <![CDATA[
    68       <![CDATA[
    69         INSERT INTO C_ORDER (C_ORDER_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, UPDATED, UPDATEDBY, DOCUMENTNO,
    69         INSERT INTO C_ORDER (C_ORDER_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, UPDATED, UPDATEDBY, DOCUMENTNO,
    70         DOCSTATUS, DOCACTION, PROCESSING, C_DOCTYPE_ID, C_DOCTYPETARGET_ID,
    70         DOCSTATUS, DOCACTION, PROCESSING, C_DOCTYPE_ID, C_DOCTYPETARGET_ID,
    71         DATEORDERED, DATEPROMISED, DATEACCT, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, BILLTO_ID, C_CURRENCY_ID, 
    71         DATEORDERED, DATEPROMISED, DATEACCT, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, BILLTO_ID, C_CURRENCY_ID, 
    72         PAYMENTRULE, C_PAYMENTTERM_ID, INVOICERULE, DELIVERYRULE, FREIGHTCOSTRULE, 
    72         PAYMENTRULE, C_PAYMENTTERM_ID, INVOICERULE, DELIVERYRULE,
    73         DELIVERYVIARULE, M_WAREHOUSE_ID, M_PRICELIST_ID, 
    73         DELIVERYVIARULE, M_WAREHOUSE_ID, M_PRICELIST_ID, 
    74         C_PROJECT_ID, C_ACTIVITY_ID, C_CAMPAIGN_ID, PRIORITYRULE)
    74         C_PROJECT_ID, C_ACTIVITY_ID, C_CAMPAIGN_ID, PRIORITYRULE)
    75         VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),now(),TO_NUMBER(?),now(),TO_NUMBER(?),?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),TO_DATE(?),TO_DATE(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'5')
    75         VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),now(),TO_NUMBER(?),now(),TO_NUMBER(?),?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),TO_DATE(?),TO_DATE(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'5')
    76       ]]>
    76       ]]>
    77     </Sql>
    77     </Sql>
    78     <Parameter name="cOrderId"/>
    78     <Parameter name="cOrderId"/>
    79     <Parameter name="adClientId"/>
    79     <Parameter name="adClientId"/>
    80     <Parameter name="adOrgId"/>
    80     <Parameter name="adOrgId"/>
    95     <Parameter name="cCurrencyId"/>
    95     <Parameter name="cCurrencyId"/>
    96     <Parameter name="paymentrule"/>
    96     <Parameter name="paymentrule"/>
    97     <Parameter name="cPaymenttermId"/>
    97     <Parameter name="cPaymenttermId"/>
    98     <Parameter name="invoicerule"/>
    98     <Parameter name="invoicerule"/>
    99     <Parameter name="deliveryrule"/>
    99     <Parameter name="deliveryrule"/>
   100     <Parameter name="freightcostrule"/>
       
   101     <Parameter name="deliveryviarule"/>
   100     <Parameter name="deliveryviarule"/>
   102     <Parameter name="mWarehouseId"/>
   101     <Parameter name="mWarehouseId"/>
   103     <Parameter name="mPricelistId"/>
   102     <Parameter name="mPricelistId"/>
   104     <Parameter name="cProjectId"/>
   103     <Parameter name="cProjectId"/>
   105     <Parameter name="cActivityId"/>
   104     <Parameter name="cActivityId"/>