Table CustomerArticleGlobal

DDL

create sequence seqCustomerArticleGlobal as bigint start with 1;

create table CustomerArticleGlobal (
   cagID pointer not null default next value for seqCustomerArticleGlobal,
   cagCreatedOn datetime not null default sysdatetime(),
   cagCreatedByFK bigint not null,
   cagChangedOn datetime not null default sysdatetime(),
   cagChangedByFK bigint not NULL,
   cagArticleFK bigint not null default 0,
   cagArticleCode name not null,
   cagArticleDescription Description not null default '',
   cagCountryFK pointer not null,
   cagLanguage name not null default '',
   cagLinkedArticleCode1 name not null default '',
   cagLinkedArticleDescription1 Description not null default '',
   cagSizeSticker1 Description not null default '',
   cagLinkedArticleCode2 name not null default '',
   cagLinkedArticleDescription2 Description not null default '',
   cagSizeSticker2 Description not null default '',
   cagComments Description not null default '',
   CONSTRAINT pkCustomerArticleGlobal PRIMARY KEY (cagID)
);

Default Data

none

Mapping

___

Conversion ID: CustomerArticleGlobal.cnv__ ID

New	Old
cagID	did not exist
cagCreatedOn	did not exist
cagCreatedByFK	did not exist
cagChangedOn	did not exist
cagChangedByFK	did not exist
cagArticleFK	will be populated with Article.aID once record is processed
cagArticleCode	ARTCODE
cagArticleDescription	ART_DESCRIPTION
cagCountryFK	Use COUNTRY to look ID via Country.cuCountryCode
cagLanguage	LANGUAGE
cagLinkedArticleCode1	LINKEDARTCODE1
cagLinkedArticleDescription1	LINKEDAR_DESCRIPTION1
cagSizeSticker1	SizeSticker1
cagLinkedArticleCode2	LINKEDARTCODE2
cagLinkedArticleDescription2	LINKEDAR_DESCRIPTION2
cagSizeSticker2	SizeSticker2
cagComments	COMMENTS