Table ClientOrderJob

Table to store a record for each import job in the database. One record per import job, file data is in table ClientOrderFile.

DDL

create sequence seqClientOrderJob as bigint start with 1;

create table ClientOrderJob (
   cojID bigint not null default next value for seqClientOrderJob,
   cojCreatedOn datetime not null default sysdatetime(),
   cojCreatedByFK bigint not null,
   cojChangedOn datetime not null default sysdatetime(),
   cojChangedByFK bigint not NULL,
   cojCustomerFK Pointer not null,
   cojFileName NVARCHAR(512) not null,
   cojRejected  BIT NOT NULL,
   cojRejectedReason NVARCHAR(255) not null,
   cojFailed  BIT NOT NULL,
   cojFailedReason NVARCHAR(255) not null,
   cojType smallint not null default 0,
   cojManual Bit not null default 0,
   CONSTRAINT pkClientOrderJob PRIMARY key (cojID)
);

create unique index udxClientOrderJob on ClientOrderJob (cojFileName);

Mapping

XML_OUT

Conversion XML_OUT: SPIR_ORDER.cnvClientOrderJobID

New	Old
cojID	New
cojCreatedOn	New
cojCreatedByFK	New
cojChangedOn	New
cojChangedByFK	New
cojFileName	FileName
cojCustomerFK	CUSTOMER
cojType	1
cojManual	0

SPIR_ORDER

Conversion SPIR_ORDER: SPIR_ORDER.cnvClientOrderJobID

New	Old
cojID	New
cojCreatedOn	New
cojCreatedByFK	New
cojChangedOn	New
cojChangedByFK	New
cojFileName	FileName
cojCustomerFK	CUSTOMER
cojType	1
cojManual	0

NRW_OUT

Conversion NRW_OUT : NRW_OUT.cnvClientOrderJobID

New	Old
cojID	New
cojCreatedOn	New
cojCreatedByFK	New
cojChangedOn	New
cojChangedByFK	New
cojFileName	FileName
cojCustomerFK	Norwex
cojType	1
cojManual	0