#Registro en tmovimientos de las provisiones, en este caso no actualiza saldos
org.hibernate.dialect.Oracle9Dialect.accoProvision = sum( round( (:nextAccountingDate - ts.fdesde ) * ts.provisiondia,2 ) )  provisiondia
org.hibernate.dialect.Oracle10gDialect.accoProvision = sum( round( (:nextAccountingDate - ts.fdesde ) * ts.provisiondia,2 ) )  provisiondia
org.hibernate.dialect.DB2400Dialect.accoProvision  = sum( round( (days(cast(:nextAccountingDate as date)) - days(ts.fdesde) ) * ts.provisiondia,2 ) )  provisiondia
org.hibernate.dialect.DB2Dialect.accoProvision     = sum( round( (days(cast(:nextAccountingDate as date)) - days(ts.fdesde) ) * ts.provisiondia,2 ) )  provisiondia 
org.hibernate.dialect.SQLServerDialect.accoProvision = sum( round( datediff(day,ts.fdesde,:nextAccountingDate ) * ts.provisiondia,2 ) )  provisiondia


#Obtiene el valor de la provision al dia anterior.
org.hibernate.dialect.Oracle9Dialect.yesterdayProvision = select sum( round( ( :nextAccountingDate  - ts.fdesde ) * ts.provisiondia ,2 )  ) provisiondia
org.hibernate.dialect.Oracle10gDialect.yesterdayProvision = select sum( round( ( :nextAccountingDate  - ts.fdesde ) * ts.provisiondia ,2 )  ) provisiondia
org.hibernate.dialect.DB2400Dialect.yesterdayProvision  = select sum( round( ( days(cast(:nextAccountingDate as date))  - days(ts.fdesde) ) * ts.provisiondia ,2 )  ) provisiondia
org.hibernate.dialect.DB2Dialect.yesterdayProvision     = select sum( round( ( days(cast(:nextAccountingDate as date))  - days(ts.fdesde) ) * ts.provisiondia ,2 )  ) provisiondia
org.hibernate.dialect.SQLServerDialect.yesterdayProvision = select sum( round( datediff(day, ts.fdesde,:nextAccountingDate ) * ts.provisiondia ,2 )  ) provisiondia