contacts
add1
add2
add3
comments
companyname
country
email
extension
fax
jobtitle
kind (possible values "Individual", "Company", "Company Contact")
mobile
name
phone
postcode
title
type (possible values "Customer", "Supplier", "Other")
website
orders
(any of the values below can be used - within angled brackets - on the invoice template)
balanceremaining
(the following contact fields are not actually part of the Order record but if used on a template, Organise will retrieve the value from the relevant contact as if they were)
contact:add1
contact:add2
contact:add3
contact:comments
contact:companyname
contact:country
contact:email
contact:companyname
contact:extension
contact:fax
contact:jobtitle
contact:kind
contact:mobile
contact:name
contact:surname
contact:phone
contact:postcode
contact:ref
contact:title
contact:type
contact:website
The above field names retrieve information from the billing address. For Delivery address, add a '2' - eg contact2:name, contact2:add1 etc
date (dd/mm/yyyy or mm/dd/yyyy depending on your preferences)
description
net
newcustomer hidden, populated automatically - within the database held as '0', '1' or '2' but returns string value 'Not known', 'New customer' or 'Returning customer'
ordernum
one special field returning the number 1. Used with collation to give a count
sent (invoice sent - possible values "Yes", "No"
status (possible values "Enquiry", "Order", "Flagged", "Awaiting Collection", "Shipped", "Complete" and any others you've added via Preferences)
shipping
subtotal ((=value) - total of the goods including tax but without shipping)
tax
taxrate
(Do use on templates when you want the current standard (code S) tax rate but don't use in reports any more - legacy, was used when Organise stored a single tax rate and each Order remembered the contemporary tax rate)
title
totalitemspurchased
totaldue
type
Legacy (will still exist on old records but should not be used - see payments instead)
balanceFor new records will contain a balance but may be incorrect if multiple payments are used. Use balanceremaining instead
balancepaid (dd/mm/yyyy or mm/dd/yyyy depending on your preferences)
deposit
depositpaid (dd/mm/yyyy or mm/dd/yyyy depending on your preferences)
total ((=valuewithtax) exists but don't use - legacy - must be removed from old invoice templates - adds tax to total)
Some special ones (pulled from Preferences)
currencysymbol
currencycode
taxrate
taxdescription
payments
amount
datepaid
paymentmethod
order:number
order:title
items
bought ( = the cost price)
category can contain more than one category, comma separated
code
condition (possible values: "New", "As New", "Good", "Used")
comments / description (same field - use either name)
item ( = the item name)
optimumqty
part
price ( = the selling price)
qty
shipping
status
supplier
taxcode
variation
warnlevel
itemspurchased
item (this is the displayed name)
qty
cost
unit
total
code
item:category
order:contact:id
order:contact:email
order:contact:type
order:date
order:number
actions
details
enddate
endtime
rate
startdate
starttime
totalcharge
totaltime
totaltimeunits
complete (returns "YES" or "NO")
bills
number
name
datepaid
amount
net
vat
details / comments (same field - use either name)
category (Possible values: "Rent/Rates", "Light/Heat", "Materials", "Travel", "Stationery", "Postage / Shipping", "Bank Charges / Interest", "Professional Fees", "Repairs / Renewals" and any others you've added via Preferences)