[Home] [Help] [Dependency Information]
Object Name: | IBY_EXT_PAYEE_RELATIONSHIPS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
"This table stores information about third party payment related relationships and related attributes.
IBY_EXT_PAYEE_RELATIONSHIPS contain third payment relationships entered manually using the Relationship region in the supplier page. Each row stores the relationship details like relationship status, is it a primary relationship, relationship effective dates and additional information for the relationship. This information will be utilized in payables and Payments application to create invoices and process payments."
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_EXT_PAYEE_RELATIONSHIPS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
IBY_EXT_PAYEE_RELATIONSHIPS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARTY_ID
SUPPLIER_SITE_ID |
IBY_EXT_PAYEE_RELATIONSHIPS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARTY_ID
SUPPLIER_SITE_ID REMIT_PARTY_ID REMIT_SUPPLIER_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELATIONSHIP_ID | NUMBER | (15) | Yes | Unique internal Identifier for this record. Generated using a database sequence. |
PARTY_ID | NUMBER | (15) | Party identifier for whom the third party payment relationship is created. | |
SUPPLIER_SITE_ID | NUMBER | (15) | Supplier site identifier for whom the third party payment relationship is created. | |
REMIT_PARTY_ID | NUMBER | (15) | The remit to party identifier on whom the payments will be made. | |
REMIT_SUPPLIER_SITE_ID | NUMBER | (15) | The remit to supplier site identifier on whom the payments will be made. | |
FROM_DATE | DATE | The date from which the relationship to make the third party payments is valid for processing. | ||
TO_DATE | DATE | The date up to which the relationship to make the third party payments is valid for processing. | ||
PRIMARY_FLAG | VARCHAR2 | (1) | Indicates whether this is the primary relationship for a date range. | |
ADDITIONAL_INFORMATION | VARCHAR2 | (1000) | Additional information for the third party payment relationship. | |
ACTIVE | VARCHAR2 | (1) | Indicates whether the relationship is active or not. | |
CREATED_BY | NUMBER | (15) | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. | |
LAST_UPDATE_DATE | DATE | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column - date when a user last updated this row. | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT RELATIONSHIP_ID
, PARTY_ID
, SUPPLIER_SITE_ID
, REMIT_PARTY_ID
, REMIT_SUPPLIER_SITE_ID
, FROM_DATE
, TO_DATE
, PRIMARY_FLAG
, ADDITIONAL_INFORMATION
, ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM IBY.IBY_EXT_PAYEE_RELATIONSHIPS;
IBY.IBY_EXT_PAYEE_RELATIONSHIPS does not reference any database object
IBY.IBY_EXT_PAYEE_RELATIONSHIPS is referenced by following:
|
|
|