IBY_AR_DOC_LINES_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
LINE_NUMBER NUMBER The table is used in fund capture processing. Oracle internal use only.
PO_NUMBER VARCHAR2 50 Oracle internal use only.
LINE_TYPE VARCHAR2 20 Oracle internal use only.
DESCRIPTION VARCHAR2 240 Oracle internal use only.
EXTENDED_AMOUNT NUMBER Oracle internal use only.
INVOICE_CURRENCY_CODE VARCHAR2 15 Oracle internal use only.
UNIT_PRICE NUMBER Oracle internal use only.
QUANTITY NUMBER Oracle internal use only.
UNIT_OF_MEASURE VARCHAR2 3 Oracle internal use only.
INVENTORY_ITEM_ID NUMBER 18 Oracle internal use only.
DISCOUNT_AMOUNT NUMBER Oracle internal use only.
SALES_TAX_AMOUNT NUMBER Oracle internal use only.
TAX_RATE NUMBER Oracle internal use only.
VAT_TAX_AMOUNT NUMBER Oracle internal use only.
DOC_UNIQUE_REF NUMBER 18 Oracle internal use only.

Indexes

Index Uniqueness Columns
IBY_AR_DOC_LINES_GT_N1 Non Unique DOC_UNIQUE_REF