CREATE TABLE dbo.TaxNotice
(
    NoticeNumber INT PRIMARY KEY NOT NULL,
    NoticeType INT,
    BalenceDue DECIMAL(13, 4)
    --PaymentDataID INT
);

CREATE TABLE dbo.PaymentData
(
    ID INT PRIMARY KEY,
    AmountPaid DECIMAL(13, 4),
    ReceiptNumber INT,
    CheckNumber INT,
    RemitterName VARCHAR(255),
    CashAmount DECIMAL(13, 4),
    CheckAmount DECIMAL(13, 4),
    CreditCardAmount DECIMAL(13, 4)
);


CREATE TABLE dbo.TaxNoticePaymentData
(
    ID INT,
    NoticeNumber INT,
    PaymentID INT
);