--Order 20015466

----PACKINGNOTELINE table----
ALTER TABLE PACKINGNOTELINE
	ADD (RECEIVEDQTY NUMBER  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN PACKINGNOTELINE.RECEIVEDQTY IS 'Quantity received at customer recorded via on-site UHF scanning.';


----MULTIREADSCANBATCHCONTENTS table----
ALTER TABLE MULTIREADSCANBATCHCONTENTS
	ADD (LASTDELIVERYNOTENUMBER NUMBER NULL);


----MULTIREADEXCEPTIONREASON table----
insert into MULTIREADEXCEPTIONREASON (MULTIREADEXCEPTIONREASON_ID, FACTORYDESCRIPTION, STORELOGYN, SYSTEMUSER_ID, TIMESTAMP)
values (16, 'Item not scanned out', 'Y', 1, sysdate);
commit;


----TRANSACTIONTYPE table----
insert into transactiontype
  (transactiontype_id, factorydescription, systemuser_id, timestamp)
  select 69,
         'Received at Customer',
         getminsystemuser(),
         sysdate
    from dual;
commit;

insert into transactiontype_desc
  (transactiontype_id, language_id, description, systemuser_id, timestamp)
  select transactiontype_id,
         getminlanguage(),
         factorydescription,
         systemuser_id,
         timestamp
    from transactiontype
   where transactiontype.transactiontype_id = 69;
commit;