OMLC_HDR2_VW(SQL View) |
Index Back |
|---|---|
OM Letter of Credit Doc VW |
| SELECT A.BUSINESS_UNIT, B.BUSINESS_UNIT, A.BILL_TO_CUST_ID, A.LC_ID, B.LC_DOC_ID, B.REQUIRED_FLAG, B.APPROV_SUBMITTED, B.APPROVAL_FLAG, B.APPROVAL_DATE FROM PS_OMLC_HDR1_VW A, PS_LC_DOCS 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 | LC_DOC_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Treasury Letter of Credit Document Identification
AINS=Air Insurance AIRB=Airway Bill BLAD=Bill of Lading CERT=Certificate of Origin CUST=Customs Documents INS=Insurance INV=Commercial Invoice MINS=Marine Insurance OBOL=Ocean Bill of Lading OCEA=Ocean Bill of Lading RAIL=Railroad Bill of Lading SCUS=Special Customs Invoice TRUK=Truck Bill of Lading WAR=War Risk Insurance |
| 6 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes |
| 7 | APPROV_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL | An internal work field that indicates whether a treasury deal review and/or confirmation transac |
| 8 | APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Item Definition Approved
A=Approved D=Denied P=Pending |
| 9 | APPROVAL_DATE | Date(10) | DATE | Approval Date |