Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010707Openbravo ERP09. Financial managementpublic2009-09-23 10:042009-10-16 00:00
eduardo_Argal 
eduardo_Argal 
highmajoralways
closedfixed 
5
pi 
2.50MP72.50MP7 
Core
No
0010707: Wrong column data type definition in Fact_Acct: DocBaseType
Wrong column data type definition in Fact_Acct: DocBaseType

Now a days it is char(3), and this prevents modularity to create new docbasetypes as the DB Prefix has to be included
Go to database and mind the datatype for DocBaseType column Char(3)
Go to database and modify the datatype for DocBaseType column from Char(3) to NVARCHAR (40)
No tags attached.
related to defect 0010939 closed dalsasua API check build 171 fails - part1 
Issue History
2009-09-23 10:04eduardo_ArgalNew Issue
2009-09-23 10:04eduardo_ArgalAssigned To => eduardo_Argal
2009-09-23 10:06eduardo_ArgalStatusnew => scheduled
2009-09-23 10:06eduardo_Argalfix_in_branch => pi
2009-09-23 11:59hgbotCheckin
2009-09-23 11:59hgbotNote Added: 0020307
2009-09-23 11:59hgbotStatusscheduled => resolved
2009-09-23 11:59hgbotResolutionopen => fixed
2009-09-23 11:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]
2009-09-23 16:11psarobeTarget Versionpi => 2.50MP6
2009-09-23 16:12psarobeTag Attached: 250mp6
2009-09-25 10:52psarobeTag Detached: 250mp6
2009-09-25 10:53psarobeTarget Version2.50MP6 => 2.50MP7
2009-09-25 10:53psarobefix_in_branchpi =>
2009-09-29 14:17hgbotCheckin
2009-09-29 14:17hgbotNote Added: 0020503
2009-09-29 14:17hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]
2009-10-07 13:40sureshbabuStatusresolved => new
2009-10-07 13:40sureshbabuResolutionfixed => open
2009-10-07 13:40sureshbabuNote Added: 0020844
2009-10-09 13:46psarobeStatusnew => scheduled
2009-10-09 13:46psarobefix_in_branch => pi
2009-10-13 10:39shuehnerRelationship addedrelated to 0010939
2009-10-15 09:30dalsasuaStatusscheduled => resolved
2009-10-15 09:30dalsasuaFixed in Version => pi
2009-10-15 09:30dalsasuaResolutionopen => fixed
2009-10-15 09:30dalsasuaNote Added: 0021025
2009-10-15 09:45sureshbabuStatusresolved => closed
2009-10-15 09:45sureshbabuNote Added: 0021026
2009-10-15 09:45sureshbabuFixed in Versionpi => 2.50MP7
2009-10-16 00:00anonymoussf_bug_id0 => 2880176

Notes
(0020307)
hgbot   
2009-09-23 11:59   
Repository: erp/devel/pi
Changeset: 9434157dc8fb81424824c0980d75dc58fbc9a9c5
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Sep 23 10:06:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]

Fixes issue 0010707: Wrong column data type definition in Fact_Acct: DocBaseType

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0020503)
hgbot   
2009-09-29 14:17   
Repository: erp/devel/pi-pageddatagrid
Changeset: 9434157dc8fb81424824c0980d75dc58fbc9a9c5
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Sep 23 10:06:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]

Fixes issue 0010707: Wrong column data type definition in Fact_Acct: DocBaseType

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0020844)
sureshbabu   
2009-10-07 13:40   
change is reflecting only in Orcale database not in Postgres.
(0021025)
dalsasua   
2009-10-15 09:30   
It's working fine, for me, in Postgresql as well.
(0021026)
sureshbabu   
2009-10-15 09:45   
Retested, working fine in both the context.