Specifies the columns and rows with Oracle data type information for the rph
Payment History table.
Parent-Child:
This table has one or more child tables--click here for a listing.
Description | Column Name | Data Type ? | Characteristics ? |
---|---|---|---|
Lease | lse_s | char | length 10 |
Payment number | pmt_num_s | char | length 3 |
Reversal date (YYYYMMDD) | ymd_rev_s | char | length 8, format YYYYMMDD |
Payment run date | d_pmt_run_s | date | format YYYYMMDD |
Payment run time | t_pmt_run_s | char | length 6 |
Record modification stamp | stamp_l | number | precision 10 |
Invoice billed date (YYYYMMDD) | ymd_invo_bill_s | char | length 8, format YYYYMMDD |
Invoice due date | d_invo_s | date | format YYYYMMDD |
Effective date of payment | d_eff_s | date | format YYYYMMDD |
Effective date of last payment | d_lst_s | date | format YYYYMMDD |
Payment description | ph_typ_p_s | char | length 4 |
Reversal description | ph_typ_r_s | char | length 4 |
Payment billed on invoice (Y/N) | pmt_bill_c | char | length 1 |
Invoice number | invo_s | char | length 8 |
Payment operator initials | opr_p_s | char | length 3 |
Reversal operator initials | opr_r_s | char | length 3 |
Income recognized at maturity | inc_mat_d | number | precision 15, scale 2 |
Interest carryover | car_d | number | precision 15, scale 2 |
Principal paid | prn_p_d | number | precision 15, scale 2 |
Interest paid | int_p_d | number | precision 15, scale 2 |
Principal adjustment | prn_adj_d | number | precision 15, scale 2 |
Interest unpaid | int_unpd_d | number | precision 15, scale 2 |
Principal outstanding paid | prn_out_p_d | number | precision 15, scale 2 |
Principal outstanding received | prn_out_r_d | number | precision 15, scale 2 |
Last partial month interest | partial_d | number | precision 15, scale 2 |
Index Name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 |
---|---|---|---|---|---|
rph_idx0 | lse_s | pmt_num_s | ymd_rev_s | d_pmt_run_s | t_pmt_run_s |
rph_idx1 | lse_s | ymd_invo_bill_s | d_pmt_run_s | t_pmt_run_s | pmt_num_s |
Table Name | Description |
---|---|
rpha | Payment History Assessment |
Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.
LeasePak 6.0a Documentation Suite
©
2008 by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.