CREATE TABLE PaymentBatchDataType
(
    id BIGINT UNSIGNED DEFAULT NULL,
    Node BIGINT UNSIGNED NOT NULL,
    Customer BIGINT UNSIGNED NOT NULL,
    InvoiceNumber TEXT NOT NULL,
    Amount DECIMAL(11,2) NOT NULL,
    Total DECIMAL(11,2) NOT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT

) ENGINE=INNODB CHARSET=UTF8 COMMENT="payment batch";
