Purchase Orders

Parent Previous Next


Purchase Orders are similar to Sales Orders, but there is no quote option.

If the price/value fields are not filled in the best customer price (price list if valid, stock price if not) is used and the tax is calculated for you.


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

AccountRef

A/C

Product Purchase Order - Details

nvarchar(8)

The customer account ref this inv/credit is for

InvRef

Inv Ref

Product Purchase Order - Details

nvarchar(30)

The key field for this tab. This controls the creation of each header record. Lines with identical AccountRef/InvRef will be groups on an order as detail lines. 

SuppOrderNo

Supplier Order No

Product Purchase Order - Order Details - Supplier Order Details

nvarchar(60)


Date

Date

Product Purchase Order - Details

datetime


Product

Product Code

Product Purchase Order - Details - Item Lines

nvarchar(30)


Description

Description

Product Purchase Order - Details - Item Lines

nvarchar(60)

If blank stock description used

Qty

Quantity

Product Purchase Order - Details - Item Lines

decimal(18, 2)


UnitPrice

Price

Product Purchase Order - Details - Item Lines

decimal(18, 2)


Value

Net Amount

Product Purchase Order - Details

decimal(18, 2)


DiscountAmount

Discount Amount


decimal(18, 2)


TaxCode

Tax Code

n/a

nvarchar(2)

Not visible on Product Purchase Order

VATAmount

VAT Amount

Product Purchase Order - Details - Item Line

decimal(18, 2)


ExchRate

Exchange Rate


decimal(18, 2)

If left blank will use Sage default exchange rate (where Foreign Trader enabled in Sage) 

NomCode

Nominal

Product Purchase Order - Details - Item Line - Posting Details

nvarchar(8)

If blank system default of Supplier or Product nominal code will be used depending on system override settings

OrderDueDate

Delivery Date

Product Purchase Order - Deliveries

datetime


DueDate

Due Date

Product Purchase Order - Details - Item Line - Item Status

datetime


Notes1

Notes Line 1

Product Purchase Order - Order Details - Notes

nvarchar(60)


Notes2

Notes Line 2

Product Purchase Order - Order Details - Notes

nvarchar(60)


Notes3

Notes Line 3

Product Purchase Order - Order Details - Notes

nvarchar(60)


Analysis1

Analysis1

Product Purchase Order - Order Details - Custom Fields

nvarchar(30)


Analysis2

Analysis2

Product Purchase Order - Order Details - Custom Fields

nvarchar(30)


Analysis3

Analysis3

Product Purchase Order - Order Details - Custom Fields

nvarchar(30)


TakenBy

Order Taken By

Product Purchase Order - Order Details - Supplier Order Details

nvarchar(60)


Dept

Department

Product Purchase Order - Footer Details - Global

nvarchar(2)


ProjectCode


Product Purchase Order - Details - Item Line - Project Ref

nvarchar(8)


CostCode



nvarchar(8)


DelName

Delivery Add Line 1

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


DelAdd1

Delivery Add Line 2

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


DelAdd2

Delivery Add Line 3

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


DelAdd3

Delivery Add Line 4

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


DelAdd4

Delivery Add Line 5

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


DelAdd5

Delivery Add Line 6

Product Purchase Order - Order Details - Delivery Address

nvarchar(60)


Name

Add Line 1

Product Purchase Order - Details

nvarchar(60)

Customer default address used if all blank

Add1

Add Line 2

Product Purchase Order - Details

nvarchar(60)

"

Add2

Add Line 3

Product Purchase Order - Details

nvarchar(60)

"

Add3

Add Line 4

Product Purchase Order - Details

nvarchar(60)

"

Add4

Add Line 5

Product Purchase Order - Details

nvarchar(60)

"

Add5

Add Line 6

Product Purchase Order - Details

nvarchar(60)

"

Contact

Supplier Contact

Product Purchase Order - Order Details - Supplier Order Details

nvarchar(30)


Telephone

Supp Tel. No

Product Purchase Order - Order Details - Supplier Order Details

nvarchar(30)


Comment1

Comment 1

Product Purchase Order - Details - Item Line - Details

nvarchar(60)


Comment2

Comment 2

Product Purchase Order - Details - Item Line - Details

nvarchar(60)


LineInfo

Line Information

Product Purchase Order - Details - Item Line - Additional Information

nvarchar(30)


Units

Units

Product Purchase Order - Details

nvarchar(8)


Description (for message/special lines)

Description

Product Purchase Order - (Details) - Item Line

nvarchar(60)


Details (for special items)

Details

Product Purchase Order - (Details) - Item Line

nvarchar(240)


CarriageNet

Net

Product Purchase Order - Footer - Carriage



CarriageTaxCode

Tax Code

Product Purchase Order - Footer - Carriage



CarriageNomCode

N/C

Product Purchase Order - Footer - Carriage



CarriageDept

Department

Product Purchase Order - Footer - Carriage



Status

N/A

N/A

nvarchar(8)

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


Script to create the table...


CREATE TABLE [dbo].[PurchaseOrders](

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

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

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

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

       [Date] [datetime] NULL,

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

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

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

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

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

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

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

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

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

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

       [OrderDueDate] [datetime] NULL,

       [DueDate] [datetime] NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

       [Fund] [nvarchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

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

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

       [Description (for message/special lines)] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

       [Details (for special items)] [nvarchar](240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

       [CarriageTaxCode] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

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

 CONSTRAINT [PK_PurchaseOrders] PRIMARY KEY CLUSTERED 

(

       [ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]