
UPDATE pal_Template
SET templateContent = '<style type="text/css">     .heading {     font-size: large;     color: #595959;     }     .subheading{     font-size: medium;     color: #595959;     }     .full {     width: 100%;     }     .half {     width: 50%;     }     .third {     width: 33.3%;     }     .fourth {     width: 25%;     }     .right {     text-align: right; padding-right: 50px; }     .spacer {     height: 20px;     }     .shim {     height: 10px;     }     div {     position: relative;     float: left;     }  .main-info{    font-weight: bold;  }</style> <table class="full" cellpadding="0" cellspacing="0" border="0" style="height: 66px;">     <tbody>         <tr>             <td class="heading" style="width: 300px;">{logo}</td>             <td class="half heading right"><span style="font-family: MS Sans Serif;">{heading}</span></td>         </tr>     </tbody> </table> <table>     <tbody>         <tr>             <td class="spacer"></td>         </tr>     </tbody> </table> <table class="full" cellpadding="0" cellspacing="0" border="0">     <tbody>         <tr>             <td class="third subheading"><span style="font-family: MS Sans Serif;">TO</span></td>             <td class="third subheading"><span style="font-family: MS Sans Serif;">FROM</span></td>             <td class="third" rowspan="3"><span style="font-family: MS Sans Serif;">{DocNum}<br/>   {DocDate}<br/>   {AccountNumber}<br/>  {Reference}<br/>             </span></td>         </tr>         <tr>             <td><span style="font-family: MS Sans Serif;">             <strong>{oSales.title} {oSales.name} {oSales.surname}</strong><br />             {oSales.postalAddress}             </span></td>             <td><span style="font-family: MS Sans Serif;">             <strong>{oSetup.customer}</strong><br />             {oSetup.postalStreet}<br />             {oSetup.postalSuburb}<br />             {oSetup.postalCity}<br />             {oSetup.postalCode}<br />             </span></td>         </tr>         <tr>             <td><span style="font-family: MS Sans Serif;"></span></td>             <td><span style="font-family: MS Sans Serif;">             <strong>{SetupVATNumberLabel}</strong><br />             {oSetup.vatRegistrationNumber}             </span></td>         </tr>     </tbody> </table>'
where templateName = 'Statement Sales Header';
