LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rpy Table: Batch Payoff

Description Column Datatype
Batch date d_batch_s date
Batch number batch_num_s char (6)
Portfolio por_s char (2)
Processed indicator (Y/N) processed_c char (1)
Oracle row stamp stamp_l number (10)
Batch projected total total_d number (15,2)
Payoff status payoff_stat_s char (4)
Batch count total count_l number (10)
Processed entries count processed_cnt_l number (10)
Processed entries total processed_tot_d number (15,2)
Batch validated (Y/N) validated_c char (1)
Run date d_run_s date
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