tbl_expenceclaimmaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
expid bigserial 19 √ nextval('tbl_expenceclaimmaster_expid_seq'::regclass)
tbl_expenceapproval.expid Implied Constraint R
companyid int8 19 √ null
expname varchar 50 √ null
placefrom varchar 50 √ null
placeto varchar 50 √ null
modeoftravel varchar 50 √ null
traveldate timestamp 29,6 √ null
expdetail varchar 500 √ null
createdate timestamp 29,6 √ null
createdby varchar 50 √ null
comm1 varchar 50 √ null
comm2 varchar 2147483647 √ null
comm3 varchar 50 √ null
comm4 int8 19 √ null
comm5 int8 19 √ null
comm6 int8 19 √ null
comm7 timestamp 29,6 √ null
comm8 timestamp 29,6 √ null
requestedamount numeric 0 √ null
modeofpayment varchar 6 √ null
bankname varchar 50 √ null
payemntdetail varchar 50 √ null
paymentdate timestamp 29,6 √ null
total_km numeric 0 √ null
showtracking bool 1 √ false
exceed_limit_remarks varchar 500 √ null
originalamount varchar 50 √ null
rep1amount varchar 50 √ null
rep2amount varchar 50 √ null
adminamount varchar 50 √ null
paymentbunchid int8 19 √ null
chequedate date 13 √ null
chequeno varchar 100 √ null
cashreceiptno varchar 100 √ null
gst varchar 50 √ null
sgst varchar 50 √ null
cgst varchar 50 √ null
igst varchar 50 √ null
utgst varchar 50 √ null
tds varchar 50 √ null
tds_amount varchar 50 √ null
payable_amount varchar 50 √ null
principal_amount varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_expenceclaimmaster_pk__tbl_expe__45b117c7b5b12a09 Primary key Asc expid

Relationships

Close relationships within degrees of separation