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)
balance
balancepaid (dd/mm/yyyy or mm/dd/yyyy depending on your preferences)
(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)
deposit
depositpaid (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
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
title
totalitemspurchased
[total ((=valuewithtax) exists but don't use - legacy - must be removed from old invoice templates - adds tax to total)]
type
items
bought ( = the cost price)
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
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)