Import CEGID + PJ : requête mode SaaS hébergé
Type d'action
Tenue
Description
SELECT distinct
"C" as TYPE
,E_EXERCICE
left join generaux on g_general =e_general
left join tiers on t_auxiliaire =e_auxiliaire
left join journal on j_journal =e_journal
left join ECRCOMPL on (E_EXERCICE = EC_EXERCICE and E_JOURNAL = EC_JOURNAL and E_NUMEROPIECE = EC_NUMEROPIECE and E_NUMLIGNE = EC_NUMLIGNE)
where e_exercice > 000
ORDER BY E_JOURNAL,E_PERIODE,E_NUMEROPIECE,E_NUMLIGNE
"C" as TYPE
,E_EXERCICE
- ,E_QUALIFPIECE
- ,E_JOURNAL
- ,E_DATECOMPTABLE
- ,E_NUMEROPIECE
- ,E_NUMLIGNE
- ,E_GENERAL
- ,E_AUXILIAIRE
- ,E_REFINTERNE
- ,E_DEBIT
- ,Y_AXE
- ,Y_SECTION
- ,Y_DATEREFEXTERNE
- ,E_NUMECHE
- ,E_MODESAISIE
- ,E_NUMGROUPEECR
- ,E_AFFAIRE
- ,E_AVOIRRBT
- ,E_BANQUEPREVI
- ,E_CFONBOK
- ,E_CONFIDENTIEL
- ,E_CONSO
- ,E_CONTREPARTIEAUX
- ,E_CONTREPARTIEGEN
- ,E_CONTROLE
- ,E_CONTROLETVA
- ,E_CONTROLEUR
- ,E_COTATION
- ,E_COUVERTURE
- ,E_COUVERTUREDEV
- ,E_CREDITDEV
- ,E_DATECREATION
- ,E_DATEECHEANCE
- ,E_DATEMODIF
- ,E_DATEORIGINE
- ,E_DATEPAQUETMAX
- ,E_DATEPAQUETMIN
- ,E_DATEPOINTAGE
- ,E_DATERELANCE
- ,E_DATETAUXDEV
- ,E_DATEVALEUR
- ,E_DATPER
- ,E_DEVISE
- ,E_DOCID
- ,E_ECHEDEBIT
- ,E_ECHEENC1
- ,E_ECHEENC2
- ,E_ECHEENC3
- ,E_ENTITY
- ,E_ETABLISSEMENT
- ,E_ETATLETTRAGE
- ,E_IMMO
- ,E_LETTRAGE
- ,E_LETTRAGEDEV
- ,E_LIBREBOOL0
- ,E_LIBREBOOL1
- ,E_LIBREDATE
- ,E_LIBREMONTANT0
- ,E_LIBREMONTANT1
- ,E_LIBREMONTANT2
- ,E_LIBREMONTANT3
- ,E_LIBRETEXTE0
- ,E_LIBRETEXTE1
- ,E_LIBRETEXTE2
- ,E_LIBRETEXTE3
- ,E_LIBRETEXTE4
- ,E_LIBRETEXTE5
- ,E_LIBRETEXTE6
- ,E_LIBRETEXTE7
- ,E_LIBRETEXTE8
- ,E_LIBRETEXTE9
- ,E_MODEPAIE
- ,E_MULTIPAIEMENT
- ,E_NATUREPIECE
- ,E_NIVEAURELANCE
- ,E_NOMLOT
- ,E_NUMCFONB
- ,E_NUMENCADECA
- ,E_NUMORDRE
- ,E_NUMPIECEINTERNE
- ,E_NUMTRAITECHQ
- ,E_ORIGINEPAIEMENT
- ,E_PERIODE
- ,E_QTE1
- ,E_QTE2
- ,E_QUALIFORIGINE
- ,E_QUALIFQTE1
- ,E_QUALIFQTE2
- ,E_REFEXTERNE
- ,E_REFGESCOM
- ,E_REFLETTRAGE
- ,E_REFLIBRE
- ,E_REFPOINTAGE
- ,E_REFRELEVE
- ,E_REFREVISION
- ,E_REGIMETVA
- ,E_RIB
- ,E_SEMAINE
- ,E_SOCIETE
- ,E_TABLE0
- ,E_TABLE1
- ,E_TABLE2
- ,E_TABLE3
- ,E_TAUXDEV
- ,E_TIERSPAYEUR
- ,E_TPF
- ,E_TRESOSYNCHRO
- ,E_TVA
- ,E_TYPEANOUVEAU
- ,E_TYPEMVT
- ,Y_NUMVENTIL
- ,E_UTILISATEUR
- ,E_VALIDE
- ,G_NATUREGENE
- ,T_NATUREAUXI
- ,J_NATUREJAL
- ,E_DATEREFEXTERNE
- ,E_REFGUID
- ,"0" as EFG_GUID
- ,"0" as EFG_ECRITURENUM
- ,"0" as EFG_VALIDDATE
- ,EC_DOCGUID
- ,EC_CASHGUID
- ,EC_CASHDOC
- ,EC_CASHSTATUT from ecriture
left join generaux on g_general =e_general
left join tiers on t_auxiliaire =e_auxiliaire
left join journal on j_journal =e_journal
left join ECRCOMPL on (E_EXERCICE = EC_EXERCICE and E_JOURNAL = EC_JOURNAL and E_NUMEROPIECE = EC_NUMEROPIECE and E_NUMLIGNE = EC_NUMLIGNE)
where e_exercice > 000
ORDER BY E_JOURNAL,E_PERIODE,E_NUMEROPIECE,E_NUMLIGNE
Site Internet
http://
Checkbox Group
Créé par MyUnisoft, Validé par MyUnisoft
cegid import requete