1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT COALESCE(a."NUMSUITEKEY", 0) AS COL1,
a."COMMENTAIREFACTURATION" AS COL2,
a."FICHIERIMAGE" AS COL3,
a."NOMBREOUBASE" AS COL4,
a."TAUXOUMONTANT" AS COL5,
a."MOISPAIE" AS COL6,
COALESCE(a."NUMCONTRAT", 0) AS COL7,
a."ETATTRAITEMENT" AS COL8,
a."NUMERISE" AS COL9,
a."NOMBREOUBASE2" AS COL10,
a."RUBRIQUE" AS COL11,
a."ORIGINE" AS COL12,
a."NUMFACTURE" AS COL13,
a."NUMPAIE" AS COL14,
a."LIBELLE" AS COL15,
a."DATEFACTURE" AS COL16,
COALESCE(a."DATERUB", ('0001-01-01'::DATE)) AS COL17,
a."TAUXOUMONTANT2" AS COL18
FROM PACA."INTERIM@CONTRATBORDEREAURUBRIQUE" a
WHERE (a."RUBRIQUE" <> 0)
ORDER BY COL7 ASC,
COL17 ASC,
COL1 ASC
FOR READ ONLY |
Partager