Purchase Invoices - codbex/codbex-olympus GitHub Wiki

Purchase Invoice is a document that a person or company receives when they buy something, giving details of price, payment conditions, etc.

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
Number	VARCHAR	20	no	-	-
Date	DATE		no	-	-
Due	DATE		-	-	-
Supplier	INTEGER		no	-	yes	Reference to Suppliers
Net	DECMIAL		-	yes	-	SUM(PurchaseInvoiceItem.Net)
Currency	INTEGER		-	-	yes	Reference to Currency
Gross	DECMIAL		-	yes	-	SUM(PurchaseInvoiceItem.Gross)
Discount	DECMIAL		-	-	-	% Discount
Taxes	DECMIAL		-	-	-	% Taxes (other than VAT)
VAT	DECMIAL		-	yes	-	SUM(PurchaseInvoiceItem.Net * %VAT)
Total	DECMIAL		-	yes	-	Gross - (Gross * Discount / 100) + (Gross * Taxes / 100) + VAT
Conditions	VARCHAR	200	-	-	-	Conditions about payment
PaymentMethod	INTEGER		-	-	yes	Reference to Methods
SentMethod	INTEGER		-	-	yes	Reference to Methods
Status	INTEGER		-	-	yes	Reference to Invoice Status
Document	VARCHAR	200	-	-	-	Link to the scanned copy of the document
Company	INTEGER		-	-	yes	Reference to Companies
Name	VARCHAR	200	-	yes	-	Supplier.Name/Number/Date/Amount
UUID	VARCHAR	36	-	yes	-	Random UUID generated
Reference	VARCHAR	36	-	-	-	Reference via UUID to the PurchaseOrder

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
PurchaseInvoice	INTEGER		no	-	yes	Reference to Purchase Invoice
Name	VARCHAR	2000	no	-	-	Free text representing Product/Service
Quantity	DOUBLE		no	-	-
UoM	INTEGER		no	-	yes	Reference to UoM
Price	DECMIAL		no	-	-
Net	DECMIAL		-	yes	-	Quantity * Price
VAT	DECMIAL		-	-	-	Net * 0.2(depends of the country, for now 20% VAT
Gross	DECMIAL		-	yes	-	Net + VAT

Field	Type	Null?	Calc?	Ref?	Description
Id	INTEGER	no	-	-
PurchaseInvoice	INTEGER	no	-	yes	Reference to Purchase Invoice
PaymentEntry	INTEGER	no	-	yes	Reference to Payments Entry
Amount	DOUBLE	-	-	-	Amount from the payment assigned to this invoice