LC_DOC_AP_VW(SQL View) |
Index Back |
|---|---|
AP Letter of Credit Doc VW |
| SELECT A.BUSINESS_UNIT ,A.LC_ID ,B.LC_DOC_ID ,B.NBR_COPIES ,B.REQUIRED_FLAG ,B.APPROV_SUBMITTED ,B.APPROVAL_FLAG ,B.APPROVAL_DATE FROM PS_LC_HDR_AP_VW A ,PS_LC_DOCS 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 | 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 |
| 4 | NBR_COPIES | Number(3,0) | SMALLINT NOT NULL | Number of Copies |
| 5 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes |
| 6 | APPROV_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL | An internal work field that indicates whether a treasury deal review and/or confirmation transac |
| 7 | APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Item Definition Approved
A=Approved D=Denied P=Pending |
| 8 | APPROVAL_DATE | Date(10) | DATE | Approval Date |