ID

Column

Description

Account

Account code

The customer account code.

ALLOCATED

Allocated quantity

The quantity allocated (reserved) for your customer.

NAME2

Alternate product code

This column can be used to find products based on the entry contained in the Alternate field in Stock Control.

FREESTOCK

Available stock

The quantity of stock available for sale. (This is calculated as total physical stock less allocated/reserved stock.)

QTY

Back order quantity

The quantity remaining on back order.

BOX

Box quantity on back order

The quantity of stock remaining on back order in box quantity units.

BOXALLOC

Box quantity allocation

The quantity of stock on back order in box units rather than standard units of measure.

CARRIER

Carrier/method of shipping

For more information on carrier codes consult the topic: Carriers. This column is only available in the Enterprise Edition.

COMMENT

Comment

A comment line relating to the status of the back ordered item.

Onhold

Customer on hold status

The status of the account: Yes if on hold, otherwise No.

DATE

Date of back order

The date the back order was first raised.

TITLE

Description

The product description.

DADR1

Delivery address line #1

The first line of the customer's delivery address.

DADR2

Delivery address line #2

The 2nd line of the customer's delivery address.

DNAME

Delivery name

The name of the delivery location.

DSUBURB

Delivery suburb

The suburb of the delivery address.

DSTATE

Delivery state

The state of the delivery address.

DPOSTCODE

Delivery postcode

The postcode of the delivery address.

DEPARTMENT

Department

The transaction department code.

DESCRIPTION

Product description

The line item's product description.

DIMENSION

Dimension

The product's dimension. For more information on dimension conversion factors see: Dimension Based Pricing.

DISCOUNT

Discount percentage

The line item's discount percentage.

LISTDISC

Discount Off list price

The product's discount percentage off the item's sell price.

FORWARD

Forward date

The forward date of the back order. Back orders will not be allocated stock or released until the current system date is equal to or greater than the forward date.

HOLD

Hold release marker

Tick this column to place the back order on hold. (Held back orders will not be released.)

ORDERED

Last ordered date

The last time this back ordered item was ordered through the purchasing system.

LEADTIME

Lead time

The lead time in days for this product.

LOCATION

Location

The stock item's location.

LISTPRICE

List price

The list price.

MEASURE

Measure (unit of)

The item's unit of measure description.

NEXTDEL

Next delivery expected date

The next expected purchase order delivery date of the selected stock item.

REFERENCE

Order Number/Reference

The customer order number or reference.

PRIORITY

Order priority

The priority of the sales order. States include: urgent, high, normal and low. If the Warehouse Manager component is installed, the priority of the sales order can be used to determine the picking sequence for warehouse staff.

PURCHASE

Purchase marker

Tick this column to mark this back order for automatic purchasing.

PCODE

Product Code

The stock item's product code, part number or main reference code.

PURCHMIN

Purchase Unit Minimum

The minimum supplier purchase quantity for this stock item.

STOCKIN

Physical Stock

The quantity physically in stock.

PICKED

Quantity picked

The quantity picked by the warehouse.

This column is available only when the Warehouse Manager component is installed.

RELEASE

Release marker

Tick this column to mark this back order for selective release.

OURREF

Second Reference

The second transaction reference.

REF1

Ref #1 (item)

Reference #1. This can contain up to 20 characters of information.

REF2

Ref #2 (item)

Reference #2. This can contain up to 20 characters of information.

REQUIRED

Required

The date the item is required by the customer.

SALEPERSON

Salesperson

The salesperson's code.

SELLPRICE

Sell Price

The sell price. If the item is sold by a dimension, this is the sell price per dimension (e.g., sell price per metre) otherwise if no dimension has been set-up, it will be the sell price per unit or piece.

STOCKID

Stock ID

The Stock ID. This is a unique 7 digit code assigned to every stock item in Stock Control.

TNAME

Transaction Name

The sales order or invoice account name.

TOTAL

Total $ (Unit x Qty)

The sell price multiplied by the number of units on back order.

TRANO

Transaction Number

The sales order or invoice transaction number.

TRANSACTION

Transaction Source

The transaction source. This is either a "sales order" or an "invoice" which contains back ordered items.

VOLUME

Volume

The unit volume of the item.

WEIGHT

Weight

The unit weight of the item.

ZONE

Zone (of delivery)

The back ordered item's delivery zone. For more information on zones the topic: Delivery Zones. This column is only available in the Enterprise Edition.