TAPEИГ‹ p\ ^hz,ŠeLЌкASIFD5.3.0.019FUhЂT–IЏЌL6ˆёьMicrosoft SQL ServerSPAD2 SFMB8SSETЌdЧ z„–ІeLЌкшнBїбxХIœv\н?Ш‹ASIFD5.3.0.019FUhЂT–IЏЌL6ˆёьsaSPAD>,VOLBpf IOOeLЌкC:\CAMELEON-FRONTDSPADzhMSCI8:MQCIHFSCIN2]wў јф‚ф„ф‚ЃudѕMЬeLЌкDфPd№&  š‡Ѕže]IЉЧбФжєZф„ƒлd|‰A…tЅˆд&W~­^‘­В$ CЙDd>Pєл§ аƒлd|‰A…tЅˆд&W~asiHotel_ASIFDCAMELEON-FRONTD\ASISFGI"PRIMARYSFINr iКœжрџџџ ф‚ рџџџiЃu­^‘­В$ CЙDd>Pєл§asiHotel_ASIFDC:\Archivos de programa\Microsoft SQL Server\MSSQL$ASI\Data\asiHotel_ASIFD.mdfSFIN‚ р$КЄорџџџ ррџџџрasiHotel_ASIFD_logC:\Archivos de programa\Microsoft SQL Server\MSSQL$ASI\Data\asiHotel_ASIFD_log.LDFSPADR@MSDA<<APAD€–MQDAdmcу` 0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ “`џџџџ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “А `џџџџ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “А `џџџџ“А BЙщЛ(мmHЈ ЅЦ&е–R0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “А “Й`џџџџ“А BЙщЛ(мmHЈ ЅЦ&е–R0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й`џџџџ“А BЙщЛ(мmHЈ ЅЦ&е–R0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й“П`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й•€`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й™.`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ “Й›p`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p`џџџџ“ЙЩkbТ^AC•KјBЊPŽѓ0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p`џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p›`џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p›к `џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p *`џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ›p Y`џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ Ѓu`џџџџ›pљ‹&MIи•pп ь~0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ Ѓu`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ЃuЃ}`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ЃuДИ`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ЃuЧ`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ЃuШŽ`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ ЃuP`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZјџџџџ Ѓu!`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓu!`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓu[`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓu•Mo`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ ЃuЃЇ`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ ЃuНА`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ ЃuЯ`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓuс@C`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓuф#`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ Ѓuф}`џџџџЃu­^‘­В$ CЙDd>Pєл§0KKMOSW[_isssw{ƒ—ЁЋЛš‡Ѕže]IЉЧбФжєZHџџџџ ф‚`џџџџЃu­^‘­В$ CЙDd>Pєл§š‡Ѕže]IЉЧбФжєZјџџџџ †Г`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ †З`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ †К`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ †Н`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ †Р`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ ‰*`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ ‰c`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ Š`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ *`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ ‘`џџџџ0KKMOSW[__iiimquyyyyƒš‡Ѕže]IЉЧбФжєZјџџџџ ’*`џџџџ(TвBWвB44˜MвB`_вB`UвB==lX[вB] cќфqœDDDDDDddtdttd`@@@@@@@@d`pp````a``````p````p``p````p``p``p`````DCBCDDCCp```p`pd`p`p``p`p`p`````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@```d````@@@@@@@@@@@@@@@@d```p``p`p``````````````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@``````p`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@`p``p``p``p``p``p``p``p``p``p``p`ap`p``p``p``p``p``p``p``p`ap`p```p```p`dc`p``p``p``p``p``p`ap`p``p`p``p`papddd`p``p``p``p`p``p``p`ap`````````p`cp`pdp`p`p`p`dp`p`p`a`a`p``p`pd`@@@@@@@@``pad`bpDBCBBCCC@@@@@@@@`pa`p``p`aa`aa`p``aap``p``p`a`p`CBDCCBDB`p``p`aaaa`aaaa``paaa````a````p`````````AABBCBBBBB`p```a `@@@@@@@a BA`ZcібН§џџ?^8№џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџО` Zcіфq^8€О`Zcіф‚^8О`Zcі^8О`*EВФ]*0*S р`ЏЊ№х’јџHsysobjects0*S р ЏЊ№х’јџHsysindexes0*S  рPЏЊ№х’јџHsyscolumns0*S рPЏЊ№х’јџDsystypes0*S  р0ЏЊ№х’јџJsyscommentsc0*S рЏЊ№х’јџFsysfiles1t0* S  рЏЊ№х’јџPsyspermissions0* S р`ЏЊ№х’јџDsysusers0* S р ЏЊ№х’јџNsyspropertiess0* S  р@ЏЊ№х’јџHsysdepends0*S )рPЏЊ№х’јџNsysreferencese0*S р0ЏЊ№х’јџZsysfulltextcatalogs)0*S  рЏЊ№х’јџLsysindexkeys0*S  рЏЊ№х’јџPsysforeignkeys0*S  рЏЊ№х’јџHsysmembers0*S  рЏЊ№х’јџJsysprotectsn0*S рЏЊ№х’јџVsysfulltextnotify0*_S  рЏЊ№х’јџDsysfiles0*`S р0ЏЊ№х’јџNsysfilegroupst0*’UU !`ТXи› NcfSupplier_mst*0*Ы5IU !`ТXи› FcfUnit_mstp0*Z=U !` ТXи› Ncfacc_category0*=~1U !` ТXи› Lcfacc_payable0*vЂ%U !` ТXи› Rcfcashdrawer_mstГx0*ЏЦU !` ТXи› \cfcategory_receivable0*шъ U !` ТXи› Rcfcategory_table0*!U ! ` ТXи› Lcfcharges_mst0*Z3іU !`ТXи› Pcfdeposites_mst0*“WъU !`ТXи› Fcfdept_mstx}0*h U !`=ФXи› Pfdreminder_info0*Ё+U !`=ФXи› Pfdreminder_tran0*кOU V! `0GФXи› Vfdreservation_info`0*tќU !%`0PФXи› Tfdrespayment_tran0*L˜№U !`PФXи› Rfdresrental_infoX0*…МфU U! ` YФXи› Nfdroom_booking 0*ОриU !` ^ФXи› Nfdshift_detailc0*їЭU  !`^ФXи› VfdtempIDTypeDetailo0*0)СU !`^ФXи› \fdtempIngerence_Stock0*iMЕU !!` cФXи› ffdtempNonRentalPaymentTran0*w!пPKж7Г_]ЦXи› RPK_fdchkinn_info0*АEгPK\Ї`]ЦXи› `PK_fdchkinnguest_detail0*щiЧPKH€›a]ЦXи› PPK_fdcity_point0*"ŽЛPKЄbbЦXи› lPK_fdday_status_NonRentalUnit0*[ВЏPKѓьwdbЦXи› ZPK_fdday_status_room0*”жЃPK,lebЦXи› XPK_fdday_status_tax0*Эњ—PKe5`fbЦXи› dPK_fdday_status_tax_child0*ŒPKžYTgfЦXи› LPK_fddnr_tran0*?C€PKз}HhfЦXи› XPK_fdguest_feedback0*xgt PKЂPєл§` Zј ŒW^ [\ŒŽЁ8Р` м ”Oytх[№ИJ\H€›aŒЂqЉ ЇЯ“4ŽчнœqЁ%'W)^?9ŸUЌˆа|Ф Иp”` Zј ^ 8Р` Zј  Ђ^)1]^‰8€Р` а ƒзu)˜Ед31Лl]БRD^ЂqЉ ‰ а|O˜$сС ™,lešMо… ›Ь{о œ в л• žП^ŸЄbxкOyL˜№z\Ї`{ж7Г_|wшК }ЪяГx~G:YА€ №P€@РарА  0Рp`p` ‰"№…и &+base_schema_verB&cache&category& crdateйB&deltrig& ftcatid&id&indexdel&info&instrig&name& !parent_obj&refdate&replinfo& !schema_vera&seltrig& -stats_schema_verˆ&status&sysstat&typeЇЛB&uid&updtrig&userstatЌЛB&version&xtype& dpages&first&FirstIAM&groupidB&id&impid&indid&keycnt&keys&lockflagsB&maxirow&maxlen8НB&minlen&namefЛB&)OrigFillFactor&pgmodctr& reservedуЛB&reserved2B&reserved3&reserved4&root& rowcnt& rowmodctr&rows&statbmob ™&status&#StatVersion@& used&xmaxlen&autoval& bitpos&cdefault& colid&collation&#collationid&colorder№?& colstat&domain&id&!iscomputed&!isnullable&!isoutpaqam&language&length&name&number&offset™&prec&printfmt& reserved&scale&status& %tdscollation&type&typestat&usertype& xoffset&xprec&xscale&xuypeB&xusertype&!allownulls&collation& #collationidB& domain&length&name&prec&printfmt& reserved&scale&status&tdefault&type& uidB& usertype&variablen?&xprec&xscale&xtype&xusertypeџ&colid& !compressed&ctext&encrypted&id&language &number&statusџџџ& text&texttype&fileid&filename&name&status& actadd& actmod& grantee& grantor& id& refadd& refmod9НB& seladd& selmod& updaddfЛB& updmod& altuid"НB& !createdate& environ& gid& #hasdbaccess& isaliased& isapprole& islmgin& isntgroup& isntname& isntuser& issqlrole& issqluser& name& password& roles& sid& status­ЛB& uid& !updatedate& id& name& smallid& typeтЛB& value& depdbid& depid& depnumber& depsiteid& deptype& id& numberЏЛB& readobjB& resultobj& selall& status&constid& fkey1&fkey10&fkey11vМB&fkey12&fkey13&fkey14&fkey15&fkey15lЛB& fkey2& fkey3& fkey4&fkey5џ&fkey6&fkey7&fkey8&fkey9&fkeydbidтКB&fkeyid&forkeys&keycnt&refkeys&rkey1&#rkey10&$rkey11&%rkey12&&rkey13&'rkey14pЛB&)rkey15&)rkey16™&rkey2&rkey3&rkey4&rkey5&rkey6& rkey7&!rkey8&"rkey9& rkeydbid&rkeyid`ЛB&rkeyindid&ftcatid&nameцЛB&path&status&colid&id&indid&keyno&constid&fkey&fkeyid ™&keyno&rkey&rkeyid&groupuid&memberuid&action&columns&grantor&id&#protecttype&uid&ftkey&rowinfo&tableid&_fileid&_ filename&_groupid&_growth&_maxsize&_name&_perf&_size`ЛB&_status&`#allocpolicy&`groupid&`groupname&`status&­:яsname&­:яssegment&­:яsstatus&ц^уtactions&ц^уtcolid&ц^уtconstid&ц^уterrmr&ц^уtid&ц^уtspare1&ц^уtstatus&ƒзuHWInfoID&ƒзu!moduleName™&ƒзu)serverDateTime ™&ƒзu-terminalDateTime ™$ ™0`ЛB ™$ ™0`ЛB ™$ ™0`ЛB`ѓЛBЈхЛB88№™ ™Р”pP4ьаИœ€dL0єаДœ„lP4јмРЄŒxT@$ьЬЌx`D,јрЬД˜€hL,№иРЈx`H0јмРЄˆlT8фФЌ”|dL4шЬА”x\@( №дД˜|hL, єиРЈŒt`<( јрРЈˆhH(ьЬЌˆtX4ќрФЈŒp\@$ь а И ˜ | \ D ( ь и И   | d D ,  ј и И Є Œ l P 8  ј р Ш Ќ  l L (  № д М   € ` H  ьЬЌ”x\D(фРœˆlP0 ьдД˜|`H$шаА”|\<ќмА˜|`D$ №иРЌpX<$шЬИ „h8јиМ˜€dL,ќрФЄŒ`.-Iў p8( 0.чџџџџ(а?name0.88  ;id0.ЏЏ(аAxtype0.44   =uid0.44  ?info0.88  Cstatus0.88  Ubase_schema_ver0.88  Greplinfo0.88   Kparent_obj0.==  Ccrdate0.44 ( & Eftcatid0.88  ;id0.88  Cstatus0.­­   Afirst0.44 Aindid0.­­ ?root0.44 Cminlen0.44 Ckeycnt0.44 Egroupid0.88  Cdpages0.88 $ " Greserved0.88 ( & ?used0. , * Crowcnt0.88 4 2 Irowmodctr0.0086 Ireserved30.0097 Ireserved40.44:8 Exmaxlen0.44<: Emaxirow0.00>< SOrigFillFactor0.00?= MStatVersion0.88 @> Ireserved20.­­DB GFirstIAM0.44JH Aimpid0.44LJ Ilockflags0.88 NL Gpgmoectr0.ЅЅ@џџџџ ?keys0.чўџўџ(а?name0.""§џ§џ Gstatblob0.чџџџџ(а?name0.88  ;id0.00 Axtype0.00  Gtypestat0.44  Ixusertype0.44   Clength0.00  Axprec0.00  Cxscale0.44   Acolid0.44   Exoffset0.00   Cbitpos0.00   Greseqved0.44   Ecolstat0.88  Gcdefault0.88  Cdomain0.44  Cnumber0.44"  Gcolorder0.ЅЅ@ўџўџ Eautoval0.44$" Coffset0.88   Kschema_verd0.88   Wstats_schema_ver0.ЏЏ(а?type0.44 Guserstat0.44 Esysstat 0.44 Gindexdelџ0.== Erefdate0.88  Eversion0.88  Edeltrig0.88  Einstrig0.88  Eupdtrig0.88  Eseltrig0.88  Gcategory0.44 Acache0.88  Cmaxlen0.88  ?rows Greserved0.88  ўџ Mcollationid0. 44 =uid0. 44 Cstatus0. чџџџџа4?name0. ЅЅUўџўџ =sid0. ЅЅ§џ§џ Aroles0. == Kcreatedate0. == Kupdatedate0. 44 Caltuid0. ЅЅ ќџ ќџ Gpassword0.`44 Egroupid0.`44 Mallocpolicy0.`88  Cstatus0.`чџџџџа4Igroupname0.88  ;id0.44 Cnumber0.44  Acolid0.44   Cstatus0.ЅЅ@џџџџ Actext0. 88  ;id0. 44 Egrantee0. 44  Egrantor0. 44   Cactadd0. 44  Cactmod0. ЅЅ џџџџ Cseladd0. ЅЅ ўџўџ Cselmod0. ЅЅ §џ§џ Cupdadd0. ЅЅ  ќџ ќџ Cupdmod0. ЅЅ  ћџ ћџ Crefadd0. ЅЅ  њџ њџ Crefmod0. 88  ;id0. 44 Esmallid0. 00  ?type0. чџџџџа4?name0. bbPўџўџ Avalue0. 88  ;id0. 88  Adepid0. 44   Cnumber0. 44  Idepnumber0.88   Kschema_verXаŒDќРTаŒ|8єАh м˜PР | 4 № Ќ h $ и  L  а 0ьˆ H  Р t 0 шœLјАhа„@Иt,шЄd м˜\Ј`аˆ@јАh и˜@єа„<ф ` м `Dи ]- <J_ ƒзu !!Ь{о "цg$­:яs\П ]Ж!^KK* ўМ5'Г: в^=`}Œ:@ aгeѓEb№ИJc а|Od*…AT eœЭ)VfЙ‚юZgж7Г_pж7Г_4q\Ї`rКШƒcs‚ъ$ktf{ѕnu х~xv.gzwкOxкO:ytќz…Мф#{Mо… |†z }j“J~БRDFМzКz&‘nфУ'’Bм.“Ru”+”эHј0•ЈNM1*–7Lњ7—7Lњ76уўkCrќJrќJ2+Ыж\ЎђЬd чСeчСeA ;Еf` ;ЕfEaY_ЉgbY_ЉgHc"Чпwd"Чпw>eKR[{fЭ3Мzg?|Є| ?|Є|>Ё…МфTЂyц-ЃiMЕЄ`P0@@0 А№ №раРА №раРА €€pp``P@P@00  №раРрА аР€p€p`P €p`u.@ф œф‚ "0.­:яs88  Esegment`пB0.­:яsЇЇ (а?name0.­:яs88  CstatusB0.ц^уt88  Econstid0.ц^уt88  ;idB0.ц^уt44 Acolid™0.ц^уt00 Cspare10.ц^уt88  Cstatus0.ц^уt88  Eactions0.ц^уt88  AerroršмB0.ƒзu88 IVHWInfoID~‚мB0.ƒзuЇЇ2џџџџа4KmoduleName0.ƒзu==ўџ WterminalDateTineB0.ƒзu==§џ SserverDateTime0.ƒзuЇЇ2ўџќџа4OcomputerNameB0.ƒзuЇЇ2§џћџа4GHDDModel0.ƒзuЇЇ2ќџњџа4IHDDSeriald#0.ƒзuЇЇ2ћџљџа4MHDDFirmWare†зB0.ƒзuЇЇ2 њџ јџа4MMACAddress1…зB0.МTЎt88 Ublostfoundunkid0.МTЎt==џџ Ifounddate0.МTЎtЇЇdџџўџа4Gitemname0.МTЎtЇЇdўџ§џа4Iitemcolor0.МTЎtЇЇd§џќџа4Kwherefound0.МTЎtЇЇdќџћџа4GwhofoundB0.МTЎtЇЇdћџњџа4Iitemvalue0.МTЎtЇЇdњџљџа4Wcurrent_location0.МTЎt==  јџ Mreturn_dateqпB0.МTЎtЇЇd љџ їџа4Ireturn_by жB0.МTЎt==  іџ Odiscard_date0.МTЎtЇЇd јџ ѕџа4Kdiscard_by0.МTЎtЇЇd їџ єџа4Ienteredby‰зB0.МTЎtЇЇdіџѓџа4Iclaimedby0.МTЎtЇЇџѕџђџа4Eaddress0.МTЎtЇЇdєџёџа4?cityB0.МTЎtЇЇdѓџ№џа4Astate0.МTЎtЇЇdђџяџа4=zip0.МTЎtЇЇdёџюџа4Ecountry0.МTЎtЇЇd№џэџа4Itelephone0.МTЎt88  ьџ IroomunkidJ™0.МTЎtЏЏ$ыџа4Ustatuslostfound0.ѕxЂull  Iuserunkid0.ѕxЂuЏЏ џџа4;IP0.ѕxЂuЇЇ2џџўџа4MMachineName0.ѕxЂu$$  Eguidcol0.ѕxЂuЏЏ,§џа4Cstatus0.ѕxЂuЇЇdўџќџа4Iuser_name0.>6t88  ]@intCatReceiveunkidJ™0.>6t88  W@intpaytypeunkid0.>6t== U@dtpay_datetime жB0.>6t<< U@intamount_paid0.>6tЇЇd(аU@strAuthoNumber0.>6tЇЇd(аS@strCardNumber?0.>6tЇЇ(аQ@strValidTill‘зB0.>6tЇЇd(аK@strPaidBy0.>6t88   Q@intUserunkid0.>6t88   W@intPayReference0.>6tЇЇd  (аQ@strReceiptNo0.>6t88   [@intexcahngeRateid0.>6t<<   W@intexchangeRate0.>6t<< E@intTax0.wZu== C@mindtB0.wZu== C@maxdt0.wZu88  G@guestid№?x™0 жB`˜мB0JпB№?ь“зB8ˆзB@‰зB№‘зBxжBЬƒ™0РнBР[™0 жB88 јJ™0 жBhhРN™0 жBч(а`3жBР[™0 жB88 џџяјJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 0РнBјJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 јJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 јJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 јJ™0 жBhhРN™0 жBч(а`3жBР[™0 жB88 јJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 јJ™0 жBhhРN™0 жB88 0)жBР[™0 жB88 џџяјJ™0 жBhhРN™0 жBЏЏ(а@(жBР[™0 жB88 X„зBјJ™0 жBhhРN™0 жBЏЏ(а@(жBР[™0 жB88 8жBє ™џџџџџџя|Јex™0 жB(зBpЦмBx™0 жBX]МB0ХмBд˜зB@™зBш˜зBx™0 жB`зB№УмBє ™џџџџџџяx™0 жB—зBАТмB|Јex™0 жB˜зB0ЪмBx™0 жBазB0EпBˆУ@x™0 жB —зBpFпBŒšзB šзBЈ›зB№™зBє ™x™0 жB@—зBАBпBфšзBP›зBјšзBЂo?|Јex™0 жBŽзBpAпBџџяx™0 жB`—зB0@пBx™0 жB@ŽзB№CпB8жB№?№?x™0 жB€–зB0дмB№?|œзB@зBœзB"?SzЌќz?x™0 жBШcзB№вмBдœзBшœзBтЎНЦЛ,?тЎНЦЛ,?x™0 жBŒзBАбмBuЋѕ?оhЎЉј?gEy‹,>j?x™0 жB0]МBpамB MП„зB№зB˜зB ”?0SuЋѕ?x™0 жBHŒзB0ЯмBй?ЉъLeй? ‡ Оa@6?x™0 жB –зB№ЭмBЃіx™0 жB€ŒзBpемBЉј?’%>:хj?QœиUо?x™0 жBИŒзBpЫмB@x™0 жBР–зBАЬмB<ŸзBPŸзB˜™зB žзB@x™0 жBр–зB№ШмBŒ<№ЈXЌ`а Œ D є И l TЬФ|8єАt, Ш | 4 є А p ( м  D єЈXДl дŒ@м„,а|$а„0м„,д|шЈ`.[^ьŒU0.\П 88 Q^paytypeunkid ‚0.\П ЇЇdџџџџа4Kpayment_by0.\П hh YcreditCardProcess0.\П hh Ucashlessprocess0.•у88 Ubprivilegeunkid+‚0.•уЇЇШџџџџа4QprivilegenameржB0.•уЏЏўџа4Odeletestatus0.•у88  §џ IdispOrder0.Ю 88 O\seasonunkid0.Ю ЇЇ2џџџџа4Mseason_name0.Ю 44ўџ Gfrom^day0.Ю 44 §џ Kfrom_month0.Ю 44 ќџ Cto_day0.Ю 44ћџ Gto_monthB0.Ю ==њџ Mexpire_date0.Ю ==љџ Kstart_date0.,§88 Wdposusercatunkid0.,§88  Oposuserunkid0.,§88    Mchargeunkid0.kйп88 ]jwakeupcallansunkidЇ0.kйп==џџ Swakeupdate_ansџ0.kйпЇЇ џџўџа4Iextn_name0.kйпЇЇ ўџ§џа4Oaccount_code0.kйпЇЇ2§џќџа4Emessage0.kйп$$ћџ Eguidcolos0.Є§г88 KXundounkid‚0.Є§г88  Mchkinnunkidte0.Є§г88    Iuserunkid40.Є§г== Qundo_datetime 0.Є§г== Usystem_datftimeRa0.Є§г88   Oundomstunkid0.Є§г88 $" Kguestunkid0.Є§гЇЇdџџџџа4Kfirst_name0.Є§гЇЇd ўџ ўџа4Ilast_name0.Є§гЇЇџ §џ §џа4Eaddress0.Є§гЇЇ2 ќџ ќџа4APhone0.Є§гЇЇd ћџ ћџа4?City0.Є§гЇЇd њџ њџа4AState)0.Є§гЇЇ2љџљџа4EZipCode80.Є§гЇЇdјџјџа4ECountry0.Є§г88 (їџ MidentiunkidmзB0.Є§гЇЇdїџіџа4Iidenti_nonk0.Є§гЇЇdіџѕџа4Oidenti_staten0.Є§гЇЇџѕџєџа4Mundo_Reason0.Є§г88 ,& Iroomunkidtu0.Є§гЇЇџєџѓџа4EfolioNokB0.н!Ш88 Q^undomstunkid‚!0.н!ШЇЇџџџџа4Ioperation0.FМ88 Wdunpostcallunkid0.Хu:: Mworkjngdate 0.Хu88  =recki0.PщiЏЏ(аMWorkingdateke0.Pщi88  Qemployeeunkidџ0.‰ ^88  Gresunkid0.‰ ^88  Kguestunkid0.‰ ^== Gres_dateџ0.‰ ^== Edate_in0.‰ ^== Gdate_out0.‰ ^ЇЇdа4Etime_in.0.‰ ^88  IroomunkidIr0.‰ ^88  Qroomrateunkid§г0.‰ ^<<  ?ratee0.‰ ^<<  Itotal_taxte0.‰ ^<<  Mamount_paidOu0.‰ ^88  Sgrouptranunkide0.‰ ^88  Kagentunkidr0.‰ ^88  _arrival_airlineunkid0.‰ ^ЇЇ2а4Warrival_flightnoџ0.‰ ^88  _arrival_airportunkid0.‰ ^== Oarrival_datee0.‰ ^88  ]depart_airlineunkidјџ0.‰ ^ЇЇ2а4Udepart_flightno0.‰ ^88  ]depart_airportunkid0.‰ ^== Mdepart_dateOi0.‰ ^== Stransport_dated0.‰ ^== Obaggage_dateo0.‰ ^88  Ocompanyunkido0.‰ ^ЇЇ2а4Iagentnamems0.‰ ^ЇЇ2а4Mairlinename0.‰ ^ЏЏа4Qcancel_statusun0.Т1R88  Mdsroomunkid0.Т1R== Kvoday_date0.Т1R88  Iroomunkid0.Т1R88  Mstatusunkidџа0.Т1R88  Mchkinnunkid0.Т1R88  Qroomrateunkidur0.Т1R<< ?rate0.Т1R<< Kocc_amount0.Т1R<<   [occ_excempt_amount0.Т1R<<  Ostate_amount0.Т1R<<  _state_excempt_amountаGdurationi0.OjА<<ћџ EchargesWr0.OjА==њџ Wcurrentdate_timec0.OjА88  љџ Mct_positioneu0.ˆŽЄ88 IVvehunkide0.ˆŽЄЇЇdџџџџа4Evehmakeem0.ˆŽЄЇЇ2ўџўџа4Gvehmodelt0.Хu:: Mworkingdateke0.Хu88 \Œ<р”TА`Шx0р|А$дˆ8ш”DфŒ,м|$Фx$дˆHєЈ`аˆ<є0р˜TРphЬ | 0 р ˜ P Ь ˆ @ є Ј \ Д `  Фl PШx$Р$мŒ@ь€Рh Р`.‘3в8ц=Е$0.]Ж!88  IroomunkidптB0.]Ж!88    QratetypeunkidЕсB0.]Ж!<<џџ ?rate0.]Ж!hh GweekdaysB0.]Ж!hh Gweekends0.]Ж!<<ўџ KadultsRate0.]Ж!<<!§џ OchildrenRate0.]Ж!88 ) ќџ Mseasonunkid0.–)Њ"88  Iroomunkid`жB0.–)Њ"ЇЇџџџџџа4Cremark0.ЯMž#88 S`roomtypeunkid‚0.ЯMž#ЇЇdџџџџа4Itype_name0.ЯMž!88 ўџ Ibackcolor0.ЯMž#88  §џ KnoOfAdults0.ЯMž#88 ќџ OnoOfChildren0.ЯMž#88 ћџ MoverBookingілB0.ЯMž#hhгž: UrateDisplayType0.r’$88 Ubroomownerunkid0.r’$ЇЇ2џ§џџа4Glastname0.r’$ЇЇ2ўџўџа4Ifirstname0.r’$ЇЇd§џ§џа4Eaddress0.r’$ЇЇ2ќџќџа4?city0.r’$ЇЇ2ћџћџа4Astate ™0.r’$ЇЇ2њџњџа4=zip0.r’$ЇЇ2љџљџа4Ecountry жB0.r’$ЇЇ2 јџ јџа4Aphone0.r’$ЇЇ2 їџ їџа4=fax№0.r’$ЇЇ2 іџ іџа4Aemail0.A–†%88 ]jroomownertranunkid0.A–†%88  Iroomunkid0.A–†%88    SroomownerunkidЄ0.zКz&88 O\seasonunkid0.zКz&ЇЇ2џџџџа4Mseason_name>“A0.zКz&44ўџ Gfrom_day0.zКz&44 §џ Kfrom_month?0.zКz&44 ќџ Cto_day0.zКz&44ћџ Gto_month0.zКz&==њџ Mexpire_date0.zКz&==љџ Kstart_date0.Гоn'88 Q^serviceUnkid0.Гоn'ЇЇ2џџџџа4MserviceName0.ьc(88 O\statusunkid0.ьc(ЇЇdџџџџа4Wroom_status_name0.ьc(jj ўџ AcolorтB0.%'W)88 MZtableuniidтB0.%'W)ЇЇ2џџџџа4Itablename0.%'W)ЇЇџўџўџа4Cremark0.%'W)ЏЏ§џа4Odeletestatus0.^KK*88 ertempItemIngerenceunkidлB0.^KK*88 џџ YtempItemTranunkidhсB0. "88  Q@imtPOSMastIdUn0. "<< M@curBalancete0. "88  E@status]r0.Q/џ"== K@todayDate0.Q/џ"ЇЇ (аM@roomunkidsџ0.Q/џ"ЏЏ(аI@lastDate0.Q/џ"88  E@statusџ0.ŠSѓ#88  U@PurchaseBillId 0.ŠSѓ#88  K@deptunkidi0.ŠSѓ#88  E@status0.Уwч$== I@CurrDate0.Уwч$88  U@intSeasonunkID0.Уwч$88  E@Status0.ќ›л%== I@CurrDate 0.ќ›л%88  U@intSeasonunkID0.ќ›л%88  E@Status0.5РЯ&88  C@grpId0.5РЯ&ЇЇd(аQ@strGroupName 0.5РЯ&ЇЇd(а[@strPersonLastname0.5РЯ&ЇЇd(а]@strPersonFirstnamelN0.5РЯ%ЇЇd(аM@straddresssg0.5РЯ&ЇЇd(аG@strcity0.5РЯ&ЇЇ2(аI@StrStatern0.5РЯ&ЇЇ2(аM@strCountryes0.5РЯ&ЇЇ  (аM@StrZipcode40.5РЯ&ЇЇ  (аI@strPhoneџ0.5РЯ&ЇЇ  (аIAstrFaxno0.5РЯ&ЇЇd  (аI@strEmail0.5РЯ&==   E@dtFroml0.5РЯ&== A@dttoNo0.5РЯ&ЏЏ(аK@strStatuse0.5РЯ&ЇЇџ(аK@strRemarkp0.5РЯ&88  C@usrId0.5РЯ&$$ GAguidcol0.5РЯ&88  Q@intGrptranid0.5РЯ&== G@dtToday0.5РЯ&ЇЇd(аU@strCountryName0.5РЯ&88  W@intChargeUpdate0.5РЯ&88  Y@intPaymentUpdateqt0.5РЯ&88  M@intAgenuId0.5РЯ&88  O@intSourceId0.5РЯ&ЇЇd(аM@strFolioNoid0.5РЯ&== K@ETArrivali0.5РЯ&ЇЇd(аK@ETARemark0.5РЯ&== O@ETDeparture0.5РЯ&ЇЇd(аK@ETDRemark0.5РЯ&== U@CommissionDate0.5РЯ&hh   [@AllowGroupInvoice0.5РЯ&ЇЇd!!(аS@strCheckinRem0.5РЯ&ЇЇd""(аS@strInhouseRemhєЄ`И t  Р p  ф4м@єЈXИ\ЌdШ„8ьЈ`Ш|,мHј˜<шЄФ t , ш œ T  Ј \ИT  œpЬXдŒLШ€4ьˆ„8р0рDјЌL˜LќАМhФlаˆ@Ќ`’.”12 о0.^KK*88  ўџ [itemIngerenceUnkid0.^KK*88 §џ UrecipeItemunkid0.^KK*88 ќџ ]recipeitemtranunkid0.^KK*88 ћџ Iitemunkid0.^KK*88 њџ Qitemtranunkid0.^KK*>>5 љџ =qty0.^KK*88 ( јџ Iunitunkid0.^KK*$$ , їџ Eguidcol0.^KK*hh <  KisUpdStock0.—o?+88 Wdtempchargeunkid0.—o?+88  Qcategoryunkid0.—o?+ЇЇdџўџџа4Mcharge_name0.—o?+hh   Mshowtableno0.—o?+hh   Kshowwaiter0.—o?+hh   Mshowpersons0.—o?+hh   =kot0.—o?+88  ўџ Ideptunkid0.—o?+88  §џ Oolddeptunkjd0.—o?+$$  ќџ Eguidcol0.—o?+ll  % ћџ KlastBillNo0.—o?+ЇЇџ ўџ њџа4MthankYouMsg0.—o?+ЇЇ §џ љџа4Cprefix0.—o?+ЇЇ ќџјџа4YsalesReturnPrefix0.—o?+ll .їџ asalesReturnLastBillNo0.—o?+ЇЇ ћўіџа4OcompliPrefix0.—o?+ll 7ѕџ WcompliLastBillNo0.—o?+hh   Ucashlessprocess0.—o?+ЇЇ2њџєџа4IkotPrefix0.—o?+ll @ѓџ QkotLastBillNo0.—o?+88 Iђџ QkotRemoveDays0.а“3,88 [htempitemtranunkid0.а“3,88 џџ Qitemtranunkid0.а“3,88  ўџ Iitemunkid0.а“3,88 §џ Ideptunkid0.а“3,hh Qmaintainstock0.а“3,>>5ќџ Gquantity0.а“3,>>5ћџ Cmaxqty0.а“3,>>5%њџ Cminqty0.а“3,>>5 - љџ Iqtyinhand0.а“3,88 5 јџ Iunitunkid0.а“3,88 9 їџ Usourceunitunkid0.а“3,88 = іџ _destinationunitunkid0.а“3,>>5 A ѕџ Wconversionfactor0.а“3,$$I Eguidcol0. И'-88 _ltempposusercatunkid0. И'-88 џџ Oposuserunkid0. И'-88  ўџ Mchargeunkid0. И'-ЇЇdџџ§џа4Mcharge_name0. И'-$$ Eguidcol0.Q *88  K@grpTranIdr0.Q *88  E@status0.Ru”+88  C@grpId0.Ru”+ЇЇd(аQ@strGroupNameџџ0.Ru”+ЇЇd(а[@strPersonLastname0.Ru”+ЇЇd(а]@strPersonFirstname 0.Ru”+ЇЇd(аM@straddressQr0.Ru”+ЇЇd(аG@strcity0.Ru”+ЇЇ2(аI@StrStateGw0.Ru”+ЇЇ2(аM@strCountryke0.Ru”+ЇЇ  (аM@StrZipcodeat0.Ru”+ЇЇ  (аI@strPhonenR0.Ru”+ЇЇ  (аI@strFaxnonu0.Ru”+ЇЇd  (аI@strEmailmt0.Ru”+==   E@dtFrom 0.Ru”+== A@dtto0.Ru”+ЏЏ(аK@strStatus0.Ru”+ЇЇџ(аK@strRemark0.Ru”+88  C@usrId0.Ru”+$$ G@guidcol0.Ru”+88  Q@intGrptranId0.Ru”+== G@dtToday0.Ru”+ЇЇd(аU@strCountryName0.Ru”+88  W@intChargeUpdate0.Ru”+88  Y@intPaymentUpdateGa0.Ru”+88  M@intAgentIdy0.Ru”+88  O@intSourceId0.Ru”+ЇЇd(аM@strFolioNoљџ0.Ru”+== K@ETArrival0.Ru”+ЇЇd(аK@ETARemark0.Ru”+== O@ETDeparture0.Ru”+ЇЇd(аK@ETDRemarks0.Ru”+== U@CommissjonDate.0.Ru”+hh   [@AllowGroupInvoice0.Ru”+ЇЇd!!(аS@strCheckinRem0.Ru”+ЇЇd""(аS@strInhouseRem0.Ru”+ЇЇd##(аU@strCheckoutRem0.Ru”+ЇЇd$$(аS@strPaymentRem0.Ru”+88 %% S@intVranStatus0.Ru”+hh&& W@intRemovedRooms0.Ru”+88 '' [@intDiscountUpdate0.Ru”+88 (( U@NewGroupTranIdQ^0.Ru”+88 )) E@status0.‹™ˆ,88  S@intQueryunkid0.‹™ˆ,ЇЇd(аQ@strQufryName0.‹™ˆ,ЇЇџ(аU@strDescription0.‹™ˆ,hh O@bitIsDelete0.‹™ˆ,$$ G@strGUID  K@grpTranIdЄTДHИhМhЈ H № Є X  а ˆ 4 ш œ H р ШlРlРlИlа„4ф”8рˆ@ьЄ`Ш„<№ЄXИl$дtФ€Œ 8 ь”<ьˆ,ш˜LДh(иŒ<ь˜48ьш TРtМ`–.—1і№ЈD0. ўМ5==џџ Itodaydate0. ўМ5ЇЇ–џџўџа4KBackUpPathB0. ўМ5ЏЏ§џа4Kbackuptype0. ўМ5ЏЏќџа4Qdelete_status0. ўМ588  IuserunkidЁтB0.C"Б688 Ubblockroomunkid:‚0.C"Б688 џџ Iroomunkid™0.C"Б6== ўџ Kblock_date0.C"Б6ЇЇdџџ§џа4Creason0.|FЅ788 WdchargeTranUnkid0.|FЅ788  ObookingUnkid0.|FЅ788  џџ KguestUnkidB0.|FЅ788   MchargeUnkid0.|FЅ7<< Qcharge_amount0.|FЅ7<<ўџ Ktax_amountB0.|FЅ7ЇЇџџ§џа4IvoucherNo0.|FЅ7hh$ Scharge_reoccur0.|FЅ7== %  Ucharge_datftime™0.|FЅ788 - ќџ Iuserunkid€тB0.|FЅ788 1 ћџ SgrouptranunkidB0.Еj™8ll [˜BookingPaperunkid0.Еj™8ll    Obookingunkid0.Еj™8ll  Kpaperunkid0.Еj™888  Kno_of_copy0.юŽ988 _lbookingPaymentUnkid0.юŽ988  ObookingUnkid0.юŽ9<<   Mamount_paid0.юŽ9==џџ Opay_datetime0.юŽ9ЇЇdџџўџа4IreceiptNo0.юŽ988 §џ Opaytypeunkid0.юŽ9ЇЇdўџќџа4Ecard_no0.юŽ9ЇЇ§џћџа4QcardValidTill№?0.юŽ9ЇЇd ќџ њџа4Wauthorisation_no?0.юŽ988 љџ OaccountUnkid0.юŽ988 $  IuserunkidѕлB0.юŽ988 ( јџ Sgrouptranunkid0.юŽ9== , їџ IauditDate0.юŽ9==4іџ EauditOn*жB0.юŽ9<<< ]currencyamount_paid0.юŽ988 D YexchangeRateunkid0.юŽ9<<H" OexchangeRate0.юŽ9hhP У ;* QisCCProcessed0.юŽ9hhPEчџ;* [isCCBatchProcessedB0.'Г:88 ERtranID0.'Г:== GtranTimeB0.'Г:ЇЇ џџџџа4KmoduleName0.'Г:ЇЇdўџўџа4KserverName0.'Г:ЇЇ2§џ§џа4GclientID0.'Г:ЇЇ2ќџќџа4CsiteID0.'Г:ЇЇ2ћџћџа4EpriceID0.'Г:ЇЇ2њџњџа4Gpassword0.Х6== K@todaydate0.Х688  K@roomunkid0.Х6ЇЇџ(аK@strreason0.Х688  O@chkinnunkid0.Х688  M@guestunkid0.Х6ЇЇd(аG@folioNo0.Х688  Q@intuserunkidџа0.Х688  O@statusunkid0.ў'788  U@PurchaseBillIdUa0.ў'7ЇЇ(аK@voucherno0.ў'7== O@vouchfrdate0.ў'788  S@supplierUnkidd0.ў'7<< Q@total_amountГ:0.ў'7<< M@tax_amountэџ0.ў'7<< O@dis_percent0.ў'7<< M@dis_amount40.ў'7<<   O@bill_amountc0.ў'788   K@userunkidc0.ў'7$$   G@guidcol0.ў'788   K@deptunkid0.ў'7ЇЇ  (аO@PurchaseVno0.ў'7ЇЇ(аQ@PurchaseType0.ў'788  E@status0.7Lњ7== M@curNaxDateQn0.7Lњ788  S@intguestunkidn0.7Lњ7ЇЇd(аQ@strFirstNameTr0.7Lњ7ЇЇd(аO@strLastNamer0.7Lњ7ЇЇd(аM@straddressd0.7Lњ7ЇЇd(аI@strPhoneГ:0.7Lњ7ЇЇd(аG@strcity:0.7Lњ7ЇЇd(аI@StrState.0.7Lњ7ЇЇd  (аM@StrZipcode0.7Lњ7ЇЇd  (аM@strCountryay0.7Lњ7ЇЇ2  (аI@strEmail0.7Lњ7hh   K@bitGender0.7Lњ7==   O@dtbirthdate0.7Lњ788  Y@strJdentityUnkid0.7Lњ7ЇЇd(аS@strIdentityNo0.7Lњ7ЇЇd(аY@StridentityStateџа0.7Lњ7ЇЇd(а]@stridentityCountryes0.7Lњ7== Q@dtexpiredate0.7Lњ7ЇЇd(аY@strautoLicenseNo0.7Lњ7ЇЇd(а_@strautoLicenseState0.7Lњ7ЇЇd(аW@strvehicle_make0.7Lњ7ЇЇd(аY@strvehicle_model  Gissucess0.Х6==`дŒ@єЌXќ Ј X ќ œ T  Д h  Р l $ д ˆ 8 ш˜,р”DЌ”<м€,ЬpРp$иˆ8ьЄXИdРX Д`Шt$иˆ$x$дˆ@єЄTД` Мpр”HфШt,мŒ@єЈ˜DјЌ`.`@ l_10Р0.'Г:ЇЇ2 љџ љџа4=key0.'Г:ЇЇ2 јџ јџа4GtranTypeB0.'Г:ЇЇ2 їџ їџа4KcardNumber0.'Г:ЇЇ іџ іџа4GexpMonth0.'Г:ЇЇ ѕџ ѕџа4EexpYear0.'Г:<<єџ Camount0.'Г:hh McardPresent0.'Г:ЇЇєџѓџа4ItrackData0.'Г:ЇЇ2ѓџђџа4KsendGateID0.'Г:hh UallowDuplicates0.'Г:ЇЇџђџёџа4GlastName0.'Г:ЇЇџёџ№џа4IfirstName0.'Г:ЇЇџ№џяџа4Eaddress0.'Г:ЇЇџяџюџа4?cityџ0.'Г:ЇЇџюџэџа4Astate0.'Г:ЇЇџэџьџа4Ecountry0.'Г:ЇЇџьџыџа4=zip0.'Г:ЇЇџыџъџа4Aemail0.'Г:ЇЇ2ъџщџа4KchargeType0.'Г:ЇЇ щџшџа4OcheciOutTime0.'Г:ЇЇ шџчџа4McheckInTimeџя0.'Г:ЇЇчџцџа4OstayDuration0.'Г:ЇЇ2цџхџа4KroomNumber0.'Г:ЇЇ2 хџ фџа4KroomAmount0.'Г:ЇЇ2!фџ!уџа4GroomRate0.'Г:ЇЇ2"уџ"тџа4QnonRoomCharge0.'Г:ЏЏ##сџа4CnoShow0.'Г:hh$$ [processTransaction0.'Г:ЇЇ%тџ%рџа4CerrMsg0.'Г:ЇЇ &сџ&пџа4Gapproved0.'Г:ЇЇ2'рџ'оџа4CgateID0.'Г:ЇЇ2(пџ(нџа4GauthCode0.'Г:ЇЇ)оџ)мџа4MdeclineCode0.`зu;88 ERtranID0.`зu;88  itranID_ASIPaymentGateway2ЕтB0.`зu;ЇЇ@џџџџа4GrecvDataB0.™ћi<88 ERtranIDтB0.™ћi<88  itranID_ASIPaymentGateway2ЖтB0.™ћi<ЇЇ@џџџџа4GsendDataB0.в^=88 Q^cctransunkid0.в^=ЏЏџџа4Itranstype0.в^=ЇЇdџџўџа4Ideskclerk уB0.в^=ЇЇ2ўџ§џа4Arecno0.в^=ЇЇ2§џќџа4?ccno0.в^=ЇЇќџћџа4Iccexpdate0.в^=<< њџ CammuntB0.в^=ЇЇ ћџљџа4=zipџџџ0.в^=ЇЇ2 њџ јџа4Eaddress€тB0.в^=hh   Gissucess0.в^=ЇЇd љџ їџа4Mtran_result0.в^=ЇЇd јџ іџа4Mtran_sourceMуB0.в^=ЇЇd їџ ѕџа4Itran_file™0.тИж:88  O@cikinnunkid0.тИж:88  I@resunkid0.тИж:88  Q@bookingUnkid.0.тИж:$$ G@guidcolo0.тИж:ЏЏ(аA@flague0.тИж:88  K@groupFlagy0.нЪ;ЏЏ(а_@strUpdMultipleGuestB0.нЪ;ЏЏ(а_@strDelMultipleGuest0.нЪ;$$ G@guidcola0.нЪ;ЏЏ(аA@flagdd0.нЪ;88  K@groupFlage0.TП<$$ G@guidcol. DR>ЇЇ2ћџћџа4Astate0. DR>ЇЇ2њџњџа4=zip0. DR>ЇЇ2љџљџа4Ecountry0. DR>ЇЇ2 јџ јџа4Aphone0. DR>ЇЇ2 їџ їџа4=fax0. DR>ЇЇ2 іџ іџа4Aemail0. DR><<   McreditLimit0. DR><<   Ebalance0. DR>ЏЏѕџа4OactiveStatus0. DR>ЏЏєџа4OdeleteStatus0. DR>ЇЇ2ѕџѓџа4IfirstName0. DR>ЇЇ2єџђџа4GlastName0. DR>88 ёџ KagentUnkid0. DR><<№џ SopeningBalanceB0. DR>ЇЇ2ѓџяџа4IrfcNumberџџџ0. DR>ЇЇ2ђџюџа4MrfcAddreqs10. DR>ЇЇ2ёџэџа4MrfcAddress20. DR>ЇЇ2№џьџа4ErfcCity0. DR>ЇЇ2яџыџа4GrfcState0. DR>ЇЇ2юџъџа4CrfcZipB0. DR>ЇЇ2эџщџа4KrfcCountry0. DR>88 &шџ KcreditDays0.DhF?88 KXtqanUnkid0.DhF?88  anonrentalpaymentunkid0.DhF?88    GtranType0.DhF?== GtranDate0.DhF?88  WpaymenttranunkidB0.DhF?<< UallocatedAmount™0.DhF?88 $" Mchkimnunkid0.DhF?88 (џџ Uchargetranunkid0.}Œ:@88 YfdailyAttendUnkid0.}Œ:@88  QemployeeUnkid0.}Œ:@88    UdepartmentUnkid0.}Œ:@:: MworkingDate0.}Œ:@jj  OworkingHours0.}Œ:@<< EpayRateEуB0.}Œ:@ЏЏ%#а4EpayType€тB0.}Œ:@ЏЏ&$а4Cstatus0.тИж:88  O@chkinnunkid0.тИж:88  I@resux(иHФ x 8 є Ј \ ќ $Д H є и”LьŒЌ @ ь @ќД`Фœ T  Ш„(фHќА`Рt0№Јd$мH№ЄXФ|4ш `RО xф;–10R * C@ ~’88 sysobjects0RRњЄМ žВ88 44sysindexes0R  # ^psysfiles10R@џ@1+џџ^ttsysindexes0R@.Dri•Œ| Рдф€88 44 44 syscolumns@0R @ (& Š q' АР€ЅЅUџџўџџџ44sysusers@ 0R  ++kq,Ржц€44ЅЅUџџўџџџ44ncsysusers2 @0R`@0. /€šЊ€44sysfilegroups @0R@53ЃЉЅууb 4Ржц€88 4444 syscomments @0R @I?| HРмь€88 4444 syspermissions @0R @86"JBаш;%%7$0088 88 44  44 sysdepends@0R 99 %: КЪ88 44 0088 44  0088 88 44  44 ncsysdepends1@0R@ЅЃ**nЄ€žЎ€88 ucsysreferences@ 0RІІ  Ї Ра€88 88 nc1sysreferences@0RЈЈ  Љ Ра€88  88 nc2sysreferences@0R@%€ІЖ€44sysfulltextcatalogs@0R@ ž Тв€88 ЅЅ€џџџџџџsysfulltextnotify@ 0R^vsysindexkeys0R'^zsysforeignkeys0R^rsysmembers0RС^tsysprotects0R_$6^nsysfiles 0RKKЫџџџ LРиш€ч(аџџџџџџ44 88 ncsysobjectsщ@0RMM Ыџџџ N КЪ€88  88 ncsysobjects2ъ@s0RPP !?џџџ"Q 8H88 ч(аџџџџџџ44 88 44 44 ncsyscolumnsы@0R@RT1S€ €ч(аџџџџџџsystypesь@0RUUV ДФ€44ч(аџџџџџџncsystypesэ@ 0R  WW єџџџmsXРжц€ч(аџџџџџџЅЅUўџўџџџ44ncsysusers1ю@ 0R @ |!рњ 88 00 44ч(аџџџџџџsyspropertiesя@ 0R Ък€ч(аџџџџџџ44ncsysfulltextcatalogs№@ 0R`YYџџџџZ ОЮ€ч(аџџџџџџ44sysfilegroupsncё@l0Rƒзuўџџ^jHWInfo0RXЇЫv4џџ^|cfCountryMaster0R‘ЫПw%џџ^~cfItemGroup_tran0RЪяГx Rџџ^vcfItem_Group0RЈy*;џџ^~cfItem_Ingerence0R<8œz…џџ^|cfNewsPaper_mst0Ru\{ Ћџџ^„cfNonRentalUnit_mst0Ru\{џџџ^†tcfNonRentalUnit_mst0RЎ€„|Oџџ^xcfRateCaption0RчЄx} џџ^|cfRoomAmenities0R Щl~Mџџ^„cfRoomAmenities_Mst0RYэ` /џџ^tcfRoomImage0RYэ`џџџ^vtcfRoomImageR0R’U9џџ^zcfSupplier_mst44sysfil„Œ˜Œ˜Аќр@ ЬXмdи  8 ˆ М˜ј0pЌЈФLЌdŒє˜А` †ш ^Зd& isapprole& islogin& isntgroup& isntname& isntuserЧq& issqlrole& issqluserB& nameсЛB& passwordсЛB& roles& sid& status`ЛB& uid& !updatedateTеB& idЋНB& name& smallidB& typeтЛB& value& depdbid& depid& depnumber& depsiteid?& deptype& id& numberѓЛB& readobjB& resultobj& selall™& status&constid& fkey1B&fkey10&fjey11чЛB&fkey12&fkey13™&fkey14`ЛB&fkey15&fkey16& fkey2& fkey3& fkey4&fkey5&fkey6&fkey7&fkey8&fkey9&fkeydbid&fkeyid&forkeys&keycnt&refkeys&rkey1&#rkey10ћЛB&$rkey11&%rkey12™&&rkey13`ЛB&'rkey14‹Ѕ&(rkey15&)rkey16ћЛB&rkey2B&rkey3B&rkey4B&rkey5B&rkey6B& rkey7B&!rkey8B&"rkey9B& rkeydbid&rkeyid&rkeyindid&ftcatidB&name&path&status&colidB&id™&indid&keyno&constid&fkey&fkeyid&keynoB&rkey рB&rkeyid&groupuid&memberuid&action&columns&grantor&id&#protebttype&uidB&ftkey&rowinfo&tableid&_fileid&_ filename&_groupid&_growthYЪB&_maxsize&_name&_perf&_size&_status`ЛB&`#allocpolicy&`groupid&`groupname&`status&’ULastName&’UFirstName&’UAddress1ac&’UAddress2li&’UCityns&’U Countryo&’U Phonenoу&’U email&’U Faxnos&’U%ActiveStatusƒз&’U%DeleteStatus&h 'reminderunkidз&h startDatee&h #Duedatetimet&h title&h messageз&h %remindertype#&h priority &h userunkidз&h isreadss&h )Dest_userunkidƒз&h %intervaltype&h frequency&h %stopReminderXЇЫ&h snoozeioB&XЇЫv#tax2Caption&XЇЫv%stateCaption`ЛB&XЇЫv!zipCaption&XЇЫvCurrency&‘ЫПw1itemgrouptranunkid&‘ЫПw)itemgroupunkid рB&‘ЫПw#chargeunkid&‘ЫПwitemunkidB&ЪяГx)itemgroupunkid№ЛB&ЪяГx!item_group№ЛB&ЪяГx%deletestatus&ЪяГx-itemgrouporderID&Јy1itemIngerenceUnkid&Јy+recipeitemunkidB&Јy3recipeitemtranunkid&ЈyitemunkidB&Јy'itemtranunkid&Јyqty&Јyunitunkid&Њy!isUpdStock ™&<8œz!paperunkid&<8œz!paper_name&<8œz'delete_status&u\{unitunkid&u\{unitNameЋЛB&u\{!isDispName&u\{+captionPositionB&u\{unitImage&u\{backColor&u\{#isBackColor&u\{foreColorB&u\{ remarkЈЛB&u\{ %deletestatus&Ў€„|ratenbme&Ў€„|#ratecaption&Ў€„|/defaultratenumber&чЄx}1roomAmenitiesUnkid&чЄx}roomunkidџ& Щl~1roomAmenitiesUnkidџџџ& Щl~'roomAmenities&Yэ`)roomImageUnkidџџџ&Yэ`roomUnkidџ&Yэ`roomImageџ&’U'Supplierunkidџ&’U%SupplierName&’ULastNameџџџ&’UFirstName&’UAddress1&’UAddress2&’UCityџџџ&’UStateџ&’U CountryB&’U ZipCodeџ&’U Phoneno&’U email&’U Faxno&’U%ActiveStatus&’U%DeleteStatus&’UTax&Ы5IUnitunkid&Ы5IUnitName&Ы5I%deletestatus&Z='categoryunkid&Z='cbtegory_name&Z=isdeleted&=~1#accpayunkidB&=~1%account_typeљЛB&=~1isdeletedB&vЂ%+cashdrawerunkid&vЂ%1cashdrawercurrencynМB&ЏЦ+catreceiveunkidB&ЏЦ+catreceive_nameB&ЏЦisdeletedB&шъ 1categorytableunkid&шъ #chargeunkidB&шъ !tableunkid&!#chargeunkidB&!#charge_name&!taxableB&!%alwayschargeњЛB&!#charge_typeB&!rateЂНB&!)charge_reoccuriМB&!#charge_call&! pos&! #showtablenoB&! !showwaiterћЛB&! #showpersons?&! kot&!#ct_position&!deptunkid&!isDepnsitB&!!lastBillNoьЛB&!#thankYouMsgB&!prefix&!/salesReturnPrefix&!7salesReturnLastBillNo&!%compliPrefix&!-compliLastBillNo&!+cashlessprocess&!kotPrefix&!'kotLastBillNo&!'kotRemoveDays&Z3і%depositunkid&Z3і%dfposit_name&h 'reminderunkid&h startDate&h #Duedatetime &h title &h message&h %remindertypeь&h prio” р Ш А  x ` @ р œ ШX №0 а ј Д 8€Јx TФ Є ˆ d H 0  ф Ш Ќ Œ p T 8 ш д И œ € ` @ $ єиРЄŒt`H,ќрРЄ„lT<$ ємФЈŒpT8шЬА”xX@(јрША˜|`D( №дМ „hH,ќрР ˆlT< єаМ ŒtT<ќмМœ€` Zј„^-<J!"$8аР` џZјЃh ^O‹ 4568‚@Р`J.xDœ мдBV$0._яя  (аGfilename0.`44 Egroupid0.`44 Mallocpolicy0.`88  Cstatus0.`чџџџџ(аIgroupname ™0.’U88 S`Supplierunkid0.’UЇЇdџџџџа4OSupplierName0.’UЇЇ2ўџўџа4GLastName0.’UЇЇ2§џ§џа4IFirstName0.’UЇЇdќџќџа4GAddress1l0.’UЇЇdћџћџа4GAddress2e0.’UЇЇ2њџњџа4?Citya0.’UЇЇ2љџљџа4AStatect0.’UЇЇ2 јџ јџа4ECountryrr0.’UЇЇ їџ їџа4EZipCodeIn0.’UЇЇ2 іџ іџа4EPhoneno0.’UЇЇd ѕџ ѕџа4Aemailџ0.’UЇЇ2 єџ єџа4AFaxno0.’UЏЏѓџа4OActiveStatus0.’UЏЏ ђџв4ODeleteStatus0.’U>>5 ёџ =Taxƒзu0.Ы5I88 KXUnitunkid0.Ы5IЇЇ2џџџџа4GUnitName0.Ы5IЏЏўџа4Odeletestatus0.h 88 S`reminderunkid‚0.h ==џџ IstartDatfna0.h ==ўџ MDuedatetimeed0.h ЇЇ2џџ§џа4Atitlecp0.h ЇЇdўџќџа4Emessage40.h ЇЇ2§џћџа4Oremindertype0.h 88 њџ Gpriority0.h 88 љџ Iuserunkid0.h hh  Cisreade0.h 88 ! јџ SDest_userunkide0.h ЇЇ ќџ їџа4Ointervaltypec0.h 88 % іџ Ifrequency40.h == ) ѕџ OstopReminder0.h 88 1єџ Csnooze0.Ё+jj [˜remindertranunkid‚0.Ё+88  џџ Qreminderunkid0.Ё+==ўџ Mduedatetimeme0.Ё+88 §џ Qdestuserunkid0.Ё+hh  CisReadg0.кO88 IVresunkidх‚.0.кO88  Kguestunkjd0.кO==   Gres_date0.кO== Edate_inll0.кO== Gdate_out0.кOЇЇdџџџџа4Etime_inno0.кOЇЇdўџўџа4Mtime_cancelra0.# u88  K@itemunkids0.# uЇЇd(аI@itenname 0.# uhh I@purchased0.# uhh A@saleIs0.# u$$ G@guidcol0.# uhh K@ingerence0.\1i88  Q@kotmastunkidsa0.\1i== G@KOTdaten0.\1i88  O@chargeunkidr0.\1i88  S@cattableunkidа0.\1i88  K@userunkid0.\1iЇЇџ(аE@remarkki0.\1i$$ G@guidcola0.\1i88  G@KOTTypee0.\1i88   I@WaiterIdto0.\1iЇЇ  (аK@vouchernos0.\1ihh   O@isFirstTimed0.\1i88   ]@intTransactionType8  џџ Qreminderunkid 0.Ё+==ўџ Mduedatetime 0.Ё+88 §џ Qdestuserunkidti0.Ё+hh  CjsReadp0.кO88 IVresunkidt0.кO88  KguestunkidN0.кO==   Gres_dateo0.кO== Edate_inre0.кO== Gdate_outs0.кOЇЇdџџџџа4Etime_in0.кOЇЇdўџўџа4Mtime_cancel0.кO88 $" Iroomunkid10.кO88 ( & Qroomrateunkid0.кO88 , §џ Ototal_person0.кO<< 0 ќџ ?ratex0.кO<< 8 ћџ Itotal_taxBi0.кO<< @ њџ AtotalQk0.кO<<Hљџ Mamount_paid0.кO88 Pјџ Iuserunkid0.кOЏЏTїџа4Mocc_excempt0.кOЏЏUіџа4Qstate_excempt0.кOЏЏVѕџа4Kres_status0.кOЏЏWєџа4Qchkinn_status0.кOЏЏXѓџа4Qcancfl_status0.кOЏЏYђџа4Ogroup_chkinn0.кO88 Zёџ Ggrpunkid0.кO88 ^№џ Sgrouptranunkid0.кO88 bяџ KagentUnkid0.кO88 fюџ _arrival_airlineUnkid0.кOЇЇ2§џэџа4Warrival_flightNo_0.кO88 jьџ _arrival_airportunkidl0.кO==nыџ Oarrival_datee0.кO88 vъџ ]depart_airlineUnkid_b0.# u88  K@itemunkid P  ДX ИXДdЌ$м”LИ ` |,р”LМpЬ„0Рh Ш x $ Œ фœX Рt(иˆDИp(фЄ\Ш€0аH ј Ќ \  Ф x 0 р˜TИX„@№Ј`Ry,Јфч 0R^vsysindexkeys0R'^zsysforeignkeys0R^rsysmembers0RС^tsysprotects0R@ ž Тв€88 ЅЅ€џџџџџџsysfulltextnotify@0R_$6^nsysfilesЛB0R`@0. /€šЊ€44sysfilegroups @0R`YYџџџџZ ОЮ€ч(аџџџџџџ44sysfilegroupsncё@0R’UH9€ЂВ€88 PK_fdSupplier_mstТ O 0RЫ5IH N€šЊ€88 PK_cfUnit_mstУ Os0Rh Hqo50p€ЄД€88 PK_fdreminder_info; ‹>0RЁ+Htr/!s€ЄД€jj PK_fdreminder_tran< ‹?0RкOHGE КV‰щF€ЊК€88 PK_fdreservation_info= ‹@0RЁ+` ќџџџ#) иш€==jj  _WA_Sys_duedatetime_01142BA1ˆ#E0RЁ+`  ќџџџ" Юо€hhjj _WA_Sys_isRead_01142BA1‰#EА€0RЁ+` ќџџџ% мь€88 jj _WA_Sys_destuserunkid_01142BA1Š#E0RкO` ўџџџ мь€ЏЏа4W88 _WA_Sys_chkinn_status_02084FDAŒ#E0RкO` ўџџџ мь€ЏЏа4X88 _WA_Sys_cancel_status_02084FDA#E0RкO` ўџџџ къ€hhTт88 _WA_Sys_hourlyRented_02084FDAŽ#Ea0RкO`€ ўџџџ$ ар€==88  _WA_Sys_date_in_02084FDA#E0RкO`€ ўџџџ  дф€88 $88 _WA_Sys_roomunkid_02084FDA#E0RЁ+` ќџџџ% мь€88  jj _WA_Sys_reminderunkid_01142BA1д2ˆPK_fdshift_detailA ‹D_0RїЭHQ!€ЊК€ll PK_fdtempIDTypeDetailB ‹Ef0R0)СH):€АР€88 PK_fdtempIngerence_StockC ‹F0RiMЕHZC€КЪ€88 PK_fdtempNonRentalPaymentTranD ‹G0RЁ+` ќџџџ#) иш€==jj  _WA_Sys_duedatetime_01142BA1ˆ#E0RЁ+`  ќџџџ" Юо€hhjj _WA_Sys_isRead_01142BA1‰#E0RЁ+` ќџџџ% мь€88 jj _WA_Sys_destuserunkid_01142BA1Š#E0RL˜№`€ §џџџ  вт€88 88 _WA_Sys_resunkid_03F0984C‹#C0RкO` ўџџџ мь€ЏЏа4W88 _WA_Sys_chkinn_status_02084FDAŒ#E0RкO` ўџџџ мь€ЏЏа4X88 _WA_Sys_cancel_status_02084FDA#E0RкO` ўџџџ къ€hhTт88 _WA_Sys_hourlyRented_02084FDAŽ#E0RкO`€ ўџџџ$ ар€==88  _WA_Sys_date_in_02084FDA#E0RкO`€ ўџџџ  дф€88 $88 _WA_Sys_roomunkid_02084FDA#E0RкO`€ ўџџџ  жц€88 88 _WA_Sys_guestunkid_02084FDA“#F0RкO` ўџџџ|‚ дф€ЇЇdа44џџіџџџ88 _WA_Sys_firstName_02084FDA™#C0RкO`  ўџџџ|‚ вт€ЇЇdа45џџѕџџџ88 _WA_Sys_lastName_02084FDAš#C 0RкO`€ ўџџџ$ вт€==88  _WA_Sys_date_out_02084FDAœ#F 0RЁ+` ќџџџ%žк88  jj _WA_Sys_reminderunkid_01142BA1 (Dиј 4 ФАМH h €ќ\,€<ШTи`.d0 2Ь0.ƒзuЇЇ2 љџ їџа4MMACAddress20.ƒзuЇЇ2 јџ іџа4KIPAddress10.ƒзuЇЇ2 їџ ѕџа4KIPAddress20.XЇЫv88 Q^countryUnkidэ‚0.XЇЫvЇЇџџџџџа4McountryName0.XЇЫvЇЇџўџўџа4Mtax1Caption0.XЇЫvЇЇџ§џ§џа4Mtax2Caption0.XЇЫvЇЇџќџќџа4OstateCaption0.XЇЫvЇЇџћџћџа4KzipCaptionB0.XЇЫvЇЇњџњџа4GCurrency0.‘ЫПw88 ]jitemgrouptranunkid0.‘ЫПw88 џџ Sitemgroupunkid0.‘ЫПw88  ўџ Mchargeunkid0.‘ЫПw88 §џ Iitemunkid0..–vll џџ Iuserunkidpu0..–v$$ ўџ Eguidcol0..–v$$§џ KMasterGuid0..–vll -ќџ Mdsroomunjid0..–vll 6ћџ Mchkinnunkid0..–vll ?њџ Gresunkid0.gСŠw88 Q^paytranunkid 0.gСŠw88  Qcategoryunkid0.gСŠw88    Maccpayunkid0.gСŠw== Opayable_date0.gСŠw<<џџ Camount0.gСŠwЇЇdџџўџа4Cnumber0.gСŠwЇЇdўџ§џа4Epaid_to)0.gСŠw88   Iuserunkid0.gСŠw<< $ ќџ =tax0. х~x88 Q^paymentunkidа0. х~x88  Mchkinnunkid40. х~x88    Kguestunkid0. х~x<< Mamount_paid0. х~x88 џџ Opaytypeunkid0. х~xЇЇdџџўџа4Ecard_no0. х~xЇЇdўџ§џа4Wauthorisation_no0. х~x==ќџ Opay_datetime0. х~x88 $  Iuserunkid0. х~x88 ( ћџ OaccountUnkid0. х~x88 , њџ Sgrouptranunkid0. х~xЏЏ 0‚#I_ љџа4Kauthorized0. х~xЇЇ §џ јџа4QcardValidTillGr0. х~x==1їџ IauditDateat0. х~x==9іџ EauditOn 0. х~x88 Aѕџ Urespaymentunkid0. х~xЇЇdќџєџа4IreceiptNo0. х~xhhEЛG=` MISReconcile0. х~x88 Fѓџ Odepositunkid~0. х~x<<Jђџ UallocatedAmount80.А~їu== C@mindtk0.А~їu== C@maxdt0.А~їu88  K@RoomunkID0."Чпw88  S@intGM_guestIDu0."ЧпwЇЇd(аW@strGM_firstNamel0."ЧпwЇЇd(аU@strGM_lastName–v0."ЧпwЇЇџ(аS@strGM_address0."ЧпwЇЇd(аOBstrGM_phone0."ЧпwЇЇd(аM@strGM_city0."ЧпwЇЇd(аO@strGM_state0."ЧпwЇЇd(аS@strGM_zipCode0."ЧпwЇЇd  (аS@strGM_countryw0."Чпw88   [@intGM_identiUnkid0."ЧпwЇЇd  (аM@strGM^idNo0."ЧпwЇЇd  (аS@strGM_idState0."ЧпwЇЇd  (аW@strGM_idCountryu0."Чпw== U@dtGM_ExpirDate80."ЧпwЇЇd(а_@strGM_autoLicenseNo0."ЧпwЇЇd(аe@strGM_autoLicenseState0."ЧпwЇЇd(в[@strGM_vehicleMake0."ЧпwЇЇd(а]@strGM_vehicleModelpe0."Чпw88  e@intGM_vehicleModelYearўџ0."ЧпwЇЇџ(аQ@strGM_Remark0."Чпw== U@dtGM_BirthDate0."ЧпwЇЇџ(аO@strGM_Email0."Чпvhh Q@bitGM_Gender0."Чпw88  W@intGM_DNRStatus0."Чпw88  U@intCI_chkinnID0."Чпw88  S@intCI_guestID0."Чпw88  U@intCI_ResUnkidud0."Чпw== W@dtCI_chkinnDatev0."Чпw== W@dtCI_chkoutDate0."Чпw88  Q@intCI_roomID.0."Чпw88  Y@intCI_roomrateID0."Чпw<<   M@intCI_rateх~x0."Чпw88 !! [@intCI_totalPerson0."Чпw<<"" ]@intCI_totblChargesх~x0."Чпw<<## ]@intCI_transientTax0."Чпw<<$$ ]@intCI_otherCharges0."Чпw<<%% Y@intCI_amountPaid0."ЧпwЏЏ&&(а]@intCI_chkoutStatus40."ЧпwЏЏ''(аY@intCI_occExcemptir0."ЧпwЏЏ(((а]@intCI_stateExcempt.0."Чпw88 )) c@intCI_ChkOutUserUnkid0."Чпw88 ** [@intCI_GroupChkinnm_phone0.А~їu==DєЄXИ l  Ь x ( м Œ 4 ь œ L А P АLь0дtДXЌXЈPќЄLјЈPќ”4иpИ` М` ИhШtФpŒ<ш| Ф|8єЄT 4ш˜HјЈHXИl$и$рœќА` €uхp&’UState&’U%SupplierNameеB&’U'SupplierunkidB&’UTax&’U ZipCode&Ы5I%deletestatus &Ы5IUnitName ™&Ы5IUnitunkidB&Ё+/remindertranunkid&Ё+'reminderunkid&Ё+#duedatetime%&Ё+'destuserunkid#&Ё+isRead=~1&кOresunkidvЂ%&кO!guestunkidrr&кOres_datesh&кOdate_in&кOdate_out_n&кOtime_inr&кO#time_cancel&кOroomunkid1&кO 'roomrateunkid&кO %total_personшъ &кO ratenk&кO total_taxs&кO total&кO#amount_paid&кOuserunkidl&кO#occ_excemptm&кO'state_excemptc&кO!res_status_t&кO'chkinn_statusi&кO'cancel_statusi&кO%group_chkinnPr&кOgrpunkid_p&кO)grouptranunkidki&кO!agentUnkidt&кO5arrival_airlineUnkidlN&кO-arrival_flightNo'&кO5arrival_airportunkidll&кO %arrival_date&кO3depart_airlineUnkid7&кO+depart_flightNo&кO3depart_airportunkid&кO #depart_date&кO!)transport_date!&кO"%baggage_dateta&кO#%companyUnkidou&кO$auditDatei&кO%auditOn%&кO&#total_child&кO'#cancel_date&кO(cancelbyys&кO )%paytypeunkidoc&кO*card_noe&кO+'cardvalidtillъ&кO,#sourceUnkid&кO-;franchiseConfirmationNod&кO.%bookingUnkido_&кO/!tranStatusce&кO0ETA&кO1ETARemarks&кO2ETD &кO3ETDRemarks&кO4firstNameo&кO5lastNamese&кO6address#&кO7cityn&кO8suaten&кO9country9&кO:zipH&кO;phonet&кO<birthDatet&кO=emailо&кO>genderGu&кO?#identiUnkid&кO@identiNoma&кOA#identiStatee&кOB'identiCountry#&кOC!expireDate!&кOD'autoLicenseNoh&кOE-autoLicenseStatert&кOF#vehicleMake)&кOG%vehicleModelЬ{о&кO H'vehicle_colori&кOI-vehicleModelYearЬ{о&кOJ#companyNameо&кOKremarkli&кOL/tranRemarkCheckIna&кOM/tranRemarkInHousea&кON1tranRemarkCheckOutЬ{о&кOO/tranRemarkPaymentt&кOP/commissionPayDatee&кOQ-commissionAmountЬ{о&кOR/allowGuestInvoicec&кOS%otherAharges_u&кOT%hourlyRentedpa&кOU9hourlyCheckoutDateTimeoc&кOVdiscountce&# u!@itemunkidou&# u@itemnames&# u@purchase#&# u@saleo&# u@guidcolve&# u!@ingerenceac&\1i'@kotmastunkid+&\1i@KOTdateat&\1i%@chargeunkid-&\1i)@cattableunkid-&\1i!@userunkidt&\1i@remarkt&\1i@guidcolЁ+&\1i@KOTTypean&\1i @WaiterIdi&\1i !@vouchernodu&\1i %@isFirstTimest&\1i 3@intTransactionTyperesunkidYэ`&кO!guestunkid&кOres_dateZ3і&кOdate_inl&кOdate_outpo&кOtime_inі&кO#time_cancele&кOroomunkide&кO 'roomrateunkide&кO %total_personun&кO rateus&кO total_taxa&кO total&кO#amount_paidB&кOuserunkidh&кO#occ_excemptw&кO'state_excempte&кO!res_statusЬ{о&кO'chkinn_statusо&кO'cancel_status&кO%group_chkinn&кOgrpunkidro&кO)grouptranunkidra&кO!agentUnkidra&кO5arrival_airlineUnkid9&кO-arrival_flightNo&кO5arrival_airportunkid&кO%arrival_dateeR&кO3depart_airlineUnkida&кO+depart_flightNou&кO3depart_airportunkido&кO #depart_datee&кO!)transport_dateeK&кO"%baggage_date&кO#%companyUnkidou&кO$auditDatee&кO%auditOni&кO&#total_child&кO'#cancel_datea&кO(cancelbyge&кO)%paytypeunkidss&кO*card_no&кO+'cardvalidtill&кO,#sourceUnkidd&кO-;franchiseConfirmationNot&кO.%bookingUnkid_u&кO/!tranStatus_q&кO0ETAо&кO1ETARemarke&кO2ETDa&кO3ETDRemarks&кO4firstNamea&кO5lastNameЬ{о&кO6addressc&кO7city ™&кO8states&кO9countrys&кO:zip'&кO;phoned&кO<birthDateu&кO=email)&кO>genderrW&кO?#identiUnkide&кO@identiNoЬ{о&кOA#identiStatet&кOA'identiCountry-&кOC!expireDate`еB&кOD'autoLicenseNon&кOE-autoLicenseState_d&кOF#vehicleMakek&кOG%vehicleModel&кOH'vehicle_colorЦ&кOI-vehicleModelYear>ФЦ&кOJ#companyNameК&кOKremarkra&кOL/tranRemarkCheckInD&кOM/tranRemarkInHouseК&кON1tranRemariCheckOutex&кOO/tranRemarkPaymente&кOP/commissionPayDatei&кOQ-commissionAmount'&кOR/allowGuestInvoicen&кOS%otherChargeski&кOT%hourlyRentedd&кOU9hourlyCheckoutDateTimeou&кOVdiscountgr&tќ+respaymentunkidu&tќresunkid&tќ!guestunkid&tќ#amount_paidB&tќ%paytypeunkidЭСs&tќcard_nos&# u!@itemunkid &# u@itemname &# u@purchase &# u@sale&# u@guidcolИ&# u!@ingerence$ $ д А ќ ф№м( Ф є ” ˆH”ЈРм(№ h  Pdx p8 ќш œ Є ш Ш 8@ь Фˆ Œ| 4 \ H (  p tXИ„$ „ 0T X ˆ и t@$мœИШP € X xX”ќФ\РИ 8М p№PT|Дм0œФ@ ј`Имји”И0мШ x`l asiHotel_ASIFD C:\Archivos de programa\Microsoft SQL Server\MSSQL$ASI\Data\asiHotel_ASIFD.mdf BРasiHotel_ASIFD_log C:\Archivos de programa\Microsoft SQL Server\MSSQL$ASI\Data\asiHotel_ASIFD_log.LDF x`Ѓ.Є1В0!B€ 0.!88 їџ Mct_positionr0.!88 іџ Ideptunkidu0.!hh IisDepositC0.!ll ѕџ KlastBillNo0.!ЇЇџўџєџа4MthankYouMsg0.!ЇЇ §џѓџа4Cprefix0.!ЇЇ ќџђџа4YsalesReturnPrefix#жB0.!ll (ёџ asalesReturnLastBillNot0.!ЇЇ2ћџ№џа4OcompliPrefix0.!ll 1яџ WcompliLastBillNo0.!hh Ucashlessprocesse0.!ЇЇ2њџюџа4IkotPrefix0.!ll :эџ QkotLastBillNor0.!88 Cьџ QkotRemoveDays0.Z3і88 Q^depositunkid‚e0.Z3іЇЇdџџџџа4Odeposit_name0.Z3і88 ўџ Mchargeunkid10.Z3іhh  Sdeposit_always0.Z3іhh  Udeposit_reoccurb0.Z3і<< §џ ?rate0.“Wъ88 KXdeptunkid0.“WъЇЇ2џџџџа4Gdeptname0.“WъЏЏўџа4Odeletestatus0.Ь{о 88 KXuserunkjd0.Ь{о ЇЇdџџџџа4Iuser_name0.Ь{о ЇЇdўџўџа4Gpassword0.Ь{о ЏЏ§џа4Sview_daily_repB0.Ь{о ЏЏ ќџа4Wview_monthly_rep0.Ь{о ЏЏ ћџа4Qview_year_repc0.Ь{о ЏЏ њџа4[access_auto_backup0.Ь{о ЏЏ љџа4Qaccess_backupЇ0.Ь{о ЏЏ јџа4Saccess_restore0.Ь{о ЏЏ  їџа4Odeletestatus0.Ь{о ЏЏ  іџа4Uconfig_propertyd40.Ь{о ЏЏ  ѕџа4Minsert_tran00.Ь{о ЏЏ  єџа4Mdelete_tran0.Ь{о ЏЏѓџа4QexpManagement0.Ь{о ЏЏђџа4cblockRoomHistoryReport0.Ь{о ЏЏёџа4YroomHistoryReport.0.Ь{о ЏЏ№џа4eroomWiseGuestWiseReport0.Ь{о ЏЏяџа4cguestStaySummaryReport0.Ь{о ЏЏюџа4arevenueForecastReportom0.Ь{о ЏЏэџа4KundoReportH0.Ь{о ЏЏьџа4QrevenueReportri0.Ь{о ЏЏыџа4[houseKeepingReport0.Ь{о ЏЏъџа4IdnrReport3жB0.Ь{о ЏЏщџа4MgroupReportup0.0)С88 _lingerencestockunkid0.0)С>>5џџ OCurrentStock0.0)С88 ўџ Iitemunkid{о 0.0)С$$§џ EGUIDCOL4жB0.0)С88 $ќџ OtempposUnkidB0.0)СЏЏ(ћџа4=AUDMa0.iMЕ88 Yftemppaymentunjidr0.iMЕ88  OpaymentunkidH0.iMЕ88    OpayReference0.iMЕ88  MreferenceID0.iMЕ<< Mamount_paid{о 0.iMЕ88 џџ Opaytypeunkide0.iMЕЇЇdџџўџа4Ecard_nond0.iMЕЇЇdўў§џа4Wauthorisation_noe0.iMЕ==  Opay_datetimee0.iMЕ88 ( " Iuserunkid0.iMЕ88 , ќџ WpaytranpaymentIDp0.iMЕЇЇ §џ ћџа4QcardValidTillck0.iMЕ$$ 0 њџ EguidcoltB0.iMЕ<<@љџ ]currencyamount_paid0.iMЕ88 Hјџ YexchangeRateunkid0.iMЕ<<Lїџ OexchangeRate0.iMЕhhTƒiоg& QisCCProcessed0.iMЕhhTМвh& [isCCBatchProcessed0.iMЕ88 Uіџ OaccountUnkid0.iMЕЏЏYѕџа4=AUDel0.ЂqЉ 88 KXtranunkid0.ЂqЉ 88  Opaymentunkid0.ЂqЉ 88    Mchkinnunkidar0.ЂqЉ 88  Gtrantypes0.ЂqЉ == Gtrandate0.ЂqЉ $$ Eguidcollo0.ЂqЉ 88 ,џџ Uchargetranunkidd_0.ЂqЉ <<0* UallocatedamountUa0.ЂqЉ 88 8 2 Mpaymentflag0.ЂqЉ 88 < ўџ Kchargeflag0.ЂqЉ 88 @ §џ upaymentbifurcation_paymentunkidex0.ЂqЉ 88 D ќџ KgroupRecIdb0.В "ЇЇd(аG@guidcol0.В "ЇЇ(аG@mSource 0.ы.$$ G@guidColu0.ы.88  Mchkinnunkidto0.ы.ЏЏ(аKchargeDate0.ы.<< OchargeAmountа0.ы.<< ItazAmount0.$S $$ G@guidCol0.$S 88  Mchkinnunkid0.$S ЏЏ(аEpayDate)С0.$S << ?cashcstockun|0д€4а l  Ј D №   P ј Ј T Є P јЄ\ИД<№ H№Ј`Шx №ЈXh Шр4р4дŒ8р”DьЄTДdЌФt(иˆ0мŒ<мlдˆ8ЬHˆ4ш8ш„(ф”HќА`Є.|/Ž"фrENђ 0.Ь{о ЏЏшџа4EnetlockмB0.Ь{о ЏЏчџа4QdirectBilling0.Ь{о ЏЏцџа4=POS0.Ь{о ЏЏ хџа4Mchangerates0.Ь{о ЏЏ!фџа4QchangeFolioNoМB0.Ь{о ЏЏ"уџа4[access_night_audit0.Ь{о ЏЏ#тџа4Qaccess_newday0.Ь{о ЏЏ $ сџа4Uaccess_pastdate0.Ь{о ЏЏ!%!рџа4gaccess_upddel_amountpaid0.Ь{о ЏЏ"&"пџа4yaccess_upddel_amountpaid_pastdate0.Ь{о ЏЏ#'#оџа4iaccess_upddel_othercharge0.Ь{о ЏЏ$($нџа4{access_upddel_othercharge_pastdate0.Ь{о ЏЏ%)%мџа4_access_lockunlockday0.Ь{о ЏЏ&*&лџа4iaccess_upd_businesssource80.Ь{о ЏЏ'+'кџа4Uaccess_undoroom0.Ь{о ЏЏ(,(йџб4Mreduce_stay00.Ь{о 88 )-)иџ [screenSaverWaitForB0.Ь{о 88 *1*зџ Waccess_exempttax0.Ь{о ЏЏ+5+жџа4kaccess_pastdate_roomstatus0.Ь{о ЏЏ,6,еџа4Waccess_deleteRes0.Ь{о ЏЏ-7-дџа4Uaccess_discount0.Ь{о ЏЏ.8.гџа4aaccess_to_cash_drawer0. в 88 IVdnrunkid‚0. в ЇЇdџџџџа4Gdnr_info0.>ФЦ 88 MZemergunkidмB0.>ФЦ ЇЇdџџџџа4Winformation_nameB0.>ФЦ ЇЇdўџўџа4MinformationМA0.wшК 88 [hexchangerateunkid0.wшК 88  Kcountry_ID0.wшК ЇЇdџџџџа4Qcurrency_Nameon0.wшК ЇЇўџўџа4Qcurrency_Sign40.wшК <<   Qexchange_Rate0.wшК hh SisBaseCurrenay0.А Џ 88 KXextnunkid0.А Џ ЇЇ џџџџа4Iextn_name мB0.щ0Ѓ88 S`extntranunkid0.щ0Ѓ88  Iextnunkidƒзu0.щ0Ѓ88    Iroomunkidim0."U—88 O\columnUnkid0."U—ЇЇџџџџа4KcolumnName0.[y‹88 Q^hkgroupunkid0.[y‹ЇЇ2џџџџа4Kgroup_name0.”88 Yfhkgrouptypeunkid0.”ЇЇ2џџџџа4Sgrouptype_name0.ЭСs88 O\identiunkid0.ЭСsЇЇdџџџџа4Midenti_name40.ЭСsЇЇ2ўџўџа4Midenti_maskџа0.цg88 Ubissuemastunkide0.цg==џџ Iissuedate0.л• 88 џџ Mchkinnunkid0.л• == IFrom_date0.л• ==  ETo_date0.л• 88  Qroomrateunkid 0.л• << ?rate0.л• 88 $ ?daysk0.л• $$(ўџ Eguidcollu0.л• 88 8§џ Iroomunkid0.л• 88 < ќџ KgroupRecId0.К‘ 88 MZcallsunkid0.К‘ == Qcalldate_time0.К‘ ЇЇџџџџа4Iextn_name0.К‘ ЇЇ2ўџўџа4Gdialedno0.К‘ ЇЇ§џ§џа4Gduration0.К‘ <<ќџ Echargesnt0.К‘ $$ћџ EeuidcolMi0.К‘ 88 (њџ Uunpostcallunkidsu0.Mо… 88 WdchargetranunkidР‚0.Mо… 88  Mchargeunkidep0.Mо… <<   Qcharge_amounttu0.Mо… <<џџ Ktax_amountr0.Mо… == Ucharge]datetimeцg0.Mо… 88 $ўџ Iroomunkid80.Mо… 88 (§џ Iuserunkid0.Mо… $$,ќџ Eguidcolss0.Mо… 88 < ћџ Sgrouptranunkide0.Mо… ЇЇ џџ њџа4IvoucherNoua0.Mо… == @ љџ Qcalldate_timeid0.Mо… ЇЇ ўџ јџа4Iextn_name0.Mо… ЇЇ2 §џ їџа4Gdialednoi0.Mо… ЇЇќџіџа4Gdurationi0.Mо… <<Hѕџ EchargesGp0.Mо… 88 Pєџ Uunpostcallunkid.P0.Mо… 88 Tѓџ Oposmastunkid0.Mо… hhX Scharge_reoacur0.Mо… 88 Yђџ [unpostserviceunkid0.Mо… hhX Qiscallposting 0.Mо… hhX Sisotherservice0.Mо… ЏЏ]ёџа4=AUD0.Mо… 88 ^№џ cchargeTran_ChargeUnkid0.Mо… 88 bяџ KgroupRecIdt0.†z 88 Ubtempguestunkid0.†z 88 џџ Wchkinnguestunkid0.†z 88  ўџ Mchkinnunkid servicetax0.л• 88 џџЌ\ А\єЈHќ   T  Ј \  И`ќА \  Д h АL ИdДd Ф|4ш”HєЌ`МpЬhА X ќШ€8№ЄPєД\Ј\д”@јЌ\ј Hм„(и€Д8ЬPш<рŒ<ќЈ`Љ ‚jdL#$?UЧU&Ь{о user_name&Ь{о userunkid&Ь{о )view_daily_reptжB&Ь{о -view_monthly_reptжB&Ь{о 'view_year_rep& в dnr_infotжB& в dnrunkid™&>ФЦ !emergunkid&>ФЦ #information&>ФЦ -information_name™&wшК !country_ID&wшК 'currency_Name&wшК 'currency_Sign&wшК 'exchange_Rate&wшК /exchangerateunkid&wшК )isBaseCurrency&А Џ extn_nameB&А Џ extnunkid&щ0Ѓ'extntranunkidB&щ0Ѓextnunkid&щ0Ѓroomunkid&"U—!columnName&"U—#columnUnkid&[y‹!group_name&[y‹%hkgroupunkid&”)grouptype_name ЛB&”-hkgrouptypeunkid ЛB&ЭСs#identi_mask&ЭСs#identi_nameB&ЭСs#identiunkid&цg)issuemastunkidgm&цgissuedates&цg'fromdeptunkid&цg#todeptunkids&цgremarkro&цguserunkid&цgissueNo&? \)issuetranunkidut&? \)issuemastunkidmW&? \itemunkidd&? \quantityer&? \unitunkido&? \realqtyd&x.PitemunkidP&x.Pitemname#&x.Ppurchase &x.Psaless&x.P%deletestatus ЛB&x.Pingerencee&БRD'itemrateunkidl&БRDitemunkid#&БRD#chargeunkid%&БRDitemcodeXЇЫ&БRDratecy&БRDrate1t&БRDrate2Ы&БRDrate3t&БRD rate4a&БRD salestax!&БRD !servicetax#&БRD othertax&БRD /defaultratenumberП&БRDunitunkidk&БRD#seasonunkidi&БRD/salesTaxInclusiveГ&БRD3serviceTaxInclusivem&БRD/otherTaxInclusivem&ъv8'itemtranunkids&ъv8itemunkid1&ъv8deptunkidk&ъv8'maintainstockn&ъv8quantityun&ъv8maxqtyy&ъv8minqtyit&ъv8qtyinhand&ъv8 unitunkidi&ъv8 +SourceUnitUnkid&ъv8 5DestinationUnitUnkidr_&ъv8 -ConversionFactor&#›,para_ido&#›,key_namenP&#›,key_valuee&\П %paytypeunkidfo&\П !payment_byBa&\П /creditCardProcesse&\П +cashlessprocess&•у)privilegeunkidNa&•у'privilegename&•у%deletestatusum&•уdispOrdera&Ю #seasonunkida&Ю #season_namen&Ю from_day&Ю !from_month'&Ю to_days&Ю to_monthit&Ю #eypire_dateo&Ю !start_dateom&,§+posusercatunkidm&,§%posuserunkidas&,§#chargeunkidu&@Pё%posuserunkidpt&@Pёuser_namee&@Pёpasswordre&@Pё%deletestatuski&ytх%posuserunkid&ytх)privilegeunkid&л• #chkinnunkid&л• From_date&л• To_datey&л• %roomrateunkid\&л• ratey&л• daysun&л• guidcolm&л• roomunkidc&л• !groupRecId жB&К‘ !callsunkidus&К‘ 'calldate_timeD&К‘ extn_namei&К‘ dialednoki&К‘ durationun&К‘ chargesm&К‘ guidcola&К‘ +unpostcallunkid&Mо… +chargetranunkid &Mо… #chargeunkide&Mо… 'charge_amountt&Mо… !tax_amountax&Mо… +charge_datetimem&Mо… roomunkidn&Mо… userunkidn&Mо… guidcola&Mо… )grouptranunkid3&Mо… voucherNos&Mо… 'calldate_timen&Mо… extn_namet&Mо… dialedno&Mо… duration&Mо… charges8&Mо… +unpostcallunkid&Mо… %posmastunkidma&Mо… )charge_reoccurъv8&Mо… 1unpostserviceunkidun&Mо… 'iscallpostingt&Mо… )isotherserviceio&Mо… AUDd&Mо… 9chargeTran_ChargeUnkid&Mо… !groupRecIdke&†z )tempguestunkidlu&†z -chkinnguestunkid\П &†z #chkinnunkid &†z !guestunkidoc&†z !first_namess&†z last_namer&†z address&†z phonil&†z city&†z statet&†z zipcodep&†z countrye&†z #identiunkide&†z identi_no&†z %identi_stateom&†z )identi_countryВмB&†z !expir_dateЮ &†z +auto_license_no!&†z 1auto_license_staterc&†z %vehicle_makese&†z 'vehicle_modele&†z 1vehicle_model_year&†z remarkam&†z !birth_date&†z emaile&†z guidcol1&†z -AddEditDelStatus&†z 'oldguestunkid&†z resunkidid&†z 5arrival_airlineUnkid&†z -arrival_flightNoыМЭ&†z 5arrival_airportunkid'&†y !%arrival_date'&†z "3depart_airlineUnkidB&†z #+depart_flightNo&†z $3depart_airportunkidk&†z %#depart_daten&†z &)transport_datedB&†z '%baggage_date&†z (%companyUnkidro&†z )roomunkid&†z *gender$сС&†z +#companyName&†z ,'vehicle_color&†z -%bookingUniidOf&†z .!groupRecIdOf&П&n1tempTaxDetailunkidrl&П&ntaxType+&П&ntaxNamep&П&ntaxRatea&П&ntaxDate&јJb'feedbackunkide&јJbcity]Ж&јJbhotelName&јJbphoneЖ&јJbaddress&јJbguidcola&јJbroomunkidr&1oV'feedbackUnkidn&1oV%serviceUnkidki&1oVfeedback&1oVguidcole&1oVroomunkidename&лh@иАјd8Œа Д ( L  p № Œ И  р ф 0 ` ˆ Ф Є д є \ Д ˜ | 4 є Ь  X єh € 8 `H0шœ Є„\ШФЄќмœМ<`€@ ШєŒLpЌи$Дl<шФШ, № |€0dајH\<,`˜|Дєд˜<ьИмL€X<pPає<ШЬx№hАXИ„$Д0”hЈxрŒИŒ”ќФ\4фЈxP(м ЄPа4„ќЌ„Фр(T”tшМьД$X ,иЌˆdtј8XЌаD$иhєLˆИ4”ќЬ €`~.3ж$ X 0.цg88 ўџ QfromdeptunkidЛB0.цg88 §џ Mtodeptunkid™0.цgЇЇџџџќџа4Cremark0.цg88 ћџ Iuserunkid™0.цgЇЇўџњџа4EissueNo™0.? \88 Ubissuetranunkid0.? \88  SissuemastunkidB0.? \88  џџ Iitemunkid0.? \88 ўџ Gquantity0.? \88 §џ Iunitunkid™0.? \>>5ќџ Erealqty™0.x.P88 KXitemumkid0.x.PЇЇdџџџџа4Gitemname0.x.Phh Gpurchase0.x.Phh ?sale0.x.PЏЏ ўџа4OdeletestatusB0.x.Phh Iingerence0.БRD88 S`itemrateunkid0.БRD88  Iitemunkid0.БRD88    Mchargeunkid0.БRDЇЇ2џџџџа4Gitemcode0.БRD<<ўџ ?rateB0.БRD<<§џ Arate10.БRD<< ќџ Arate20.БRD<<(ћџ Arate30.БRD<< 0 њџ Arate40.БRD<< 8 љџ Gsalestax0.БRD<< @ јџ KservicetaxB0.БRD<< H їџ Gothertax0.БRD88 P іџ Ydefaultratenumber0.БRD88 Tѕџ Iunitunkid0.БRD88 Xєџ Mseasonunkid0.БRDhh\ YsalesTaxInclusive^уt0.БRDhh\ ]serviceTaxInclusive0.БRDhh\ YotherTaxInclusivect0.ъv888 S`itemtranunkid0.ъv888 џџ Iitemunkid.0.ъv888  ўџ Ideptunkid.0.ъv8hh Qmaintainstocke0.ъv8>>5§џ Gquantityt0.ъv8>>5ќџ Cmaxqtyc0.ъv8>>5!ћџ Cminqty0.ъv8>>5)њџ Iqtyinhand0.ъv888 1 љџ Iunitunkid0.ъv888 5 јџ USourceUnitUnkidMM0.ъv888 9 їџ _DestinationUnitUnkid0.ъv8>>5 = іџ WConversionFactorr0.#›,88 GTpara_id0.#›,ЇЇdџџџџа4Gkey_named0.#›,ЇЇњўџўџа4Ikey_valuexI0.'88  MseasonunkIDid0.'==џџ GfromDatep0.'==ўџ CtoDate0.'$$§џ Eguidcol0.N$88 Q^tempposunkid0.N$88  Opostranunkid0.N$88    Oposmastunkid0.N$88  Qitemrateunkid 0.N$88  Iitemunkid 0.N$88 џџ Gquantity0.N$<< ?ratea0.N$<<$ўџ Mdis_percentro0.N$<< , §џ Kdis_amount_0.N$<< 4 ќџ Gsalestax_0.N$<< < ћџ Kservicetaxt0.N$<< D њџ Gothertax_0.N$<< L љџ Ktax_amountt0.N$<<Tјџ Mitem_amountse0.N$$$\ Eguidcol0.N$88 lїџ Iunitunkid0.N$hhp. Oisadjustment0.N$>>5qіџ ErealqtyЇ0.N$88 yѕџ Sitemgroupunkidџ0.N$<<}єџ WitemFixed_amount0.N$hhp. IisNewItem0.‡H88 џџ Kfieldunkidl0.‡HЇЇџџџўџа4SconditionTitle0.‡HЇЇџўџ§џа4SconditionValue0.‡H$$ќџ Eguidcolun0.Рl88  Urespaymentunkidna0.Рl88 џџ Opaytypeunkid0.Рl<<  Mamount_paidki0.Рl==ўџ Opay_datetimeT0.РlЇЇdџџ§џа4Ecard_no 0.РlЇЇdўџќџа4Wauthorisation_nor0.Рl88  IroomunkidsR0.Рl88   Iuserunkidre0.Рl$$ $ ћџ Eguidcolee0.РlЇЇ §џ њџа4QcardValidTillsu0.РlЇЇd ќџ љџа4IreceiptNoid0.Рl88 4 јџ OfileRowCount0.Рl88 8 їџ OaccountUnkida0.Рlhh< QisCCProcessednk0.љї88 Wdrespaymentunkid0.љї88 џџ Opaytypeunkid0.љї<<  Mamount_paidўџ0.љї==ўџ Opay_datetime0.љїЇЇdџџ§џа4Ecard_no0.љїЇЇdўџќџа4Wauthorisation_no0.љї88  Iroomunkid Mseasonu`ФМdЬ|,Шl Д h  и ” L ј Ќ ` t$дˆ4ь TќДdФlЄ D ш ˜ L №Ј\аŒHФ|,р€$а|04фЄ\МфŒ8№ T Мp(м”HјИp$а€0аt(р”@мˆDќЌ”HД`„ …kZP% i'цеѕ7&ytх1userprivilegeunkid&˜йdays&˜йrate_name&˜й'ratetypeunkid&ыМЭ!adultsRate&ыМЭ%childrenRate&ыМЭrate&ыМЭ'rateTypeUnkid&ыМЭ/roomTypeRateUnkid&ыМЭ'roomTypeUnkid&ыМЭ #seasonunkid&ыМЭweekDays &ыМЭweekEnds&$сС /canBeHourlyRented&$сС %deletestatus&$сС hposition&$сС !noOfAdults&$сС %noOfChildrenа&$сС +rateDisplayTypeB&$сС remarkЋѕ?&$сС room_name&$сС 'roomtypeunkid&$сС roomunkid&$сС vposition&]Ж!!adultsRate&]Ж!&childrenRate&]Ж!rate&]Ж!'ratetypeunkid&]Ж!'roomrateunkidB&]Ж!roomunkid&]Ж! #seasonunkid&]Ж!weekdays&]Ж!weekends&–)Њ"remark&–)Њ"roomunkid&ЯMž#'roomtypeunkid&ЯMž#type_nameB&ЯMž#backcolor&ЯMž#!noOfAdultsst&ЯMž#%noOfChildrens&ЯMž##overBooking&ЯMž#+rateDisplayTypeу&r’$)roomownerunkid&r’$lastnameƒз&r’$firstnamee&r’$addressr&r’$city&r’$stateз&r’$zipr&r’$countryn&r’$ phone!&r’$ fax1&r’$ emaild&A–†%1roomownertranunkid1&A–†%roomunkids&A–†%)roomownerunkidƒз&zКz&"seasonunkide&zКz&#season_namea&zКz&from_dayco&zКz&!from_monthco&zКz&to_dayXЇЫ&zКz&to_monthXЇЫ&zКz&#expire_date&zКz&!start_daten&Гоn'%serviceUnkidXЇЫ&Гоn'#serviceNameП&ьc(#statusunkidП&ьc(-room_status_nameN™&ьc(colorr&%'W)!tableunkidit&%'W)tablenamef&%'W)remarkЪяГ&%'W)%deletestatus&^KK*9tempItemIngerenceunkidem&^KK*/tempItemTranunkidS&^KK*1itemIngerenceUnkideU&^KK*+recipeItemunkidn&^KK*3recipeitemtranunkid&^KK*itemunkide&^KK*'itemtranunkid+&^KK*qtym&^KK* unitunkidt&^KK* guidcole&^KK* !isUpdStock"&—o?++tempchargeunkide&—o?+'categoryunkido&—o?+#charge_nameP&—o?+#showtablenoe&—o?+!showwaiterfo&—o?+#showpersonsa&—o?+kot&—o?+deptunkid&—o?+ %olddeptunkid&—o?+ guidcol&—o?+ !lastBillNo&—o?+ #thankYouMsge&—o?+ prefixbe&—o?+/salesReturnPrefix&—o?+7sblesReturnLastBillNot&—o?+%compliPrefixom&—o?+-compliLastBillNoie&—o?++cashlessprocessU&—o?+kotPrefixm&—o?+'kotLastBillNog&—o?+'kotRemoveDaysn&а“3,deptunkido&а“3, -conversionfactorЯMž&ˆŽЄvehunkiden&ˆŽЄvehmakeo&ˆŽЄvehmodelte&С˜+wakeupcallunkidm&С˜"chkinnunkid&С˜!wakeupdatefi&С˜%wakeupremarkes&С˜userunkid’&С˜iscancel&С˜#Cancelledby&С˜updatedby &њжŒ 1wakeupcallansunkidro&њжŒ #chkinnunkid&њжŒ !wakeupdateA–†&њжŒ %wakeupremark&њжŒ )wakeupdate_ans&њжŒ extn_namez&њжŒ %account_code"&њжŒ messagez&4z:#chkinnunkid&4z:!today_dateex&4z:cashzКz&4z:noncashe&4z:directic&mž.!today_daterv&mž.#chkinnunkidt&mž.dayrate-&ІТ" #chkinnunkid&ІТ" !today_date!&ІТ" noncashW&ІТ" casham&ІТ" tote&ІТ" directde&пц!-@masterAccountIDIt&пц!*@strAccountIDs&пц!@statusn& "'@intPOSMastIde& "#@curBalance+& "@statusi&Q/џ"!@todayDateem&Q/џ"#@roomunkidst&Q/џ"@lastDatet&Q/џ"@statusK&ŠSѓ#+@PurchaseBillIdi&ŠSѓ#!@deptunkid^KK&ŠSѓ#@statusk&Уwч$@CurrDater&Уwч$+@intSeasonunkIDy&Уwч$@Statush&ќ›к%@CurrDate#&ќ›л%+@intSeasonunkIDw&ќ›л%@Status#&5РЯ&@grpId—o?&5РЯ&'@strGroupNamen&5РЯ&1@strPersonLastname—o?&5РЯ&3@strPersonFirstnamel&5РЯ&#@straddressu&5РЯ&@strcityix&5РЯ&@StrStatet&5РЯ&#@strCountrya&5РЯ& #@StrZipcodeN&5РЯ& @strPhoner&5РЯ& @strFaxnop&5РЮ& @strEmail?&5РЯ& @dtFromr&5РЯ&@dtto&5РЯ&!@strStatusko&5РЯ&!@strRemark'&5РЯ&@usrIdsB&5РЯ&@guidcoltr&5РЯ&'@intGrptranidr&5РЯ&@dtTodayit&5РЯ&+@strCountryNamei&5РЯ&-@intChargeUpdateа“3&5РЯ&/@intPaymentUpdateq&5РЯ&#@intAgentId&5РЯ&%@intSourceId &5РЯ&"@strFolioNo+&5РЯ&!@ETArrivalа“3&5РЯ&!@ETARemarkni&5РЯ&%@ETDepartureer&5РЯ&!@ETDRemark&5РЯ&+@CommissionDateu&5РЯ& 1@AllowGroupInvoiceru&5РЯ&!)@strCheckinRemki&5РЯ&")@strInhouseRem И'&5РЯ&#+@strCheckoutRemp&5РЯ&$)@strPaymentRemBм&5РЯ&%)@intTranStatus&5РЯ&&1@intDjscountUpdatepr&5РЯ&'+@NewGroupTranIdd&5РЯ&(@statusm&nфУ'@grpIdra&nфУ''@strGroupNamea&nфУ'1@strpersonLastName&nфУ'3@strPersonFirstnamee&nфУ'#@straddressa&nфУ'@strcityon&nфУ'@StrStatem&nфУ'#@strCountrya&nфУ' #@StrZipcode&nфУ' @strPhonek&nфУ' @strFaxnok&nфТ' @strEmaill&nфУ' @dtFrom%&nфУ'@dtToe™&ˆ<€ œ x Р Р № Є  \ єЌЬф @ ј (PT , €  € D ф  Œ D d А м Р М р  P t Є ˜TМЈм€мќt4d8 , ˜˜PTtМЈм8€ємќt4d HМЬxдшHЈДdˆ`<ќ8Ќиœ€рє\<МHќЈШtрД”шH0t”H\аДx(TlDјаЌŒЄ Шь$ˆ<dшШЄ„\4єає ФАhH,иД”l<dŒ@шИи”<`Ј|ќиА€X@є<ШdШ„єЄДќиЬЌ”lЈŒ@|˜d`Р  ’l&ў(4 PС ЈР ”l˜€4ЅЅHС аС  С шџџџ€4getdate,g˜FиСЄPТ ЈС €4getdateFиСЄШТ (Т €488 РТ 8У ˜Т €4 У €4ŽˆxФ  € €ћ@џџœ† 88 @џџд† 88 @џџ ‡ ЇЇа4@џџT‡ ЅЅ@џџœ‡ ЅЅ@џџф‡ 88 ИУ иУ јУ Ф 8Ф XФ lŒhХ  € €ћ@џџЄ‰ 88 @џџм‰ 88 @џџŠ ЇЇа4@џџ\Š ЅЅ@џџЄŠ 88 ШФ шФ Х (Х HХ Ш‘ћD44(“ћˆ  ’ћeчча4ј’ћD44H@’ћD44˜”ћeча4•ћHЅЅU˜•ћHЅЅ—ћD44АS І dn˜јУ  Р Ln˜јУ n˜јУ 44ЅЅUџџџџ44uidstatusnamesidЅrolesџџcreatedateupdatedate altuidpasswordИ›ћˆ 0›ћeчча4ˆ›ћD44HlŒ Ь  € €ћ@џџєm88 @џџ,n88 @џџdnЇЇа4@џџМnЅЅ@џџo88 €Ы  Ы РЫ рЫ Ь lŒщџџџЭ  € €ћ@џџФp88 @џџќp88 @џџ4qЇЇа4@џџ|qЅЅ@џџФq88 pЬ Ь АЬ аЬ №Ь lŒЮ  € €ћ@џџ„s88 @џџМs88 @џџєsЇЇа4@џџDtЅЅ@џџŒt88 `Э €Э  Э РЭ рЭ lŒ№Ю  € €ћ@џџLv88 @џџ„v88 @џџМvЇЇа4@џџ wЅЅ@џџTw88 PЮ pЮ Ю АЮ аЮ lŒрЯ  € €ћ@џџy88 @џџLy88 @џџ„yЇЇ а4@џџдyЅЅ@џџz88 @Я `Я €Я  Я РЯ lŒаа  € €ћ@џџм{88 @џџ|88 @џџL|ЇЇа4@џџЄ|ЅЅ@џџь|88 0а Pа pа а Аа lŒРб  € €ћ@џџЌ~88 @џџф~88 @џџЇЇ а4@џџlЅЅ@џџД88 б @б `б €б  б lŒАв  € €ћ@џџœ 88 @џџl— 88 @џџЄ— ЇЇ а4@џџє— ЅЅ@џџќ› 88 в 0в Pв pв в lŒ г  € €ћ@џџœ 88 @џџд 88 @џџ ž ЇЇа4@џџdž ЅЅ@џџЌž 88 г  г @г `г €г lŒд  € €ћ@џџќ  88 @џџ4Ё 88 @џџlЁ ЇЇа4@џџФЁ ЅЅ@џџ Ђ 88 №г д 0д Pд pд ncsysusers2 @№Aшj˜№б  Р ncsysusers1@ №Aшj˜г  Р €џџ‰ јв Hо јв Hо `џ №п ph0@њ(8јв о ип Р №п 0‚ №8Ч ` Z ј'ў^&(8Р` d(Wž<QE№х’QE№х’ ,-.dbo0[E№х’[E№х’ 223public0[E№х’[E№х’ 012guest 0@[E№х’[E№х’ 667db_owner0@_E№х’_E№х’ BBCdb_accessadmin0@_E№х’_E№х’ FFGdb_securityadmin0@_E№х’_E№х’ <<=db_ddladminy 0@dE№х’dE№х’ HHIdb_backupoperator0@dE№х’dE№х’ @@Adb_datareader0@iE№х’iE№х’ @@Adb_datawriter0@iE№х’iE№х’ HHIdb_denydatareaderb 0 @iE№х’iE№х’ HHIdb_denydatawriter<QE№х’QE№х’ ,HIdboмєм;=уM№”Ш_ыc 0QE№х’QE№х’ ,HIdboмєм;=уM№”Ш_ы шg ˆe 0  0b d 0  H2ІP (d 0  Иr @d Рr  Xd 0  жЅ рt pd 0  Шr ˆd 0  аr  d 0  H2І Јu Иd 0  H2І €5 аd иr шd рr e шr @G e №r  V 0e јr  He s `e s xe s e s Јe  s Рe (s №S иe 0s №e 8s f @s №? f b €b АS 8f 0  0ІРb Pf 0  0Іc hf 0  0І@c €f  Рs 0` ˜f  Шs Аf  аs Шf  иs џџџџрf шs јf 0   аu g 0   јu (g  рs @g  јs UXg Xg pg 0  H2І@K ˆg 0  РK  g 0  0  рc Иg 0  (˜  h 8Шk  g  h  g М%—`[ ы h јљ0ь„Hh ы d Рj €h №c №Œ @h t$—Иh ˜* Ј №h 8h h p$—0€М%—` №ƒ (i рh `i 0А   рZ ˜i p$—М%—0˜i Рœ аi (+ №ќ  R €i 4j  j Hj j 0 o p Xk 0  440€М%—xj 0  чча4ИS  k 0  44@j 0  000€k 0  чча4шj 0  88  ИS Аj 0  44ЌУЄрB l X ˜m mИqча40  аc 0 |l ЈG ЅЅq№m 0  xj {ЎGсzЄ?5@l 0  Аj @ n l №?шl 0  Шk „m шl ˜m јЛ @m 0  рs мm @m l 8јn 0  рs 4n јn Hn шl ј†— n 0  шj 0Œn  n 8l 0   k p$—0Po 0  Шk  €r  r Јr xr *  r  P Рr  r Рr Ps pРъ рr pъ  ъ ащ €щ s 0щ рш ш @ш  s иѓ 8f `ѓ АS `S Шћ @s Ј pR `S hs @P ps `s ˜s  s h №?€s    p†  s Рs 0  hhx ( < рl t$—ш› (› ˜y 0€Аz ш™ Hx  ЬЈ•  ‘ №  { №) №?№?ш €u Xu u 0u Иt t ht @t t ш  {   ‘ ш™ Аz ˜y (› ш› `S S РR pR  R аQ €Q 0Q рP ФЏ—s ˆs €s xs ps АS €]—0  —АS  рP 0Q 8$——€Q аQ  R pR 8РR —S  `S 8x: t$—p$—0  џџд7—>@8$—№?t$—p$—0  џџt$—p$—0  џt$—p$—0  џџt$—p$—0  Рs–ШŸ  рP 88 Рs–ˆš  Аz ==Ž |——0  444иE |——0  чча4џч Є 0` d—0  44|——0  88 88$—Рs–0  Hš  { ==ИŒ Ѓ—0  ==иСЄ0€ Рs–0  HŽ  44€• |——0  88 8p$—0` Ѓ—0  44ЌУЄЃ—0  ==иСЄ0€  ` d p h l ДДФаŒHќМt0ј]R~"|)фyиР0Ru\{џџџ^†tcfNonRentalUnit_mst0RЎ€„|Oџџ^xcfRateCaption0RчЄx}$$ ЏN%џџ^|cfRoomAmenities0RYэ`џџџ^vtcfRoomImage0R.–vЁKH•YLLџџ^zfdnetlock_tran0R х~xeef eнЖfџџ^zfdpayment_tran0RƒзuHпн~~ўо€’Ђ€88 PK_HWInfoЙ O0RXЇЫvHээ4€ЄД€88 PK_cfCountryMasterК O0R‘ЫПwH%€ІЖ€88 PK_cfItemGroup_tranЛ O0RЪяГxH R€žЎ€88 PK_cfItem_GroupМ Oџџ0RЈyH*;!€ІЖ€ll PK_cfItem_IngerenceН O0R<8œzH…!€ЄД€ll PK_cfNewsPaper_mstО O 0Ru\{H Ћ€ЌМ€88 PK_cfNonRentalUnit_mstП O 0R Щl~HM€ЌМ€88 PK_cfRoomAmenities_MstР O 0RYэ`H /€œЌ€88 PK_cfRoomImageС O 0RgСŠwH, € А€88 PK_fdpayble_tran3 ‹60Rй syHњјћљ€œЌ€88 PK_fdphone_dir4 ‹70R.gzHzv€˜Ј€88 PK_fdpos_mst5 ‹80RKR[{Hi|€šЊ88 PK_fdpos_tran6 ‹90R„vO|H->€ЈИ€88 PK_fdposshift_detail7 ‹:0RНšC}H€€œЌ€88 PK_fdquery_mst8 ‹;0RіО7~H#€žЎ€88 PK_fdquery_tran9 ‹<0R/у+H‡€ЈИ€88 PK_fdreceivable_tran: ‹=0R х~xgg $h Тв€88 ­­PK_fdpayment_tran^  М€0RXЇЫv` џџџ иш€ЇЇџа4џџџџџџ88 _WA_Sys_countryName_76CBA758Y0R Щl~` ћџџџJP мь€ЇЇ2а4џџџџџџ88 _WA_Sys_roomAmenities_7E6CC920\0RчЄx}`  $ дф€88 ­­_WA_Sys_roomunkid_7D78A4E7V#B0RчЄx}`€ $ ці€88 ­­_WA_Sys_roomAmenitiesUnkid_7D78A4E7W#B0R х~x`  ўџџџ$ къ€88 ­­_WA_Sys_paytypeunkid_787EE5A0#D~x0R х~x`€ ўџџџ$ иш€88 ­­_WA_Sys_chkinnunkid_787EE5A0€#D0R х~x` ќџџџ"( къ€==­­  _WA_Sys_pay_datetime_787EE5A0#C 0R х~x`€ ќџџџ$ дф€88 $­­_WA_Sys_userunkid_787EE5A0‚#C 0R х~x`  ќџџџ! жц€ЏЏа4 0­­_WA_Sys_authorized_787EE5A0ƒ#D0R х~x`  ќџџџ$ къ€88 F­­_WA_Sys_depositunkid_787EE5A0„#E џџ0R х~x`  љџџџ$ р№€88 A­­_WA_Sys_respaymentunkid_787EE5A0…#D0R х~x`€ іџџџ"( иш€<<­­  _WA_Sys_amount_paid_787EE5A0‘#F0R х~x`  іџџџ$ къ€88 (­­_WA_Sys_accountUnkid_787EE5A0’#F0R.–v` *0 ар€$$ ­­_WA_Sys_guidcol_76969D2E RЙ0R.–v` L#) иш€ll 6­­  _WA_Sys_chkinnunkid_76969D2E R50R.–v` L*0 жц$$­­_WA_Sys_MasterGuid_76969D2E R50R х~x`€ Нџџџ$ фє€88 Z­­_WA_Sys_exchangeRateunkid_787EE5A0нYИTSCHECK_CONSTRAINTSм№`д4А ЄР` шL `x  Фј L \ˆь(@\pˆœаЄœ ь№ ИиTL† ‡fМм*™•Nе\&а“3, 5destinationunitunkid&а“3,guidcol&а“3,'itemtranunkid&а“3,itemunkidB&а“3,'maintainstock&а“3,maxqtyl&а“3,minqtyt&а“3, qtyinhand&а“3,quantityZ™&а“3, +sourceunitunkid?&а“3,/tempitemtranunkid@&а“3, unitunkidB& И'-#charge_name& И'-#chargeunkid& И'-guidcol& И'-%posuserunkid& И'-3tempposusercatunkid@&Bм.guidcol&Bм.%posuserunkid&Bм.'privilegename&Bм.)privilegeunkidусB&Bм.9tempuserprivilegeunkidp&{/!adultsRate&{/%childrenRate№?&{/rateџсB&{/'ratetypeunkid&{/roomunkid&{/#seasonunkid&{/weekdays&{/weekendsюсB&Д$0!adultsRate&Д$0%childrenRate№?&Д$0rate&Д$0'ratetypeunkid&Д$0'roomtypeunkid&Д$0weekdays&Д$0weekends&Д$0#seasonunkid&эHј0'propertyunkids&эHњ0'property_name&эHј0address1co&эHј0address2ro&эHј0city&эHј0state1&эHј0zipcodes&эHј0countryt&эHј0 faxз&эHј0 urlr&эHј0 email&эHј0 res_phon&эHј0 propLogo&&mь1#waiterunkidP&&mь1!waitercodeIP&&mь1!waiternameMA&&mь1%deletestatusCA&_‘р2)agentRateVnkidNa&_‘р2!agentUnkidDa&_‘р2'roomTypeUnkidn&_‘р2rate.@&_‘р2'rateTypeUnkidЫ&˜Ед3%airlineUnkidXЇЫ&˜Ед3#airlineCode&˜Ед3#airlineNameЫ&бйШ4%airportUnkid&бйШ4#airportName& ўМ5#backupunkid& ўМ5todaydateП& ўМ5!BackUpPathnu& ўМ5!backuptypegr& ўМ5'delete_stbtusm& ўМ5userunkide&C"Б6)blockroomunkid_g&C"Б6roomunkidm&C"Б6!block_date&C"Б6reasonnk&|FЅ7+chargeTranUnkid?&|FЅ7%bookingUnkideU&|FЅ7!guestUnkidtr&|FЅ7#chargeUnkidm&|FЅ7'charge_amount&|FЅ7!tax_amountun&|FЅ7voucherNoe&|FЅ7)charge_reoccurun&|FЅ7 +chargf_datetimeu&|FЅ7 userunkida&|FЅ7 )grouptranunkid&Еj™8/BookingPaperunkida&Еj™8%bookingunkid%&Еj™8!paperunkid&Еj™8!no_of_copy#&юŽ93bookingPaymentUnkida&юŽ9%bookingUnkidu\&юŽ9#amount_paid&юŽ9%pay_datetimeun&юŽ9receiptNoe&юŽ9%paytypeunkid&юŽ9cbrd_no&юŽ9'cardValidTill&юŽ9 -authorisation_noчЄx&юŽ9 %accountUnkid'&юŽ9 )grouptranunkidro&юŽ9 auditDated&юŽ9auditOnm&юŽ93currencyamount_paid&юŽ9/exchangeRateunkide&юŽ9%exchangeRateop&юŽ9'isCCProcessedp&юŽ91isCCBatchProcessedY&‹™ˆ,)@intQueryunjid&‹™ˆ,'@strQueryNameј&‹™ˆ,+@strDescriptionn&‹™ˆ,%@bitIsDelete&‹™ˆ,@strGUIDl&ФН|-@ChkinId&ФН|-@GuestId&ФН|-@ChargeIdi&ФН|-!@chargeAmtde&ФН|-@taxAmtr&ФН|-@CdayTimee&ФН|-@usrId&ФН|-@statusk&§сp.@guestidtU&§сp.?@lngNonRentalChargeTranId&§сr.@TranDatee&§сp.@userId&§сp.@guidcol&§сp.@statusC&6e/+@intGroupTranId?&6e/1@strTransactionIds#&6e/-@intTotalTranIdsup&6e/)@strTranStatuseB&6e/#@dtFromDate&6e/@dtToDatee&6e/%@dtTodayDatetu&6e/@statusn&o*Y0+@intGroupTranIdk&o*Y0?@strChebkinTransactionIds_&o*Y0;@intTotalCheckinTranIdsr&o*Y0?@strReserveTransactionIds&o*Y0;@intTotalReserveTranIdse&o*Y09@strBookTransactionIds&o*Y05@intTotalBookTranIdsrN&o*Y0%@dtTodayDatecc&o*Y0 @statusr&ЈNM1!@bookingID&ЈNM1#@curMaxDater&ЈNM1@guidcolЕj™&ЈNN1@newGuestr&ЈNM1)@oldguestunkidnk&ЈNM1'@strFirstNamed&ЈNM1%@strLastName&ЈNM1#@straddresse&ЈNM1 @strPhoneo&ЈNM1 @strcity&ЈNM1 @StrState&ЈNM1 #@StrZipcode&ЈNM1 #@strCountry&ЈNM1@strEmaild&ЈNM1!@bitGenderюŽ&ЈNM1%@dtbirthdateюŽ&ЈNM1/@strIdentityUnkidŽ&ЈNM1)@strIdentityNo &ЈNM1/@StridentityStatet&ЈNM13@stridentityCountry&ЈNM1'@dtexpiredate3&ЈNM1/@strautoLicenseNo&ЈNM15@strautoLicenseStateex&ЈNM1-@strvehicle_makePr&ЈNM1/@strvehicle_modelP&ЈNM1'@vehicleColorn&ЈNM1)@dtvehicleyear'Г&ЈNM1!@strremark'Г&ЈNM1%@intdnrunkid&ЈNM1+@strCompanyNamee&ЈNM1@dtdateinI&ЈNM1 !@dtdateoutасB&ЈNM1!!@strtimeintr&ЈNM1")@strtimecancelmb&ЈNM1#'@introomunkidB&ЈNM1$!@dtresdate&ЈNM1%/@introomrateunkids&ЈNM1&+@inttotalperson&ЈNM1')@intTotalChild+&ЈNM1(@dbratee&ЈNM1)+@dbtransienttax&ЈNN1*@dbtotal&ЈNM1+'@dbamountpaidy&ЈNM1,'@strOccExempt&ЈNM1-+@strStateExempt&ЈNM1.'@intUserunkide&ЈNM1/)@charresstatusTi&ЈNM10/@charchkinnstatus&ЈNM11/@charcancelstatus!&ЈNM12@sourceID &ЈNM13@agentID'Г&ЈNM145@strAddMultipleGuestmC&ЈNM157@arrival_airlineUnkidr&ЈNN16/@arrival_flightNo&ЈNM177@arrival_airportunkidd&ЈNM18'@arrival_date &ЈNM1>'@baggage_date &ЈNM1?'@companyUnkid”pИ€P ДlќдМDpа,\Hd@ мшИ˜ŒLќ˜\ˆр,јмЈlLДИДРь”„Œќd,Фl”р| ,дќЬєАdD$`фмx $ИPpАH рМ œдttT0œ|X8јаЌќXМ8œpDєиd(€ФЄфDЄ|`<„0м\јШœ|\@$ќмĘ` +ž: 6 @@@X@ @@@ @ @ :&мєм;=уM№”Ш_ы6&мєм;=уM№”Ш_ыџџ8 р ац 0р 4с Q•с ŒQ•0р Xс Q•с ŒQ•№?0р |с Q•с ŒQ•t$—0р  с Q•с ŒQ•0р Фс Q•с ŒQ•0р шс Q•с ŒQ•0р  т Q•с ŒQ•0р 0т Q•с ŒQ•0р Tт Q•с ŒQ•0` 0р xт Q•с ŒQ•0р œт Q•с ŒQ•0р Рт Q•с ŒQ•p$—0р фт Q•с ŒQ•0р у Q•с ŒQ•0р ,у Q•с ŒQ•@ 0р Pу Q•с ŒQ•јF 0р tу Q•с ŒQ•0р ˜у Q•с ŒQ•0р Му Q•с ŒQ•0р ру Q•с ŒQ•0р ф Q•с ŒQ•0` 0р (ф Q•с ŒQ•0р Lф Q•с ŒQ•0р pф Q•с ŒQ•0р ”ф Q•с ŒQ•0р Иф Q•с ŒQ•0р мф Q•с ŒQ•0р х Q•с ŒQ•t$—0р $х Q•с ŒQ•0р Hх Q•с ŒQ•0р lх Q•с ŒQ•0р х Q•с ŒQ•0р Дх Q•с ŒQ•0р их Q•с ŒQ•0р ќх Q•с ŒQ•0р  ц Q•с ŒQ•0р Dц Q•с ŒQ•0р hц Q•с ŒQ•0р Œц Q•с ŒQ•0р Ац Q•с ŒQ•t$—((р №џ (ч ј (шр №џ Аz ИŒ Ш˜y Ž Ич №џ t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` РE 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` ЈE 88dЏ—А t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` А E 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` xE 88dЏ—t$—p$—0` t$—p$—0`  t$—p$—0` t$—p$—0` `E 88dЏ—( t$—p$—0` €t$—p$—0` t$—p$—0` €t$—p$—0` ( HE 88dЏ—t$—p$—0` €t$—p$—0` t$—p$—0` €t$—p$—0` 0E 88dЏ—t$—p$—0` €t$—p$—0` t$—p$—0` t$—p$—0` E 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` E 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` шD 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` аD 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` ИD 88dЏ—` t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` `  D 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` ˆD 88dЏ—t$—p$—0` t$—p$—0` t$—p$—0` t$—p$—0` pD 88dЏ—t$—p$—0` •t$—p$—0` *t$—p$—0` t$—p$—0` XD 8јШЎ—№?№?№?№?@D ? X+ t$—p$—0` •t$—p$—0` j7@D џџџџџџџџ0` јјШЎ—№?№?№?№?(? ш? И t$—p$—0` џ?t$—p$—0` jїџџџџџџџџџ0` јРр №џ р №џ t$—p$—0 ˆd –?z?88dЏ—t$—p$—0 t$—p$—0 t$—p$—0 t$—p$—0 pd 8№р №џ AЌH–нн?AЌH–нн?р8п>a?z?AЌH–нн?AЌH–нн?№?AЌH–нн?/†Шщыy?р8п>a?z?AЌH–нн?AЌH–нн?џџџџРИАЈ ˜ˆ€t№l Z ј,^+8 Р`.<9šр-83б0.88 &§џ Mcollationid0.88 *$ Glanguage0.чџџџџ(а?name0.00 Axtype0.00 Cstatus0.44 Ixusertype0.44 Clength0.00  Axprec0.00   Cxscale0.88    Gtdefault0.88   Cdomain0.44   =uid0.44   Greserved0.88  ўџ Mcollationid0.88  ;id0.44 Cnumber0.44  Acolid0.44   Cstatus0.ЅЅ@џџџџ Actext0.88  Cstatus0.44 Cfileid0.яя (а?name0.яя (аGfilename0. 88  ;id0. 44 Egrantee0. 44  Egrantor0. 44   Cactadd0. 44  Cactmod0. ЅЅ џ§џџ Cseladd0. ЅЅ ўџўџ Cselmodџ0. ЅЅ §џ§џ Cupdadd0. ЅЅ  ќџ ќџ Cupdmod0. ЅЅ  ћџ ћџ Crefadd0. ЅЅ  њџ њџ Crefmod0. 44 =uid0. 44 Cstatus0. чџџџџа4?name0. ЅЅUўџўџ =sid0. ЅЅ§џ§џ Aroles0. == Kcreatedate0. == Kupdatedate0. 44 Caltuid0. ЅЅ ќџ ќџ Gpassword0. 88  ;id0. 44 Esmallid0. 00  ?type0. чџџџџа4?name0. bbPўџўџ Avalue0. 88  ;id0. 88  Adepid0. 44   Cnumber0. 44  Idepnumber0.`44 Egroupid0.`44 Mallocpolicy‹ 0.`88  Cstatus0.`чџџџџа4Igroupname0. 44 Cstatus0. 00 Edeptype• 0.88  Econstid0.88  Cfkeyid0.88    Crkeyid0.44 Irkeyindid0.44 Ckeycnt0.ЅЅ џџџџ Eforkeys0.ЅЅ ўџўџ Erefkeys0.44 Eftcatid0.чџџџџа4?name0.44 Cstatus0.ччўџўџа4?path0.88  Etableid0.44 Erowinfo˜ 0.ЅЅ€џџџџ Aftkey0.00 Cstatus0.00 ?type0.44 Gusertype0.ЇЇџ(аGprintfmt0.44 ?prec0.88  Ascale0.88  Kiscomputed0.88  Kisoutparam0.88  Kisnullable0.ч(аIcollationi0.­­   Otdscollation0.44   Gusertype0.hh Gvariable0.hh Kallownulls0.00 ?type0.ЇЇџ(аGprintfmt0.44 ?prec0.00 Ascale0.ч(аIcollation40.44 Gtexttype0.44 Glanguage0.hh Iencrypted0.hh   Kcompressed0.чч@  (а?text0. 44 Edepdbid0. 44 Idepsiteid0. hh   Cselall0. hh   Iresultobj0. hh   Ereadobjf•0.44 Gfkeydbid0.44   Grkeydbid0.44   Afkey1r0.44   Afkey2y0.44   Afkey3e0.44   Afkey4f•0.44 Afkey50.44 Afkey60.44 Afkey7Ѕ0.44 Afkey8f•0.44 Afkey9џџџ (Ÿ l0  ŒШ  ˜€ ЉDј$рHˆ@јИt4ьœXаŒHР|4ьЄ\ЬˆDќЄXШ€Дpќ И t 8 є Д t , № Ј d  Ь ˆ H  Ф „ @ ќИt0ьЈdд˜PЬˆ@єЈ`DМx<ЬˆHРt,фьЄd и”P Р|8ј”HќАd р˜PЬА`Р `’l.r0 `€ м p€ €€ `А/ `/ € Р. p.  .  € €- , @, А€  л @л рт Р€ €ж а- €- а€ рЦ €Ц р^ р€ @L 3 Р2 №€  2 а1 €1  р0 0 @0     0 pŽ @ РŽ шџџџP  Ž ` P @ 0 p  € pŽ  РŽ    Ž       € ‚ РŽ pŽ  ˆЧ АЧ иЧ ‡ а `/ / Р. Р  › Аš pЦ \I—0@X„ ›  › Аš h0  ‚  Р2 ˜2 p2   2 ј1 а1 hF˜0@p‚ 0— Qz' €‚ €‚ 8— Qz' ‚ ‚ @— Qz' Qz' p“ h“ `“ Qz' |Ў—`/ |Ў—p. р‚ а‚ p. `/ А/ @ƒ ƒ №‚ р‚ ›  › `Њ Аš `/ / Р. p. |Ў—`/ Р. @ƒ №:—0@\I—0@ ‡ P.—0@ Ђ—0@А𠐛  › `Њ Аš  Ђ—0@ ›  Ђ—0@› GаKŒ аƒ 0@p. шІ „ p‡  0@H2ІР& 0@Ш’ 0@“ 0@ ‚ XЫ 0@а’ 0@H2Іи’ 0@'  0@H2І@' 0@ш’ ЬЈ•№’ 0@0‚ 0@ј’ 0@H2ІP‚ 0@H2Ір ЬЈ•“ ЬЈ•“ ЬЈ•“ ЬЈ• “ ЬЈ•(“ ЬЈ•0“ ј7 ЬЈ•8“ ЬЈ•@“ ЬЈ•H“ №?ЬЈ•P“ ДЏ—Р‚ А‚ А/ 0@0І№‚ 0@0Іƒ ЬЈ•Р“ 0€ ЬЈ•Ш“ ЬЈ•а“ И' ЬЈ•и“ ЬЈ•ш“ 0@ ƒ 0@0ƒ ЬЈ•р“ ИЫ ј“ X‡ X‡ 0@H2І€' 0@ ƒ  N—0@0@рƒ 0@(`‹ ˆ  РŠ 0€ 0€  ž —0 і №?№?У@0ё0‰ @ˆ ˜Ж     x‰ dЗ јИрˆ 0€ €; P&   гž88 ЅЅ€џџџџџџ €‰    Š јљ”п„Рм„шІ @7 H? а‡ `ƒ 0@№ƒ HЈ ˜@x‹ hГ @Д ˆ‹ pЖ PЗ ˜‹ x‹ PЗ ˆ‹ TЗ Œ XМ%—0@€ƒ h  г |Œ  Ž ˜ Œ М%—0@ƒ ( дŒ шŒ ,k– М%—0@шš ш , @ ,k–јЊ М%—0@ — Ј рЊ а М%—0@Аƒ h м №  Ž ЅЅ!М%—0@X› ( X7 4Ž HŽ ИМ%—0@Р— ш 0€ œŽ Q•М%—0@Рƒ Ј 0€ фŽ јŽ ш ŒQ•0€ М%—0@Ш› h ŒQ•< P 0€ P М%—0@р— ( Q•ш ŒQ•М%—0@И‡ ( t$— —ј“     ( t$—0 p$—8 @ H P X ` t$—h p$—p x € ˆ  ˜ t$—  p$—Ј А И Р Ш а и р ш № ј Ј% ‘ ‘ 8ј‘ ‘  ‘ (‘ 0‘ №?8‘ №?@‘ ˆУ@H‘ P‘ р X‘ `‘ h‘ p‘ 0€ x‘ €‘ ˆ‘ ‘ ˜‘  ‘ Ј‘ 0€ А‘ И‘ Р‘ Ш‘ а‘ и‘ % р‘ ш‘ №‘ џџџџј‘ ’  ’ јј’ ’  ’ (’ 0’ №?8’ №?@’ ˆУ@H’ P’ р X’ `’ h’ p’ 0€ x’ €’ ˆ’ рЮ  ’ Ј’ ’ ˜’ 0€ Р’ а’ Р’ 8Œ А’ а’ % р’ H №’ џџџџа’ pf ј №Ÿ 0€ Q•ŒQ•P“ И„P† А/ p. 0€ `/ Q•p“ ŒQ•x“  “ ˜“ Ј“ И„№?А/ 0€ Q•ŒQ•р“ И„0€ ј“  › И’ 0€ ”  • — ŒQ•0€ (” Q•И„ŒQ•0€  ” 0€ L” Q•И„ŒQ•0€ @” 0€ p” Q•И„ŒQ•`” 0€ ”” Q•И„ŒQ•€” 0€ И” Q•И„ ” 0€ 0€ м” Q•Р” ŒQ•0€ 0€ • р” И„ŒQ•0€ 0€ • Q•И„ŒQ•0€  • H• Q•И„ŒQ•0€ @• 0€ l• Q•И„ŒQ• :—`• 0€ • Q•И„ŒQ•€• 0€ Д• Q•И„ŒQ• • 0€ и• Q•И„Р• 0€ ќ• Q•р• ŒQ•0€  – – И„ŒQ•0€  – Q•И„ŒQ•@– h– Q•И„ŒQ•`– 0€ Œ– Q•И„ŒQ•€– €– 0€ А– Q•И„ŒQ• – 0€ д– Q•И„ŒQ•Р– 0€ ј– Q•И„р– 0€ — Q•— `/ / Р. p. 0€ @— А/ `/ / Р. p. А/ Ь:—0@`ƒ |˜—0@ЇЇа4иЊ |˜—0@88 ЈЉ |˜—0@88 №Ј ˜ 8H˜ ˜ Q•И„ŒQ•0€ <˜ Q•И„ŒQ•˜ 0€ `˜ Q•И„ŒQ•0€ t$—p$—0@€t$—p$—0@t$—p$—0@Jt$—p$—0@Ъt$—p$—0@Ъt$—p$—0@Jt$—p$—0@t$—p$—0@Ъt$—p$—0@Jt$—p$—0@JРs–pn @Ћ  › ча4Й d—0@ча4Рs–Њ  › 44РИ d—0@44Рs–XЉ  44€И d—0@44  € „ ” 0 ( ˜ $ Ь , Œ 4 а 8  Р ˆ < ` Z`ј/r^.0 8Р`€ `z„0v0 !PRIMARY Аo М%—0@XХ Ј Р5 ˜Ю Ав р6 д 8 8Œ ˆd а М%—0@@! ( `5 рЮ @в @7 ,!   ! 0€ ˆ 0r—0@А/ (‡ ‡ €Х  D, М%—0@ + ( `/ м! №!  " Р. М%—0@‚ Ј 4" Ј 8Œ 0" М%—0@ + ( Œ" №!  " @7 Qz' М%—0@p‚ 0 0€ |Ў— . М%—0@ + p / <# P#  " а- €- М%—0@3 0 p' ”# Ј# 0€ Р. / М%—0@pƒ ^ь# Ј 8Œ @л ЈE$ @@& 0€ P6 0€ 0І@6 0€ 06 ш$ , АЫ @л 06 0€ 0І@$ Р. / `/ 0J 0€ ˆ$ , @, €$  „ 0€ И$ % 0€ 6 Р$ 0€ 86 0€ €2 0€ % 0€ Р2 0€ ˜6 0€ @% Ј6 0€ H2Іp" ЬЈ•А6 €% И6 ДЏ—и6 а6 А/ ЬЈ•Р% ЬЈ• 7 јu ЬЈ•(7 w hH—& Р" ‡ @' 0€ 0Ір" ЬЈ•`7 шЦ РЦ ˜Ц pЦ HЦ  Ц јХ аХ ЈХ Р7 ЬЈ•Ч 8Ч `Ч 0 @0 h0 0 И0 р0 и7 ЬЈ•Р& ш7 0€ ЬЈ•07 ЬЈ•87 H2  2 ј1 а1 Ј1 €1 X1 01 1 3 0€ и3 А3 ˆ3 `3 83 №7 ˆ' ˆ' 0€ А/ `/ / Р. p. р# 0€ (`+ ( 0р* ( ( @( 8( p( X(  ( @( М%—0€ ˜) H шЪ а( Р ,) №) ) М%—0€ И8  †  у P 0) р( `) 0r—0€ ) Xd @d $ ‡ (d PР) 0€ ! h † @4  №) XЌ 4* @) P+ а4М%— * иe и- шЪ P* Р* Œ* Ј+ 00М%—0€ иe €* X  * А* @К„lЗ„№ 8№ЊЈE€ H Xœ ЈЎ—0@№# ЈЎ—0@ЈЎ—0@tG—0@ D(‡ ‡ ‘. А/ ,:—0@ D0@Pƒ , P .  а XK, 4444x, @, и- K€- 88 88 , Р* @dѓ0€ ИЎ—t$—р, Р*  @ћѓр, p$—0€ 0- ИJа- ЅЅ€ЅЅ€џџp. €-  J . 4444p. h, а- ˆJp. 88 88 p. ,k–  ­ Р. ча4ча4џџА/ @И ,k– X­ / 88 88 А/ И ШЈ•,k– / ­ `/ 4444А/ РЗ p$—,k–аЌ А/ 4444А/ €З œm–Ќ  Аš ЅЅ DЅЅџ@З 0 (Х Аš `/ ˜5  / Р. p. А/ А/  p. Р. 0€ / `/  Аš   › › ЈLА/ Аš  › (У › ФЏ—˜“ “ ˆ“ €“ x“ А/ €]—0@яА/  p. А  Р. / `/ 4 `5 4 4  4 (4 04 @4 H4  P4 X4 №8 `4 h4 0! p4 x4 PЏ—€4  „ ˆ4 4 @4  4 Ј4  А4 И4 `9 Р4 Ш4 `! а4 и4 PЏ—р4 ш4 №4  4 5 5 5 5 ˜9  5 (5 0! 05 85 PЏ—@5 H5 P5 (Џ—(  %€˜ + PЏ—(Џ—Ј №˜ + PЏ—(Џ—( + PЏ—(Џ—( Ș @+ PЏ—(Џ—Ј №˜ @+ PЏ—(Џ—( а™ p+ PЏ—ЄЏ—X“ 8† 0@ ‚ 0@‚ 0@€‚ 8 €€; t$—p$—0€  8 t$—p$—0€ @8 p$—0€ €8 €— 8  „ Аo Р8 t$—p$—0€ €8 9 t'—Рj ˜  4  9 џџя @9 p$—0€ 9 t$—€9 0€  9 t$—p$—0€ Р9 €9 €—0€ :  „ Аo  : Рj р Р5 џџџџџџя@: t$—: 0€ €: t'—Рj (  : џџџџџџяh Р: t$—p$—0€ €: ; Рj p €6 џџџџџџя ; t'—;  . а- €- p. p$—0€ Ь:—0€ Р# ˜D—0€  „ Ь:—0€ Р# < И и= 8    0  Р ,   Ф а   (  h< 8$—p$—0@8$—p$—0@8$—p$—0@ = 8$—p$—0@8$—p$—0@8$—p$—0@ИЎ—t$—p$—0@Jt$—p$—0@t$—p$—0@ИЎ—t$—p$—0@€t$—p$—0@t$—p$—0@`™R˜#6и1б Ё@0Ra Dџџџ^€tfdEmployeeMaster0RЗіУI(џџ^tfdImageInfo0R˜Ед3Hh€ЄД€88 PK_fdAirlineMasterѕ @0RбйШ4HM€ЄД€88 PK_fdAirportMasterі @0R ўМ5HснПо€–І€88 PK_fdBackupї @ a0RC"Б6H?=\‹м§џџ>€ А€88 PK_fdBlock_roomsј @!0R|FЅ7H5b€ЎО€88 PK_fdBookingCharge_Tranљ @"^0RЕj™8H#4!€ЌМ€ll PK_fdBookingPaper_infoњ @#0RюŽ9HQ €АР€88 PK_fdBookingPayment_Tranћ @$0R'Г:Hџ€МЬ€88 PK_fdCCTran_ASIPaymentGateway2ќ @%0R`зu;H _€Юо€88 PK_fdCCTrans_ASIPaymentGateway2_Receive§ ‹b0R™ћi<H _€Ши€88 PK_fdCCTrans_ASIPaymentGateway2_Sendў ‹0Rв^=H+Л€ЂВ€88 PK_fdCCTrans_Infoџ ‹0R DR>H*€ЄД€88 PK_fdCompanyMaster ‹0RDhF?H,=€ВТ€88 PK_fdDBPaymentBifurcation ‹0R}Œ:@H[n€ЈИ€88 PK_fdDailyAttendance ‹0RЖА.AH*€ЎО€88 PK_fdDepartmentEmployee ‹0Rяд"BH €€ЊК€88 PK_fdDepartmentMaster ‹e0R(љCH N€ЌМ€88 PK_fdDesignationMaster ‹0Ra DH@2€ІЖ€88 PK_fdEmployeeMaster ‹ 0RšAџDH)€ЈИ€88 PK_fdExpenseTran_map ‹ 0RгeѓEH(€ЂВ€88 PK_fdExpense_tran ‹ 0R ŠчFH#4!€ЈИ€ll PK_fdGuestPaper_info ‹ 0REЎлGHќњ Nћ€ЌМ€88 PK_fdGuestSourceMaster ‹ 0R~вЯHHA№!€ЂВ€ll PK_fdIDTypeDetail ‹s0R№ИJHaА€ВТ€88 PK_fdNonRentalPaymentTran ‹ 0R)?ЌKH@m€МЬ€88 PK_fdNonrentalOtherChargesTran ‹0Rbc LHM•€ЈИ€88 PK_fdPOSpurchase_mst ‹0R›‡”MH8J€ЊК€88 PK_fdPOSpurchase_tran ‹ 0RдЋˆNHki(У9j€ЎО€88 PK_fdPaymentBifurcation ‹0RC"Б6`  м§џџ$ жц€== 88  _WA_Sys_block_date_36B12243c# 0RC"Б6`  §џџџ žв88 88 _WA_Sys_roomunkid_36B12243d0RC"Б6`  м§џџ  дф€88 88 _WA_Sys_roomunkid_36B12243d#D0RдЋˆN`€ §џџџ žж88 $88 _WA_Sys_chkinnunkid_4E88ABD40RдЋˆN`€ §џџџ  иш€88 $88 _WA_Sys_chkinnunkid_4E88ABD4}#E0RдЋˆN`€ §џџџ žи88 88 _WA_Sys_paymentunkid_4E88ABD40RдЋˆN`€ §џџџ  къ€88 88 _WA_Sys_paymentunkid_4E88ABD4‡#E r0RдЋˆN`€ Зџџџ žа88  88 _WA_Sys_tranType_4E88ABD40RдЋˆN`€ Зџџџ  вт€88  88 _WA_Sys_tranType_4E88ABD4KJŽ9€ЎО88 PK_fdPaymentBifurcation ‹0RC"Б6`  §џџџ$žд== 88  _WA_Sys_block_date_36B12243estPaper_info ‹ fdCCTrans_Infoџ ‹<<М<И``````````````  є8x@„Ь<рˆЬ`Ј`№ 4 x И < ˆ дќPдМdМT h‘* Д2{жb?&юŽ9 userunkidB&'Г:address&'Г:+allowDuplicates&'Г:amountc&'Г: !cardNumber&'Г:#cardPresent&'Г:!chargeTypeМB&'Г:#checkInTime&'Г:%checkOutTimeQ&'Г:cityn&'Г:clientID&'Г:country&'Г:email&'Г:%errMsgBМB&'Г: expMonth&'Г: expYearB&'Г:firstName&'Г: key&'Г:lastNameCМB&'Г:!moduleNameа4&'Г:"'nonRoomCharge&'Г:#noShow&'Г:passworda&'Г:priceID&'Г:$1processTransaction&'Г: !roomAmounte&'Г:!roomNumber&'Г:!roomRateu&'Г:"sendGateID&'Г:!serverNamel&'Г:siteIDа&'Г:state&'Г:%stayDurationc&'Г:trackData&'Г:tranIDn&'Г:tranTimeQ&'Г: tranTypel&'Г:zip&'Г:&approved&'Г:'gateID&'Г:(authCode&'Г:)#declineCodei&`зu;tranIDti&`зu;?tranID_ASIPaymentGatewaz2p&`зu;recvDataat&™ћi<tranIDmp&™ћi<?tranID_ASIPaymentGateway2&™ћi<sendData&в^=%cctransunkidHW&в^=transtypeP&в^=deskclerk!&в^=recno&в^=ccnodd&в^=ccexpdateA&в^=amount!&в^=zipe&в^= addressr&в^= issucess-&в^= #tran_result&в^= #tran_rource&в^= tran_filek&в^=%filerowcount&в^=tran_datei&в^=#chkinnunkidt&в^='approval_codeo&в^=!guestunkidon&в^=%paytypeunkidd&в^=rawStringt& DR>%accountUnkidem& DR>#accountName& DR>address1%& DR>address2ЪяГ& DR>cityro& DR>statet& DR>zipd& DR>countryt& DR> phoned& DR> faxs& DR> emailЈ& DR> #creditLimitU& DR> balancet& DR>%activeStatusit& DR>%deleteStatusЈ& DR>firstNamer& DR>lastNamere& DR>!agentUnkid& DR>)openingBalancele& DR>rfcNumber!& DR>#rfcAddress1!& DR>#rfcAddress2& DR>rfcCity& DR>rfcStateio& DR>rfcZipte& DR>!rfcCountryre& DR>!creditDaysck&DhF?tranUnkidi&DhF?7nonrentalpaymentunkid&DhF?tranType&DhF?tranDate&DhF?-paymenttranunkidtr&DhF?+allocatedAmounta&DhF?#chkinnunkida&DhF?+chargetranunkide&}Œ:@-dailyAttendUnkidd&}Œ:@'employeeUnkid&}Œ:@+departmentUnkidk&}Œ:@payRatem&}Œ:@payTypeo&}Œ:@statusC&}Œ:@ miscPayi&}Œ:@ remarkov&}Œ:@ dailyPayID&}Œ:@insertAtde&Љ”т9%@dttodaydatee&Љ”т9'@introomunkid?&Љ”т9@statusm&тИж:%@chkinnunkidre&тИж:@resunkidr&тИж:'@bookingUnkidA&тИж:@guidcolay&тИж:@flagd&тИж:!@groupFlagan&нЪ;5@strUpdMultipleGuest&нЪ;5@strDelMultipleGuest&нЪ;@guidcolcc&нЪ;@flag&нЪ;!@groupFlagzi&TП<@guidcols4&%Г=@resunkidB&%Г=!@chkinDatet&%Г=!@roomunkide&ЦIЇ>#@moduleName^&ЦIЇ>/@terminalDateTime&ЦIЇ>'@computerNamei&ЦIЇ>@HDDModelp&ЦIЇ>!@HDDSerial!&ЦIЇ>%@HDDFirmWarepa&ЦIЇ>%@MACAddress1ra&ЦIЇ>%@MACAddress2un&ЦIЇ> #@IPAddress1o&ЦIЇ> #@IPAddress2r&ЦIЇ> @statusd&џm›?)@fromdeptunkid DR&џm›?%@todeptunkidp&џm›?@guidcol DR phone& DR> fax& DR> email& DR> "creditLimit& DR> balanceB& DR>%activeStatus& DR>%deleteStatus& DR>firstNameB& DR>lastName& DR>!agentUnkide& DR>)openingBalanceа4& DR>rfcNumberB& DR>#rfcAddress1& DR>#rfcAddress2& DR>rfcCity& DR>rfcState& DR>rfcZip& DR>!rfcCountryu& DR>!creditDays&DhF?tranUnkid&DhF?7nonrentalpaymentunkid&DhF?tranTypee&DhF?tranDatee&DhF?-paymenttranunkid&DhF?+allocatedAmount&DhF?#chkinnunkid&DhF?+chargetranunkid&}Œ:@-dailyAttendUnkidu&}Œ:@'employeeUnkidB&}Œ:@+departmentUnkid&}Œ:@#workingFate&}Œ:@%workingHours@&}Œ:@payRateB&}Œ:@payType&}Œ:@statuse&}Œ:@ miscPay&}Œ:@ remark&}Œ:@ dailyPay&}Œ:@ userUnkid&}Œ:@ timeIn &}Œ:@timeOut&}Œ:@insertAt&}Œ:@updateAtt&ЖА.A'deptEmplUnkidB&ЖА.A'employeeUnkid&ЖА.A+departmentUnkid&ЖА.ArbteOfPay&ЖА.ApayType&яд"B+departmentunkid&яд"Bnames&яд"Bstatus7&(љC-designationUnkid&(љCnames&(љCstatus&a D'employeeUnkid&a DemplNoc&a Dfirstname&a DlastnameR&a DssNumber[МB&a DbirthdateB&a Daddress&a Dcity&a D state&a D country&a D zip&a D homePhone&a D emailId&a DisMarried&a D'totDependents&a D'extraWithHold&a DhireDate&a D-designationUnkid&a DpayType&a DpayRateB&a D)leavesPerMonth8&a D!layOffDate жB&a D%layOffReason жB&a DreHired&a Dstatus&a DuserUnkid&Љ”т9%@dttodaydate Д &Љ”т9'@introomunkid &Љ”т9@status&тИж:%@chkinnunkid(&тИж:@resu„МhL јј иШ l”@„ м ќ  Є x œ L Ш$ЄДŒм@ dјш а | < ф Р œ  P ь 0 D Ф \ ` ќ И € , ˜ x œ , T €<\tШшФ T фЄР,шt  8˜Xˆ@$€PˆРјрФЈЌє,„ЬєдИ˜pX<єдАŒX<иД”€H`D$№„дДœtP,фd(Шœ€h@`Ѓ&” 3J5;=>*ОeHЊо Ћпц!ЌaV/8ИQ/џ"ЙQ/џ"КQ/џ"ЛQ/џ"МУwч$Нќ›л%О5РЯ&П5РЯ&Р5РЯ&СnфУ'ТnфУ'УnфУ'ФnфУ'ХnфУ' ЦnфУ' ЧnфУ' ШnфУ'ЩnфУ'ЪnфУ'ЫnфУ'ЬЇИ(ЭЇИ(ЮЇИ(ЯЇИ(а4ЇИ( бЇИ( вQ *гRu”+дRu”+еRu”+жRu”+зRu”+ рRu”+ сRu”+тФН|-уo*Y0фЈNM1хЈNM1цсrA2ч—53јSЛ)4љŒп5њŒп5ћŒп5ќХ6§Х6ўХ6џ7Lњ77Lњ77Lњ7тИж:Eчџ;тИж:тИж:тИж:тИж:  У ;!нЪ;"нЪ;#нЪ;$8’@%ЊкwB&уўkC'UGTE(Иu}F)UGTE*UGTE+œNJ,9и$I-rќJ.rќJ/rќJ0rќJ1rќJ 2rќJ 3е*BK4Ћ K5Ћ K6Ћ K7Ћ K8Ћ K 9зЖl\:+ћP;•ЫT<ѓ%œX=en„Z>иќe?ѕ^PX_QЛG=`RX_S‚#I_T‘=`U‘=`V†№aW<ЊфbXuЮиcYŸи dZ!іe[чСe\JEъf] ;Еf^ ;Еf_ ;ЕfhƒiоgiY_ЉgjY_ЉgkЫЇ‘il.жКjmЫЇ‘inЫЇ‘ioЫЇ‘ipЫЇ‘i qйB—mrgњЎks“Щ2qt>6tuщЂыvvщЂыvwщЂыvxщЂыvy"Чпwz"Чпw{Э3Мz|Э3Мz}Э3Мz~Э3МzЭ3Мz ˆЭ3Мz ‰Э3Мz ŠЭ3Мz‹Э3МzŒЭ3МzЭ3МzŽЭ3МzXА{˜XА{™XА{šXА{›?|Є|œ?|Є|x ˜}žБФŒ~Ÿ!А# uБ•U]ВžEГžEДžEЕ@Т9Жyц-Зyц-Рyц-Сyц-ТВ "У88 ИW#јЉ'ˆЊ'œ88 фЊ'88 Ћ'ИW#АЊ'иЊ'88 <Ћ'88 XЋ' bXЉ'І44Ћ'`Ћ'”Ћ'І88 0Ћ'ˆЋ'H[І88 АЋ'F44ИЦЄ Џ'(Ќ'(Ќ'{ pЌ'ЈЌ'иЋ'€4чча4˜Ќ'indexdelччvа4аЌ'v(convert(smallint,(([base_schema_ver] & ((~15))) / 65536)))refdatedatetime==datetimep­'`џ€4crdate(0== џџ @Ў'crdate'88 xЎ'p­'І==Ў'€Ў'І==PЎ'ЈЎ'І88 аЎ'F==ИЦЄИБ'HЏ'{ Џ'ШЏ'јЎ'€4(чча4ИЏ'refdateчч8а4№Џ'8(convert(datetime,[crdate]))versionint0`'88 int#@А'%€488 рА'єА'88 Б'@А'hА'І88 ИА'Б'0Б'І88 шА'@Б'І88 џџџџhБ'F88 ИЦЄ`Й'рБ'ЬЈ•{ (В'`В'Б'(u€40 (Јuчча4PВ'versionчч а4ˆВ' (convert(int,0))deltrigint88 intРВ'€4xЖ']88 xtype(0 ЏЏа4џџ АГ'xtype0 (U9ЇЇа4№Г'U2І:pГ'ШГ'фhh (SЇЇа4PД'S˜Д'(Д'hh XД'Јm*‰ (0 ЏЏа4џџ иД'xtypeObjectPropertyid(088 џџPЕ'idЕ'р№ІTableDeleteTrigger— ђЇЇа4аЕ'TableDeleteTriggerЈЕ'XЕ'ІЕ'hm*F88 ИгЄ€Д'ˆ  8Ж'И'І Ж'PЖ'Іxtype(0 ЏЏа4џџ №Ж'xtypeTRЇЇа40З'TRАЖ'З'рlhhparent_obj(088 џџИЗ'parent_obj8З'ˆ аЗ'hИ'ІxЗ'шЗ'І88 `И'hИ'8И'pўІџ88 ИИ'РВ'І88 8Г'РИ'І88 И'шИ'І88 Й'F88 ИЦЄР@ˆЙ'{ аЙ'К'8Й'€4ьчча4јЙ'deltrigчч>а40К'>(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableDeleteTrigger')) when ([xtype] = 'TR') then [parent_obj] else 0 end))instrigint K#88 intˆЛ'€4@П'hh]88 xtype(0 ЏЏа4џџ xМ'xtypeUЧ' ђЇЇа4ИМ'U 8М'М'hh —SЇЇа4Н'S`Н'№М'hh Н'0n*‰  (0 ЏЏа4џџ  Н'xtype'ObjectPropertyid(088 џџО'idиН'рlІb(TableInsertTrigger nЇЇа4˜О'TableInsertTriggerpО' О'Ф Д Є ” „ t d T D 4 $   єфдФДЄ”„tdTD4$єЄфдФД”d„t$TD4DєфдФtДЄ”„dTє4$”фдФДЄ„tdTD4$ЄфєдФДЄ”„tdTD4$дєфдФДЄ”„tdTD4$єфдФДЄ”„tdTD4$єфдФДЄ”„tdTD4$єфФД„ t d T D 4 $   є ф д ”„t` Zј4Ы^35;=>ЊЋЌ8€—јьJР`; Ў ”5О'0 O([base_schema_ver] & ((~15)))0 E([base_schema_ver] & 15)40Ы(convert(char(2),case when (([xtype] = 'UQ' or [xtype] = 'PK')) then 'K' else [xtype] end))0Й(convert(smallint,case when (([xtype] = 'S' or [xtype] = 'U')) then 1 else 0 end))0(convert(smallint,(case [xtype] when 'S' then 1 when 'V' then 2 when 'U' then 3 when 'P' then 4 when 'RF' then 4 when 'X' then 4 when 'L' then 5 when 'D' then 6 when 'R' then 7 when 'TR' then 8 when 'PK' then 9 when 'UQ' then 9 when 'C' then 10 when 'F' then 11 when 'AP' then 13 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 1 <> 0) then 16 else 0 end + case when ([status] & 2 <> 0) then 32 else 0 end + 64 + case when (substring([name],1,1) = '#') then 256 else 0 end + case when ([status] & 0x01000000 <> 0) then 512 else 0 end + case when ([status] & 0x200000 <> 0) then 1024 else 0 end + case when ([status] & 0x04000000 <> 0) then 2048 else 0 end + case when ([status] & 4 <> 0) then 8192 else 0 end + case when (substring([name],1,2) = '##') then (-32768) else 0 end) else 0 end)))0‹(convert(smallint,(([base_schema_ver] & ((~15))) / 65536)))0M(convert(datetime,[crdate]))05(convert(int,0))0S(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableDeleteTrigger')) when ([xtype] = 'TR') then [parent_obj] else 0 end))0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableInsertTrigger')) else 0 end))0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableUpdateTrigger')) else 0 end))05(convert(int,0))0}(convert(int,(case when ([status] & 0x80000000 <> 0) then 2 else 0 end + case when ([replinfo] & 1 <> 0) then 32 else 0 end + case when ([replinfo] & 2 <> 0) then 64 else 0 end + case when ([replinfo] & 4 <> 0) then 256 else 0 end + case when ([xtype] = 'P' and ([status] & 2 <> 0)) then 16 else 0 end + case when ([xtype] = 'D' and ([parent_obj] <> 0)) then 2048 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 0x20 <> 0) then 1 else 0 end + case when ([status] & 0x0400 <> 0) then 4 else 0 end + case when ([status] & 0x0800 <> 0) then 8 else 0 end + case when ([status] & 0x1000 <> 0) then 128 else 0 end + case when ([status] & 0x0100 <> 0) then 512 else 0 end + case when ([status] & 0x0200 <> 0) then 1024 else 0 end + case when ([status] & 0x2000 <> 0) then 2048 else 0 end + case when ([status] & 0x4000 <> 0) then 4096 else 0 end + case when ([status] & 0x10 <> 0) then 16384 else 0 end) else 0 end)))0?(convert(smallint,0))0!(8000)80Н(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)а40Г(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or (type_name([xtype]) = 'char' or type_name([xtype]) = 'binary')) and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))0(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))0(convert(smallint,columnproperty([id],[name],'oldusertype')))0W(convert(varchar(255),[autoval]))0ћ(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))0O(odbcscale([xtype],[xscale]))0](convert(int,sign(([colstat] & 4))))0](convert(int,sign(([colstat] & 4))))˜a(ЬЈ•]88 status4д„ˆ0 \œx8И € | x $ ь œ  €ФјА`" А 6š† AшF8­dяЪ]Q/џ"АzКz&Уwч$БЛl5РЯ&Дл• ЇИ(ЖИDѓьwdQ/џ"EюŽ9БнN Ff{ѕnuЮиcGж7Г_"Чпw+€ћUF=№yk›‡”MŠSѓ#‚ж7Г_XА{6ƒїЭrќJ„мл2XА{… х~xXА{†dяЪ]vnl‡œЭ)VnфУ'ИкOyц-OЙкO ;ЕfК C)rowcntsJмБ88 PC)џџџиB)Рx*„hhџџя88 ЈC)џџџXC)5—ˆ џџяАC)ШE)І€C)ШC)Іintа488 int) D)e€4шD)rowcnt(0 ,џџ шD)rowcntІ88 E) D)рD)І88 ЈD)(E)88ІјD)PE)0E)І88 xE)F88 ИЦЄ E)€E)ІF){ `F)F) B)аE)€4ˆ F)чча4ˆF)rows88ччЈа4ИF)Ј(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)G)чча4ˆG)sysindexesˆ €u'јH)р›*h@њ)иД `@u'  (XH)иџџџџІHH)88  H)аH)I)І€H)шH)8ˆ I)`I)ИH)шG)Жџџџџџџџџџџџџ(0 syscolumnsstatustinyint(I)00tinyintXI)`I)€4bitposИ(000 џџ (J)bitposJ)88 `J)@}*8J)œ88 J)@L)e]88 typestat88(000 џџK)typestatp$—88 HK)€}* K)t$—œ88 00 K)PK)Ј}*hh88 јK)ЈK)Dˆ hL)L)˜L)ІаK)L)88Іs88 L)hL)ІhJ)J) Š88 R)]88 typestatЇЇ(000 џџhM)typestat88  M)x~*xM)œ88 00јM)ЈM) ~* †hhtype_namextypePN)e(000џџ N)xtypeІPN)І*Fчча4ќзЄtextЇЇа4(O)text O)ШN)@*hhhh imageЇЇа4O)imagepиO)№~*hh ˜O)~*PK‰ (P)Ш~*Fчча4ќзЄe(000џџ @P)xtypecolstatP)(044 џџ P)colstatЅЅрP)`P)h*ЇЇœ44 =008Q)шP)*88†hhРO)0~*e ˆ N)H~*‰ 88 РQ)€Q)ˆ (0 ШQ)`R)а4І˜Q)рQ)xtІа488 XR)І0R)ІРL)шL)Š88 S)[)]88 type_name`S)xtype (000џџ @S)xtypePS)S)eІHс*ˆS)Fчча4ќзЄtextЇЇа4иS)textxS)pс*T)hh imageЇЇа4@T)imageˆT) с*hh HT)а*‰ јр*ˆS)Fчча4ќзЄ (000џџ №T)xtypecolstat U)(044 џџPU)colstat ЅЅU) U)˜с*ШU)œ44№U)00шU)˜U)Рс*†hhpT) р*ˆ  type_nameh[)xtype (000џџ ˜V)xtype8 XV)І ˆт*Fчча4ќзЄbinaryЇЇа40W)binaryаV)Ат*88hh charsˆ  W)ЇЇа4˜W)charшX)`т*hh  W)8W)se‰  timestamp\)ЇЇ а4 X) timestamp8 pX)т*@X)hh E0X)hр*‰ шс*Fчча4ќзЄ(000џџ иX)xtype8т*Fчча4ќзЄ(000џџ PY)xtype8 typestat(000 џџИY)typestat88 №Y) ит*ШY)œ88  00HZ)atјY)у*hhXX)Ар*ˆ V)Шр*88‰ 88 аZ) Z)[)ˆ ІиZ)p[)ІЈZ)№Z)І8888 h[)[)@[)88Іш[)ˆR)АR)Š88 h])88]88 colstat(044 џџ8\)colstatx\)88 p\)@у*H\)œ88 00Ш\)x\)hу*†hh88 ])@а\)ˆ (])Р])Іј\)@])џџІ])Р])88 И])])І˜[)Р[)^)Š88 И_)]88 colstat(044 џџˆ^)colstat88 Р^)Ју*˜^)œ88 00_)Ш^)ау*†hh 88 p_)€ _)ˆ x_)Pр(stІEH_)xЈTДє@l0ИМŒамXh D|”,ЄШ€№јрЬф` Z ј7н^68­АБДЖи 8 Р`ЙЂ ,08kКСDц^уt ц^уt ц^уtц^уtц^уt‰ ^кO#‰ ^кO"‰ ^кO!•‰ ^кO  ‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кOt‰ ^кO‰ ^кO‰ ^кO n‰ ^кO p‰ ^кO c‰ ^кOt‰ ^кO1‰ ^кO8‰ ^кO ‰ ^кO ‰ ^кO]‰ ^кOrQ/џ"кO (Q/џ"кO 'Q/џ"кOyQ/џ"кO yQ/џ"кO tQ/џ"кO sQ/џ"кO0Q/џ"кO eQ/џ"кO. Q/џ"кOwnфУ'кO _nфУ'кO]nфУ'кO  nфУ'кOSenфУ'кO nфУ'кOV Q *кO  Q *кO Q *кOmQ *кO=Q *кO'Q *кO aRu”+кO  Ru”+кO  Ru”+кOxRu”+кOiRu”+кO Ru”+кO&Ru”+кO. eRu”+кO Ru”+кOwRu”+кOaRu”+кO )Ru”+кO&sRu”+кOaRu”+кOoRu”+кO<Ru”+кO2Ru”+кOdRu”+кORu”+кO Ru”+кO Ru”+кO Ru”+кO Ru”+кORu”+кO—Ru”+кORu”+кOSRu”+кO,Ru”+кO0Ru”+кO1Ru”)кO2Ru”+кO3Ru”+кOPRu”+кOQeRu”+кORRu”+кOLRu”+кOMRu”+кONtRu”+кOO Ru”+кO4Ru”+кO5 Ru”+кO6(Ru”+кO7Ru”+кO8Ru”+кO9Ru”+кO:Ru”+кO;Ru”+кO?Ru”+кO@Ru”+кOCRu”+кOBRu”+кOIRu”+кOH Ru”+кO>Ru”+кO/Ru”+кOTRu”+кOURu”+кOVRu”+кO6e/кO8@6e/кO6e/кOe6e/кO6e/кO n6e/кOt6e/кO(o*Y0кO-o*Y0кO]o*Y0кO 'o*Y0кO'o*Y0кO'ЈNM1кOЈNM1кOlЈNM1кO4ЈNM1кOЈNM1кOЈNM1кOrЈNM1кO'ЈNM1кO ЈNM1кOЈNM1кO ЈNM1кO  ЈNM1кO&eЈNM1кO 0 ЈNM1кO ЈNM1кO (ЈNM1кOЈNM1кOЈNM1кOЈNM1кOЈNM1кOrtЈNM1кOЈNM1кOЈNM1кO ЈNM1кOЈNM1кOЈNM1кOЈNM1кOЈNM1кOЈNM1кO ЈNM1кO! ЈNM1кO"ЈNM1кO#ЈNM1кO)ЈNM1кO*щЂыv# uЫ5I@Т9кOV@Т9кOU@Т9кOTr@Т9кOS@Т9кOR@Т9кOQa@Т9кOPn@Т9кOOd@Т9кONl@Т9кOM)@Т9кOLt@Т9кOK@Т9кOJ@Т9кOIc@Т9кOH4@Т9кOG@Т9кOF@Т9кOE@Т9кOD@Т9кOC@Т9кOBo@Т9кOA@Т9кO@@Т9кO?@Т9кO>@Т9кO=@Т9кO<(@Т9кO;@Т9кO:@Т9кO9@Т9кO8@Т9кO7(@Т9кO6@Т9кO5@Т9кO4@Т9кO3@Т9кO2t@Т9кO1@Т9кO0n@Т9кO/r@Т9кO.v@Т9кO-c@Т9кO,t@Т9кO+@Т9кO*@Т9кO)(@Т9кO(@Т9кO'@Т9кO&(@Т9кO%@Т9кO$m@Т9кO#'@Т9кO"@Т9кO!@Т9кO p@Т9кO@Т9кO@Т9кO@Т9кOt@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO*@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO@Т9кO*@Т9кO @Т9кO @Т9кO 0@Т9кO @Т9кO (@Т9кO@Т9кO@Т9кO0@Т9кO@Т9кO(@Т9кO@Т9кO@Т9кO yц-кO.yц-кOyц-кO yц-кOeyц-кOpyц-кO0yц-кOyц-кO0(yц-кO1yц-кO2yц-кO3yц-кO yц-кO iyц-кO&yц-кO yц-кO eryц-кO yц-кOSeyц-кO0yц-кOyц-кO(yц-кO/yц-кO(yц-кO,yц-кOyц-кO-yц-кOPyц-кOQyц-кORyц-кOLyц-кOMyц-кONyц-кOOgyц-кO0yц-кO4yц-кO5(yц-кO6(yц-кO7yц-кO8yц-кO9yц-кO:yц-кO;eyц-кO<yц-кO=yц-кO> yц-кO?yц-кO@yц-кOAyц-кOByц-кOCyц-кODyц-кOE yц-кOF(yц-кOGyц-кOHyц-кOIyц-кOJyц-кO)(yц-кO*yц-кO+yц-кOyц-кOyц-кOyц-кOyц-кOtyц-кOayц-кOyyц-кO pyц-кO!h yц-кO" yц-кO#Ш yц-кO'  yц-кO(H yц-кOKА˜ @Јp`€hxP8 0№ˆи РшXИА(Шрј˜h 8€P№`0РxиЈHи№ 8Ph€˜АШрј(@Xpˆ Иаш(ј€hP8 №иРЈx`H0шаИ ˆp0ш8@˜hША˜шxаИ ˆpX@(јр€XИ P№РЈ`Hˆа Xp0H`xЈРи№ 8Ph€˜АШрј(@Xpˆ Иаш0H`xЈРи№ 8Ph€˜АШрј(@Xpˆ Иаш0H`xЈРи№ 8Ph€˜АШрј(`xЈР 89šB€  ) ) ) ))i   ts(apn'p[ ht e]r)  0 •l4  t t ) )     ) )4   l      t    t ) e y    ) 4p0)) ) !"#$ %&'(•) )   •  )4ttoy) t!c"#$%)&4'()             •      )             ) )    ) ц^уt ц^уtnц^уtц^уtц^уtо ЯMž#tо ЯMž#rо Й‚юZuо Й‚юZcо Й‚юZlо Й‚юZ)о Й‚юZо ˜йо ˜йlХu}Œ:@)Хu}Œ:@Pщi}Œ:@Pщi}Œ:@‰ ^Й‚юZ)‰ ^Й‚юZ‰ ^˜Ед3‰ ^˜Ед3e‰ ^кO#)‰ ^кO")‰ ^кO!0‰ ^кO ‰ ^кO‰ ^кO)‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO‰ ^кO•‰ ^кO‰ ^кO‰ ^кO ‰ ^кO ‰ ^кO ‰ ^кOg‰ ^кO‰ ^кO‰ ^кO‰ ^кO*‰ ^кO‰ ^кO‰ ^\Ї`$‰ ^\Ї`#x‰ ^\Ї`"‰ ^\Ї`!‰ ^\Ї` ‰ ^\Ї`*‰ ^\Ї`‰ ^\Ї`)‰ ^\Ї`‰ ^\Ї`‰ ^\Ї`‰ ^\Ї`‰ ^\Ї`0Т1RКШƒc Т1RКШƒc Т1RКШƒc)Т1RКШƒc)Т1RКШƒcТ1RКШƒcТ1RКШƒcТ1RКШƒcТ1RКШƒcТ1RѓьwdТ1RѓьwdpТ1RѓьwdТ1Rѓьwd ћUFѓьwd ћUFѓьwdћUFКШƒc)ћUFКШƒcћUFdяЪ]ћUFdяЪ]ћUFdяЪ]ћUFdяЪ]e4z: х~xy4z: х~xe4z: х~x4z: х~x4z: х~xmž.ѓьwdmž.FєpPemž.FєpPmž.FєpPmž.FєpPcmž.FєpPІТ" ѓьwdІТ" ѓьwdІТ" КШƒcioІТ" КШƒc)ІТ" 4z:ІТ" 4z:•ІТ" 4z:ІТ" 4z:ІТ" 4z:пц! DR> пц! DR>пц! DR> пц! DR>пц! х~x )пц! х~xпц! х~xпц!№ИJ)пц!№ИJ пц!№ИJ ".gz! ".gz "KR[{ "KR[{ "KR[{ "KR[{ "KR[{) "KR[{) "KR[{ "KR[{  "KR[{  "KR[{  "KR[{  "KR[{  "KR[{c "KR[{ "KR[{ "KR[{n "№ИJa "№ИJa "№ИJ  "№ИJn "№ИJy "№ИJ' "№ИJo "№ИJ _ "№ИJ t "№ИJ  "№ИJ  "№ИJ _ "№ИJt "№ИJ  "№ИJ) "№ИJn "№ИJe "№ИJr "№ИJ[ "№ИJp "№ИJn "№ИJ)Q/џ"кOlQ/џ"кOyQ/џ"ж7Г_Q/џ"ж7Г_Q/џ"кOQ/џ"кOQ/џ" DR> 4Q/џ" DR>Q/џ" х~x Q/џ" х~xQ/џ" х~xeQ/џ" х~xyQ/џ" х~xeQ/џ" х~xQ/џ" х~xQ/џ" х~xQ/џ" х~x Q/џ" х~x eQ/џ" х~xQ/џ" х~xQ/џ" х~xlQ/џ"№ИJQ/џ"№ИJQ/џ"№ИJQ/џ"№ИJ )Q/џ"№ИJ Q/џ"№ИJ)Q/џ"№ИJQ/џ"№ИJQ/џ"№ИJQ/џ"№ИJ Q/џ"№ИJQ/џ"№ИJQ/џ" х~xQ/џ"ж7Г_Q/џ"ж7Г_Q/џ"№ИJQ/џ"дЋˆN)Q/џ"дЋˆN Q/џ" х~xQ/џ"ж7Г_ Q/џ"КШƒcQ/џ"КШƒc)Q/џ"КШƒcQ/џ"ѓьwdQ/џ"ѓьwd4Q/џ"FМQ/џ"FМQ/џ"FМQ/џ"FМQ/џ"FМQ/џ"FМQ/џ"dяЪ]Q/џ"dяЪ]Q/џ"dяЪ]Q/џ"dяЪ] nQ/џ"dяЪ] nQ/џ"dяЪ] pQ/џ"dяЪ]tQ/џ"OjА]Q/џ"OjА'Q/џ"OjАlQ/џ"OjАQ/џ"OjАQ/џ"OjАQ/џ"OjАQ/џ"dяЪ]nQ/џ"dяЪ])Q/џ"!Q/џ"!Q/џ"ж7Г_ Q/џ"dяЪ])Q/џ"dяЪ]oQ/џ"dяЪ]tQ/џ"dяЪ]Q/џ"КШƒc oQ/џ"КШƒc Q/џ"ж7Г_ Q/џ"ж7Г_Q/џ"ж7Г_Q/џ"-WnlQ/џ"-WnQ/џ"FєpPQ/џ"FєpPQ/џ"e5`feQ/џ"e5`fQ/џ",leQ/џ",leQ/џ"žYTg)Q/џ"žYTgQ/џ"-WnQ/џ"ƒ0КsQ/џ"ƒ0КsQ/џ"ƒ0КsQ/џ"МTЎt Q/џ"МTЎt Q/џ"МTЎt Q/џ"МTЎtQ/џ"кOQ/џ"tќQ/џ"tќQ/џ"tќ)Q/џ"tќ Q/џ"кOQ/џ"ѓьwdQ/џ"ѓьwd ЎТ1RКШƒcЏQ/џ"ƒ0КsВ5РЯ&є2 mГnфУ'ж7Г_"ЕЇИ(œЭ)V1ЗRu”+tќйФН|-dяЪ]№—53юŽ9 ёХ6\Ї`ђтИж:†z ѓ%Г=кOєUGTE№ИJѕrќJMо… іrќJ х~xїЏŠUytхHЩgXж7Г_OIца+]]Ж!JЎђЬd'Г:"K ;ЕfкO"LY_ЉgКШƒcMZЅ>p№ИJNЭ3Мzл• OЭ3Мzж7Г_:XА{ж7Г_"‘# uа“3,’žEiMЕ“@Т9*…AT”@,№мШД ŒxdP<(ьиФАœˆt|hT` Z ј:я^9ЎЏВГЕЗй8@Р`5=X p;!F0?(convert(smallint,0))0!(8000)0Н(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)€(0Г(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or (type_name([xtype]) = 'char' or type_name([xtype]) = 'binary')) and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))0(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))0(convert(smallint,columnproperty([id],[name],'oldusertype')))0W(convert(varchar(255),[autoval]))0ћ(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))0O(odbcscale([xtype],[xscale]))0](convert(int,sign(([colstat] & 4))))0](convert(int,sign(([colstat] & 4))))80_(convert(int,(1 - ([typestat] & 1))))0•(convert(sysname,collationpropertyfromid([collationid],'name')))Ў—0 Љ(convert(binary(5),collationpropertyfromid([collationid],'tdscollation')))0 (convert(smallint,typeproperty([name],'oldusertype')))'0A(convert(bit,case when ((type_name([xtype]) = 'nvarchar' or (type_name([xtype]) = 'varchar' or type_name([xtype]) = 'varbinary'))) then 1 else 0 end))0[(convert(bit,(1 - ([status] & 1))))0e(convert(tinyint,xtypetotds([xtype],0)))0M(convert(varchar(255),null))(0(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null else (typeproperty([name],'precision')) end))0s(convert(tinyint,typeproperty([name],'scale')))0•(convert(sysname,collationpropertyfromid([collationid],'name')))0m(convert(smallint,(2 + 4 * ([status] & 1))))a0?(convert(smallint,0))0O(convert(bit,([status] & 1)))0 O(convert(bit,([status] & 2)))0 й(convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))0 ?(convert(smallint,0))0 ?(convert(smallint,0))0 O(convert(bit,([status] & 2)))0 O(convert(bit,([status] & 4)))0 O(convert(bit,([status] & 8)))0?(convert(smallint,0))0 ?(convert(smallint,0))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))'0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))80Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))аŸ(8`#8Ÿ(?ЉЊ*€4Дј<€ФLд\ фЄdФt4єШx8Ш0М<ь„(ф ` Д  М \ ќ Ќ АXШ8„Ф `-.J9–<880. ЅЅ  њџ њџ Crefmod0. 44 =uidi0. 44 Cstatus0. чџџџџ(а?name0. ЅЅUўџўџ =sid 0. ЅЅ§џ§џ Aroles0. == Kcreatedate0. == Kupdatedate0. 44 Caltuid0. ЅЅ ќџ ќџ Gpassword0. 88  ;id0. 44 Esmallide0. 00  ?type0. чџџџџ(а?name0. bbPўџўџ Avalue0. 88  ;id0. 88  Adepid0. 44   Cnumber0. 44  Idepnumber0. 44 Cstatus0. 00 Edeptype0. 44 Edepdbid0. 44 Idepsiteid0. hh   Cselall0. hh   Iresultobj0. hh   Ereadobjg#0.88  Econstid0.88  Cfkeyid0.88    Crkeyid0.44 Irkeyindidi0.44 Ckeycnt0.ЅЅ џџџџ Eforkeys0.ЅЅ ўџўџ Erefkeys 0.44 Gfkeydbid0.44   Grkeydbid0.44   Afkey1j#0.44   Afkey20.44   Afkey3b0.44   Afkey4a0.44 Afkey50.44 Afkey640.44 Afkey7l0.44 Afkey8a0.44 Afkey90.44 Eftcatid0.чџџџџа4?name0.44 Cstatus0.ччўџўџа4?path0.88  Etableid0.44 Erowinfo0.ЅЅ€џџџџ AftkeyЯЄ0.`44 Egroupid­0.`44 Mallocpolicy80.`88  Cstatus0.`чџџџџа4Igroupname0.44 Cfkey100.44 Cfkey110.44 Cfkey120.44 Cfkey130.44 Cfkey140.44 Cfkey150.44 Cfkey160.44 Arkey1u0.44 Arkey2t0.44 Arkey30.44 Arkey40.44 Arkey50.44 Arkey60.44   Arkey70.44!! Arkey8s0.44"" Arkey9џџ0.44## Crkey100.44$$ Crkey110.44%% Crkey120.44&& Crkey130.44'' Crkey140.44(( Crkey150.44)) Crkey160. 44   =gid0. ЇЇџ  (аEenviron0. 88    Mhasdbaccess0. 88   Eislogin0. 88  Gisntname0. 88  Iisntgroup0. 88  Gisntuser0. 88  Iissqluser0. 88  Iisaliased0. 88  Iissqlroles0. 88  Iisapprolei0.88  ;id0.44 Aindid0.44  Acolid0.44   Akeyno0.88  Econstid0.88  Cfkeyid0.88    Crkeyidџ0.44 ?fkey0.44 ?rkey0.44 Akeyno 0.44 Imemberuid0.44 Ggroupuid0.88  ;id0.44 =uid0.00  Caction0.00   Mprotecttype0.ЅЅ џџџџ Ecolumns0.44   Egrantor0._44 Cfileid0._44 Egroupid0._88  ?size0._88    Emaxsize0._88  Cgrowth40._88  Cstatusconvert(smalliМl$Мx0№Јdр ˜ P д„@Ф|0ьЌl(фœXа” Ь Œ D $рœXаŒHР|8єАl(ф \дL М x 4 № Ќ h $ р ˜ P  Р|0ьЈ`Ьˆ<єЌhи”Xд”LHќАdаˆ@№ЈhШ„8ьЈh(фЄ`;> , ”=f10O(convert(bit,([status] & 1)))0 O(convert(bit,([status] & 2)))0 й(convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))80 ?(convert(smallint,0))0 ?(convert(smallint,0))г0 O(convert(bit,([status] & 2)))0 O(convert(bit,([status] & 4)))0 O(convert(bit,([status] & 8)))0?(convert(smallint,0))0 ?(convert(smallint,0))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))0 Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))0Й(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))0 •(convert(smallint,case when ([uid] >= 16400) then [uid] when ((datalength([roles]) is null or datalength([roles]) <= 2)) then 0 else (16384 - 8 + datalength([roles]) * 8 + case when (convert(tinyint,[roles]) & 1 <> 0) then 0 when (convert(tinyint,[roles]) & 2 <> 0) then 1 when (convert(tinyint,[roles]) & 4 <> 0) then 2 when (convert(tinyint,[roles]) & 8 <> 0) then 3 when (convert(tinyint,[roles]) & 16 <> 0) then 4 when (convert(tinyint,[roles]) & 32 <> 0) then 5 when (convert(tinyint,[roles]) & 64 <> 0) then 6 when (convert(tinyint,[roles]) & 128 <> 0) then 7 end) end))ll0 M(convert(varchar(255),null))ub0 (convert(int,case when ([status] & 2 = 2) then 1 else 0 end))t0 е(convert(int,case when ([status] & 32 = 0 and [uid] > 0 and ([uid] < 16384)) then 1 else 0 end))ev0 (convert(int,case when ([status] & 4 = 4) then 1 else 0 end))l0 ‘(convert(int,case when ([status] & 12 = 4) then 1 else 0 end))on0 “(convert(int,case when ([status] & 12 = 12) then 1 else 0 end)))0 е(convert(int,case when ([status] & 60 = 0 and [uid] > 0 and ([uid] < 16384)) then 1 else 0 end))0 “(convert(int,case when ([status] & 16 = 16) then 1 else 0 end))10 Љ(convert(int,case when (([uid] >= 16384 or [uid] = 0)) then 1 else 0 end))re0 “(convert(int,case when ([status] & 32 = 32) then 1 else 0 end))rverse(substring([refkeys],19,2))),0)))0$Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0(Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2))),0)))fkey8smallint44smallintxл(€4isnullbinary]Тѕ­­binaryм(t$—€4reversesubstringforkeys(0ЅЅ џџџџн(forkeysам(ІЅЅ  /&88 pн(Hн( н(І88 0Р'ЉЊ*88 Шн( н(xн(І88 ан(ШЎ—FЅЅ|ФЄјн(џџ?гІ /& `+(`'FЇЇа4tЯЄ88 ˜о(0Р'м(ЉЊ*І­­Hо( о(ІЇЇа4pо(Шо(І88 ЬЬ)@№о(F­­ИЦЄп(Cц™эІ88 п(0щ@hп(@п(A1!KІд\ ф(lАє$ h Ќ №4xМDˆЬŒLќЌ\мTРшTР0XШxр А`=А И„>М>ѕWP0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],27,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],29,2))),0)))0Л(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],31,2))),0)))џ0Й(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],1,2))),0)))0Й(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],3,2))),0)))ЯЄ0Й(convert(smallint,isnull(convert(binary(2),reverse(qubstring([refkeys],5,2))),0)))0Й(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],7,2))),0)))ЦЄ0Й(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],9,2))),0)))0Л(convert(smallint,isnull(aonvert(binary(2),reverse(substring([refkeys],11,2))),0)))0 Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],13,2))),0)))0!Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],15,2))),0)))0"Й(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],17,2))),0)))0#Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],19,2))),0)))0$Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))40&Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0(Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)Л(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2))),0)))0# uЕ CREATE PROCEDURE updateItemMaster @itemunkid AS INT, @itemname AS VARCHAR(100), @purchase AS BIT, @sale AS BIT, @guidcol AS UNIQUEIDENTIFIER, --Jitu (18 July 2006) --Start --Update POS 2006 @ingerence AS BIT --Jitu (18 July 2006) --End AS DECLARE @status AS INT, --Jitu (18 July 2006) --Start --Update POS 2006 @rc AS INT, @itemtranId AS INT, @tempitemTranId AS INT, @tempSourceUnitID AS INT, @tempUnitId AS INT, @tempChargeId AS INT, @tempRate AS FLOAT, @tempRate1 AS FLOAT, @tempRate2 AS FLOAT, @tempRate3 AS FLOAU, @tempRate4 AS FLOAT, @tempSalestax AS FLOAT, @tempServicetax AS FLOAT, @tempOthertax AS FLOAT, @tempDefaultratenumber AS FLOAT, @tempFactor AS FLOAT --Jitu (18 July 2006) --End BEGIN BEGIN TRAN trupdateItemMaster IF EXISTS(SELECT itemname FROM cfitem_mst WHERE itemname = @itemname AND itemunkid <> @itemunkid) BEGIN SET @status = 100 ROLLBACK TRAN trupdateItemMaster RETURN @status END --Jitu (18 July 2006) --Start --Update POS 2006 /*UPDATE cfitem_mst SET itemname = @iuemname, purchase = @purchase, sale = @sale FROM cfitem_mst WHERE itemunkid = @itemunkid*/ UPDATE cfitem_mst SET itemname = @itemname, purchase = @purchase, sale = @sale, ingerence = @ingerence FROM cfitem_mst WHERE itemunkid = @itemunkid --Jitu (18 July 2006) --End IF @@error <> 0 SET @status = 200 --Jitu (18 July 2006) --Start --Update POS 2006 DELETE FROM cfItem_Ingerence WHERE recipeitemunkid = @itemunkid IF @@error <> 0 SET @status = 250 --Jitu (18 July 2006) --End DELETE FROM cfitem_tran WHERE itemunkid = @itemunkid IF @@error <> 0 SET @status = 300 --Jitu (18 July 2006) --Start --UPDATE POS 2006 /*INSERT INTO cfitem_tran (itemunkid, deptunkid, maintainstock, quantity, maxqty, minqty, qtyinhand, unitunkid, SourceUnitUnkid, DestinationUnitUnkid, ConversionFactor) SELECT @itemunkid, deptunkid, maintainstock, quantity, maxqty, minqty, qtyinhand, unitunkid, SourceUnitUnkid, DestinationUnitUnkid, ConversionFactor FROM cftempitem_tran WHERE guidcol = @guidcol IF @@error <> 0 SET @status = 400*/ select * FROM cftempitem_tran WHERE guidcol = @guidcol SELECT @rc = @@rowcount WHILE (@rc > 0) BEGIN SELECT top 1 @tempitemtranId = tempitemtranunkid FROM cftempitem_tran WHERE guidcol = @guidcol IF (@@rowcount > 0) BEGIN INSERT INTO cfitem_tran (itemunkid, deptunkid, maintainstock, quantity, maxqty, minqty, qtyinhand, unitunkid, SourceUnitUnkid, DestinationUnitUnkid, ConversionFactor) SELECT @itemunkid, deptumkid, maintainstock, quantity, maxqty, minqty, qtyinhand, unitunkid, SourceUnitUnkid, DestinationUnitUnkid, ConversionFactor FROM cftempitem_tran WHERE guidcol = @guidcol AND tempitemtranunkid = @tempitemtranId IF @@error <> 0 SET @status = 300 SET @itemtranId = @@identity /*SELECT @tempSourceUnitID = unitunkid, @tempUnitId = destinationunitunkid, @tempFactor = ConversionFactor FROM cfitem_tran WHERE itemtranunkid = @itemtranId IF NOT EXISTQ(SELECT * FROM cfitem_rate WHERE unitunkid = @tempUnitId AND itemunkid = @itemunkid) BEGIN SELECT @tempChargeId = chargeunkid, @tempRate = rate/@tempFactor, @tempRate1 = rate1/@tempFactor, @tempRate2 = rate2/@tempFactor, @tempRate3 = rate3/@tempFactor, @tempRate4 = rate4/@tempFactor, @tempsalestax = salestax, @tempservicetax = servicetax, @tempothertax = othertax, @tempdefaultratenumber = defaultratenumber FROM cfitem_rate WHERE itemunkid = @itemunkid AND unitunkid = @tempSourceUnitID DELETE FROM cfitem_rate WHERE itemunkid = @itemunkid AND unitunkid <> @tempUnitId AND unitunkid <> @tempSourceUnitID INSERT INTo cfitem_rate (itemunkid, chargeunkid, itemcode, rate, rate1, rate2, rate3, rate4, salestax, servicetax, othertax, defaultratenumber, unitunkid) VALUES( @itemunkid, @tempChargLєиМœ€dH,єиМ „hL0№|`D$ьаАtX< шЬTxдЬT˜ м d Ј ь 0 tИќ@„Ш P”и`Р Št?Š AkI**p *`X *№?* *  *H * *А *ІР *а *nyintр *88№ *!*tiny!*t № * !*€4 А *№?*iles@!*P!*`!*lesp!*(0€!*!* !* Р!*А!*lesР!*"*а!* р!*№!*([І"*"*€!*"* "*ІЅЅ0"*@"*("*€"*ІP"* `"*P"*p"*F00€"*ИЦЄ"* "* А"* Р"* "*аœа"* р"*№"*00#* #*#*а"*o+ #*†hh0#*@#*P#* `#*p#* ˆ €#*€#*Ш&*#*І #*А#*˜#* ІР#*а#*tinyа#*8ю)$*ш'*tiny$*tј#*€4($*@$*X$*Іrolesp$*Ј$*(0ЅЅˆ$*§џ $* Ш$*roleИ$*ЏЏа$* %*ш$*