[Home] [Help] [Dependency Information]
Object Name: | IBY_USED_PAYMENT_DOCS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_USED_PAYMENT_DOCS |
Subobject Name: | |
Status: | VALID |
IBY_USED_PAYMENT_DOCS tracks information about which payment documents have been used when printing payments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_USED_PAYMENT_DOCS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PAYMENT_DOCUMENT_ID
USED_DOCUMENT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_DOCUMENT_ID | NUMBER | (15) | Yes | Payment document Identifier |
USED_DOCUMENT_NUMBER | NUMBER | (15) | Yes | Number of payment document used |
DATE_USED | DATE | Date that the payment document was used | ||
DOCUMENT_USE | VARCHAR2 | (30) | This column can be populated with any of the values defined in the IBY_PAYMENT_DOCUMENT_USES lookup. | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_DOCUMENT_ID
, USED_DOCUMENT_NUMBER
, DATE_USED
, DOCUMENT_USE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_USED_PAYMENT_DOCS;
IBY.IBY_USED_PAYMENT_DOCS does not reference any database object
IBY.IBY_USED_PAYMENT_DOCS is referenced by following:
|
|
|