Table ReturnReason

Warning

To be completed!

DDL

create sequence seq__ as bigint start with 1;

  create table ReturnReason (
     rrID pointer not null default next value for seqReturnReason,
     rrCreatedOn datetime not null default sysdatetime(),
     rrCreatedByFK pointer not null,
     rrChangedOn datetime not null default sysdatetime(),
     rrChangedByFK pointer not NULL,
     rrCode dbo.name not null,
     rrDescription longname not null,
     rrCountryCodeList longname not null default '',
     rrDisplayOrder int not null default 0,
     CONSTRAINT pkReturnReason PRIMARY key (rrID)
  );

  create unique index udxReturnReason on ReturnReason (rrCode);

Default Data

none

Mapping

RETURNREASON

Conversion ID: .cnv ID

New	Old
ID
CreatedOn
CreatedByFK
ChangedOn
ChangedByFK