IBY_DOCUMENT_LINES
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.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_DOCUMENT_LINES_PK |
DOCUMENT_PAYABLE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_PAYABLE_LINE_ID | NUMBER | 18 | Yes | System generated primary key | |
| DOCUMENT_PAYABLE_ID | NUMBER | 18 | 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 | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | 18 | 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 |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_DOCUMENT_LINES | iby_docs_payable_all | DOCUMENT_PAYABLE_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| IBY_DOCUMENT_LINES_U1 | Unique | DOCUMENT_PAYABLE_LINE_ID |
| IBY_DOCUMENT_LINES_N1 | Non Unique | DOCUMENT_PAYABLE_ID |