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

TABLE: IBY.IBY_DOCUMENT_LINES

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


IBY_DOCUMENT_LINES stores Oracle Payments' representation of individual line items for documents payable, such as invoice lines for an Oracle Payables invoice. This information is passed according to payment format, but is not used to affect payment processing. Not every source product needs to have document lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_DOCUMENT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_PAYABLE_LINE_ID
IBY_DOCUMENT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_PAYABLE_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_PAYABLE_LINE_ID NUMBER (15) Yes System generated primary key
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)
Purhcase 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_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;

Dependencies

[top of page]

IBY.IBY_DOCUMENT_LINES does not reference any database object

IBY.IBY_DOCUMENT_LINES is referenced by following:

SchemaIBY
ViewIBY_DOCUMENT_LINES#