singularity/InvoiceSummary.sql at main · shuxton/singularity · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
--DROP TABLE IF EXISTS SalesInvoiceSummary
--DROP TABLE IF EXISTS CreditNoteSummary
--DROP TABLE IF EXISTS DebitNoteSummary

CREATE TABLE SalesInvoiceSummary (
    Id BIGINT IDENTITY(1,1) PRIMARY KEY,
    TenantId INT NOT NULL,
    UniqueIdentifier UNIQUEIDENTIFIER NOT NULL,
    CreatedDate DATETIME NOT NULL,
    ModifiedDate DATETIME NOT NULL,
    NetInvoiceAmount DECIMAL(38, 18) NOT NULL,
    SumOfInvoiceLineNetAmount DECIMAL(38, 18) NOT NULL,
    TotalAmountWithoutVAT DECIMAL(38, 18) NOT NULL,
    TotalVATAmount DECIMAL(38, 18) NOT NULL,
    CurrencyCode NVARCHAR(10) NOT NULL,
    TotalAmountWithVAT DECIMAL(38, 18) NOT NULL,
    PaidAmount DECIMAL(38, 18) NOT NULL,
    PayableAmount DECIMAL(38, 18) NOT NULL,
    AdvanceAmountWithoutVat DECIMAL(38, 18) NOT NULL,
    AdvanceVat DECIMAL(38, 18) NOT NULL
);

CREATE TABLE CreditNoteSummary (
    Id BIGINT IDENTITY(1,1) PRIMARY KEY,
    TenantId INT NOT NULL,
    UniqueIdentifier UNIQUEIDENTIFIER NOT NULL,
    CreatedDate DATETIME NOT NULL,
    ModifiedDate DATETIME NOT NULL,
    NetInvoiceAmount DECIMAL(38, 18) NOT NULL,
    SumOfInvoiceLineNetAmount DECIMAL(38, 18) NOT NULL,
    TotalAmountWithoutVAT DECIMAL(38, 18) NOT NULL,
    TotalVATAmount DECIMAL(38, 18) NOT NULL,
    CurrencyCode NVARCHAR(10) NOT NULL,
    TotalAmountWithVAT DECIMAL(38, 18) NOT NULL,
    PaidAmount DECIMAL(38, 18) NOT NULL,
    PayableAmount DECIMAL(38, 18) NOT NULL,
    AdvanceAmountWithoutVat DECIMAL(38, 18) NOT NULL,
    AdvanceVat DECIMAL(38, 18) NOT NULL
);

CREATE TABLE DebitNoteSummary (
    Id BIGINT IDENTITY(1,1) PRIMARY KEY,
    TenantId INT NOT NULL,
    UniqueIdentifier UNIQUEIDENTIFIER NOT NULL,
    CreatedDate DATETIME NOT NULL,
    ModifiedDate DATETIME NOT NULL,
    NetInvoiceAmount DECIMAL(38, 18) NOT NULL,
    SumOfInvoiceLineNetAmount DECIMAL(38, 18) NOT NULL,
    TotalAmountWithoutVAT DECIMAL(38, 18) NOT NULL,
    TotalVATAmount DECIMAL(38, 18) NOT NULL,
    CurrencyCode NVARCHAR(10) NOT NULL,
    TotalAmountWithVAT DECIMAL(38, 18) NOT NULL,
    PaidAmount DECIMAL(38, 18) NOT NULL,
    PayableAmount DECIMAL(38, 18) NOT NULL,
    AdvanceAmountWithoutVat DECIMAL(38, 18) NOT NULL,
    AdvanceVat DECIMAL(38, 18) NOT NULL
);