Table: SALES  Index > Table Index > SALES   Description:   No description available.   Columns   Field Name Data Type Allow Null Character Set Default PO_NUMBER CHAR(8) No NONE CUST_NO INT No SALES_REP SHORT Yes ORDER_STATUS VARCHAR(7) No NONE DEFAULT 'new' ORDER_DATE TIMESTAMP No DEFAULT 'NOW' SHIP_DATE TIMESTAMP Yes DATE_NEEDED TIMESTAMP Yes PAID CHAR(1) Yes NONE DEFAULT 'n' QTY_ORDERED INT No DEFAULT 1 TOTAL_VALUE INT No DISCOUNT FLOAT No DEFAULT 0 ITEM_TYPE VARCHAR(12) Yes NONE AGED BIGINT Yes   Indices   Index Name FieldName Unique Active Descending Description NEEDX DATE_NEEDED No Yes No No description available. QTYX ITEM_TYPE No Yes Yes No description available. QTY_ORDERED No Yes Yes No description available. SALESTATX PAID No Yes No No description available. ORDER_STATUS No Yes No No description available.   Permissions:   User Select Insert Delete Update Reference User: PUBLIC Yes Yes Yes Yes Yes User: SYSDBA Yes Yes Yes Yes Yes     Dependent Objects   Object Type Name Field Trigger CHECK_11 ORDER_STATUS Trigger CHECK_12 ORDER_STATUS Trigger CHECK_13 SHIP_DATE, ORDER_DATE Trigger CHECK_14 SHIP_DATE, ORDER_DATE Trigger CHECK_15 DATE_NEEDED, ORDER_DATE Trigger CHECK_16 DATE_NEEDED, ORDER_DATE Trigger CHECK_17 PAID Trigger CHECK_18 PAID Trigger CHECK_19 QTY_ORDERED Trigger CHECK_20 QTY_ORDERED Trigger CHECK_21 TOTAL_VALUE Trigger CHECK_22 TOTAL_VALUE Trigger CHECK_23 DISCOUNT Trigger CHECK_24 DISCOUNT Trigger CHECK_25 SHIP_DATE, ORDER_STATUS Trigger CHECK_26 SHIP_DATE, ORDER_STATUS Trigger CHECK_27 ORDER_STATUS, CUST_NO Trigger CHECK_28 ORDER_STATUS, CUST_NO Procedure DELETE_EMPLOYEE SALES_REP, PO_NUMBER COMPUTED RDB$31 SHIP_DATE, ORDER_DATE Procedure SHIP_ORDER PAID, SHIP_DATE, PO_NUMBER, ORDER_STATUS, CUST_NO   Created using FBDoc