tablesync in HQ

Can someone tell me what the tablesync table in hq is for. Can i create my own tables to send down to the stores. I see the tohq tostore fields are bits , the option field is an integer. What is the options field? Can i use this table for this purpose. I have found no documentation on this. thanks mark

Reply to
MarkD
Loading thread data ...

You need to create a record in the TableSync table: TableName = Name of table to upload or download ToHQ = 1 if to upload, 0 if not ToStore = 1 if to download, 0 if not Options = See translate table below. The tables to be uploaded and downloaded must follow these conventions:

- They must exist at both HQ and the Store as the same name

- If uploading to HQ, the table must contain both an ID field and a StoreID field. The ID field must have the IDENTITY attribute at the store and not at HQ.

- If downloading from HQ to the store, the table must have an ID field with an IDENTITY attribute at both HQ and the Store and a HQID field at both locations.

- The tables must contain a DBTimeStamp field that is the TimeStamp for the record.

- The TableSync data will be processed for each Data Upload worksheet, immedeiately after the transaction data has been uploaded. Translate Table Options: The data in the tables uploaded to HQ can be translated to maintain the proper links. The following table describes the translate options: Value Meaning

0x0001 The AccountTypeID field will be translated for HQ 0x0002 The CurrencyID field will be translated for HQ 0x0004 The CustomerID field will be translated for HQ 0x0008 The ItemID field will be translated for HQ 0x0010 The ItemTaxID field will be translated for HQ 0x0020 The ShippingCarrierID field will be translated for HQ 0x0040 The ShippingServiceID field will be translated for HQ 0x0080 The ShipToID field will be translated for HQ 0x0100 The SupplierID field will be translated for HQ 0x0200 The TaxID field will be translated for HQ 0x0400 The TenderID field will be translated for HQ 0x0800 The DailySalesTypeID field will be translated for HQ 0x1000 The ReasonCodeID field will be translated for HQ 0x2000 The DiscountReasonCodeID field will be translated for HQ 0x4000 The ReturnReasonCodeID field will be translated for HQ 0x8000 The TaxChangeReasonCodeID field will be translated for HQ These values can be OR'd together to translate more than one field in the uploaded table.

"MarkD" wrote:

Reply to
Randall

Thank you!

"Randall" wrote:

Reply to
MarkD

I have had a problem with Tablesync in that it sent 4 times the rows from a location to head office. How do I reset my table at HQ to get all the data again?

"MarkD" wrote:

Reply to
PRS

PRS,

Try backdating a 401.

Reply to
Jeff

Cheers Jeff,

I got it to go another way as I would need to remove duplicates.

Ivan

Reply to
Ivan Brebner ..::PRS::..

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.