CORE-POS/IS4C

USE `is4c_log`;

DROP VIEW IF EXISTS `fstenders`;
CREATE VIEW `fstenders` AS SELECT 
    `tendertape`.`tdate` AS `tdate`,
    `tendertape`.`emp_no` AS `emp_no`,
    `tendertape`.`register_no` AS `register_no`,
    `tendertape`.`trans_no` AS `trans_no`,
    `tendertape`.`fsTender` AS `FsTender` 
    FROM `tendertape` 
    WHERE (`tendertape`.`fsTender`<>0)