Name | Segment 1 |
---|---|
rac_idx0 | por_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
por_s | Portfolio |
CHAR(2) | no |
stamp_l | Record modification stamp |
NUMBER(10) | no |
d_scratch_s | Last physical scratch file create date |
DATE | yes |
d_bank_s | Last physical bank file create date |
DATE | yes |
d_last_s | Last physical PAP-ACH run end date |
DATE | yes |
d_last_vach_s | Last physical vendor ACH run end date |
DATE | yes |
map_type_s | 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 "WDE " - Australia Westpac Direct Entry |
CHAR(6) | yes |
char_code_s | Bank file character code "ASCII " - American Standard Code for Information Interchange "EBCDIC" - Extended Binary Coded Decimal Interchange Code |
CHAR(6) | yes |
tran_type_s | 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 |
CHAR(3) | yes |
cur_type_s | Currency type code CAD - Canadian dollars USD - US dollars |
CHAR(3) | yes |
invert_inst_id_c | 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 #. |
CHAR(1) | yes |
pap_current_only_c | PAP-ACH current payment only |
CHAR(1) | yes |
use_lease_for_cust_no_c | Use lease number instead of lessee number for customer number in Royal Bank format. |
CHAR(1) | yes |
load_effective_date_c | PAP-ACH load primary due date into effective date field in ACH format only |
CHAR(1) | yes |
o_inst_id_s | Originator PAP institution id for returns (Canadian formats only) |
CHAR(9) | yes |
o_acct_num_s | Originator account number for returns (Canadian formats only) |
CHAR(12) | yes |
o_cust_no_s | Originator customer number for returns (Canadian formats only) |
CHAR(5) | yes |
o_cust_s_nam_s | Originator customer short name |
CHAR(15) | yes |
o_id_num_s | Originator identification number |
CHAR(10) | yes |
data_ctr_s | Data center number (Canadian formats only) |
CHAR(5) | yes |
password_s | Password |
CHAR(17) | yes |
dest_id_num_s | Destination identification number / transmit routing number (US formats only) |
CHAR(10) | yes |
company_id_s | Company identification number (US formats only) |
CHAR(10) | yes |
file_no_l | Next logical bank file control number |
NUMBER(10) | yes |
grace_days_l | PAP-ACH grace days |
NUMBER(10) | yes |
fin_inst_s | Financial institution |
CHAR(4) | yes |
bank_file_after_due_c | Generate bank file after due date (Y/N) |
CHAR(1) | yes |
pap_to_lse_c | Copy PAP (Preauthorized payment) information to lease when booking (Y/N) |
CHAR(1) | yes |