Changeset 9619 for branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql

Timestamp:

06/12/13 16:34:04 (11 years ago)

Author:

spimming

Message:

#1888:

• Added new BillingService methods
• Disabled proxy generation and lazy loading!
• Extended see method with additional test data
• Added properties to order and invoice model
• initial commit of BillingEngine module

File:

• branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql (modified) (2 diffs)

branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql

@@ -15 +15 @@
     [UserId] [bigint] not null,
     [OrderId] [bigint] not null,
+    [InvoiceDate] [datetime] not null,
     [Due] [datetime] not null,
     [StatusValue] [int] not null,
+    [Total] [float] not null,
+    [Tax] [float] not null,
     [InvoiceDocument] [nvarchar](max) null,
     primary key ([InvoiceId])
@@ -36 +39 @@
     [ActiveSince] [datetime] null,
     [ActiveUntil] [datetime] null,
+    [LastBillableDay] [datetime] null,
+    [NextBillableDay] [datetime] null,
     primary key ([OrderId])
 );