src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_Lines_data.xsql
changeset 799 fef2c5e2feb7
parent 423 ecf368072c48
child 1605 8a0fe0193bef
--- a/src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_Lines_data.xsql	Wed Apr 30 10:48:47 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_Lines_data.xsql	Mon May 05 06:59:24 2008 +0000
@@ -28,7 +28,7 @@
     <SqlMethodComment></SqlMethodComment>
     <Sql>
       <![CDATA[
-      SELECT C_INVOICELINE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_INVOICE_ID, C_ORDERLINE_ID, M_INOUTLINE_ID, LINE, DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, A_ASSET_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, C_INVOICE_DISCOUNT_ID, 
+      SELECT C_INVOICELINE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_INVOICE_ID, C_ORDERLINE_ID, M_INOUTLINE_ID, LINE, DESCRIPTION, M_PRODUCT_ID, QTYINVOICED, PRICELIST, PRICEACTUAL, PRICELIMIT, LINENETAMT, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, C_INVOICE_DISCOUNT_ID, 
       AD_COLUMN_IDENTIFIER(TO_CHAR('M_Product'), TO_CHAR(M_PRODUCT_ID), TO_CHAR(?)) AS M_PRODUCT_ID_D, PRICESTD, M_OFFER_ID 
       FROM C_INVOICELINE 
       WHERE C_INVOICE_ID = TO_NUMBER(?) 
@@ -80,7 +80,7 @@
     <Sql><![CDATA[
         UPDATE C_INVOICELINE SET UPDATEDBY = TO_NUMBER(?), UPDATED = now(), M_PRODUCT_ID = TO_NUMBER(?), QTYINVOICED = TO_NUMBER(?), C_TAX_ID = TO_NUMBER(?), 
         DESCRIPTION = ?, PRICELIST = TO_NUMBER(?), PRICEACTUAL = TO_NUMBER(?), PRICELIMIT = TO_NUMBER(?), LINENETAMT = (TO_NUMBER(?)*TO_NUMBER(?)), 
-        C_CHARGE_ID = TO_NUMBER(?), CHARGEAMT = TO_NUMBER(?), C_UOM_ID = TO_NUMBER(?), S_RESOURCEASSIGNMENT_ID = TO_NUMBER(?), A_ASSET_ID = TO_NUMBER(?), TAXAMT = TO_NUMBER(?), 
+        C_CHARGE_ID = TO_NUMBER(?), CHARGEAMT = TO_NUMBER(?), C_UOM_ID = TO_NUMBER(?), S_RESOURCEASSIGNMENT_ID = TO_NUMBER(?), TAXAMT = TO_NUMBER(?), 
         M_ATTRIBUTESETINSTANCE_ID = TO_NUMBER(?), ISDESCRIPTION = ?, QUANTITYORDER = TO_NUMBER(?), M_PRODUCT_UOM_ID = TO_NUMBER(?), C_INVOICE_DISCOUNT_ID = TO_NUMBER(?), 
         PRICESTD = TO_NUMBER(?)
         WHERE C_INVOICELINE_ID = TO_NUMBER(?) 
@@ -99,7 +99,6 @@
     <Parameter name="chargeamt"/>
     <Parameter name="cUomId"/>
     <Parameter name="sResourceassignmentId"/>
-    <Parameter name="aAssetId"/>
     <Parameter name="taxamt"/>
     <Parameter name="mAttributesetinstanceId"/>
     <Parameter name="isdescription"/>
@@ -120,7 +119,7 @@
     PRICELIST, PRICEACTUAL, PRICELIMIT, 
     LINENETAMT, C_CHARGE_ID, CHARGEAMT, 
     C_UOM_ID, C_TAX_ID, S_RESOURCEASSIGNMENT_ID, 
-    A_ASSET_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID, 
+    TAXAMT, M_ATTRIBUTESETINSTANCE_ID, 
     ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID, 
     C_INVOICE_DISCOUNT_ID, PRICESTD) 
     VALUES ( TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), 
@@ -157,7 +156,6 @@
     <Parameter name="cUomId"/>
     <Parameter name="cTaxId"/>
     <Parameter name="sResourceassignmentId"/>
-    <Parameter name="aAssetId"/>
     <Parameter name="taxamt"/>
     <Parameter name="mAttributesetinstanceId"/>
     <Parameter name="isdescription"/>