TR_BAX_FLTR_OPT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TR_FILTER_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Filter Options
1=Status Filters 2=Hide Status Filters Default Value: 1 |
| 2 | SELECT_DT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Date Type
1=Specific Dates 2=Relative Dates Default Value: 2 |
| 3 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | SRCH_DAYS | Number(5,0) | INTEGER NOT NULL |
Relative Days
Default Value: 0 |
| 5 | FROM_DT | Date(10) | DATE |
From Date
Default Value: %date |
| 6 | TO_DT | Date(10) | DATE |
To Date
Default Value: %date |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 8 | BAX_TRANSFER_ID | Character(12) | VARCHAR2(12) NOT NULL |
An unique key identifier that represents a bank transfer transaction.
Prompt Table: BAX_HEADER_TR |
| 9 | TRANSFER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer 01=External Transfer |
| 10 | TR_WR_TEMPLATE_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
Prompt Table: TR_WR_TMPL_VW2 |
| 11 | BNK_ACCTGRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Account Group ID
Prompt Table: BNK_ACCTGRP_VW |
| 12 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: %EDITTABLE2 |
| 13 | BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
Prompt Table: BAX_ACCT_VW1 |
| 14 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: %EDITTABLE |