西软客房预定信息

# 客房预订信息
select * from typim --房间小类 code,descript
select * from rmstalist --房间状态，脏房，检查，维修，干净，锁定，Touch Up

#房态 0维修1空净房2空脏房3空检查房4锁定房5住净房6住脏房7住检查房 8检查房9干净房10脏房
select * from sysoption

select * from bill_mode

SELECT * from yrmsalerep

select * FROM master where sta='R'

select * FROM hmaster where ressta='S'

select * from Pos_reserve

select m.hotelid,m.accnt,m.sta,m.cat,m.name,m.sex,m.vip,m.arr,m.dep,m.ratecode,m.setrate,m.haccnt,SUBSTR(m.extra,5,1) extra5,
m.resno,(m.charge - m.credit) as dblamount,m.type,m.roomno,m.gstno,m.rmnum,m.ref,m.master 
from master as m where (1=1) AND sta ='R' order by dblamount;

#rmsta 客房资料

SELECT * from rmsta

SELECT * from rmsta_till --备份信息
landv / landv.github.io

西软客房预定信息 #69
