Sage Connect Status Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: SNETSTAT.DAT
The SNETSTAT.DAT file contains a record (row) for all packages sent to Sage Connect.
- To add Sage Connect hash fields to your Crystal reports, select SNETHASH.DAT.
Indexes and their uses
The SNETSTAT.DAT file has the following indexes:
0 = ByLocalKey
1 = ByServerKey
Fields
The following table shows the fields available in the SNETHASH.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
| LocalKey | GUID | Local task key | |
| ServerKey | GUID | Local server key | |
| Created | UInteger | When the record was created | |
| LastUpdated | UInteger | The last time the record was updated | |
| ZipFileHash | Zstring | 64 | The hash of the zip file to prevent tampering |
| BaseWorkingPath | Zstring | 256 | The path of the temporary folder used to build the sync |
| SyncType | UShort | Sync type | |
| LocalState | UShort | Local state of the sync | |
| ServerState | UShort | Server state of the sync | |
| PackageType | UShort | What was packaged (data or attachments) |