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

Database Reference Sybase 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
timestamp 
Record modification stamp
timestamp yes
d_last_end_s 
Last End of Day date
datetime yes
d_cur_end_s 
Current End of Day date
 datetime yes
d_last_acc_s 
Last accrual date
 datetime yes
d_next_acc_s 
Next accrual date
 datetime yes
d_last_inv_s 
Last invoicing date
 datetime yes
d_next_inv_s 
Next invoicing date
 datetime yes
d_last_mth_s 
Last month end date
 datetime yes
d_next_mth_s 
Next month end date
 datetime yes
d_lst_year_s 
Date of last year end
 datetime yes
d_nxt_year_s 
Date of next year end
 datetime yes
d_sbmt_s 
Date of submit
 datetime yes
d_cmplt_day_s 
Date of EOD completion
 datetime yes
t_cmplt_day_s 
Time of EOD completion
 char(6) yes
d_cmplt_month_s 
Date of EOM completion
 datetime 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)
 char(250) yes
m_skip2_s 
Module array, skip execution (Y/N)
 char(250) yes
beg_chk_s 
Beginning check number
 char(6) yes
t_eod_after_s 
Default EOD submit after time
 char(20) yes
t_eom_after_s 
Default EOM submit after time
 char(20) yes
eop_queue_s 
EOP queue name
 char(40) yes
eop_supr_s 
EOP supervisor
 char(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
 char(40) yes
post_eop_s 
Post-EOP user command
 char(40) yes
eop_lpr_sym_s 
EOP lineprinter symbol
 char(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
integer yes
pp_end_mth_l 
End of Month post-portfolio boolean
 integer yes
end_day_l 
End of day
 integer yes
end_mth_l 
End of month
 integer yes
end_year_l 
End of year
 integer yes
cyc_acc_l 
Cycle accrual
 integer yes
cyc_invo_l 
Cycle invoicing
 integer yes
start_acc_l 
Start day to use in next monthly accrual cycle
 integer yes
start_invo_l 
Start day to use in next monthly invoice cycle
 integer yes
eop_multi_l 
EOP multi-process count
 integer yes
lse_cnt1_l 
Number of leases in range [1]
 integer yes
lse_cnt2_l 
Number of leases in range [2]
 integer yes
lse_cnt3_l 
Number of leases in range [3]
 integer yes
lse_cnt4_l 
Number of leases in range [4]
 integer yes
lse_cnt5_l 
Number of leases in range [5]
 integer yes
lse_cnt6_l 
Number of leases in range [6]
 integer yes
lse_cnt7_l 
Number of leases in range [7]
 integer yes
lse_cnt8_l 
Number of leases in range [8]
 integer yes
lse_cnt9_l 
Number of leases in range [9]
 integer yes
lse_cnt10_l 
Number of leases in range [10]
 integer yes
m_skip3_s 
Module array, skip execution (Y/N)
 char(200) yes
eop_prefetch_l 
EOP prefetch rowcount
 integer yes
d_prev_cmplt_day_s 
Date of previous EOD completion
 datetime 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
 integer yes
start_invo_wk_l 
Start day to use in next weekly invoice cycle
 integer yes
start_acc_biw_l 
Start day to use in next bi-weekly accrual cycle
 integer yes
start_invo_biw_l 
Start day to use in next bi-weekly invoice cycle
 integer yes
start_acc_smo_l 
Start day to use in next semi-monthly accrual cycle
 integer yes
start_invo_smo_l 
Start day to use in next semi-monthly invoice cycle
 integer yes