60a48b9df5
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3657 248e525c-4dfb-0310-94bc-949c084e9493
50 lines
1.5 KiB
Plaintext
50 lines
1.5 KiB
Plaintext
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
|