JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseAgreementsnotificationControls

Configures alerts (for example, expiration, usage threshold) for purchase agreements, notifying stakeholders of key milestones.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long The unique identifier for the purchase agreement header, linking all notification control records to the overall purchase agreement.
NotificationId [KEY] Long The unique identifier for the notification control associated with the purchase agreement, used to manage and track notifications.
ConditionCode String The notification type for the purchase agreement, specifying the condition or event that triggers the notification (for example, 'Reminder,' 'Expiration').
Percentage Decimal The percentage of the purchase agreement document total that the notification is based on, used to calculate the notification value.
Amount Decimal The specific monetary amount of the purchase agreement document total that the notification applies to, often used for threshold-based notifications.
StartDate Date The effective date from which the notification becomes active, indicating when the terms of the notification should start being applied.
EndDate Date The expiration date of the notification, marking the last day on which the notification control is valid and should be considered for the purchase agreement.
ReminderDays Decimal The number of days before the expiration event that the reminder notification should be triggered, helping to provide timely alerts before critical dates.
CreatedBy String The name of the user or system responsible for creating the notification control on the purchase agreement, ensuring accountability for data entry.
CreationDate Datetime The date and time when the notification control for the purchase agreement was created, providing a historical record of when the control was implemented.
LastUpdatedBy String The name of the user or system responsible for the last update made to the notification control of the purchase agreement, ensuring accountability for changes.
LastUpdateDate Datetime The date and time when the notification control for the purchase agreement was last updated, reflecting the most recent changes to the notification terms.
AgreementHeaderId Long The unique identifier for the purchase agreement header, linking this notification control record to the corresponding agreement.
Finder String The search function or query used to locate or filter notification controls associated with the purchase agreement, allowing for easy retrieval based on criteria.
EffectiveDate Date The date used to fetch notification control records that are effective as of the specified start date, ensuring accurate data retrieval based on the active period.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434