Updated language

begin transaction
SELECT * FROM LANGUAGE
--Insert a new language and make sure that the code is an actual ISO-language code.
INSERT INTO LANGUAGE VALUES ('en-AU','English - Australian','dd/MM/yyyy','/','HH:mm:ss',',','.')
--Check that it exists!
SELECT * FROM LANGUAGE
--Make sure that there are no language there before.
SELECT * FROM languagetext WHERE LanguageID = 'en-AU'

--Use the 'en-US' as a template for creating the 'en-AU' language.
INSERT INTO LanguageText (LanguageID,TextIndex, Text)
SELECT 'en-AU',TextIndex, TEXT FROM LanguageText WHERE LanguageID = 'en-US'
--commit only if everything seems to work!
rollback


USE [GWAUAT]
GO
/****** Object:  StoredProcedure [dbo].[Adaption_UpdateSupplierWithCommodity]    Script Date: 06/10/2011 10:25:02 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

/*------------------------------------------------------------------------------------------------------------------------
    SP:     Adaption_UpdateSupplierWithCommodity
    Desc:   Updates suppliers to make sure that they all are available for purchase
            and make sure that they have all at least one commodity
------------------------------------------------------------------------------------------------------------------------
drop procedure Adaption_UpdateSupplierWithCommodity
exec DatabasePermission_Apply 'Adaption_UpdateSupplierWithCommodity'
grant execute on Adaption_UpdateSupplierWithCommodity to baltzar0
select * from _Supplier where AvailableForPurchase <> 1
select * from _Supplier where SupplierID not in
        (select DISTINCT SupplierID from CommoditySupplier)

execute Adaption_UpdateSupplierWithCommodity @Company = 'A05', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'C01', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'C15', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'C60', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'C62', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'C64', @CommodityName='General'
execute Adaption_UpdateSupplierWithCommodity @Company = 'H01', @CommodityName='General'
Select * from _Commodity where Commodity = 'General'
*/


ALTER procedure [dbo].[Adaption_UpdateSupplierWithCommodity]
(
@Company varchar(30),
@CommodityName varchar(30) = NULL
)
--with encryption
AS

declare @CommodityID int
SELECT @CommodityID = CommodityID  FROM _Commodity WHERE Commodity = @CommodityName AND Company =@Company

IF LEN(@CommodityID) > 0
    begin
        INSERT INTO CommoditySupplier (CommodityID,SupplierID)
        SELECT @CommodityID , Supplierid FROM _Supplier WHERE SupplierID NOT IN
        (SELECT DISTINCT SupplierID FROM CommoditySupplier) AND company = @Company
    end
UPDATE _Supplier SET AvailableForPurchase = 1
WHERE AvailableForPurchase <> 1 OR AvailableForPurchase IS NULL

Marias kod

INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','1714','Loo Ping TEO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','1715','Bryan Wong Chee Meng','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','1715','Bryan Wong Chee Meng','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','1800','CLS - Senior RM (WK)','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','1900','CLS - Singapore','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2000','International Desk','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2100','Human Resources','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2101','HR Singapore','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2102','HR CLAMHK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2103','Kandy Bong shu Hua','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2200','Project Wealth','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2300','Overhead CL','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2400','Marketing','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2410','Marketing Asia','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2420','Marketing Central Budget (CLZ)','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2500','Portfolio Management Research','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2600','Investment Advisory','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2601','Tan Wan Ling','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2650','FX Advisory','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2700','Business Dev & New Business','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2800','Financial Institutions','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','2900','Booking Center Asia','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3000','Wealth Management Solutions','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3800','CLAMHK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3801','Christopher Burgess','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3802','Chun Cheung Chan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3803','Gillian Yin Ho','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3804','Kimitoshi Hoshiyama','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3805','Tak Tin Leung','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3806','Thomas Reber','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3807','Yuen Mei Tam','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3808','Shuk Ling Wong','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3809','Lora Man Fung YU','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3810','Blechstein Annett','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3811','Hwang Ida','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3812','Lee Hui Min Sally','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3813','Ying Winnie Wing Shui','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3814','Yu Pui Wah','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3815','Lo Yuen Fong Virginia','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3816','Hoo Yong Andrew','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3817','Kylie Shuk Yin Chan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3818','Terence Kwan Lok Lin','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3819','Elaine Hon','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3820','Alan Chan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3821','Henry Chi Hou LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3822','Hoi Cheung Tong','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3823','Poon Tsze Kay','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3824','Christy Chau Ming Cheung','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3825','Matthew Yan Lam Man','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3830','Cheung Ah Lai Peggy','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3831','May Sui Ling, CHOW','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3832','Desmond HO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3833','Amy Hing HUNG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3834','Ivy Wing Yee LI','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3835','Samson Shun Hing LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3836','Philip Penaloza','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3837','Ramy Lai IP','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3838','Manuela LEUENBERGER','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3839','Andrew Bok Man CHAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3840','James Jianguo WANG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3841','Gimmy Wing Yee TAM','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3842','Dinah Yee Man LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3843','Dorothy Lai Fong YUEN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3844','Paul Shek Wing LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3845','Dun Chiu Yin SHE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3846','Hsueh-Mei HO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3847','Kenneth Ken Kwok TOONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3848','Edward Fai Yue WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3849','Kit Yee TSO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3850','Kiu WAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3851','Raymond Kai Shing CHUNG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3852','Ursula Yee Har TSUI','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3853','Alice Yim Ling LI','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3854','Robert Yi Ming KUNG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3855','Lai Ying CHAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3856','David Kwun Yin LOUIE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3878','Calvin Chak Lam TSE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3879','Rebecca Tak Hing YOUNG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3880','Wai Chiu NG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3881','Derek Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3882','IRENE SO WAI YIN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3883','MATTHEW MAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3890','CLAMHK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3900','CL Singapore Branch','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3902','Nenni Angela','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3903','Jacqueline Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3904','Raveen Bharvani','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3904','Raveen Bharvani','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3905','Michael Bonnet','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3905','Michael Bonnet','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3906','Chua Kuek Heng Mui','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3907','Aaron Chwee','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3908','Michael Foo','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3910','Patricia Kim Goh','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3910','Patricia Kim Goh','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3911','Jennie Hananto','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3912','Selina Kia Wei SEAH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3913','Winston J.M. K','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3913','Winston J.M. K','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3915','Sherry Lim','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3916','Jimmy Kong Eng LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3916','Jimmy Kong Eng LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3917','Linda Mei Ling TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3917','Linda Mei Ling TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3918','Karen Su Yin TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3918','Karen Su Yin TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3919','Selena Teng','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3921','Cheng Hin Saw','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3922','Simone BOBBIA','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3922','Simone BOBBIA','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3923','Chin Lit YEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3923','Chin Lit YEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3925','Lily Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3925','Lily Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3926','Soon Gek CHEW','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3926','Soon Gek CHEW','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3927','Hazel Mooi Quan TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3928','Claudia Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3928','Claudia Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3928','Claudia Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3929','Sandra THESEIRA','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3929','Sandra THESEIRA','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3930','Angela Choi Peng WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3931','Patric JEUCH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3931','Patric JEUCH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3932','Edwin Chin Yeow TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3932','Edwin Chin Yeow TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3933','Lily Tan-chg dept to XEGR (6201)','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3933','Lily Tan-chg dept to XEGR (6201)','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3934','Dianto Wiranata','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3935','Renton Yap','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3935','Renton Yap','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3937','Erliena Yulianawati','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3937','Erliena Yulianawati','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3938','Andrea CARL','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3938','Andrea CARL','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3939','Lynn Palma','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3939','Lynn Palma','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3940','Chow Yuan WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3940','Chow Yuan WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3941','Roman LAUFFENBURGER','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3942','Cheryl Chan-chg XEGR 6204','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3944','Lincoln Teng WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3944','Lincoln Teng WONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3946','Huang Kaiwen Maureen','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3947','Sandra Ann Drysdale','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3949','Lee Hoon','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3950','Margaret Seah','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3951','Jessica Fong','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3952','Carl Anthony Athayde','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3953','I-Ning CHEONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3953','I-Ning CHEONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3954','Iriana Binte IQBAL','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3955','Sharon CHIANG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3956','Li Cheng LOH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3956','Li Cheng LOH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3957','Jin Yang LEE','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3958','Angelia SEOW-chg to XEGR 6202','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3959','Hatasia Emlyn SAHLAN-chg XEGR 6203','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3960','Hong Chwee TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3961','Fitriyani FONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3962','Bernadette Poh Leen CHAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3963','David Jo Hock CHEN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3964','Audrey KOONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3965','Wee Theng ANG-left 25/6/10','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3966','Terence Hock Lin SEAH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3967','Regina KOH-left 20100625','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3968','Betty NG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3969','Loraine Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3970','Ramani Sundar','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3970','Ramani Sundar','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3971','Eileen Ai Ling TONG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3972','Permana ANG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3973','Lina Lee Yen Wong-chg XEGR 6205','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3974','Clara Shing Yi NG-left 30/6/10','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3975','Daniel Odermatt','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3975','Daniel Odermatt','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3976','Joy Yu-Ting HUANG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3976','Joy Yu-Ting HUANG','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3977','Dorinda Handayani NURJONO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3978','Markus KOCH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3978','Markus KOCH','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3979','Catherine Hui Hui HO','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3980','Markus BUCK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3980','Markus BUCK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3980','Markus BUCK','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3981','Diane Sio Hung TAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3982','Marc FISCHER','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3983','Rossinsky Nikita','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3983','Rossinsky Nikita','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3984','Stacey Ann Phillips','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3984','Stacey Ann Phillips','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3985','Shamah Mohsin Abdat','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3985','Shamah Mohsin Abdat','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3986','Alex Khuen Kam Lai','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3986','Alex Khuen Kam Lai','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3987','Lee Jin Yang-left 24/8/10','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3988','Esther Goh Kui Kheng','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3989','Winnie Low Mei Jun','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3990','Andreas Wing Yew Looi','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3990','Andreas Wing Yew Looi','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3991','Peter Paul Buehler','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3991','Peter Paul Buehler','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3992','Linda Pek Siao Wei','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3992','Linda Pek Siao Wei','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3993','Kaspar Zhou Yi''An-Left 13/8/10','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3994','Jeremy Chua','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3995','Charles Yeoh','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3996','Evelyn Ng','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','3997','AMANDA ZHANG WEIJIA','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','6201','Lily Tan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','6202','Angelia SEOW','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','6203','Hatasia Emlyn SAHLAN','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','6204','Cheryl Chan','2011-01-01')
INSERT INTO OBJECTQUEUE (ObjectTypeNo, Object, Name, validFrom) VALUES('1','6205','Lina Lee Yen Wong','2011-01-01')

INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60010','Basic Salary Permanent Staff')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60012','Jobs Credit')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60014','Sign-on Bonus')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60015','Deferred Compensation Awards')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60016','Business Plan Premium')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60017','Business Plan Premium Accrual')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60020','Fixed Bonus')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60023','Variable Bonus')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60025','Additional hiring costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60031','Variable Bonus - Adj to PY')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60100','SDF Contributions')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60110','Salaries to Temp Staff Agencies')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60111','Salaries to Contract Staff Agencies')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60120','Allowances (MU)')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60125','prov for leave pay CBS')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60300','Personnel Recruitment Costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60305','Pre-employment Screening')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60320','Relocation Expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60400','Social Security - CPF (Local)')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60420','Social Security - CPF on Bonus')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60600','Severance Pay')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60605','Long Service Award')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60700','Staff Benefit - Miscellaneous')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60703','Fitness Club Subscrip and Classes')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60710','Gifts to Staff')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60711','Staff Accommodation - Stamp Duty')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60714','Staff accommodation - house rental')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60720','Staff Catering')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60721','Meal Allowances')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60730','Staff Events')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60800','Medical Expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60805','Dental expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60806','Optical expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('60900','Staff Training')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('61010','Office Rental')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('61011','Property Tax')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('61027','Various space rentals')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('61105','Office Protection Services')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62102','Printed Forms')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62108','Data Processing Supplies')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62130','REPAIRS & MAINT. - BANK PREMISES')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62135','Other Premises Costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62140','ELECTRICITY EXPENSES')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62150','REP. & MAINT. HEATING, AIRCON ETC')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62160','CLEANING EXPENSES')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62170','Other Contract With Third Parties')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62190','DISASTER RECOVERY PLAN EXPENSES IC')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62201','Infrastructure - CS Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62220','Inv. - IT Equipment')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62230','Inv. - Office Equipment')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62240','Inv. - Communication')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62250','Inv. - Office Furn & Fixture')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62280','Rent - Phone Equipment')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62300','Rent - Copy + Office machines')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62310','Repair & Maint HW & Infrastructure')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62311','Maintenance Applications')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62320','Repairs & Maint. - Communication')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62330','Repairs & Maint. - M/c, F/r')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62340','Repairs & Maint. - Vehicles')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62430','Loose Stationery')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62441','Copier Charges')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62450','Newspapers & Magazines')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62459','Local Transport-Pte Car Exps')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62460','Loc Transport excl Car Park&Coupon')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62461','Transport Allowances')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62470','Ext Courier Services')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62480','Postages')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62490','Mobile Phone Charges')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62500','Phone and Fax')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62501','Installation of New Tel and Ext')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62510','Internal Entertainment - CL')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62520','Data Lines')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62540','External Entertainment - Clients')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62541','Travel - Land Transport')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62545','Travel - Hotel Accommodation')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62550','Travel - Air Transport')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62551','Travel - Miscellaneous')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62552','Car Rental Exps Outside Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62554','Car Rental/Limousine Svcs in Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62555','Gifts to Clients')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62560','Advertising')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62570','PR Communication')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62571','Marketing - MMF')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62572','Events - Clients')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62574','Events - Banks')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62620','Donations-Approved Institutions')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62621','Donations - Others')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62631','Seminar n Conference')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62640','Business Club Subscription')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62641','Business Club Entrance/Transfer Fee')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62645','Processing corporate card')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62648','Association expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62650','Professional Membership Subscription')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62652','AMEX Corporate Card Expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62670','Insurance - Vehicles')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62680','Insurance - GPA & Public Liability')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62685','Oth insurances')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62690','External Audit Fees')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62691','Tax Fees')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62700','Legal Fees')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62701','Consulting Costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62702','Secretarial & Filing Fees')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62703','Search fees CBS')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62704','Professional Fees - Clients')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62706','Ops & other biz svcs-CS Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62720','Bank License Fees')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62730','Information Services')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62741','Ext IT Consultancy')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62745','SW Licenses & Maint - CS Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62746','IT Services - CS Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62747','IT APAC Proj Cost-CS Sp')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62750','Other general exp')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62751','Fines and Penalties')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62752','Trf Px-CS Pte Bkg Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62753','HO SLA - Controlling/IT Ops Support')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62760','Office Lease - Stamp Duty')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62761','Stamp duty New Tenancy Agreement')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62762','Stamp Duty Renew Tenancy Agreement')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62800','Deprn & Prov - Capitalised Software')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62810','Deprn & Prov- Leasehold Improvement')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62820','Deprn & Prov - IT Equipment')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62821','Deprn & Prov -Office Eqmt&Furniture')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('62822','Deprn & Prov -Communications Eqmt')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('63020','Irrecoverable GST')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('63022','Output tax not reclaimable CBS')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('64002','prov for admin liabs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('64006','Restruct costs CL Leu')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('64007','Restruct Costs CL Leu-CS Spore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('64008','Audit Fees CS Singapore')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('64875','Specific Loan Provision')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('CHF120010030','Prepaid IT costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('GBP120010030','Prepaid IT costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('NZD120010030','Prepaid IT costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('SGD120010030','Prepaid IT costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD120010030','Prepaid IT costs')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('SGD120020030','Prepaid Other General Expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD120020030','Prepaid Other General Expenses')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD108110030','Leasehold Improvement')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD108310030','Office Furnishings/Machines')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD108510030','IT PC equipment - HW')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD108710030','IT communication system')
INSERT INTO ACCOUNTQUEUE (Account, Name) VALUES ('USD105300030','Cap Software-Completed/in use')

Valid XHTML :: Valid CSS: :: Powered by WikkaWiki