Synchronization - how it works
Synchronization
POSX synchronization is a program model which enables synchronization of data between two locations - Central and Off line Cash register.
From Central to Off line Register the Settings are being transferred (new records and changes of existing ones) and from Off line Cash register to Central the traffic is being transferred.
Interval
Sync is performed automatically at a given interval. By default the interval is set to 15 minutes. The lenght of interval can be changed, in practice it is usually set to 60 minutes. Additionally the option "Sync on demand" has been added, so if data transfer is needed, it can be synchronized immediately (it is in the menu in the wizard on the POSX form, as on Off line Cash register as well as at the switchboard).
By this way the Central SQL database is relieved, especially if there are several Off line Cash registers that are being synchronized.
Transfer of Invoices
Since version 1003700 the method of transferring invoices has changed. Invoices are now no longer transferred at intervals, but each invoice is sent independently after fiscalization/issuing of invoice. Invoice is by this way transferred only once.
Stock
Only Settings and not also the receiving documents are transferred from the central database to the Off line Cash register, so the stock status is transferred with synchronization from the Central database to the Off line Cash register. Stock recalculation is blocked at the Off line Cash register.
List of tables that are synchronized and the direction of transfer
TableName
|
TransferDirection
|
|
tHE_SetItemType
|
CENTRAL_TO_LOCAL
|
|
tHE_SetTax
|
CENTRAL_TO_LOCAL
|
|
tHE_SetDuty
|
CENTRAL_TO_LOCAL
|
|
tHE_SetForeTrans
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItemSNT
|
CENTRAL_TO_LOCAL
|
|
tHE_SetUM
|
CENTRAL_TO_LOCAL
|
|
tHE_SetDelMet
|
CENTRAL_TO_LOCAL
|
|
tHE_SetDelTerm
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjNACE
|
CENTRAL_TO_LOCAL
|
|
tDE_SetAccountPlan
|
CENTRAL_TO_LOCAL
|
|
tPA_UserGroup
|
CENTRAL_TO_LOCAL
|
|
tPA_Reports
|
CENTRAL_TO_LOCAL
|
|
tHE_SetCustTariff
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItemSNTItem
|
CENTRAL_TO_LOCAL
|
|
tDE_SetAccount
|
CENTRAL_TO_LOCAL
|
|
tPA_UserGroupProfile
|
CENTRAL_TO_LOCAL
|
|
tHE_SetPayMet
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjType
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjContact
|
CENTRAL_TO_LOCAL
|
|
tHE_CostDrv
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItemCateg
|
CENTRAL_TO_LOCAL
|
|
tPA_SetDocType
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItem
|
CENTRAL_TO_LOCAL
|
|
tHE_SetCustTariffPurcEx
|
CENTRAL_TO_LOCAL
|
|
tHE_SetCustTariffSaleEx
|
CENTRAL_TO_LOCAL
|
|
tHE_SetCustTariffPref
|
CENTRAL_TO_LOCAL
|
|
tHE_SetProdSt
|
CENTRAL_TO_LOCAL
|
|
tHE_SubjType
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjBank
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjContactAddress
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjPriceItem
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjPriceCateg
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjTypePriceItem
|
CENTRAL_TO_LOCAL
|
|
tHE_SetSubjTypePriceCateg
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItemExtItemSubj
|
CENTRAL_TO_LOCAL
|
|
tHE_SetItemPriceForWrh
|
CENTRAL_TO_LOCAL
|
|
tPA_UserAutho
|
CENTRAL_TO_LOCAL
|
|
tPA_Certificates
|
CENTRAL_TO_LOCAL
|
|
tHE_FiscalWorkPlace
|
CENTRAL_TO_LOCAL
|
|
tPA_SysParam
|
CENTRAL_TO_LOCAL
|
|
tHE_Stock
|
CENTRAL_TO_LOCAL
|
|
tHE_StockSerialNo
|
CENTRAL_TO_LOCAL
|
|
tPX_TouchColors
|
CENTRAL_TO_LOCAL
|
|
tPX_TouchMenu
|
CENTRAL_TO_LOCAL
|
|
tPX_TouchMenuItem
|
CENTRAL_TO_LOCAL
|
|
tPX_SetRooms
|
CENTRAL_TO_LOCAL
|
|
tPX_SetScale
|
CENTRAL_TO_LOCAL
|
|
tPX_SetTables
|
CENTRAL_TO_LOCAL
|
|
tPX_TableGlyph
|
CENTRAL_TO_LOCAL
|
|
tPX_RoomTable
|
CENTRAL_TO_LOCAL
|
|
tPA_SetDocTypeHE
|
CENTRAL_TO_LOCAL
|
|
tPA_SetDocTypeStat
|
CENTRAL_TO_LOCAL
|
|
tPA_SetDocTypeSyncItemCateg
|
CENTRAL_TO_LOCAL
|
|
tPA_SetDocTypeSyncItem
|
CENTRAL_TO_LOCAL
|
|
tDE_SetAccountCode
|
CENTRAL_TO_LOCAL
|
|
tHE_SetDocText
|
CENTRAL_TO_LOCAL
|
|
tHE_Move
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveItem
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveCash
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveFiscalisation
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveFiscalPrints
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveItemSerialNo
|
LOCAL_TO_CENTRAL
|
|
tHE_MoveItemExciseOut
|
LOCAL_TO_CENTRAL
|
|
tHE_LinkMoveMove
|
LOCAL_TO_CENTRAL
|
|
tHE_LinkMoveItemMoveItem
|
LOCAL_TO_CENTRAL
|
|
tHE_CashReg
|
LOCAL_TO_CENTRAL
|
|
tHE_CashRegItem
|
LOCAL_TO_CENTRAL
|
|
tHE_LinkMoveCashReg
|
LOCAL_TO_CENTRAL
|
|
tHE_Order
|
LOCAL_TO_CENTRAL
|
|
tHE_OrderItem
|
LOCAL_TO_CENTRAL
|
|
tHE_LinkMoveItemOrderItem
|
LOCAL_TO_CENTRAL
|
|
tPX_LinkOrders
|
LOCAL_TO_CENTRAL
|
|
tPX_LinkOrdersInvoice
|
LOCAL_TO_CENTRAL
|
|
tPX_LinkOrdersItems
|
LOCAL_TO_CENTRAL
|
|
tPA_Link
|
LOCAL_TO_CENTRAL
|
|
tHE_SetCurrency
|
TWO_WAY
|
|
tHE_SetPostCode
|
TWO_WAY
|
|
tHE_SetCountry
|
TWO_WAY
|
|
tHE_SetSubj
|
TWO_WAY
|