Abfrage Zuteilung Preissynchronisationsgruppe
Über SQL-Abfrage (TBase -> Extras) kann eine Liste mit allen Leistungen gezogen werden, welche einer bestimmten Preissynchronisationsgruppe zugeteilt sind.
| Info | ||||
|---|---|---|---|---|
| ||||
| SELECT lt.s_id AS LT_ID, lt.describing_name_de AS LT_NAME, srv.s_id AS LEISTUNG_ID, srv.describing_name_de AS LEISTUNG_NAME, lva_value AS PREIS_SYNC_GRUPPE FROM tbx_service_provider, tbx_to_simple lt, tbx_service, tbx_to_simple srv, wbx_data_lookup, wbx_lookup_values WHERE tbx_service_provider.s_id = lt.s_id AND tbx_service.s_id = srv.s_id AND tbx_service.service_provider_id = tbx_service_provider.s_id AND tbx_service.s_id = wbx_data_lookup.dlo_dba_id AND wbx_data_lookup.dlo_dfi_id = "TBX00020010001913775" AND wbx_data_lookup.dlo_value = wbx_lookup_values.lva_loo_id AND wbx_lookup_values.lva_lan_code = "de" AND wbx_data_lookup.dlo_value IN ("TDS00020010903810546") ORDER BY 2,3 |
Aktuell verwendete Preissynchronisations-Gruppen:
Name Preissynchronisationsgruppe | TOMAS-ID |
|---|---|
SAVO: Pauschale | TDS00020010909192661 |
TESSVM: Pauschalen Hotel | TDS00020010903810546 |
TESSVM: Reserve Pauschalen Hotel | TDS00020010915101605 |
GRB_GRF_PAU_BUCHUNG | TDS00020010818144341 |
GRB_Promotions (Partner & Promo) | TDS00020010909198057 |
GRB_RhB_e-Tickets | TDS00020010896955372 |
| Anchor | ||||
|---|---|---|---|---|
|