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 34 35 36 37 38 39 40 41 42 43 44
|
CREATE TABLE article (
Num_Ligne INTEGER,
Code_article CHAR(25),
Code_famille CHAR(8),
Code_UM INTEGER,
Nom_Article CHAR(80),
Pu_achat_HT CURRENCY,
Pu_Vente_HT CURRENCY,
Marge NUMBER,
Stock_Min NUMBER,
Stock_Max NUMBER,
code_taxe SMALLINT,
Type_Calcul SMALLINT,
STOCK_GERE BOOLEAN,
Stock_Initial NUMBER,
Code_Cond INTEGER,
Reference CHAR(30),
Stock_actuel NUMBER,
BLOQUE BOOLEAN,
QTE_COLIS NUMBER,
POID_BRUT NUMBER,
POID_NET NUMBER,
Code_depot CHAR(8),
PAMP CURRENCY,
Raz_stock NUMBER,
Ecart NUMBER,
Theorique NUMBER,
Valid_raz_stock BOOLEAN,
En_Cde_Four NUMBER,
En_Cde_Client NUMBER,
Date_fabrication DATE,
Date_peremption DATE,
Nb_Jour_Alerte SMALLINT,
Date_Alerte DATE,
Compose BOOLEAN,
Valider BOOLEAN,
Element BOOLEAN,
Taux_Taxe NUMBER,
Enable_Tarif BOOLEAN,
Code_Marque INTEGER,
IsMin BOOLEAN,
IsMax BOOLEAN,
Code_Four CHAR(8)); |
Partager