FV_PAYMENT_EXCLUSION_CRITERIAS
This table contains payment offset exclusion criterias so that no payment netting will be done by treasury for the payments meeting the criterias. Payment exclusion will be done at supplier, supplier site, supplier type, payment reason and by accounting range.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_PAY_EXCLUSION_CRITERIA_PK |
EXCLUSION_CRITERIA_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXCLUSION_CRITERIA_ID | NUMBER | 18 | Yes | Unique identifier for the exclusion criteria. | |
| EXCLUSION_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique code for exclusion type. The valid values are Supplier, Supplier Sites, Accounting, and Payment Reason. These values come from ORA_FV_OFFSET_CRITERIA_TYPE. | |
| SUPPLIER_ID | NUMBER | 18 | Unique supplier identifier for which the payment is to be excluded in netting. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Unique supplier site identifier to be excluded from the payment netting. | ||
| SUPPLIER_TYPE_CODE | VARCHAR2 | 30 | Supplier type codes to be excluded from the payment netting. Valid values will be provided by the lookup type VENDOR_TYPE_LOOKUP_CODE. | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason for which the payment is excluded from the payment netting. Valid values comes from lookup type PAYMENT_REASON. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Unique identifier for the business unit associated to the treasury offset criteria. | |
| START_DATE | DATE | Start date when this criteria is applied. | |||
| END_DATE | DATE | End date when this criteria is applied. | |||
| ACCOUNT_RANGE_FILTER | XMLTYPE | Accounting filter condition for which the payment is excluded from the payment netting. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| 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. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FV_PAY_EXCLUSION_CRITERIA_N1 | Non Unique | FUSION_TS_TX_DATA | SUPPLIER_ID, SUPPLIER_SITE_ID, BUSINESS_UNIT_ID |
| FV_PAY_EXCLUSION_CRITERIA_N2 | Non Unique | FUSION_TS_TX_DATA | SUPPLIER_TYPE_CODE, BUSINESS_UNIT_ID |
| FV_PAY_EXCLUSION_CRITERIA_N3 | Non Unique | FUSION_TS_TX_DATA | PAYMENT_REASON_CODE, BUSINESS_UNIT_ID |
| FV_PAY_EXCLUSION_CRITERIA_U1 | Unique | FUSION_TS_TX_DATA | EXCLUSION_CRITERIA_ID |