Expense Tracker¶

Expense Tracker table stores information about Shipment Expense & revenue along with linked Shipment and invoice.

trackerId: Primary key of the table.

orgId: Foreign key of Organisation table. This field stores the information of the organisation in which Expense tracker is created.

shipmentId: Foreign key of shipment table. This field stores the information of the shipment in which Expense tracker is created.

invoiceAmount: Total amount of commercial invoice.

orgCurrency: Local currency of organisation.

invoiceCurrency: Currency of invoice.

createdBy: Foreign key of the User table. This field stores the information of the email id which created the bank account.

updatedBy: Foreign key of the User table. This field stores the information of the email id which updated the bank account.

Expense Tracker always belongs any one organisation.

Expense Tracker always created by any one user belongs to organisation.

Expense Tracker always updated by any one user belongs to organisation.

Expense Tracker always belongs any one Shipment.

Expense Tracker always have multiple Expense Tracker Items.