ProjectTrans

Parent Previous Next


Field Mapping (mandatory fields in RED)

E2S Field

SAGE Field

Location within Sage

Length

Notes

Type

n/a

n/a

nvarchar(2)

Used as transaction type to upload as. Available types are... CD/CC

ProjectCode

Project Reference

Project Record -Activity

nvarchar(8)


CostCode

Cost Code

Project Record -Activity

nvarchar(8)


Resource

Resource

Project Record -Activity

nvarchar(8)


Date

Date

Project Record -Activity

datetime


Reference

Reference

Project Record -Activity

nvarchar(8)


Details

Details

Project Record -Activity

nvarchar(60)


Qty

Quantity

Project Record -Activity

Decimal(18,2)


Rate

Debit/Credit

Project Record -Activity

Decimal(18,2)


Status


N/A

nvarchar(8)



Script to create the table...


CREATE TABLE [dbo].[ProjectTrans](

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

       [Type] [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,

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

       [Date] [datetime] NULL,

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

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

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

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

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

 CONSTRAINT [PK_ProjectTrans] PRIMARY KEY CLUSTERED 

(

       [ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]