Table PrintStock

Table used to store the data has to be printed in a report.

DDL

create sequence seqPrintStock as bigint start with 1;

create table PrintStock (
   psID bigint not null default next value for seqPrintStock,
   psCreatedOn datetime not null default sysdatetime(),
   psCreatedByFK pointer not null,
   psChangedOn datetime not null default sysdatetime(),
   psChangedByFK pointer not null,
   psJobID integer not null,
   psArticleFK pointer not null,
   psCustomerFK pointer not null default 0,
   psArticleCode nvarchar(50) not null default '',
   psStockCode nvarchar(3) not null default '',
   psLocation nvarchar(50) not null default '',
   psLotNo nvarchar(50) not null default '',
   psPalNo nvarchar(50) not null default '',
   psExpiryDate date,
   psQuantityIn amount not null default 0,
   psQuantityOut amount not null default 0,
   psQuantityStock amount not null default 0,
   psDateStock datetime not null default getdate(),
   CONSTRAINT pkPrintStock PRIMARY key (psID)
 );

Default Data

None.

Mapping

No mapping as this is a temporary table for printing.