pears.Composite [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.Composite ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
List of Composite Payroll Companies.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **CompositeId** | char(20) | NOT NULL |  |  |
| CompositePayCoReference | char(60) | NULL |  |  |
| VATNumber | char(20) | NULL |  |  |
| RegNo | char(20) | NULL |  |  |
| CompanyName | char(50) | NULL |  |  |
| BankRef | char(20) | NULL |  |  |
| BankAcNo | char(15) | NULL |  |  |
| BankAcName | char(50) | NULL |  |  |
| BankSortCode | char(8) | NULL |  |  |
| BankName | char(30) | NULL |  |  |
| TemplateName | char(30) | NULL |  |  |
| PayrollAddress | long varchar | NULL |  |  |
| VATRegistered | tinyint | NULL | 0 |  |
| TaxMethod | tinyint | NULL |  |  |
| PayFrequency | tinyint | NULL |  |  |
| FlagPayMethod | tinyint | NULL | 0 |  |
| FlagPayrollAddress | tinyint | NULL | 0 |  |
| FlagPayCoReference | tinyint | NULL | 0 |  |
| FlagVATNumber | tinyint | NULL | 0 |  |
| FlagVATRegistered | tinyint | NULL | 0 |  |
| FlagRegNo | tinyint | NULL | 0 |  |
| FlagCompanyName | tinyint | NULL | 0 |  |
| FlagTaxMethod | tinyint | NULL | 0 |  |
| FlagPayFrequency | tinyint | NULL | 0 |  |
| FlagBankRef | tinyint | NULL | 0 |  |
| FlagBankAcNo | tinyint | NULL | 0 |  |
| FlagBankAcName | tinyint | NULL | 0 |  |
| FlagBankSortCode | tinyint | NULL | 0 |  |
| FlagBankName | tinyint | NULL | 0 |  |
| PayMethod | tinyint | NULL |  |  |
| FlagIBAN | tinyint | NULL |  |  |
| IBAN | char(34) | NULL |  |  |
| FlagSWIFTBIC | tinyint | NULL |  |  |
| SWIFTBIC | char(11) | NULL |  |  |
| DirectlyEmployed | tinyint | NOT NULL | 0 |  |
| FlagDirectlyEmployed | tinyint | NULL | 0 |  |
| FlagPayDistribution | tinyint | NULL |  |  |
| PayDistribution | char(4) | NULL |  |  |
| HMRCEngagementDetail | char(1) | NULL |  |  |
| PayrollAddr1 | char(40) | NULL |  |  |
| PayrollAddr2 | char(40) | NULL |  |  |
| PayrollAddr3 | char(40) | NULL |  |  |
| PayrollAddr4 | char(40) | NULL |  |  |
| PayrollPostcode | char(30) | NULL |  |  |
| SupplierCode | char(12) | NULL |  | Self bill account for umbrella etc. |
| FlagSupplierCode | tinyint | NULL | 0 |  |
| EmailAddress | char(250) | NULL |  |  |
| FlagEmailAddress | tinyint | NULL | 0 |  |
| FlagHMRCEngagementDetail | tinyint | NULL |  |  |
| AnalysisCode | char(5) | NULL |  | Can be sent to Accord. |

===== Primary Key =====
  * CompositeId

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_pay_employee|pears.Pay_Employee]] | Composite | CompositeID | CompositeId |

===== Indexes =====
  * No indexes found.

===== Triggers =====
^ Name ^ Timing ^ Event ^
| CompositeSelfBill | after | insert,update order 1 |
| CompositeAudit | before | update of "CompositeId", "CompositePayCoReference","VATNumber","RegNo","CompanyName","BankRef","BankAcNo","BankAcName","BankSortCode","BankName", "TemplateName","PayrollAddress","VATRegistered","TaxMethod","PayFrequency","FlagPayMethod","FlagPayrollAddress","FlagPayCoReference", "FlagVATNumber","FlagVATRegistered","FlagRegNo","FlagCompanyName","FlagTaxMethod","FlagPayFrequency","FlagBankRef", "FlagBankAcNo","FlagBankAcName","FlagBankSortCode","FlagBankName","PayMethod","FlagIBAN","IBAN","FlagSWIFTBIC", "SWIFTBIC","DirectlyEmployed","FlagDirectlyEmployed","FlagPayDistribution","PayDistribution","HMRCEngagementDetail", "PayrollAddr1","PayrollAddr2","PayrollAddr3","PayrollAddr4","PayrollPostcode","SupplierCode","FlagSupplierCode", "EmailAddress","FlagEmailAddress","FlagHMRCEngagementDetail","AnalysisCode" order 1 |

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."Composite"
-- Table comment: List of Composite Payroll Companies.
-- Statement count: 8

CREATE TABLE "pears"."Composite" (
    "CompositeId"                    char(20) NOT NULL
   ,"CompositePayCoReference"        char(60) NULL
   ,"VATNumber"                      char(20) NULL
   ,"RegNo"                          char(20) NULL
   ,"CompanyName"                    char(50) NULL
   ,"BankRef"                        char(20) NULL
   ,"BankAcNo"                       char(15) NULL
   ,"BankAcName"                     char(50) NULL
   ,"BankSortCode"                   char(8) NULL
   ,"BankName"                       char(30) NULL
   ,"TemplateName"                   char(30) NULL
   ,"PayrollAddress"                 long varchar NULL
   ,"VATRegistered"                  tinyint NULL DEFAULT 0
   ,"TaxMethod"                      tinyint NULL
   ,"PayFrequency"                   tinyint NULL
   ,"FlagPayMethod"                  tinyint NULL DEFAULT 0
   ,"FlagPayrollAddress"             tinyint NULL DEFAULT 0
   ,"FlagPayCoReference"             tinyint NULL DEFAULT 0
   ,"FlagVATNumber"                  tinyint NULL DEFAULT 0
   ,"FlagVATRegistered"              tinyint NULL DEFAULT 0
   ,"FlagRegNo"                      tinyint NULL DEFAULT 0
   ,"FlagCompanyName"                tinyint NULL DEFAULT 0
   ,"FlagTaxMethod"                  tinyint NULL DEFAULT 0
   ,"FlagPayFrequency"               tinyint NULL DEFAULT 0
   ,"FlagBankRef"                    tinyint NULL DEFAULT 0
   ,"FlagBankAcNo"                   tinyint NULL DEFAULT 0
   ,"FlagBankAcName"                 tinyint NULL DEFAULT 0
   ,"FlagBankSortCode"               tinyint NULL DEFAULT 0
   ,"FlagBankName"                   tinyint NULL DEFAULT 0
   ,"PayMethod"                      tinyint NULL
   ,"FlagIBAN"                       tinyint NULL
   ,"IBAN"                           char(34) NULL
   ,"FlagSWIFTBIC"                   tinyint NULL
   ,"SWIFTBIC"                       char(11) NULL
   ,"DirectlyEmployed"               tinyint NOT NULL DEFAULT 0
   ,"FlagDirectlyEmployed"           tinyint NULL DEFAULT 0
   ,"FlagPayDistribution"            tinyint NULL
   ,"PayDistribution"                char(4) NULL
   ,"HMRCEngagementDetail"           char(1) NULL
   ,"PayrollAddr1"                   char(40) NULL
   ,"PayrollAddr2"                   char(40) NULL
   ,"PayrollAddr3"                   char(40) NULL
   ,"PayrollAddr4"                   char(40) NULL
   ,"PayrollPostcode"                char(30) NULL
   ,"SupplierCode"                   char(12) NULL
   ,"FlagSupplierCode"               tinyint NULL DEFAULT 0
   ,"EmailAddress"                   char(250) NULL
   ,"FlagEmailAddress"               tinyint NULL DEFAULT 0
   ,"FlagHMRCEngagementDetail"       tinyint NULL
   ,"AnalysisCode"                   char(5) NULL
   ,PRIMARY KEY ("CompositeId" ASC) 
)
go


COMMENT ON COLUMN "pears"."Composite"."SupplierCode" IS 
	'Self bill account for umbrella etc.'
go


COMMENT ON COLUMN "pears"."Composite"."AnalysisCode" IS 
	'Can be sent to Accord.'
go


COMMENT ON TABLE "pears"."Composite" IS 
	'List of Composite Payroll Companies.'
go


create trigger "CompositeSelfBill" after insert,update order 1 on
"pears"."Composite"
referencing new as "NewCompo"
for each row when("isnull"("newcompo"."suppliercode",'') <> '')
begin
  if not exists(select * from "iqacaccount" where "ledgerid" = 'Purchase' and "accountcode" = "newcompo"."suppliercode") then
    insert into "iqacaccount"( "ledgerid","accountcode","name" ) values( 'Purchase',"newcompo"."suppliercode","newcompo"."templatename" ) ;
    insert into "iqacaccountsettings"( "ledgerid","accountcode","addr1","addr2","addr3","postcode","VATNumber","RegNo","email","banksortcode","bankacno" ) values
      ( 'Purchase',"newcompo"."suppliercode","newcompo"."payrolladdr1","newcompo"."payrolladdr2","newcompo"."payrolladdr3","newcompo"."payrollpostcode",
      "newcompo"."VATNumber","newcompo"."RegNo","newcompo"."emailaddress","newcompo"."banksortcode","newcompo"."bankacno" ) 
  end if
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."Composite"."CompositeSelfBill" IS 
{create trigger CompositeSelfBill 
 after insert,update order 1 on
"pears"."Composite"
referencing new as "NewCompo"
for each row when("isnull"("newcompo"."suppliercode",'') <> '')
begin
  if not exists(select * from "iqacaccount" where "ledgerid" = 'Purchase' and "accountcode" = "newcompo"."suppliercode") then
    insert into "iqacaccount"( "ledgerid","accountcode","name" ) values( 'Purchase',"newcompo"."suppliercode","newcompo"."templatename" ) ;
    insert into "iqacaccountsettings"( "ledgerid","accountcode","addr1","addr2","addr3","postcode","VATNumber","RegNo", email,banksortcode,bankacno ) values
      ( 'Purchase',"newcompo"."suppliercode","newcompo"."payrolladdr1","newcompo"."payrolladdr2","newcompo"."payrolladdr3","newcompo"."payrollpostcode",
      "newcompo"."VATNumber","newcompo"."RegNo","newcompo"."emailaddress","newcompo"."banksortcode","newcompo"."bankacno" ) 
  end if
end
}
go


create trigger "CompositeAudit" before update of "CompositeId",
"CompositePayCoReference","VATNumber","RegNo","CompanyName","BankRef","BankAcNo","BankAcName","BankSortCode","BankName",
"TemplateName","PayrollAddress","VATRegistered","TaxMethod","PayFrequency","FlagPayMethod","FlagPayrollAddress","FlagPayCoReference",
"FlagVATNumber","FlagVATRegistered","FlagRegNo","FlagCompanyName","FlagTaxMethod","FlagPayFrequency","FlagBankRef",
"FlagBankAcNo","FlagBankAcName","FlagBankSortCode","FlagBankName","PayMethod","FlagIBAN","IBAN","FlagSWIFTBIC",
"SWIFTBIC","DirectlyEmployed","FlagDirectlyEmployed","FlagPayDistribution","PayDistribution","HMRCEngagementDetail",
"PayrollAddr1","PayrollAddr2","PayrollAddr3","PayrollAddr4","PayrollPostcode","SupplierCode","FlagSupplierCode",
"EmailAddress","FlagEmailAddress","FlagHMRCEngagementDetail","AnalysisCode" order 1 on "pears"."Composite"
referencing old as "old_name" new as "new_name"
for each row /* WHEN( search_condition ) */
begin
  /* Type the trigger statements here */
  if update("CompositePayCoReference") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':CompositePayCoReference'),"old_name"."CompositePayCoReference","new_name"."CompositePayCoReference")
  end if;
  if update("VatNumber") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':VATNumber'),"old_name"."VATNumber","new_name"."VATNumber")
  end if;
  if update("RegNo") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':RegNo'),"old_name"."RegNo","new_name"."RegNo")
  end if;
  if update("CompanyName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':CompanyName'),"old_name"."CompanyName","new_name"."CompanyName")
  end if;
  if update("BankRef") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':BankRef'),"old_name"."BankRef","new_name"."BankRef")
  end if;
  if update("BankAcNo") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':BankAcNo'),"old_name"."BankAcNo","new_name"."BankAcNo")
  end if;
  if update("BankAcName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':BankAcName'),"old_name"."BankAcName","new_name"."BankAcName")
  end if;
  if update("BankSortCode") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':BankSortCode'),"old_name"."BankSortCode","new_name"."BankSortCode")
  end if;
  if update("BankName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':BankName'),"old_name"."BankName","new_name"."BankName")
  end if;
  if update("TemplateName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':TemplateName'),"old_name"."TemplateName","new_name"."TemplateName")
  end if;
  if update("PayRollAddress") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':PayRollAddress'),"old_name"."PayRollAddress","new_name"."PayRollAddress")
  end if;
  if update("VATRegistered") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':VATRegistered'),"old_name"."VATRegistered","new_name"."VATRegistered")
  end if;
  if update("TaxMethod") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':TaxMethod'),"old_name"."TaxMethod","new_name"."TaxMethod")
  end if;
  if update("PayFrequency") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':PayFrequency'),"old_name"."PayFrequency","new_name"."PayFrequency")
  end if;
  if update("PayMethod") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':PayMethod'),"old_name"."PayMethod","new_name"."PayMethod")
  end if;
  if update("IBAN") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':IBAN'),"old_name"."IBAN","new_name"."IBAN")
  end if;
  if update("SWIFTBIC") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':SWIFTBIC'),"old_name"."SWIFTBIC","new_name"."SWIFTBIC")
  end if;
  if update("DirectlyEmployed") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':DirectlyEmployed'),"old_name"."DirectlyEmployed","new_name"."DirectlyEmployed")
  end if;
  if update("PayDistribution") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':PayDistribution'),"old_name"."PayDistribution","new_name"."PayDistribution")
  end if;
  if update("HMRCEngagementDetail") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':HMRCEngagementDetail'),"old_name"."HMRCEngagementDetail","new_name"."HMRCEngagementDetail")
  end if;
  if update("SupplierCode") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':SupplierCode'),"old_name"."SupplierCode","new_name"."SupplierCode")
  end if;
  if update("EmailAddress") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':EmailAddress'),"old_name"."EmailAddress","new_name"."EmailAddress")
  end if;
  if update("AnalysisCode") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':AnalysisCode'),"old_name"."AnalysisCode","new_name"."AnalysisCode")
  end if;
  if update("FlagPayCoReference") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagPayCoReference'),"old_name"."FlagPayCoReference","new_name"."FlagPayCoReference")
  end if;
  if update("FlagVatNumber") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagVATNumber'),"old_name"."FlagVATNumber","new_name"."FlagVATNumber")
  end if;
  if update("FlagRegNo") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagRegNo'),"old_name"."FlagRegNo","new_name"."FlagRegNo")
  end if;
  if update("FlagCompanyName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagCompanyName'),"old_name"."FlagCompanyName","new_name"."FlagCompanyName")
  end if;
  if update("FlagBankRef") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagBankRef'),"old_name"."FlagBankRef","new_name"."FlagBankRef")
  end if;
  if update("FlagBankAcNo") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagBankAcNo'),"old_name"."FlagBankAcNo","new_name"."FlagBankAcNo")
  end if;
  if update("FlagBankAcName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagBankAcName'),"old_name"."FlagBankAcName","new_name"."FlagBankAcName")
  end if;
  if update("FlagBankSortCode") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagBankSortCode'),"old_name"."FlagBankSortCode","new_name"."FlagBankSortCode")
  end if;
  if update("FlagBankName") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagBankName'),"old_name"."FlagBankName","new_name"."FlagBankName")
  end if;
  if update("FlagPayRollAddress") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagPayRollAddress'),"old_name"."FlagPayRollAddress","new_name"."FlagPayRollAddress")
  end if;
  if update("FlagVATRegistered") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagVATRegistered'),"old_name"."FlagVATRegistered","new_name"."FlagVATRegistered")
  end if;
  if update("FlagTaxMethod") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagTaxMethod'),"old_name"."FlagTaxMethod","new_name"."FlagTaxMethod")
  end if;
  if update("FlagPayFrequency") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagPayFrequency'),"old_name"."FlagPayFrequency","new_name"."FlagPayFrequency")
  end if;
  if update("FlagPayMethod") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagPayMethod'),"old_name"."FlagPayMethod","new_name"."FlagPayMethod")
  end if;
  if update("FlagIBAN") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagIBAN'),"old_name"."FlagIBAN","new_name"."FlagIBAN")
  end if;
  if update("FlagSWIFTBIC") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagSWIFTBIC'),"old_name"."FlagSWIFTBIC","new_name"."FlagSWIFTBIC")
  end if;
  if update("FlagDirectlyEmployed") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagDirectlyEmployed'),"old_name"."FlagDirectlyEmployed","new_name"."FlagDirectlyEmployed")
  end if;
  if update("FlagPayDistribution") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':FlagPayDistribution'),"old_name"."FlagPayDistribution","new_name"."FlagPayDistribution")
  end if;
  if update("FlagHMRCEngagementDetail") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':HMRCEngagementDetail'),"old_name"."FlagHMRCEngagementDetail","new_name"."FlagHMRCEngagementDetail")
  end if;
  if update("FlagSupplierCode") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':SupplierCode'),"old_name"."FlagSupplierCode","new_name"."FlagSupplierCode")
  end if;
  if update("FlagEmailAddress") then
    call "AuditLog"('COMPOSITE',"old_name"."compositeid","string"('Template - ',"old_name"."templatename",':EmailAddress'),"old_name"."FlagEmailAddress","new_name"."FlagEmailAddress")
  end if
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."Composite"."CompositeAudit" IS 
{create trigger CompositeAudit 
before update of CompositeId,
CompositePayCoReference,VATNumber,RegNo,CompanyName,BankRef,BankAcNo,BankAcName,BankSortCode,BankName,
TemplateName,PayrollAddress,VATRegistered,TaxMethod,PayFrequency,FlagPayMethod,FlagPayrollAddress,FlagPayCoReference,
FlagVATNumber,FlagVATRegistered,FlagRegNo,FlagCompanyName,FlagTaxMethod,FlagPayFrequency,FlagBankRef,
FlagBankAcNo,FlagBankAcName,FlagBankSortCode,FlagBankName,PayMethod,FlagIBAN,IBAN,FlagSWIFTBIC,
SWIFTBIC,DirectlyEmployed,FlagDirectlyEmployed,FlagPayDistribution,PayDistribution,HMRCEngagementDetail,
PayrollAddr1,PayrollAddr2,PayrollAddr3,PayrollAddr4,PayrollPostcode,SupplierCode,FlagSupplierCode,
EmailAddress,FlagEmailAddress,FlagHMRCEngagementDetail,AnalysisCode order 1 on pears.Composite
referencing old as old_name new as new_name
for each row /* WHEN( search_condition ) */
begin
/* Type the trigger statements here */
  if update(CompositePayCoReference) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':CompositePayCoReference'),old_name.CompositePayCoReference,new_name.CompositePayCoReference)
  end if;
  if update(VatNumber) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':VATNumber'),old_name.VATNumber,new_name.VATNumber)
  end if;
  if update(RegNo) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':RegNo'),old_name.RegNo,new_name.RegNo)
  end if;
  if update(CompanyName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':CompanyName'),old_name.CompanyName,new_name.CompanyName)
  end if;
  if update(BankRef) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':BankRef'),old_name.BankRef,new_name.BankRef)
  end if;
  if update(BankAcNo) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':BankAcNo'),old_name.BankAcNo,new_name.BankAcNo)
  end if;
  if update(BankAcName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':BankAcName'),old_name.BankAcName,new_name.BankAcName)
  end if;
  if update(BankSortCode) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':BankSortCode'),old_name.BankSortCode,new_name.BankSortCode)
  end if;
  if update(BankName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':BankName'),old_name.BankName,new_name.BankName)
  end if;
  if update(TemplateName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':TemplateName'),old_name.TemplateName,new_name.TemplateName)
  end if;
  if update(PayRollAddress) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':PayRollAddress'),old_name.PayRollAddress,new_name.PayRollAddress)
  end if;
  if update(VATRegistered) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':VATRegistered'),old_name.VATRegistered,new_name.VATRegistered)
  end if;
  if update(TaxMethod) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':TaxMethod'),old_name.TaxMethod,new_name.TaxMethod)
  end if;
  if update(PayFrequency) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':PayFrequency'),old_name.PayFrequency,new_name.PayFrequency)
  end if;
  if update(PayMethod) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':PayMethod'),old_name.PayMethod,new_name.PayMethod)
  end if;
  if update(IBAN) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':IBAN'),old_name.IBAN,new_name.IBAN)
  end if;
  if update(SWIFTBIC) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':SWIFTBIC'),old_name.SWIFTBIC,new_name.SWIFTBIC)
  end if;
  if update(DirectlyEmployed) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':DirectlyEmployed'),old_name.DirectlyEmployed,new_name.DirectlyEmployed)
  end if;
  if update(PayDistribution) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':PayDistribution'),old_name.PayDistribution,new_name.PayDistribution)
  end if;
  if update(HMRCEngagementDetail) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':HMRCEngagementDetail'),old_name.HMRCEngagementDetail,new_name.HMRCEngagementDetail)
  end if;
  if update(SupplierCode) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':SupplierCode'),old_name.SupplierCode,new_name.SupplierCode)
  end if;
  if update(EmailAddress) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':EmailAddress'),old_name.EmailAddress,new_name.EmailAddress)
  end if;
  if update(AnalysisCode) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':AnalysisCode'),old_name.AnalysisCode,new_name.AnalysisCode)
  end if;
  if update(FlagPayCoReference) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagPayCoReference'),old_name.FlagPayCoReference,new_name.FlagPayCoReference)
  end if;
  if update(FlagVatNumber) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagVATNumber'),old_name.FlagVATNumber,new_name.FlagVATNumber)
  end if;
  if update(FlagRegNo) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagRegNo'),old_name.FlagRegNo,new_name.FlagRegNo)
  end if;
  if update(FlagCompanyName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagCompanyName'),old_name.FlagCompanyName,new_name.FlagCompanyName)
  end if;
  if update(FlagBankRef) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagBankRef'),old_name.FlagBankRef,new_name.FlagBankRef)
  end if;
  if update(FlagBankAcNo) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagBankAcNo'),old_name.FlagBankAcNo,new_name.FlagBankAcNo)
  end if;
  if update(FlagBankAcName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagBankAcName'),old_name.FlagBankAcName,new_name.FlagBankAcName)
  end if;
  if update(FlagBankSortCode) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagBankSortCode'),old_name.FlagBankSortCode,new_name.FlagBankSortCode)
  end if;
  if update(FlagBankName) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagBankName'),old_name.FlagBankName,new_name.FlagBankName)
  end if;
  if update(FlagPayRollAddress) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagPayRollAddress'),old_name.FlagPayRollAddress,new_name.FlagPayRollAddress)
  end if;
  if update(FlagVATRegistered) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagVATRegistered'),old_name.FlagVATRegistered,new_name.FlagVATRegistered)
  end if;
  if update(FlagTaxMethod) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagTaxMethod'),old_name.FlagTaxMethod,new_name.FlagTaxMethod)
  end if;
  if update(FlagPayFrequency) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagPayFrequency'),old_name.FlagPayFrequency,new_name.FlagPayFrequency)
  end if;
  if update(FlagPayMethod) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagPayMethod'),old_name.FlagPayMethod,new_name.FlagPayMethod)
  end if;
  if update(FlagIBAN) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagIBAN'),old_name.FlagIBAN,new_name.FlagIBAN)
  end if;
  if update(FlagSWIFTBIC) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagSWIFTBIC'),old_name.FlagSWIFTBIC,new_name.FlagSWIFTBIC)
  end if;
  if update(FlagDirectlyEmployed) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagDirectlyEmployed'),old_name.FlagDirectlyEmployed,new_name.FlagDirectlyEmployed)
  end if;
  if update(FlagPayDistribution) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':FlagPayDistribution'),old_name.FlagPayDistribution,new_name.FlagPayDistribution)
  end if;
  if update(FlagHMRCEngagementDetail) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':HMRCEngagementDetail'),old_name.FlagHMRCEngagementDetail,new_name.FlagHMRCEngagementDetail)
  end if;
  if update(FlagSupplierCode) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':SupplierCode'),old_name.FlagSupplierCode,new_name.FlagSupplierCode)
  end if;
  if update(FlagEmailAddress) then
    call AuditLog('COMPOSITE',old_name.compositeid,string('Template - ',old_name.templatename,':EmailAddress'),old_name.FlagEmailAddress,new_name.FlagEmailAddress)
  end if
end
}
go
</code>