Table CommercialInvoiceDetail

DDL

create sequence seqCommercialInvoiceDetail as bigint start with 1;

create table CommercialInvoiceDetail (
   cidID bigint not null default next value for seqCommercialInvoiceDetail,
   cidCreatedOn datetime not null default sysdatetime(),
   cidCreatedByFK pointer not null,
   cidChangedOn datetime not null default sysdatetime(),
   cidChangedByFK pointer not null,
   cidCommercialInvoiceFK pointer not null,
   cidArticleFK pointer not null,
   cidQuantity integer not null,
   cidHSCode varchar(8) not null,
   cidRowValue AMOUNT not null default 0,
   cidRowNo Int not null default 0,
   cidCountryFK pointer not null,

   CONSTRAINT pkCommercialInvoiceDetail PRIMARY key (cidID)
);

alter table CommercialInvoiceDetail add constraint fkCommercialInvoiceDetailArticle foreign key (cidArticleFK) references Article(aID);
alter table CommercialInvoiceDetail add constraint fkCommercialInvoiceDetailCommInv foreign key (cidCommercialInvoiceFK) references CommercialInvoice(ciID) on update cascade on delete cascade;

Default Data

None.

Mapping

NRW_CI_DET

Conversion ID: .cnv ID

New	Old
cidID	ID
cidCreatedOn	RSystemDate
cidCreatedByFK
cidChangedOn
cidChangedByFK
cidCommercialInvoiceFK	InvoiceNumber
cidArticleFK	'NW' + ItemCode (Article.aCode)
cidQuantity	Quantity
cidHSCode	HSCode
cidRowValue	RowValue
cidRowNo	RowNu
cidCOO	COO