Menambah Provinsi di Adempiere

Untuk menambah provinsi di adempiere login sebagai SuperUser ke menu System Admin - General Rules - System Rules - Country Region and City
Pada tab country klik country has region dan isi field region dengan Provinsi
Untuk tab Region tinggal di input provinsi yang ada.
atau kalau agak malas input satu per satu silakan copy paste sql syntax ini di SQL editor dan execute. sebelum di execute pastikan key untuk ID sama '209' lihat di table c_country.

insert into c_region values ('1000001','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','AC','Aceh','209','N');
insert into c_region values ('1000002','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SU','Sumatera Utara','209','N');
insert into c_region values ('1000003','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SB','Sumatera Barat','209','N');
insert into c_region values ('1000004','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','RI','Riau','209','N');
insert into c_region values ('1000005','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','JA','Jambi','209','N');
insert into c_region values ('1000006','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SS','Sumatera Selatan','209','N');
insert into c_region values ('1000007','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','BE','Bengkulu','209','N');
insert into c_region values ('1000008','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','LA','Lampung','209','N');
insert into c_region values ('1000009','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','BB','Kepulauan Bangka Belitung','209','N');
insert into c_region values ('1000010','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','KR','Kepulauan Riau','209','N');
insert into c_region values ('1000000','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','JK','Daerah Khusus Ibukota Jakarta','209','N');
insert into c_region values ('1000012','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','JB','Jawa Barat','209','N');
insert into c_region values ('1000013','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','JT','Jawa Tengah','209','N');
insert into c_region values ('1000014','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','YO','Daerah Istimewa Yogyakarta','209','N');
insert into c_region values ('1000015','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','JI','Jawa Timur','209','N');
insert into c_region values ('1000016','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','BT','Banten','209','N');
insert into c_region values ('1000017','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','BA','Bali','209','N');
insert into c_region values ('1000018','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','NB','Nusa Tenggara Barat','209','N');
insert into c_region values ('1000019','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','NT','Nusa Tenggara Timur','209','N');
insert into c_region values ('1000020','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','KB','Kalimantan Barat','209','N');
insert into c_region values ('1000021','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','KT','Kalimantan Tengah','209','N');
insert into c_region values ('1000022','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','KS','Kalimantan Selatan','209','N');
insert into c_region values ('1000023','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','KI','Kalimantan Timur','209','N');
insert into c_region values ('1000024','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SA','Sulawesi Utara','209','N');
insert into c_region values ('1000025','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','ST','Sulawesi Tengah','209','N');
insert into c_region values ('1000026','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SN','Sulawesi Selatan','209','N');
insert into c_region values ('1000027','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SG','Sulawesi Tenggara','209','N');
insert into c_region values ('1000028','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','GO','Gorontalo','209','N');
insert into c_region values ('1000029','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','SR','Sulawesi Barat','209','N');
insert into c_region values ('1000030','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','MA','Maluku','209','N');
insert into c_region values ('1000031','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','MU','Maluku Utara','209','N');
insert into c_region values ('1000032','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','PB','Papua Barat','209','N');
insert into c_region values ('1000033','0','0','Y','2010-07-16 23:59:21','0','2010-07-16 23:59:21','0','PA','Papua','209','N');