Audit Trial
Audit Trail is used to perform any of the tradition Header/Split type transactions in Sage such as batch sales invoices and credits. Although most of these loads can be found elsewhere in E2S with more fields, this is included for users who wish to upload many types quickly with the most common fields in one process.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
Type |
n/a |
n/a |
2 |
Used as transaction type to upload as. Available types are... BR/BP/CR/CP/JD/JC/SI/SC/SR/SP/SA/PI/PC/PR/PP/PA/VP/VR. |
|
AccountRef |
Dependant on type |
Various - Activity |
8 |
|
|
Date |
Transaction Date |
Various - Activity |
10 |
|
|
Details |
Line 1 |
Various - Activity |
60 |
|
|
Reference |
Ref |
Various - Activity |
30 |
|
|
ExtraReference |
ExRef |
Various - Activity |
30 |
|
|
UserName |
User Name |
Various - Activity |
32 |
|
|
Value |
n/a Amount |
Various - Activity |
8 |
|
|
TaxCode |
VAT Code |
Various - Activity |
2 |
|
|
VATAmount |
VAT Amount |
Various - Activity |
8 |
|
|
ExchangeRate |
Exchange Rate |
Various - Activity |
8 |
If using a foreign currency company and the transaction is for a foreign currency account the transaction uses this exchange rate if provided, and the rate for the account if not. |
|
NomCode |
Nominal Code |
Various - Activity |
8 |
|
|
Dept |
Dept |
Various - Activity |
2 |
|
|
ProjectCode |
Project Code |
Various - Activity |
8 |
|
|
CostCode |
Cost Code |
Various - Activity |
8 |
|