Table PrintTable

Temporary table for printing delivery reports.

Records used in the report are duplicated here, to be able to count them with different grouping.

DDL

create sequence seqPrintTable as bigint start with 1;

create table PrintTable (
   ptID bigint not null default next value for seqPrintTable,
   ptCreatedOn datetime not null default sysdatetime(),
   ptCreatedByFK pointer not null,
   ptChangedOn datetime not null default sysdatetime(),
   ptChangedByFK pointer not null,
   ptJobID bigint not null,
   ptArticleFK pointer not null,
   ptArticleCategoryFK pointer not null,
   ptOutOrderFK pointer not null,
   ptOutOrderDetailFK pointer not null,
   ptInvDetailFK pointer not null,
   CONSTRAINT pkPrintTable PRIMARY key (ptID)
 );

Mapping

None, temporary table.