ALTER TABLE `customer` ADD `cs_jbstatusmail2` INT(1) AFTER `cs_jbstatusmail`, ADD `cs_jbstatusmail3` INT(1) AFTER `cs_jbstatusmail2`; ALTER TABLE `job` ADD `jb_automailsent2` SMALLINT(1) DEFAULT '0' NOT NULL AFTER `jb_automailsent`, ADD `jb_automailsent3` SMALLINT(1) DEFAULT '0' NOT NULL AFTER `jb_automailsent2`; INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SRV_INSTANCE', 203, 0, 'HT1', 'Instance of the current server (SB1, SB2, ... HT1, ...)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('HQ_INSTANCE', 203, 0, 'HT_LG', 'Instance of the current headquarter (HB, HH, B, H, ...)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_STARTDATE_YESTERDAY', 203, 0, '1', 'Start day of the joblist starts yesterday'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_TAKENJOB_ORDERBY', 203, 0, '1', 'ORDER BY of the joblist of the taken jobs by the couriers'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('JB_EDITBATCH_JBTYPE', 203, 0, '2', 'Default value of "jb_type" (e.g. "1" = "K" = "Kurier" / "2" = "G" = "Gütertaxi" / ...)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('JB_EDITBATCH_DISCOUNT_DISABLED', 203, 0, '0', 'Width of the logo used in mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('IMG_LOGO_WIDTH', 203, 0, '230', 'Width of the logo used in mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('IMG_LOGO_HEIGHT', 203, 0, '55', 'Height of the logo used in mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('IMG_LOGO_NAME', 203, 0, 'logo_hansetrans.gif', 'Logo used in mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAIL_SALUTATION_TEXT', 203, 0, 'Ihre HANSETRANS', 'Mail salutation text'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('LOCATING_PDA_INTERVAL', 203, 0, '0,0,23,59', 'Interval hour_from:minute_from <=> hour_to:minute_to'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('LOCATING_PDA_ENABLED', 203, 0, '0', 'Enables (= 1) locating by PDA'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTOMAILER_STARTTIME_IN_DAYS', 203, 0, '3', 'Current date minus this days the mails are sent automatically'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTOMAILER_LOGFILE', 203, 0, '../log/automailer.log', 'Location of the logfile of the automailer'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTOMAILER_ENABLED', 203, 0, '1', 'Enables (=1) the automatic mode to send customer mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('LOG_DB', 203, 0, '1', 'Logs (= 1) e.g. all job movements into the database'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_SWITCH_SUBSTR2LEFTRIGHT', 203, 0, '', 'Enables (= 1) the switch to use range of "substr(valueToBeExported)" as "left()" and "right()"'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_FILES_ON_SERVER_CUSTOMER', 203, 0, '10', 'Max. of export files left on the server (ONLY customer)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_FILES_ON_SERVER', 203, 0, '100', 'Max. of export files left on the server (ONLY headquarter)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_FILTER_NO_DRIVER', 203, 0, '1', 'Enables (= 1) the filter to export only couriers refereing NO parent id'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_FILTER_NO_CASHPAYER', 203, 0, '1', 'Enables (= 1) the filter to export only debitors not being a cashpayer'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_FILTER_EID_LENGTH', 203, 0, '', 'Enables (> 0) the filter to export only debitors having a EID with x chars'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SEARCH_CSCSCLIST_CMPCOMP_CSCADPHONE', 203, 0, '1', 'Searches (= 1) the search value of cmp.cmp_comp in both fields (cmp.cmp_comp AND cscad.cscad_phone)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SEARCH_CSCSCLIST_CMPCOMP_CSEID', 203, 0, '1', 'Searches (= 1) the search value of cmp.cmp_comp in both fields (cmp.cmp_comp AND cs.cs_eid)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SEARCH_CSCSCLIST_CMPCOMP_CMPMATCH', 203, 0, '1', 'Searches (= 1) the search value of cmp.cmp_comp in both fields (cmp.cmp_comp AND cmp.cmp_match)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOKE_JOB_MODE', 203, 0, '0', '(=0): Revokes ALL jobs (assigned by autoranking AND manually), (=1): Revokes ONLY jobs assigned by autoranking, NOT assigned manually, (=2): Revokes ONLY jobs assigned manually, NOT assigned by autoranking'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOKETIME_MANUELL_IN_SECONDS', 203, 0, '0', 'x seconds after MANUELL assignment the job will be revoked if jb_status = 0 (IMPORTANT: Both values (AUTORANKING_REVOKETIME_IN_MINUTES and AUTORANKING_REVOKETIME_IN_SECONDS) will be added!!!)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOKETIME_MANUELL_IN_MINUTES', 203, 0, '3', 'x minutes after MANUELL assignment the job will be revoked if jb_status = 0 (IMPORTANT: Both values (AUTORANKING_REVOKETIME_IN_MINUTES and AUTORANKING_REVOKETIME_IN_SECONDS) will be added!!!)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOKETIME_IN_SECONDS', 203, 0, '0', 'x seconds after AUTOMATIC assignment the job will be revoked if jb_status = 0'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOKETIME_IN_MINUTES', 203, 0, '1', 'x minutes after AUTOMATIC assignment the job will be revoked if jb_status = 0'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_MAXNUMBER_OF_CHALLENGES', 203, 0, '2', 'Max number of challenges a courier can challenge a specified job'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_NUMBER_OF_ITERATIONS', 203, 0, '2', 'Number of iterations for each list (favoured couriers or mediation area couriers, etc.)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_LOGFILE', 203, 0, '../log/autoranking.log', 'Location of the logfile of the autoranking'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_REVOCATION_ENABLED', 203, 0, '1', 'Enables (=1) the revocation of the jobs inside the autoranking process'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_ASSIGNMENT_ENABLED', 203, 0, '0', 'Enables (=1) the assignment of the jobs inside the autoranking process'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('RANKING_CR2CRVH_MULTI_RELATION', 203, 0, '1', 'Enables (=1) the "MUST-association" between courier and vehicle (cr.cr_id = crvh.cr_id)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('RANKING_FAVOURED_COURIER_FOR_PAYER', 203, 0, '1', 'Enables (=1) the request for the favoured couriers for the payer(s) of the tour'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('RANKING_FAVOURED_COURIER_FOR_STATION', 203, 0, '0', 'Enables (=1) the request for the favoured couriers for the station(s) of the tour'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('STATISTIC_NO_STORNOJOBS', 203, 0, '1', 'Enables the exclusion of storno jobs (only for the "count()" statements)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIERDETAILS_TARGET', 203, 0, '1', '(= 0) Old mode with frames / (= 1) Opens couriers details in separate window'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CUSTOMERDETAILS_TARGET', 203, 0, '1', '(= 0) Old mode with frames / (= 1) Opens customer details in separate window'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBDETAILS_USER_HISTORY', 203, 0, '1', '(= 0) Displays only the creator of the job / (= 1) Displays the history of the employees of the job'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_CR_FAVOURED', 203, 0, '0', 'Get the existence of favoured couriers from table "job" (history) (=0) or from table "customercourier" (current state) (=1)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_TOTALPRICE', 203, 0, '0', 'Get the total price from table "job" (=0) or from table "tourservice" (=1)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_VEHICLE_FILTER', 203, 0, 'L1,L2,L3,L4,L5,L6,L7', 'In the joblist only show these specified filters behind the vehicle type if at least one of them matches the filter specified in the job'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_ALERT_LEG_TIME_SECONDS', 203, 0, '300', 'Time between each done leg of the tour (leg 1 and leg 2, leg 2 and leg 3, ...) the courier has needed to finish'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_LENGTH_TOURNAME', 203, 0, '20', 'Length of the tourname displayed in the joblists'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_CANCELLATION_WITH_COSTS', 203, 0, '0', 'Enables (= 1) the explicit request for cancallation WITH costs'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CUSTOMER_SHOW_LIST', 203, 0, '0', 'Shows (= 1) the customer list after modification/insertion of a (new) customer'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_MAXCOLS_EXPORT', 203, 0, '70', 'Max columns for a line in invoice fields job.jb_invtext and job.jb_freetext_2 to be exported'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_MAXCOLS', 203, 0, '50', 'Max columns for a line in invoice fields job.jb_invtext and job.jb_freetext_2 to be shown'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CUSTOMER_EID_LENGTH', 203, 0, '6', 'Length of the customer EID to be at least (e.g. for the export)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIER_EID_LENGTH', 203, 0, '6', 'Length of the courier EID to be at least (e.g. for the export)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIER_FREETIME_MINUTES', 203, 0, '30', 'Time before ordertime a courier is considered free: Minutes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIER_FREETIME_HOURS', 203, 0, '0', 'Time before ordertime a courier is considered free: Hours'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIER_SORT_BY_OCCUPIED', 203, 0, '1', 'Enables (= 1) or disables (= 0) two lists of couriers in the disposition separated by occupation-status'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_LOCKTIME_TIMEOUT', 203, 0, '5', 'Timeout in minutes for locks in database'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_DATE_PLUSOFFSETDAYS', 203, 0, '2', 'Offset in days (today plus offset)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_DATESELECTFIELDS_ENABLED', 203, 0, '0', 'Enables (= 1) or disables (= 0) select-fields for the date'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_WAITTIME_ENABLED', 203, 0, '0', 'Enables (= 1) or disables (= 0) waittime'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_SINGLE_INVOICE', 203, 0, '0', 'Enables (= 1) or disables (= 0) the possibility to open more than one invoice window'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_BROWSE_MAX', 203, 0, '100', 'Number of rows to be displayed to browse'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_SINGLE_JOBEDIT', 203, 0, '0', 'Enables (= 1) or disables (= 0) the possibility to open more than one job-edit window'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_MULTI_JOBLIST_MAX', 203, 0, '4', 'Upper range of job lists to be displayed'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_MULTI_JOBLIST', 203, 0, '1', 'Number of job lists'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ENCRYPT_FILEEXTENSION', 203, 0, 'gpg', 'Extension of the encrypted files (e.g. export data files)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBLIST_DEFAULTLIST', 203, 0, '8,9,0,1', 'Default list(s) to be displayed entering the joblist view (e.g.: 1. list <=> jb_status = 8, 2. list <=> jb_status = 9, etc.)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('GPG_PATH', 203, 0, '', 'Path to the executable of GnuPG'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ENCRYPT_EXPORTDATA', 203, 0, '0', 'Enables (= 1) or disables (= 0) the encryption of the export data according to an existing public key und key user'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_AUTO_REFRESH', 203, 0, '0', 'Enables (= 1) or disables (= 0) the automatic refresh of courier-lists'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EMAIL_CRVHSID_NO_MAIL', 203, 0, '1777,1888', 'Defines vehicles (comma separated list) where no automatic finished mail will be generated'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EMAIL_ENABLED', 203, 0, '1', 'Enables (= 1) or disables (= 0) the global mail activities'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CR_SID_STATUS', 203, 0, '0', 'Contains the status if SID is activated in table "courier" for unique handling and frontend ("0" = disabled [default], "1" = enabled)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAX_CARDINALITY', 203, 0, '300', 'Specifies the maximum of the cardinality of a specified table, used to check for empty search filters. If all are empty and the cardinality is less than MAX_CARDINALITY then show all table-rows'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('NUM_ROWS_ZIPCODEAREA_MATRIX', 203, 0, '10', 'Number of rows and cols of the zipcodearea-matrix to be displayed'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('NUM_ROWS_ZIPCODE_MATRIX', 203, 0, '10', 'Number of rows and cols of the zipcode-matrix to be displayed'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ZIPCODEAREA_PADLENGTH', 203, 0, '4', 'Length of the name of the zipcodesareas (e.g.: "57" => "0057")'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ZIPCODE_LENGTH', 203, 0, '5', 'Length of the zipcodes (currently in Germany it is "5")'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('COUNTRY_FON_PREFIX', 203, 0, '49', 'Fon-prefix of the country'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('LATEST_TAKETIME_IN_MINUTES', 203, 0, '30', 'Default-time for the latest taketime of a job'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('JB_TAX_RATE_SIGN', 203, 0, 'OM', 'Default export value for tax rate'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CMP_BANKMODE_DEBITNOTE', 203, 0, 'L', 'Default if bank-mode is debitnote'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('JB_PAYMODE_CASH', 203, 0, 'BZ', 'Default if paying mode is cash (no invoice)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ROW_EDIT_STATUS_DELETE', 203, 0, 'L', 'Default if a row will be removed (e.g. for export)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CMP_BANKMODE_INVOICE', 203, 0, '', 'Default if bank-mode is invoice'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ROW_EDIT_STATUS_NEW', 203, 0, 'N', 'Default if a row is new (e.g. for export)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('ROW_EDIT_STATUS_MODIFY', 203, 0, 'A', 'Default if a row becomes changed (e.g. for export)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAXIMUM_SEARCH_RADIUS', 203, 0, '20', 'Maximum radius in kilometers to search for surrounding zipcode-districts from a zipcode-district a courier is located in'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('LOCATING_MODE', 203, 0, '0', 'Mode of locating ("0"=Polygon [DEFAULT], "1"=Pythagoras)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('GEO_EARTH_RADIUS', 203, 0, '6371.0', 'Radius of the earth in kilometers [GEO_EARTH_RADIUS is set to the mean value: 6371. km; (equatorial radius as of WGS84: 6378.137 km)]'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAXIMUM_LOGIN_TRIALS', 203, 0, '100', 'Maximum number of login-trials before denying the access'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AD_STATUS', 203, 0, '1', 'Checks address in Adress-Table ("1/0" = Check enabled/disabled), DEFAULT = "1")'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MG_STATUS', 203, 0, '0', 'Checks address in M&G-Server ("1/0" = Check enabled/disabled), DEFAULT = "1")'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('TA_STATUS', 203, 0, '1', 'Transaction-Mode ("1/0" = Enabled/Disabled [InnoDB], Only "0" = Disabled [MyISAM])'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('HTTP_VARS_SEC_SEQ', 203, 0, '__', 'Changable identificator to identify an encrypted parameter to be decrypted'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('HTTP_VARS_SEC_STATE', 203, 0, '1', 'Enables functionality according the functions "ec()" and "dc()"'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_PATH', 203, 0, '../export/download/', 'Path to store the exportfiles'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SIGNS_PATH', 203, 0, '../temp/signs/', 'Path to store and remove the signs temporarly for sending mails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('IMAGES_PATH', 203, 0, '/phoenix/images/', 'Not in use'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('FTP_PASSWORD', 203, 0, 'gx25ta%', 'FTP password'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('FTP_UPLOADPATH', 203, 0, '/stadtbote/', 'FTP upload path where files will be stored'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('FTP_SERVER', 203, 0, 'mi2ju.de', 'FTP server'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('FTP_USER', 203, 0, 'u34847762', 'FTP user'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('DB_FIELDTYPE_WRAPPER_1', 203, 0, '1', 'Enables the wrapper function ONLY for "timestamp" => "datetime" (1 = Enabled)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JB_TYPE_DEFAULT', 203, 0, '2', 'Default value for jb_type (Stadtbote: 0, Hansetrans: 2)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_MANUAL_DISPOSITION', 203, 0, '1', 'Checkbox for manual disposition is checked: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CALCULATOR', 203, 0, '1', 'Additional button for calculations: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_SERVICE_PRICE', 203, 0, '1', 'Additional field for jb_service_price: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CHECK_DISCOUNT', 203, 0, '1', 'Checkbox for discount if customer has global discount: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAIL_BCC_ADDRESS', 203, 0, 'b.transport@hansetrans.de', 'Mail Bcc address'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAIL_CC_ADDRESS', 203, 0, '', 'Mail Cc address'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COURIER_NEWBIE_TIME', 203, 0, '30', 'The courier is marked as newbie when the courier\'s first finished job is within a certain time in the past (time in days)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MAIL_SENDER_ADDRESS', 203, 0, 'b.transport@hansetrans.de', 'Mail address of the sender'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CSC_ID_PAYER_EXTERN', 203, 0, '44541', 'csc_id of extern costcenter'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_ASK_DEFAULTPAYER_CHANGE', 203, 0, '1', 'Ask if default-payer is to be changed: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CREATE_EXTERN_COSTCENTER', 203, 0, '0', 'Create new costcenter for unspecified customers in mask (1=yes, 0=no)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CASH_PAYER_SELECT', 203, 0, '1', 'Cash payer must be selected: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_FAVOURED_COURIER_MANUAL', 203, 0, '1', 'No autoranking for jobs with customers who have favoured couriers = 1, do not bother about favoured couriers = 0'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_COMMISSION_NO', 203, 0, '1', 'Button for commission number always enabled = 1, enabled only for specified customers = 0'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_VEHICLE_LKW', 203, 0, '1', 'Vehicle number a LKW driver get jobs from autoranking (e.g. "5" => Bus, Gr. Bus und LKW // "7" => Only LKW)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_PRINT_DISCOUNT', 203, 0, '0', 'Print discount (if granted) in jb_invtext (0 = NO, 1 = YES)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('AUTORANKING_NEIGHBOUR_LEVEL', 203, 0, '1', 'Number of neighbour areas to be checked by autoranking process'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_PRINT_REMARK', 203, 0, '0', 'Print tr_remark in jb_invtext (0 = NO, 1 = YES)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CS_EID_EDITABLE', 203, 0, '1', 'Makes the EID-number of a customer editable (=1)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CR_EID_EDITABLE', 203, 0, '1', 'Makes the EID-number of a courier editable (=1)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CS_EID_GENERATION', 203, 0, 'HTLG950000', 'ONLY(!) for generating the next EID-number for inserting a new customer'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CR_EID_GENERATION', 203, 0, '28800', 'ONLY(!) for generating the next EID-number for inserting a new courier'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('RANKING_FAVOURED_COURIER_AREA_RESTRICTION', 203, 0, '0', 'Enables (=1) the filter for the favoured couriers beeing only in areas and not outside'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CSC_ID_PAYER_CASH', 203, 0, '6758', 'csc_id of cash-payer (HB = 4002 / HH = 4)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('EXPORT_HQ_KEY', 203, 0, '010', 'Headquarter key for export (e.g. "039" = "HB", "041" = "HH")'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MODE_INTERMEDIATION', 203, 0, '2', 'Mode of intermediation (0 = Services, 1 = Zipcode, 2 = Zipcode area, 3 = Combined mode)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('HQ_ID_DEFAULT', 203, 0, '203', 'Number of current headquarter'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('PATH_DOCROOT', 203, 0, '/home/www/hansetrans', 'Document root path (e.g. for autoranking_keepalive)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('SERVICE_DISPLAY_MODE_DEFAULT', 203, 0, '1', 'Defines the mode displayed by entering Services'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MANDATOR_SERVICE_ENABLED', 203, 0, '0', NULL); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_JB_CR_PRICE', 203, 0, '1', 'show additional column in invoice-module in courier-mode ("0" = no, "1" = yes)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('CSC_ID_PAYER_CALCULATOR', 203, 0, '6558', 'costcenter-id for courier-splitting in the calculator'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_SHOW_CR_ID_PARENT', 203, 0, '1', 'show jobs of sub-couriers that are connected by `cr_id_parent` in the portfolio of the main courier (0 = no, 1 = yes)'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CALCULATOR_TYPE', 203, 0, '1', 'enable selection of field `jb_type` in calculator: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CALCULATOR_SRV', 203, 0, '1', 'enable selection of services in calculator: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_MAXLINES', 203, 0, '50', 'Max columns for a line in invoice fields jb_invtext'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_MAXTOUR', 203, 0, '10', 'max no. of addresses in one job'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_CSC_ID_NOAUTO', 203, 0, '', 'dont`t generate automatic text in invoice if this csc_id is the first one in the tour-list'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MODE_LATER_JOB_WITH_NORMAL', 203, 0, '0', 'additional link to `normal` mask in mode `MODE_LATER_JOB`: 0 = no, 1 = yes'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_JOBDETAILS_BOOKJOB_DATE', 203, 0, '1', 'Default date for booking jobs in jobdetails'); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CR_LIST_COLS', 203, 0, 'cr_sid,crvh_vh_sign,cr_eid,crvh_prov,usr_name,usr_firstname,usr_phone,cr_mobile_pda,cmp_authenticated_img,cr_id_history,cmp_id_edit', 'Structure of the courier list '); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('MASK_CS_LIST_COLS', 203, 0, 'cmp_comp,cmp_comp2,ad_street,ad_zipcode,cmp_match,cs_eid,usr_phone,usr_email,csc_id_jb_edit,cs_id_history,cmp_authenticated_img,cs_id_jb_permanent,cmp_id_edit', 'Structure of the courier list '); INSERT INTO parameter (par_key, hq_id, emp_id, par_value, par_text) VALUES ('INV_PRINT_METATYPE_SERVICE', 203, 0, '1', 'dont`t generate text "(mit Service)" in invoice: 0 = no, 1 = yes'); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 1, '2-,-35-,-l-,-2-,--,-0-,- -,--,--;-3-,-35-,-l-,-3-,- |-,-0-,- -,--,--;-7-,-15-,-l-,-11-,--,-0-,- -,--,-25=L-;-8-,-18-,-l-,-12-,--,-0-,- -,--,-25=L-;-10-,-35-,-l-,-16-,--,-0-,- -,--,--;-12-,-35-,-l-,-8-,--,-0-,- -,--,--;-13-,-16-,-l-,-9-,--,-0-,- -,--,--;-15-,-31-,-l-,-10-,-003|ZA10|X|Kunde seit: 24 |0001| |-,-0-,- -,--,--;-18-,-30-,-l-,-4-,--,-1-,- -,--,--;-19-,-5-,-l-,-5-,--,-0-,- -,--,--;-20-,-10-,-l-,-7-,--,-0-,- -,--,--;-21-,-35-,-l-,-6-,--,-0-,- -,--,--;-23-,-10-,-r-,-1-,-041 |039 |K |01|-,-0-,-0-,--,--;-24-,-1-,-l-,-0-,--,-0-,- -,--,--;-26-,-1-,-l-,-13-,-000001|91|91|1|91|01|-,-0-,- -,--,--;-27-,-5-,-r-,-15-,-099|01|9F|J| |320 |W0|-,-0-,-0-,-3-,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 1, '2-,-35-,-l-,-3-,--,-0-,- -,--,--,- -,- -,-0-;-3-,-35-,-l-,-4-,--,-0-,- -,--,--,- -,- -,-0-;-7-,-15-,-l-,-14-,--,-0-,- -,--,-25=L-,- -,- -,-0-;-8-,-18-,-l-,-15-,--,-0-,- -,--,-25=L-,- -,- -,-0-;-10-,-20-,-l-,-21-,-|-,-0-,- -,--,--,- -,- -,-0-;-11-,-15-,-l-,-20-,--,-1-,- -,--,--,- -,- -,-0-;-12-,-35-,-l-,-10-,--,-0-,- -,--,--,- -,- -,-0-;-13-,-16-,-l-,-11-,--,-0-,- -,--,--,- -,- -,-0-;-15-,-31-,-l-,-12-,-003|ZA10|X|Kunde seit: 24 |0001| |-,-0-,- -,--,--,- -,- -,-0-;-23-,-10-,-r-,-1-,-010 |-,-0-,-0-,--,--,- -,- -,-0-;-24-,-1-,-l-,-0-,--,-0-,- -,--,--,- -,- -,-0-;-26-,-1-,-l-,-16-,-000001|91|91|1|91|-,-0-,- -,--,--,- -,- -,-0-;-27-,-5-,-r-,-18-,-099|28|9F|J| |-,-0-,-0-,-3-,--,- -,- -,-0-;-29-,-2-,-l-,-17-,--,-0-,- -,--,--,- -,- -,-0-;-31-,-10-,-l-,-5-,--,-0-,- -,--,--,- -,- -,-0-;-40-,-4-,-l-,-19-,-W0|-,-0-,- -,--,--,- -,- -,-0-;-42-,-30-,-l-,-6-,--,-1-,- -,--,--,- -,- -,-0-;-43-,-5-,-l-,-7-,--,-0-,- -,--,--,- -,- -,-0-;-44-,-10-,-l-,-9-,--,-0-,- -,--,--,- -,- -,-0-;-45-,-35-,-l-,-8-,--,-0-,- -,--,--,- -,- -,-0-;-53-,-4-,-l-,-2-,-G |01|-,-0-,- -,--,--,- -,- -,-0', '', '', '', '', 'RETRANS Debitorenstammsatz', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 2, '1090-,-1-,-l-,-0-,--,-0-,- -,--,--;-1360-,-10-,-r-,-1-,--,-0-,-0-,--,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 2, '1010-,-35-,-l-,-4-,--,-0-,- -,--,--,- -,- -,-0-;-1020-,-35-,-l-,-5-,-12,0,9,10|-,-0-,- -,--,--,- -,- -,-0-;-1030-,-11-,-l-,-19-,--,-0-,- -,--,--,- -,- -,-0-;-1040-,-20-,-l-,-18-,--,-0-,- -,--,--,- -,- -,-0-;-1060-,-15-,-l-,-15-,--,-0-,- -,--,--,- -,- -,-0-;-1070-,-18-,-l-,-16-,-ZA10|-,-0-,- -,--,--,- -,- -,-0-;-1090-,-1-,-l-,-0-,--,-0-,- -,--,--,- -,- -,-0-;-1160-,-16-,-l-,-12-,--,-0-,- -,--,--,- -,- -,-0-;-1280-,-31-,-l-,-13-,-003|X|-,-0-,- -,--,--,- -,- -,-0-;-1290-,-30-,-l-,-7-,--,-1-,- -,--,--,- -,- -,-0-;-1300-,-5-,-l-,-8-,--,-0-,- -,--,--,- -,- -,-0-;-1310-,-10-,-l-,-10-,- |-,-0-,- -,--,--,- -,- -,-0-;-1320-,-35-,-l-,-9-,--,-0-,- -,--,--,- -,- -,-0-;-1360-,-10-,-r-,-1-,--,-0-,-0-,--,--,- -,-5-,-1-;-1400-,-4-,-l-,-3-,- |-,-0-,- -,--,--,- -,- -,-0-;-1410-,-4-,-l-,-2-,--,-0-,- -,--,--,- -,- -,-0', '', '', '', '', 'RETRANS Kreditorenstammsatz', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 3, '1090-,-1-,-l-,-0-,--,-0-,- -,--,--;-1360-,-10-,-r-,-1-,--,-0-,-0-,--,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 3, '2030-,-4-,-r-,-4-,- | |-,-0-,- -,--,--,- -,-3-,-1-;-2040-,-12-,-l-,-2-,--,-0-,- -,--,--,- -,- -,-0-;-2060-,-5-,-l-,-3-,--,-0-,- -,-11-,--,- -,- -,-0-;-2080-,-5-,-r-,-8-,--,-0-,-0-,-1-,--,- -,- -,-0-;-2090-,-5-,-l-,-7-,--,-0-,- -,--,--,- -,- -,-0-;-2100-,-5-,-l-,-12-,- | | |-,-0-,- -,--,--,- -,- -,-0-;-2110-,-50-,-l-,-9-,- G |-,-0-,- -,--,--,- -,- -,-0-;-2120-,-30-,-l-,-16-,--,-0-,- -,--,--,- -,- -,-0-;-2130-,-30-,-l-,-17-,-01|-,-0-,- -,--,--,- -,- -,-0-;-2150-,-1-,-l-,-18-,--,-0-,- -,--,--,- -,- -,-0-;-2300-,-10-,-l-,-1-,--,-0-,- -,--,--,- -,- -,-0-;-2350-,-6-,-r-,-0-,--,-0-,-0-,--,--,- -,- -,-0', '', '', '', '', 'RETRANS Fahrzeugstammsatz', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 4, '1373-,-4-,--,-0-,--,-0-,- -,--,--;-1374-,-2-,--,-1-,--,-0-,- -,--,--;-1375-,-10-,-r-,-2-,--,-0-,- -,--,--;-1376-,-8-,--,-3-,--,-0-,- -,--,--;-1377-,-5-,--,-4-,--,-0-,- -,--,--;-1378-,-8-,--,-5-,--,-0-,- -,--,--;-1379-,-5-,--,-6-,--,-0-,- -,--,--;-1380-,-9-,-r-,-7-,--,-0-,- -,--,--;-1381-,-2-,--,-8-,--,-0-,- -,--,--;-1382-,-2-,--,-9-,--,-0-,- -,--,--;-1383-,-13-,--,-10-,--,-0-,- -,--,--;-1384-,-10-,--,-11-,--,-0-,- -,--,--;-1385-,-10-,--,-12-,--,-0-,- -,--,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 4, '3000-,-4-,-l-,-0-,--,-0-,- -,--,--,- -,- -;-3020-,-10-,-r-,-2-,--,-0-,-0-,--,--,- -,- -;-3025-,-4-,-r-,-3-,- |-,-0-,- -,--,--,- -,- -;-3030-,-8-,-l-,-4-,--,-0-,- -,--,--,- -,- -;-3040-,-5-,-l-,-5-,--,-0-,- -,--,--,- -,- -;-3050-,-8-,-l-,-6-,--,-0-,- -,--,--,- -,- -;-3060-,-5-,-l-,-7-,-3|-,-0-,- -,--,--,- -,- -;-3070-,-9-,-r-,-8-,-000| |-,-0-,-0-,--,--,- -,- -;-3090-,-2-,-l-,-10-,- | |-,-0-,- -,--,--,- -,- -;-3100-,-10-,-r-,-14-,-0000000|0000000000| |00000|00000| |0000|0000|00|0000|00000000|000000000| |-,-0-,-0-,-3-,--,- -,- -;-3110-,-10-,-r-,-15-,-00000000000000|-,-0-,-0-,--,--,- -,- -;-3120-,-10-,-r-,-16-,--,-0-,-0-,--,--,- -,- -;-3130-,-70-,-l-,-18-,-14,70,140,70|14,140,210,70|14,210,280,70|-,-0-,- -,--,--,- -,- -;-3140-,-2-,-l-,-11-,--,-0-,- -,--,--,- -,- -;-3160-,-2-,-l-,-9-,--,-0-,- -,--,--,- -,- -;-3180-,-70-,-l-,-19-,-19,70,140,70|19,140,210,70|19,210,280,70|19,280,350,70|19,350,420,70||-,-0-,- -,--,--,- -,- -;-3200-,-4-,-r-,-20-,-0000000|0000|0000000|0000000|0000|0000000| |-,-0-,-0-,-3-,--,- -,- -;-3210-,-2-,-l-,-12-,--,-0-,- -,--,--,- -,- -;-3220-,-2-,-l-,-13-,- | | |-,-0-,- -,--,--,- -,- -;-3230-,-40-,-l-,-17-,- |-,-0-,- -,--,--,- -,- -;-3270-,-2-,-l-,-1-,--,-0-,- -,--,--,- -,- ', '', '', '', '', 'RETRANS Abrechnungen', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 4, '3000-,-4-,-l-,-0-,--,-0-,- -,--,--,- -,- -;-3010-,-2-,-l-,-1-,--,-0-,- -,--,--,- -,- -;-3020-,-10-,-r-,-2-,--,-0-,-0-,--,--,- -,- -;-3025-,-4-,-r-,-3-,- |-,-0-,- -,--,--,- -,- -;-3030-,-8-,-l-,-4-,--,-0-,- -,--,--,- -,- -;-3040-,-5-,-l-,-5-,--,-0-,- -,--,--,- -,- -;-3050-,-8-,-l-,-6-,--,-0-,- -,--,--,- -,- -;-3060-,-5-,-l-,-7-,-3|-,-0-,- -,--,--,- -,- -;-3070-,-9-,-r-,-8-,-000| |-,-0-,-0-,--,--,- -,- -;-3090-,-2-,-l-,-10-,- | |-,-0-,- -,--,--,- -,- -;-3100-,-10-,-r-,-12-,-0000000|0000000000| |00000|00000| |0000|0000|00|0000|00000000|000000000| |-,-0-,-0-,-3-,--,- -,- -;-3110-,-10-,-r-,-13-,-00000000000000|-,-0-,-0-,--,--,- -,- -;-3120-,-10-,-r-,-14-,- | |-,-0-,-0-,--,--,- -,- -;-3130-,-70-,-l-,-15-,-|0000|0000000|0000|0000000|0000000|0000|0000000| |-,-0-,- -,--,--,- -,- -;-3140-,-2-,-l-,-11-,-RZ| | | | |-,-0-,- -,--,--,- -,- -;-3160-,-2-,-l-,-9-,--,-0-,- -,--,--,- -,- ', '', '', '', '', 'RETRANS Abrechn. Kopie', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 5, '1373-,-4-,--,-0-,--,-0-,- -,--,--;-1374-,-2-,--,-1-,--,-0-,- -,--,--;-1375-,-10-,-r-,-2-,--,-0-,- -,--,--;-1376-,-8-,--,-3-,--,-0-,- -,--,--;-1377-,-5-,--,-4-,--,-0-,- -,--,--;-1378-,-8-,--,-5-,--,-0-,- -,--,--;-1379-,-5-,--,-6-,--,-0-,- -,--,--;-1380-,-9-,-r-,-7-,--,-0-,- -,--,--;-1381-,-2-,--,-8-,--,-0-,- -,--,--;-1382-,-2-,--,-9-,--,-0-,- -,--,--;-1383-,-13-,--,-10-,--,-0-,- -,--,--;-1384-,-10-,--,-11-,--,-0-,- -,--,--;-1385-,-10-,--,-12-,--,-0-,- -,--,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 5, '3300-,-4-,-l-,-0-,--,-0-,- -,--,--,- -,- -,-0-;-3320-,-10-,-r-,-2-,--,-0-,-0-,--,--,- -,- -,-0-;-3325-,-4-,-r-,-3-,- |-,-0-,- -,--,--,- -,- -,-0-;-3330-,-8-,-l-,-4-,--,-0-,- -,--,--,- -,- -,-0-;-3340-,-5-,-l-,-5-,--,-0-,- -,--,--,- -,- -,-0-;-3350-,-8-,-l-,-6-,--,-0-,- -,--,--,- -,- -,-0-;-3360-,-5-,-l-,-7-,-3|-,-0-,- -,--,--,- -,- -,-0-;-3370-,-9-,-r-,-8-,-000| |-,-0-,-0-,--,--,- -,- -,-0-;-3390-,-2-,-l-,-10-,- | |-,-0-,- -,--,--,- -,- -,-0-;-3400-,-10-,-r-,-14-,-0000000|0000000000| |00000|00000| |0000|0000|00|0000|00000000|-,-0-,-0-,-3-,--,- -,- -,-0-;-3410-,-10-,-r-,-17-,-00000000000000|-,-0-,-0-,--,--,- -,- -,-0-;-3420-,-10-,-r-,-18-,--,-0-,-0-,--,--,- -,- -,-0-;-3430-,-70-,-l-,-20-,-14,70,140,70|14,140,210,70|14,210,280,70|14,280,350,70|14,350,420,70|14,420,490,70|14,490,560,70|14,560,630,70|14,630,700,70|14,700,770,70|14,770,840,70|14,840,910,70|14,910,980,70|14,980,1050,70|14,1050,1120,70|14,1120,1190,70|14,1190,1260,70|14,1260,1330,70|14,1330,1400,70|14,1400,1470,70|14,1470,1540,70|14,1540,1610,70|14,1610,1680,70|14,1680,1750,70|14,1750,1820,70|14,1820,1890,70|14,1890,1960,70|14,1960,2030,70|14,2030,2100,70|14,2100,2170,70|14,2170,2240,70|14,2240,2310,70|14,2310,2380,70|14,2380,2450,70|14,2450,2520,70|14,2520,2590,70|14,2590,2660,70|14,2660,2730,70|14,2730,2800,70|14,2800,2870,70|14,2870,2940,70|14,2940,3010,70|14,3010,3080,70|14,3080,3150,70|14,3150,3220,70|14,3220,3290,70|14,3290,3360,70|14,3360,3430,70|14,3430,3500,70|-,-0-,- -,--,--,- -,- -,-0-;-3440-,-2-,-l-,-11-,--,-0-,- -,--,--,- -,- -,-0-;-3460-,-2-,-l-,-9-,--,-0-,- -,--,--,- -,- -,-0-;-3500-,-4-,-r-,-22-,-0000000|0000|0000000|0000000|0000|0000000| |-,-0-,-0-,-3-,--,- -,- -,-0-;-3510-,-2-,-l-,-12-,--,-0-,- -,--,--,- -,- -,-0-;-3520-,-2-,-l-,-13-,- | | |-,-0-,- -,--,--,- -,- -,-0-;-3530-,-40-,-l-,-19-,- |-,-0-,- -,--,--,- -,- -,-0-;-3570-,-2-,-l-,-1-,--,-0-,- -,--,--,- -,- -,-0-;-3592-,-9-,-r-,-16-,- |-,-0-,-0-,--,--,- -,- -,-0-;-3596-,-8-,-r-,-15-,--,-0-,-0-,-3-,--,- -,- -,-0', '', '', '', '', 'RETRANS Abrechnungen', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 6, '1373-,-4-,--,-0-,--,-0-,- -,--,--;-1374-,-2-,--,-1-,--,-0-,- -,--,--;-1375-,-10-,-r-,-2-,--,-0-,- -,--,--;-1376-,-8-,--,-3-,--,-0-,- -,--,--;-1377-,-5-,--,-4-,--,-0-,- -,--,--;-1378-,-8-,--,-5-,--,-0-,- -,--,--;-1379-,-5-,--,-6-,--,-0-,- -,--,--;-1380-,-9-,-r-,-7-,--,-0-,- -,--,--;-1381-,-2-,--,-8-,--,-0-,- -,--,--;-1382-,-2-,--,-9-,--,-0-,- -,--,--;-1383-,-13-,--,-10-,--,-0-,- -,--,--;-1384-,-10-,--,-11-,--,-0-,- -,--,--;-1385-,-10-,--,-12-,--,-0-,- -,--,-', '', '', '', '', 'DEFAULT', NULL); INSERT INTO exportparameters (hq_id, cs_id, expc_id, expp_parstr, expp_bolchars, expp_eolchars, expp_bofchars, expp_eofchars, expp_name, expp_fileextension) VALUES (203, 0, 6, '3700-,-4-,-l-,-0-,--,-0-,- -,--,--,- -,- -,-0-;-3720-,-10-,-r-,-2-,--,-0-,-0-,--,--,- -,- -,-0-;-3725-,-4-,-r-,-3-,- |-,-0-,- -,--,--,- -,- -,-0-;-3730-,-8-,-l-,-4-,--,-0-,- -,--,--,- -,- -,-0-;-3740-,-5-,-l-,-5-,--,-0-,- -,--,--,- -,- -,-0-;-3750-,-8-,-l-,-6-,--,-0-,- -,--,--,- -,- -,-0-;-3760-,-5-,-l-,-7-,-3|-,-0-,- -,--,--,- -,- -,-0-;-3770-,-9-,-r-,-8-,-000| |-,-0-,-0-,--,--,- -,- -,-0-;-3790-,-2-,-l-,-10-,- | |-,-0-,- -,--,--,- -,- -,-0-;-3800-,-10-,-r-,-14-,-0000000|0000000000| |00000|00000| |0000|0000|00|0000|00000000|-,-0-,-0-,-3-,--,- -,- -,-0-;-3810-,-10-,-r-,-17-,-00000000000000|-,-0-,-0-,--,--,- -,- -,-0-;-3820-,-10-,-r-,-18-,--,-0-,-0-,--,--,- -,- -,-0-;-3830-,-70-,-l-,-20-,-14,70,140,70|14,140,210,70|14,210,280,70|14,280,350,70|14,350,420,70|14,420,490,70|14,490,560,70|14,560,630,70|14,630,700,70|14,700,770,70|14,770,840,70|14,840,910,70|14,910,980,70|14,980,1050,70|14,1050,1120,70|14,1120,1190,70|14,1190,1260,70|14,1260,1330,70|14,1330,1400,70|14,1400,1470,70|14,1470,1540,70|14,1540,1610,70|14,1610,1680,70|14,1680,1750,70|14,1750,1820,70|14,1820,1890,70|14,1890,1960,70|14,1960,2030,70|14,2030,2100,70|14,2100,2170,70|14,2170,2240,70|14,2240,2310,70|14,2310,2380,70|14,2380,2450,70|14,2450,2520,70|14,2520,2590,70|14,2590,2660,70|14,2660,2730,70|14,2730,2800,70|14,2800,2870,70|14,2870,2940,70|14,2940,3010,70|14,3010,3080,70|14,3080,3150,70|14,3150,3220,70|14,3220,3290,70|14,3290,3360,70|14,3360,3430,70|14,3430,3500,70|0000|0000000|0000|0000000|0000000|0000|0000000| |-,-0-,- -,--,--,- -,- -,-0-;-3840-,-2-,-l-,-11-,--,-0-,- -,--,--,- -,- -,-0-;-3860-,-2-,-l-,-9-,--,-0-,- -,--,--,- -,- -,-0-;-3910-,-2-,-l-,-12-,--,-0-,- -,--,--,- -,- -,-0-;-3920-,-2-,-l-,-13-,- | | |-,-0-,- -,--,--,- -,- -,-0-;-3930-,-40-,-l-,-19-,- |-,-0-,- -,--,--,- -,- -,-0-;-3970-,-2-,-l-,-1-,--,-0-,- -,--,--,- -,- -,-0-;-3992-,-9-,-r-,-16-,- |-,-0-,-0-,--,--,- -,- -,-0-;-3996-,-8-,-r-,-15-,--,-0-,-0-,-3-,--,- -,- -,-0', '', '', '', '', 'RETRANS Abrechnungen', NULL);