Shipment Checklist¶
Shipment checklist table stores information about checklist created inside Shipment along with whom it's assigned & status of checklist. By default, shipment checklist is created from the checklist master when shipment is created.
Attributes¶
shipmentChecklistId Primary key of the table.
shipmentId Foreign key of Shipment table. This field stores the information of the shipment inside which checklist is created.
orgId Foreign key of Organisation table. This field stores the information of the organisation inside which checklist is created.
name Name of the shipment checklist.
checked Boolean value indicating whether shipment checklist is completed or not.
assignToEmail Email id of the user whom checklist is assigned. This can be any user (External/Internal) who has access to shipment.
assignToName Name of the user whom checklist is assigned. This can be any user (External/Internal) who has access to shipment.
createdBy Email id of the user who created the shipment checklist. This can be any user (External/Internal) who has access to shipment.
completedBy Email id of the user who completed the shipment checklist. This can be any user (External/Internal) who has access to shipment.
Associations¶
Organisation¶
Shipment checklist always belongs any one Organisation.
User¶
Shipment¶
Shipment Checklist always belongs any one Shipment.