|
Invoice Template Variables |
  
|
|
Invoice Template Variables |
|
Date and code
Code to paste to template |
Information to be displayed in the saved document |
\STATUS\ |
Invoice status Example: Expected within 30 days, Settled 5 days earlier |
\DATE_DUE\ \SETTLEMENT_DATE\ |
Date when invoice is due in following format: 10/4/2006 |
\DATE_DUE_LONG\ \SETTLEMENT_LONGDATE\ \DUE_DATELONG\ |
Date when invoice is due in following format: Monday, October 04, 2006 |
\INVOICE_DATE\ \INV_DATE\ |
Date invoice sent in following format: 10/4/2006 |
\INVOICE_DATE_LONG\ \INV_LONGDATE\ |
Date invoice sent in following format: Monday, October 04, 2006 |
\INVOICE_CODE\ \INV_CODE\ |
Invoice code |
\INVOICE_GLOBAL_CODE\ \INV_GLOBAL\ \INV_GLOBALLONG\ |
Invoice global code |
\NOTES\ \INVOICE_NOTES\ |
Invoice notes from Notes tab of Edit Invoice window |
Invoice totals
Code to paste to template |
Information to be displayed in the saved document |
\INVOICE_TOTAL\ |
Invoice total in client's currency |
\INVOICE_TOTAL_BASE\ |
Invoice total in base currency |
\JOBS_TOTAL\ |
Jobs total in client's currency |
\JOBS_TOTAL_B\ |
Jobs total in base currency |
\NET_JOBS_TOTAL\ |
Jobs total with discounts in client's currency |
\NET_JOBS_TOTAL_B\ |
Jobs total with discounts in base currency |
Taxes
Code to paste to template |
Information to be displayed in the saved document |
\TAX1\ |
Indicates if the tax 1 has been added; used in algorithms (If tax 1 exists = True, if it doesn’t = False) |
\TAX1_NAME\ |
Tax 1 name |
\TAX1_VALUE\ |
Tax 1 value in client's currency |
\TAX1_VALUE_B\ |
Tax 1 value in base currency |
\TAX2\ |
Used in algorithms (If tax 2 exists = True, if it doesn’t = False) |
\TAX2_NAME\ |
Tax 2 name |
\TAX2_VALUE\ |
Tax 2 value in client's currency |
\TAX2_VALUE_B\ |
Tax 2 value in base currency |
\TAXES\ |
Indicates whether the taxes in Tax fields are set; used in algorithms (If any tax is set = True, if it they are not = False) |
\AFTER_TAX1\ |
Total in client's currency after Tax 1 applied |
\AFTER_TAX1_B\ |
Total in base currency after Tax 1 applied |
Discounts
Code to paste to template |
Information to be displayed in the saved document |
\DISCOUNT1\ |
Indicates if the discount/markup in the Discount/Markup field is set; used in algorithms (If discount 1 exists = True, if it does not = False) |
\DISCOUNT1_NAME\ |
Discount 1 name |
\DISCOUNT1_VALUE\ |
Discount 1 value in client's currency |
\DISCOUNT1_VALUE_B\ |
Discount 1 value in base currency |
\DISCOUNT2\ |
Indicates if the discount/markup in the Discount/Markup field is set; used in algorithms (If discount 2 exists = True, if it does not = False) |
\DISCOUNT2_NAME\ |
Discount 2 name |
\DISCOUNT2_VALUE\ |
Discount 2 value in client's currency |
\DISCOUNT2_VALUE_B\ |
Discount 2 value in base currency |
\DISCOUNTS\ |
Indicates if the discounts/markups in the Discount/Markup fields are set; used in algorithms (If any discount is set = True, if there are no = False) |
\AFTER_DISCOUNT1\ |
Total in client's currency after Discount 1 applied |
\AFTER_DISCOUNT1_B\ |
Total in base currency after Discount 1 applied |
\NET_JOBS_TOTAL\ |
Jobs total with discounts in client's currency |
\NET_JOBS_TOTAL_B\ |
Jobs total with discounts in base currency |
Payment status variables
Code to paste to template |
Information to be displayed in the saved document |
\INVOICE_DUE\ |
Balance due in client's currency |
\INVOICE_DUE_BASE\ |
Balance due in base currency |
\INVOICE_PAID\ |
Total payments linked to this invoice in client's currency |
\INVOICE_PAID_BASE\ |
Total payments linked to this invoice in base currency |
\INV_IS_PAID\ |
Used in algorithms (If the invoice is paid = True, if it’s not = False) |
\BEFORE_ADJUSTMENTS\ |
Invoice total in client's currency, excluding adjustments |
\BEFORE_ADJUSTMENTS_B\ |
Invoice total in base currency, excluding adjustments |
\ADJUSTMENTS_VALUE\ |
Value of the adjustments in client's currency |
\ADJUSTMENTS_VALUE_B\ |
Value of the adjustments in base currency |
\ADJUSTMENTS_DESCR\ |
Description of the adjustments |
\INVOICE_PAYMETHOD\ |
Invoice payment method. |
\INVOICE_PAYMETHOD_DESCR\ |
Payment method description. |
Client Job Variables in Invoice
Code to paste to template |
Information to be displayed in the saved document |
\DTLINKJOBS:CJOB_PONUMB\ |
Client PO of the job |
\DTLINKJOBS:CJOB_NAME\ |
Client job name |
\DTLINKJOBS:CJOB_ASSIGNED\ |
Date the client job was assigned |
\DTLINKJOBS:CJOB_DEADLINE\ |
Deadline of client job |
\DTLINKJOBS:CJOB_ISCOMPLETED\ |
Completed (Boolean: True/False) |
\DTLINKJOBS:CJOB_COMPLETED\ |
Date the client job was completed |
\DTLINKJOBS:CJOB_PRICE\ |
Price of client job |
\DTLINKJOBS:CJOB_VOLUME\ |
Client job volume |
\DTLINKJOBS:CJOB_FEE_KIND\ |
Pricing (per unit, flat fee) |
\DTLINKJOBS:CJOB_RATE\ |
Exchange rate |
\DTLINKJOBS:CJOB_TOTAL\ |
Job total in client's currency |
\DTLINKJOBS:CJOB_TOTAL_B\ |
Job total in base currency |
\DTLINKJOBS:CJOB_INSTRUCTION\ |
Instructions of client job |
\DTLINKJOBS:CJOB_WORKNOTES\ |
Work notes of client job |
\DTLINKJOBS:CJOB_COUNTNOTES\ |
CATCount notes of client job |
\DTLINKJOBS:SERV_NAME\ |
Service name of client job |
\DTLINKJOBS:UNIT_NAME\ |
Volume units of client job |
\DTLINKJOBS:PROJ_CODE\ |
Project code of client job |
\DTLINKJOBS:CJOB_CODE\ |
Client job code |
\DTLINKJOBS:CJOB_CLCODE\ |
Client Ref. of the job |
\DTLINKJOBS:CCON_NAME\ |
Client PM of the client job |