rop Table: Operator
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rop Table: Operator

Indexes

Name Segment 1
rop_idx0 opr_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
opr_s
Operator initials
CHAR(3) no
stamp_l
Record modification stamp
NUMBER(10) no
pmt_tx_l
Number of payment transactions
NUMBER(10) yes
pay_l
Number of payoff transactions
NUMBER(10) yes
mnt_l
Number of maintenance transactions
NUMBER(10) yes
adj_l
Number of adjustment transactions
NUMBER(10) yes
new_l
Number of new loan transactions
NUMBER(10) yes
acc_l
Number of accrual transactions
NUMBER(10) yes
sup_l
Number of suspense transactions
NUMBER(10) yes
cch_l
Number of cashier's check transactions
NUMBER(10) yes
s_crdt_d
Total system credits
NUMBER(15,2) yes
s_dbt_d
Total system debits
NUMBER(15,2) yes
reb_l
Number of rebook transactions
NUMBER(10) yes