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 |