1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| select
ITMREF_0 as ref_article,
ITMDES1_0 as des_article,
TLCCOD_0 as categorie,
X_TYPVIN_0 as type_vin,
case X_COUL_0 when 'R' then 'Rouge' when 'S' then 'Rosé' when 'B' then 'Blanc' when 'X' then 'Indéterminé' end as couleur,
X_MILL_0 as millesime,
X_FORMAT_0 as format_vin,
X_DESVIN_0 as desig_libelle,
X_CAPSULE_0 as capsule,
X_ETIQ_0 as etiquette,
X_ETUI_0 as etui,
X_TYPCAIS_0 as type_caisse,
X_NBFCDT_0 as contenance,
X_RACINE_0 as racine,
STU_0 as unite_stock,
SAU_0 as unite_vente,
SSUSTUCOE_0 as coefficient, |
Partager