Organisation Notifications

Organisation Notifications table stores information about upcoming events for the company like due of invoice in near or order dispatch date is near.

Attributes

notificationId: primary key of the table.

orgId: Foreign key of Organisation table. This field stores the information of the organisation whose notification is being linked with other document.

shipmentId: Foreign key of Shipment table. This field stores the information of the shipment with whom notification is linked.

salesOrderId: Foreign key of Export/Sales Order table. This field stores the information of the Export/Sales Order with whom notification is linked.

purchaseOrderId: Foreign key of Import/Purchase order table. This field stores the information of the Import/Purchase order with whom notification is linked.

invId: Foreign key of Invoice table. This field stores the information of the invoice with whom notification is linked.

eventName: Name of notification event.

Example

Upcoming Order Delivery: #ORD_2021_12 for Umbrella Corporation.

eventType: Type of Notifications event.

Example

1. Upcoming ETA Date (For shipment)
2. Dispatch Date (For order)

description: Description of the notification event.

targetDate: Target date of the event.

isSeen: Boolean value indicating whether the notification is seen by the user or not.

---

Associations

Shipment

Notification always belongs any one Shipment.

Organisation

Notification always belongs any one Organisation.

PurchaseOrder

Notification always belongs any one Purchase Order.

SalesOrder

Notification always belongs any one Sales Order.

Invoice

Notification always belongs any one Invoice.