Price Lists

Parent Previous Next

Price Lists are currently Customer only. 


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

Reference

Name

Price List / Price List Details

nvarchar(8)


Name

Description

Price List / Price List Details

nvarchar(60)


AccountRef

Reference

Price Lists / Price List Details / Customers 

nvarchar(8)


Status

N/A

N/A

nvarchar(8)

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


NB: The Currency for the Customer will be the Currency used for the Price List. 


Script to create the table...


CREATE TABLE [dbo].[PriceLists](

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

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

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

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

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

 CONSTRAINT [PK_PriceLists] PRIMARY KEY CLUSTERED 

(

       [ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]