BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW
LC_IDDefault Value: NEXT
Prompt Table: LC_ID_VW
LC_HDR_IMP_VW(SQL View) |
Index Back |
|---|---|
Redefined LC Transaction ViewUse LC_HDR to redefine for the LC_HDR_IMP_VW_SBP. |
| SELECT BUSINESS_UNIT , LC_ID , LC_NUMBER , DESCR150_MIXED FROM PS_LC_HDR WHERE IMPORT_EXPORT_IND = 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business 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
Default Value: NEXT Prompt Table: LC_ID_VW |
| 3 | LC_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | Treasury Letter of Credit Number Assigned by the Issuing Bank |
| 4 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |