UPDATE `help` SET `detail` = '[{"name":"BILLINGEMAIL","description":"Email address for billing inquiries","hostingonly":false},{"name":"SUPPORTEMAIL","description":"E-mail to support staff","hostingonly":false},{"name":"COMPANYNAME","description":"Company name","hostingonly":false},{"name":"COMPANYADDRESS","description":"Company address","hostingonly":false},{"name":"COMPANYURL","description":"URL to your web site","hostingonly":false},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation","hostingonly":false},{"name":"CLIENTNAME","description":"Client''s First and Last Name","hostingonly":false},{"name":"FIRSTNAME","description":"Client''s First name","hostingonly":false},{"name":"CLIENTEMAIL","description":"Email Address","hostingonly":false},{"name":"ORGANIZATION","description":"Client''s Organization","hostingonly":false},{"name":"PACKAGEGROUPNAME","description":"Client''s Plan group","hostingonly":false},{"name":"PLANNAME","description":"Client''s Plan","hostingonly":false},{"name":"PACKAGEID","description":"Client''s Plan ID","hostingonly":false},{"name":"NEXTDUEDATE","description":"Client''s Plan next billing date","hostingonly":false},{"name":"USERPACKAGEID","description":"Client''s Package ID","hostingonly":false},{"name":"DATE","description":"Date payment is due."},{"name":"SENTDATE","description":"Date invoice was last sent."},{"name":"INVOICENUMBER","description":"Invoice Number"},{"name":"SUBSCRIPTION_ID","description":"Subscription Id"},{"name":"INVOICEDESCRIPTION","description":"Invoice Description"},{"name":"TAX","description":"Invoice Tax"},{"name":"AMOUNT_EX_TAX","description":"The total price excluding taxes."},{"name":"AMOUNT","description":"The total price due."},{"name":"PAID","description":"The amount already paid of the invoice."},{"name":"BALANCEDUE","description":"The balance due of the invoice."},{"name":"RAW_AMOUNT","description":"The total price excluding currency symbol."},{"name":"DIRECTPAYMENTLINK","description":"Direct Payment Link<br/><i style=''font-size:smaller;''>Add direct link for invoice payment. Only visible when applicable billing plugin that support this method of payment is used</i>"},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password.","hostingonly":false}]' WHERE `title` = 'Notification Email Tags';