spool C:\wms_log\WM1DSUN001.txt

START request id WM1DSUN001--17-08-2011 -- CHANGED BY PRAVIN
ALTER TABLE LOCATION ADD (PALLET_BASED CHAR(1));
ALTER TABLE LOCATION ADD (SINGLE_LOT_SL CHAR(1));
ALTER TABLE LOCATION ADD (ITEM_LOT_OPT CHAR(1));
ALTER TABLE LOCATION ADD (CYCLE_COUNT_REQD CHAR(1));
INSERT INTO pbcatcol( pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap, pbc_init, pbc_edit, pbc_cmnt )VALUES ('LOCATION', 'std', 'PALLET_BASED', 'pallet_based', 23, 'pallet_based', 25, 25, '', 0, 0, 0, '', 'N', '', '', 'Describe Inventory weather pallet based Y - Yes or N - No.') ;
INSERT INTO pbcatcol( pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap, pbc_init, pbc_edit, pbc_cmnt )VALUES ('LOCATION', 'std', 'SINGLE_LOT_SL', 'single_lot_sl', 23, 'single_lot_sl', 25, 25, '', 0, 0, 0, '', 'N', '', '', 'Describe weather Single Lot_sl yes ,Y - Yes N - No ') ;
INSERT INTO pbcatcol( pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap, pbc_init, pbc_edit, pbc_cmnt )VALUES ('LOCATION', 'std', 'ITEM_LOT_OPT', 'item_lot_opt', 23, 'item_lot_opt', 25, 25, '', 0, 0, 0, '', 'N', '', '', 'Describe Location for keeping item and lot 0-Single Item singel lot 1-single item multiple lot 2- multipl items multiple lot') ;
INSERT INTO pbcatcol( pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap, pbc_init, pbc_edit, pbc_cmnt )VALUES ('LOCATION', 'STD', 'CYCLE_COUNT_REQD', 'cycle_count_reqd', 23, 'cycle_count_reqd', 25, 25, '', 0, 0, 0, '', 'N', '', '', 'Desc Location  for Cycle count applicable or not Y - Yes or N - No.');
commit;
-- End request id WM1DSUN001--17-08-2011 -- CHANGED BY PRAVIN

spool off
