API tools faq
paste
Advertisement
Guest User

Search-TC8

a guest
Aug 23rd, 2019
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 11.57 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO "3pl_detail"("id","header_id","request_id","reference_number","reference_type","detail_type","activity","raw_data","translated_data","note","created_by","created_on","modified_by","modified_on")
  2. VALUES
  3. (482,217,E'RMA20190515165_190515190402796447799_DHL20190515140316168.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190515165","outbound_type":"TF002","order_number":"DN_12","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-15 18:22:54","destination":"blo.jakartaselatan@ruma.co.id","status":"Allocated","sku":"ZBOX12347","quantity":"20","condition":"BAIK","note":""}],"filename":"DHL20190515140316168.csv"}',E'{"request_id":"RMA20190515165_190515190402796447799_DHL20190515140316168.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"DN_12","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557921842,"nanos":796447799}},"shipped_items":[{"code":"ZBOX12347","quantity":20,"condition":1}],"actual_date":{"year":2019,"month":5,"day":15},"report_status":2}',E'',E'DHL ADAPTER',E'2019-05-15 12:04:02.816399+00',E'3PL TRANSLATOR',E'2019-05-28 05:09:54.164068+00'),
  4. (335,187,E'RMA20190514117_190514172937749855340_DHL20190514122902112.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190514117","outbound_type":"TF002","order_number":"DN_07","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-14 17:55:05","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"EDEY12434","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190514122902112.csv"}',E'{"request_id":"RMA20190514117_190514172937749855340_DHL20190514122902112.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"DN_07","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557829777,"nanos":749855340}},"shipped_items":[{"code":"EDEY12434","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":14},"report_status":4}',E'',E'DHL ADAPTER',E'2019-05-14 10:29:37.768096+00',E'3PL TRANSLATOR',E'2019-05-28 05:09:31.553162+00'),
  5. (336,187,E'RMA20190514117_190514173147881453312_DHL20190514123102113.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190514117","outbound_type":"TF002","order_number":"DN_07","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-14 17:55:05","destination":"blo.jakartaselatan@ruma.co.id","status":"Reject Picking","sku":"EDEY12434","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190514123102113.csv"}',E'{"request_id":"RMA20190514117_190514173147881453312_DHL20190514123102113.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"DN_07","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557829907,"nanos":881453312}},"shipped_items":[{"code":"EDEY12434","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":14},"report_status":4}',E'',E'DHL ADAPTER',E'2019-05-14 10:31:47.892409+00',E'3PL TRANSLATOR',E'2019-05-28 05:09:31.581364+00'),
  6. (5897,5317,E'RMA20190604141_190604153225136693533_DHL20190604103146256.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_RETRIEVED',E'{"data":[{"request_id":"RMA20190604141","outbound_type":"STOCK POINT","order_number":"OUT123456d","delivery_note":"1797-JAKARTA SELATAN","transaction_time":"2019-06-04 16:31:20","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12350","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190604103146256.csv"}',E'',E'',E'DHL ADAPTER',E'2019-06-04 08:32:25.266031+00',E'DHL ADAPTER',E'2019-06-04 08:32:25.266031+00'),
  7. (28,24,E'RMA20190509111_190509115912925264707_DHL20190509065830055.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190509111","outbound_type":"TF002","order_number":"OUT20190510_01","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-09 12:54:16","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAEX12353","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190509065830055.csv"}',E'{"request_id":"RMA20190509111_190509115912925264707_DHL20190509065830055.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"OUT20190510_01","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557377952,"nanos":925264707}},"shipped_items":[{"code":"AAEX12353","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":9},"report_status":5}',E'',E'DHL ADAPTER',E'2019-05-09 04:59:12.931684+00',E'3PL TRANSLATOR',E'2019-05-09 04:59:13.973249+00'),
  8. (29,25,E'RMA20190509112_190509115912929664691_DHL20190509065830055.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190509112","outbound_type":"TF002","order_number":"OUT20190510_02","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-09 12:54:17","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAEX12359","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190509065830055.csv"}',E'{"request_id":"RMA20190509112_190509115912929664691_DHL20190509065830055.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"OUT20190510_02","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557377952,"nanos":929664691}},"shipped_items":[{"code":"AAEX12359","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":9},"report_status":5}',E'',E'DHL ADAPTER',E'2019-05-09 04:59:12.95414+00',E'3PL TRANSLATOR',E'2019-05-09 04:59:14.476929+00'),
  9. (26,25,E'RMA20190509112_190509115702802159949_DHL20190509065630054.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190509112","outbound_type":"TF002","order_number":"OUT20190510_02","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-09 12:54:17","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAEX12359","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190509065630054.csv"}',E'{"request_id":"RMA20190509112_190509115702802159949_DHL20190509065630054.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"OUT20190510_02","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557377822,"nanos":802159949}},"shipped_items":[{"code":"AAEX12359","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":9},"report_status":5}',E'',E'DHL ADAPTER',E'2019-05-09 04:57:02.843726+00',E'3PL TRANSLATOR',E'2019-05-09 04:57:04.365197+00'),
  10. (25,24,E'RMA20190509111_190509115702684862866_DHL20190509065630054.csv',E'0-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"RMA20190509111","outbound_type":"TF002","order_number":"OUT20190510_01","delivery_note":"0-JAKARTA SELATAN","transaction_time":"2019-05-09 12:54:16","destination":"blo.jakartaselatan@ruma.co.id","status":"Open","sku":"AAEX12353","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190509065630054.csv"}',E'{"request_id":"RMA20190509111_190509115702684862866_DHL20190509065630054.csv","reference_number":"0-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"OUT20190510_01","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557377822,"nanos":684862866}},"shipped_items":[{"code":"AAEX12353","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":9},"report_status":5}',E'',E'DHL ADAPTER',E'2019-05-09 04:57:02.808472+00',E'3PL TRANSLATOR',E'2019-05-09 04:57:03.860518+00'),
  11. (95,88,E'SCP-896 REQUEST ID_190509172059184878070_DHL20190503140443015.csv',E'1770-JAKARTA SELATAN',E'DN',E'OUTBOUND_REPORT',E'REPORT_TRANSLATED',E'{"data":[{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12352","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"AAAX12353","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:34","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"LAAX12345","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12494","quantity":"1","condition":"BAIK","note":""},{"request_id":"SCP-896 REQUEST ID","outbound_type":"TF002","order_number":"SCP-896 ORDER NUMBER","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"BAIK","note":""}],"filename":"DHL20190503140443015.csv"}',E'{"request_id":"SCP-896 REQUEST ID_190509172059184878070_DHL20190503140443015.csv","reference_number":"1770-JAKARTA SELATAN","reference_type":1,"outbound_type":16,"order":{"order_number":"SCP-896 ORDER NUMBER","shipped_from_id":"0178","shipped_to_id":"blo.jakartaselatan@ruma.co.id","created_by":"DHL ADAPTER","created_time":{"seconds":1557397259,"nanos":184878070}},"shipped_items":[{"code":"AAAX12352","quantity":1,"condition":1},{"code":"AAAX12353","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"LAAX12345","quantity":1,"condition":1},{"code":"CABX12494","quantity":1,"condition":1},{"code":"CABX12495","quantity":1,"condition":1}],"actual_date":{"year":2019,"month":5,"day":3},"report_status":1}',E'',E'DHL ADAPTER',E'2019-05-09 10:20:59.195231+00',E'3PL TRANSLATOR',E'2019-05-09 10:20:59.918086+00'),
  12. (101,94,E'SCP-896_OTB-042_190509173456384605020_DHL20190503140443015.csv',E'',E'',E'OUTBOUND_REPORT',E'REPORT_TRANSLATION_FAILED',E'{"data":[{"request_id":"SCP-896_OTB-042","outbound_type":"TF002","order_number":"SCP-896_OTB-042 ORDER NUMBER 6","delivery_note":"1770-JAKARTA SELATAN","transaction_time":"2019-05-03 19:42:35","destination":"blo.jakartaselatan@ruma.co.id","status":"Closed","sku":"CABX12495","quantity":"1","condition":"RUSAK PRODUK RETUR","note":""}],"filename":"DHL20190503140443015.csv"}',E'',E'invalid report on line number 1: Item condition "RUSAK PRODUK RETUR" is invalid',E'DHL ADAPTER',E'2019-05-09 10:34:56.506865+00',E'3PL TRANSLATOR',E'2019-05-09 10:34:57.917573+00');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!