roomactivity

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
roomno varchar 5 null
statusno bpchar 3 null
maidstatus bpchar 2 null
dateref date 13 null
qty int2 5 0
pax int2 5 0
room numeric 10,2 0
service numeric 10,2 0
tax numeric 10,2 0
arrqty int2 5 0
arrpax int2 5 0
roomtypeno bpchar 5 null
orino bpchar 3 null
natno bpchar 5 null
agentno int4 10 null
saleno bpchar 3 null
rsvtypeno bpchar 3 null
rateno bpchar 3 null
condno bpchar 3 null
comp bpchar 1 'N'::bpchar
hsu bpchar 1 'N'::bpchar
walkin bpchar 1 'N'::bpchar
groupflag bpchar 1 'N'::bpchar
dayused int2 5 null
dau_pax int2 5 null
dau_room numeric 10,2 null
stattype bpchar 2 null
startdate date 13 null
enddate date 13 null
bedtypeno bpchar 3 null
bldgno bpchar 3 null
memberno varchar 20 null
ctno bpchar 3 null
lang_id int4 10 null
mktno bpchar 3 null
gsttype bpchar 1 null
vipno bpchar 3 null
accno int4 10 null
guestno int4 10 null
adult int2 5 null
child int2 5 null
dau_adult int2 5 null
dau_child int2 5 null
arp int2 5 null
age int2 5 null
sex bpchar 1 null
name varchar 125 null
shareroom bpchar 1 'N'::bpchar
crno bpchar 3 null
abf numeric 10,2 null

Relationships