BUSINESS_UNITLC_IDBACK=Back to Back
DPAY=Deferred Payment
GVMT=Government
OTH=Other
RED=Red Clause
REVL=Revolving
SBY=Standby
TRAV=Traveler's
XFER=Transferable
E=Export Letter of Credit
I=Import Letter of Credit
LC_INQ_VW(SQL View) |
Index Back |
|---|---|
Letter of Credit Inquiry View |
| SELECT BUSINESS_UNIT , LC_ID , LC_TYPE , IMPORT_EXPORT_IND , LC_NUMBER , ISSUE_DT , AMOUNT , CURRENCY_CD FROM PS_LC_HDR |
| # | 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_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Treasury Letter of Credit Type idicates the kind of letter of credit that has been issued by a bank. For example, Standy By L/C, or Revocable L/C.
BACK=Back to Back DPAY=Deferred Payment GVMT=Government OTH=Other RED=Red Clause REVL=Revolving SBY=Standby TRAV=Traveler's XFER=Transferable |
| 4 | IMPORT_EXPORT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Import or Export Letter of Credit Indication
E=Export Letter of Credit I=Import Letter of Credit |
| 5 | LC_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | Treasury Letter of Credit Number Assigned by the Issuing Bank |
| 6 | ISSUE_DT | Date(10) | DATE | Issue Dt |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |