Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011929ModulesInitial data loadpublic2010-01-11 12:412011-07-20 18:09
Reportermgerke 
Assigned Tojonalegriaesarte 
PrioritynormalSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0011929: Missing Bank Account Routing Number, missing BIC/SWIFT
Description/Xidl/Functional_Specifications/Business_Partners

In Germany a bank account needs:
- account number
- bank routing number
- BIC (SWIFT)

Initial Data Load for Business Partners is useless for Germany without fields for routing number and BIC

In manual dialogs:
Routing numbers are chosen from a list (updated quarterly)
Account numbers are checked against the routing number

IBAN is calculated from account and routing number

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-11 12:41mgerkeNew Issue
2010-01-11 12:41mgerkeAssigned To => mirurita
2010-01-12 15:52mgerkeNote Added: 0023361
2010-02-11 13:56psarobeStatusnew => scheduled
2010-02-11 13:56psarobefix_in_branch => pi
2011-06-03 11:11dalsasuaAssigned Tomirurita => dalsasua
2011-07-20 18:09dalsasuaAssigned Todalsasua => jonalegriaesarte

Notes
(0023361)
mgerke   
2010-01-12 15:52   
The fields are already in the c_bp_bankaccount table.

=> routingno character varying(20), -- --OBTG:NVARCHAR--
    accountno character varying(20), -- --OBTG:NVARCHAR--
    iban character varying(34), -- --OBTG:NVARCHAR--
=> swiftcode character varying(20), -- --OBTG:NVARCHAR--