--Order 20013059.170

--- STAY table ---

INSERT INTO STAY
  (STAY_ID, STAYTYPE, STAYNR, FACTORYDESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)
VALUES
  (SEQ_STAY.NEXTVAL, 2, 21, 'ON-SITE AT CUSTOMER', GETMINSYSTEMUSER(), SYSDATE);

COMMIT;


---PACKINGNOTECONTAINER table-----------

ALTER TABLE PACKINGNOTECONTAINER
	ADD (BAGLABELIDCODE VARCHAR2(24) NULL,
	          DELIVERYSCANTIMESTAMP DATE NULL);


---transactiontype table----
insert into transactiontype
  (transactiontype_id, factorydescription, systemuser_id, timestamp)
  select 546,
         'On-Site Delivery Scan',
         getminsystemuser(),
         sysdate
    from dual;
commit;

