LOAD DATA
INFILE *
INTO TABLE role_types
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
,rt_type
)
BEGINDATA
ENQ CREATE|Created Enquiry|ENRT
ENQ OWN|Owner of Enquiry|ENRT
ENQ AMEND|Amend Enquiry|ENRT
ENQ RFQ|Submit Request For Quotation|ENRT
LOW DEFINITION DRAWING|Low definition drawing|DORT
HIGH DEFINITION DRAWING|High definition drawing|DORT
MANUAL QUOTATION|Manually generated quotation|DORT
GENERATED QUOTATION|WebMIP generated quotation|DORT
ENQUIRY SUPPORTING DOC|User-supplied documentation to support enquiry|DORT
Q SEL|Selected quotation|QURT
OFFICE|Office|PART
HOME|Home|PART
BILLADDR|Billing inquiries|PCMRT
BILLPHONE|Billing inquiries number|PCMRT
MAINOFFADDR|Main office address|PCMRT
MAINOFFPHONE|Main office number|PCMRT
MAINOFFFAX|Main office fax|PCMRT
SECOFFPHONE|Secondary office number|PCMRT
SECOFFFAX|Secondary office fax|PCMRT
MAINHOMEADDR|Main home address|PCMRT
MAINHOMEPHONE|Main home number|PCMRT
MAINHOMEFAX|Main home fax|PCMRT
SECHOMEPHONE|Secondary home number|PCMRT
SECHOMEFAX|Secondary home fax|PCMRT
AGENT|Agent|PRT
SUPP|Gas supplier|PRT
SUPPADMIN|User administrator|PRT
MIPADMIN|System Administrator|PRT
ICU|Quotation operative|PRT
CS|Customer Service operative|PRT
EXTORG|External organization|PRT
Q RFQ|Submitted request for quotation|QURT
Q OWN|Owner of quotation|QURT
Q ACC|Accepted quotation|QURT
Q REJ|Rejected quotation|QURT
Q SUBACC|Submitted acceptance of quotation|QURT
Q SUBREJ|Submitted rejection of quotation|QURT
ENQ SUPP|Supplier for Enquiry|ENRT