SETIDPrompt Table: SP_SETID_NONVW
BANK_CDPrompt Table: BANK_CD_TBL
BANK_CD_CPTYPrompt Table: BANK_CD_INT_VW
BANK_ACCT_KEYPrompt Table: BANK_ACCT_TBL
EFFDTDefault Value: %DATE
A=Active
I=Inactive
Default Value: A
Default Value: 360
BANK_HURDLE_RTE(SQL Table) |
Index Back |
|---|---|
Bank Hurdle/Discount RateBank Hurdle Discount Evaluation Rate. This rate is used to evaluate (if setup) if it is better to take the discount and pay the supplier or to wait for the complete maturity date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 3 | BANK_CD_CPTY |
Character(5) | VARCHAR2(5) NOT NULL |
An internal key field convention that facilitates the system distinction between banks and counterparties.
Prompt Table: BANK_CD_INT_VW |
| 4 | 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: BANK_ACCT_TBL |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %DATE |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | HURDLE_RATE | Number(9,5) | DECIMAL(8,5) NOT NULL | Interest Rate |
| 8 | DAYS_IN_YEAR | Number(3,0) | SMALLINT NOT NULL |
Days in Year
Default Value: 360 |