Sage One Account Mapping Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: S1ActMap.DAT
S1ActMap.DAT is the account mapping file for the Sage 50 General Ledger accounts and their corresponding Sage One accounts.
- To add Sage 50 account fields to your Crystal reports, select S1ActMap.DAT.
Fields
The following table shows the fields available in the S1ActMap.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
| RecordNumber | Integer | Primary key | |
| SageOneAcntID | UBinary | 16 | GUID (Globally Unique Identifier) used for the Sage One account |
| AccountID | UBinary | 16 | GUID (Globally Unique Identifier) used for Sage 50 |