rpn Table: Check Payment Detail
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rpn Table: Check Payment Detail

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rpn_idx0 d_batch_s batch_num_s batch_seq_num_s batch_pmt_num_s  
rpn_idx1 lse_s d_batch_s batch_num_s batch_seq_num_s batch_pmt_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_pmt_num_s
Batch payment number
char(4) no
timestamp
Record modification stamp
timestamp yes
lse_s
Lease
char(10) no
d_post_s
Posting date
datetime yes
d_out_s
Transfer/reversal date
datetime yes
a_typ_s
Assessment type
char(4) yes
trn_type_s
Transaction type (type of transfer/reversal)
char(4) yes
invo_s
Invoice number
char(8) yes
opr_s
Operator initials
char(3) yes
opr_r_s
Reversal operator initials
char(3) yes
tran_pmt_s
Transfer payment number
char(4) yes
amt_d
Amount
double precision yes
trn_rsn_s
Transaction reason code (TRN.RSN code)
char(4) yes
payoff_tran_typ_c
Payoff transaction type (P/T)
char(1) yes
orig_s
Payment origination code
char(4) yes
orig_r_s
Payment reversal origination code
char(4) yes
d_invo_s
Invoice due date
datetime yes
unit_s
Asset
char(10) yes