Имя Пусто? Тип
----------------------------------------- -------- ----------------------------
RECTYPE NOT NULL NUMBER(10)
ARTICLE NOT NULL VARCHAR2(50)
SALETYPE NOT NULL CHAR(2)
SALEID NOT NULL VARCHAR2(50)
SALESPECITEM NOT NULL NUMBER(10)
SALELOCATIONFROM NUMBER(10)
SALELOCATIONTO NUMBER(10)
SALEDATE NOT NULL DATE
SALEOP NOT NULL NUMBER(5)
SALEUSEROP NUMBER(5)
SALEPAYCASH NOT NULL CHAR(1)
SALECLIENTINDEX NUMBER(10)
SALEQ NOT NULL NUMBER(14,3)
SALESUM NOT NULL NUMBER(19,4)
SALENOVAT NOT NULL NUMBER(19,4)
SALENOTAX NOT NULL NUMBER(19,4)
SALECURTYPE NOT NULL NUMBER(5)
SALESUMCUR NOT NULL NUMBER(19,4)
SALEVATRATE NOT NULL NUMBER(8,4)
PRIMECOST NOT NULL NUMBER(19,4)
PRIMECOSTNOVAT NOT NULL NUMBER(19,4)
PRIMECOSTFORCED NOT NULL CHAR(1)
FORCEDMAPPING CHAR(1)
QUANTITY NOT NULL NUMBER(14,3)
INCOMEID VARCHAR2(50)
INCOMETYPE CHAR(2)
INCOMESPECITEM NUMBER(10)
INCOMECLIENTINDEX NUMBER(10)
GOODSOWNER NUMBER(5)
INCOMEQ NUMBER(14,3)
INCOMESUM NUMBER(19,4)
INCOMENOVAT NUMBER(19,4)
INCOMEVATRATE NUMBER(8,4)
INCOMECURTYPE NUMBER(5)
INCOMESUMCUR NUMBER(19,4)
INCOMEDATE DATE
SQL> select index_name from all_indexes where table_name='FFMAPREP';
INDEX_NAME
------------------------------
FFMAPREP_ARTICLE
FFMAPREP_SALEDATE
FFMAPREP_LOCFROM
FFMAPREP_LOCTO
FFMAPREP_SUPPLIER
FFMAPREP_DOC
6 строк выбрано.