name=id, type=int8
name=merch_type_code, type=int4
name=merch_id, type=text
name=ver, type=int8
name=status_code, type=int4
name=merch_name, type=text
name=merch_reg_no, type=text
name=bank_code, type=text
name=bank_account_no, type=text
name=bank_account_name, type=text
name=addr_1, type=text
name=addr_2, type=text
name=addr_city, type=text
name=addr_post, type=text
name=addr_state_code, type=int4
name=addr_country_code_alpha_2, type=text
name=person_in_charge, type=text
name=phone_number, type=text
name=fax_number, type=text
name=email, type=text
name=website_url, type=text
name=pic_1_url, type=text
name=pic_2_url, type=text
name=created_by, type=text
name=updated_by, type=text
name=dt_create, type=timestamptz
name=dt_update, type=timestamptz
name=mdr_rate, type=numeric
name=sc_rate, type=numeric
name=pic_2_file, type=text
name=pic_1_file, type=text
SQL upsert=INSERT INTO i3s_merchant (merch_type_code,merch_id,status_code,merch_name,merch_reg_no,bank_code,bank_account_no,bank_account_name,addr_1,addr_2,addr_city,addr_post,addr_state_code,addr_country_code_alpha_2,person_in_charge,phone_number,fax_number,email,website_url,pic_1_url,pic_2_url,created_by,updated_by,mdr_rate,sc_rate,pic_2_file,pic_1_file) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27) ON CONFLICT (merch_id) DO UPDATE SET merch_type_code=$1,status_code=$3,merch_name=$4,merch_reg_no=$5,bank_code=$6,bank_account_no=$7,bank_account_name=$8,addr_1=$9,addr_2=$10,addr_city=$11,addr_post=$12,addr_state_code=$13,addr_country_code_alpha_2=$14,person_in_charge=$15,phone_number=$16,fax_number=$17,email=$18,website_url=$19,pic_1_url=$20,pic_2_url=$21,created_by=$22,updated_by=$23,mdr_rate=$24,sc_rate=$25,pic_2_file=$26,pic_1_file=$27)
Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-71D1-B054-212EF47261C1
    [2] => 2
    [3] => Kantin SK Cheras Jaya
    [4] => 001346893W
    [5] => MBB
    [6] => 514356704044
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 14
    [13] => MY
    [14] => RUSNAH BIN RASHID
    [15] => +60126240784
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7FCA-8DE9-31447EDAD7B0
    [2] => 1
    [3] => Kantin SMK Damansara Jaya
    [4] => 1409479H
    [5] => MBB
    [6] => 562759706933
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 10
    [13] => MY
    [14] => MUHAMMAD SYAZWAN BIN MOHAMAD ZAKI
    [15] => +60126455773
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 5
    [1] => 0195B1B9-5937-7230-A7E9-DDFD73320D46
    [2] => 1
    [3] => KEDAI i3s
    [4] => 414477T
    [5] => CIMB
    [6] => 70556534
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => Maisarah
    [15] => +60199305900
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5935-775D-A1FC-92FA4AE7D7A3
    [2] => 2
    [3] => R & Z RAZIMAN ENTERPRISE
    [4] => SA0030843D
    [5] => MBB
    [6] => 114011717259
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => MD RAZI BIN MAN
    [15] => +60133240649
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 5.00
    [24] => 0.00
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 2
    [1] => 0195B1B9-5936-722C-9CBE-B213AE6EB5A3
    [2] => 1
    [3] => KOPERASI MRSM BAGAN DATUK
    [4] => 002572144V
    [5] => MBB
    [6] => 162021451127
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => MOHD FAREEZ BIN ABDUL RAHMAN
    [15] => +60129197821
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7794-8082-3889C2F241A2
    [2] => 1
    [3] => Kantin SK Seksyen 6
    [4] => SA0380564W
    [5] => CIMB
    [6] => 8603264387
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => SRI MURNI BINTI ABDULLAH
    [15] => +60133339109
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 10.00
    [24] => 0.00
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7AA0-991A-F84FF53ABC33
    [2] => 2
    [3] => TUNAS JAYA RESOURCES
    [4] => 001559521X
    [5] => CIMB
    [6] => 8600431749
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => HIRMAN BIN HAMDAN
    [15] => +60106305533
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 3
    [1] => 0195B1B9-5936-768E-B62E-84AC0A4655BC
    [2] => 2
    [3] => KANGTING SDN BHD
    [4] => 210639V
    [5] => MBB
    [6] => 014196208044
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => GAN KANG TING
    [15] => +60189888351
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7586-8D47-37809ABFEECF
    [2] => 2
    [3] => Kantin SMK Seksyen 1, BK (Q CATERERS)
    [4] => 000989143M
    [5] => MBB
    [6] => 512491103378
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => MOHD AZHARUDIN BIN BIDIN
    [15] => +60122323886
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-786F-8851-987B57B96BDF
    [2] => 2
    [3] => KEMBARA DESA RESOURCES
    [4] => SA0095789P
    [5] => BIMB
    [6] => 12038010087076
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => FOZIAH BINTI ABD GHANI
    [15] => +60123949434
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-702D-9478-56C643583FE0
    [2] => 1
    [3] => Kantin SKPP 9(1)
    [4] => JR0050628V
    [5] => BIMB
    [6] => 12065010046084
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => ROZIATY RASHID
    [15] => +60175392747
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7430-9837-08F24FCBF447
    [2] => 2
    [3] => Kantin SKPP 18(2)
    [4] => 002131315B
    [5] => MBB
    [6] => 162982008948
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => KHAIRUL ZANZABIL B.ABDUL RAZAK
    [15] => +601164604698
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 0.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-74E2-986C-AA72793CB40D
    [2] => 1
    [3] => MAHAT HASHIM ENTERPRISE
    [4] => 001106686P
    [5] => BIMB
    [6] => 04024010028395
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => MAHAT BIN HASHIM
    [15] => +60133923803
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7710-9A19-11D06B7A43AF
    [2] => 1
    [3] => Kantin SMK Seksyen 18
    [4] => SA0309649H
    [5] => MBB
    [6] => 8881020261405
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => ABDUL AZIZ AL IKRAM BIN HJ YAAKUB
    [15] => +60136773711
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7ED8-B458-969229914146
    [2] => 2
    [3] => Kantin SMK Damansara Jaya
    [4] => SA0303191X
    [5] => MBB
    [6] => 152077305062
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => ZURIATY BINTI MAT ISA @ HASHIM
    [15] => +60194444123
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 0.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5936-7D6A-B1F5-3FC17939B079
    [2] => 1
    [3] => Kantin SMK Ampuan Rahimah
    [4] => SA0237380A
    [5] => CIMB
    [6] => 8003690861
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => ZUZANA BINTI RAHMAN
    [15] => +601155594349
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-71FD-BF84-EA8E452FCCC3
    [2] => 1
    [3] => AZZAQ LAVENDER TRADING (SKS1 2)
    [4] => 001362897W
    [5] => HLB
    [6] => 18700004676
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => Azman
    [15] => +60182119313
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-758F-833A-51CC5072D569
    [2] => 1
    [3] => Kantin SMK Bukit Kapar
    [4] => 001504469W
    [5] => RHB
    [6] => 26229600010700
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => Suraya Binti Jaafar
    [15] => +60193671512
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7D35-90E3-487D7151CA0B
    [2] => 1
    [3] => Kantin SK Pandamaran Jaya
    [4] => AS0444131M
    [5] => CIMB
    [6] => 8605213195
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => NORYUSLAIHIS BINTI MOHD ZAIN
    [15] => +60172852957
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7AE8-B7B6-FEC62CB99C02
    [2] => 1
    [3] => Kantin SMK Jalan Kebun
    [4] => 001983218K
    [5] => MBB
    [6] => 564212106767
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => SHIHABUDDIN BIN ABDULLAH
    [15] => +601136940873
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7AFE-B0B8-3BFB6B5163FF
    [2] => 1
    [3] => Kantin SMK Seksyen 18
    [4] => RA0100581M
    [5] => MBB
    [6] => 562861153150
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => MAWARNI BINTI AZALI
    [15] => +60178384283
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 3
    [1] => 0195B1B9-5937-7968-A9F9-EEC51A728D86
    [2] => 1
    [3] => Bookstore SK Jln Gurney 1
    [4] => 937857K
    [5] => RHB
    [6] => 21213400069120
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => SITI
    [15] => +60198927030
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-78B9-AF5D-D459DEDC79AE
    [2] => 2
    [3] => Kantin SK Jln Gurney 1
    [4] => 001274334X
    [5] => RHB
    [6] => 26419700002275
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => yahaya hashim
    [15] => +60173207023
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-70A8-8B11-810B09768E91
    [2] => 1
    [3] => Kantin SKPP 18(2)
    [4] => SA014381V
    [5] => CIMB
    [6] => 8602019298
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => NOR PARALIZA BINTI A KAHAR
    [15] => +60148381866
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7F8C-AA6F-B239D408071D
    [2] => 1
    [3] => Kantin SK ST John 1
    [4] => 002688927U
    [5] => BIMB
    [6] => 14153023306317
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => ZAIDAH BINTI ZAINAL ABIDIN
    [15] => +60166470320
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Params=Array
(
    [0] => 1
    [1] => 0195B1B9-5937-7DC9-BD5C-AF033488EDA0
    [2] => 1
    [3] => Kantin SMK PP9(1)
    [4] => 002823236T
    [5] => MBB
    [6] => 562058080781
    [7] => 
    [8] => 
    [9] => 
    [10] => 
    [11] => 
    [12] => 
    [13] => MY
    [14] => TUMINAH BINTI MARKOM
    [15] => +601135191559
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 6.00
    [24] => 5.66
    [25] => 
    [26] => 
)

Version=
Row count=26