Name | Description |
---|---|
rase | EOP Module |
Name | Segment 1 |
---|---|
ras_idx0 | por_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | 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 |