ras Table: EOP Accrual System
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

Database Reference

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