Table OutOrderDetailCC

DDL

create sequence seqOutOrderDetailCC as bigint start with 1;

create table OutOrderDetailCC (
   odcID pointer not null default next value for seqOutOrderDetailCC,
   odcCreatedOn datetime not null default sysdatetime(),
   odcCreatedByFK pointer not null,
   odcChangedOn datetime not null default sysdatetime(),
   odcChangedByFK pointer not NULL,
   odcOutOrderFK pointer not NULL,
   odcArticleFK pointer not null,
   odcCustomerFK pointer not null,
   odcQuantity INT NOT NULL DEFAULT 0,
   odcStockCode NVARCHAR(2) NOT NULL,
   odcOriginalStockCode NVARCHAR(2) NOT NULL,
   odcComments longname not null default '',
   odcTransactionType ShortName not null,
   CONSTRAINT pkOutOrderDetailCC PRIMARY KEY (odcID)
 );

Mapping

OUTDETAILSCC

Conversion ID: OUTDETAILSCC.OutOrderDetailCCID

New	Old
odcID	ID
odcCreatedOn	FILLDATE
odcCreatedByFK	PCNAME
odcChangedOn	FILLDATE
odcChangedByFK	PCNAME
odcOutOrderFK	AVIZNO
odcArticleFK	ARTCODE
odcCustomerFK	SUPPLIER
odcQuantity	QTY
odcStockCode	STOCKCODE
odcOriginalStockCode	ORIGINALSTOCKCODE
odcComments	COMMENTS
odcTransactionType	TRANSACTIONTYPE

Indexes