Prices

Parent Previous Next

Prices are currently fixed Price Lists Prices 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

Type

N/A

N/A

1

P = Price List Price / S = Special Price

PriceListRef

Name

Price List / Price List Details

8


Product

Description

Price List / Associated Products / Edit Price / Product Details

30


Price

Reference

Price List / Associated Products / Edit Price / List Price Calculation / Value 

8


Status

N/A

N/A

nvarchar(8)

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


NB: Prices are currently fixed and will inherit the currency of the Price List they are attached to.


Script to create the table...


CREATE TABLE [dbo].[Prices](

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

       [Type] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

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

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

 CONSTRAINT [PK_Prices] PRIMARY KEY CLUSTERED 

(

       [ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]