LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rsr Table: Suspense Reversal

Description Column Datatype
Suspense number susp_num_s char (6)
Sybase timestamp timestamp timestamp
Date entered d_ent_s datetime
Clearing date d_clr_s datetime
Type of suspense item sus_type_s char (4)
Deletion reason sus_rsn_s char (4)
Operator initials opr_s char (3)
Comments comments_s char (36)
Portfolio por_s char (2)
Company com_s char (2)
Region reg_s char (2)
Office off_s char (3)
Lease lse_s char (10)
Assigned to operator asg_s char (3)
Receivable bank account G/L vector recv_bank_s char (3)
Disbursal bank account G/L vector disb_bank_s char (3)
Clear suspend G/L account clr_accnt_s char (3)
Reversal origination code rev_orig_s char (4)
Reversal batch number rev_batch_s char (20)
Check number chk_num_s char (10)
Amount amt_d double precision
Remaining check balance bal_d double precision
Reversal reason code rev_rsn_s char (4)

rsr Indexes:

Index name Piece 1 Piece 2
rsr_idx0 susp_num_s
rsr_idx1 lse_s susp_num_s


HomeTableIndexes