-- -- PostgreSQL database dump -- -- Started on 2008-07-01 13:28:44 BST SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 2879 (class 1259 OID 39657) -- Dependencies: 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 5 -- Name: c_currency; Type: TABLE; Schema: public; Owner: tad; Tablespace: -- CREATE TABLE c_currency ( c_currency_id numeric(10,0) NOT NULL, ad_client_id numeric(10,0) NOT NULL, ad_org_id numeric(10,0) NOT NULL, isactive character(1) DEFAULT 'Y'::bpchar NOT NULL, created timestamp without time zone DEFAULT now() NOT NULL, createdby numeric(10,0) NOT NULL, updated timestamp without time zone DEFAULT now() NOT NULL, updatedby numeric(10,0) NOT NULL, iso_code character(3) NOT NULL, cursymbol character varying(10), description character varying(255) NOT NULL, stdprecision numeric(10,0) NOT NULL, costingprecision numeric(10,0) NOT NULL, iseuro character(1) DEFAULT 'N'::bpchar, isemumember character(1) DEFAULT 'N'::bpchar, emuentrydate timestamp without time zone, emurate numeric DEFAULT 0, priceprecision numeric(10,0) DEFAULT 0 NOT NULL, CONSTRAINT c_curr_isemumember_check CHECK ((isemumember = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))), CONSTRAINT c_currency_isactive_check CHECK ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))), CONSTRAINT c_currency_iseuro_check CHECK ((iseuro = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) ); ALTER TABLE public.c_currency OWNER TO tad; -- -- TOC entry 3690 (class 0 OID 39657) -- Dependencies: 2879 -- Data for Name: c_currency; Type: TABLE DATA; Schema: public; Owner: tad -- COPY c_currency (c_currency_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, iso_code, cursymbol, description, stdprecision, costingprecision, iseuro, isemumember, emuentrydate, emurate, priceprecision) FROM stdin; 102 0 0 Y 1999-12-05 23:03:52 0 2004-02-18 17:35:01 100 EUR E Euro 2 4 Y N \N 0 3 105 0 0 N 1999-12-09 13:43:31 0 2002-07-27 23:28:18 0 BEF BFr Belgian Franc 0 0 N Y 1999-01-01 00:00:00 40.3399 0 108 0 0 N 1999-12-09 13:48:04 0 2002-07-27 23:29:06 0 ITL L Italian Lira 0 0 N Y 1999-01-01 00:00:00 1936.27 0 110 0 0 N 1999-12-09 13:50:01 0 2002-07-27 23:29:24 0 PTE Es Portugese Escudo 0 0 N Y 1999-01-01 00:00:00 200.482 0 111 0 0 N 1999-12-09 13:54:14 0 2002-07-27 23:28:37 0 ESP Pts Spannish Peseto 0 0 N Y 1999-01-01 00:00:00 166.386 0 113 0 0 Y 1999-12-09 14:04:07 0 1999-12-09 14:04:07 0 JPY ¥ Japanese Yen 0 0 N N \N 0 0 159 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 TPE \N Timor Escudo 0 2 N N \N \N 0 203 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 BYR BR Belarussian Ruble 0 2 N N \N \N 0 211 0 0 Y 2003-08-06 17:05:33 0 2003-08-06 17:05:33 0 KMF CF Comoro Franc 0 2 N N \N \N 0 212 0 0 Y 2003-08-06 17:05:33 0 2003-08-06 17:05:33 0 XOF CFAF CFA Franc BCEAO 0 2 N N \N \N 0 214 0 0 Y 2003-08-06 17:05:33 0 2003-08-06 17:05:33 0 XAF CFAF CFA Franc BEAC 0 2 N N \N \N 0 225 0 0 Y 2003-08-06 17:05:35 0 2003-08-06 17:05:35 0 XPF CFPF CFP Franc 0 2 N N \N \N 0 228 0 0 Y 2003-08-06 17:05:35 0 2003-08-06 17:05:35 0 CLP Ch$ Chilean Peso 0 2 N N \N \N 0 237 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 DJF DF Djibouti Franc 0 2 N N \N \N 0 253 0 0 Y 2003-08-06 17:05:38 0 2003-08-06 17:05:38 0 BIF FBu Burundi Franc 0 2 N N \N \N 0 254 0 0 Y 2003-08-06 17:05:38 0 2003-08-06 17:05:38 0 MGF FMG Malagasy Franc 0 2 N N \N \N 0 323 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 TRL TL Turkish Lira 0 2 N N \N \N 0 329 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 VUV VT Vatu 0 2 N N \N \N 0 330 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 KRW W Won 0 2 N N \N \N 0 337 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 GNF \N Guinea Franc 0 2 N N \N \N 0 344 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 PYG \N Guarani 0 2 N N \N \N 0 114 0 0 Y 1999-12-09 14:05:37 0 2008-07-01 12:55:48.27601 100 GBP £ British Pound 2 4 N N \N 0 2 100 0 0 Y 1999-12-05 23:02:28 0 1999-12-05 23:02:28 0 USD $ US Dollar 2 4 N N \N 0 2 103 0 0 N 1999-12-05 23:05:55 0 2002-07-27 23:28:25 0 DEM DM Deutsche Mark 2 4 N Y 1999-01-01 00:00:00 1.95583 2 104 0 0 N 1999-12-09 13:40:51 0 2002-07-27 23:28:13 0 ATS Sch Austrian Schilling 2 4 N Y 1999-01-01 00:00:00 13.7603 2 106 0 0 N 1999-12-09 13:44:29 0 2002-07-27 23:28:46 0 FIM FM Finish Mark 2 4 N Y 1999-01-01 00:00:00 5.94573 2 107 0 0 N 1999-12-09 13:46:22 0 2002-07-27 23:29:01 0 IEP I£ Irish Pound 2 4 N Y 1999-01-01 00:00:00 0.787564 2 109 0 0 N 1999-12-09 13:49:03 0 2002-07-27 23:29:15 0 NLF Fl Dutch Gilder 2 4 N Y 1999-01-01 00:00:00 2.20371 2 112 0 0 N 1999-12-09 14:01:19 0 2002-07-27 23:28:50 0 FRF Fr French Franc 2 4 N Y 1999-01-01 00:00:00 6.55957 2 115 0 0 Y 1999-12-09 14:06:05 0 1999-12-09 14:06:05 0 SFR SFr Swiss Franc 2 4 N N \N 0 2 116 0 0 Y 2001-05-09 22:27:35 100 2003-03-10 14:08:49 0 CAD C$ Canadian Dollar 2 4 N N \N 0 2 118 0 0 Y 2003-08-06 17:05:21 0 2003-08-06 17:05:21 0 ARS $ Argentine Peso 2 4 N N \N \N 2 120 0 0 Y 2003-08-06 17:05:21 0 2003-08-06 17:05:21 0 AUD $ Australian Dollar 2 4 N N \N \N 2 121 0 0 Y 2003-08-06 17:05:21 0 2003-08-06 17:05:21 0 NZD $ New Zealand Dollar 2 4 N N \N \N 2 127 0 0 Y 2003-08-06 17:05:22 0 2003-08-06 17:05:22 0 LRD $ Liberian Dollar 2 4 N N \N \N 2 130 0 0 Y 2003-08-06 17:05:22 0 2003-08-06 17:05:22 0 MXN $ Mexican Peso 2 4 N N \N \N 2 142 0 0 Y 2003-08-06 17:05:24 0 2003-08-06 17:05:24 0 UYU $U Peso Uruguayo 2 4 N N \N \N 2 143 0 0 Y 2003-08-06 17:05:24 0 2003-08-06 17:05:24 0 AMD \N Armenian Dram 2 4 N N \N \N 2 144 0 0 Y 2003-08-06 17:05:24 0 2003-08-06 17:05:24 0 AOA \N Kwanza 2 4 N N \N \N 2 145 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 AZM \N Azerbaijanian Manat 2 4 N N \N \N 2 146 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 BOB \N Boliviano 2 4 N N \N \N 2 147 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 CDF \N Franc Congolais 2 4 N N \N \N 2 148 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 CZK \N Czech Koruna 2 4 N N \N \N 2 149 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 GEL \N Lari 2 4 N N \N \N 2 150 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 IRR \N Iranian Rial 2 4 N N \N \N 2 151 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 LTL \N Lithuanian Litus 2 4 N N \N \N 2 152 0 0 Y 2003-08-06 17:05:25 0 2003-08-06 17:05:25 0 MDL \N Moldovan Leu 2 4 N N \N \N 2 153 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 PHP \N Philippine Peso 2 4 N N \N \N 2 154 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 PLN \N Zloty 2 4 N N \N \N 2 155 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 RUR \N Russian Ruble 2 4 N N \N \N 2 156 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 SDD \N Sudanese Dinar 2 4 N N \N \N 2 157 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 TJS \N Somoni 2 4 N N \N \N 2 158 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 TMM \N Manat 2 4 N N \N \N 2 160 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 UAH \N Hryvnia 2 4 N N \N \N 2 161 0 0 Y 2003-08-06 17:05:26 0 2003-08-06 17:05:26 0 UZS \N Uzbekistan Sum 2 4 N N \N \N 2 163 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 CYP £C Cyprus Pound 2 4 N N \N \N 2 164 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 EGP £E Egyptian Pound 2 4 N N \N \N 2 165 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 FKP £F Falkland Islands Pound 2 4 N N \N \N 2 166 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 GIP £G Gibraltar Pound 2 4 N N \N \N 2 167 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 SHP £S Saint Helena Pound 2 4 N N \N \N 2 168 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 SYP £S Syrian Pound 2 4 N N \N \N 2 170 0 0 Y 2003-08-06 17:05:27 0 2003-08-06 17:05:27 0 GHC ¢ Cedi 2 4 N N \N \N 2 171 0 0 Y 2003-08-06 17:05:28 0 2003-08-06 17:05:28 0 SVC ¢ El Salvador Colon 2 4 N N \N \N 2 195 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 AFA Af Afghani 2 4 N N \N \N 2 196 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 AWG Af. Aruban Guilder 2 4 N N \N \N 2 197 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 PAB B Balboa 2 4 N N \N \N 2 198 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 BND B$ Brunei Dollar 2 4 N N \N \N 2 199 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 BSD B$ Bahamian Dollar 2 4 N N \N \N 2 200 0 0 Y 2003-08-06 17:05:31 0 2003-08-06 17:05:31 0 BHD BD Bahraini Dinar 3 5 N N \N \N 3 201 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 BMD Bd$ Bermudian Dollar 2 4 N N \N \N 2 202 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 BBD Bds$ Barbados Dollar 2 4 N N \N \N 2 204 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 ETB Br Ethiopian Birr 2 4 N N \N \N 2 205 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 VEB Bs Bolivar 2 4 N N \N \N 2 206 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 THB Bt Baht 2 4 N N \N \N 2 207 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 BZD BZ$ Belize Dollar 2 4 N N \N \N 2 209 0 0 Y 2003-08-06 17:05:32 0 2003-08-06 17:05:32 0 NIO C$ Cordoba Oro 2 4 N N \N \N 2 210 0 0 Y 2003-08-06 17:05:33 0 2003-08-06 17:05:33 0 CVE C.V.Esc. Cape Verde Escudo 2 4 N N \N \N 2 229 0 0 Y 2003-08-06 17:05:35 0 2003-08-06 17:05:35 0 KYD CI$ Cayman Islands Dollar 2 4 N N \N \N 2 230 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 COP Col$ Colombian Peso 2 4 N N \N \N 2 231 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 KHR CR Riel 2 4 N N \N \N 2 232 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 CUP Cu$ Cuban Peso 2 4 N N \N \N 2 233 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 GMD D Dalasi 2 4 N N \N \N 2 234 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 VND D Dong 2 4 N N \N \N 2 235 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 DZD DA Algerian Dinar 2 4 N N \N \N 2 236 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 STD Db Dobra 2 4 N N \N \N 2 238 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 AED Dh UAE Dirham 2 4 N N \N \N 2 239 0 0 Y 2003-08-06 17:05:36 0 2003-08-06 17:05:36 0 MAD DH Moroccan Dirham 2 4 N N \N \N 2 240 0 0 Y 2003-08-06 17:05:37 0 2003-08-06 17:05:37 0 YUM Din Yugoslavian Dinar 2 4 N N \N \N 2 241 0 0 Y 2003-08-06 17:05:37 0 2003-08-06 17:05:37 0 DKK Dkr Danish Krone 2 4 N N \N \N 2 244 0 0 Y 2003-08-06 17:05:37 0 2003-08-06 17:05:37 0 XCD EC$ East Caribbean Dollar 2 4 N N \N \N 2 252 0 0 Y 2003-08-06 17:05:38 0 2003-08-06 17:05:38 0 FJD F$ Fiji Dollar 2 4 N N \N \N 2 255 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 HUF Ft Forint 2 4 N N \N \N 2 256 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 HTG G Gourde 2 4 N N \N \N 2 257 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 GYD G$ Guyana Dollar 2 4 N N \N \N 2 258 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 HKD HK$ Hong Kong Dollar 2 4 N N \N \N 2 259 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 HRK HRK Croatian Kuna 2 4 N N \N \N 2 260 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 IQD ID Iraqi Dinar 3 5 N N \N \N 3 261 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 ISK IKr Iceland Krona 2 4 N N \N \N 2 262 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 JMD J$ Jamaican Dollar 2 4 N N \N \N 2 263 0 0 Y 2003-08-06 17:05:39 0 2003-08-06 17:05:39 0 JOD JD Jordanian Dinar 3 5 N N \N \N 3 264 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 MMK K Kyat 2 4 N N \N \N 2 265 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 PGK K Kina 2 4 N N \N \N 2 266 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 KES K Sh Kenyan Shilling 2 4 N N \N \N 2 267 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 KWD KD Kuwaiti Dinar 3 5 N N \N \N 3 268 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 BAM KM Convertible Marks 2 4 N N \N \N 2 269 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 LAK KN Kip 2 4 N N \N \N 2 270 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 ERN KR Nakfa 2 4 N N \N \N 2 271 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 ALL L Lek 2 4 N N \N \N 2 272 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 HNL L Lempira 2 4 N N \N \N 2 273 0 0 Y 2003-08-06 17:05:40 0 2003-08-06 17:05:40 0 ROL L Leu 2 4 N N \N \N 2 274 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 SZL L Lilangeni 2 4 N N \N \N 2 275 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 LYD LD Libyan Dinar 3 5 N N \N \N 3 276 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 SLL Le Leone 2 4 N N \N \N 2 277 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 MTL Lm Maltese Lira 2 4 N N \N \N 2 278 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 LVL Ls Latvian Lats 2 4 N N \N \N 2 279 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 BGL Lv Lev 2 4 N N \N \N 2 280 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 MUR Mau Rs Mauritius Rupee 2 4 N N \N \N 2 281 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 MWK MK Kwacha 2 4 N N \N \N 2 282 0 0 Y 2003-08-06 17:05:41 0 2003-08-06 17:05:41 0 MKD MKD Denar 2 4 N N \N \N 2 283 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 MZM Mt Metical 2 4 N N \N \N 2 284 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 ANG NAf. Netherlands Antillian Guilder 2 4 N N \N \N 2 285 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 EEK Nfa Kroon 2 4 N N \N \N 2 286 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 ILS NIS New Israeli Sheqel 2 4 N N \N \N 2 287 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 NOK NKr Norwegian Krone 2 4 N N \N \N 2 288 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 NPR NRs Nepalese Rupee 2 4 N N \N \N 2 289 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 TWD NT$ New Taiwan Dollar 2 4 N N \N \N 2 290 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 BWP P Pula 2 4 N N \N \N 2 291 0 0 Y 2003-08-06 17:05:42 0 2003-08-06 17:05:42 0 MOP P Pataca 2 4 N N \N \N 2 292 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 GTQ Q Quetzal 2 4 N N \N \N 2 293 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 QAR QR Qatari Rial 2 4 N N \N \N 2 294 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 ZAR R Rand 2 4 N N \N \N 2 297 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 BRL R$ Brazilian Real 2 4 N N \N \N 2 298 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 DOP RD$ Dominican Peso 2 4 N N \N \N 2 299 0 0 Y 2003-08-06 17:05:43 0 2003-08-06 17:05:43 0 MVR Rf Rufiyaa 2 4 N N \N \N 2 301 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 MYR RM Malaysian Ringgit 2 4 N N \N \N 2 300 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 RWF RF Rwanda Franc 0 2 N N \N \N 0 302 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 OMR RO Rial Omani 3 5 N N \N \N 3 303 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 IDR Rp Rupiah 2 4 N N \N \N 2 304 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 INR Rs Indian Rupee 2 4 N N \N \N 2 306 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 PKR Rs Pakistan Rupee 2 4 N N \N \N 2 307 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 SGD S$ Singapore Dollar 2 4 N N \N \N 2 308 0 0 Y 2003-08-06 17:05:44 0 2003-08-06 17:05:44 0 PEN S/. Nuevo Sol 2 4 N N \N \N 2 309 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SRG Sf. Suriname Guilder 2 4 N N \N \N 2 310 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SBD SI$ Solomon Islands Dollar 2 4 N N \N \N 2 311 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SEK Sk Swedish Krona 2 4 N N \N \N 2 312 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SKK Sk Slovak Koruna 2 4 N N \N \N 2 313 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 LKR SLRs Sri Lanka Rupee 2 4 N N \N \N 2 314 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SIT SlT Tolar 2 4 N N \N \N 2 315 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SOS So. Sh. Somali Shilling 2 4 N N \N \N 2 316 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SCR SR Seychelles Rupee 2 4 N N \N \N 2 317 0 0 Y 2003-08-06 17:05:45 0 2003-08-06 17:05:45 0 SAR SRls Saudi Riyal 2 4 N N \N \N 2 318 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 CHF SwF Swiss Franc 2 4 N N \N \N 2 320 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 TOP T$ Pa’anga 2 4 N N \N \N 2 321 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 TND TD Tunisian Dinar 3 5 N N \N \N 3 322 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 BDT Tk Taka 2 4 N N \N \N 2 324 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 TZS TSh Tanzanian Shilling 2 4 N N \N \N 2 325 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 TTD TT$ Trinidad and Tobago Dollar 2 4 N N \N \N 2 326 0 0 Y 2003-08-06 17:05:46 0 2003-08-06 17:05:46 0 MNT Tug Tugrik 2 4 N N \N \N 2 327 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 MRO UM Ouguiya 2 4 N N \N \N 2 328 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 UGX USh Uganda Shilling 2 4 N N \N \N 2 331 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 WST WS$ Tala 2 4 N N \N \N 2 332 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 CNY Y Yuan Renminbi 2 4 N N \N \N 2 333 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 YER YRls Yemeni Rial 2 4 N N \N \N 2 334 0 0 Y 2003-08-06 17:05:47 0 2003-08-06 17:05:47 0 ZWD Z$ Zimbabwe Dollar 2 4 N N \N \N 2 335 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 ZMK ZK Kwacha 2 4 N N \N \N 2 336 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 CRC \N Costa Rican Colon 2 4 N N \N \N 2 338 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 GWP \N Guinea-Bissau Peso 2 4 N N \N \N 2 339 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 KGS \N Som 2 4 N N \N \N 2 340 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 KPW \N North Korean Won 2 4 N N \N \N 2 341 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 KZT \N Tenge 2 4 N N \N \N 2 342 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 LBP \N Lebanese Pound 2 4 N N \N \N 2 343 0 0 Y 2003-08-06 17:05:48 0 2003-08-06 17:05:48 0 NGN \N Naira 2 4 N N \N \N 2 \. -- -- TOC entry 3684 (class 2606 OID 43670) -- Dependencies: 2879 2879 -- Name: c_currency_key; Type: CONSTRAINT; Schema: public; Owner: tad; Tablespace: -- ALTER TABLE ONLY c_currency ADD CONSTRAINT c_currency_key PRIMARY KEY (c_currency_id); -- -- TOC entry 3686 (class 2606 OID 43674) -- Dependencies: 2879 2879 -- Name: c_currencyisocode; Type: CONSTRAINT; Schema: public; Owner: tad; Tablespace: -- ALTER TABLE ONLY c_currency ADD CONSTRAINT c_currencyisocode UNIQUE (iso_code); -- -- TOC entry 3689 (class 2620 OID 44577) -- Dependencies: 2879 190 -- Name: c_currency_trg; Type: TRIGGER; Schema: public; Owner: tad -- CREATE TRIGGER c_currency_trg AFTER INSERT OR UPDATE ON c_currency FOR EACH ROW EXECUTE PROCEDURE c_currency_trg(); -- -- TOC entry 3687 (class 2606 OID 51138) -- Dependencies: 2693 2879 -- Name: c_currencyclient; Type: FK CONSTRAINT; Schema: public; Owner: tad -- ALTER TABLE ONLY c_currency ADD CONSTRAINT c_currencyclient FOREIGN KEY (ad_client_id) REFERENCES ad_client(ad_client_id); -- -- TOC entry 3688 (class 2606 OID 51148) -- Dependencies: 2736 2879 -- Name: c_currencyorg; Type: FK CONSTRAINT; Schema: public; Owner: tad -- ALTER TABLE ONLY c_currency ADD CONSTRAINT c_currencyorg FOREIGN KEY (ad_org_id) REFERENCES ad_org(ad_org_id); -- Completed on 2008-07-01 13:28:51 BST -- -- PostgreSQL database dump complete --