select * from m_partner where partner_id = 35305
select * from m_partner_npwp where partner_id = 35305
SELECT * FROM fi_vat_out_for_efaktur WHERE record_type = 'LT' AND col2 = 'PT.SUMBER ALFARIA TRIJAYA, TBK' LIMIT 100
SELECT * FROM fi_vat_out_for_efaktur WHERE record_type = 'FK' AND col8 = 'PT.SUMBER ALFARIA TRIJAYA, TBK' LIMIT 100

select * from m_partner where partner_id = 36776
select * from m_partner_npwp where partner_id = 36776
SELECT * FROM fi_vat_out_for_efaktur WHERE record_type = 'LT' and col2 = 'PT. SUMBER ALFARIA TRIJAYA TBK' LIMIT 100
SELECT * FROM fi_vat_out_for_efaktur WHERE record_type = 'FK' AND col8 = 'PT. SUMBER ALFARIA TRIJAYA TBK' LIMIT 100


begin;
update m_partner set partner_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk', partner_ext_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk' where partner_id = 35305
update m_partner_npwp set npwp_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk' where partner_id = 35305
update fi_vat_out_for_efaktur set col2 = 'PT SUMBER ALFARIA TRIJAYA , TBK' where record_type = 'LT' and col2 = 'PT.SUMBER ALFARIA TRIJAYA, TBK'
update fi_vat_out_for_efaktur set col8 = 'PT SUMBER ALFARIA TRIJAYA , TBK' where record_type = 'FK' AND col8 = 'PT.SUMBER ALFARIA TRIJAYA, TBK'

update m_partner set partner_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk', partner_ext_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk' where partner_id = 36776
update m_partner_npwp set npwp_name = 'PT SUMBER ALFARIA TRIJAYA , Tbk' where partner_id = 36776
update fi_vat_out_for_efaktur set col2 = 'PT SUMBER ALFARIA TRIJAYA , TBK' where record_type = 'LT' and col2 = 'PT. SUMBER ALFARIA TRIJAYA TBK'
update fi_vat_out_for_efaktur set col8 = 'PT SUMBER ALFARIA TRIJAYA , TBK' where record_type = 'FK' AND col8 = 'PT. SUMBER ALFARIA TRIJAYA TBK'
end;