Invoice Consignments
Invoice Updates, which replaced Invoice Consignments in version 2021.01.1, is used to add a consignment number (and optionally a courier) and to update the three Notes fields and three Analysis fields on an existing Invoice in Sage.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Data Type |
Notes |
|
SageInvNo |
Inv No. |
Product Invoice - Details |
nvarchar(60) |
The key field for this tab. This will be the order number for an existing SOP record |
|
ConsignNo |
Consign. No |
Product Invoice - Footer - Carriage |
nvarchar(30) |
The consignment number you wish to update on the order listed above |
|
Courier |
Courier |
Product Sales Order - Footer - Courier |
int |
Number relating to courier No |
|
Notes1 |
Notes line 1 |
Product Invoice - Order Details - Notes |
nvarchar(60) |
|
|
Notes2 |
Notes line 2 |
Product Invoice - Order Details - Notes |
nvarchar(60) |
|
|
Notes3 |
Notes line 3 |
Product Invoice - Order Details - Notes |
nvarchar(60) |
|
|
Analysis1 |
Analysis 1 |
Product Invoice - Order Details - Custom Fields |
nvarchar(60) |
|
|
Analysis2 |
Analysis 2 |
Product Invoice - Order Details - Custom Fields |
nvarchar(60) |
|
|
Analysis3 |
Analysis 3 |
Product Invoice - Order Details - Custom Fields |
nvarchar(60) |
|
Script to create the table...
CREATE TABLE [dbo].[InvoiceConsignments](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SageInvNo] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConsignNo] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Courier] [int] 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](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Analysis2] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Analysis3] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_InvoiceConsignments] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]