src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql
changeset 799 fef2c5e2feb7
parent 564 7a8d97aafa29
child 1075 e15725d9a757
equal deleted inserted replaced
798:4994e5a604bb 799:fef2c5e2feb7
   460     <Sql>
   460     <Sql>
   461       <![CDATA[
   461       <![CDATA[
   462         INSERT INTO C_DocType(C_DocType_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,
   462         INSERT INTO C_DocType(C_DocType_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,
   463         Name,PrintName,DocBaseType,DocSubTypeSO,
   463         Name,PrintName,DocBaseType,DocSubTypeSO,
   464         C_DocTypeShipment_ID,C_DocTypeInvoice_ID,IsDocNoControlled,DocNoSequence_ID,GL_Category_ID,
   464         C_DocTypeShipment_ID,C_DocTypeInvoice_ID,IsDocNoControlled,DocNoSequence_ID,GL_Category_ID,
   465         IsPrinted,IsTransferred,DocumentCopies,IsSOTrx, ad_table_id)
   465         DocumentCopies,IsSOTrx, ad_table_id)
   466         VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),'Y',?,0,?,TO_NUMBER(?))
   466         VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),0,?,TO_NUMBER(?))
   467       ]]>
   467       ]]>
   468     </Sql>
   468     </Sql>
   469     <Parameter name="C_DocType_ID"/>
   469     <Parameter name="C_DocType_ID"/>
   470     <Parameter name="AD_Client_ID"/>
   470     <Parameter name="AD_Client_ID"/>
   471     <Parameter name="Name"/>
   471     <Parameter name="Name"/>
   475     <Parameter name="C_DocTypeShipment_ID"/>
   475     <Parameter name="C_DocTypeShipment_ID"/>
   476     <Parameter name="C_DocTypeInvoice_ID"/>
   476     <Parameter name="C_DocTypeInvoice_ID"/>
   477     <Parameter name="IsDocNoControlled"/>
   477     <Parameter name="IsDocNoControlled"/>
   478     <Parameter name="AD_Sequence_ID"/>
   478     <Parameter name="AD_Sequence_ID"/>
   479     <Parameter name="GL_Category_ID"/>
   479     <Parameter name="GL_Category_ID"/>
   480     <Parameter name="IsTransferred"/>
       
   481     <Parameter name="IsSOTrx"/>
   480     <Parameter name="IsSOTrx"/>
   482     <Parameter name="adTableId"/>
   481     <Parameter name="adTableId"/>
   483   </SqlMethod>
   482   </SqlMethod>
   484       <SqlMethod name="insertElementValue" type="preparedStatement" connection="true" return="rowCount">
   483       <SqlMethod name="insertElementValue" type="preparedStatement" connection="true" return="rowCount">
   485     <SqlMethodComment></SqlMethodComment>
   484     <SqlMethodComment></SqlMethodComment>
   863   </SqlMethod>
   862   </SqlMethod>
   864   <SqlMethod name="insertPaymentTerm" type="preparedStatement" connection="true" return="rowCount">
   863   <SqlMethod name="insertPaymentTerm" type="preparedStatement" connection="true" return="rowCount">
   865     <SqlMethodComment></SqlMethodComment>
   864     <SqlMethodComment></SqlMethodComment>
   866     <Sql>
   865     <Sql>
   867       INSERT INTO C_PaymentTerm (C_PaymentTerm_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,
   866       INSERT INTO C_PaymentTerm (C_PaymentTerm_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,
   868       CreatedBy,Updated,UpdatedBy,Value,Name,NetDays,GraceDays,
   867       CreatedBy,Updated,UpdatedBy,Value,Name,NetDays,IsDefault) 
   869       DiscountDays,Discount,DiscountDays2,Discount2,IsDefault) 
   868       VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,'Immediate','Immediate',0,'Y')
   870       VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,'Immediate','Immediate',0,0,0,0,0,0,'Y')
       
   871     </Sql>
   869     </Sql>
   872     <Parameter name="C_PaymentTerm_ID"/>
   870     <Parameter name="C_PaymentTerm_ID"/>
   873     <Parameter name="AD_Client_ID"/>
   871     <Parameter name="AD_Client_ID"/>
   874   </SqlMethod>
   872   </SqlMethod>
   875   <SqlMethod name="insertCycle" type="preparedStatement" connection="true" return="rowCount">
   873   <SqlMethod name="insertCycle" type="preparedStatement" connection="true" return="rowCount">