LENDER_OE_CDDefault Value: 0000
Default Value: LENDER_TBL.DESCR
Default Value: LENDER_LOAD_TBL.DFLT_GUAR
Prompt Table: GUARANTOR_TBL
Prompt Table: SERV_SRCH
Y/N Table Edit
Prompt Table: GUARANTOR_TBL
C=Compuserve
I=Internet
LENDER_LDTBL_VW(SQL View) |
Index Back |
|---|---|
Lender Load TablePrompt record for Lenders (Master Lender list) |
| SELECT LENDER_OE_CD, LENDER_OE_BRNCH, DESCR, DESCRSHORT, DFLT_GUAR, DFLT_DEST_BR, PREF_LENDER, GUAR_UNQ_ID, MAILBOX_ID, MAILBOX_TYPE FROM PS_LENDER_LOAD_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LENDER_OE_CD |
Character(6) | VARCHAR2(6) NOT NULL | Lender OE Code |
| 2 | LENDER_OE_BRNCH | Character(4) | VARCHAR2(4) NOT NULL |
Lender OE Branch
Default Value: 0000 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: LENDER_TBL.DESCR |
| 5 | DFLT_GUAR | Character(3) | VARCHAR2(3) NOT NULL |
Default Guarantor
Default Value: LENDER_LOAD_TBL.DFLT_GUAR Prompt Table: GUARANTOR_TBL |
| 6 | DFLT_DEST_BR | Character(10) | VARCHAR2(10) NOT NULL |
Default Destination
Prompt Table: SERV_SRCH |
| 7 | PREF_LENDER | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Lender
Y/N Table Edit |
| 8 | GUAR_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Guarantor ID
Prompt Table: GUARANTOR_TBL |
| 9 | MAILBOX_ID | Character(40) | VARCHAR2(40) NOT NULL | Mailbox ID |
| 10 | MAILBOX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Mailbox Type
C=Compuserve I=Internet |