Form code reference

A form or a message template is text or HTML with codes in it. When TrakIT generates the document or sends the message, it replaces each code with a value: the container number of the work order, the date of an event, the total of an invoice. This page lists the codes, says what each one gives, and in which kinds of form and message it works.

In the app, the ? button (Code Reference) of a form opens the Form Code Reference popup, with the codes of that kind of form: see Code reference. To write a form step by step, see Setting up document templates.

How codes are written

There are four kinds of code:

Kind	Written	Example
A value read from the work order or another record	%%%, a type digit, a comma, a name, then ;	%%%0,CONTNUM;
A value of the document, or a fixed value such as today’s date	The name between ## and ##	##INVNUM##, ##DATE##
A number in words, or a translated word	Between {{ and }}	{{WORDS:150}}
The name of an event or data field of the workflow	Between [ED: and ]	[ED:DEL:NAME]

• Write the codes in capitals, as on this page. The type digit says what the name is: 0 a header field, 1 an event, 2 a data field, 4 an account, 5 an asset, 6 a link or QR code, 7 a document, 8 the user, 9 an entity.
• Many %%% codes take a format after |, before the ;: a date pattern such as dd MMM yyyy or HH:mm, or a number pattern such as #,##0.00. For example %%%1,ETA|dd MMM yyyy;.
• A %%% code must end with ; on the same line. Without it, TrakIT leaves the text as you typed it, so you can see the mistake in the document.
• A name TrakIT does not find, such as a misspelled column or an event the workflow does not have, gives nothing. A ## code that is misspelled, or that does not belong to the kind of form, stays in the document as typed. A %%% code with no comma, such as %%%LOOP; where repeating blocks do not work, gives Undefined.

Where codes work

Each kind of form fills in its own set of codes:

Form or message	Gets its values from	Codes
Work order form	The work order.	Work order codes, items, common codes, form numbers, company codes.
Job form	Each work order of the job in turn, inside the repeating block; outside it, the first one.	As a work order form, plus the repeating block and job totals and the document checklist.
Report form	The rows of an advanced report.	Report form codes only.
Invoice, debit note, credit note, invoice document	The invoice, and the work orders of its job (with no job, those on its lines).	Invoice codes, plus the work order codes, repeating block, job totals, items, document checklist and company codes, as in a job form.
Bill	The bill, and the work orders of its job.	Bill codes, plus the work order codes, repeating block, job totals, items, document checklist and company codes, as in a job form.
Quotation	The quotation.	Quotation codes, common codes. No work order codes.
Receipt voucher, payment voucher	The receipt or payment.	Voucher codes, common codes. No work order codes.
Yard form	The yard move, and its work order.	Yard codes, work order codes, common codes.
Message template	The work order of the event or data field.	See Message templates.

The header and the footer of a form take codes too, but only on work order, job, invoice and bill forms: see Header and footer.

Work order codes

These codes read one work order: the work order of a work order form; in a job form, each work order in turn inside the repeating block and the first one outside it; for an invoice or a bill, the work orders of its job, the same way; for a yard form, the work order of the move; for a message, the work order of the event or data field.

Header fields

%%%0,COLUMN; gives a header field of the work order, by the name of its column. These are the columns for documents:

Code	Gives
%%%0,WORKORDERID;	The work order ID.
%%%0,BOLID;	The job ID.
%%%0,BOLNUM;	The job reference, such as the bill of lading number.
%%%0,BOLTYPENAME;	The job’s job types, separated by commas.
%%%0,CARGOTYPE;	The cargo type, such as Full Container Load (FCL).
%%%0,INCO;	The Incoterms, such as FOB.
%%%0,CORCODE;, %%%0,CORNAME;	The code and the name of the workflow.
%%%0,COUNTRY;	The country of the workflow’s company.
%%%0,CONTNUM;	The container number, or To Be Advised while it starts with TBAU.
%%%0,LOADID;	The load ID, for a load without a container.
%%%0,TYPECODE;	The code of the load type, such as 22G1.
%%%0,CONTLENGTH;	The container length in feet, such as 20 or 40.
%%%0,WEIGHT;	The weight, in kilograms.
%%%0,VOLUME;	The volume, in cubic metres, with three decimals.
%%%0,SEALNUM;	The seal number.
%%%0,COMMODITY;	The commodity.
%%%0,OWNCONT;	True if the shipper owns the container, otherwise False.
%%%0,ORGCNTRY;, %%%0,DESTCNTRY;	The country of origin and the final destination, by name.
%%%0,CONTCUSCODE;, %%%0,CONTCUSNAME;, %%%0,CONTCUSADDR;	The customer’s code, name and address.
%%%0,SHIPPERCODE;, %%%0,SHIPPERNAME;, %%%0,SHIPPERADDR;	The shipper’s code, name and address.
%%%0,RECEIVERCODE;, %%%0,RECEIVERNAME;, %%%0,RECEIVERADDR;	The receiver’s code, name and address.
%%%0,OPCODE;, %%%0,OPNAME;	The carrier’s code and name.
%%%0,AGENTNAME;, %%%0,AGENTPHONE;, %%%0,AGENTEMAIL;	The bond agent’s name, phone number and email address.
%%%0,CLAGENTNAME;, %%%0,CLAGENTPHONE;, %%%0,CLAGENTEMAIL;	The clearing agent’s name, phone number and email address.
%%%0,TRANSCODE;, %%%0,TRANSNAME;, %%%0,TRANSADDR;	The transporter’s code, name and address.
%%%0,RETTRANSNAME;	The return transporter’s name.
%%%0,FIRSTDEPOTNAME;, %%%0,LASTDEPOTNAME;	The first and the last location of the work order’s location list, each as its city and its name, separated by -.
%%%0,DEPOTLIST;	All the locations of the list, in order, separated by ; .
%%%0,RESPNAME;, %%%0,RESPMOBILE;	The name and the mobile number of the work order’s responsible person. %%%0,RESP; also gives the name.
%%%0,CREATEDBY;	The name of the user who created the work order.
%%%0,CREATEDON;	The date and time the work order was created.
%%%0,MONTHCREATED;, %%%0,YEARCREATED;	The month (1 to 12) and the year the work order was created.
%%%0,WOSTATUS;	Active, Abandoned, Cancelled or Closed.
%%%0,REMARKS;	The internal remarks.
%%%0,BLREMARKS;	The remarks for the job.
%%%0,CUSTREMARKS;	The remarks for the customer.
%%%0,LASTEVENT;, %%%0,LASTEXTNAME;, %%%0,LASTEVENTDATE;	The work order’s last event: its name, its external name and its date.
%%%0,CUSEVENT;, %%%0,CUSEXTNAME;, %%%0,CUSEVENTDATE;	The last event the customer can see: its name, its external name and its date.
%%%0,YARDPOS;	The container’s position in the yard.

• %%%0,CREATEDON; is in the local time of the user who generates the document. %%%0,LASTEVENTDATE; and %%%0,CUSEVENTDATE; are in UTC: for a local date, use the event’s own code with %%%1.
• A format after | applies to the numbers and dates, for example %%%0,WEIGHT|#,##0; or %%%0,CREATEDON|dd.MM.yyyy;.
• %%%0,LASTEVENT; is in bold when the work order’s status has changed and its customer is notified by email.
• Other columns of the work order work the same way. For the other details of an entity, such as the shipper’s phone number, use the entity codes.

Entities

%%%9,ROLE-COLUMN; gives a detail of one of the work order’s entities. ROLE says which entity:

Role	Entity
CONTCUS	The customer.
SHIPPER	The shipper.
RECEIVER	The receiver.
OP	The carrier.
AGENT	The bond agent.
CLAGENT	The clearing agent.
TRANS	The transporter.
RETTRANS	The return transporter.

COLUMN says which detail of the entity:

Column	Gives
ENTCODE, ENTNAME, LOCALNAME	The code, the name and the local name.
ADDRESS	The address.
CONTACT, PHONE, EMAIL	The contact person, the phone number and the email address.
FINEMAIL, MGMTEMAIL	The finance and the management email addresses.
TIN, REGN	The tax number (TIN) and the registration number.
COUNTRYCODE	The code of the country.
ENTITY.CURRCODE	The currency code.
ENTITY.REMARKS	The remarks.

For example %%%9,CONTCUS-TIN;, %%%9,SHIPPER-PHONE; or %%%9,TRANS-ADDRESS;. Write ENTITY. before CURRCODE and REMARKS, because the job and the work order have columns of the same name: without it, the code gives {Err}.

%%%9,ROLE-ENTDATA-CODE; gives the value of one of the entity’s data fields, by its code, for example %%%9,CONTCUS-ENTDATA-CRDAYS;. A format can follow after |. The older codes %%%9,CUSTIN;, %%%9,SHTIN; and %%%9,RCTIN; still give the TIN of the customer, the shipper and the receiver.

Events and data fields

Code	Gives
%%%1,CODE;	The date and time of the event with that code in the workflow, such as 14:30, 05 Mar 2026.
%%%2,CODE;	The value of the data field with that code. A number has the field’s decimals, a currency two decimals, and a date is shown as an event date.
%%%1,CODE|format;, %%%2,CODE|format;	The same, with a date or number format, such as %%%1,ETA|dd MMM; or %%%2,QTY|#,##0;. |W writes a number in words.
%%%2,CODE~1;	The remarks of the event or data field.
%%%2,CODE~3;	When it was last updated.
%%%2,CODE~4;	The name of the user who last updated it.
%%%2,CODE-COLUMN;	For a data field that holds an entity or a location: a detail of that entity or location, such as %%%2,POD-ADDR; for the address of the location in the field POD. For an entity, the columns are those of the entity codes, written without ENTITY.; for a location, for example GEONAME, ADDR, CITYNAME, COUNTRYNAME, GEOCONTACT and GEOPHONE.
[ED:CODE:NAME]	The name of the event or data field in the workflow, such as Delivered to Customer.
[ED:CODE:EXTNAME]	Its external name, the name external users see, or its name if it has none.
##QREV-CODE##	The address of a QR code image. Scanned with the separate TrakIT app by a user who can update events, it records that event on the work order, with the time of the scan, if it is not recorded yet.

Dates and times are in the local time of the user who generates the document. %%%1 and %%%2 read the same way, so either one works for an event or a data field. An event or data field the workflow does not have gives nothing.

Accounts, assets and the user

Code	Gives
%%%4,CODE;	The total of the job’s actual amounts (not estimates) on the account with that account code, in the base currency, such as %%%4,CHARGES;. Empty in a work order form.
%%%5,CODE;	The value of the asset data field with that code, from the assets linked to the work order.
%%%5,TYPE-COLUMN;	A detail of the work order’s asset of that asset type, by the type’s name without spaces, for example %%%5,TRUCK-ASSETSERIAL; or %%%5,TRUCK-ASSETNAME;. LATESTLOCATION gives the asset’s last known address.
%%%5,TYPE-LIST;	The names of all the work order’s assets of that type, separated by commas, such as %%%5,TRAILER-LIST;.
%%%5,TYPE-COUNT;	How many assets of that type are linked to the work order.
%%%8,COLUMN;	A detail of the user who generates the document: FULLNAME, FIRSTNAME, LASTNAME, EMAIL, MOBILE, USERID or OFFICENAME (the user’s company). For example %%%8,OFFICENAME;.
%%%8,UDV-CODE;	The value of one of the user’s data fields, such as %%%8,UDV-DOB;.

The %%%8 codes give nothing when no user generates the document, for example in a message sent by a workflow action.

Links and QR codes

Code	Gives
%%%6,TRACKWO;	A link to the work order’s shared page, reading WO and its ID. Put your own text after |: %%%6,TRACKWO|Track this container;.
%%%6,TRACKLINK;	A link to the customer’s tracking page, reading Tracking Link or your text after |. [Entity not available] if the work order has no customer.
%%%7,FILENAME;	A link to the work order’s latest document whose file name or title is FILENAME, or else the job’s, such as %%%7,Invoice.pdf;. Spaces are ignored, and * and ? work as wildcards. [Not Found] if there is none.
##QRWO##	The address of a QR code image that opens the work order, to use in an <img> tag: <img src="##QRWO##">.
%%%6,QRURL|CODE;	The address of a QR code image for the web address held in the data field CODE.
%%%6,QRLOC|CODE;	The address of a QR code image that opens Google Maps on the address held in the data field CODE.
%%%6,QRNAV;	A QR code image, ready to show, that opens Google Maps directions to the work order’s last location. If that location has no position, a grey square says No position available. Add a size in pixels after |, from 40 to 400 (100 by default): %%%6,QRNAV|120;.

Items

%%%ITEMSTART; … %%%ITEMEND; marks a block that is repeated for each item of the work order. Inside it:

Code	Gives
##NUM##	The item’s number in the list: 1, 2, 3 and so on.
%%%ITEMCODE;, %%%ITEMNAME;	The item’s code and name.
%%%DESCRIPTION;	The item’s description.
%%%QTY;, %%%UNITNAME;	The quantity and its unit.
%%%WEIGHT;, %%%VOLUME;	The weight and the volume.
%%%HSCODE;	The HS code.
%%%SERIAL;	The serial number.
%%%REFERENCE;, %%%REMARKS;	The reference and the remarks.
%%%FULLNAME;	The name of the user who added the item.

Only item codes work inside the block: any other %%% code there, or a name that is not one of the item’s, turns the whole block into {Error}. Outside the block:

Code	Gives
##TOTALITEMQTY##	The total quantity of the work order’s items.
##TOTALITEMWEIGHT##, ##TOTALITEMVOLUME##	Their total weight and volume, from the weight and volume of each item in the item list.

Items work in work order and job forms, and in invoice and bill forms. In a job form, a block inside the repeating block lists the items of each work order; outside it, those of the first one.

Document checklist

Code	Gives
##CHECKLISTFULL##	A table of the job’s document checklist: each document and its status.
##CHECKLISTPENDING##	The same, with only the documents still outstanding: Pending, Partial, Incorrect, Requested, Have Draft, Have Telex and Need Stamp, and Have Copy where the original is required.

The checklist codes work in job forms, invoice and bill forms, and message templates, not in work order forms.

Job forms: the repeating block

In a job form, %%%LOOP; … %%%END; marks a block that is repeated for each work order of the job that is not cancelled, in the order of their IDs, or for those the form’s filter keeps. One element of the block must have the data-id ##WOID##, or TrakIT refuses to save the form: see The form editor.

Code	Gives
%%%LOOP|,;	Starts the block, and puts the text after | (here a comma) between the repeats. Job forms only.
##SERIAL##	Inside the block, the work order’s number in the list: 1, 2, 3 and so on.
##NUM20##, ##NUM40##	How many work orders of the block have a 20-foot and a 40-foot container.
##NUMX##	How many have another length, or no container.
##NUMALL##	How many work orders the block has.
##FIRSTWO##	The ID of the first work order.
##TOTALWEIGHT##, ##TOTALVOLUME##	The total weight and volume of the work orders.

A second %%%LOOP; … %%%END; block is repeated the same way. The repeating block and the totals also work in invoice and bill forms, over the work orders of the invoice’s or bill’s job, and in a message template that has a repeating block.

Common codes

These work in every kind of form and in message templates, except report forms (see Report forms).

Code	Gives
##DATE##	Today’s date, such as 05 Mar 2026.
##DAY##, ##MONTH##, ##MMM##	The day (05), the month (03) and the short month name (Mar).
##YEAR##, ##YY##	The year (2026) and its last two digits (26).
##TIME##	The time, such as 14:30.
##NOW##	The time and date, such as 14:30, 05 Mar 2026.
##NOW|format##	The time and date in your format, such as ##NOW|dd-MMM HH:mm##.
##ISOTIME##	The date and time in UTC, such as 2026-03-05T11:30:00Z.
##USERID##, ##USERNAME##	The user ID and the name of the user who generates the document. System when no user does.
##USEREMAIL##, ##USERMOBILE##, ##USEROFFICE##	That user’s email address, mobile number and company. — when no user does.
{{WORDS:number}}	The number in words, such as {{WORDS:150}}. Not in yard forms.
{{TRANS-C:text}}	The text translated into the form’s Language, using the translation cache. Not in message templates.
{{TRANS-X:text}}	The same without the cache. Slower, so use TRANS-C.

Dates and times are in the local time of the user who generates the document. A message sent by a workflow action uses the workflow’s time zone.

Form numbers

Code	Gives
##REFNO##	The document’s unique reference number, kept in the form history. Work order and job forms.
##FORMSEQ##	The form’s generation count, this generation included, on four digits, such as 0042. Work order, job, report, invoice and voucher forms.

Company codes

These give details of the company: in a work order or job form, the company of the workflow; in an invoice or bill form, the company of the invoice or bill.

Code	Gives
##CMPHDR-COLUMN##	A detail of the company, by the name of its column, such as ##CMPHDR-OFFICENAME## or ##CMPHDR-FINCODE##.
##CMPDATA-CODE##	The value of one of the company’s data fields, such as ##CMPDATA-SAPCID##.
##CMPDATA-CODE|REMARKS##	Its remarks. |UPDATED gives the date it was last updated and |USERNAME who updated it.

Codes TrakIT Support sets up

Code	Gives
##SQL and a number, such as ##SQL12##	A value TrakIT Support computes for the record.
##QREP and a number, such as ##QREP45##	The query report with that ID, as a table. The record’s ID goes to the report’s first parameter. Work order, job, invoice, voucher and quotation forms.

Invoices, debit notes, credit notes and invoice documents

These forms also take the work order codes, the repeating block and job totals, items, the document checklist and the company codes: they read the work orders of the invoice’s job or, for an invoice with no job, the work orders on its lines.

Code	Gives
##TITLE##	The title, such as Invoice, Credit Note or Pro-Forma Invoice; for an invoice document, the form’s name.
##INVNUM##, ##PFNUM##	The invoice number and the pro forma number.
##INVDATE##, ##INVDATE|format##	The invoice date, such as 05 Mar 2026, or in your format: ##INVDATE|dd.MM.yy##.
##DUEDATE##, ##CREDITDAYS##	The due date and the credit days, or - without credit days.
##INVCURR##	The currency.
##INVREM##	The invoice remarks.
##CRBY##, ##CRDATE##	Who created the invoice, and when.
##BOLID##, ##BOLNUM##	The job ID and the job reference.
##REVRECDATE##	The job’s revenue/expense recognition date.
##INVTO##, ##INVTOCODE##, ##INVTOLOCAL##	The customer’s name, code and local name.
##ADDRESS##	The address on the invoice.
##INVTOTIN##, ##INVTOREGN##, ##INVTOCOUNTRY##	The customer’s TIN, registration number and country.
##INVTOCONTACT##, ##INVTOPHONE##	The customer’s contact person and phone number.
##INVTOEMAIL##, ##INVTOFINEMAIL##, ##INVTOMGMTEMAIL##	The customer’s general, finance and management email addresses.
##INVTOREMARKS##	The customer’s remarks.
##ENTDATA-CODE##	The value of one of the customer’s data fields.
##INVTABLE##	The table of the invoice lines.
##INVTOTAL##, ##INVWORDS##	The invoice total, in figures and in words.
##TAXABLE##, ##TAXTOTAL##, ##TAXWORDS##	The taxable amount, the total tax, and the total tax in words.
##INVTAXDEDUCT##	The tax deducted.
##RECEIVABLEWORDS##	The amount receivable, after adjustments, in words.
##XRATE##, ##XRATEREV##	The invoice’s exchange rate, and its reciprocal.
##DXRATE##	The exchange rate derived from the lines.
##XRATE-XXX##	The rate of the currency XXX, such as ##XRATE-USD##.
##CURR-XXX##, ##CURR-XXX|WORDS##	The total in the currency XXX, in figures or in words, such as ##CURR-EUR##.
##CURR-XXX|REC##	The amount receivable in the currency XXX.
##INVREF##	On a credit note, the number of the invoice it credits.
##CNREF##	On an invoice, the number of the credit note linked to it.
##ECODE##, ##EINVSCUNUM##	Where e-invoicing is on: the e-invoice code and number.
##INVREFECODE##, ##CNREFECODE##	The e-invoice code of the credited invoice, and of the linked credit note.
##QRINV##	The address of a QR code image that opens the invoice in the external portal.
##FORMSEQ##	See Form numbers.

The customer codes of quotations without |TYPE, such as ##ENTNAME## or ##ENTADDR##, give the invoice’s customer too, and the data field codes its invoice data fields.

Bills

Bill forms also take the work order codes, the repeating block and job totals, items, the document checklist and the company codes, read from the work orders of the bill’s job.

Code	Gives
##ID##, ##NUM##, ##SEQ##	The bill ID, the vendor’s bill number and the sequence number.
##BILLDATE##, ##DUEDATE##	The bill date and the due date.
##RECEIVEDDATE##, ##VALIDATEDDATE##, ##FINALISEDDATE##	When the bill was received, validated and finalised.
##CRBY##, ##VALIDATEDBY##, ##FINALISEDBY##	Who created, validated and finalised it.
##REMARKS##	The remarks.
##ACCTABLE##	The table of the bill lines.
##TOTAL##, ##TOTALWORDS##	The total with tax, in figures and in words.
##AMTTOTAL##	The total without tax.
##TAXAMT##, ##TAXTOTAL##, ##TAXTOTALWORDS##	The tax amount, the total tax, and the total tax in words.
##TAXDEDUCT##	The tax deducted.
##OUTSTANDINGAMT##	The amount still to pay.

The customer codes of quotations without |TYPE, such as ##ENTNAME##, give the bill’s vendor.

Quotations

Code	Gives
##ID##, ##NUM##, ##REV##	The quotation ID, number and revision.
##TITLE##	The quotation’s title.
##QDATE##, ##VALDATE##	The quotation date and the date it is valid until.
##CRBY##	Who created it.
##CURR##	The currency.
##EXTREM##, ##TERMS##	The external remarks and the terms and conditions.
##ACCTABLE##	The table of the quotation lines.
##TOTAL##, ##TOTALWORDS##	The total with tax, in figures and in words. Empty when the quotation hides its total.
##AMTTOTAL##, ##TAXTOTAL##	The total without tax, and the total tax.
##XRATE-XXX##	The rate of the currency XXX.
##CURR-XXX##, ##CURR-XXX|WORDS##	The total in the currency XXX, in figures or in words.
##ENTNAME##, ##ENTCODE##, ##ENTLOCAL##	The customer’s name, code and local name.
##ENTADDR##, ##ENTCOUNTRY##	The customer’s address and country.
##ENTCONTACT##, ##ENTPHONE##	The customer’s contact person and phone number.
##ENTEMAIL##, ##ENTFINEMAIL##, ##ENTMGMTEMAIL##	The customer’s general, finance and management email addresses.
##ENTTIN##, ##ENTREGN##, ##ENTREMARKS##	The customer’s TIN, registration number and remarks.
##ENTNAME|TYPE## and the others	The same detail of another entity of the quotation: |TRANS the transporter, |SHP the shipper, |REC the receiver, |OP the carrier. For example ##ENTNAME|SHP##.

Receipt and payment vouchers

Code	Gives
##ID##, ##SEQ##, ##REF##	The receipt or payment ID, its sequence number and its reference.
##TITLE##	Receipt Voucher or Payment Voucher.
##TRANSDATE##, ##TRANSMODE##	The transaction date and the payment mode.
##COMP##, ##CURR##	The company and the currency.
##REM##	The remarks.
##NUMLIST##	The numbers of the invoices or bills it pays, separated by commas.
##TRANSTABLE##	The table of those invoices or bills.
##ACCTABLE##	The table of the lines of those invoices or bills.
##AMOUNT##, ##AMOUNTWORDS##	The amount, in figures and in words.
##TOTALADJ##, ##TOTALADJWORDS##	The total adjustments, in figures and in words.
##FINALAMOUNT##, ##FINALAMOUNTWORDS##	The amount including the adjustments, in figures and in words.
##CRBY##, ##CRDATE##	Who created it, and when.
##APPBY##, ##APPDATE##, ##APPDATE|format##	Who approved it, and when, also in your format.
##ENTITY##	The entity’s name.
##ENTNAME##, ##ENTCODE##, ##ENTLOCAL##, ##ENTCURRCODE##	The entity’s name, code, local name and currency code.
##ENTADDR##, ##ENTCOUNTRY##, ##ENTCONTACT##, ##ENTPHONE##, ##ENTEMAIL##	Its address, country, contact person, phone number and email address.
##ENTTIN##, ##ENTREGN##, ##ENTREMARKS##	Its TIN, registration number and remarks.
##CONTACTNAME##, ##CONTACTDESIG##	The contact chosen on the receipt or payment, and their designation.
##CONTACTPHONE##, ##CONTACTEMAIL##, ##CONTACTIDNUM##	That contact’s phone number, email address and ID number.
##FORMSEQ##	See Form numbers.

Data fields of finance documents

Every finance form takes the document’s own data fields: those of invoices, quotations, receipts, payments or bills.

Code	Gives
##DATA-CODE##	The value of the data field with that code, such as ##DATA-DAYCOUNT##.
##DATA-CODE|format##	A date field in your format, such as ##DATA-ETA|dd.MM.yy##.
##DATAREM-CODE##	The remarks of the data field.

Live signature box

A finance form with Require Live Signature must contain exactly one signature box, <div class="LiveSign"></div>, which the user signs in the preview before the document is generated. It is 280 by 90 pixels unless you give it a size, and any text inside it is shown as a caption: <div class="LiveSign" style="width:300px;height:100px">Customer Signature</div>. See Form fields.

Yard forms

Yard forms take these codes, the %%% work order codes and ##QRWO## of the move’s work order, and the common codes except {{WORDS:...}}. ##USERID## and ##USERNAME## give the user who recorded the move.

Code	Gives
##MOVEID##, ##MOVETYPE##	The move ID and the move type.
##MOVEADDED##, ##EXECUTED##	When the move was added and when it was executed.
##YARD##, ##ZONE##, ##BAY##, ##ROW##	The yard, and the zone, bay and row.
##AREAID##, ##POSID##	The IDs of the area and of the position.
##CONTNUM##, ##CONTTYPE##, ##CONTLENGTH##	The container number, type and length.
##ISEMPTY##	Empty or Full.
##IMPEX##	Import, Export or Other.
##SEALNUM##	The seal number.
##WOID##, ##BOLNUM##	The work order ID and the job reference.
##VEHNAME##, ##DRIVER##, ##ASSETID##	The vehicle, the driver and the asset ID.
##REF##, ##REMARKS##	The reference and the remarks.
##EXPIRES##	An expiry date: today, or tomorrow when fewer than six hours of today are left.
##QRMV##	The address of a QR code image that opens the move in the mobile app.
##DATA-CODE##	The value of one of the move’s data fields.

Report forms

A report form lays out the rows of an advanced report sent by a subscription. It takes only these codes:

Code	Gives
%%%ROWST; … %%%ROWEND;	A block repeated for each row of the report.
%%%GROUPST; … %%%GROUPEND;	A block added before the rows of each value of the report’s Group separator.
%%%CODE;	The value of the report field with that Field Code, such as %%%CONTNUM;. [ Not Found ] if the report has no such field.
##SERIAL##	Inside the row block, the row’s number: 1, 2, 3 and so on.
##NUMALL##	How many rows the report has.
##F and the field’s ID, then ##	The total of a field that has one, such as ##F234##. TrakIT Support can give you the field’s ID.
##DATE##, ##YEAR##, ##MONTH##, ##TIME##	Today’s date, the year, the month (3, not 03) and the time.
##FORMSEQ##	See Form numbers.

Message templates

A message template sent by an action of an event or data field takes the work order codes, the document checklist, the repeating block and job totals (with a plain %%%LOOP;), {{WORDS:...}}, the ##SQL codes and the date and user codes of the common codes. It does not take items, form numbers, company codes, query reports or translations. The action has no user, so ##USERNAME## gives System and the %%%8 codes give nothing. The work order codes and the common codes also work in the subject of an email action, and in a plain message typed on the action.

A message template can also be the Message Template of a print form, used as the body of the email when the document is emailed, for example an invoice or a quotation. It then takes the codes of that kind of form.

A message template used as the Email Template of a query report or an advanced report is sent as it is: its codes are not replaced.