Table ReturnShipment

DDL

create sequence seqReturnShipment as bigint start with 1;

create table ReturnShipment (
   rsID bigint not null default next value for seqReturnShipment,
   rsCreatedOn datetime not null default sysdatetime(),
   rsCreatedByFK bigint not null,
   rsChangedOn datetime not null default sysdatetime(),
   rsChangedByFK bigint not NULL,
   rsReturnDate datetime not null default sysdatetime(),
   rsClientOrderJobFK pointer,
   rsPrepaid BIT NOT NULL DEFAULT 0,
   rsOriginalOrderNumber ShortName Not null default '',
   rsCustomerFK pointer NOT NULL,
   rsReturnReasonFK pointer NOT NULL,
   CONSTRAINT pkReturnShipment PRIMARY key (rsID)
 );

Mapping

RETUR

Conversion ID: RETUR.cnvReturnShipmentID

New	Old
rsID	ID
rsCreatedOn	CREATIONDATE + CREATIONTIME
rsCreatedByFK	PCNAME
rsChangedOn	CREATIONDATE + CREATIONTIME
rsChangedByFK	PCNAME
rsReturnDate	ReturnDate
rsClientOrderJobFK	OriginalFileID
rsPrepaid	Prepaid (Y =>1, all other values => 0)
rsOriginalOrderNumber	OriginalOrderNumber
rsCustomerFK	Supplier (SupplierID)
rsReturnReasonFK	Reason (ReasonID)