Sage Connect Hash Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: SNETHASH.DAT
The SNETHASH.DAT file contains a record (row) for all data sent to Sage Connect.
- To add Sage Connect hash fields to your Crystal reports, select SNETHASH.DAT.
Indexes and their uses
The SNETHASH.DAT file has the following indexes:
0 = ByDataTypeErpKey
1 = BySyncStatusKey
2 = ByReferenceDeleted
3 = ByReferenceKey
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 |
|---|---|---|---|
| DataType | UShort |
|
Unique record key |
| ErpKey | Zstring | 64 | Unique key sent to the server |
| SyncStatusKey | GUID | Local key for the sync status | |
| DataHash | ZString | 64 | Encrypted hash |
| ReferenceKey | GUID | Key for the related transactions | |
| ReferenceRevision | UInteger | Record version of the hash | |
| ReferenceDeleted | UTinyInt | Has the reference record been deleted |