-- ABS-69452 / ABS-70903
ALTER TABLE ARTRANSACTIONSHADOW ADD (REMITIDSEQUENCENUMBER NUMBER DEFAULT 1 NOT NULL);

COMMENT ON COLUMN ARTRANSACTIONSHADOW.REMITIDSEQUENCENUMBER
  IS 'Used to make it possible to have multiple payments for a given RemitIdentification (check number)';

DROP INDEX XAK1ARTRANSACTIONSHADOW;
CREATE UNIQUE INDEX XAK1ARTRANSACTIONSHADOW ON ARTRANSACTIONSHADOW (BUSINESSUNIT_ID ASC, BILLTOCUSTOMER_LINK_ID ASC, ARTRANSACTIONDATE ASC, DEBITCREDIT ASC, ARTRANSACTIONTYPE_ID ASC, REMITIDENTIFICATION ASC, REMITIDSEQUENCENUMBER ASC);
