Table OutOrderDetail

DDL

create sequence seqOutOrderDetail as bigint start with 1;

create table OutOrderDetail (
   odID bigint not null default next value for seqOutOrderDetail,
   odCreatedOn datetime not null default sysdatetime(),
   odCreatedByFK pointer not null,
   odChangedOn datetime not null default sysdatetime(),
   odChangedByFK pointer not NULL,
   odOutOrderFK pointer not null,
   odArticleFK pointer not null,
   odQuantityRequested integer not null default 0,
   odQuantity integer not null default 0,
   odComments LongName not null default '',
   odInvDetailFK pointer,
   odStockCode Shortname Not null,
   odRowNumber integer not null default 0,
   odQuantityCurrent int not null default 0,
   odQuantityChangedOn datetime not null default sysdatetime(),
   odLSBFile dbo.Name not null default '',
   odFilledOn datetime,
   odBPoints ShortName not null default '',
   odQuantitySoft INT not null default 0,
   odUnitValue Float not null default 0.0,
   odPickedOn DateTime,
   odPickedByFK pointer,
   odPickedBy2FK pointer,
   odQuantityChecked int not null default 0,
   odCheckedByFK pointer,
   odCheckedOn datetime,
   odPaletteFK pointer,
   odQuantityPalette Int not null default 0,
   odPaletteDate datetime,
   odTransactionType ShortName not null,
   odTransitLocationFK pointer not null default 0,
   odrecordClosed BIT not null default 0,
   odOriginalImportRow nvarchar(250) not null default '',
   odQuantityMaster INT not null default 0,
   odGrouped dbo.Name not null default '',
   odCGroupID dbo.Name not null default '',
   odQuantityUnit INT not null default 0,
   odQuantityMasterReal INT not null default 0,
   odPickingLocationFK pointer not null default 0,
   odSuggestedLocationFK pointer not null default 0,
    CONSTRAINT pkOutOrderDetail PRIMARY key (odID)
 );
 -- create unique index udxOutOrderDetail

Default Data

None

Mapping

OUTDETAILS

Conversion ID: OUTDETAILS.cnvOutOrderDetailID

New	Old
odID	ID
odCreatedOn	FILLDATE
odCreatedByFK	PCNAME
odChangedOn	FILLDATE
odChangedByFK	PICKEDBY/CheckedBy
odOutOrderFK	AVIZNO
odArticleFK	ARTCODE
odQuantityRequested	QTYASKED
odQuantity	QTY
odInvDetailFK	INVOICENO contains the value of field INVDETAILS.ID
odStockCode	STOCKCODE
odRowNumber	ROWNO
odFilledOn	FILLDATE
odQuantityCurrent	QTYCF
odQuantityChangedOn	DATACF + TIMECF
odBPoints	BPOINTS
odQuantitySoft	QTYSOFT
odUnitValue	UNITVALUE
odPickedByFK	PICKEDBY
odPickedBy2FK	PICKEDBY2
odQuantityChecked	CHECKEDQTY
odCheckedByFK	CHECKEDBY
odPaletteFK	COLNO
odQuantityPalette	COLQTY
odPaletteDate	COLDATE
odTransactionType	TransactionType
odTransitLocationFK	TransitLocation
odrecordClosed	RecordClosed
odOriginalImportRow	OriginalImpRow
odQuantityMaster	MasterQTY
odGrouped	GROUPED
odCGroupID	CGROUPID
odQuantityUnit	UnitQTY
odQuantityMasterReal	RealMasterQTY
odPickingLocationFK	PickingLocation
odSuggestedLocationFK	SugestedLocation