We need to run a report and return Order records that were created locally only (not online).
I wondered if there is a reliable way to check if records were created on the remote client vs. the online client?
e.g. is there some field which is only set locally, or function that works differently locally to online?
The only thing we came up with so far was, for a limited number of orders, the Order Number for local orders (which is based on: Expr: 'RowIdToRowIdNum ([Id])') appears to create differently formatted order numbers locally to online (but is that by design?) and will it be reliable?
Or is there another method to see were the orders were created?
You can read more on ROW_ID's on Supportweb: What is RowID/ROW_ID, and How is it Generated and Used? [ID 476256.1]
It looks like the Corporate Prefix is different for local databases and it looks like it's by design.
"The corporate prefix will always be unique for any database (main or local). The server maintains its original value, and mobile databases created against that particular server database are always assigned a new, unique value."