Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --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 )
- VALUE ('1','23','15000002',
- '16000011','20160802000000','-2',
- '20160902000000','-2','0'),
- ('2','24','15000003',
- '16000012','20160802000000','-3',
- '20160902000000','-3','0'),
- ('3','25','15000004',
- '16000013','20160802000000','-4',
- '20160902000000','-4','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 )
- VALUE ( '15000002','24','15000004',
- '1','SUMATERA','20160902000000',
- '-2','20160902000000','',
- '0','Y','20160902000000',
- '' ),
- ( '15000003','25','15000005',
- '2','JAWA','20160902000000',
- '-3','20160902000000','',
- '0','Y','20160902000000',
- '' ),
- ( '15000004','26','15000005',
- '3','KALIMANTAN','20160902000000',
- '-4','20160902000000','',
- '0','Y','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 )
- VALUE ('101','25','JKT',
- 'JAKARTA','1000001','JAKARTA',
- '-99','-99','N',
- 'G','20160918000000','-1',
- '20160918000000','-1','0',
- 'Y','20160918000000','',
- '','','',
- '01'),
- ('102','26','BDG',
- 'BANDUNG','1000002','BANDUNG',
- '-99','-99','N',
- 'A','20160918000000','-2',
- '20160918000000','-1','0',
- 'Y','20160918000000','',
- '','','',
- '02'),
- ('103','27','BL',
- 'BALI','1000001','BALI',
- '-99','-99','N',
- 'B','20160918000000','-3',
- '20160918000000','-1','0',
- 'Y','20160918000000','',
- '','','',
- '03');
Advertisement
Add Comment
Please, Sign In to add comment