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 |