PeopleSoft 9.0 Cash Management |
Table Name | FCLTY_DFN |
Table Description |
FCLTY_DFN |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | Yes |
FCLTY_ID | CHAR(12) | Yes | No |
EFFDT | PSDATE | Yes | No |
EFF_STATUS | CHAR(1) | No | No |
DESCR | CHAR(30) | No | No |
FCLTY_TYPE | CHAR(1) | No | No |
REVIEW_DT | PSDATE | No | No |
EXPIRATION_DT | PSDATE | No | No |
BANK_CD | CHAR(5) | No | Yes |
REVIEW_STATUS | CHAR(1) | No | No |
ISSUER_CD | CHAR(5) | No | No |
GUARANTOR_CD | CHAR(5) | No | No |
FACILITY_TYPE | CHAR(1) | No | No |
AMOUNT | DECIMAL(26,3) | No | No |
CURRENCY_CD | CHAR(3) | No | No |
AMOUNT_2 | DECIMAL(26,3) | No | No |
FCLTY_COMMIT_FLG | CHAR(1) | No | No |
FCLTY_REVOLVE_FLG | CHAR(1) | No | No |
FCLTY_CONVERT_FLG | CHAR(1) | No | No |
FCLTY_CPBACKUP_FLG | CHAR(1) | No | No |
TRANSACTION_RATE | DECIMAL(15,8) | No | No |
FCLTY_CMTFEE_CLC | CHAR(1) | No | No |
REPEAT_INTERVAL | CHAR(3) | No | No |
AMOUNT_3 | DECIMAL(26,3) | No | No |
FLOATING_MKT_CD | CHAR(10) | No | No |
INT_BASIS | CHAR(2) | No | No |
FLOATING_MARGIN | DECIMAL(11,8) | No | No |
TRANSACTION_RATE_2 | DECIMAL(15,8) | No | No |
RESET_INDEX_TENOR | CHAR(3) | No | No |
FLT_MARGIN_OP | CHAR(1) | No | No |
RT_TYPE | CHAR(5) | No | No |
Index |
Name | Type | Unique | Member |
PS_FCLTY_DFN | PK | Yes |
![]() |
Member(s) of "PS_FCLTY_DFN" Index |
SETID |
FCLTY_ID |
EFFDT |
Published April 30, 2007 |