Table ClientOutOrder
DDL
create sequence seqClientOutOrder as bigint start with 1;
create table ClientOutOrder (
coID bigint not null default next value for seqClientOutOrder,
coCreatedOn datetime not null default sysdatetime(),
coCreatedByFK bigint not null,
coChangedOn datetime not null default sysdatetime(),
coChangedByFK bigint not NULL,
coClientOrderJobFK Pointer not null,
coCustomerFK Pointer not NULL,
coSubCustomerFK Pointer,
coClientOrderNo dbo.Name not null,
coOrderDate datetime NOT NULL,
coDeliveryType smallint not null default 0,
coDeliveryDueDate datetime,
coDeliveryDueDateMandatory BIT not null default 0,
coDeliveryClientID dbo.Name not null default '',
coDeliveryClientFirstName dbo.Name not null default '',
coDeliveryClientLastName dbo.Name not null default '',
coDeliveryClientFullName dbo.Name not null default '',
coInvoiceClientFullName dbo.Name not null default '',
coDeliveryClientEmail LongName not null default '',
coDeliveryCompanyName dbo.Name not null default '',
coDeliveryCompanyAddress Description not null default '',
coDeliveryTown dbo.Name not null default '',
coDeliveryZip ShortName not null default '',
coDeliveryAddress1 NVARCHAR(200) not null default '',
coDeliveryAddress2 NVARCHAR(200) not null default '',
coDeliveryAddress3 NVARCHAR(200) not null default '',
coDeliveryProvince dbo.Name not null default '',
coDeliveryCountry dbo.Name not null default '',
coDeliveryTelephone dbo.Name not null default '',
coInvoiceClientIDI dbo.Name not null default '',
coInvoiceClientID dbo.Name not null default '',
coInvoiceClientFirstName dbo.Name not null default '',
coInvoiceClientLastName dbo.Name not null default '',
coInvoiceClientEmail LongName not null default '',
coInvoiceCompanyName dbo.Name not null default '',
coInvoiceCompanyAddress Description not null default '',
coInvoiceTown dbo.Name not null default '',
coInvoiceZip ShortName not null default '',
coInvoiceAddress1 NVARCHAR(200) not null default '',
coInvoiceAddress2 NVARCHAR(200) not null default '',
coInvoiceAddress3 NVARCHAR(200) not null default '',
coInvoiceProvince dbo.Name not null default '',
coInvoiceCountry dbo.Name not null default '',
coInvoiceTelephone dbo.Name not null default '',
coPaymentType dbo.Name not null default '',
coPaymentPrice amount not null default 0.0,
coPaymentPriceAdditional amount not null default 0.0,
coPaymentPriceShipping amount not null default 0.0,
coPaymentPriceTotal amount not null default 0.0,
coPaymentPriceDiscount amount not null default 0.0,
coPaymentPriceDiscountCode ShortName not null default '',
coPaymentPriceCurrency ShortName not null default '',
coPersonalMessage memo,
coPersonalMessageFrom dbo.Name not null default '',
coPersonalMessageTo dbo.Name not null default '',
coCustomerComment Memo,
coPrincipal ShortName not null default '',
coShippingMethod dbo.Name not null default '',
coLanguageCode ShortName not null default '',
coWeight amount not null default 0.0,
coCashOnDeliveryPrice amount not null default 0.0,
coShipmentID NVARCHAR(200) not null default '',
coICFlag dbo.Name not null default '',
coSRN dbo.Name not null default '',
coSerialNumber dbo.Name not null default '',
coMfgBatchNo dbo.Name not null default '',
coSerial dbo.Name not null default '',
coStockfeature dbo.Name not null default '',
coServiceCode ShortName not null default '',
coCarrierFK Pointer not null default 0,
coCashondelivery BIT not null default 0,
coProcessed BIT not null default 0,
coProcessedSent BIT not null default 0,
coProcessedDate DateTime,
coProcessedSentDate DateTime,
coRejected BIT not null default 0,
coRejectedReason CHAR (1) not null default ' ',
coRejectedDate DateTime,
coRejectedDescription NVARCHAR(100) not null default '',
coRejectionSent BIT not null default 0,
coRejectionSentDate DateTime,
coBackOrdered BIT NOT NULL DEFAULT 0,
coBackOrderedDate DATETIME,
coOrderReference dbo.Name not null default '',
coCustomerTrackingNumber dbo.Name not null default '',
coContact1 dbo.Name not null default '',
coContact2 dbo.Name not null default '',
coGiftWrap BIT NOT NULL DEFAULT 0,
coPickinstruction dbo.Name not null default '',
coDeliveryinstruction dbo.Name not null default '',
coOutputType ShortName not null default '',
CONSTRAINT pkClientOutOrder PRIMARY key (coID)
);
alter table ClientOutOrder add constraint fkClientOutOrderCustomer foreign key (coCustomerFK) references Customer(cID) on update cascade on delete cascade;
Default Data
insert into ClientOutOrder (coID, coCreatedByFK, coChangedByFK, ...) values (...)
Mapping
NRW_OUT
Conversion ID: NRW_OUT.cnvClientOutOrderID
| New | Old |
|---|---|
| ID | None |
| CreatedOn | None |
| CreatedByFK | None |
| ChangedOn | None |
| ChangedByFK | None |
| coClientOrderNo | SalesOrderNo |
| coOrderLineNo | OrderLineNo |
| coMfgBatchNo | MfgBatchNo |
| coSerial (?coArticleFK) | SRN |
| coStockfeature | StockFeature |
| coSerialNumber | SerialNumber |
| coDeliveryClientID | ShiptoCode |
| coDeliveryClientFullName | Shiptoname |
| coDeliveryAddress | Address1 |
| coDeliveryAddress2 | Address2 |
| coDeliveryAddress3 | Street |
| coDeliveryCompanyAddress | AddtlAddress |
| coDeliveryZip | ZipCode |
| coDeliveryTown | City |
| coDeliveryCountry | CountryCode |
| coDeliveryTelephone | Phone |
| coOrderReference | SalesOrderreference |
| coOrderDate | OrderDate |
| coDeliveryDueDate | DeliveryDate |
| coDeliveryDueDateMandatory | Datemandatory |
| coDeliveryType | Deliverytype |
| coPrincipal | Principal |
| coCarrierFK | Carrier |
| coOutputType | OutputType |
| coShipmentMethod | ShipmentMethod |
| coPickinstruction | Pickinstruction |
| coDeliveryinstruction | Deliveryinstruction |
| coContact1 | Contact |
| coContact2 | Contact1 |
| coLanguageCode | Languagecode |
| coDeliveryClientEmail | SpecificField1 |
| coDeliveryClientFirstName | SpecificField2 |
| coDeliveryClientLastName | SpecificField3 |
| coCashOnDelivery | Cashondelivery |
| coCashOnDeliveryPrice | Priceforcashondelivery |
| coShipmentID | ShipmentNumber |
| coClientOrderjobFK | FileName |
| coServiceCode | ServiceCode |
| coInvoiceAddress1 | Add_AddtlAddress1 |
| coInvoiceAddress2 | Add_AddtlAddress |
| coInvoiceZip | Add_ZipCode |
| coInvoiceTown | Add_City |
| coInvoiceCountry | Add_CountryCode |
| coICFlag | IC_flag |
| coWeight | Size |
| coPaymentPrice | UnitPrice |
SPIR_ORDER
Conversion ID: SPIR_ORDER.cnvClientOutOrderID
| New | Old |
|---|---|
| coID | ID |
| coCreatedOn | None |
| coCreatedByFK | None |
| coChangedOn | None |
| coChangedByFK | None |
| coClientOrderNo | OrderNo |
| coOrderDate | OrderDate |
| coDeliveryClientID | VARCHAR(50) |
| coDeliveryClientFirstName | DClientFirstName |
| coDeliveryClientLastName | DClientLastName |
| coDeliveryClientCompany | DClientCompany |
| coDeliveryCompanyAddress | DClientCompanyAddress |
| coDeliveryTown | DClientTown |
| coDeliveryZip | DClientTownCode |
| coDeliveryAddress1 | DClientAddress |
| coDeliveryAddress2 | DClientAddress1 |
| coDeliveryAddress3 | DClientAddress2 |
| coDeliveryCountry | DClientCountry |
| coDeliveryTelephone | DClientPhone |
| coInvoiceClientIDI | IDIClient |
| coInvoiceClientID | IClientID |
| coInvoiceClientFirstName | IClientFirstName |
| coInvoiceClientLastName | IClientLastName |
| coInvoiceCompanyName | IClientCompany |
| coInvoiceCompanyAddress | IClientCompanyAddress |
| coInvoiceClientEmail | IClientMail |
| coInvoiceTown | IClientTown |
| coInvoiceZip | IClientTownCode |
| coInvoiceAddress1 | IClientAddress |
| coInvoiceAddress2 | IClientAddress1 |
| coInvoiceAddress3 | IClientAddress2 |
| coInvoiceCountry | IClientCountry |
| coInvoiceTelephone | IClientPhone |
| coPaymentType | Payment_type |
| coPaymentPrice | Payment_price |
| coPaymentPriceAdditional | Payment_price_additional |
| coPaymentPriceShipping | Payment_price_shipping |
| coPaymentPriceTotal | Payment_price_total |
| coPaymentPriceDiscount | Payment_discount |
| coPaymentPriceDiscountCode | Payment_discount_code |
| coPaymentPriceCurrency | Payment_currency |
| coPersonalMessage | PersonalMessage |
| coPersonalMessageFrom | PersonalMessageFrom |
| coPersonalMessageTo | PersonalMessageTo |
| coCustomerComment | Customer_comment |
| coShippingMethod | shipping_method |
| coOrderReference | OrderReference |
| coCustomerTrackingNumber | TrackingNumber |
| coID | ID |
| coClientOrderjobFK | FileName |
| coCustomerFK | Customer |
| coCustomerFK | CustomerID |
| coSubCustomerFK | SubCustomer |
| coCarrierFK | Carrier |
| coProcessed | Processed |
| coProcessedDate | ProcessedDate |
| coProcessedSent | ProcessedSent |
| coProcessedSentDate | ProcessedSentDate |
XML_OUT
Conversion ID: XML_OUT.cnvClientOutOrderID
| New | Old |
|---|---|
| coID | ID |
| coClientOrderNo | OrderNo |
| coClientOrderDate | OrderDate |
| coDeliveryDueDate | OrderDeliveryDate |
| coClientOrderjobFK | FileName |
| coDeliveryClientID | DClientID |
| coDeliveryClientFirstName | DClientFirstName |
| coDeliveryClientLastName | DClientLastName |
| coDeliveryClientFullName | DClientFullName |
| coDeliveryTown | DClientTown |
| coDeliveryZip | DClientTownCode |
| coDeliveryAddress1 | DClientAddress1 |
| coDeliveryAddress2 | DClientAddress2 |
| coDeliveryAddress3 | DClientAddress3 |
| coDeliveryProvince | DClientProvince |
| coDeliveryCountry | DClientCountry |
| coDeliveryTelephone | DClientPhone |
| coDeliveryClientEmail | DClientEmail |
| coInvoiceClientIDI | IDIClient |
| coInvoiceClientID | IClientID |
| coInvoiceClientFirstName | IClientFirstName |
| coInvoiceClientLastName | IClientLastName |
| coInvoiceClientFullName | IClientFullName |
| coInvoiceCompanyName | IClientCompany |
| coInvoiceCompanyAddress | IClientCompanyAddress |
| coInvoiceTown | IClientTown |
| coInvoiceZip | IClientTownCode |
| coInvoiceAddress1 | IClientAddress1 |
| coInvoiceAddress2 | IClientAddress2 |
| coInvoiceAddress2 | IClientAddress3 |
| coInvoiceProvince | IClientProvince |
| coInvoiceCountry | IClientCountry |
| coInvoiceTelephone | IClientPhone |
| coInvoiceClientEmail | IClientEmail |
| coPaymentType | Payment_type |
| coPaymentPrice | Payment_price |
| coPaymentPriceAdditional | Payment_price_additional |
| coPaymentPriceShipping | Payment_price_shipping |
| coPaymentPriceTotal | Payment_price_total |
| coPaymentPriceDiscount | Payment_discount |
| coPaymentPriceDiscount | Payment_discount_code |
| coPaymentPriceCurrency | Payment_currency |
| coPersonalMessage | PersonalMessage |
| coPersonalMessageFrom | PersonalMessageFrom |
| coPersonalMessageTo | PersonalMessageTo |
| coGiftWrap | Gift_wrap |
| coCustomerComment | Customer_comment |
| coShipmentMethod | shipping_method |
| coCarrierFK | ShipCarrier |
| coWeight | OrderWeight |
| coCustomerFK | Customer |
| coCustomerFK | CustomerID |
| coProcessed | Processed |
| coProcessedDate | ProcessedDate |
| coProcessedSent | ProcessedSent |
| coProcessedSentDate | ProcessedSentDate |
| coRejected | Rejected |
| coRejectedDate | RejectedDate |
| coRejectedReason | RejectionReason |
| coRejectedDescription | RejectionDescription |
| coRejectionSent | RejectionSent |
| coRejectionSentDate | RejectionSentDate |
| coBackOrdered | BackOrdered |
| coBackOrderedDate | BackOrderedDate |