bubs technical reference manual (itgen datamodel). bubs b44...kse bubs_kasstroom_projecties cash...

Invantive Estate

Powered by Invantive

Data Model (PDF)Settings: system, EUR, Year, Current situationApplication: bubs - Invantive EstateTables: ☒Table Columns: ☒Table Column Details: ☒Attribute Rules: ☒Referential Constraints: ☒Table Contents: ☒Indexes: ☒Database Views: ☒Function: itgen_datamodel_pdf_rpt

Applicationsbubs - Invantive Estate

Column "date last updated"

Column "original system reference"

bubs_lov_:tcn_name_rTemplate for LOV View Name

bijgewerkt_door

Column "column type"

Column "history active when filled"

bijgewerkt_in

Column "date created"

N

Column "column prefix"h_id

Column "history date start"

Column "session updated"

Column "original system group"

h_datum_einde

ANSI joins

datum_aangemaakt

Column "history event"

Column "transaction updated"

Column Identity

h_actief_als_gevuld

h_datum_start

orig_system_reference

Y☐

datum_bijgewerkt

id

Column "transaction created" transactie_aangemaakt

Column "date interface last updated"

Column "created by"

_vlag

aangemaakt_door

Flag Field Value for "yes"

Natural Key

Column "updated in"Column "updated by"

Column "date interface created"datum_intrf_bijgewerkt

Column "created in"

sessie_bijgewerktColumn "session created"

Flag Field Value for "no"

kolom

h_gebeurtenis

Column "history date ends"

_nk

Postfix for Flag Field

transactie_bijgewerktsessie_aangemaakt

datum_intrf_geladen

aangemaakt_in

Column "history id"

orig_system_group

kolom_soort

DocumentationAutocompleted ☐

bubsCodeInvantive EstateName

select cwe_id id, cwe_code code, cwe_label omschrijving, cwe_label label, cwe_sorteer_volgorde sorteer_volgordefrom bubs_lov_cachewhere cde_code='LOV-:tcn_name'and tal_code = coalesce(sys_context(coalesce(sys_context('USERENV','CLIENT_INFO'), '_bubs'), 'cig.tal_code'), 'en')

Template for LOV View

Expression set_session_info bubs_session.set_session_infoExpression unset_session_info bubs_session.unset_session_userExpression Get All Translations bubs#vertalingen.get_tab_vtgExpression Get Last Identity bubs_session.get_context_last_idExpression Register Interaction bubs_session.register_interactionExpression Restricted Logon bubs_restricted_logon

Expression Session User IdentityExpression Set Point in Time bubs_session.set_point_in_time

bubs_code_waardesTable Name ValuesTable Name for Codes

bubs_transactiesTable with Transactionsbubs_interactiesTable with Interactions_indPostfix for Code Field

bubs_codes

Expression point_in_time coalesce(to_date(sys_context(concat(sys_context('USERENV','CLIENT_INFO'), '_bubs'), 'point_in_time'), 'YYYYMMDDHH24MISS'), sysdate)

31-05-2012 12:38 Page 1 / 3,222

http://www.invantive.combubs_main_pjt.dohttp://tst.estate.invantive.com/smoke_bubs/bubs_rpt.do?Button_Execute=Execute&P_APN_CODE=bubs&P_INCL_TBE_VLAG=N&P_INCL_TBE_VLAG=Y&P_INCL_TCN_VLAG=N&P_INCL_TCN_VLAG=Y&P_INCL_TCL_VLAG=N&P_INCL_TCL_VLAG=Y&P_INCL_ARE_VLAG=N&P_INCL_ARE_VLAG=Y&P_INCL_RCT_VLAG=N&P_INCL_RCT_VLAG=Y&P_INCL_TBE_CONTENTS_VLAG=N&P_INCL_TBE_CONTENTS_VLAG=Y&P_INCL_IDX_VLAG=N&P_INCL_IDX_VLAG=Y&P_INCL_VIW_VLAG=N&P_INCL_VIW_VLAG=Y&GO=Y&FTE_CODE=itgen_datamodel_pdf_rpt&P_METADATA_KEYWORDS=invantive+vision%2C+invantive+estate%2C+projectplan%2C+real+estate+development%2C+microsoft+outlook%2C+budget%2C+forecast%2C+prognosis%2C+riskmodel%2C+project+software%2Cdata+model%2C+database+normalization%2Coracle+database%2C+query+tool%2C+business+rules%2C+attribute+rules%2C+SQL%2C+module+definitions%2C+table+definitions%2C+view+definitions%2C+er+modeling&P_METADATA_SUBJECT=Data+Model+Invantive+Estate+and+Invantive+Vision&USER_FRIENDLY_NAME=bubs+technical+reference+manual

Invantive Estate



Applicationsbubs - Invantive EstateExpression Effective Date itgen_history.get_effective_date(:table, :event, :anti_date_bool)Expression Translate Keys bubs#vertalingen.translate_keysStandard Where ClauseStandard Select ClauseInclude Natural Key Column ☒Natural Key PrefixNatural Key PostfixNatural Key Separator -Column "transaction updated" transactie_bijgewerktProcedure for Logging Execution of Attribute Rules bubs_session.log_are_eventCopyright (C) Copyright 2004-2012 Invantive Software BV, the Netherlands. All rights reserved.

31-05-2012 12:38 Page 1 / 3,222


Invantive Estate




Code NameTables

Label Pluralale bubs_afleesmethodes Property Determination Methods ({res:bubs_property_determination_methods})ame bubs_aggregatie_methodes Aggregation Methods ({res:bubs_aggregation_methods})aml bubs_ame_regels Aggregation Method Lines ({res:bubs_aggregation_method_lines})aoe bubs_aanvragen_ojt_actie Requested Object Actions ({res:bubs_requested_object_actions})ard bubs_ame_regels_prod Aggregation Method Products ({res:bubs_aggregation_method_products})atg bubs_aanvragen_toegang Access Requests ({res:bubs_access_requests})bce bubs_btw_codes VAT Codes ({res:bubs_vat_codes})bee bubs_bestand_extensies Extensions ({res:bubs_file_extensions})bjb bubs_background_jobs Background Jobs ({res:bubs_background_jobs})brt bubs_berichten Messages ({res:bubs_messages})btn bubs_betaaltermijnen Payment Conditions ({res:bubs_payment_conditions})bvd bubs_berekende_velden Additional Business Rules ({res:bubs_calculated_fields})bvg bubs_budget_verschuivingen Budget Movements ({res:bubs_budget_movements})cde bubs_codes Codes ({res:bubs_codes})cdi bubs_condities Conditions ({res:bubs_conditions})cfl bubs_cpt_factuur_regels Draft Invoice Lines ({res:bubs_concept_invoice_lines})cig bubs_context_instellingen Filters ({res:bubs_contexts})ci1 bubs_cig_1_r My Filters ({res:bubs_my_contexts})crl bubs_conditie_regels Condition Elements ({res:bubs_condition_lines})ctg bubs_ctt_taken_generatie Contract Processes Generation ({res:bubs_contract_tasks_generation})ctt bubs_contracten Contracts ({res:bubs_contracts})cwe bubs_code_waardes Code Values ({res:bubs_code_values})dal bubs_dual Duals ({res:bubs_duals})dct bubs_documenten Documents ({res:bubs_documents})dfe bubs_deelfuncties Subfunctions ({res:bubs_subfunctions})dgr bubs_dct_gbr Document Involvements ({res:bubs_document_involvements})dke bubs_dct_kle Document Classifications ({res:bubs_document_classifications})drl bubs_deelnemer_rollen Involvement Roles ({res:bubs_involvement_roles})dse bubs_dct_statistieken Document Statistics ({res:bubs_document_statistics})dsk bubs_dct_statistieken_r Document Statistics ({res:bubs_document_statistics})dss bubs_dct_statussen Document Statuses ({res:bubs_document_statuses})dst bubs_dct_soorten Document Types ({res:bubs_document_types})egf bubs_exact_grtbk_bedrijven ERP Financial Companies ({res:bubs_erp_financial_companies})egp bubs_eigenschappen Properties ({res:bubs_properties})eig bubs_exact_instellingen ERP Settings ({res:bubs_erp_settings})elf bubs_exact_laad_ftr ERP Load Invoices ({res:bubs_erp_load_invoices})elg bubs_exact_laad_gbr ERP Load Persons ({res:bubs_erp_load_users})elk bubs_exact_laad_kbg ERP Load Cost Categories ({res:bubs_erp_load_cost_categories})ell bubs_exact_laad_frl ERP Load Invoice Lines ({res:bubs_erp_load_invoice_lines})elo bubs_exact_laad_obt ERP Load Revenues ({res:bubs_erp_load_revenues})elr bubs_exact_laad_lvr ERP Load Invoices ({res:bubs_erp_load_invoices})fpr bubs_functie_parameters Function Parameters ({res:bubs_function_parameters})frl bubs_factuur_regels Invoice Lines ({res:bubs_invoice_lines})fsa bubs_lov_fpr_soort_data_r Function Parameter Data Types ({res:bubs_function_parameter_datatypes})fte bubs_functies Functions ({res:bubs_functions})ftr bubs_facturen Invoices ({res:bubs_invoices})gbr bubs_gebruikers Persons ({res:bubs_persons})gce bubs_grootboek_codes General Ledger Account Codes ({res:bubs_general_ledger_codes})gke bubs_gbr_kle Person Classifications ({res:bubs_user_classifications})gmg bubs_gebruiker_meldingen User Messages ({res:bubs_user_messages})grl bubs_gebruiker_rollen User Roles ({res:bubs_user_roles})gsk bubs_gesprekken Calls ({res:bubs_calls})gss bubs_grond_statussen Land Statuses ({res:bubs_ground_statuses})

31-05-2012 12:38 Page 2 / 3,222


Invantive Estate




Code NameTables

Label Pluralgvd bubs_gbr_vdd User Skills ({res:bubs_user_skills})gwt bubs_gbr_wst Articles per Person and Labor Type ({res:bubs_user_labour_types})hgr bubs_herhaling_generatoren Repeat Generators ({res:bubs_repeat_generators})iae bubs_interacties Interactions ({res:bubs_interactions})idx bubs_indexen Economic Indexes ({res:bubs_indexes})isg bubs_instellingen Settings ({res:bubs_settings})iwe bubs_index_waardes Economic Index Values ({res:bubs_index_values})jmg bubs_job_meldingen Job Messages ({res:bubs_job_messages})job bubs_jobs ERP Jobs ({res:bubs_jobs})jpr bubs_job_parameters Job Parameters ({res:bubs_job_parameters})kbg bubs_kps_beschrijvingen Cost Categories ({res:bubs_cost_categories})kdl bubs_kse_dagdetails Cash Flow Projection Day Details ({res:bubs_cashflow_projection_day_details})khg bubs_kps_hfdverdichtingen Cost Type Master Rollups ({res:bubs_cost_category_master_rollups})kle bubs_klassificaties Classifications ({res:bubs_classifications})klr bubs_kalender Calendars ({res:bubs_calendars})kps bubs_kostenplaatsen Budgets ({res:bubs_budgets})kpt bubs_kosten_plaatsen2 Cost Centers ({res:bubs_cost_centres})kse bubs_kasstroom_projecties Cash Flow Projections ({res:bubs_cashflow_projections})ksl bubs_kse_details Cash Flow Projection Details ({res:bubs_cashflow_projection_details})ksm bubs_kse_methodes Cash Flow Projection Methods ({res:bubs_cashflow_projection_methods})kvg bubs_kps_verdichtingen Cost Type Rollups ({res:bubs_cost_category_rollups})lae bubs_lov_ame_uot_r Aggregation Method Line Types ({res:bubs_aggregation_method_line_types})lbw bubs_lov_balans_vw_r Balance and "Profit and Loss" Types ({res:bubs_balance_profit_loss_types})lca bubs_lov_sct_programma_r Script Program Types ({res:bubs_script_program_types})lcdl bubs_lov_cfl_ref_det_tabel_r Draft Invoice Line Detail Object Types ({res:bubs_cfl_detail_object_types})lce bubs_licenties Licenses ({res:bubs_licenses})lch bubs_lov_cache LOV Caches ({res:bubs_lov_caches})lcl bubs_lov_cfl_ref_tabel_r Draft Invoice Line Object Types ({res:bubs_cfl_object_types})lct bubs_lov_credit_debet_r Debit Credit Types ({res:bubs_debet_credit_types})lcy bubs_lov_sct_categorie_r Script Scheduler Category Required Types ({res:bubs_script_scheduler_category_required_types})ldl bubs_lov_dct_ref_tabel_r Document Object Types ({res:bubs_document_object_types})lgr bubs_lvr_gbr Organization Involvements ({res:bubs_organisation_involvements})lgt bubs_lov_gbr_geslacht_r Gender Types ({res:bubs_gender_types})lje bubs_lov_job_eindstatus_r Job End Status Types ({res:bubs_job_end_status_types})ljs bubs_lov_job_status_r Job Status Types ({res:bubs_job_status_types})lke bubs_lov_kse_detail_type_r Cash Flow Projection Detail Types ({res:bubs_cashflow_projection_detail_types})lkl bubs_lov_koppel_ind_r Usable as ({res:bubs_coupling_possibilities})lkr bubs_lov_kosten_opbr_r Cost Revenue Types ({res:bubs_cost_revenue_types})llb bubs_loader_lob CLOBs to be Loaded ({res:bubs_clobs_to_be_loaded})lme bubs_lov_mime_ikoontje_r MIME Type Small Icon Types ({res:bubs_mime_type_small_icon_types})lnd bubs_landen Countries ({res:bubs_countries})loc bubs_locaties Locations ({res:bubs_locations})lop bubs_lov_overschot_comp_r Release Deviation Types ({res:bubs_release_balance_types})lpe bubs_lov_pst_ikoontje_r Project Status Small Icon Types ({res:bubs_project_status_small_icon_types})lpm bubs_lov_projectvorm_r Project Form Types ({res:bubs_project_form_types})lpn bubs_lov_pst_ikoon_r Project Status Icon Type ({res:bubs_project_status_icon_types})lps bubs_lov_project_status_r Project Status Types ({res:bubs_project_status_types})lra bubs_lov_records_per_pagina_r Records per Page Types ({res:bubs_records_per_page_types})lre bubs_lvr_relaties Organization Relations ({res:bubs_organisation_relations})lrg bubs_lov_reden_aanvraag_r Reason Access Request Types ({res:bubs_reason_access_request_types})lrj bubs_lov_rentedagen_pj_ind_r Interest Days per Year ({res:bubs_interest_days_per_year})lrt bubs_lvr_relatiesoorten Organization Relation Types ({res:bubs_organisation_relation_types})lsk bubs_lov_saldo_vrijg_kps_r Release Remaining Balance on Budgets ({res:bubs_release_balance_on_budgets})

31-05-2012 12:38 Page 3 / 3,222


Invantive Estate




Code NameTables

Label Plurallss bubs_lov_sdr_status_r Scheduler Status Types ({res:bubs_scheduler_status_types})lst bubs_lov_saldo_vrijg_pjt_r Release deviation on Contract Types ({res:bubs_release_balance_on_contract_types})lsy bubs_lov_sdr_categorie_r Scheduler Category Types ({res:bubs_scheduler_category_types})ltg bubs_lov_tmr_toepassing_r Text Mask Application Types ({res:bubs_text_mask_application_types})lue bubs_lov_uitsmeer_meth_r Cash Flow Distribution Methods ({res:bubs_cashflow_distribution_methods})lvr bubs_leveranciers Organizations ({res:bubs_organisations})mat bubs_mijn_rechten_r My Privileges ({res:bubs_my_privileges})mdg bubs_meldingen Messages ({res:bubs_messages})med bubs_munt_eenheden Monetary Units ({res:bubs_monetary_units})mgn bubs_magazijnen Warehouses ({res:bubs_warehouses})mim bubs_menu_items Menu Items ({res:bubs_menu_items})mnu bubs_menus Menus ({res:bubs_menus})mpr bubs_mijn_pjt_gerechtigd_r My visible projects ({res:bubs_my_visible_projects})mst bubs_mime_soorten MIME Types ({res:bubs_mime_types})nrm bubs_normen Intended Values ({res:bubs_intended_values})obt bubs_opbrengsten Revenues ({res:bubs_revenues})oct bubs_outlook_contacts_r Outlook Contacts ({res:bubs_outlook_contacts})ode bubs_ola_data_extracties Outlook Add-In Data Extractions ({res:bubs_outlook_addin_data_extractions})odt bubs_opdrachten Purchase Orders ({res:bubs_purchase_orders})oke bubs_lvr_kle Organization Classifications ({res:bubs_organisation_classifications})okr bubs_lov_olk_klr_r Outlook Category Colors ({res:bubs_outlook_category_colors})oss bubs_lov_olk_sts_r Outlook Category Shortcut Keys ({res:bubs_outlook_category_shortcut_keys})ost bubs_opbrengst_soorten Revenue Types ({res:bubs_revenue_types})pae bubs_project_autorisaties Project Authorizations ({res:bubs_project_authorizations})pal bubs_project_allocaties Project Allocations ({res:bubs_project_allocations})pce bubs_pve_categorieen Project Version Categories ({res:bubs_project_version_categories})pgp bubs_product_groepen Product Groups ({res:bubs_product_groups})pgr bubs_pjt_gbr Project Involvements ({res:bubs_project_involvements})pjt bubs_projecten Projects ({res:bubs_projects})pke bubs_pjt_kle Project Classifications ({res:bubs_project_classifications})plt bubs_prijslijsten Price Lists ({res:bubs_pricelists})poe bubs_profiel_opties Profile Options ({res:bubs_profile_options})pre bubs_pjt_relaties Project Relations ({res:bubs_project_relations})prl bubs_prijslijst_regels Price List Lines ({res:bubs_pricelist_lines})prt bubs_pjt_relatiesoorten Project Relation Types ({res:bubs_project_relation_types})psg bubs_pss_overgangen Project Phase Transitions ({res:bubs_project_phase_transitions})pss bubs_project_statussen Project Statuses ({res:bubs_project_statuses})pve bubs_project_versies Project Versions ({res:bubs_project_versions})pvw bubs_project_versie_views Project Version Views ({res:bubs_project_version_views})pwe bubs_profiel_waardes Profile Option Values ({res:bubs_profile_option_values})pzr bubs_projecten_zichtbaar_r Projects ({res:bubs_projects})rae bubs_rol_autorisaties Role Authorizations ({res:bubs_role_authorizations})red bubs_rapportage_eenheden Reporting Units ({res:bubs_reporting_units})rme bubs_rente_methodes Interest Rate Methods ({res:bubs_interest_rate_methods})rol bubs_rollen Roles ({res:bubs_roles})rpt bubs_ref_pjt_r Any Projects ({res:bubs_any_projects})rtd bubs_rapport_tijd_eenheden Time Reporting Units ({res:bubs_time_reporting_units})rvm bubs_rechtsvormen Legal Forms ({res:bubs_legal_forms})sct bubs_scripts Background Scripts ({res:bubs_scripts})sdr bubs_schedulers Schedulers ({res:bubs_schedulers})sma bubs_schemas_r Schemas ({res:bubs_schemas})spr bubs_script_parameters Script Parameters ({res:bubs_script_parameters})svg bubs_std_vertalingen_r Standard Translations ({res:bubs_standard_translations})

31-05-2012 12:38 Page 4 / 3,222


Invantive Estate




Code NameTables

Label Pluraltak bubs_taken Processes ({res:bubs_tasks})tal bubs_talen Languages ({res:bubs_languages})tce bubs_taak_categorieen Process Categories ({res:bubs_task_categories})tgr bubs_tak_gbr Process Involvements ({res:bubs_task_involvements})tip bubs_tips Tips ({res:bubs_tips})tit bubs_taak_impacten Process Impacts ({res:bubs_task_impacts})tke bubs_tak_kle Process Classifications ({res:bubs_task_classifications})tlr bubs_tellers Counters ({res:bubs_counters})tmr bubs_tekst_maskers Text Masks ({res:bubs_text_masks})tnc bubs_tne_categorieen Process Note Categories ({res:bubs_task_note_categories})tne bubs_taak_notities Process Notes ({res:bubs_task_notes})tog bubs_taak_oorsprongen Process Origins ({res:bubs_task_origins})tre bubs_tak_relaties Process Relations ({res:bubs_task_relations})trl bubs_termijnschema_regels Payment Schedule Lines ({res:bubs_payment_schedule_lines})trt bubs_tak_relatiesoorten Process Relation Types ({res:bubs_task_relation_types})tsa bubs_termijnschemas Payment Schedules ({res:bubs_payment_schedules})tse bubs_transacties Transactions ({res:bubs_transactions})tsg bubs_tss_overgangen Process Status Transitions ({res:bubs_task_status_transitions})tss bubs_taak_statussen Process Statuses ({res:bubs_task_statuses})tts bubs_toetsen Current Values ({res:bubs_current_values})tug bubs_tus_overgangen Process Unit Status Transitions ({res:bubs_task_unit_status_transitions})tus bubs_tak_unt_statussen Process Unit Statuses ({res:bubs_task_unit_statuses})tut bubs_tak_unt Process Units ({res:bubs_task_units})tvd bubs_tak_vdd Process Skills ({res:bubs_task_skills})uee bubs_unt_egp_waardes Article Properties ({res:bubs_article_properties})unt bubs_units Units ({res:bubs_units})upe bubs_usp_eigenschappen Article Properties ({res:bubs_article_properties})ure bubs_unt_relaties Unit Relations ({res:bubs_unit_relations})urt bubs_unt_relatiesoorten Unit Relation Types ({res:bubs_unit_relation_types})use bubs_ust_eigenschappen Article Properties ({res:bubs_article_properties})usg bubs_uss_overgangen Timesheet Status Transition ({res:bubs_timesheet_status_transitions})usp bubs_unit_soort_groepen Article Groups ({res:bubs_article_groups})uss bubs_uur_statussen Timesheet Statuses ({res:bubs_timesheet_statuses})ust bubs_unit_soorten Articles ({res:bubs_unit_types})ute bubs_unit_transacties Unit Transactions ({res:bubs_unit_transactions})utt bubs_ute_soorten Unit Transaction Types ({res:bubs_unit_transaction_categories})uur bubs_uren Timesheets ({res:bubs_timesheets})vbg bubs_kps_vrwcht_bstllngen Latest Estimates ({res:bubs_latest_estimates})vbt bubs_volgnummer_budgetten Contract Budgets ({res:bubs_contract_budgets})vdd bubs_vaardigheden Skills ({res:bubs_skills})vrd bubs_voorraden Stock Levels ({res:bubs_stock_levels})vsd bubs_volgnummer_standen Contract Financial Statuses ({res:bubs_contract_financial_statuses})vse bubs_versies Versions ({res:bubs_versions})vtg bubs_vertalingen Translations ({res:bubs_translations})wce bubs_lov_wce_r Labor Type Categories ({res:bubs_labour_type_categories})wfe bubs_waarde_formules Value Formulas ({res:bubs_value_formulas})wsa bubs_werk_schemas Working Schedules ({res:bubs_work_schedules})wse bubs_web_sites Websites ({res:bubs_web_sites})wsi bubs_web_site_interacties Website Accesses ({res:bubs_web_site_accesses})wst bubs_werksoorten Labor Types ({res:bubs_labour_types})wug bubs_wsa_uitzonderingen Working Schedule Exceptions ({res:bubs_work_schedule_exceptions})zst bubs_zware_sql_statements Heavy SQL Statements ({res:bubs_heavy_sql_statements})

31-05-2012 12:38 Page 5 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralacr_r bubs_asterisk_cdr_r Asterisk Call Data Record ({res:bubs_asterisk_call_data_record})adt_r bubs_alle_documenten_r All Documents ({res:bubs_all_documents})ale bubs_afleesmethodes_v Property Determination Methods ({res:bubs_property_determination_methods})ale_r bubs_ale_picklist_r Property Determination Methods ({res:bubs_property_determination_methods})ame bubs_aggregatie_methodes_v Aggregation Methods ({res:bubs_aggregation_methods})ame_r bubs_ame_picklist_r Aggregation Methods ({res:bubs_aggregation_methods})aml bubs_ame_regels_v Aggregation Method Lines ({res:bubs_aggregation_method_lines})aml_r bubs_aml_picklist_r Aggregation Method Lines ({res:bubs_aggregation_method_lines})aoe bubs_aanvragen_ojt_actie_v Requested Object Actions ({res:bubs_requested_object_actions})apg_r bubs_apg_r Project Authorizations per Person ({res:bubs_project_authorisations_per_person})apt bubs_alle_projecten_rapt_r bubs_tak_picklist_r Processes ({res:bubs_tasks})ap1_r bubs_apg_s1_r Project Authorizations per Person ({res:bubs_project_authorisations_per_person})ard bubs_ame_regels_prod_v Aggregation Method Products ({res:bubs_aggregation_method_products})ard_r bubs_ame_regels_prod_src_r Aggregation Method Products ({res:bubs_aggregation_method_products})arf_r bubs_arf_r Functions per Role ({res:bubs_functions_per_role})arg_r bubs_arg_r Persons per Role ({res:bubs_persons_per_role})arp_r bubs_ard_picklist_r Aggregation Method Products ({res:bubs_aggregation_method_products})ar1_r bubs_arg_s1_r Persons per Role ({res:bubs_persons_per_role})ase_r bubs_actieve_sessies_r Active Sessions ({res:bubs_active_sessions})ate_r bubs_authenticatie_gegevens_r Authentication Data ({res:bubs_authentication_data})atg bubs_aanvragen_toegang_v Access Requests ({res:bubs_access_requests})atk bubs_alle_taken_raur_r bubs_alle_uren_r All Hours ({res:bubs_all_hours})bce bubs_btw_codes_v VAT Codes ({res:bubs_vat_codes})bce_r bubs_bce_picklist_r VAT Codes ({res:bubs_vat_codes})bee bubs_bestand_extensies_v Extensions ({res:bubs_file_extensions})bee_r bubs_bee_picklist_r Extensions ({res:bubs_file_extensions})bjb bubs_background_jobs_v Background Jobs ({res:bubs_background_jobs})bjb_r bubs_background_jobs_r Background Jobs ({res:bubs_background_jobs})bjp_r bubs_bjb_picklist_r Background Jobs ({res:bubs_background_jobs})bps_r bubs_bvg_per_kps_r Budget Movements per Budget ({res:bubs_budget_movements_per_budget})bpt_r bubs_btn_picklist_r Payment Conditions ({res:bubs_payment_conditions})brt bubs_berichten_v Messages ({res:bubs_messages})brt_r bubs_brt_picklist_r Messages ({res:bubs_messages})btd_r bubs_betrokkenheden_r Involvements ({res:bubs_involvements})btn bubs_betaaltermijnen_v Payment Conditions ({res:bubs_payment_conditions})bvd bubs_berekende_velden_v Additional Business Rules ({res:bubs_calculated_fields})bvd_r bubs_bvd_picklist_r Additional Business Rules ({res:bubs_calculated_fields})bvg bubs_budget_verschuivingen_v Budget Movements ({res:bubs_budget_movements})cal_r bubs_cdi_picklist_r Conditions ({res:bubs_conditions})cde bubs_codes_v Codes ({res:bubs_codes})cde_r bubs_cde_picklist_r Codes ({res:bubs_codes})cdi bubs_condities_v Conditions ({res:bubs_conditions})cdi_r bubs_cdi_r Conditions ({res:bubs_conditions})cfl bubs_cpt_factuur_regels_v Draft Invoice Lines ({res:bubs_concept_invoice_lines})cfl_r bubs_cfl_picklist_r Draft Invoice Lines ({res:bubs_concept_invoice_lines})cgt_r bubs_cfl_groep_picklist_r {res:bubs_concept_invoice_line_groups}cia bubs_context_instellingen_a Filters ({res:bubs_contexts})cig bubs_context_instellingen_v Filters ({res:bubs_contexts})cig_r bubs_cig_1_r My Filters ({res:bubs_my_contexts})ckl_r bubs_cdi_k_picklist_r Purchasing Conditions ({res:bubs_purchasing_conditions})col_r bubs_cdi_o_picklist_r Selling Conditions ({res:bubs_selling_conditions})

31-05-2012 12:38 Page 6 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralcrl bubs_conditie_regels_v Condition Elements ({res:bubs_condition_lines})crl_r bubs_crl_picklist_r Condition Elements ({res:bubs_condition_lines})crt_r bubs_conditie_regels_plat_r Condition Elements ({res:bubs_condition_lines})csn_r bubs_cig_ssn_r Filter Settings ({res:bubs_context_settings})cte_r bubs_controles_r Controls ({res:bubs_controls})ctg bubs_ctt_taken_generatie_v Contract Processes Generation ({res:bubs_contract_tasks_generation})ctr_r bubs_ctr_picklist_r Categories ({res:bubs_categories})ctt bubs_contracten_v Contracts ({res:bubs_contracts})cwe bubs_code_waardes_v Code Values ({res:bubs_code_values})cwe_r bubs_cwe_picklist_r Code Values ({res:bubs_code_values})dal bubs_dual_v Duals ({res:bubs_duals})dct bubs_documenten_v Documents ({res:bubs_documents})dct_r bubs_dct_picklist_r Documents ({res:bubs_documents})dcx_r bubs_db_ctx_r Database Contexts ({res:bubs_db_contexts})dfe bubs_deelfuncties_v Subfunctions ({res:bubs_subfunctions})dfe_r bubs_dfe_picklist_r Subfunctions ({res:bubs_subfunctions})dgr bubs_dct_gbr_v Document Involvements ({res:bubs_document_involvements})dke bubs_dct_kle_v Document Classifications ({res:bubs_document_classifications})dkp_r bubs_dke_picklist_r Document Classifications ({res:bubs_document_classifications})dof_r bubs_dct_ongeldige_ref_r Invalid Document References ({res:bubs_invalid_document_references})drl bubs_deelnemer_rollen_v Involvement Roles ({res:bubs_involvement_roles})drl_r bubs_drl_picklist_r Involvement Roles ({res:bubs_involvement_roles})dsc_r bubs_dct_statistieken_src_r Document Source Statistics ({res:bubs_document_source_statistics})dse bubs_dct_statistieken_v Document Statistics ({res:bubs_document_statistics})dsk_r bubs_dct_statistieken_r Document Statistics ({res:bubs_document_statistics})dss bubs_dct_statussen_v Document Statuses ({res:bubs_document_statuses})dss_r bubs_dss_picklist_r Document Statuses ({res:bubs_document_statuses})dst bubs_dct_soorten_v Document Types ({res:bubs_document_types})dst_r bubs_dst_picklist_r Document Types ({res:bubs_document_types})egf bubs_exact_grtbk_bedrijven_v ERP Financial Companies ({res:bubs_erp_financial_companies})egf_r bubs_egf_picklist_r ERP Financial Companies ({res:bubs_erp_financial_companies})egp bubs_eigenschappen_v Properties ({res:bubs_properties})egp_r bubs_egp_picklist_r Properties ({res:bubs_properties})eig bubs_exact_instellingen_v ERP Settings ({res:bubs_erp_settings})eig_r bubs_eig_picklist_r Exact settings ({res:bubs_exact_settings})elf bubs_exact_laad_ftr_v ERP Load Invoices ({res:bubs_erp_load_invoices})elf_r bubs_elf_picklist_r ERP Load Invoices ({res:bubs_erp_load_invoices})elg bubs_exact_laad_gbr_v ERP Load Persons ({res:bubs_erp_load_users})elg_r bubs_elg_picklist_r ERP Load Persons ({res:bubs_erp_load_users})elk bubs_exact_laad_kbg_v ERP Load Cost Categories ({res:bubs_erp_load_cost_categories})ell bubs_exact_laad_frl_v ERP Load Invoice Lines ({res:bubs_erp_load_invoice_lines})elo bubs_exact_laad_obt_v ERP Load Revenues ({res:bubs_erp_load_revenues})elr bubs_exact_laad_lvr_v ERP Load Invoices ({res:bubs_erp_load_invoices})elr_r bubs_elr_picklist_r ERP Load Invoices ({res:bubs_erp_load_invoices})etp_r bubs_een_tip_r Tips ({res:bubs_tips})fdt_r bubs_fdt_r Projects Overview Directors ({res:bubs_projects_overview_directors})fet_r bubs_fte_picklist_r Functions ({res:bubs_functions})fhe_r bubs_factuur_historie_r Invoiced Amounts over Time ({res:bubs_invoiced_amounts_over_time})fic_r bubs_favoriete_items_cig_r Favorite Items: Project ({res:bubs_favorite_items_project})fik_r bubs_favoriete_items_tak_r Favorite Items: Process ({res:bubs_favorite_items_task})fim_r bubs_favoriete_items_r Favorite Items ({res:bubs_favorite_items})fin_r bubs_fin_interface_runs_r Financial Interface Runs ({res:bubs_fin_interface_runs})fip_r bubs_favoriete_items_pjt_r Favorite Items: Process ({res:bubs_favorite_items_task})

31-05-2012 12:38 Page 7 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralfir_r bubs_favoriete_items_uur_r Favorite Items: Hour ({res:bubs_favorite_items_hour})fnt_r bubs_fpt_n2c_pst_r Project Status ({res:bubs_fpt_n2c_pst_rpt})fot_r bubs_fot_r Projects Overview Board of Directors ({res:bubs_projects_overview_board})fpr bubs_functie_parameters_v Function Parameters ({res:bubs_function_parameters})fpr_r bubs_fpr_picklist_r Function Parameters ({res:bubs_function_parameters})fpt_r bubs_fpt_r Project Management Document ({res:bubs_fpt_rpt})fp1_r bubs_fpt_n1_r Financial Project Overview Level 1 ({res:bubs_fpt_n1_rpt})fp2_r bubs_fpt_n2_r Financial Project Overview Level 2 ({res:bubs_fpt_n2_rpt})fp3_r bubs_fpt_n3_r Financial Project Overview Level 3 ({res:bubs_fpt_n3_rpt})fp4_r bubs_fpt_n4_r Financial Project Overview Level 4 ({res:bubs_fpt_n4_rpt})frl bubs_factuur_regels_v Invoice Lines ({res:bubs_invoice_lines})frl_r bubs_frl_picklist_r Invoice Lines ({res:bubs_invoice_lines})frt_r bubs_ftr_picklist_r Invoices ({res:bubs_invoices})fsa_r bubs_lov_fpr_soort_data_r Function Parameter Data Types ({res:bubs_function_parameter_datatypes})fte bubs_functies_v Functions ({res:bubs_functions})ftr bubs_facturen_v Invoices ({res:bubs_invoices})ftr_r bubs_footer_r Footers ({res:bubs_footers})f3b_r bubs_fpt_n3wb_r Project Status per Cost Category ({res:bubs_fpt_n3wb_rpt})f4b_r bubs_fpt_n4wb_r Project Status Workbench ({res:bubs_fpt_n4wb_rpt})f4d_r bubs_fpt_n4wb_det_r Project Status Workbench Details ({res:bubs_fpt_n4wb_details_rpt})f4g_r bubs_fpt_n4_bvg_r Financial Project Overview Level 4 Budget Movements ({res:bubs_fpt_n4_bvg_rpt})gak_r bubs_gbr_all_ik_r xxxgat_r bubs_gat_r User Activities ({res:bubs_user_activities})ga1_r bubs_gat_s1_r User Activities ({res:bubs_user_activities})ga2_r bubs_gat_s2_r User Activities ({res:bubs_user_activities})ga3_r bubs_gat_s3_r User Activities ({res:bubs_user_activities})ga4_r bubs_gat_s4_r User Activities ({res:bubs_user_activities})gbr bubs_gebruikers_v Persons ({res:bubs_persons})gbr_r bubs_gbr_r Persons ({res:bubs_persons})gbt_r bubs_gbr_picklist_r Persons ({res:bubs_persons})gce bubs_grootboek_codes_v General Ledger Account Codes ({res:bubs_general_ledger_codes})gce_r bubs_gce_picklist_r General Ledger Account Codes ({res:bubs_general_ledger_codes})gdt_r bubs_gbr_drr_picklist_r Product Group Directors ({res:bubs_product_group_directors})gft_r bubs_gr_fin_p_pjt_r Projects Financial Overview ({res:bubs_projects_financial_overview})gke bubs_gbr_kle_v Person Classifications ({res:bubs_user_classifications})gke_r bubs_gke_picklist_r Person Classifications ({res:bubs_user_classifications})gkm_r bubs_gr_kdl_p_kse_datum_r Cash Flow Projections per Day ({res:bubs_cashflow_projections_per_day})gkr_r bubs_gebruiker_kopieer_r Copy Persons ({res:bubs_copy_persons})gmg bubs_gebruiker_meldingen_v User Messages ({res:bubs_user_messages})gmt_r bubs_gr_marge_p_pjt_r Profits per Project ({res:bubs_margins_per_project})got_r bubs_gr_obt_verkocht_p_pjt_r Percentages Sold per Project ({res:bubs_percentages_sold_per_project})gpe_r bubs_gbr_profiel_waardes_r User Profile Values ({res:bubs_user_profile_values})gps_r bubs_gr_pjt_p_pss_r #Projects per Phase ({res:bubs_number_of_projects_per_phase})gpt_r bubs_gbr_por_picklist_r Project Developers ({res:bubs_project_developers})grl bubs_gebruiker_rollen_v User Roles ({res:bubs_user_roles})grl_r bubs_grl_picklist_r User Roles ({res:bubs_user_roles})grt_r bubs_gbr_amr_picklist_r Administrators ({res:bubs_administrators})gsk bubs_gesprekken_v Calls ({res:bubs_calls})gss bubs_grond_statussen_v Land Statuses ({res:bubs_ground_statuses})gss_r bubs_gss_picklist_r Land Statuses ({res:bubs_ground_statuses})gth_r bubs_gbr_thr_picklist_r Process Owners ({res:bubs_task_keepers})gtm_r bubs_gbr_tmr_picklist_rgtr_r bubs_gr_tak_p_gbr_r Open Processes per Process Owner ({res:bubs_open_tasks_per_task_owner})

31-05-2012 12:38 Page 8 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralgts_r bubs_gr_tak_p_tss_r Processes per Status ({res:bubs_tasks_per_status})gtt_r bubs_gbr_tsr_picklist_r Time Writers ({res:bubs_time_writers})gur bubs_gewerkte_uren_r Working Hours ({res:bubs_working_hours})gut_r bubs_gbr_uur_picklist_r Project Timesheet Validators ({res:bubs_project_timesheet_validators})gvd bubs_gbr_vdd_v User Skills ({res:bubs_user_skills})gwt bubs_gbr_wst_v Articles per Person and Labor Type ({res:bubs_user_labour_types})g1p_r bubs_gbr_001_p1_r User overview ({res:bubs_gbr_001_pdf_rpt})g2p_r bubs_gbr_001_p2h_r Half dashboard displays report with user details ({res:bubs_gbr_p2h_pdf_rpt})hgr bubs_herhaling_generatoren_v Repeat Generators ({res:bubs_repeat_generators})hgr_r bubs_hgr_picklist_r Repeat Generators ({res:bubs_repeat_generators})hpt_r bubs_khg_picklist_r Cost Type Master Rollups ({res:bubs_cost_category_master_rollups})iae bubs_interacties_v Interactions ({res:bubs_interactions})idx bubs_indexen_v Economic Indexes ({res:bubs_indexes})ipt_r bubs_idx_picklist_r Economic Indexes ({res:bubs_indexes})isg bubs_instellingen_v Settings ({res:bubs_settings})isg_r bubs_isg_picklist_r Settings ({res:bubs_settings})iwe bubs_index_waardes_v Economic Index Values ({res:bubs_index_values})iwpt_r bubs_iwe_picklist_r Economic Index Values ({res:bubs_index_values})jmg bubs_job_meldingen_v Job Messages ({res:bubs_job_messages})job bubs_jobs_v ERP Jobs ({res:bubs_jobs})jpr bubs_job_parameters_v Job Parameters ({res:bubs_job_parameters})kbg bubs_kps_beschrijvingen_v Cost Categories ({res:bubs_cost_categories})kbg_r bubs_kbg_r Cost Category Structures ({res:bubs_cost_category_structures})kb1_r bubs_kbg_s1_r Cost Category Structures ({res:bubs_cost_category_structures})kcn_r bubs_kps_controlegetallen_r Checksums ({res:bubs_check_sums})kdl bubs_kse_dagdetails_v Cash Flow Projection Day Details ({res:bubs_cashflow_projection_day_details})kdl_r bubs_kdl_r Cash Flow Projection Day Details ({res:bubs_cashflow_projection_day_details})kds_r bubs_kse_dagdetails_r Cash Flow Projection Day Details ({res:bubs_cashflow_projection_day_details})khg bubs_kps_hfdverdichtingen_v Cost Type Master Rollups ({res:bubs_cost_category_master_rollups})kkt_r bubs_ksm_kst_r Cash Flows per Cost Category ({res:bubs_cashflows_per_cost_category})kle bubs_klassificaties_v Classifications ({res:bubs_classifications})kle_r bubs_kle_picklist_r Classifications ({res:bubs_classifications})klr bubs_kalender_v Calendars ({res:bubs_calendars})kmt_r bubs_ksm_picklist_r Cash Flow Projection Methods ({res:bubs_cashflow_projection_methods})kpe_r bubs_kpe_r Cash Flow Projections ({res:bubs_cashflow_projections})kpe1_r bubs_kpe_s1_r Cash Flow Projections ({res:bubs_cashflow_projections})kpm_r bubs_kdl_p_kse_datum_r Cash Flow Projections per Day ({res:bubs_cashflow_projections_per_day})kps bubs_kostenplaatsen_v Budgets ({res:bubs_budgets})kpt bubs_kosten_plaatsen2_v Cost Centers ({res:bubs_cost_centres})kpt_r bubs_kbg_picklist_r Cost Categories ({res:bubs_cost_categories})krf_r bubs_kle_ref_r Classifications ({res:bubs_classifications})ksa_r bubs_ksa_r Overall Cash Flow Projections ({res:bubs_overall_cashflow_projections})kse bubs_kasstroom_projecties_v Cash Flow Projections ({res:bubs_cashflow_projections})ksl bubs_kse_details_v Cash Flow Projection Details ({res:bubs_cashflow_projection_details})ksm bubs_kse_methodes_v Cash Flow Projection Methods ({res:bubs_cashflow_projection_methods})ktt_r bubs_kpt_picklist_r Cost Centers ({res:bubs_cost_centres})kve_r bubs_kps_vrije_ruimte_r Budgets ({res:bubs_budgets})kvg bubs_kps_verdichtingen_v Cost Type Rollups ({res:bubs_cost_category_rollups})kvt_r bubs_kvg_picklist_r Cost Type Rollups ({res:bubs_cost_category_rollups})lae_r bubs_lov_ame_uot_r Aggregation Method Line Time Units ({res:bubs_aggregation_method_line_time_units})lan_r bubs_lov_afgelopen_r xxxlat_r bubs_lov_afw_mz_opdracht_r Invoice Line Origins ({res:bubs_invoice_line_origins})lbw_r bubs_lov_balans_vw_r Balance and "Profit and Loss" Types ({res:bubs_balance_profit_loss_types})

31-05-2012 12:38 Page 9 / 3,222


Invantive Estate




Database ViewsCode Name Label Plurallca_r bubs_lov_sct_programma_r Script Program Types ({res:bubs_script_program_types})lcdl_r bubs_lov_cfl_ref_det_tabel_r Draft Invoice Line Detail Object Types ({res:bubs_cfl_detail_object_types})lce bubs_licenties_v Licenses ({res:bubs_licenses})lce_r bubs_lce_picklist_r Licenses ({res:bubs_licenses})lch bubs_lov_cache_v LOV Caches ({res:bubs_lov_caches})lcl_r bubs_lov_cfl_ref_tabel_r Draft Invoice Line Object Types ({res:bubs_cfl_object_types})lct_r bubs_lov_credit_debet_r Debit Credit Types ({res:bubs_debet_credit_types})lcy_r bubs_lov_sct_categorie_r Script Scheduler Category Required Types ({res:bubs_script_scheduler_category_required_types})ldl_r bubs_lov_dct_ref_tabel_r Document Object Types ({res:bubs_document_object_types})ldt_r bubs_lnd_picklist_r Countries ({res:bubs_countries})lfr_r bubs_lov_functies_r Functions ({res:bubs_functions})lgr bubs_lvr_gbr_v Organization Involvements ({res:bubs_organisation_involvements})lgt_r bubs_lov_gbr_geslacht_r Gender Types ({res:bubs_gender_types})lhp_r bubs_lov_http_robots_r HTTP Robots ({res:bubs_http_robots})lje_r bubs_lov_job_eindstatus_r Job End Status Types ({res:bubs_job_end_status_types})ljs_r bubs_lov_job_status_r Job Status Types ({res:bubs_job_status_types})lke_r bubs_lov_kse_detail_type_r Cash Flow Projection Detail Types ({res:bubs_cashflow_projection_detail_types})lkl_r bubs_lov_koppel_ind_r Usable as ({res:bubs_coupling_possibilities})lkr_r bubs_lov_kosten_opbr_r Cost Revenue Types ({res:bubs_cost_revenue_types})lkt_r bubs_lvr_klt_picklist_r Customers ({res:bubs_customers})llb bubs_loader_lob_v CLOBs to be Loaded ({res:bubs_clobs_to_be_loaded})lle_r bubs_lov_lineaire_functie_r Linear Functions ({res:bubs_linear_functions})lme_r bubs_lov_mime_ikoontje_r MIME Type Small Icon Types ({res:bubs_mime_type_small_icon_types})lnd bubs_landen_v Countries ({res:bubs_countries})loc bubs_locaties_v Locations ({res:bubs_locations})loc_r bubs_loc_picklist_r Locations ({res:bubs_locations})lon_r bubs_lov_opbrengst_termijnen_r Revenue Number of Terms ({res:bubs_revenue_number_of_terms})lop_r bubs_lov_overschot_comp_r Release Deviation Types ({res:bubs_release_balance_types})lot_r bubs_lvr_onr_picklist_rlpa_r bubs_lov_project_afgelopen_r Closed Projects ({res:bubs_closed_projects})lpe_r bubs_lov_pst_ikoontje_r Project Status Small Icon Types ({res:bubs_project_status_small_icon_types})lpm_r bubs_lov_projectvorm_r Project Form Types ({res:bubs_project_form_types})lpn_r bubs_lov_pst_ikoon_r Project Status Icon Type ({res:bubs_project_status_icon_types})lpp_r bubs_lvr_pe_picklist_r Project Entities ({res:bubs_project_entities})lps_r bubs_lov_project_status_r Project Status Types ({res:bubs_project_status_types})lpt_r bubs_lov_pjt_fin_result_r Project Financial Results ({res:bubs_project_financial_results})lra_r bubs_lov_records_per_pagina_r Records per Page Types ({res:bubs_records_per_page_types})lre bubs_lvr_relaties_v Organization Relations ({res:bubs_organisation_relations})lrg_r bubs_lov_reden_aanvraag_r Reason Access Request Types ({res:bubs_reason_access_request_types})lrj_r bubs_lov_rentedagen_pj_ind_r Interest Days per Year ({res:bubs_interest_days_per_year})lrt bubs_lvr_relatiesoorten_v Organization Relation Types ({res:bubs_organisation_relation_types})lrt_r bubs_lrt_picklist_r Organization Relation Types ({res:bubs_organisation_relation_types})lrt1_r bubs_lrt_picklist_combi_r Organization Relation Types ({res:bubs_organisation_relation_types})lrv_r bubs_lvr_relaties_vv_rlse_r bubs_lov_sigmoid_functie_r Sigmoid Functions ({res:bubs_sigmoid_functions})lsk_r bubs_lov_saldo_vrijg_kps_r Release Remaining Balance on Budgets ({res:bubs_release_balance_on_budgets})lss_r bubs_lov_sdr_status_r Scheduler Status Types ({res:bubs_scheduler_status_types})lst_r bubs_lov_saldo_vrijg_pjt_r Release deviation on Contract Types ({res:bubs_release_balance_on_contract_types})lsy_r bubs_lov_sdr_categorie_r Scheduler Category Types ({res:bubs_scheduler_category_types})lta_r bubs_lov_taak_afgelopen_r Processes Ended ({res:bubs_tasks_ended})lte_r bubs_lov_toets_categorie_r Application Control Outcomes ({res:bubs_application_control_outcomes})ltg_r bubs_lov_tmr_toepassing_r Text Mask Application Types ({res:bubs_text_mask_application_types})ltm_r bubs_lov_taak_mijn_r My Processes ({res:bubs_my_tasks})

31-05-2012 12:38 Page 10 / 3,222


Invantive Estate




Database ViewsCode Name Label Plurallue_r bubs_lov_uitsmeer_meth_r Cash Flow Distribution Methods ({res:bubs_cashflow_distribution_methods})lvg_r bubs_lov_vlag_r Flags ({res:bubs_flags})lvr bubs_leveranciers_v Organizations ({res:bubs_organisations})l4p_r bubs_lvr_001_p4_r Quarter dashboard displays report with organization details ({res:bubs_lvr_p4_1_pdf_rpt})mat bubs_mijn_rechten_r My Privileges ({res:bubs_my_privileges})mdg bubs_meldingen_v Messages ({res:bubs_messages})mdg_r bubs_mdg_picklist_r Messages ({res:bubs_messages})mdt_r bubs_med_picklist_r Monetary Units ({res:bubs_monetary_units})med bubs_munt_eenheden_v Monetary Units ({res:bubs_monetary_units})mfd_r bubs_mijn_functie_ids_r My Functions ({res:bubs_my_functions})mfe_r bubs_menu_functies_r Menu Functions ({res:bubs_menu_functions})mfi_r bubs_mijn_functies_r My Functions ({res:bubs_my_functions})mgn bubs_magazijnen_v Warehouses ({res:bubs_warehouses})mgn_r bubs_mgn_picklist_r Warehouses ({res:bubs_warehouses})mim bubs_menu_items_v Menu Items ({res:bubs_menu_items})mim_r bubs_mim_picklist_r Menu Items ({res:bubs_menu_items})mme_r bubs_mijn_menu_functies_r My Menu Functions ({res:bubs_my_menu_functions})mnp_r bubs_mnu_picklist_r Menus ({res:bubs_menus})mnu bubs_menus_v Menus ({res:bubs_menus})mnu_r bubs_mnu_r Menu Structure ({res:bubs_menu_structure})moe_r bubs_mijn_ola_rpt_functies_r My Outlook Report Functions ({res:bubs_my_outlook_report_functions})mpe_r bubs_mijn_profiel_waardes_r My Profile Values ({res:bubs_my_profile_values})mpt_r bubs_mogelijke_pjt_picklist_r Projects ({res:bubs_projects})msc bubs_mijn_rechten_src_r My Privileges ({res:bubs_my_privileges})mst bubs_mime_soorten_v MIME Types ({res:bubs_mime_types})mst_r bubs_mst_picklist_r MIME Types ({res:bubs_mime_types})mtk_r bubs_mijn_taken_r My Processes ({res:bubs_my_tasks})nls_r bubs_nls_parameters_r NLS Parameters ({res:bubs_nls_parameters})nrm bubs_normen_v Intended Values ({res:bubs_intended_values})nrm_r bubs_nrm_picklist_r Intended Values ({res:bubs_soll_values})nvg_r bubs_netto_verschuivingen_r Netted Budget Movements ({res:bubs_netted_budget_movements})obd_r bubs_obd_r Overview Additional Business Rules ({res:bubs_overview_additional_business_rules})obt bubs_opbrengsten_v Revenues ({res:bubs_revenues})ode bubs_ola_data_extracties_v Outlook Add-In Data Extractions ({res:bubs_outlook_addin_data_extractions})ode_r bubs_ode_picklist_r Database Object Definitions ({res:bubs_database_object_definitions})odt bubs_opdrachten_v Purchase Orders ({res:bubs_purchase_orders})oke bubs_lvr_kle_v Organization Classifications ({res:bubs_organisation_classifications})oke_r bubs_oke_picklist_r Organization Classifications ({res:bubs_organisation_classifications})okr_r bubs_lov_olk_klr_r Outlook Category Color ({res:bubs_outlook_category_color})oot_r bubs_oot_r Revenues Overview ({res:bubs_revenues_overview})opt_r bubs_ost_picklist_r Revenue Types ({res:bubs_revenue_types})oss_r bubs_lov_olk_sts_r Outlook Category Shortcut Keys ({res:bubs_outlook_category_shortcut_keys})ost bubs_opbrengst_soorten_v Revenue Types ({res:bubs_revenue_types})pae bubs_project_autorisaties_v Project Authorizations ({res:bubs_project_authorizations})pal bubs_project_allocaties_v Project Allocations ({res:bubs_project_allocations})pal_r bubs_pal_r Project Allocations ({res:bubs_project_allocations})pce bubs_pve_categorieen_v Project Version Categories ({res:bubs_project_version_categories})pce_r bubs_pce_picklist_r Project Version Categories ({res:bubs_project_version_categories})pfr_r bubs_lvr_picklist_ftr_r Suppliers ({res:bubs_suppliers})pgp bubs_product_groepen_v Product Groups ({res:bubs_product_groups})pgp_r bubs_pgp_picklist_r Product Groups ({res:bubs_product_groups})pgr bubs_pjt_gbr_v Project Involvements ({res:bubs_project_involvements})pjt bubs_projecten_v Projects ({res:bubs_projects})

31-05-2012 12:38 Page 11 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralpke bubs_pjt_kle_v Project Classifications ({res:bubs_project_classifications})pke_r bubs_pke_picklist_r Project Classifications ({res:bubs_project_classifications})pkr_r bubs_project_kopieer_r Copy Projects ({res:bubs_copy_projects})pkt_r bubs_pkt_r Price Lists ({res:bubs_pricelists})pkt1_r bubs_pkt_s1_r Price Lists ({res:bubs_pricelists})plt bubs_prijslijsten_v Price Lists ({res:bubs_pricelists})plt_r bubs_plt_picklist_r Price Lists ({res:bubs_pricelists})pod_r bubs_lvr_picklist_odt_r Suppliers ({res:bubs_order_takers})poe bubs_profiel_opties_v Profile Options ({res:bubs_profile_options})poe_r bubs_poe_picklist_r Profile Options ({res:bubs_profile_options})pok_r bubs_project_saldo_kps_r Projects Financial Status per Cost Category ({res:

bubs_projects_financial_status_per_cost_category})pot_r bubs_pot_r Production Overview ({res:bubs_production_overview})pov_r bubs_project_saldo_vnr_r Contracts Financial Status ({res:bubs_contracts_financial_status})ppd_r bubs_pjt_picklist_hoofd_r Master Projects ({res:bubs_master_projects})ppn_r bubs_pjt_picklist_finan_r Financial Projects ({res:bubs_financial_projects})ppt_r bubs_pjt_picklist_r Projects ({res:bubs_projects})pre bubs_pjt_relaties_v Project Relations ({res:bubs_project_relations})prl bubs_prijslijst_regels_v Price List Lines ({res:bubs_pricelist_lines})prr_r bubs_oracle_parameters_r Database Parameters ({res:bubs_oracle_parameters})prt bubs_pjt_relatiesoorten_v Project Relation Types ({res:bubs_project_relation_types})prt_r bubs_prt_picklist_r Project Relation Types ({res:bubs_project_relation_types})prt1_r bubs_prt_picklist_combi_r Project Relation Types ({res:bubs_project_relation_types})prv_r bubs_pjt_relaties_vv_rpsf_r bubs_project_status_pjtf_r Projects Financial Status ({res:bubs_projects_financial_status})psg bubs_pss_overgangen_v Project Phase Transitions ({res:bubs_project_phase_transitions})psg_r bubs_psg_picklist_r Project Phase Transitions ({res:bubs_project_phase_transitions})psk_r bubs_project_status_kps_r Projects Financial Status per Cost Category ({res:

bubs_projects_financial_status_per_cost_category})psr_r bubs_pjt_stat_uur_r Projects Statistics ({res:bubs_projects_statistics})pss bubs_project_statussen_v Project Statuses ({res:bubs_project_statuses})pss_r bubs_pss_picklist_r Project Statuses ({res:bubs_project_statuses})pst_r bubs_project_status_pjt_r Projects Financial Status ({res:bubs_projects_financial_status})ps1_r bubs_pot_s1_r Production Overview ({res:bubs_production_overview})ptn_r bubs_publiceren_tak_dmn_r Domains for Publish Process Note ({res:bubs_task_publish_domains})ptr_r bubs_planning_tak_r Processes Planning ({res:bubs_tasks_planning})pve bubs_project_versies_v Project Versions ({res:bubs_project_versions})pvr_r bubs_project_verwijder_r Delete Projects ({res:bubs_delete_projects})pvw bubs_project_versie_views_v Project Version Views ({res:bubs_project_version_views})pwe bubs_profiel_waardes_v Profile Option Values ({res:bubs_profile_option_values})pwe_r bubs_pwe_picklist_r Profile Option Values ({res:bubs_profile_option_values})pzr_r bubs_projecten_zichtbaar_r Visible Projects ({res:bubs_visible_projects})rae bubs_rol_autorisaties_v Role Authorizations ({res:bubs_role_authorizations})rae_r bubs_rae_picklist_r Role Authorizations ({res:bubs_role_authorizations})rdt_r bubs_red_picklist_r Reporting Units ({res:bubs_reporting_units})red bubs_rapportage_eenheden_v Reporting Units ({res:bubs_reporting_units})rme bubs_rente_methodes_v Interest Rate Methods ({res:bubs_interest_rate_methods})rme_r bubs_rme_picklist_r Interest Rate Methods ({res:bubs_interest_rate_methods})rol bubs_rollen_v Roles ({res:bubs_roles})rol_r bubs_rol_picklist_r Roles ({res:bubs_roles})rps_r bubs_rtd_picklist_r Time Reporting Units ({res:bubs_time_reporting_units})rpt_r bubs_ref_pjt_r Any Projects ({res:bubs_any_projects})rtd bubs_rapport_tijd_eenheden_v Time Reporting Units ({res:bubs_time_reporting_units})rur_r bubs_resterende_uren_r Remaining Hours ({res:bubs_remaining_hours})

31-05-2012 12:38 Page 12 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralrvm bubs_rechtsvormen_v Legal Forms ({res:bubs_legal_forms})rvm_r bubs_rvm_picklist_r Legal Forms ({res:bubs_legal_forms})sct bubs_scripts_v Background Scripts ({res:bubs_scripts})sct_r bubs_sct_picklist_r Background Scripts ({res:bubs_background_scripts})sdr bubs_schedulers_v Schedulers ({res:bubs_schedulers})sdr_r bubs_sdr_picklist_r Schedulers ({res:bubs_schedulers})sft_r bubs_sqlloader_formats_r SQL*Loader Formats ({res:bubs_sqlloader_formats})spe_r bubs_spe_r Mergeable Project Versions ({res:bubs_mergeable_project_versions})spr bubs_script_parameters_v Script Parameters ({res:bubs_script_parameters})spr_r bubs_spr_picklist_r Script Parameters ({res:bubs_script_parameters})spw_r bubs_sys_profiel_waardes_r System Profile Values ({res:bubs_system_profile_values})sqe_r bubs_sequences_r Sequences ({res:bubs_sequences})tak bubs_taken_v Processes ({res:bubs_tasks})tak_r bubs_tak_r Processes ({res:bubs_tasks})tal bubs_talen_v Languages ({res:bubs_languages})tbl_r bubs_tabellen_r Tables ({res:bubs_tables})tce bubs_taak_categorieen_v Process Categories ({res:bubs_task_categories})tce_r bubs_tce_picklist_r Process Categories ({res:bubs_task_categories})tfk_r bubs_tabellen_fysiek_r Physical Tables ({res:bubs_physical_tables})tgr bubs_tak_gbr_v Process Involvements ({res:bubs_task_involvements})tip bubs_tips_v Tips ({res:bubs_tips})tip_r bubs_tip_picklist_r Tips ({res:bubs_tips})tit bubs_taak_impacten_v Process Impacts ({res:bubs_task_impacts})tit_r bubs_tit_picklist_r Process Impacts ({res:bubs_task_impacts})tke bubs_tak_kle_v Process Classifications ({res:bubs_task_classifications})tke_r bubs_tke_picklist_r Process Classifications ({res:bubs_task_classifications})tkr_r bubs_taak_kopieer_r Copy Processes ({res:bubs_copy_tasks})tkt_r bubs_tpt_r Processes per Relation ({res:bubs_tasks_per_relation})tk1_r bubs_tak_s1_r Processes ({res:bubs_tasks})tlr bubs_tellers_v Counters ({res:bubs_counters})tlr_r bubs_tlr_picklist_r Counters ({res:bubs_counters})tmr bubs_tekst_maskers_v Text Masks ({res:bubs_text_masks})tmr_r bubs_tmr_picklist_r Text Masks ({res:bubs_text_masks})tnc bubs_tne_categorieen_v Process Note Categories ({res:bubs_task_note_categories})tnc_r bubs_tnc_picklist_r Process Categories ({res:bubs_task_categories})tne bubs_taak_notities_v Process Notes ({res:bubs_task_notes})tog bubs_taak_oorsprongen_v Process Origins ({res:bubs_task_origins})tog_r bubs_tog_picklist_r Process Origins ({res:bubs_task_origins})tpt_r bubs_tal_picklist_r Languages ({res:bubs_languages})tre bubs_tak_relaties_v Process Relations ({res:bubs_task_relations})tre_r bubs_tut_rente_actie_r Process Unit Interest Actions ({res:bubs_task_unit_interest_actions})trl bubs_termijnschema_regels_v Payment Schedule Lines ({res:bubs_payment_schedule_lines})trl_r bubs_trl_picklist_r Payment Schedule Lines ({res:bubs_payment_schedule_lines})trt bubs_tak_relatiesoorten_v Process Relation Types ({res:bubs_task_relation_types})trt_r bubs_trt_picklist_r Process Relation Types ({res:bubs_task_relation_types})trt1_r bubs_trt_picklist_combi_r Process Relation Types ({res:bubs_task_relation_types})trv_r bubs_tak_relaties_vv_rtsa bubs_termijnschemas_v Payment Schedules ({res:bubs_payment_schedules})tsa_r bubs_tsa_picklist_r Payment Schedules ({res:bubs_payment_schedules})tse bubs_transacties_v Transactions ({res:bubs_transactions})tsg bubs_tss_overgangen_v Process Status Transitions ({res:bubs_task_status_transitions})tsg_r bubs_tak_stat_tsg_r Process Status Transition Statistics ({res:bubs_task_status_transition_statistics})tsp_r bubs_tsg_picklist_r Process Status Transitions ({res:bubs_task_status_transitions})

31-05-2012 12:38 Page 13 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluraltsr_r bubs_tak_stat_uur_r Processes Statistics ({res:bubs_tasks_statistics})tss bubs_taak_statussen_v Process Statuses ({res:bubs_task_statuses})tss_r bubs_tss_picklist_r Process Statuses ({res:bubs_task_statuses})tts bubs_toetsen_v Current Values ({res:bubs_current_values})tt1_r bubs_tpt_s1_r Processes per Relation ({res:bubs_tasks_per_relation})tug bubs_tus_overgangen_v Process Unit Status Transitions ({res:bubs_task_unit_status_transitions})tug_r bubs_tug_picklist_r Process Unit Status Transitions ({res:bubs_task_unit_status_transitions})tul_r bubs_testurl_r Report URLs ({res:bubs_report_urls})tus bubs_tak_unt_statussen_v Process Unit Statuses ({res:bubs_task_unit_statuses})tus_r bubs_tus_picklist_r Process Unit Statuses ({res:bubs_task_unit_statuses})tut bubs_tak_unt_v Process Units ({res:bubs_task_units})tvd bubs_tak_vdd_v Process Skills ({res:bubs_task_skills})tvk_r bubs_views_fysiek_r Physical Views ({res:bubs_physical_views})twr_r bubs_te_werken_uren_r Working Hours ({res:bubs_working_hours})udg_r bubs_uren_per_dag_r Hours per Day ({res:bubs_hours_per_day})udk_r bubs_uur_r Timesheets ({res:bubs_timesheets})ud1_r bubs_uur_s1_r Timesheets ({res:bubs_timesheets})uee bubs_unt_egp_waardes_v Article Properties ({res:bubs_article_properties})uee_r bubs_uee_picklist_r Unit Property Values ({res:bubs_unit_property_values})unt bubs_units_v Units ({res:bubs_units})unt_r bubs_unt_picklist_r Units ({res:bubs_units})uor_r bubs_uor_r Invoiced Timesheets ({res:bubs_invoiced_timesheets})upe bubs_usp_eigenschappen_v Article Properties ({res:bubs_article_properties})upe_r bubs_upe_picklist_r Article Group Properties ({res:bubs_article_group_properties})upk_r bubs_uren_per_week_r Hours per Week ({res:bubs_hours_per_week})ure bubs_unt_relaties_v Unit Relations ({res:bubs_unit_relations})urt bubs_unt_relatiesoorten_v Unit Relation Types ({res:bubs_unit_relation_types})urt_r bubs_urt_picklist_r Unit Relation Types ({res:bubs_unit_relation_types})urt1_r bubs_urt_picklist_combi_r Unit Relation Types ({res:bubs_unit_relation_types})urv_r bubs_unt_relaties_vv_ruse bubs_ust_eigenschappen_v Article Properties ({res:bubs_article_properties})use_r bubs_use_picklist_r Article Properties ({res:bubs_article_properties})usg bubs_uss_overgangen_v Timesheet Status Transition ({res:bubs_timesheet_status_transitions})usg_r bubs_usg_picklist_r Timesheet Status Transition ({res:bubs_timesheet_status_transitions})usp bubs_unit_soort_groepen_v Article Groups ({res:bubs_article_groups})usp_r bubs_usp_picklist_r Article Groups ({res:bubs_unit_type_groups})uss bubs_uur_statussen_v Timesheet Statuses ({res:bubs_timesheet_statuses})uss_r bubs_uss_picklist_r Timesheet Statuses ({res:bubs_timesheet_statuses})ust bubs_unit_soorten_v Articles ({res:bubs_unit_types})ust_r bubs_ust_picklist_r Articles ({res:bubs_unit_types})ute bubs_unit_transacties_v Unit Transactions ({res:bubs_unit_transactions})utk_r bubs_uren_per_taak_r Hours per Process ({res:bubs_hours_per_task})utt bubs_ute_soorten_v Unit Transaction Types ({res:bubs_unit_transaction_categories})utt_r bubs_utt_picklist_r Unit Transaction Types ({res:bubs_unit_transaction_categories})uur bubs_uren_v Timesheets ({res:bubs_timesheets})vba_r bubs_verbindingsdata_r Connection Data ({res:bubs_connection_data})vba_v bubs_verbindingsdata_v Connection Data ({res:bubs_connection_data})vbg bubs_kps_vrwcht_bstllngen_v Latest Estimates ({res:bubs_latest_estimates})vbt bubs_volgnummer_budgetten_v Contract Budgets ({res:bubs_contract_budgets})vdd bubs_vaardigheden_v Skills ({res:bubs_skills})vdd_r bubs_vdd_picklist_r Skills ({res:bubs_skills})vek_r bubs_vda_gbr_email_uk_r Person Unique Email Addresses ({res:bubs_person_unique_email_addresses})vel_r bubs_vda_email_r Email Addresses ({res:bubs_email_addresses})

31-05-2012 12:38 Page 14 / 3,222


Invantive Estate




Database ViewsCode Name Label Pluralvfs_r bubs_vsd_fouten_tekst_r Contract Financial Status Errors Text ({res:bubs_contract_financial_status_errors_text})vft_r bubs_vsd_fouten_r Contract Financial Status Errors ({res:bubs_contract_financial_status_errors})vge_r bubs_vda_gbr_email_v Person Email Addresses ({res:bubs_person_email_addresses})vgl_r bubs_vda_gbr_tel_v Person Phone Numbers ({res:bubs_person_phone_numbers})vgx_r bubs_vda_gbr_fax_v Person Fax Numbers ({res:bubs_person_fax_numbers})vg1_r bubs_vda_gbr_fax_gbr_vvg2_r bubs_vda_gbr_fax_lvr_vvg3_r bubs_vda_gbr_tel_gbr_vvg4_r bubs_vda_gbr_tel_lvr_vvle_v bubs_vda_lvr_email_v Organisation Email Addresses ({res:bubs_organisation_email_addresses})vll_v bubs_vda_lvr_tel_v Organisation Phone Numbers ({res:bubs_organisation_phone_numbers})vlx_v bubs_vda_lvr_fax_v Organisation Fax Numbers ({res:bubs_organisation_fax_numbers})vpt_r bubs_lvr_picklist_r Organizations ({res:bubs_organisations})vrd bubs_voorraden_v Stock Levels ({res:bubs_stock_levels})vsd bubs_volgnummer_standen_v Contract Financial Statuses ({res:bubs_contract_financial_statuses})vse bubs_versies_v Versions ({res:bubs_versions})vse_r bubs_vse_picklist_r Versions ({res:bubs_versions})vtg bubs_vertalingen_v Translations ({res:bubs_translations})vtg_r bubs_vertalingen_r Translations ({res:bubs_translations})vtp_r bubs_vtg_picklist_r Translations ({res:bubs_translations})v4p_r bubs_vdd_001_p4_r Quarter dashboard displays report with user skills ({res:bubs_vdd_p4_1_pdf_rpt})wat_r bubs_wsa_picklist_r Working Schedules ({res:bubs_work_schedules})wbh_r bubs_wbh_r Involvements ({res:bubs_involvements})wbs_r bubs_wbh_det_js_r Involvements ({res:bubs_involvements})wbt_r bubs_wbh_det_r Involvements ({res:bubs_involvements})wce_r bubs_lov_wce_r Labor Type Categories ({res:bubs_labour_type_categories})wfe bubs_waarde_formules_v Value Formulas ({res:bubs_value_formulas})wfe_r bubs_wfe_picklist_r Value Formulas ({res:bubs_value_formulas})wsa bubs_werk_schemas_v Working Schedules ({res:bubs_work_schedules})wse bubs_web_sites_v Websites ({res:bubs_web_sites})wse_r bubs_wse_picklist_r Websites ({res:bubs_web_sites})wsi bubs_web_site_interacties_v Website Accesses ({res:bubs_web_site_accesses})wst bubs_werksoorten_v Labor Types ({res:bubs_labour_types})wst_r bubs_wst_picklist_r Labor Types ({res:bubs_labour_types})wug bubs_wsa_uitzonderingen_v Working Schedule Exceptions ({res:bubs_work_schedule_exceptions})zst bubs_zware_sql_statements_v Heavy SQL Statements ({res:bubs_heavy_sql_statements})

31-05-2012 12:38 Page 15 / 3,222


Invantive Estate




TablesCodeName Label Pluralaoebubs_aanvragen_ojt_actie Requested Object Actions ({res:bubs_requested_object_actions})

Table Definitionaoe - bubs_aanvragen_ojt_actieCodeName bubs_aanvragen_ojt_actie

aoe

Requests to perform an action on an object.DefinitionExample Update thumbnail of DCT 123.

User May Select

AutocompletedCreateCreate HistoryShow HistoryUser May DeleteUser May Insert

Label Plural when Referenced Requested Object Actions ({res:bubs_requested_object_actions})

User May Update

Label Plural Requested Object Actions ({res:bubs_requested_object_actions})

Label Singular Requested Object Action ({res:bubs_requested_object_action})

Documentation

Label Singular when ReferencedNumber of Rows

Requested Object Action ({res:bubs_requested_object_action})

Interface?

Default Reference Columns id,seqData Category Transaction

Derived

☐☒☒☒☐☐☐☐☐☐

31-05-2012 12:38 Page 16 / 3,222


Invantive Estate





Data Type Label SingularNameTable Columns

DefinitionOpt.aantal_pogingen Number of completed tries to execute the action.number(9, 0) Number of Tries ({res:

bubs_number_of_tries})☐

afgehandeld_vlag Indicator whether the message has been processed.char(1 byte) Finished ({res:bubs_finished})☐

datum_volgende_poging Date of the next try to execute action. Null when the messagehas already been delivered.

Next Try ({res:bubs_date_next_try})

☐

id The number assigned to this record. This number is unique inthe whole table. The number will increase with time, but there isno guarantee that the numbers used build a contiguous rangeof numbers. This value will never change after creation of therecord.

number(15, 0) Requested Object Action({res:bubs_requested_object_action})

☐

seq Unique numeric code. Generally, the column is introduced tocreate an artificial natural unique index and it's value is identicalto the value of the column ID.

number(15, 0) Number ({res:bubs_number})☐

actie Action to be performed.varchar2(240 char) Action ({res:bubs_action})☒

datum_eerste_poging Date of the initial try to execute the action.Date First Try ({res:bubs_date_first_try})

☒

datum_laatste_poging Date of the last try to execute the action.Last Try ({res:bubs_date_last_try})

☒

datum_vervalt The system time at which the action request can be purged andat which it will be executed no longer.

No Delivery After ({res:bubs_do_not_deliver_after})

☒

laatste_melding Message during the last effort to execute the action.varchar2(4000 char) Last Message ({res:bubs_last_message})

☒

parameter1 First parameter.varchar2(4000 char) Parameter 1 ({res:bubs_parameter1})

☒

parameter10 10th parameter.varchar2(4000 char) Parameter 10 ({res:bubs_parameter10})

☒

parameter2 2nd parameter.varchar2(4000 char) Parameter 2 ({res:bubs_parameter2})

☒

parameter3 3rd parameter.varchar2(4000 char) Parameter 3 ({res:bubs_parameter3})

☒


☒


☒


☒


☒


☒


☒

ref_sleutel ID of the object to which the message is associated.number(15, 0) Source ID ({res:bubs_association_id})

☒

ref_tabel Table alias of the table containing the object associated with.varchar2(30 char) Source ({res:bubs_association})

☒

31-05-2012 12:38 Page 17 / 3,222


Invantive Estate





Table Column Detailsbubs.aoe.aantal_pogingen - aantal_pogingenName aantal_pogingenDefinition Number of completed tries to execute the action.Example 45.Definition for ManualDocumentation

Display In LOV☐

In Search Filter☐ ☐

In Search ResultsIn Record☐

Label Plural as Reference

Number of Tries ({res:bubs_number_of_tries})

Autocompleted

Confidential

Label Singular

Derived

Label Plural

System ColumnCreate

Expression Default Value

Label Singular as Reference

☐☐☒☐☐

Data Type number(9, 0)Nullable ☐

Translatable ☐

Display Order 100B042

ConversionAdd Purchase Order

coalesce(:orig, 0)bubs.aoe.actie - actieName actieDefinition Action to be performed.Example THUMBNAILDefinition for ManualDocumentation

Display In LOV☐

In Search Filter☐ ☐

In Search ResultsIn Record☐

Label Plural as Reference

Action ({res:bubs_action})

Autocompleted

Confidential

Label Singular

Derived

Label Plural

System ColumnCreate

Expression Default Value

Label Singular as Reference

☐☐☒☐☐

Data Type varchar2(240 char)Nullable ☒

Translatable ☐

Display Order 50B042

ConversionAdd Purchase Order

:orig

31-05-2012 12:38 Page 18 / 3,222

http://www.invantive.combubs_main_pjt.dohttp://tst.estate.invantive.com/smoke_bubs/bubs_rpt.do?Button_Execute=Execute&P_APN_CODE=bubs&P_INCL_TBE_VLAG=N&P_INCL_TBE_VLAG=Y&P_INCL_TCN_VLAG=N&P_INCL_TCN_VLAG=Y&P_INCL_TCL_VLAG=N&P_INCL_TCL_VLAG=Y&P_INCL_ARE_VLAG=N&P_INCL_ARE_VLAG=Y&P_INCL_RCT_VLAG=N&P_INCL_RCT_VLAG=Y&P_INCL_TBE_CONTENTS_VLAG=N&P_INCL_TBE_CONTENTS_VLAG=Y&P_I