0033727: Improve the initialization of the tables related with business partner segmentation

Description

The initialize.bp.segmentation.tables task was created to initialize the tables related with the business partner segmentation before the default store column was added to c_bpartner (see [1]).

As part of this task, the c_order table is used to determine for each business partner the list of stores he belongs to, and add a new record to obstsyn_server_bpartner for each line. After the change done in [1], this process should be updated so that the if the business partner has only bought from that store that store will be included as his default store, and if he has bought from several, one of them will be included as his default store and the rest as secondary stores in obstsyn_server_bpartner (which store is the default and which stores are the secondary stores does not matter).

[1] https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/edacffe523c3efd267703d17784dd0494e0d1cd4 [^]

Steps To Reproduce

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	feature request	0032252	RR16Q4	closed	AugustoMauch	Store Server Data Segmentation and Sync for BP
depends on	feature request	0035236	RR17Q2	closed	mtaal	Business Partner Segment: take into account financial payment records to determine what BPs to sync to a store
related to	defect	0034465		closed	AugustoMauch	Initialize.bp.segmentation.tables does not take into account BPartners of gift card instances

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2016-08-17 11:03	AugustoMauch	New Issue
2016-08-17 11:03	AugustoMauch	Assigned To	=> StoreServer
2016-08-17 11:03	AugustoMauch	Triggers an Emergency Pack	=> No
2016-08-17 11:03	AugustoMauch	Relationship added	related to 0032252
2016-08-25 15:30	mtaal	Assigned To	StoreServer => AugustoMauch
2017-01-05 10:07	AugustoMauch	Relationship added	related to 0034465
2017-02-13 14:30	mtaal	Relationship added	depends on 0035236