Abfrage Zuteilung Preissynchronisationsgruppe
Über SQL-Abfrage (TBase -> Extras) kann eine Liste mit allen Leistungen gezogen werden, welche einer bestimmten Preissynchronisationsgruppe zugeteilt sind.
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 |