Table ClientOrderCommunication

DDL

create sequence seqClientOrderCommunication as bigint start with 1;

create table ClientOrderCommunication (
   cocID bigint not null default next value for seqClientOrderCommunication,
   cocCreatedOn datetime not null default sysdatetime(),
   cocCreatedByFK bigint not null,
   cocChangedOn datetime not null default sysdatetime(),
   cocChangedByFK bigint not NULL,
   cocCustomerFK Pointer not null,
   cocClientOutOrderFK Pointer not null,  -- Can be zero
   cocMessageType ShortName not null,
   cocClientOrderJobFK Pointer not null, -- Can be zero
   cocMessage memo not null,
   CONSTRAINT pkClientOrderCommunication PRIMARY key (cocID)
 );

Default Data

Mapping

XML_EXPORT

Conversion ID: XML_EXPORT.cnvClientOrderCommunicationID

New	Old
cocID	BatchID
cocCreatedOn	RSYSTEMDATE
cocCreatedByFK	0
cocChangedOn	RSYSTEMDATE
cocChangedByFK	0
coaClientOutOrderFK	OrderNo
cocCustomerFK	OrderNo -> Customer
cocClientOutOrderFK	orderNo
cocMessageType	MsgType
cocClientOrderJobFK	FileName