Logical Model Mapping for the Financial Management Model

1 Introduction
2 AFEs View
3 Business Associates View
4 Business Associate Addresses View
5 Cost Centres View
6 Line Items View
7 Organizations View
8 Vouchers View

Introduction

The Optix Logical Model represents the data from a business perspective therefore; the object and attribute names may not exactly match that of the Qbyte physical database tables. The following cross reference documents the physical to logical mapping for objects and attributes where the Optix naming differs from the physical structure.

AFEs View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
authorizations_for_expenditure.afe_udf_1_code - afe_udf_20_code	lom_afes.custom_content1 - custom_content20
authorizations_for_expenditure.afe_reporting_udf_1_code - afe_reporting_udf_3_code	lom_afes.reporting_custom_content1 - reporting_custom_content3
operator_afes.client_id	lom_afes.operated_flag - to determine if an AFE is operated or not; Optix reads the client_id value from Qbyte and determines if the Business Associate record for the specified client_id is linked to an organization or not. If the Business Associate record is linked to an organization in Qbyte, the AFE is operated. If the Business Associate record is not linked to an organization in Qbyte, the AFE is non operated.

Business Associates View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
business_associates.ba_udf_1_code - ba_udf_30_code	lom_business_associates.custom_content1 - custom_content30

Business Associate Addresses View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
ba_addresses.alternate_ba_name_1	lom_ba_addresses.override_ba_name
ba_addresses.alternate_ba_name_2	lom_ba_addresses.override_ba_name2

Cost Centres View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table | Column)

Optix (View | Attribute)

cost_centres.cc_udf_1_code - cc_udf_20_code

lom_cost_centres.custom_content1 - custom_content20

cost_centres.operator_client_id

lom_cost_centre.operated_flag - to determine if a Cost Centre is operated or not; Optix reads the operator_client_id value from Qbyte and determines if the Business Associate record for the specified operator_client_id is linked to an organization or not. If the Business Associate record is linked to an organization in Qbyte, the Cost Centre is operated. If the Business Associate record is not linked to an organization in Qbyte, the Cost Centre is non operated.

Line Items View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
line_items.gl_code	lom_line_items.sub_feature
line_items.result_invc_id	lom_line_items.control_account_invoice_id
line_items.src_invc_id	lom_line_items.distribution_invoice_id
line_items_supplement.env_code	lom_line_Items.supplemental_content1
line_items_supplement.alternate_gl_code	lom_line_items.supplemental_content2
line_items_supplement.user_defined_tag	lom_line_items.supplemental_content3
line_items_supplement.alternate_client_id	lom_line_items.supplemental_ba_id
line_items.li_rem	lom_line_items.description

Organizations View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
organizations.gst_reg_num	lom_organizations.business number

Vouchers View

Qbyte FM (Table \| Column)	Optix (View \| Attribute)

Qbyte FM (Table \| Column)	Optix (View \| Attribute)
vouchers.voucher_rem	lom_vouchers.description