LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rpy Table: Batch Payoff

Description Column Datatype
Batch date d_batch_s datetime
Batch number batch_num_s char (6)
Portfolio por_s char (2)
Processed indicator (Y/N) processed_c char (1)
Sybase timestamp timestamp timestamp
Batch projected total total_d double precision
Payoff status payoff_stat_s char (4)
Batch count total count_l integer
Processed entries count processed_cnt_l integer
Processed entries total processed_tot_d double precision
Batch validated (Y/N) validated_c char (1)
Run date d_run_s datetime
Run time t_run_s char (6)
Operator initials opr_s char (3)
Process batch at EOP (Y/N) proc_at_eop_c char (1)

rpy Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4
rpy_idx0 d_batch_s batch_num_s
rpy_idx1 por_s processed_c d_batch_s batch_num_s


HomeTableIndexes