PurchaseItemPrices

Purchase Item Prices

Columns


Name	Type	Description
Timestamp [KEY]	Long	Timestamp
Account	String	ID of the supplier
AccountName	String	Name of the supplier account
Created	Datetime	Creation date
Creator	String	User ID of creator
CreatorFullName	String	Name of creator
Currency	String	The currency of the price
DefaultItemUnit	String	The default unit of the item
DefaultItemUnitDescription	String	The description of the default item unit
Division	Int	Division code
EndDate	Datetime	Together with StartDate this determines whether the price is active
ID	String	ID of the PurchaseItemPrices.
Item	String	Item ID
ItemCode	String	Code of Item
ItemDescription	String	Description of Item
Modified	Datetime	Last modified date
Modifier	String	User ID of modifier
ModifierFullName	String	Name of modifier
NumberOfItemsPerUnit	Double	This is the multiplication factor when going from default item unit to the unit of this price.
Price	Double	The actual price of this purchase item
Quantity	Double	Minimum quantity to which the price is applicable
StartDate	Datetime	Together with EndDate this determines whether the price is active
Unit	String	The unit code of the price
UnitDescription	String	Description of the price unit