Donations
Donations creates both a Sales Invoice and a related and allocated Sales Receipt. The key field on this load is AccountRef. It is important to fill in a Nominal Code for the Invoice and a Bank Code for the receipt. FundID is also used on both parts. Each line will create a new donation. If the customer in AccountRef is set-up for Gift-Aid and the Date is after the declaration valid from date then the sales receipt record will be marked for Gift-Aid.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Data Type |
Notes |
|
|
ID |
N/A |
N/A |
int |
Used internally and not uploaded to Sage |
|
|
AccountRef |
A/C |
Customer Activity |
nvarchar(8) |
The key field for this tab. This will be the A/C or account ref for the customer this receipt or payment is for. |
|
|
Ref |
Ref |
Customer Activity - Transaction Line |
3nvarchar(0) |
|
|
|
ExtRef |
ExtRef |
Customer Activity - Transaction Detail Line |
3nvarchar(0) |
|
|
|
Date |
Date |
Customer Activity - Transaction Line |
datetime |
|
|
|
TaxCode |
n/a Tax Code |
n/a |
nvarchar(2) |
Not visible on Customer Activity or Nominal Ledger |
|
|
Value |
Amount |
Customer Activity - Transaction Line |
decimal(18, 2) |
Combined with VATAmount as Amount in Sage |
|
|
VATAmount |
Combined with above |
Customer Activity - Transaction Line |
decimal(18, 2) |
Combined with Amount as Amount in Sage |
|
|
Details |
Details |
Customer Activity - Transaction Line |
nvarchar(30) |
|
|
|
NomCode |
N/C Invoice |
Customer Activity - Transaction Detail Line |
nvarchar(8) |
|
|
|
BankCode |
N/C Receipt |
Customer Activity - Transaction Detail Line |
nvarchar(8) |
|
|
|
Dept |
Dept |
Customer Activity - Transaction Detail Line |
nvarchar(2) |
|
|
|
ProjectCode |
n/a - Project Code |
n/a |
nvarchar(8) |
Not visible on Customer Activity transactions |
|
|
CostCode |
n/a - Cost Code |
n/a |
nvarchar(8) |
Not visible on Customer Activity transactions |
|
|
Fund |
Funds |
Customer Activity - Transaction Detail Line |
nvarchar(4) |
|
|
|
Status |
N/A |
N/A |
nvarchar(8) |
|
NB: Some fields for the Invoice record only are also visible via Funds.
Script to create the table...
CREATE TABLE [dbo].[Donations](
[ID] [int] IDENTITY(1,1) NOT NULL,
[AccountRef] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ref] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExtRef] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[TaxCode] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Value] [decimal](18, 2) NULL,
[VATAmount] [decimal](18, 2) NULL,
[Details] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NomCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BankCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dept] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CostCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund] [nvarchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Donations_Status] DEFAULT (N'New'),
CONSTRAINT [PK_Donations] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]