Funds
Every line is a new Fund in Sage, repeated descriptions will be duplicated with new FundID
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 |
|
|
Description |
Name |
Funds/Add Fund |
nvarchar(63) |
|
|
|
Contact |
Contact |
Funds/Add Fund |
nvarchar(30) |
|
|
|
HeldBy |
(Holding) Institution |
Funds/Add Fund |
nvarchar(62) |
|
|
|
NomCode |
N/C |
Funds/Add Fund |
nvarchar(8) |
|
|
|
FundType |
Type |
Funds/Add Fund |
nvarchar(1) |
|
|
|
Status |
N/A |
N/A |
nvarchar(8) |
|
Script to create the table...
CREATE TABLE [dbo].[Funds](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Description] [nvarchar](63) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Contact] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HeldBy] [nvarchar](62) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NomCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FundType] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Funds_Status] DEFAULT (N'New'),
CONSTRAINT [PK_Funds] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]