LC_HDR_AP_VW(SQL View) |
Index Back |
|---|---|
Payables L/C InformationPayables - Letter of Credit |
| SELECT A.BUSINESS_UNIT_AP ,A.VENDOR_ID ,A.LC_ID ,A.BUSINESS_UNIT ,A.LC_TYPE ,A.IMPORT_EXPORT_IND ,A.AMOUNT ,A.NET_AMOUNT ,A.LC_NUMBER ,A.LC_AMEND_NBR ,A.VENDOR_SETID ,A.BANK_CD ,A.ISSUE_DT ,A.LC_AMEND_DT ,A.EXPIRATION_DT ,A.LAST_SHIPMENT_DT ,A.PO_ID ,A.CURRENCY_CD FROM PS_LC_HDR A WHERE A.IMPORT_EXPORT_IND = 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | LC_ID |
Character(12) | VARCHAR2(12) NOT NULL | Treasury Letter of Credit Number Assigned by the System |
| 4 | BUSINESS_UNIT_TR | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | 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 |
| 6 | 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 |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | NET_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The resulting net amount related to settlement cash flows subject to counterparty netting agreements. |
| 9 | LC_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | Treasury Letter of Credit Number Assigned by the Issuing Bank |
| 10 | LC_AMEND_NBR | Character(10) | VARCHAR2(10) NOT NULL | Letter of Credit amendment number from the bank. |
| 11 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 12 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 13 | ISSUE_DT | Date(10) | DATE NOT NULL |
Issue Dt
Default Value: %date |
| 14 | LC_AMEND_DT | Date(10) | DATE | L/C Amendment Date is used to identify the date a critical contractural item is changed. |
| 15 | EXPIRATION_DT | Date(10) | DATE NOT NULL | Expiration Date |
| 16 | LAST_SHIPMENT_DT | Date(10) | DATE | Treasury Letter of Credit last shipment date. This is the latest date on which transportation of the goods described in the letter of credit can arrive at the final destination. |
| 17 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |