rpx Table: Batch Payoff Detail
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rpx Table: Batch Payoff Detail

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rpx_idx0 d_batch_s batch_num_s batch_seq_num_s batch_det_num_s    
rpx_idx1 por_s lse_s d_batch_s batch_num_s batch_seq_num_s batch_det_num_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
d_batch_s
Batch date
datetime no
batch_num_s
Batch number
char(6) no
batch_seq_num_s
Batch sequence number
char(8) no
batch_det_num_s
Batch detail number
char(4) no
timestamp
Record modification stamp
timestamp yes
lse_s
Lease
char(10) no
invo_s
Invoice number
char(8) yes
method_s
Method
char(4) yes
d_payoff_eff_s
Payoff effective date
datetime yes
payoff_src_s
Payoff source
char(4) yes
payoff_rat_s
Payoff rating
char(5) yes
chk_num_s
Check number
char(10) yes
received_d
Amount received
double precision yes
allow_ovr_s
Allow to override
char(8) yes
payoff_bank_s
Payoff bank code
char(4) yes
processed_c
Processed indicator (Y/N)
char(1) yes
opr_s
Operator initials
char(3) yes
por_s
Portfolio
char(2) no
susp_num_s
Suspense number
char(6) yes