[Home] [Help]
[Dependency Information]
Object Name: | IBY_DOCUMENT_LINES |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | ![]() |
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.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_DOCUMENT_LINES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
IBY_DOCUMENT_LINES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
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 | |
Name | Datatype | Length | Mandatory | Comments |
---|
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;
IBY.IBY_DOCUMENT_LINES does not reference any database object
IBY.IBY_DOCUMENT_LINES is referenced by following:
|
|
|