BUSINESS_UNITLC_IDSTATUS_DT01=Requested By Internal Unit
02=Request Made to Issuing Bank
03=Open
04=Expired
05=Cancelled
06=Incorporated into Another L/C
07=Open, But Past Expiration
LC_STAT_AP_VW(SQL View) |
Index Back |
|---|---|
LC_STAT_AP_VW |
| SELECT A.BUSINESS_UNIT , A.LC_ID , B.STATUS_DT , B.LC_STATUS FROM PS_LC_HDR_AP_VW A , PS_LC_STATUS B WHERE A.BUSINESS_UNIT_TR = B.BUSINESS_UNIT AND A.LC_ID = B.LC_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LC_ID |
Character(12) | VARCHAR2(12) NOT NULL | Treasury Letter of Credit Number Assigned by the System |
| 3 | STATUS_DT |
Date(10) | DATE NOT NULL | Status Date |
| 4 | LC_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Letter of Credit Status
01=Requested By Internal Unit 02=Request Made to Issuing Bank 03=Open 04=Expired 05=Cancelled 06=Incorporated into Another L/C 07=Open, But Past Expiration |