BUSINESS_UNITBUSINESS_UNIT_BIBILL_TO_CUST_IDLC_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
OMLC_HDR3_VW(SQL View) |
Index Back |
|---|---|
OM_LC_STATUS_VWSELECT A.BUSINESS_UNIT, A.BILL_TO_CUST_ID, A.LC_ID, B.STATUS_DT, B.LC_STATUS FROM PS_OM_LC_HDR_VW A, PS_LC_STATUS B WHERE A.LC_ID = B.LC_ID |
| SELECT DISTINCT A.BUSINESS_UNIT , B.BUSINESS_UNIT , A.BILL_TO_CUST_ID, A.LC_ID, B.STATUS_DT, B.LC_STATUS FROM PS_OMLC_HDR1_VW A, PS_LC_STATUS B WHERE A.BUSINESS_UNIT_BI = 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 | BUSINESS_UNIT_BI |
Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 3 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 4 | LC_ID |
Character(12) | VARCHAR2(12) NOT NULL | Treasury Letter of Credit Number Assigned by the System |
| 5 | STATUS_DT |
Date(10) | DATE NOT NULL | Status Date |
| 6 | 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 |