Table ClientOutOrderArticle
DDL
create sequence seqClientOutOrderArticle as bigint start with 1;
create table ClientOutOrderArticle (
coaID bigint not null default next value for seqClientOutOrderArticle,
coaCreatedOn datetime not null default sysdatetime(),
coaCreatedByFK bigint not null,
coaChangedOn datetime not null default sysdatetime(),
coaChangedByFK bigint not NULL,
coaClientOutOrderFK Pointer not null,
coaRowID dbo.Name not null ,
coaArticleFK Pointer not null,
coaGiftWrap BIT not null default 0,
coaUnitOfMeasure ShortName not null default ''
coaSize smallint not null default 0,
coaOrderLineNo Int not null default -1,
coaRSystemDate DateTime ,
coaRSystemDate1 DateTime ,
coaUnitPrice amount not null default 0.0,
coaRowPrice amount not null default 0.0,
coaRowGiftWrap bit not null default 0,
coaQuantityOrdered Int not null default 0,
coaQuantityToDeliver Int not null default 0,
coaQuantityDelivered Int not null default 0,
coahazardousMaterial ShortName not null default '',
coaBatchID bigint not null default 0,
coaCustomerItemCode dbo.Name not null default '',
coaCustomerItemDescription dbo.Name not null default '',
coaCustomerItemEAN ShortName not null default '',
coaMfgBatchNo ShortName not null default '',
coaSRN ShortName not null default '',
coaStockFeature SmallInt not null default 0,
coaOwner ShortName not null default '',
CONSTRAINT pkClientOutOrderArticle PRIMARY key (coaID)
);
alter table ClientOutOrderArtcle add constraint fkClientOutOrderArticleArticle foreign key (coaArticleFK) references Article(aID) on update cascade on delete cascade;
Default Data
insert into ClientOutOrderArticle (_ID, _CreatedByFK, _ChangedByFK, ) values
Mapping
XML_OUTDETAILS
Conversion ID: XML_OUTDETAILS.cnvClientOutOrderArticleID
| New | Old |
|---|---|
| coaClientOutOrderFK | OrderNo |
| coaRowID | RowID |
| coaArticleFK | Artcode |
| coaArticleFK | ArticleDescription |
| coaQuantityOrdered | QTY |
| coaUnitOfMeasure | UnitOfMeasure |
| coaUnitPrice | UnitPrice |
| coaRowPrice | RowPrice |
| coaRowGiftWrap | RowGiftWrap |
| coaSize | UnitWeight |
| coahazardousMaterial | HazardousMaterial |
| coaRSystemDate | RSystemDate |
| coaRSystemDate1 | RSystemDate1 |
| coaBatchID | BatchID |
| coaTrackingNumber | |
| coaOrderReference | |
| coaRSystemDate1 | RSystemDate1 |
| coaTrackingNumber | TrackingNumber |
| coaOrderReference | TrackingNumber |
NRW_OUT
Conversion ID: NRW_OUT.cnvClientOutOrderArticleID
| New | Old |
|---|---|
| coaID | None |
| coaCreatedOn | None |
| coaCreatedByFK | None |
| coaChangedOn | None |
| coaChangedByFK | None |
| coaSize | size (convert to integer) |
| coaOrderLineNo | OrderLineNo |
| coaArticleFK | ItemCode |
| coaArticleFK | Description |
| coaClientOutOrderFK | OrderNo |
| coaBatchID | BlockNo |
| coaRSystemDate | RSystemDate |
| coaUnitPrice | Unitprice (convert to currency) |
| coaProcessed | Processed |
| coaCustomerItemCode | Customeritemcode |
| coaCustomerItemDesription | CustomerItemdescription |
| coaQuantityOrdered | OrderedQuantity |
| coaQuantityOrdered | Quantitytodeliver |
| coaOwner | Owner |
SPIR_ORDER
Conversion ID: SPIR_ORDER.cnvClientOutOrderArticleID
| New | Old |
|---|---|
| coaID | None |
| coaCreatedOn | None |
| coaCreatedByFK | None |
| coaChangedOn | None |
| coaChangedByFK | None |
| coSize | size (convert to integer) |
| coaBatchID | BatchID |
| coaArticleFK | Artcode |
| coaArticleFK | ArticleDescription |
| coaArticleFK | ArticleEAN |
| coaQuantityOrdered | QTY |
| coaRowPrice | Row_Price |
| coaRowGiftWrap | Row_Gift_wrap |
| coaRSystemDate | RSystemDate |
| coaTrackingNumber | TrackingNumber |
| coaCustomerItemEAN | ArticleEAN |
| coaCustomerItemCode | ArtCode |
| coaCustomerItemDescription | ArtDescription |