DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_DOCUMENT_LINES_H

Object Details
Object Name: IBY_DOCUMENT_LINES_H
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_DOCUMENT_LINES_H
Subobject Name:
Status: VALID


IBY_DOCUMENT_LINES_H stores historical snapshots of document line items. This table contains denormalized versions of document lines from specific points in time, including when the payment for the associated document was submitted to a payment system. Different snapshots of the same document line can exist in this table. These snapshots are differentiated by the table's primary key and a snapshot date.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_LINE_HISTORY_ID NUMBER (15) Yes System generated primary key
DOCUMENT_LINE_HISTORY_DATE DATE
Yes Document line snapshot date
DOCUMENT_PAYABLE_HISTORY_ID NUMBER (15) Yes Document payable snapshot with which this line is associated
DOCUMENT_PAYABLE_LINE_ID NUMBER (15) Yes Oracle Payments' internal payment document line Identifier
DOCUMENT_PAYABLE_ID NUMBER (15) Yes Oracle Payments' internal payment document Identifier
CALLING_APP_DOCUMENT_LINE_CODE VARCHAR2 (255) Yes Source product''s document line Identifier. Since document line Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PO_NUMBER VARCHAR2 (255)
Purchase order numbers to which this document line is matched. If multiple purchase orders, value is comma delimited.
LINE_NUMBER NUMBER (15)
Line number
LINE_TYPE VARCHAR2 (30)
Line type
LINE_NAME VARCHAR2 (100)
Line name
LINE_AMOUNT NUMBER

Line amount, in document currency
DESCRIPTION VARCHAR2 (255)
Line description
UNIT_PRICE NUMBER

Unit price
QUANTITY NUMBER

Quantity
UNIT_OF_MEASURE VARCHAR2 (100)
Unit of measure
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DOCUMENT_LINE_HISTORY_ID
,      DOCUMENT_LINE_HISTORY_DATE
,      DOCUMENT_PAYABLE_HISTORY_ID
,      DOCUMENT_PAYABLE_LINE_ID
,      DOCUMENT_PAYABLE_ID
,      CALLING_APP_DOCUMENT_LINE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      PO_NUMBER
,      LINE_NUMBER
,      LINE_TYPE
,      LINE_NAME
,      LINE_AMOUNT
,      DESCRIPTION
,      UNIT_PRICE
,      QUANTITY
,      UNIT_OF_MEASURE
FROM IBY.IBY_DOCUMENT_LINES_H;

Dependencies

[top of page]

IBY.IBY_DOCUMENT_LINES_H does not reference any database object

IBY.IBY_DOCUMENT_LINES_H is referenced by following:

SchemaIBY
ViewIBY_DOCUMENT_LINES_H#