----Script to update conversion I_tables only.
----Adds 3 new columns to 2 i-tables, I_CUSTOMER and I_CLIENT see below
-- Add/modify columns 
alter table I_CUSTOMER add CHARGEREPAIRCOG number default 0 not null;
-- Add comments to the columns 
comment on column I_CUSTOMER.CHARGEREPAIRCOG
  is 'only for COG
0 = No Repair allowed  and No charge repair
1 = Repair allowed and No charge repair
2 = Repair allowed and Charge repair';


-- Add/modify columns 
alter table I_CLIENT add deliverypointnumber number;
-- Add comments to the columns 
comment on column I_CLIENT.deliverypointnumber
  is 'Only for clientprivateperson, default will otherwise be the clientnumber';
  
  
-- Add/modify columns 
alter table I_CLIENT add PAYMENTTYPE number default 0 not null;
-- Add comments to the columns 
comment on column I_CLIENT.PAYMENTTYPE
  is '0 = Cash /Not applicable 
1 = Check 
2 = Credit Card 
3 = EFT 
4 = EDI 
5 = Accept Giro 
6 = Automatic Collection 
Default 0 (paid via Customer) ';  
