rac Table: Preauthorized Payments Control
Oracle DBMS
Specifies the columns and rows with Oracle data type information for the rac Preauthorized Payments Control table.
rac Columns
| Description | Column Name | Data Type ? | Characteristics ? |
|---|---|---|---|
| Portfolio | por_s | char | length 2 |
| Record modification stamp | stamp_l | number | precision 10 |
| Last physical scratch file create date | d_scratch_s | date | format YYYYMMDD |
| Last physical bank file create date | d_bank_s | date | format YYYYMMDD |
| Last physical PAP-ACH run end date | d_last_s | date | format YYYYMMDD |
| Last physical vendor ACH run end date | d_last_vach_s | date | format YYYYMMDD |
| Bank file map type "ACH " - Automated Clearing House electronic only "BM1 " - Bank of Montreal 1 electronic "BM2 " - Bank of Montreal 2 tape "RB1 " - Royal Bank 1 electronic "RB2 " - Royal Bank 2 tape "TD1 " - Toronto Dominion 1 electronic "TD2 " - Toronto Dominion 2 tape | map_type_s | char | length 6 |
| Bank file character code "ASCII " - American Standard Code for Information Interchange "EBCDIC" - Extended Binary Coded Decimal Interchange Code | char_code_s | char | length 6 |
| Payment transaction type code. (In Canada) service class code. (In USA) Possible values: In Cananda 400 - Lease payments In USA CCD - Corporate Lessees PPD - Private Lessees | tran_type_s | char | length 3 |
| Currency type code CAD - Canadian dollars USD - US dollars | cur_type_s | char | length 3 |
| Sort method code GL - Sort and break on GL key P/C/R/O/Lease PL - Sort and break on Portfolio/Lease only PC - Sort and break on Portfolio/Company/Lease subtotal by company and date | sort_method_s | char | length 2 |
| Invert lessee PAP institute ID when written to bank file. " " - Do not invert, write exactly as is. I - Invert. Normally, the lessee institute ID is entered in [U0203] in the following format: "0" / 3-char branch # / 5-char transit #. However, some users enter it differently: "0" / 5-char transit # / 3-char branch #. If this is the case, one may want to invert the branch and transit numbers when the institute ID is written to the bank file by setting this switch to "I", in which case it will be written as: "0" / 3-char branch # / 5-char transit #. | invert_inst_id_c | char | length 1 |
| PAP-ACH current payment only | pap_current_only_c | char | length 1 |
| Use lease number instead of lessee number for customer number in Royal Bank format. | use_lease_for_cust_no_c | char | length 1 |
| PAP-ACH load primary due date into effective date field in ACH format only | load_effective_date_c | char | length 1 |
| Originator PAP institution id for returns (Canadian formats only) | o_inst_id_s | char | length 9 |
| Originator account number for returns (Canadian formats only) | o_acct_num_s | char | length 12 |
| Originator customer number for returns (Canadian formats only) | o_cust_no_s | char | length 5 |
| Originator customer short name | o_cust_s_nam_s | char | length 15 |
| Originator identification number | o_id_num_s | char | length 10 |
| Data center number (Canadian formats only) | data_ctr_s | char | length 5 |
| Password | password_s | char | length 17 |
| Destination identification number / transmit routing number (US formats only) | dest_id_num_s | char | length 10 |
| Company identification number (US formats only) | company_id_s | char | length 10 |
| Next logical bank file control number | file_no_l | number | precision 10 |
| PAP-ACH grace days | grace_days_l | number | precision 10 |
| Financial institution | fin_inst_s | char | length 4 |
| PAP amount preference A - All P - Payment | pap_amt_pref_c | char | length 1 |
| Generate bank file after due date (Y/N) | bank_file_after_due_c | char | length 1 |
rac Indexes
| Index Name | Piece 1 |
|---|---|
| rac_idx0 | por_s |
Data Type Definitions and Characteristics
Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.
- char
- Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes,
and single-character switch values.
Characteristics:- length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.
- date
- Oracle date and time, containing century, year, month, day, hour, minute, and second information.
Characteristics:- format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.
- number
- Oracle numeric data type. Used for all numbers.
Characteristics:- precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
- scale - The fractional granularity, meaning the maximum number of places available to the right of the decimal point.
- varchar2
- Oracle variable length character string. Typically used to store medium and long-length string data such as names,
addresses, descriptions, and notebook entries.
Characteristics:- length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.
LeasePak Documentation Suite
©
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.