Fanadia_Friska

dummy

Sep 9th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.19 KB | None | 0 0
  1. --m_region_customer
  2. INSERT INTO m_region_customer(
  3. region_customer_id, tenant_id, region_id,
  4. customer_id, create_datetime, create_user_id,
  5. update_datetime, update_user_id, version )
  6.  
  7. VALUE ('1','23','15000002',
  8. '16000011','20160802000000','-2',
  9. '20160902000000','-2','0'),
  10.  
  11.  
  12. ('2','24','15000003',
  13. '16000012','20160802000000','-3',
  14. '20160902000000','-3','0'),
  15.  
  16.  
  17. ('3','25','15000004',
  18. '16000013','20160802000000','-4',
  19. '20160902000000','-4','0');
  20.  
  21.  
  22.  
  23.  
  24. --m_region
  25.  
  26. INSERT INTO m_region(
  27. region_id , tenant_id , ou_id ,
  28. region_code , region_name , create_datetime ,
  29. create_user_id , update_datetime , update_user_id ,
  30. version , active , active_datetime ,
  31. non_active_datetime )
  32.  
  33. VALUE ( '15000002','24','15000004',
  34. '1','SUMATERA','20160902000000',
  35. '-2','20160902000000','',
  36. '0','Y','20160902000000',
  37. '' ),
  38.  
  39. ( '15000003','25','15000005',
  40. '2','JAWA','20160902000000',
  41. '-3','20160902000000','',
  42. '0','Y','20160902000000',
  43. '' ),
  44.  
  45. ( '15000004','26','15000005',
  46. '3','KALIMANTAN','20160902000000',
  47. '-4','20160902000000','',
  48. '0','Y','20160902000000',
  49. '' );
  50.  
  51.  
  52.  
  53. --m_partner
  54.  
  55. INSERT INTO m_partner(
  56. partner_id, tenant_id, partner_code,
  57. partner_name, ctgr_partner_id, partner_ext_name,
  58. npwp_id, holding_id, flg_holding,
  59. rank, create_datetime, create_user_id,
  60. update_datetime, update_user_id, version,
  61. active, active_datetime, non_active_datetime,
  62. line_of_business, price_level, industry_type,
  63. npwp_status )
  64.  
  65. VALUE ('101','25','JKT',
  66. 'JAKARTA','1000001','JAKARTA',
  67. '-99','-99','N',
  68. 'G','20160918000000','-1',
  69. '20160918000000','-1','0',
  70. 'Y','20160918000000','',
  71. '','','',
  72. '01'),
  73.  
  74. ('102','26','BDG',
  75. 'BANDUNG','1000002','BANDUNG',
  76. '-99','-99','N',
  77. 'A','20160918000000','-2',
  78. '20160918000000','-1','0',
  79. 'Y','20160918000000','',
  80. '','','',
  81. '02'),
  82.  
  83. ('103','27','BL',
  84. 'BALI','1000001','BALI',
  85. '-99','-99','N',
  86. 'B','20160918000000','-3',
  87. '20160918000000','-1','0',
  88. 'Y','20160918000000','',
  89. '','','',
  90. '03');
Advertisement
Add Comment
Please, Sign In to add comment