Table OutOrder

DDL

create sequence seqOutOrder as bigint start with 1;

create table OutOrder (
   oID bigint not null default next value for seqOutOrder,
   oCreatedOn datetime not null default sysdatetime(),
   oCreatedByFK pointer not null,
   oChangedOn datetime not null default sysdatetime(),
   oChangedByFK pointer not NULL,
   oCode dbo.Name not null,
   oCustomerFK pointer not null,
   oCountryFK pointer not null,
   oFileName nvarchar(200) not null default '',
   oFillDate Timestamp,
   oType nvarchar(50) not null default '',
   oSystemDate TimeStamp,
   oDelivClientID ShortName not null default '',
   oDelivClientName dbo.Name not null default '',
   oDelivClientTown dbo.Name not null default '',
   oDelivClientTownCode ShortName not null default '',
   oDelivClientAddress Description not null default '',
   oDelivClientCountry dbo.Name not null default '',
   oDelivClientProvince dbo.Name not null default '',
   oDelivClientPhone dbo.Name not null default '',
   oDelivClientEmail LongName not null default '',
   oInvoiceClientID ShortName not null default '',
   oInvoiceClientName dbo.Name not null default '',
   oInvoiceClientTown dbo.Name not null default '',
   oInvoiceClientTownCode ShortName not null default '',
   oInvoiceClientAddress Description not null default '',
   oInvoiceClientCountry dbo.Name not null default '',
   oInvoiceClientProvince dbo.Name not null default '',
   oInvoiceClientPhone dbo.Name not null default '',
   oInvoiceClientEmail LongName not null default '',
   oInvoiceClientReference dbo.Name not null default '',
   oConfirmFileDate TimeStamp,
   oConfirmFileGenerate BIT not null default 0,
   oConfirmFileGenerate1 BIT not null default 0,
   oConfirmFileGenerate2 BIT not null default 0,
   oConfirmFileFileName Description not null default '',
   oTrackingNumber LongName not null default '',
   oTrackingNumber2 LongName not null default '',
   oFirstArticle dbo.Name not null default '',
   oArticleCount INT not null default 0,
   oTransportLocationFK pointer not null default 0,
   oCarrierDepo1FK pointer not null default 0,
   oCarrierDepo2FK pointer not null default 0,
   oCarrierDepo3FK pointer not null default 0,
   oCarrierTrackingNumber1 dbo.Name not null default '',
   oCarrierTrackingNumber2 dbo.Name not null default '',
   oCarrierRoutingDate TimeStamp,
   oCarrierFK pointer not null default 0,
   oEDIGeneratedOn Timestamp,
   oShippingMethodFK pointer Not null default 0,
   oPickListPrintedOn Timestamp,
   oPickjobFK pointer not null default 0,
   oClientOutOrderFK pointer,
   CONSTRAINT pkOutOrder PRIMARY key (oID)
 );
 create unique index udxOutOrderInvoice on OUT(oCode);
 create index idxOutOrderCreatedOn on OutOrder(oCreatedOn );

Default Data

Mapping

OUT

Conversion ID: OUT.cnvOUTOrderID

New	Old
oID	unique ID, no old field
oCreatedOn	DATA
oCreatedByFK	PCNAME
oChangedOn	FILLDATE
oChangedByFK	PCNAME
oCustomerFK	IDCLient
oCountryFK	COUNTRY
oCode	AVIZ
oType	OrderType
oSystemDate	SystemDate
oDelivClientID	IDDClient
oDelivClientName	DClient
oDelivClientTown	DClientTown
oDelivClientTownCode	DClientTownCode
oDelivClientAddress	DClientAddress
oDelivClientCountry	DClientCountry
oDelivClientProvince	DClientProvince
oDelivClientPhone	DClientPhone
oDelivClientEmail	DClientEmail
oInvoiceClientID	IDIClient
oInvoiceClientName	IClient
oInvoiceClientTown	IClientTown
oInvoiceClientTownCode	IClientTownCode
oInvoiceClientAddress	IClientAddress
oInvoiceClientCountry	IClientCountry
oInvoiceClientProvince	IClientProvince
oInvoiceClientPhone	IClientPhone
oInvoiceClientEmail	IClientEmail
oInvoiceClientReference	IClientReference
oConfirmFileDate	CFGenFileDate
oConfirmFileFileName	CFGenFile
oConfirmFileGenerate	CFGen
oConfirmFileGenerate1	CFGen1
oConfirmFileGenerate1	CFGen2
oTrackingNumber	TrackingNumber
oTrackingNumber2	TrackingNumber2
oFirstArticle	FirstArticle
oArticleCount	ArticleCount
oTransportLocationFK	TLocation
oCarrierDepo1Fk	CarrierDepo1
oCarrierDepo2Fk	CarrierDepo2
oCarrierDepo2Fk	CarrierDepo3
oCarrierTrackingNumber1	CarrierTrackingNo1
oCarrierTrackingNumber2	CarrierTrackingNo2
oCarrierRoutingDate	CarrierRoutingDate
oCarrierFK	Carrier
oEDIGeneratedOn	EdiDate
oShippingMethodFK	ShippingMethod
oPickListPrintedOn	PLPrintingDate
oPickjobFK	PickingJobID