pears.CompositeTmp

Temp Table - used by interface when working with Composite Payroll Companies.

• CompositeId

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CompositeTmp"
-- Table comment: Temp Table - used by interface when working with Composite Payroll Companies.
-- Statement count: 3
 
CREATE GLOBAL TEMPORARY TABLE "pears"."CompositeTmp" (
    "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 NULL
   ,"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
   ,PRIMARY KEY ("CompositeId" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON COLUMN "pears"."CompositeTmp"."SupplierCode" IS 
	'Self bill account for umbrella etc.'
GO
 
 
COMMENT ON TABLE "pears"."CompositeTmp" IS 
	'Temp Table - used by interface when working with Composite Payroll Companies.'
GO