tbl_expensepaymentbunch

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_expensepaymentbunch_id_seq'::regclass)
companyid int8 19 √ null
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R
expensetype varchar 50 √ null
modeofpayment varchar 6 √ null
expenseclaim text 2147483647 √ null
approvedamount varchar 50 √ null
daterange varchar 100 √ null
bankname varchar 50 √ null
paymentstatus varchar 50 null
paymentdate date 13 √ null
approvaldate date 13 √ null
chequedate date 13 √ null
chequeno varchar 100 √ null
cashreceiptno varchar 100 √ null
remarks varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_expensepaymentbunch_id Primary key Asc id

Relationships

Close relationships within degrees of separation