Purchase Order, Stock, and System Fields

Purchase Order

Details about the purchase order.

Purchase Order	Unique identifier - the purchase order
Number	Text
Date	Date the order was sent, or null
Delivery Address	Text
Comments to Vendor	Text
Internal Notes	Text
Shipping Cost	Currency
Cancelled	Date if its been cancelled, or null.
Closed	True/False

Purchase Order Line Item

This represents a line on the purchase order, this is summary data.

Supplier Code	Text - Supplier Code for the Item
Item Name	Text
Cost	Currency
Quantity	Integer
Size Name	Text
Size Display Order	Integer
Current Stock Available	Integer - The current stock on hand (as at report date)
Count to be Delivered	Integer - The current stock on order (as at report date)
Number in Pending Orders	Integer - The current stock in unsent orders (as at report date)
Preallocated to Students	Integer - The current stock ordered by students (as at report date)

Purchase Order Payments

Payments made to the Supplier for this Purchase Order.

Given Name	Unique identifier - the contract config from which it was created
Surname	Text
Amount	Currency
Date	Date of payment

Purchase Order Individual Entries

These entries include items received information (non summarized).

Description	Unique identifier - the contract config from which it was created
Supplier Code	Text
Qty	Integer
Buy	Currency
Supply Date	Null = this is an order item row, Date = this is an item received row
Cancelled	Item removed from order, or received data removed

Stock and Fees

Stock Item Types defined in your system.

Item Name	Text
Is Inventory Item	True = inventory item, False = fee
Size	Text
Size Display Order	Integer
Default Buy Price	Currency
Default Sell Price	Currency
Inc Tax	True/False
Number in Stock	Integer - The current stock on hand (as at report date)
Number Backordered	Integer - The current stock on order from Suppliers (as at report date)
Deleted	null, or not null if deleted

Stock Adjustment

Details on stock adjustments.

Check	filter for stock adjustment entries only
Date	Date of adjustment
Item Name	Text
Quantity	Integer
Size	Text
Size Display Order	Integer

System

System Values.

Organisation Name

Text