Table ReturnOrderDetail

DDL

create sequence seqReturnOrderDetail as bigint start with 1;

create table ReturnOrderDetail (
   roID pointer not null default next value for seqReturnOrderDetail,
   roCreatedOn datetime not null default sysdatetime(),
   roCreatedByFK bigint not null,
   roChangedOn datetime not null default sysdatetime(),
   roChangedByFK bigint not NULL,
   roReturnOrderFK bigint not NULL,
   roOutOrderFK bigint,
   roPalletFK bigint not null,
   roTransactionType shortName not null,
   roPicked BIT not null default 0,
   roPickedByFK bigint not NULL,
   roPickedOn datetime,
   CONSTRAINT pkReturnOrderDetail PRIMARY key (roID)
);

Mapping

RETUROUTDET

Conversion ID: RETUROUTDET.cnvReturnOrderDetailID

New	Old
roID	ID
roCreatedOn	CREATIONDATE + CREATIONTIME
roCreatedByFK	PCNAME
roChangedOn	CREATIONDATE + CREATIONTIME
roChangedByFK	PCNAME
roReturnOrderFK	IDNO
roOutOrderFK	ReturNO
roPalletFK	PalNo
roTransactionType	TransactionType
roPicked	picked
roPickedByFK	PickedBy
roPickedOn	pickeddate