1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
CREATE TABLE "DOC_LIG" ("CDGRP" VARCHAR2(10) NOT NULL ENABLE, "CDSOC" VARCHAR2(10) NOT NULL ENABLE, "CIDOC" NUMBER(9, 0) NOT NULL ENABLE, "LNUM" NUMBER(5, 0) NOT NULL ENABLE,
"LORDRE" NUMBER(5, 0) NOT NULL ENABLE, "CIART" NUMBER(9, 0), "LINT" VARCHAR2(50), "LNBR" NUMBER(10, 3), "LCOTE1" NUMBER(10, 3), "LCOTE2" NUMBER(10, 3), "LQTE" NUMBER(10, 3),
"LUNQTE" VARCHAR2(3), "LPRIX" NUMBER(13, 4), "LMT" NUMBER(13, 2), "LQTER" NUMBER(10, 3), "LMTR" NUMBER(13, 2), "LDTLIVINI" DATE, "LDTLIVDEM" DATE, "LDTLIVEFF" DATE, "LFACAN"
NUMBER(4, 0), "LFACMOIS" NUMBER(2, 0), "LFACMT" NUMBER(13, 2), "LTXT" VARCHAR2(2000), "LCOM" VARCHAR2(2000), "LCDTVA" VARCHAR2(3), "LQTEUG" NUMBER(10, 3), "LQTEUGR" NUMBER(10,
3), "TYPDOC" VARCHAR2(3) NOT NULL ENABLE, "TYPLIG" VARCHAR2(3) NOT NULL ENABLE, "CIAFF" NUMBER(9, 0), "CDSTOCK" VARCHAR2(10), "LPRIXREV" NUMBER(13, 4), "LCOEFFVTE" NUMBER(9, 5),
"LMTTREV" NUMBER(13, 2), "LCDEFOU" NUMBER(1, 0), "LCDEFOU_CITRS" NUMBER(9, 0), "LDTSTOCK" DATE, "LNUMMVT" NUMBER(9, 0), "LPRIXSTOCK" NUMBER(13, 4), "LQTESTOCKAV" NUMBER(10, 3),
"LPRIXVTE" NUMBER(13, 4), "LMTTVTE" NUMBER(13, 2), "LDTCREAT" DATE, "LDTMODIF" DATE, "LDTSUPP" DATE, "LUTICREAT" VARCHAR2(10), "LUTIMODIF" VARCHAR2(10), "LUTISUPP" VARCHAR2(10),
"LCPT1" VARCHAR2(10), "LPRIXBRUT" NUMBER(13, 4), "LREMISE" NUMBER(5, 2), "CDRUB" VARCHAR2(10), "LSTAT1" VARCHAR2(20), "LSTAT2" VARCHAR2(20), "LSTAT3" VARCHAR2(20), "LSTAT4"
VARCHAR2(20), "LSTAT5" VARCHAR2(20), "LSTAT6" VARCHAR2(20), "LSTAT7" VARCHAR2(20), "LANNREL" NUMBER(1, 0), "LMODIF" NUMBER(1, 0), "LREPCITRS" NUMBER(9, 0), "LANUM" NUMBER(3, 0),
"LCDGTAIL" VARCHAR2(6), "LCDTAIL" VARCHAR2(6), "LCOMBLOC" NUMBER(1, 0), "LTAUXCOMM" NUMBER(7, 4), "LDTRELCOMM" DATE, "LCDCOMM" VARCHAR2(2), "LQTEFAB" NUMBER(10, 3), "LQTEREAL"
NUMBER(10, 3), "LANLIV" NUMBER(4, 0), "LSEMLIV" NUMBER(2, 0), "LPROMO" NUMBER(1, 0), "LPASREM" NUMBER(1, 0), "CINOMEN" NUMBER(9, 0), "CIINOMEN" NUMBER(9, 0), "LQTEFABIMP"
NUMBER(10, 3), "LTIERSSTAT" NUMBER(9, 0), "LCOMMTERM" NUMBER(1, 0), "XXX" NUMBER(13, 2), "CDSOC_CIAFF" VARCHAR2(10)) |
Partager