SQL ADD

--m_region_customer
INSERT INTO m_region_customer(
			region_customer_id, tenant_id, region_id,
			customer_id, create_datetime, create_user_id,
			update_datetime, update_user_id, version )

	VALUES	(1,23,15000002,
			16000011,'20160802000000',-2,
			'20160902000000',-2,0),


			(2,23,15000003,
			16000012,'20160802000000',-3,
			'20160902000000',-3,0),


			(3,23,15000004,
			16000013,'20160802000000',-4,
			'20160902000000',-4,0),

			(4,23,15000005,
			16000014,'20160802000000',-5,
			'20160902000000', -5, 0),

			(5,23,15000006,
			16000015,'20160802000000',-6,
			'20160902000000', -6, 0),

			(6,23,15000007,
			16000016,'20160802000000',-7,
			'20160902000000', -7, 0),

			(7,23,15000008,
			16000017,'20160802000000',-8,
			'20160902000000', -8, 0);





--m_region

INSERT INTO m_region(
			region_id , tenant_id , ou_id ,
			region_code , region_name , create_datetime ,
			create_user_id , update_datetime , update_user_id ,
			version  , active , active_datetime ,
			non_active_datetime )

	VALUES	( 15000002,23,15000004,
			'1','SUMATERA','20160902000000',
			-2,'20160902000000','-2',
			0,'Y','20160902000000',
			'20160902000000' ),

			( 15000003,23,15000005,
			'2','JAWA','20160902000000',
			-3,'20160902000000','-3',
			0,'Y','20160902000000',
			'20160902000000' ),

			( 15000004,23,15000005,
			'3','KALIMANTAN','20160902000000',
			-4,'20160902000000','-4',
			0,'Y','20160902000000',
			'20160902000000' );



--m_partner

INSERT INTO m_partner(
			partner_id, tenant_id, partner_code,
			partner_name, ctgr_partner_id, partner_ext_name,
			npwp_id, holding_id, flg_holding,
			rank, create_datetime, create_user_id,
			update_datetime, update_user_id, version,
			active, active_datetime, non_active_datetime,
			line_of_business, price_level, industry_type,
			npwp_status  )

	VALUES	(101,23,'JKT',
			'JAKARTA',1000001,'JAKARTA',
			-99,-99,'N',
			'G','20160918000000',-1,
			'20160918000000',-1,0,
			'Y','20160918000000','20170918000000',
			'1','100','A',
			'01'),

			(102,23,'BDG',
			'BANDUNG',1000002,'BANDUNG',
			-99,-99,'N',
			'A','20160918000000',-2,
			'20160918000000',-1,0,
			'Y','20160918000000','20160918000000',
			'2','200','B',
			'02'),

			(103,23,'BL',
			'BALI',1000003,'BALI',
			-99,-99,'N',
			'B','20160918000000',-3,
			'20160918000000',-1,0,
			'Y','20160918000000','20160918000000',
			'3','300','C',
			'03');