• Home
• com.brihaspathee.zeus
• tp-service
• 1.0.2
• source code
• V2__init_tp_data_load.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V2__init_tp_data_load.sql Maven / Gradle / Ivy

INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('15cc9dbb-73e8-473e-9f6b-e772a781e6dc','060641618A', 'FFM AR TP', 'Arkansas FFM Trading Partner', 'CMSFFM', '060641618A', 'HIX', 'AR_BU', 'AR', 'FFM', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('de452af8-b789-47c5-b517-39cbe2ae083c','TP011643', 'SBE AR TP', 'Arkansas SBE Trading Partner', '716007869', 'TP011643', 'HIX', 'AR_BU', 'AR', 'SBE', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('0375a5fa-db10-4704-97b8-1cebe43c2c9a','363097810', 'FFM AZ TP', 'Arizona FFM Trading Partner', 'CMSFFM', '363097810', 'HIX', 'AZ_BU', 'AZ', 'FFM', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('a85b80c4-e7c8-4250-aab1-30aa9e532af0','91450', 'OFFX AZ TP', 'Arizona OFFX Trading Partner', 'AZOFFX', '91450', 'HIX', 'AZ_BU', 'AZ', 'OFFX', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('2b937843-e6d3-4d1d-809c-148b95beda93','954402957052', 'SBE CA TP', 'California SBE Trading Partner', 'CA0', '954402957052', 'HIX', 'CA_BU', 'CA', 'SBE', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('152b4196-1cb1-433a-b3ff-ea4d567a1788','954402957063', 'SBE CA TP', 'California SBE Trading Partner', 'CA0', '954402957063', 'HIX', 'CA_BU', 'CA', 'SBE', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('5c985138-8921-4661-8992-05d9d4ab0ca5','730654885040', 'SBE CA TP', 'California SBE Trading Partner', 'CA0', '730654885040', 'HIX', 'CA_BU', 'CA', 'SBE', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('81c1bbcc-1ffc-4554-ae56-50f721aed469','730654885034', 'SBE CA TP', 'California SBE Trading Partner', 'CA0', '730654885034', 'HIX', 'CA_BU', 'CA', 'SBE', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('fd981496-6db2-497d-8944-a780b758a00c','67138052', 'OFFX CA TP', 'California OFFX Trading Partner', 'CAOFFX', '67138052', 'HIX', 'CA_BU', 'CA', 'OFFX', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('96f76431-49ea-41e6-bac9-b08dca355b57','67138063', 'OFFX CA TP', 'California OFFX Trading Partner', 'CAOFFX', '67138063', 'HIX', 'CA_BU', 'CA', 'OFFX', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('e2c4ff60-48ec-4105-abe2-0b6852e60ec2','99110040', 'OFFX CA TP', 'California OFFX Trading Partner', 'CAOFFX', '99110040', 'HIX', 'CA_BU', 'CA', 'OFFX', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('f3dee461-7e07-4bfc-839b-68ad813d0ef2','99110034', 'OFFX CA TP', 'California OFFX Trading Partner', 'CAOFFX', '99110034', 'HIX', 'CA_BU', 'CA', 'OFFX', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('6a7bd316-ca78-4c9e-b466-d27d31c04db9','21663', 'FFM FL TP', 'Florida FFM Trading Partner', 'CMSFFM', '21663', 'HIX', 'FL_BU', 'FL', 'FFM', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('abb5a90e-57e6-4520-98c3-73057bd29a05','70893', 'FFM GA TP', 'Georgia FFM Trading Partner', 'CMSFFM', '70893', 'HIX', 'GA_BU', 'GA', 'FFM', sysdate(), sysdate());
INSERT INTO tpdb.trading_partner_detail(trading_partner_sk, trading_partner_id, name, description, sender_id, receiver_id, line_of_business_type_code, business_unit_type_code, state_type_code, marketplace_type_code, created_date, updated_date) VALUES ('cc31c1dd-8fa2-4299-af4a-24780567831d','63734', 'FFM MA TP', 'Massachusetts FFM Trading Partner', 'CMSFFM', '63734', 'HIX', 'MA_BU', 'MA', 'FFM', sysdate(), sysdate());