Table ReturnOrder

Table to register return orders.

DDL

create sequence seqReturnOrder as bigint start with 1;

create table ReturnOrder (
   rID pointer not null default next value for seqReturnOrder,
   rCreatedOn datetime not null default sysdatetime(),
   rCreatedByFK bigint not null,
   rChangedOn datetime not null default sysdatetime(),
   rChangedByFK bigint not NULL,
   CONSTRAINT pkReturnOrder PRIMARY key (rID)
);

Mapping

RETUROUT

Conversion ID: RETUROUT.cnvReturnOrderID

New	Old
rID	ID
rCreatedOn	FillDate+FillTime
rCreatedByFK	PCNAME
rChangedOn	FillDate+FillTime
rChangedByFK	PCNAME