<?php

namespace App\Reports\Sources\Ticketing;

class ColumnsManager extends \App\Reports\Sources\ColumnsManagerAbstract
{

	/**
	 * The definition of report source columns.
	 * @var array
	 */
	protected array $columnsCfg = [

		'currentRowIndex'					=> [ 'type' => 'numeric',   'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",     	    'cat' => "tktGen"],
		'tkt_key'							=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "tktGen", 'disabled' => true ],
		'tkt_date'							=> [ 'type' => 'date',		'dbDef' => "DATE NULL",										'cat' => "tktGen" ],
		'tkt_dateYM'						=> [ 'type' => 'yearMonth',	'dbDef' => "DATE NULL",										'cat' => "tktGen" ],
		'tkt_dateY'							=> [ 'type' => 'year',		'dbDef' => "YEAR NULL",										'cat' => "tktGen" ],

		'tkt_operation'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "tktGen" ], // TICKET, REFUNDED, REFUND
		'tkt_tktNumber'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "tktGen" ],
		'tkt_imported'						=> [ 'type' => 'boolean',	'dbDef' => "TINYINT NOT NULL DEFAULT '0'",					'cat' => "tktGen" ], // indicates if this is manual / imoprted ticket
		'tkt_voided'						=> [ 'type' => 'boolean',	'dbDef' => "TINYINT NOT NULL DEFAULT '0'",					'cat' => "tktGen" ],

		'impServ_id'						=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "impService" ],
		'impServ_idServiceExtSys'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_systemId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "impService" ],
		'impServ_systemCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_systemName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_serviceCode'				=> [ 'type' => 'string',	'dbDef' => "CHAR(2) NOT NULL DEFAULT ''",					'cat' => "impService" ],
		'impServ_serviceName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_systemServiceCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_processStatusCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_processStatusName' 		=> [ 'type' => 'string',    'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_systemStatusCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_systemStatusName' 			=> [ 'type' => 'string',    'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_ticketNumber'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_ticketNumberConj'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_ticketNumberList'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_ticketDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_ticketDateYM' 				=> [ 'type' => 'yearMonth', 'dbDef' => "DATE NULL DEFAULT NULL",        			 	'cat' => "impService" ],
		'impServ_ticketDateY' 				=> [ 'type' => 'year',      'dbDef' => "YEAR NULL DEFAULT NULL",        			 	'cat' => "impService" ],
		'impServ_idImpServReissued'			=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "impService" ],
		'impServ_reissue'					=> [ 'type' => 'boolean',	'dbDef' => "TINYINT NOT NULL DEFAULT '0'",					'cat' => "impService" ],
		'impServ_reissuedTktNumber'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_reissuedTktDate'			=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_co2EmissionsPerSegments'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService", 'formula'=>['type'=>'entity', 'entity'=>'ImportedService', 'id'=>'impServ_id', 'attribute'=>'itinerary_co2EmissionsPerSegments']],
		'impServ_co2EmissionsTotal'			=> [ 'type' => 'numeric',	'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impService", 'formula'=>['type'=>'entity', 'entity'=>'ImportedService', 'id'=>'impServ_id', 'attribute'=>'itinerary_co2EmissionsTotal']],
		'impServ_ticketDesignator'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService", 'formula'=>['type'=>'entity', 'entity'=>'ImportedService', 'id'=>'impServ_id', 'attribute'=>'itinerary_ticketDesignator']],
		'impServ_startDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_endDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_pax'						=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impService" ],
		'impServ_passengerLastName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_passengerFirstName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_passengerFullName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(201) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryContinentCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryContinentName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryRegionCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryRegionName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCountryTCArea'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "impService" ],
		'impServ_deptCityCode3'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptCityName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptStationCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_deptStationName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryContinentCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryContinentName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryRegionCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryRegionName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCountryTCArea'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "impService" ],
		'impServ_destCityCode3'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destCityName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destStationCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_destStationName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_locationsDetails'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impService", 'disabled' => true ],
		'impServ_offerProductType'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService"],
		'impServ_supplierId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "impService" ],
		'impServ_supplierAlias'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_supplierIataCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_supplierTktCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_offerExtSysResId'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_offerExtSysResDate'		=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_offerExtSysResDateYM' 		=> [ 'type' => 'yearMonth', 'dbDef' => "DATE NULL DEFAULT NULL",        			 	'cat' => "impService" ],
		'impServ_offerExtSysResDateY' 		=> [ 'type' => 'year',      'dbDef' => "YEAR NULL DEFAULT NULL",        			 	'cat' => "impService" ],

		'impServ_offerConfirmationNo'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_formOfPayment'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_optionDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_isNdc'						=> [ 'type' => 'boolean',	'dbDef' => "TINYINT NOT NULL DEFAULT 0",					'cat' => "impService" ],
		'impServ_offerTourCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_reasonName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_subReasonName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impService" ],

		'impServ_itinerary_segmentsCount'	=> [ 'type' => 'numeric',	'dbDef' => "TINYINT NOT NULL DEFAULT '0'",					'cat' => "impService" ],
		'impServ_itinerary_flightNumbers'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(60) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_flightNumbersExt' => [ 'type' => 'string',	'dbDef' => "VARCHAR(80) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_firstClassCode'	=> [ 'type' => 'string',	'dbDef' => "CHAR(1) NOT NULL DEFAULT ''",					'cat' => "impService" ],
		'impServ_itinerary_firstClassName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_classCodes'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(40) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_fareBasis'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_flightDurations'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(60) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_totalDuration'	=> [ 'type' => 'string', 	'dbDef' => "TIME NULL DEFAULT NULL",						'cat' => "impService" ],
		'impServ_itinerary_flightDistances'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_itinerary_flightDistanceTotal' => [ 'type' => 'string', 'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0",			'cat' => "impService" ],
		'impServ_itinerary'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impService", 'disabled' => true ],

		'impServ_addTime'					=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "impService" ],
		'impServ_blockTime'					=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "impService" ],
		'impServ_blockUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impService" ],
		'impServ_blockUserName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impService" ],
		'impServ_blockComments'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",				'cat' => "impService" ],

		'impServ_officeId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_officeName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_userId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_userName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_bookOfficeSystem'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_bookOfficeId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_bookOfficeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_bookOfficeIataNumber'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_bookUserSystem'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_bookUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_bookUserName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_issueOfficeSystem'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_issueOfficeId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_issueOfficeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_issueOfficeIataNumber'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_issueUserSystem'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_issueUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_issueUserName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_refundOfficeSystem'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_refundOfficeId'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_refundOfficeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_refundOfficeIataNumber'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_refundUserSystem'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_refundUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT 0",					'cat' => "impServiceUsers" ],
		'impServ_refundUserName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impServiceUsers" ],
		'impServ_usersDetails'				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impServiceUsers", 'disabled' => true, 'content'=>'assocArray' ],

		'impServ_total'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_currency'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "impServicePrices" ],
		'impServ_currencyRate'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_workCurrencyRate'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_invCurrencyRate'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_priceComponents'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impServicePrices", 'disabled' => true],
		'impServ_refundDetails'				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impServicePrices", 'disabled' => true, 'content'=>'assocArray' ],
		'impServ_ignoreSupplierOnDocs'		=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NULL DEFAULT NULL",			'cat' => "impServicePrices" ],
		'impServ_commissionable'			=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NULL DEFAULT NULL",			'cat' => "impServicePrices" ],
		'impServ_supplierPriceTotal'		=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_servicePriceTotal'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_servicePriceVat'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_commissionTotal'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_commissionPercent'			=> [ 'type' => 'percent',	'dbDef' => "DECIMAL(8,7) NOT NULL DEFAULT '0'",				'cat' => "impServicePrices" ],
		'impServ_discountTotal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_serviceFeeTotal'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_taxTotal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_taxVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_penaltyTotal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_taxDetails'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(300) NOT NULL DEFAULT ''",				'cat' => "impServicePrices", 'disabled' => true, 'content'=>'assocArray'],
		'impServ_taxesFullList'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",				'cat' => "impServicePrices" ],
		'impServ_netCompany'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_estimatedRevenue'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "impServicePrices" ],
		'impServ_processedRemarks'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "impServicePrices", 'disabled' => true, 'content'=>'remarks'],

		'impOrder_id'						=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "impOrder" ],
		'impOrder_idOrderExtSys'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_date'						=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "impOrder" ],
		'impOrder_originalCorporateName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(170) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_matchedCorporateId'		=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "impOrder" ],
		'impOrder_matchedCorporateAlias'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(170) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_miceProjectId'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "impOrder" ],
		'impOrder_miceProjectName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(250) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_userId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "impOrder" ],
		'impOrder_userName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_officeId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "impOrder" ],
		'impOrder_officeName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "impOrder" ],
		'impOrder_addTime'					=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "impOrder" ],

		'order_id'							=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "order" ],
		'order_convertedId'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(8) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_code'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_number'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_date'						=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "order" ],
		'order_dateYM' 						=> [ 'type' => 'yearMonth', 'dbDef' => "DATE NULL DEFAULT NULL",        			 	'cat' => "order" ],
		'order_dateY' 						=> [ 'type' => 'year',      'dbDef' => "YEAR NULL DEFAULT NULL",        			 	'cat' => "order" ],
		'order_autoProcessRuleId'			=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "order" ],
		'order_typeCode'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_typeName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_flagCode'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_flagName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_servicesTypeCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_servicesTypeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_ownerCustId'					=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "order" ],
		'order_ownerCustName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(201) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_ownerCustProcessedRemarks'	=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "order", 'disabled' => true, 'content'=>'remarks'],
		'order_ownerCorpId'					=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "order" ],
		'order_ownerCorpAlias'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_ownerCorpSegmentId'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "order" ],
		'order_ownerCorpSegmentName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_ownerCorpProcessedRemarks'	=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "order", 'disabled' => true, 'content'=>'remarks'],
		'order_ownerCorpOfficeId'			=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "order" ],
		'order_ownerCorpOfficeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_ownerCorpGroupsList' 		=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL", 							 	'cat' => "order", 'formula' => ['type' => 'entity', 'entity' => 'Corporate', 'id' => 'order_ownerCorpId', 'attribute' => 'groupElementsNames']],
		'order_contactPersonId'				=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "order" ],
		'order_contactPersonName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(201) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_corporatesList' 				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL", 							 	'cat' => "order", 'formula' => ['type' => 'entity', 'entity' => 'Order', 'id' => 'order_id', 'attribute' => 'corporatesAliasList']],
		'order_miceProjectId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "order" ],
		'order_miceProjectName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(250) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_description'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL ",								'cat' => "order" ],
		'order_comments'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL ",								'cat' => "order" ],
		'order_notes'						=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL ",								'cat' => "order" ],
		'order_statusOpCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_statusFinCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "order" ],
		'order_genDocsAssoc' 				=> [ 'type' => 'string',    'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",              'cat' => "order", 'disabled' => true, 'content'=>'assocArray'],
		'order_addTime'						=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "order" ],

		'order_userId'						=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "orderUser" ],
		'order_userName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "orderUser" ],
		'order_officeId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "orderUser" ],
		'order_officeName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "orderUser" ],
		'order_departmentId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "orderUser" ],
		'order_departmentName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "orderUser" ],
		'order_addUserId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "orderUser" ],
		'order_addUserName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "orderUser" ],

		'service_id'						=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "service" ],
		'service_isPackageSubservice'		=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "service" ],
		'service_idPackageService'			=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "service" ],
		'service_linkedToIdService'			=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "service" ],
		'service_idAutoProcessRule'			=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "service" ],
		'service_serviceCode'				=> [ 'type' => 'string',	'dbDef' => "CHAR(2) NOT NULL DEFAULT ''",					'cat' => "service" ],
		'service_serviceName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_statusOpCode'				=> [ 'type' => 'string',	'dbDef' => "CHAR(2) NOT NULL DEFAULT ''",					'cat' => "service" ],
		'service_statusFinCode'				=> [ 'type' => 'string',	'dbDef' => "CHAR(2) NOT NULL DEFAULT ''",					'cat' => "service" ],
		'service_pax'						=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "service" ],
		'service_firstPsgId'				=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "service" ],
		'service_firstPsgName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(201) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_firstPsgTypeCode'			=> [ 'type' => 'string',	'dbDef' => "CHAR(1) NOT NULL DEFAULT ''",					'cat' => "service" ],
		'service_firstPsgTypeName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_firstPsgSegmentId'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "service" ],
		'service_firstPsgSegmentName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_firstPsgProcessedRemarks'	=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service", 'disabled' => true, 'content'=>'remarks' ],
		'service_definedPsgListStd'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service", 'formula'=>['type'=>'entity', 'entity'=>'Service', 'id'=>'service_id', 'attribute'=>'definedPassengersNameListStd']],
		'service_ticketNumber'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_ticketNumberList'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],
		'service_ticketsDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "service" ],
		'service_startDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "service" ],
		'service_endDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "service" ],
		'service_duration'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "service" ],
		'service_estInvoiceDate'			=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "service" ],
		'service_estCashDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "service" ],
		'service_agencyCostCenterCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_agencyCostCenterName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",				'cat' => "service" ],
		'service_extSystemsList'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],

		'service_description'				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],
		'service_comments'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],
		'service_preferences'				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],
		'service_remarks'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service" ],
		'service_processedRemarks'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "service", 'disabled' => true, 'content'=>'remarks' ],
		'service_genDocsAssoc' 				=> [ 'type' => 'string',    'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",              'cat' => "service", 'disabled' => true, 'content'=>'assocArray'],
		'service_addTime'					=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "service" ],
		'service_lastUpdateTime'			=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "service" ],

		'service_userId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "serviceUser" ],
		'service_userName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "serviceUser" ],
		'service_officeId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "serviceUser" ],
		'service_officeName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "serviceUser" ],
		'service_addUserId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "serviceUser" ],
		'service_addUserName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "serviceUser" ],
		'service_updateUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "serviceUser" ],
		'service_updateUserName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "serviceUser" ],

		'service_departureCountryCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryContinentCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryContinentName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryRegionCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryRegionName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCountryTCArea'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_departureCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "serviceLocation" ],
		'service_departureStationCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCountryCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCountryName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCountryContinentCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",			'cat' => "serviceLocation" ],
		'service_destinationCountryContinentName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",			'cat' => "serviceLocation" ],
		'service_destinationCountryRegionCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCountryRegionName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCountryTCArea'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_destinationCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "serviceLocation" ],
		'service_destinationStationCode' 		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "serviceLocation" ],
		'service_internationalIndicator'		=> [ 'type' => 'string', 	'dbDef' => "ENUM('I','D') NOT NULL", 						'cat' => "serviceLocation"],

		'offer_id'							=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "offer" ],
		'offer_supplierId'					=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "offer" ],
		'offer_supplierAlias'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_supplierIataCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_supplierTktCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_offerType'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_serviceCode'					=> [ 'type' => 'string',	'dbDef' => "CHAR(2) NOT NULL DEFAULT ''",					'cat' => "offer" ],
		'offer_serviceName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_locationCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(25) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_locationName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(25) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_calculationCode'				=> [ 'type' => 'numeric',	'dbDef' => "TINYINT NOT NULL DEFAULT '0'",					'cat' => "offer" ],
		'offer_calculationName' 			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'calculationName']],
		'offer_startDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_endDate'						=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_duration'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT NOT NULL DEFAULT '0'",					'cat' => "offer" ],
		'offer_currencyTypeCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_currencyDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_expirationDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_cancellationPolicy'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "offer" ],
		'offer_optionDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_extSysResId'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_extSysResDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "offer" ],
		'offer_confirmationNumber'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_flightType'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_serviceClassCodeFirst'		=> [ 'type' => 'string',	'dbDef' => "CHAR(1) NOT NULL DEFAULT ''",					'cat' => "offer" ],
		'offer_serviceClassNameFirst'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_serviceClassCodes'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_serviceClassNames'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_fareBasis'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_flightNumbers'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(60) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_flightNumbersExt'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(80) NOT NULL DEFAULT ''",				'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_flightNumbersExt'] ],
		'offer_flightDurations'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(60) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_totalDuration'				=> [ 'type' => 'string', 	'dbDef' => "TIME NULL DEFAULT NULL",						'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_totalDuration'] ],
		'offer_flightDistances'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offer" ],
		'offer_flightDistanceTotal'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0",			'cat' => "offer" ],
		'offer_itinerary_startDatetime'		=> [ 'type' => 'string',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_startDatetime'] ],
		'offer_itinerary_endDatetime'		=> [ 'type' => 'string',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_endDatetime'] ],
		'offer_itinerary_passedAirpCodes'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",				'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_passedAirportsCodes'] ],
		'offer_itinerary_passedAirpNames'	=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_passedAirportsNamesStd'] ],
		'offer_itinerary_noOfStopOvers'		=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0",			'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_noOfStopOvers'] ],
		'offer_itinerary_noOfStopOvers24H'	=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0",			'cat' => "offer", 'formula'=>['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'itinerary_noOfStopOvers24H'] ],

		'offer_comments'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "offer" ],
		'offer_addTime'						=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL" ,					'cat' => "offer" ],
		'offer_addUserId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "offer" ],
		'offer_addUserName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "offer" ],

		'offer_departureCountryCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryContinentCode'=> [ 'type' => 'string',	'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryContinentName'=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryRegionCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryRegionName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCountryTCArea'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "offerLocation" ],
		'offer_departureCityCode3'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureCityName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureStationCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_departureStationName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryContinentCode'	=> [ 'type' => 'string', 'dbDef' => "VARCHAR(15) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryContinentName'	=> [ 'type' => 'string', 'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryRegionCode'=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryRegionName'=> [ 'type' => 'string',	'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCountryTCArea'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCityId'			=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "offerLocation" ],
		'offer_destinationCityCode3'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationCityName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationStationCode'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_destinationStationName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "offerLocation" ],
		'offer_itinerary'					=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "offerLocation",	'disabled' => true ], // to be used for other info related to itinerary (stores the array to be imported in the itinerary object)
		'offer_itineraryReadable'			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "offerLocation" ],

		'offer_ignoreSupplierOnDocs'		=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NULL DEFAULT NULL",			'cat' => "offerPrices" ],
		'offer_commissionable'				=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NULL DEFAULT NULL",			'cat' => "offerPrices" ],
		'offer_supplierPriceValue'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_supplierPriceVat'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_supplierPriceTotal'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_commissionValue'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_commissionVat'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_commissionTotal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_discountValue'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_discountVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_discountTotal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_serviceFeeValue'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_serviceFeeVat'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_serviceFeeTotal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_profileServiceFeeValue' 		=> [ 'type' => 'price',   	'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",     		'cat' => "offerPrices", 'formula' => ['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'defaultProfile_serviceFeeValue']],
		'offer_profileServiceFeeCurrency' 	=> [ 'type' => 'string',  	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''", 				'cat' => "offerPrices", 'formula' => ['type'=>'entity', 'entity'=>'Offer', 'id'=>'offer_id', 'attribute'=>'defaultProfile_serviceFeeCurrency']],
		'offer_taxValue'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_taxVat'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_taxTotal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_estProfit'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_netCompany'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_total'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(20,6) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => "offer_currency" ],
		'offer_currency'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "offerPrices" ],
		'offer_currencyRate'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "offerPrices" ],
		'offer_currencyRateForTktDate'		=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "offerPrices" ],
		'offer_workCurrencyRate'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "offerPrices" ],
		'offer_estProfitDefCurr'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],
		'offer_netCompanyDefCurr'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],
		'offer_totalDefCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],
		'offer_estProfitWorkCurr'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],
		'offer_netCompanyWorkCurr'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],
		'offer_totalWorkCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "offerPrices", 'subtotals' => true ],

		'offer_formOfPayment'               => [ 'type' => 'string',  'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcMaskedNo'           => [ 'type' => 'string',  'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcExpireDate'         => [ 'type' => 'date',    'dbDef' => "DATE NULL DEFAULT NULL",                  'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcCompany'            => [ 'type' => 'string',  'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcApprovalCode'       => [ 'type' => 'string',  'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcValue'              => [ 'type' => 'price',   'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",      'cat' => "offerPaymentCashingDetails"],
		'offer_paymentCcCurrency'           => [ 'type' => 'string',  'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",          'cat' => "offerPaymentCashingDetails"],
		'offer_formOfCashing'               => [ 'type' => 'string',  'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_cashingCcMaskedNo'           => [ 'type' => 'string',  'dbDef' => "VARCHAR(30) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_cashingCcExpireDate'         => [ 'type' => 'date',    'dbDef' => "DATE NULL DEFAULT NULL",                  'cat' => "offerPaymentCashingDetails"],
		'offer_cashingCcCompany'            => [ 'type' => 'string',  'dbDef' => "VARCHAR(10) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],
		'offer_cashingCcApprovalCode'       => [ 'type' => 'string',  'dbDef' => "VARCHAR(20) NOT NULL DEFAULT ''",         'cat' => "offerPaymentCashingDetails"],

		'inv_id'							=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_invoiceNumber'					=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_seriesId'						=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_seriesCode'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_formOfPaymentCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_invoiceDate'					=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "invoice" ],
		'inv_invoiceDateYM' 				=> [ 'type' => 'yearMonth', 'dbDef' => "DATE NULL DEFAULT NULL",        			 	'cat' => "invoice" ],
		'inv_invoiceDateY' 					=> [ 'type' => 'year',      'dbDef' => "YEAR NULL DEFAULT NULL",        			 	'cat' => "invoice" ],
		'inv_dueDate'						=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "invoice" ],
		'inv_fulfillmentDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "invoice" ],
		'inv_idAutoProcessRule'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_issued'						=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_temporary'						=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_cumulative'					=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_roundedTotal'					=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invoice" ],
		'inv_bankAccountId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_bankAccountNumber'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_remarks'						=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "invoice" ],
		'inv_processedRemarks'				=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "invoice", 'disabled' => true, 'content'=>'remarks' ],
		'inv_genDocsAssoc' 					=> [ 'type' => 'string',    'dbDef' => "VARCHAR(200) NOT NULL DEFAULT ''",              'cat' => "invoice", 'disabled' => true, 'content'=>'assocArray'],
		'inv_userId'						=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_userName'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_officeId'						=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_officeName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_issueTime'						=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "invoice" ],
		'inv_issueUserId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_issueUserName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "invoice" ],
		'inv_addTime'						=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "invoice" ],
		'inv_addUserId'						=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invoice" ],
		'inv_addUserName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "invoice" ],

		'inv_clientId'						=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invClientUnifDetails"],
		'inv_clientName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(201) NOT NULL DEFAULT ''",				'cat' => "invClientUnifDetails"],
		'inv_clientTypeCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "invClientUnifDetails"],
		'inv_clientCountryCode'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "invClientUnifDetails"],
		'inv_clientCountryName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "invClientUnifDetails"],
		'inv_clientCityId'					=> [ 'type' => 'string',	'dbDef' => "MEDIUMINT NOT NULL DEFAULT '0'",				'cat' => "invClientUnifDetails"],
		'inv_clientCityName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invClientUnifDetails"],

		'inv_corporateId'					=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invLegalEntityDetails"],
		'inv_corporateAlias'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateCompanyName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(170) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateTrustId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invLegalEntityDetails"],
		'inv_corporateTrustName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSegmentId'			=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invLegalEntityDetails"],
		'inv_corporateSegmentName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateKamId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invLegalEntityDetails"],
		'inv_corporateKamName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateProcessedRemarks'		=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL",									'cat' => "invLegalEntityDetails", 'disabled' => true, 'content' => 'remarks'],
		'inv_corporateGroupsList' 			=> [ 'type' => 'string',	'dbDef' => "TEXT NOT NULL", 							 	'cat' => "invLegalEntityDetails", 'formula' => ['type' => 'entity', 'entity' => 'Corporate', 'id' => 'inv_corporateId', 'attribute' => 'groupElementsNames']],
		'inv_corporateDuplicated'			=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invLegalEntityDetails"],
		'inv_corporateOriginalId'			=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeId'			=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeName'		=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeCountryCode'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeCountryName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeCityId'		=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invLegalEntityDetails"],
		'inv_corporateSelOfficeCityName'	=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invLegalEntityDetails"],
		'inv_corporateDomainId'				=> [ 'type' => 'numeric',   'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",    	'cat' => "invLegalEntityDetails"],
		'inv_corporateDomainName'			=> [ 'type' => 'string',    'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",          	'cat' => "invLegalEntityDetails"],
		'inv_corporateDomainCategoryId'		=> [ 'type' => 'numeric',   'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",    	'cat' => "invLegalEntityDetails"],
		'inv_corporateDomainCategoryName'	=> [ 'type' => 'string',    'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",          	'cat' => "invLegalEntityDetails"],

		'inv_customerId'					=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invIndividualDetails"],
		'inv_customerName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invIndividualDetails"],
		'inv_customerSegmentId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invIndividualDetails"],
		'inv_customerSegmentName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invIndividualDetails"],
		'inv_customerCountryCode'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(2) NOT NULL DEFAULT ''",				'cat' => "invIndividualDetails"],
		'inv_customerCountryName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''",				'cat' => "invIndividualDetails"],
		'inv_customerCityId'				=> [ 'type' => 'numeric',	'dbDef' => "MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "invIndividualDetails"],
		'inv_customerCityName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "invIndividualDetails"],
		'inv_customerDuplicated'			=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "invIndividualDetails"],
		'inv_customerOriginalId'			=> [ 'type' => 'numeric',	'dbDef' => "INT UNSIGNED NOT NULL DEFAULT '0'",				'cat' => "invIndividualDetails"],

		'inv_currency'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(3) NOT NULL DEFAULT ''",				'cat' => "invoicePrices" ],
		'inv_currencyRate'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices" ],
		'inv_workCurrencyRate'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(15,8) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices" ],
		'inv_value'							=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_vat'							=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_total'							=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_totalDefCurr'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_totalWorkCurr'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_components'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(400) NOT NULL DEFAULT ''",				'cat' => "invoicePrices", 'disabled' => true ],
		'inv_advanceVal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_advanceVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_advanceTtl'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_servicePriceVal'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_servicePriceVat'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_servicePriceTtl'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_supplierPriceTtl'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_servicePriceVatPercent'		=> [ 'type' => 'percent', 	'dbDef' => "DECIMAL(5,4) NOT NULL DEFAULT '0'", 			'cat' => "invoicePrices"],
		'inv_commissionVal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_commissionVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_commissionTtl'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_discountVal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_discountVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_discountTtl'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_serviceFeeVal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_serviceFeeVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_serviceFeeTtl'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_taxVal'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_taxVat'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_taxTtl'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_penaltyVal'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_penaltyVat'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_penaltyTtl'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_estProfit'						=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_estProfitDefCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_estProfitWorkCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_netCompany'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => "inv_currency" ],
		'inv_netCompanyDefCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_netCompanyWorkCurr'			=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_calculatedProfit'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => 'inv_currency' ],
		'inv_calculatedProfitDefCurr'		=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],
		'inv_calculatedProfitWorkCurr'		=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "invoicePrices", 'subtotals' => true ],

		'cash_cashedValue'					=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "cashingDetails", 'subtotals' => "inv_currency" ],
		'cash_notCashedValue'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "cashingDetails", 'subtotals' => "inv_currency" ],
		'cash_lastCashingDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "cashingDetails" ],
		'cash_lastCashingDocId'				=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "cashingDetails" ],

		'balance_id' 						=> [ 'type' => 'numeric',	'dbDef' => "BIGINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "balance" ],
		'balance_balanced' 					=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "balance" ],
		'balance_number'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_code'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_name'						=> [ 'type' => 'string',	'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_date'						=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "balance" ],
		'balance_virtualDate'				=> [ 'type' => 'date',		'dbDef' => "DATE NULL DEFAULT NULL",						'cat' => "balance" ],
		'balance_profitDefCurr'				=> [ 'type' => 'price',		'dbDef' => "DECIMAL(16,3) NOT NULL DEFAULT '0'",			'cat' => "balance", 'subtotals' => true ],
		'balance_profitPercent'				=> [ 'type' => 'percent',	'dbDef' => "DECIMAL(8,6) NOT NULL DEFAULT '0'",				'cat' => "balance" ],
		'balance_profitVatPercentCfg'		=> [ 'type' => 'percent',	'dbDef' => "DECIMAL(5,2) NOT NULL DEFAULT '0'",				'cat' => "balance"],
		'balance_userId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "balance" ],
		'balance_userName'					=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_officeId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "balance" ],
		'balance_officeName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_confirmUserId'				=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "balance" ],
		'balance_confirmUserName'			=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_confirmTime'				=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "balance" ],
		'balance_confirmed'					=> [ 'type' => 'boolean',	'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT '0'",			'cat' => "balance" ],
		'balance_addUserId'					=> [ 'type' => 'numeric',	'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT '0'",		'cat' => "balance" ],
		'balance_addUserName'				=> [ 'type' => 'string',	'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''",				'cat' => "balance" ],
		'balance_addTime'					=> [ 'type' => 'datetime',	'dbDef' => "DATETIME NULL DEFAULT NULL",					'cat' => "balance" ],

	];

	/**
	 * The primary key column.
	 * @var string
	 */
	protected string $primaryKeyColumn = 'tkt_key';

	/**
	 * The columns that are forced into the report.
	 * @var array
	 */
	protected array $forcedColumns = [
		'tkt_date', 'tkt_operation', // main filters
		'impServ_processStatusCode', 'impServ_systemStatusCode', // extra filters
	];

	/**
	 * The columns dependencies list.
	 * @var array
	 */
	protected array $columnsDependencies = [

		// imported service details
		'impServ_systemCode'				=> ['impServ_systemId'],
		'impServ_systemName'				=> ['impServ_systemId'],
		'impServ_serviceName'				=> ['impServ_serviceCode'],
		'impServ_processStatusName'			=> ['impServ_processStatusCode'],
		'impServ_systemStatusName'			=> ['impServ_systemStatusCode'],
		'impServ_reissuedTktNumber'			=> ['impServ_idImpServReissued'],
		'impServ_reissuedTktDate'			=> ['impServ_idImpServReissued'],

		'impServ_deptCountryCode'			=> ['impServ_locationsDetails'],
		'impServ_deptCountryName'			=> ['impServ_locationsDetails'],
		'impServ_deptCountryContinentCode' 	=> ['impServ_locationsDetails'],
		'impServ_deptCountryRegionCode' 	=> ['impServ_locationsDetails'],
		'impServ_deptCountryRegionName' 	=> ['impServ_locationsDetails'],
		'impServ_deptCountryTCArea' 		=> ['impServ_locationsDetails'],
		'impServ_deptCountryContinentName'	=> ['impServ_locationsDetails'],
		'impServ_deptCityId'				=> ['impServ_locationsDetails'],
		'impServ_deptCityCode3'				=> ['impServ_locationsDetails'],
		'impServ_deptCityName'				=> ['impServ_locationsDetails'],
		'impServ_deptStationCode'			=> ['impServ_locationsDetails'],
		'impServ_deptStationName'			=> ['impServ_locationsDetails'],

		'impServ_destCountryName'			=> ['impServ_destCountryCode'],
		'impServ_destCountryContinentCode' 	=> ['impServ_destCountryCode'],
		'impServ_destCountryRegionCode' 	=> ['impServ_destCountryCode'],
		'impServ_destCountryRegionName' 	=> ['impServ_destCountryCode'],
		'impServ_destCountryTCArea' 		=> ['impServ_destCountryCode'],
		'impServ_destCountryContinentName'	=> ['impServ_destCountryContinentCode'],

		'impServ_destCityCode3'				=> ['impServ_destCityId'],
		'impServ_destCityName'				=> ['impServ_destCityId'],
		'impServ_destStationCode'			=> ['impServ_locationsDetails'],
		'impServ_destStationName'			=> ['impServ_locationsDetails'],

		'impServ_supplierAlias'				=> ['impServ_supplierId'],
		'impServ_supplierIataCode'			=> ['impServ_supplierId'],
		'impServ_supplierTktCode'			=> ['impServ_supplierId'],

		'impServ_itinerary_segmentsCount'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_flightNumbers'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_firstClassCode'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_firstClassName'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_classCodes'		=> [ 'impServ_itinerary' ],
		'impServ_itinerary_fareBasis'		=> [ 'impServ_itinerary' ],
		'impServ_itinerary_flightDurations'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_totalDuration'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_flightDistances'	=> [ 'impServ_itinerary' ],
		'impServ_itinerary_flightDistanceTotal'	=> [ 'impServ_itinerary' ],

		'impServ_blockUserName'				=> ['impServ_blockUserId'],
		'impServ_officeName'				=> ['impServ_officeId'],
		'impServ_userName'					=> ['impServ_userId'],
		'impServ_bookOfficeName'			=> ['impServ_bookOfficeId'],
		'impServ_bookUserName'				=> ['impServ_bookUserId'],
		'impServ_issueOfficeName'			=> ['impServ_issueOfficeId'],
		'impServ_issueUserName'				=> ['impServ_issueUserId'],
		'impServ_bookOfficeIataNumber'		=> ['impServ_usersDetails'],
		'impServ_issueOfficeIataNumber'		=> ['impServ_usersDetails'],
		'impServ_refundOfficeSystem'		=> ['impServ_usersDetails'],
		'impServ_refundOfficeId'			=> ['impServ_usersDetails'],
		'impServ_refundOfficeName'			=> ['impServ_usersDetails'],
		'impServ_refundOfficeIataNumber'	=> ['impServ_usersDetails'],
		'impServ_refundUserSystem'			=> ['impServ_usersDetails'],
		'impServ_refundUserId'				=> ['impServ_usersDetails'],
		'impServ_refundUserName'			=> ['impServ_usersDetails'],

		'impServ_co2EmissionsPerSegments'	=> ['impServ_id'],
		'impServ_co2EmissionsTotal'			=> ['impServ_id'],
		'impServ_ticketDesignator'			=> ['impServ_id'],

		// imported service prices
		'impServ_ignoreSupplierOnDocs'		=> ['impServ_priceComponents'],
		'impServ_commissionable'			=> ['impServ_priceComponents'],
		'impServ_total'						=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_currencyRate'				=> ['impServ_ticketDate', 'impServ_currency'],
		'impServ_workCurrencyRate'			=> ['impServ_ticketDate', 'impServ_currency'],
		'impServ_invCurrencyRate'			=> ['inv_currency', 'impServ_currency', 'inv_invoiceDate'],

		'impServ_supplierPriceTotal'		=> ['impServ_servicePriceTotal', 'impServ_commissionTotal'],
		'impServ_servicePriceTotal'			=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_servicePriceVat'			=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_commissionTotal'			=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_commissionPercent'			=> ['impServ_servicePriceTotal', 'impServ_commissionTotal'],
		'impServ_discountTotal'				=> ['impServ_priceComponents', 'impServ_currency'],
		'impServ_serviceFeeTotal'			=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_taxTotal'					=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_taxVat'					=> ['impServ_priceComponents', 'impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_penaltyTotal'				=> ['impServ_refundDetails', 'impServ_currency', 'tkt_operation'],
		'impServ_taxesFullList'				=> ['impServ_taxDetails'],
		'impServ_netCompany'				=> ['impServ_supplierPriceTotal', 'impServ_taxTotal'],
		'impServ_estimatedRevenue'			=> ['impServ_commissionTotal', 'impServ_serviceFeeTotal', 'impServ_discountTotal'],

		// imported order general details
		'impOrder_id'						=> ['impServ_id'],
		'impOrder_idOrderExtSys'			=> ['impServ_id'],
		'impOrder_date'						=> ['impServ_id'],
		'impOrder_originalCorporateName'	=> ['impServ_id'],
		'impOrder_matchedCorporateId'		=> ['impServ_id'],
		'impOrder_matchedCorporateAlias'	=> ['impOrder_matchedCorporateId'],
		'impOrder_miceProjectId'			=> ['impServ_id'],
		'impOrder_miceProjectName'			=> ['impOrder_miceProjectId'],
		'impOrder_userId'					=> ['impServ_id'],
		'impOrder_userName'					=> ['impOrder_userId'],
		'impOrder_officeId'					=> ['impServ_id'],
		'impOrder_officeName'				=> ['impOrder_officeId'],
		'impOrder_addTime'					=> ['impServ_id'],

		// order general details
		'order_typeName'					=> ['order_typeCode'],
		'order_flagName'					=> ['order_flagCode'],
		'order_servicesTypeName'			=> ['order_servicesTypeCode'],
		'order_ownerCustName'				=> ['order_ownerCustId'],
		'order_ownerCustProcessedRemarks'	=> ['order_ownerCustId'],
		'order_ownerCorpAlias'				=> ['order_ownerCorpId'],
		'order_ownerCorpSegmentId'			=> ['order_ownerCorpId'],
		'order_ownerCorpSegmentName'		=> ['order_ownerCorpSegmentId'],
		'order_ownerCorpProcessedRemarks'	=> ['order_ownerCorpId'],
		'order_ownerCorpGroupsList'			=> ['order_ownerCorpId'],
		'order_ownerCorpOfficeName'			=> ['order_ownerCorpOfficeId'],
		'order_contactPersonName'			=> ['order_contactPersonId'],
		'order_miceProjectName'				=> ['order_miceProjectId'],

		// order responsible
		'order_userName'					=> ['order_userId'],
		'order_officeName'					=> ['order_officeId'],
		'order_departmentName'				=> ['order_departmentId'],
		'order_addUserName'					=> ['order_addUserId'],

		// service general details
		'service_firstPsgTypeName'			=> ['service_firstPsgTypeCode'],
		'service_firstPsgSegmentName'		=> ['service_firstPsgSegmentId'],
		'service_firstPsgProcessedRemarks'	=> ['service_firstPsgId'],
		'service_definedPsgListStd'			=> ['service_id'],
		'service_agencyCostCenterName'		=> ['service_agencyCostCenterCode'],
		'service_extSystemsList'			=> ['service_id'],

		// service responsible
		'service_userName'					=> ['service_userId'],
		'service_officeName'				=> ['service_officeId'],
		'service_addUserName'				=> ['service_addUserId'],
		'service_updateUserName'			=> ['service_updateUserId'],

		'service_departureCountryName'			=>	['service_departureCountryCode'],
		'service_departureCountryContinentCode' => 	['service_departureCountryCode'],
		'service_departureCountryRegionCode'	=> 	['service_departureCountryCode'],
		'service_departureCountryRegionName' 	=> 	['service_departureCountryCode'],
		'service_departureCountryTCArea' 		=> 	['service_departureCountryCode'],
		'service_departureCountryContinentName'	=> 	['service_departureCountryContinentCode'],

		'service_destinationCountryName'			=>	['service_destinationCountryCode'],
		'service_destinationCountryContinentCode' 	=> 	['service_destinationCountryCode'],
		'service_destinationCountryRegionCode' 		=> 	['service_destinationCountryCode'],
		'service_destinationCountryRegionName' 		=> 	['service_destinationCountryCode'],
		'service_destinationCountryTCArea' 			=> 	['service_destinationCountryCode'],
		'service_destinationCountryContinentName'	=> 	['service_destinationCountryContinentCode'],
		'service_internationalIndicator'			=>	['impServ_id'],

		// offer general details
		'offer_calculationName'				=> ['offer_id'],
		'offer_supplierAlias'				=> ['offer_supplierId'],
		'offer_supplierIataCode'			=> ['offer_supplierId'],
		'offer_supplierTktCode'				=> ['offer_supplierId'],
		'offer_serviceName' 				=> ['offer_serviceCode'],
		'offer_locationName'				=> ['offer_locationCode'],
		'offer_addUserName'					=> ['offer_addUserId'],
		'offer_flightNumbersExt'			=> ['offer_id'],
		'offer_totalDuration'				=> ['offer_id'],
		'offer_itinerary_startDatetime'		=> ['offer_id'],
		'offer_itinerary_endDatetime'		=> ['offer_id'],
		'offer_itinerary_passedAirpCodes'	=> ['offer_id'],
		'offer_itinerary_passedAirpNames'	=> ['offer_id'],
		'offer_itinerary_noOfStopOvers'		=> ['offer_id'],
		'offer_itinerary_noOfStopOvers24H'	=> ['offer_id'],
		'offer_profileServiceFeeValue'		=> ['offer_id'],
		'offer_profileServiceFeeCurrency'	=> ['offer_id'],

		// offer locations
		'offer_departureCountryName'		=> ['offer_departureCountryCode'],
		'offer_departureCityCode3'			=> ['offer_departureCityId'],
		'offer_departureCityName'			=> ['offer_departureCityId'],
		'offer_departureStationName'		=> ['offer_departureStationCode'],

		'offer_departureCountryContinentCode' =>['offer_departureCountryCode'],
		'offer_departureCountryRegionCode' => 	['offer_departureCountryCode'],
		'offer_departureCountryRegionName' => 	['offer_departureCountryCode'],
		'offer_departureCountryTCArea' => 		['offer_departureCountryCode'],
		'offer_departureCountryContinentName' =>['offer_departureCountryContinentCode'],


		'offer_destinationCountryName'		=> ['offer_destinationCountryCode'],
		'offer_destinationCityCode3'		=> ['offer_destinationCityId'],
		'offer_destinationCityName'			=> ['offer_destinationCityId'],
		'offer_destinationStationName'		=> ['offer_destinationStationCode'],

		'offer_destinationCountryContinentCode' => 	['offer_destinationCountryCode'],
		'offer_destinationCountryRegionCode' => 	['offer_destinationCountryCode'],
		'offer_destinationCountryRegionName' => 	['offer_destinationCountryCode'],
		'offer_destinationCountryTCArea' => 		['offer_destinationCountryCode'],
		'offer_destinationCountryContinentName' => 	['offer_destinationCountryContinentCode'],


		'offer_currencyRateForTktDate'		=> ['offer_currency', 'service_ticketsDate'],

		// invoice general details
		'inv_seriesCode'					=> ['inv_seriesId'],
		'inv_bankAccountNumber'				=> ['inv_bankAccountId'],
		'inv_userName'						=> ['inv_userId'],
		'inv_officeName'					=> ['inv_officeId'],
		'inv_issueUserName'					=> ['inv_issueUserId'],
		'inv_addUserName'					=> ['inv_addUserId'],

		// invoice client details
		'inv_clientId'						=> ['inv_corporateId', 'inv_customerId'],
		'inv_clientName'					=> ['inv_corporateAlias', 'inv_customerName'],
		'inv_clientTypeCode'				=> ['inv_corporateId', 'inv_customerId'],
		'inv_clientCountryCode'				=> ['inv_corporateId', 'inv_corporateSelOfficeCountryCode', 'inv_customerId'],
		'inv_clientCityId'					=> ['inv_corporateId', 'inv_corporateSelOfficeCityId', 'inv_customerId'],
		'inv_clientCountryName'				=> ['inv_clientCountryCode'],
		'inv_clientCityName'				=> ['inv_clientCityId'],

		'inv_corporateId'					=> ['inv_id'],
		'inv_corporateAlias'				=> ['inv_corporateId'],
		'inv_corporateCompanyName'			=> ['inv_corporateId'],
		'inv_corporateDuplicated'			=> ['inv_corporateId'],
		'inv_corporateSelOfficeId'			=> ['inv_id'],
		'inv_corporateKamId'				=> ['inv_corporateId'],
		'inv_corporateKamName'				=> ['inv_corporateKamId'],
		'inv_corporateTrustId'				=> ['inv_corporateId'],
		'inv_corporateTrustName'			=> ['inv_corporateTrustId'],
		'inv_corporateSegmentId'			=> ['inv_corporateId'],
		'inv_corporateSegmentName'			=> ['inv_corporateSegmentId'],
		'inv_corporateGroupsList'			=> ['inv_id'],
		'inv_corporateSelOfficeName'		=> ['inv_corporateSelOfficeId'],
		'inv_corporateSelOfficeCountryCode' => ['inv_corporateSelOfficeId'],
		'inv_corporateSelOfficeCountryName'	=> ['inv_corporateSelOfficeCountryCode'],
		'inv_corporateSelOfficeCityId'		=> ['inv_corporateSelOfficeId'],
		'inv_corporateSelOfficeCityName'	=> ['inv_corporateSelOfficeCityId'],
		'inv_corporateDomainId'				=> ['inv_corporateId'],
		'inv_corporateDomainCategoryId'		=> ['inv_corporateId'],
		'inv_corporateDomainName'			=> ['inv_corporateDomainId'],
		'inv_corporateDomainCategoryName'	=> ['inv_corporateDomainCategoryId'],

		'inv_customerId'					=> ['inv_id'],
		'inv_customerName'					=> ['inv_customerId'],
		'inv_customerSegmentId'				=> ['inv_customerId'],
		'inv_customerSegmentName'			=> ['inv_customerSegmentId'],
		'inv_customerCountryCode'			=> ['inv_customerId'],
		'inv_customerCountryName'			=> ['inv_customerCountryCode'],
		'inv_customerCityId'				=> ['inv_customerId'],
		'inv_customerCityName'				=> ['inv_customerCityId'],
		'inv_customerDuplicated'			=> ['inv_customerId'],


		// invoice prices
		'inv_value'							=> ['inv_components'],
		'inv_vat'							=> ['inv_components'],
		'inv_advanceVal'					=> ['inv_components'],
		'inv_advanceVat'					=> ['inv_components'],
		'inv_advanceTtl'					=> ['inv_components'],
		'inv_servicePriceVal'				=> ['inv_components'],
		'inv_servicePriceVat'				=> ['inv_components'],
		'inv_servicePriceTtl'				=> ['inv_components'],
		'inv_supplierPriceTtl'				=> ['inv_components'],
		'inv_servicePriceVatPercent'		=> ['offer_serviceCode', 'offer_locationCode', 'offer_calculationCode'],
		'inv_commissionVal'					=> ['inv_components'],
		'inv_commissionVat'					=> ['inv_components'],
		'inv_commissionTtl'					=> ['inv_components'],
		'inv_discountVal'					=> ['inv_components'],
		'inv_discountVat'					=> ['inv_components'],
		'inv_discountTtl'					=> ['inv_components'],
		'inv_serviceFeeVle'					=> ['inv_components'],
		'inv_serviceFeeVat'					=> ['inv_components'],
		'inv_serviceFeeTtl'					=> ['inv_components'],
		'inv_taxVal'						=> ['inv_components'],
		'inv_taxVat'						=> ['inv_components'],
		'inv_taxTtl'						=> ['inv_components'],
		'inv_penaltyVal'					=> ['inv_components'],
		'inv_penaltyVat'					=> ['inv_components'],
		'inv_penaltyTtl'					=> ['inv_components'],
		'inv_estProfit'						=> ['inv_components'],
		'inv_estProfitDefCurr'				=> ['inv_components', 'inv_currencyRate'],
		'inv_estProfitWorkCurr'				=> ['inv_components', 'inv_currencyRate', 'inv_workCurrencyRate'],
		'inv_netCompany'					=> ['inv_components'],
		'inv_netCompanyDefCurr'				=> ['inv_components', 'inv_currencyRate'],
		'inv_netCompanyWorkCurr'			=> ['inv_components', 'inv_currencyRate', 'inv_workCurrencyRate'],
		'inv_calculatedProfit'				=> [
			'tkt_operation', 'impServ_id', 'impServ_ticketDate', 'impServ_commissionTotal', 'impServ_netCompany', 'impServ_currency',
			'offer_ignoreSupplierOnDocs', 'offer_currencyDate', 'offer_commissionTotal', 'offer_netCompany', 'offer_currency',
			'inv_id', 'inv_total', 'inv_currency', 'inv_estProfit',
		],
		'inv_calculatedProfitDefCurr'		=> ['inv_calculatedProfit', 'inv_currencyRate'],
		'inv_calculatedProfitWorkCurr'		=> ['inv_calculatedProfit', 'inv_currencyRate', 'inv_workCurrencyRate'],

		// cashings
		'cash_lastCashingDocId'				=> ['inv_id'],

		// balance details
		'balance_profitVatPercentCfg'		=> ['offer_serviceCode', 'offer_locationCode', 'offer_calculationCode'],
		'balance_userName'					=> ['balance_userId'],
		'balance_officeName'				=> ['balance_officeId'],
		'balance_confirmUserName'			=> ['balance_confirmUserId'],
		'balance_addUserName'				=> ['balance_addUserId'],

	];

}
