Delivery Notes - codbex/codbex-olympus GitHub Wiki

Delivery Note is a document about shipping details of an order.

DeliveryNote

Entity Definition

• Entity Type: Primary Entity
• Layout Type: Manage Master Entities

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
Number	VARCHAR	20	no	-	-
Date	DATE		no	-	-
DeliveryDate	DATE		no	-	-
Customer	INTEGER		no	-	yes	Reference to [Customer](Customers
Amount	DOUBLE		-	yes	-	SUM(PurchaseInvoiceItem.Amount)
Currency	INTEGER		-	-	yes	Reference to Currency
Discount	DOUBLE		-	-	-	% Discount
Taxes	DOUBLE		-	-	-	% Taxes (other than VAT)
VAT	DOUBLE		-	yes	-	SUM(PurchaseInvoiceItem.Amount * %VAT)
Total	DOUBLE		-	yes	-	Amount + VAT - %Discount + %Taxes
SentMethod	INTEGER		-	-	yes	Reference to Sent Method
Status	INTEGER		-	-	yes	Reference to Invoice Status
Invoice	VARCHAR	200	-	-	yes	Reference to Invoice
Company	INTEGER		-	-	yes	Reference to Companies
Name	VARCHAR	200	-	yes	-	Supplier.Name/Number/Date/Amount
UUID	VARCHAR	36	-	yes	-	Random UUID generated
RefUUID	VARCHAR	36	-	-	-	Reference via UUID to the Invoice

Custom Actions

• Print

DeliveryNoteItem

Entity Definition

• Entity Type: Dependent Entity
• Layout Type: Manage Details Entities

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
Delivery Note	INTEGER		no	-	yes	Reference to Delivery Note
Name	VARCHAR	2000	no	-	-	Free text representing Product/Service
Quantity	DOUBLE		no	-	-
Price	DOUBLE		no	-	-
VAT	INTEGER		-	-	yes	Reference to VAT
Amount	DOUBLE		-	yes	-	Quantity * Price