SOURCE_BUS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW
LC_IDPrompt Table: LC_HDR
TR_LC_VW(SQL View) |
Index Back |
|---|---|
search for L/Cs in collateral |
| SELECT business_unit , lc_id FROM PS_LC_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW |
| 2 | LC_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table: LC_HDR |