Import CEGID + PJ : requête mode SaaS hébergé

Type d'action Tenue
Description SELECT distinct
"C" as TYPE
,E_EXERCICE
  • ,E_QUALIFPIECE
  • ,E_JOURNAL
  • ,E_DATECOMPTABLE
  • ,E_NUMEROPIECE
  • ,E_NUMLIGNE
  • ,E_GENERAL
  • ,E_AUXILIAIRE
  • ,E_REFINTERNE
,E_LIBELLE
  • ,E_DEBIT
,E_CREDIT
  • ,Y_AXE
  • ,Y_SECTION
  • ,Y_DATEREFEXTERNE
  • ,E_NUMECHE
  • ,E_MODESAISIE
  • ,E_NUMGROUPEECR
  • ,E_AFFAIRE
  • ,E_AVOIRRBT
  • ,E_BANQUEPREVI
  • ,E_CFONBOK
,E_CODEACCEPT
  • ,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_ECHEENC4
  • ,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_SAISIMP
  • ,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 analytiq on y_refguid=e_refguid
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://
Tags
cegid import requete
Checkbox Group Créé par MyUnisoft, Validé par MyUnisoft
Modifier
ImportCegidPjRequeteModeSaasHeberge (Didacticiel), écrite par WikiAdmin
créée le 21.11.2020 à 10:18
 cegid import requete