--Order 20014202.100

ALTER TABLE WEBUSER ADD (ALLOWCREATEBUDGETTRANSACTIONS NUMBER DEFAULT 0 NOT NULL
                                CONSTRAINT ALLOWCREATEBUDGETTR_VALID1_1 CHECK (ALLOWCREATEBUDGETTRANSACTIONS IN (0, 1)));
 
COMMENT ON COLUMN WEBUSER.ALLOWCREATEBUDGETTRANSACTIONS
  IS 'This attribute controls whether this web user may create manual wearer budget transactions via the garment web portal. This is only relevant when the modules BKLINTERNET and WEARERGARMENTSBUDGET are both active. Possible values:
0 = Not applicable/not allowed
1 = Web user may create budget transactions
';

COMMENT ON COLUMN WEARERBUDGETTRANSACTION.ORIGIN
  IS '1 = New employment, initial budget
2 = Annual Budget increase
3 = Expired Budget
4 = Manual Adjustment
5 = Work Order (Budget reservation)
6 = Issue (with work order)
7 = Cancel work order (Budget refund)
8 = Take out of circulation (Budget refund)
9 = Wearer inactive (set budget to zero)
10 = Manual Adjustment via Web Portal';