SL_TXN_INQUIRY_INVOICE

NAME                            Null?     Type
------------------------------- --------- -----
INVOICE_NO                      NOT NULL  VARCHAR2(30)
INQUIRY_NO                      NOT NULL  VARCHAR2(255)
INVOICE_DATE                              TIMESTAMP (3)
COPY_NO                                   NUMBER(10,0)
DISCOUNT_AMOUNT                           NUMBER(38,15)
PRECENTAGE                                NUMBER(1,0)
CANCELLATION                              NUMBER(1,0)
COMMISSION_PAID                           NUMBER(1,0)
CREATED_BY                      NOT NULL  VARCHAR2(32)
CREATED_DATE                    NOT NULL  TIMESTAMP (3)
MODIFIED_BY                     NOT NULL  VARCHAR2(32)
MODIFIED_DATE                   NOT NULL  TIMESTAMP (3)
LOCATION_CODE                             VARCHAR2(30)
SALES_PROMOTER                            VARCHAR2(30)
SALES_TYPE                                VARCHAR2(30)
INVOICE_TYPE                              VARCHAR2(30)
PORT_CODE_SEQ                             NUMBER(10,0)


# of records 45142


SL_TXN_INQUIRY_INVOICE_DETAIL

NAME                            Null?     Type
------------------------------- --------- -----
SUB_NO                          NOT NULL  NUMBER(10,0)
INQUIRY_NO                      NOT NULL  VARCHAR2(30)
INVOICE_NO                      NOT NULL  VARCHAR2(30)
QUANTITY                                  NUMBER(38,15)
DISCOUNT                        NOT NULL  NUMBER(38,15)
PERCENTAGE                      NOT NULL  NUMBER(1,0)
TXT_VALUE                                 NUMBER(38,15)
TOTAL_VALUE                     NOT NULL  NUMBER(38,15)
SERIAL_NO                                 VARCHAR2(100)
PURCHASE_STATUS                           NUMBER(1,0)
CREATED_BY                      NOT NULL  VARCHAR2(32)
CREATED_DATE                    NOT NULL  TIMESTAMP (3)
MODIFIED_BY                     NOT NULL  VARCHAR2(32)
MODIFIED_DATE                   NOT NULL  TIMESTAMP (3)
PROMOTION_CODE                            VARCHAR2(30)
ITEM_CODE                                 VARCHAR2(30)
ITEM_PRICE_ID                             NUMBER(10,0)
PURCHASE_DIS_VALUE_SEQ                    NUMBER(1,0)
PROMOTION_SEQ                             NUMBER(10,0)


# of records 93110



Details about indexes on SL_TXN_INQUIRY_INVOICE
````````````````````````````````````````````````

INDX_SL_TXN_INQUIRY_INVOICE_01	- INVOICE_DATE


PK_SL_TXN_INQUIRY_INVOICE	- INVOICE_NO
				  INQUIRY_NO




Details about indexes on SL_TXN_INQUIRY_INVOICE_DETAIL
```````````````````````````````````````````````````````

INDX_SL_TXN_INQ_INV_DETAIL_01	- INVOICE_NO
				  ITEM_CODE
				  QUANTITY

PK_SL_TXN_INQUIRY_INVO_I0GIQV	- SUB_NO
				  INQUIRY_NO
				  INVOICE_NO