Sage Business Cloud Accounting Tax Mapping Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: S1TaxMap.DAT
S1TaxMap.DAT is the tax mapping file for the Sage 50 sales taxes and their corresponding Sage Business Cloud Accounting sales taxes.
- To add Sage 50 sales tax fields to your Crystal reports, select S1TaxMap.DAT.
Fields
The following table shows the fields available in the S1TaxMap.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
| RecordNumber | Integer | Primary key | |
| SageOneTaxID | UBinary | 16 | GUID (Globally Unique Identifier) used for the Sage Business Cloud Accounting sales tax |
| SalesTaxID | UBinary | 16 | GUID (Globally Unique Identifier) used for the Sage 50 sales tax |
| IsTaxCode | UBinary | 1 | This is always true. |