7. Liste verfügbarer Variablen für Textbausteine und FormulareKapitel hinzufügen
7..1 Order Fields
Die Auswahl der Felder hängt vom Auftragstyp und Dienst ab. Nicht verwendete Felder sind zwar leer jedoch definiert.
| Name der Variable | Typ | Länge der Variable | Beschreibung |
|---|---|---|---|
| or_id | integer | internal numerical order id | |
| or_scan_id | varchar | 60 | visible order id |
| or_document_id | varchar | 255 | unique document id |
| or_scan_path | varchar | 255 | relative path to scan folder |
| or_service | varchar | 50 | order service |
| or_type | varchar | 20 | technical order type |
| or_type1 | varchar | 20 | unused |
| or_type2 | varchar | 20 | unused |
| or_ext_order_id | varchar | 100 | external order od |
| or_eln_dept | >varchar | 20 | HeBIS-eln/dep combinition *DEPRECIATED* it has removed in ME-2.4.3 |
| or_institution | varchar | 20 | unused |
| or_institution_1 | varchar | 20 | unused |
| or_institution_2 | varchar | 20 | unused |
| or_del_service | varchar | 20 | delivery protocol |
| or_del_format | varchar | 20 | delivery format |
| or_document_imported | char(1) | import flag | |
| or_date_generate | datetime | date of generation | |
| or_date_acquire | datetime | date of acquisition | |
| or_date_scan | datetime | date of last scanning | |
| or_date_deliver | datetime | date of last delivery | |
| or_date_deadline | datetime | date of delivery deadline | |
| or_del_name | varchar | 100 | delivery name |
| or_del_add_on | varchar | 100 | delivery name add on |
| or_del_customer_no | varchar | 100 | delivery customer number |
| or_del_postbox | varchar | 100 | delivery postbox |
| or_del_org | varchar | 100 | delivery institution |
| or_del_street | varchar | 100 | delivery street |
| or_del_code | varchar | 10 | delivery postal code |
| or_del_city | varchar | 100 | delivery city |
| or_del_region | varchar | 100 | delivery region |
| or_del_country | varchar | 10 | delivery country |
| or_del_address | varchar | 255 | delivery formatted address |
| or_del_email | varchar | 255 | delivery email address |
| or_del_url | varchar | 255 | delivery ftp url |
| or_del_fax | varchar | 40 | delivery fax number |
| or_del_courier_name | varchar | 100 | delivery courier name |
| or_del_notes | varchar | 255 | delivery notes |
| or_del_status_requester | varchar | 10 | subito receipt level against requester |
| or_del_status_account | varchar | 10 | subito receipt level against accounting system |
| or_del_status_user | varchar | 10 | subito receipt level against user |
| or_dod_order_id | varchar | 10 | DOD internal order id |
| or_dod_customer_id | varchar | 10 | DOD internal customer id |
| or_m3_order_type | varchar | 255 | medea3 order type |
| or_m3_request_ins | varchar | 255 | medea3 requesting institution |
| or_m3_respond_inst | varchar | 255 | medea3 responding institution |
| or_m3_del_service | varchar | 255 | medea3 delivery service |
| or_m3_ext_1 | varchar | 255 | medea3 extension field 1 |
| or_m3_ext_2 | varchar | 255 | medea3 extension field 2 |
| or_m3_ext_3 | varchar | 255 | medea3 extension field 3 |
| or_m3_ext_4 | varchar | 255 | medea3 extension field 4 |
| or_m3_ext_5 | varchar | 255 | medea3 extension field 5 |
| or_cont_name | varchar | 100 | contact name |
| or_cont_phone | varchar | 100 | contact phone number |
| or_cont_email | varchar | 100 | contact email address |
| or_bill_type | enum | billing type | |
| or_bill_meth | enum | billing method | |
| or_bill_email | varchar | 255 | subito accounting system email address |
| or_bill_prepaid_id | varchar | 100 | billing prepaid info (TAN) |
| or_bill_name | varchar | 100 | billing surname or complete name |
| or_bill_name2 | varchar | 100 | billing forename |
| or_bill_add_on | varchar | 100 | billing name add on |
| or_bill_postbox | varchar | 100 | billing postbox |
| or_bill_org | varchar | 100 | billing institution |
| or_bill_street | varchar | 100 | billing street & number |
| or_bill_code | varchar | 10 | billing postal code |
| or_bill_city | varchar | 100 | billing city |
| or_bill_region | varchar | 100 | billing region |
| or_bill_country | varchar | 10 | billing country (code) |
| or_bill_address | varchar | 255 | billing address (formatted) |
| or_item_callname | varchar | 100 | item signature |
| or_item_type | varchar | 30 | item type |
| or_item_author | varchar | 255 | item main author |
| or_item_title | varchar | 255 | item main title |
| or_item_sub_title | varchar | 255 | item sub title |
| or_item_corporation | varchar | 255 | item sponsoring body |
| or_item_series_title | varchar | 255 | item series of title |
| or_item_edition | varchar | 100 | item edition |
| or_item_publisher | varchar | 100 | item publisher |
| or_item_publ_place | varchar | 100 | item publishing place |
| or_item_publ_date | varchar | 100 | item publishing date |
| or_item_publ_date_comp | varchar | 100 | item publishing gate |
| or_item_art_author | varchar | 100 | item article author |
| or_item_art_title | varchar | 255 | item article title |
| or_item_pagination | varchar | 100 | item pagination |
| or_item_note | varchar | 255 | item note |
| or_item_vol_issue | varchar | 100 | item volume |
| or_item_issn | varchar | 20 | item issn |
| or_item_isbn | varchar | 20 | item isbn |
| or_item_system_no | varchar | 100 | item source |
| or_item_ref_source | varchar | 100 | item reference source |
| or_item_add_no_lett | varchar | 100 | unused |
| or_service_type | char | 20 | requested loan service |
| or_service_level | char | 255 | date target attribite (urgency) |
| or_service_expiry | date | date to keep order valid until | |
| or_service_placeonhold | char | 1 | flag indicating if a delivery can be done delayed |
| or_req_id | varchar | 255 | subito requester id |
| or_req_sub_id | varchar | 255 | subito requester sub id |
| or_req_note | varchar | 255 | subito requester note |
| or_req_email | varchar | 255 | subito requester email address |
| or_req_group | varchar | 255 | subito requester user group |
| or_accounting_system_id | varchar | 255 | subito accounting system id |
| or_accounting_email | varchar | 255 | subito accounting system email address |
| or_accounting_del_type | varchar | 100 | subito accounting delivery type |
| or_forward_flag | char | 1 | forward flag |
| or_forward_type | varchar | 100 | forward type |
| or_forward_list | varchar | 255 | forward list |
| or_trans_group_qualifier | varchar | 20 | transaction-group-qualifier |
| or_trans_qualifier | varchar | 20 | transaction-qualifier |
| or_supplier_id | varchar | 25 | supplier id |
| or_responder_id | varchar | 25 | responder id |
| or_responder_sub_id | varchar | 255 | responder sub id (domain) |
| or_responder_address | varchar | 255 | responder address |
| or_responder_email | varchar | 100 | responder email address |
| or_country_del_target | char | 2 | country code |
| or_client_id | varchar | 150 | client-identifier |
| or_client_name | varchar | 25 | client name |
| or_order_state | varchar | 20 | order state |
| or_order_stage | varchar | 20 | order stage |
| or_delivered | char | 1 | internal flag delivered |
| or_deleted | char | 1 | internal flag deleted |
| or_scp | char | 1 | internal flag scp |
| or_ftp | char | 1 | internal flag ftp |
| or_web | char | 1 | internal flag web |
| or_webp | char | 1 | internal flag webpublished |
| or_faxed | char | 1 | internal flag faxed |
| or_mailed | char | 1 | internal flag mailed |
| or_printed | char | 1 | internal flag printed |
| or_scanned | char | 1 | internal flag scanned |
| or_invoiced | char | 1 | internal flag invoiced |
| or_invoice_id | integer | 1 | unused |
| or_num_pages | smallint | number of pages scanned | |
| or_num_pages_del | smallint | number of pages delivered | |
| or_num_pages_bill | smalint | number of pages billed | |
| or_remark | text | remark (manually) | |
| or_orig_order | text | original order text (email acquisition) | |
| or_recla | char | 1 | recla flag |
7..2 Order Service
| Name der Variablen | Typ | Länge der Variablen | Beschreibung |
|---|---|---|---|
| sos_id | smallint | 6 | numerical service id |
| sos_name | varchar | 50 | service name |
| sos_type | varchar | 50 | order type this service is based on |
| sos_info | varchar | 255 | additional info |
| sos_active | char | 1 | active flag |
| sos_deletable | char | 1 | deletable flag |
| sos_duplicate | char | 1 | check duplicate flag |
| sos_doc_id | varchar | 255 | internal document id |
| sos_scan_path | varchar | 255 | internal scan path |
| sos_suffix | varchar | 50 | suffix for scan id |
| sos_unifier | char | 1 | unifier flag |
| sos_form_flyleaf | int | 11 | id of flyleaf form |
| sos_initial_orderstate | varchar | 20 | initial order state |
| sos_initial_orderstage | varchar | 20 | initial order stage |
| sos_default_delformat | varchar | 20 | default delivery format |
| sos_force_delformat | char | 1 | force flag |
| sos_fallback_delformat | char | 1 | fallback flag |
| sos_default_delprotocol | varchar | 20 | default delivery protocol |
| sos_force_delprotocol | char | 1 | force flag |
| sos_fallback_delprotocol | char | 1 | fallback flag |
| sos_default_billtype | varchar | 20 | default billing type |
| sos_force_billtype | char | 1 | force flag |
| sos_fallback_billtype | char | 1 | fallback flag |
| sos_default_billmeth | varchar | 20 | default billing method |
| sos_force_billmeth | char | 1 | force flag |
| sos_fallback_billmeth | char | 1 | fallback flag |
| sos_default_domain | smallint | 6 | default domain assignment |
| sos_default_customergroup | smallint | 6 | id of default customer group |
| sos_default_urgency | smallint | 6 | id of default urgency (service level) |
| sos_liable | char | 1 | liability for costs flag |
| sos_calculable | char | 1 | price calculation flag |
| sos_delta_pages_count | smallint | 6 | offset between delivered and billed pages |
| sos_subito_resp_id | varchar | 100 | subito responder id |
| sos_subito_resp_email | varchar | 100 | subito responder email |
| sos_subito_mails | varchar | 100 | activated subito messages |
| sos_subito_acc_active | char | 1 | central collection service flag |
| sos_subito_ex_active | char | 1 | invoice expiration flag |
7..3 Urgency (Service level)
Werden automatisch auf ‚STANDARD‘ bzw. ‚DEFAULT‘ gesetzt, wenn in einem Auftragsdienst keine besonderen Lieferfristen eingerichtet wurden.
| Name der Variablen | Typ | Länge der Variablen | Beschreibung |
|---|---|---|---|
| md_urgency_id | int | 4 | numerical urgency id |
| md_urgency_name | varchar | 255 | urgency name |
| md_urgency_desc | varchar | 255 | urgency description |
| md_urgency_term | varchar | 255 | urgency term / aka rule |
| md_urgency_value | int | 4 | numerical value / number of hours |
| md_urgency_sos_id | int | 4 | related service id |
7..4 Customer Group (requester group)
Wird automatisch auf ‚STANDARD bzw. DEFAULT gesetzt bei Auftragsdiensten, in denen keine speziellen Benutzergruppen definiert wurden.
| Name der Variablen | Typ | Länge der Variablen | Beschreibung |
|---|---|---|---|
| md_customer_group_id | int | 4 | numerical customer group |
| md_customer_group_service_id | int | 4 | numerical order service id |
| md_customer_group_name | varchar | 100 | customer group name |
| md_customer_group_characteristic | varchar | 100 | customer group technical identification |
| md_customer_group_description | text | customer group description | |
| md_customer_group_deletable | char | 1 | deletable flag |
| md_customer_group_deletable | varchar | 255 | default price formular |
7..5 System / Installation
Zusätzliche Felder können lokal angelegt werden, verfügbar unter ihrem generischen Namenspräfix „sys_“.
| Name der Variablen | Typ | Länge der Variablen | Beschreibung |
|---|---|---|---|
| sys_datetime | datetime | current datetime | |
| sys_date | datetime | current date | |
| sys_time | datetime | current time | |
| sys_software_title | predefined string | software title | |
| sys_software_version | predefined string | software version | |
| sys_software_revision | predefined string | software revision | |
| sys_software_date | predefined string | software release date | |
| sys_software_copyright | predefined string | software copyright | |
| sys_software_author | predefined string | software author | |
| sys_installation_title | predefined string | installation title | |
| sys_installation_state | predefined string | installation state (demo/production) | |
| sys_installation_licenso | predefined string | installation licensor | |
| sys_installation_licensee | predefined string | installation licensee | |
| sys_institution_institution_name | varchar | 255 | institution name |
| sys_institution_institution_address | varchar | 255 | institution postal address |
| sys_institution_institution_phone | varchar | 255 | institution phone |
| sys_institution_institution_fax | varchar | 255 | institution fax number |
| sys_institution_institution_email | varchar | 255 | institution email address |
| sys_institution_institution_sigel | varchar | 255 | institution sigel number |
7..6 Webpublisher
| Name der Variablen | Typ | Länge der Variablen | Beschreibung |
|---|---|---|---|
| Texttemplate WP_MAIN_TABLE_COL | |||
| wp_original_image_name | varchar | n.a. | name of the original image (used for a direct link in browser) |
| wp_original_image_mimetype | varchar | n.a. | this variable contains the mimetype of the original image |
| wp_original_image_nr | int | 4 | the image number of the current original image |
| wp_original_image_size | int | 4 | the image file size of the current original image |
| Texttemplate WP_MAIN_TABLE_COL_ONLY_PREVIEW: | |||
| wp_preview_html_name | varchar | n.a. | name of the preview html page, containing the preview image |
| wp_original_image_nr | int | 4 | the image number of the current original image |
| Texttemplate WP_MAIN: | |||
| wp_count_images | int | 4 | the count of all images (current category) |
| wp_order_picture_size | int | 4 | the image file size of the current original image |
| WP_MAIN_TABLE_COL | n.a.(texttemplate) | n.a. | texttemplatereference (for each image one column) |
| Texttemplate WP_INDEX: | |||
| wp_index_title | varchar | n.a. | name of the frameset index html page |
| wp_thumb_link | varchar | n.a. | name of the thumbnail html page |
| wp_main_link | varchar | n.a. | name_of the main html page |
| Texttemplate WP_MAIN_PDF_LINK: | |||
| wp_pdf_size | varchar | n.a. | the size of the current pdf file |
| wp_count_images | int | 4 | the count of all images (current pdf) |
| Texttemplate WP_PREVIEW: | |||
| wp_main_link | n.a. (html link) | n.a. | link to main html page |
| WP_PREVIEW_PREV | n.a. (texttemplate) | n.a. | link to previous preview html page (texttemplate) |
| WP_PREVIE_NEXT | n.a. (texttemplate) | n.a. | link to next preview html page (texttemplate) |
| wp_original_image | varchar | n.a. | name of the current original image (used for a direct link in browser) |
| wp_original_image_short | varchar | n.a. | short name of current original image (without file extension) |
| wp_original_image_size | int | 4 | the image file size of the current original image |
| wp_preview_image | varchar | n.a. | name of the current preview image (used for a direct link in browser) |
| Texttemplate WP_PREVIEW_PREV: | |||
| wp_prev_html | n.a. (html link) | n.a. | link to previous preview html page |
| Texttemplate WP_PREVIEW_NEXT: | |||
| wp_next_html | n..a. (html link) | n.a. | link to next preview html page |
| Texttemplate WP_THUMBS: | |||
| wp_logo_link | n.a. (html link) | n.a. | can be a user defined html link (i.e. http://www.imageware.de) |
| wp_logo_image | varchar | n.a. | name of the logo image (must be uploaded into ME data directory) |
| wp_order_name | varchar | n.a. | order name (same like or_scan_id) |
| wp_image_count | int | 4 | the count of all images (current category) |
| wp_image_original_size | int | 4 | the filesize of all images (current category) |
| wp_main_link | n.a. (html link) | n.a. | link to main html page |
| WP_THUMBS-PDF_LINK | n.a. (texttemplate) | n.a. | link to pdf file (texttemplate) |
| WP_THUMBS_IMAGES | n.a. (texttemplate) | n.a. | link to thumbnails (texttemplate) |
| Texttemplate WP_THUMBS_PDF_LINK: | |||
| wp_pdf_target | varchar | n.a. | link to pdf file |
| wp_pdf_size | int | 4 | the size of current pdf |
| wp_image_count | int | 4 | the count of all images (current pdf) |
| Texttemplate WP_THUMBS_IMAGES: | |||
| wp_original_name | varchar | n.a. | name of the current original image |
| wp_image_mimetype | varchar | n.a. | mimetype of current original image |
| wp_image_count | int | 4 | the count of all images (current category) |
| wp_image_size | int | 4 | the size of current image |
| wp_preview_link | n.a. (html link) | n.a. | link to current preview html page |
| wp_thumb_image | varchar | n.a. | name of the current thumbnail image |
| Texttemplate WP_MAIN_TABLE_COL_NO_PREVIEW | |||
| wp_original_image_name | varchar | n.a. | name of the current original image |
| wp_original_image_mimetype | varchar | n.a. | mimetype of current original image |
| wp_original_image_nr | int | 4 | number of current original image |
| wp_original_image_size | int | 4 | filesize of current original image |
| Texttemplate WP_THUMBS_PREVIEW: | |||
| wp_preview_link | n.a. (html link) | n.a. | link to current preview html page |
| wp_image_count | int | 4 | number of current preview |
| Texttemplate WP_THUMBS_IMAGES_PREVIEWS: | |||
| wp_original_name | varchar | n.a. | name of the current preview image |
| wp_image_mimetype | varchar | n.a. | mimetype of current preview image |
| wp_image_count | int | 4 | number of current preview image |
| wp_image_size | int | 4 | filesize of current preview image |
| wp_preview_link | n.a. (html link) | n.a. | link to current preview html page |
| wp_thumb_image | varchar | n.a. | name of the current thumbnail image |
| Texttemplate WP_THUMBS_IMAGES_THUMBNAILS: | |||
| wp_image_count | int | 4 | number of current thumbnail image |
| wp_image_size | int | 4 | filesize of current thumbnail image |
| wp_thumb_image | varchar | n.a. | name of current thumbnail image |