suppliers

Module: inventory

Supplier associations for items with pricing and lead times.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Supplier ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
item items.ID	integer			Item ID (**dependency**)
account accounts.ID	integer			Account ID (**dependency**)
itemnum	text		''	Supplier item number (SKU)
price	double precision			Supplier price per unit
taxrate	double precision			Supplier tax rate in percent
minamount	double precision		0	Minimum order amount (quantity)
deliverytime	smallint			Expected delivery time in days
stock	double precision			Expected stock/inventory amount (quantity)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_suppliers_account					gin	account
pk_suppliers					btree	ID
s_suppliers_itemnum					gin	itemnum
u_suppliers_item_account					btree	item, account

Name	Type
dc_suppliers_deliverytime	check
dc_suppliers_itemnum	check
dc_suppliers_minamount	check
dc_suppliers_taxrate	check
fk_suppliers_account	foreign_key
fk_suppliers_item	foreign_key
pk_suppliers	primary_key
u_suppliers_item_account	unique

Loading...