Bank Transfers

Parent Previous Next


Bank Transfers move money from one Bank Account to another. Some of the fields used cannot be seen on the Bank Record activity screen but are used elsewhere in the system. The key fields that header records are grouped on are BankCodeFrom, BankCodeTo, Ref and Date.

The Ref field MUST be unique 


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

BankCodeFrom

A/C

Bank Record - Activity

nvarchar(8)

A key field

BankCodeTo

A/C

Bank Record - Activity

nvarchar(8)

Also a key field

Date

Date

Bank Record - Activity - Transaction Line

datetime

Also a key field

Ref

Ref

Bank Record - Activity - Transaction Line

nvarchar(30)

Also a key field

ExtRef

Internal ref

N/A

nvarchar(30)

Not visible on Bank Activity screen

Details

Details

Bank Record - Activity - Transaction Line

nvarchar(60)


Dept

n/a Dept

Bank Record - Activity - Transaction Line

nvarchar(2)


Value

Debit/Credit Amount

Bank Record - Activity - Transaction Line

decimal(18, 2)


ExchangeRate

N/A

N/A

decimal(18, 2)

Not visible on the Bank Activity Screen or Nominal Ledger

Status

N/A

N/A

nvarchar(8)

Used internally and not uploaded to Sage. Set to 'New', 'Error' or 'Sent' normally


Notes:       For transfers between the base currency and  a foreign currency bank account, the ExchangeRate in the XLS/Database is used if present. If left blank, the Sage currency default rate will be used.

Transfers from one foreign currency account to a different foreign currency account are NOT supported


Script to create the table...


CREATE TABLE [dbo].[BankTransfers](

       [ID] [int] IDENTITY(1,1) NOT NULL,

       [BankCodeFrom] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [BankCodeTo] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [Date] [datetime] NULL,

       [Ref] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [ExtRef] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [Details] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [Dept] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [Value] [decimal](18, 2) NULL,

       [ExchangeRate] [decimal](18, 2) NULL,

       [Status] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_BankTransfers_Status]  DEFAULT (N'New'),

 CONSTRAINT [PK_BankTransfers] PRIMARY KEY CLUSTERED 

(

       [ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]