Specifies the columns and rows with Oracle data type information for the rlc
Lease Meter Charge table.
Description | Column Name | Data Type ? | Characteristics ? |
---|---|---|---|
Lease | lse_s | char | length 10 |
Meter ID | meter_id_s | char | length 4 |
Run date | d_run_s | date | format YYYYMMDD |
Run time | t_run_s | char | length 6 |
Record modification stamp | stamp_l | number | precision 10 |
Invoice number | invo_s | char | length 8 |
Operator initials | opr_s | char | length 3 |
Reversal operator initials | opr_r_s | char | length 3 |
Reversal date | d_rev_s | date | format YYYYMMDD |
Time of transaction reversal | t_rev_s | char | length 6 |
Usage period begin date | d_usage_beg_s | date | format YYYYMMDD |
Usage period end date | d_usage_end_s | date | format YYYYMMDD |
Base allowance | base_allow_l | number | precision 10 |
Previous credit | prev_credit_l | number | precision 10 |
New credit | new_credit_l | number | precision 10 |
Credit applied | credit_applied_l | number | precision 10 |
Number of billed items [1] | billed1_l | number | precision 10 |
Number of billed items [2] | billed2_l | number | precision 10 |
Number of billed items [3] | billed3_l | number | precision 10 |
Number of billed items [4] | billed4_l | number | precision 10 |
Number of billed items [5] | billed5_l | number | precision 10 |
Number of billed items [6] | billed6_l | number | precision 10 |
Number of billed items [7] | billed7_l | number | precision 10 |
Number of billed items [8] | billed8_l | number | precision 10 |
Number of billed items [9] | billed9_l | number | precision 10 |
Number of billed items [10] | billed10_l | number | precision 10 |
Cost per use rate [1] | p_cpu_rate1_d | number | precision 15, scale 5 |
Cost per use rate [2] | p_cpu_rate2_d | number | precision 15, scale 5 |
Cost per use rate [3] | p_cpu_rate3_d | number | precision 15, scale 5 |
Cost per use rate [4] | p_cpu_rate4_d | number | precision 15, scale 5 |
Cost per use rate [5] | p_cpu_rate5_d | number | precision 15, scale 5 |
Cost per use rate [6] | p_cpu_rate6_d | number | precision 15, scale 5 |
Cost per use rate [7] | p_cpu_rate7_d | number | precision 15, scale 5 |
Cost per use rate [8] | p_cpu_rate8_d | number | precision 15, scale 5 |
Cost per use rate [9] | p_cpu_rate9_d | number | precision 15, scale 5 |
Cost per use rate [10] | p_cpu_rate10_d | number | precision 15, scale 5 |
Amount charged | charged_d | number | precision 15, scale 2 |
Total meter read | tot_read_d | number | precision 15, scale 0 |
Index Name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 |
---|---|---|---|---|---|
rlc_idx0 | lse_s | meter_id_s | d_run_s | t_run_s | |
rlc_idx1 | invo_s | lse_s | meter_id_s | d_run_s | t_run_s |
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.0b Documentation Suite
©
2008 by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies 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 NetSol Technologies Inc. is prohibited.