--Order 20014589.60


---GDTRANSACTION table---

ALTER TABLE GDTRANSACTION
	ADD (BATCHNUMBER NUMBER NULL);

ALTER TABLE GDTRANSACTION
	ADD (BATCHDATE DATE NULL);

COMMENT ON COLUMN GDTRANSACTION.GDTRANSCTIONTYPE IS '10 = New Wearer
11 = Change wearer
12 = Delete wearer
13 = Disconnect Wearer
20 = Issue garment
21 = Return Stock
22 = Rag
23 = Disconect Wearer''s garment
24 = Send to garment dispenser
30 = New product in contract
32 = delete product from contract
33 = New size per product
34 = Delete size
40 = new function or new product in function
42 = delete function
50 = Add product in wearer inventory
52 = Delete product in wearer inventory
60 = Add product to customer
62 = Delete product from customer
90 = Outscan
92 = Inscan';

COMMENT ON COLUMN GDTRANSACTION.BATCHNUMBER IS 'BatchNumber / Delivery Note Number to identify the batch on which the item is send.';


---CUSTOMERGARMENTDISPENSER table---

COMMENT ON COLUMN CUSTOMERGARMENTDISPENSER.INTERFACE IS '1 = LCT KUA
2 = Kannegiesser
3 = UNIMAT
4 = UNIMAT - Check in
5 = ABS Standard
6 = Walk''n Closet';

