| Name | Description | Type | Additional information |
|---|---|---|---|
| zzmaj | integer |
None. |
|
| zzutil | string |
None. |
|
| zzposte | string |
None. |
|
| zzdate | string |
None. |
|
| zzheure | string |
None. |
|
| zzsynchro | integer |
None. |
|
| cde | string |
None. |
|
| date_cde | string |
None. |
|
| client | string |
None. |
|
| date_creation | string |
None. |
|
| heure_creation | string |
None. |
|
| numero_caisse | string |
None. |
|
| type_cli | string |
None. |
|
| poste_bloque | string |
None. |
|
| cde_type | string |
None. |
|
| avoirfact | string |
None. |
|
| type_avoir | string |
None. |
|
| facture_origine | string |
None. |
|
| date_facture_origine | string |
None. |
|
| bl_origine | string |
None. |
|
| date_origine | string |
None. |
|
| regbl | string |
None. |
|
| regroup | string |
None. |
|
| regroup_facture | string |
None. |
|
| gestion_alcool | string |
None. |
|
| gestion_ordonnance | string |
None. |
|
| refcli1 | string |
None. |
|
| refcli2 | string |
None. |
|
| status_cde | string |
None. |
|
| intra_suivi | string |
None. |
|
| intra_pays | string |
None. |
|
| intra_region | string |
None. |
|
| intra_cndlivr | string |
None. |
|
| intra_cmpllivr | string |
None. |
|
| intra_modetrsp | string |
None. |
|
| flgdeb | string |
None. |
|
| date_deb | string |
None. |
|
| remise_taxe_ligne | string |
None. |
|
| orgpay | string |
None. |
|
| group1 | string |
None. |
|
| group2 | string |
None. |
|
| adherent1 | string |
None. |
|
| adherent2 | string |
None. |
|
| fam1 | string |
None. |
|
| fam2 | string |
None. |
|
| fam3 | string |
None. |
|
| fam4 | string |
None. |
|
| subvention | string |
None. |
|
| article_trace | string |
None. |
|
| opebon | string |
None. |
|
| opcmde | string |
None. |
|
| orig | string |
None. |
|
| tarif | string |
None. |
|
| lot_marche | string |
None. |
|
| tarif2 | string |
None. |
|
| cond_spec_gen | string |
None. |
|
| promo_spec_gen | string |
None. |
|
| cptventil | string |
None. |
|
| facture | string |
None. |
|
| datefact | string |
None. |
|
| facture_date_edition | string |
None. |
|
| facture_heure_edition | string |
None. |
|
| empreinte | string |
None. |
|
| ttc | decimal number |
None. |
|
| ttc_facture | decimal number |
None. |
|
| regl | string |
None. |
|
| eche | string |
None. |
|
| eche_calc | string |
None. |
|
| rpeche | integer |
None. |
|
| eche_manuelle | string |
None. |
|
| dateeche1 | string |
None. |
|
| nbeche | integer |
None. |
|
| perfact | string |
None. |
|
| flgfixfac | string |
None. |
|
| fact_nbex | integer |
None. |
|
| perrel | string |
None. |
|
| flgfixrel | string |
None. |
|
| flgnetfac | string |
None. |
|
| infofact | string |
None. |
|
| textfact | string |
None. |
|
| langue | string |
None. |
|
| devise | string |
None. |
|
| tauxdevise | decimal number |
None. |
|
| flgttc | string |
None. |
|
| vendeur | string |
None. |
|
| representant | string |
None. |
|
| com_rep | decimal number |
None. |
|
| escompte | decimal number |
None. |
|
| typrem | string |
None. |
|
| valrem | decimal number |
None. |
|
| remise1_calc | string |
None. |
|
| remise1_taux | decimal number |
None. |
|
| remise1_val | decimal number |
None. |
|
| remise2_calc | string |
None. |
|
| remise2_taux | decimal number |
None. |
|
| remise2_val | decimal number |
None. |
|
| remise3_calc | string |
None. |
|
| remise3_taux | decimal number |
None. |
|
| remise3_val | decimal number |
None. |
|
| typrist | string |
None. |
|
| valrist | decimal number |
None. |
|
| nu_loge | string |
None. |
|
| depart_rendu | string |
None. |
|
| controle_saisie | integer |
None. |
|
| flgbon | string |
None. |
|
| flag_etat_beeper | string |
None. |
|
| flgreliquat | string |
None. |
|
| datebon | string |
None. |
|
| flgedbon | string |
None. |
|
| flgchbon | string |
None. |
|
| flgvalbon | string |
None. |
|
| flgalcool | string |
None. |
|
| flgeddcsa | string |
None. |
|
| flgconsigne_valorise | string |
None. |
|
| nbex | integer |
None. |
|
| flgfranco | string |
None. |
|
| port | decimal number |
None. |
|
| transporteur | string |
None. |
|
| transitaire | string |
None. |
|
| livreur | string |
None. |
|
| camion | string |
None. |
|
| secteur | string |
None. |
|
| tournee | string |
None. |
|
| tournee_etat | string |
None. |
|
| tournee_origine | string |
None. |
|
| ordrelivr | string |
None. |
|
| ordrelivr_origine | string |
None. |
|
| datelivr | string |
None. |
|
| infolivr1 | string |
None. |
|
| infolivr2 | string |
None. |
|
| textlivr | string |
None. |
|
| heureramasse | string |
None. |
|
| recepisse | string |
None. |
|
| heureminlivr | string |
None. |
|
| heuremaxlivr | string |
None. |
|
| heuresouhaitee | string |
None. |
|
| titre | string |
None. |
|
| raison | string |
None. |
|
| raison2 | string |
None. |
|
| adr1 | string |
None. |
|
| adr2 | string |
None. |
|
| adr3 | string |
None. |
|
| ccp | string |
None. |
|
| ville | string |
None. |
|
| pays | string |
None. |
|
| num_tel | string |
None. |
|
| noadrlivr | string |
None. |
|
| titrelivr | string |
None. |
|
| raisonlivr | string |
None. |
|
| adr1livr | string |
None. |
|
| adr2livr | string |
None. |
|
| adr3livr | string |
None. |
|
| ccplivr | string |
None. |
|
| villelivr | string |
None. |
|
| payslivr | string |
None. |
|
| noadrenlev | string |
None. |
|
| titreenlev | string |
None. |
|
| raisonenlev | string |
None. |
|
| adr1enlev | string |
None. |
|
| adr2enlev | string |
None. |
|
| adr3enlev | string |
None. |
|
| cpenlev | string |
None. |
|
| villeenlev | string |
None. |
|
| paysenlev | string |
None. |
|
| flginter_site | string |
None. |
|
| flgcompta | string |
None. |
|
| flgedi | string |
None. |
|
| impu_compta | string |
None. |
|
| compta | string |
None. |
|
| compta_consigne | string |
None. |
|
| ctaxe1 | string |
None. |
|
| ctaxe2 | string |
None. |
|
| ctaxe3 | string |
None. |
|
| ctaxe4 | string |
None. |
|
| ctaxe5 | string |
None. |
|
| ctaxe6 | string |
None. |
|
| ctaxe7 | string |
None. |
|
| ctaxe8 | string |
None. |
|
| ctaxe9 | string |
None. |
|
| ctaxe10 | string |
None. |
|
| colis | decimal number |
None. |
|
| piece | decimal number |
None. |
|
| pbrut | decimal number |
None. |
|
| tare | decimal number |
None. |
|
| pnet | decimal number |
None. |
|
| pnet_piece | decimal number |
None. |
|
| pnet_colis | decimal number |
None. |
|
| nbpal | decimal number |
None. |
|
| mnthtbrut | decimal number |
None. |
|
| mntrem | decimal number |
None. |
|
| mntpromo | decimal number |
None. |
|
| mntesc | decimal number |
None. |
|
| mntrist | decimal number |
None. |
|
| htnet | decimal number |
None. |
|
| mntcons | decimal number |
None. |
|
| mntdecons | decimal number |
None. |
|
| nblig | integer |
None. |
|
| nbligart | integer |
None. |
|
| htbrutdev | decimal number |
None. |
|
| remdev | decimal number |
None. |
|
| promodev | decimal number |
None. |
|
| escptdev | decimal number |
None. |
|
| ristdev | decimal number |
None. |
|
| htnetdev | decimal number |
None. |
|
| consdev | decimal number |
None. |
|
| deconsdev | decimal number |
None. |
|
| totachat | decimal number |
None. |
|
| totrevient | decimal number |
None. |
|
| totrevient_tarif_reel | decimal number |
None. |
|
| totrevient_tarif_reel2 | decimal number |
None. |
|
| tot_subvention | decimal number |
None. |
|
| ht_valorise | decimal number |
None. |
|
| rem_diff_valorise | decimal number |
None. |
|
| netstatlig | decimal number |
None. |
|
| netstat | decimal number |
None. |
|
| margbrut | decimal number |
None. |
|
| margnet | decimal number |
None. |
|
| flgval | string |
None. |
|
| htbrut_bl | decimal number |
None. |
|
| htnet_bl | decimal number |
None. |
|
| bord_charge_separe | string |
None. |
|
| prep_colis | decimal number |
None. |
|
| prep_pendus | decimal number |
None. |
|
| prep_info1 | string |
None. |
|
| prep_info2 | string |
None. |
|
| prep_info3 | string |
None. |
|
| prep_flgedit | string |
None. |
|
| prep | string |
None. |
|
| peseur | string |
None. |
|
| prep_liste | string |
None. |
|
| prep_pal | decimal number |
None. |
|
| fr1_calc | string |
None. |
|
| fr1_val | decimal number |
None. |
|
| fr1_unit | string |
None. |
|
| fr1_code | string |
None. |
|
| fr1_valorise | decimal number |
None. |
|
| fr2_calc | string |
None. |
|
| fr2_val | decimal number |
None. |
|
| fr2_unit | string |
None. |
|
| fr2_code | string |
None. |
|
| fr2_valorise | decimal number |
None. |
|
| fr3_calc | string |
None. |
|
| fr3_val | decimal number |
None. |
|
| fr3_unit | string |
None. |
|
| fr3_code | string |
None. |
|
| fr3_valorise | decimal number |
None. |
|
| fr4_calc | string |
None. |
|
| fr4_val | decimal number |
None. |
|
| fr4_unit | string |
None. |
|
| fr4_code | string |
None. |
|
| fr4_valorise | decimal number |
None. |
|
| fr5_calc | string |
None. |
|
| fr5_val | decimal number |
None. |
|
| fr5_unit | string |
None. |
|
| fr5_code | string |
None. |
|
| fr5_valorise | decimal number |
None. |
|
| fr6_calc | string |
None. |
|
| fr6_val | decimal number |
None. |
|
| fr6_unit | string |
None. |
|
| fr6_code | string |
None. |
|
| fr6_valorise | decimal number |
None. |
|
| cde_ref | string |
None. |
|
| bl_ref | string |
None. |
|
| cde_flg | string |
None. |
|
| cde_emis | string |
None. |
|
| cde_conf | string |
None. |
|
| cde_info | string |
None. |
|
| cde_texte | string |
None. |
|
| cde_date | string |
None. |
|
| cde_nbex | integer |
None. |
|
| cde_date_debut | string |
None. |
|
| cde_heure_debut | string |
None. |
|
| cde_date_fin | string |
None. |
|
| cde_heure_fin | string |
None. |
|
| cde_duree | decimal number |
None. |
|
| trsp_flg | string |
None. |
|
| trsp_emis | string |
None. |
|
| trsp_ref | string |
None. |
|
| trsp_conf | string |
None. |
|
| trsp_info | string |
None. |
|
| trsp_texte | string |
None. |
|
| trsp_date | string |
None. |
|
| trsp_nbex | integer |
None. |
|
| trans_flg | string |
None. |
|
| trans_emis | string |
None. |
|
| trans_ref | string |
None. |
|
| trans_conf | string |
None. |
|
| trans_info | string |
None. |
|
| trans_texte | string |
None. |
|
| trans_date | string |
None. |
|
| trans_nbex | integer |
None. |
|
| bl_flg | string |
None. |
|
| bl_emis | string |
None. |
|
| bl_conf | string |
None. |
|
| bl_info | string |
None. |
|
| bl_texte | string |
None. |
|
| bl_date | string |
None. |
|
| bl_nbex | integer |
None. |
|
| cde_ref_regroup | string |
None. |
|
| orig_reliquat | string |
None. |
|
| flag_controle_ok | string |
None. |
|
| raison2livr | string |
None. |
|
| flgexport | string |
None. |
|
| frs_transporteur | string |
None. |
|
| flgetat | string |
None. |
|
| depot | string |
None. |
|
| consigne_traitee | string |
None. |
|
| telephone | string |
None. |