LC_DOCS(SQL Table) |
Index Back |
|---|---|
Treasury L/C DocumentsTreasury Letter of Credit Documents |
| # | 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 Y/N Table Edit |
| 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 |