Table InvDetailCC

DDL

create sequence seqInvDetailCC as bigint start with 1;

create table InvDetailCC (
   idcID bigint not null default next value for seqInvDetailCC,
   idcCreatedOn datetime not null default sysdatetime(),
   idcCreatedByFK pointer not null,
   idcChangedOn datetime not null default sysdatetime(),
   idcChangedByFK pointer not NULL,
   idcInvFK pointer not null,
   idcArticleFK pointer not null,
   idcCustomerFK pointer not null,
   idcQuantity integer not null,
   idcStockCode nvarchar(2) not null default '',
   idcTransactionType ShortName not null default '',
   idcComments LongName not null default '',
   idcInvDetailFK pointer,
   CONSTRAINT pkInvDetailCC PRIMARY key (idcID)
 );
 --create unique index udx

Default Data

None.

Mapping

INVDETAILSCC

Conversion ID: INVDETAILSCC.cnvInvDetailCCID

New	Old
idcID	ID
idcCreatedOn	FillDate
idcCreatedByFK	PCNAME
idcChangedOn	FillDate
idcChangedByFK	PCNAME
idcInvFK	INVOICE
idcArticleFK	Article
idcQuantity	QTY
idcCustomerFK	SUPPLIER
idcStockCode	StockCode
idcTransactionType	TRANSACTIONTYPE
idcComments	COMMENTS
idcInvDetailFK	OriginalID