1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| CREATE TABLE RECAPA
( NUMCTEAC number(16),
PERIODEAC VARCHAR(7),
NMDBAC Number(12,3),
CMDBAC Number(12,3),
NJDBAC Number(3),
SMODBAC Number(12,3),
SMAXDBAC Number(12,3),
SMINDBAC Number(12,3),
MAUTAC Number(12,3),
NJIAC Number(12,3),
NMCRAC Number(12,3),
CMCRAC Number(12,3),
NJCRAC Number(3),
SMOCRAC Number(12,3),
SMAXCRAC Number(12,3),
SMINCRAC Number(12,3),
CMDEBAC Number(12,3),
MCAAC Number(12,3),
SFPAC Number(12,3),
SMOPAC Number(12,3),
S5MOIS Number(12,3),
S10MOIS Number(12,3),
S15MOIS Number(12,3),
S20MOIS Number(12,3),
DDMAN Date,
ITRANAC VARCHAR(1),
FILLER VARCHAR(24),);
CREATE TABLE RECAPA ( NUMCTEAC number(16),
PERIODEAC VARCHAR(7),
NMDBAC Number(12,3),
CMDBAC |
Partager