ras Table: EOP Accrual System
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

ras Table: EOP Accrual System

Child Tables

Name Description
rase EOP Module

Indexes

Name Segment 1
ras_idx0 por_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
stamp_l
Record modification stamp
NUMBER(10) no
d_last_end_s
Last End of Day date
DATE yes
d_cur_end_s
Current End of Day date
DATE yes
d_last_acc_s
Last accrual date
DATE yes
d_next_acc_s
Next accrual date
DATE yes
d_last_inv_s
Last invoicing date
DATE yes
d_next_inv_s
Next invoicing date
DATE yes
d_last_mth_s
Last month end date
DATE yes
d_next_mth_s
Next month end date
DATE yes
d_lst_year_s
Date of last year end
DATE yes
d_nxt_year_s
Date of next year end
DATE yes
d_sbmt_s
Date of submit
DATE yes
d_cmplt_day_s
Date of EOD completion
DATE yes
t_cmplt_day_s
Time of EOD completion
CHAR(6) yes
d_cmplt_month_s
Date of EOM completion
DATE yes
t_cmplt_month_s
Time of EOM completion
CHAR(6) yes
s_journal_off_c
Journaling off for next EOP (Y/N)
CHAR(1) yes
s_eod_sbmt_c
Default EOD submit state (H/I/A)
  H - Hold
  I - Immediate
  A - After time
CHAR(1) yes
s_eom_sbmt_c
Default EOM submit state (H/I/A)
CHAR(1) yes
m_skip1_s
Module array, skip execution (Y/N)
VARCHAR2(250) yes
m_skip2_s
Module array, skip execution (Y/N)
VARCHAR2(250) yes
beg_chk_s
Beginning check number
CHAR(6) yes
t_eod_after_s
Default EOD submit after time
VARCHAR2(20) yes
t_eom_after_s
Default EOM submit after time
VARCHAR2(20) yes
eop_queue_s
EOP queue name
VARCHAR2(40) yes
eop_supr_s
EOP supervisor
VARCHAR2(25) yes
s_eop_sbmt_c
EOP submitted for portfolio (Y/N)
CHAR(1) yes
sbmt_lck_c
Lock updates on EOP submit (Y/N)
CHAR(1) yes
pre_eop_s
Pre-EOP user command
VARCHAR2(40) yes
post_eop_s
Post-EOP user command
VARCHAR2(40) yes
eop_lpr_sym_s
EOP lineprinter symbol
VARCHAR2(20) yes
lse_key1_s
End of range lease key [1]
CHAR(19) yes
lse_key2_s
End of range lease key [2]
CHAR(19) yes
lse_key3_s
End of range lease key [3]
CHAR(19) yes
lse_key4_s
End of range lease key [4]
CHAR(19) yes
lse_key5_s
End of range lease key [5]
CHAR(19) yes
lse_key6_s
End of range lease key [6]
CHAR(19) yes
lse_key7_s
End of range lease key [7]
CHAR(19) yes
lse_key8_s
End of range lease key [8]
CHAR(19) yes
lse_key9_s
End of range lease key [9]
CHAR(19) yes
lse_key10_s
End of range lease key [10]
CHAR(19) yes
pp_end_day_l
End of Day post-portfolio boolean
NUMBER(10) yes
pp_end_mth_l
End of Month post-portfolio boolean
NUMBER(10) yes
end_day_l
End of day
NUMBER(10) yes
end_mth_l
End of month
NUMBER(10) yes
end_year_l
End of year
NUMBER(10) yes
cyc_acc_l
Cycle accrual
NUMBER(10) yes
cyc_invo_l
Cycle invoicing
NUMBER(10) yes
start_acc_l
Start day to use in next monthly accrual cycle
NUMBER(10) yes
start_invo_l
Start day to use in next monthly invoice cycle
NUMBER(10) yes
eop_multi_l
EOP multi-process count
NUMBER(10) yes
lse_cnt1_l
Number of leases in range [1]
NUMBER(10) yes
lse_cnt2_l
Number of leases in range [2]
NUMBER(10) yes
lse_cnt3_l
Number of leases in range [3]
NUMBER(10) yes
lse_cnt4_l
Number of leases in range [4]
NUMBER(10) yes
lse_cnt5_l
Number of leases in range [5]
NUMBER(10) yes
lse_cnt6_l
Number of leases in range [6]
NUMBER(10) yes
lse_cnt7_l
Number of leases in range [7]
NUMBER(10) yes
lse_cnt8_l
Number of leases in range [8]
NUMBER(10) yes
lse_cnt9_l
Number of leases in range [9]
NUMBER(10) yes
lse_cnt10_l
Number of leases in range [10]
NUMBER(10) yes
m_skip3_s
Module array, skip execution (Y/N)
VARCHAR2(200) yes
eop_prefetch_l
EOP prefetch rowcount
NUMBER(10) yes
d_prev_cmplt_day_s
Date of previous EOD completion
DATE yes
t_prev_cmplt_day_s
Time of previous EOD completion
CHAR(6) yes
man_range_c
EOP lease ranges are manually entered (Y/N)
CHAR(1) yes
seq_upd_restart_pos_c
Sequential updates restart position (F/C/N)
  F - First record
  C - Current record
  N - Next record
CHAR(1) yes
start_acc_wk_l
Start day to use in next weekly accrual cycle
NUMBER(10) yes
start_invo_wk_l
Start day to use in next weekly invoice cycle
NUMBER(10) yes
start_acc_biw_l
Start day to use in next bi-weekly accrual cycle
NUMBER(10) yes
start_invo_biw_l
Start day to use in next bi-weekly invoice cycle
NUMBER(10) yes
start_acc_smo_l
Start day to use in next semi-monthly accrual cycle
NUMBER(10) yes
start_invo_smo_l
Start day to use in next semi-monthly invoice cycle
NUMBER(10) yes