LC_HDR_PO_VW

(SQL View)
 Index Back

Treasury L/C Information

Letter of Credit Details

SELECT BUSINESS_UNIT ,LC_ID ,LC_TYPE ,IMPORT_EXPORT_IND ,AMOUNT ,NET_AMOUNT ,CURRENCY_CD ,BUSINESS_UNIT_AP ,BUSINESS_UNIT_OM ,APPLICANT_LC ,APPLICANT_LC_BANK ,LC_NUMBER ,LC_AMEND_NBR ,FCLTY_ID ,VENDOR_SETID ,VENDOR_ID ,VNDR_LOC ,BANK_ACCT_SEQ_NBR ,BANK_CD ,ISSUE_DT ,LC_AMEND_DT ,EXPIRATION_DT ,LAST_SHIPMENT_DT ,AIRSHIPMENT ,CONTAINER_SHIPMENT ,CREDIT_CONFIRMED ,CUSTOMER_PO ,DESCR150_MIXED ,DESCR254_MIXED ,EXTENDABLE ,TRANSHIPMENT ,REVOKABLE_IND ,LC_ADVISE_BY ,ORDER_NO ,PO_ID ,PARTIAL_SHIPMENT ,PCT_GOODS ,PCT_LC ,ORIG_OPRID ,ORIG_DTTM ,LAST_MAINT_OPRID ,LAST_MAINT_DTTM ,TRANSACTION_DT ,TRANSACTION_DTTM 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

Default Value: NEXT

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 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 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.
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

8 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
9 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

Prompt Table: BUS_UNIT_TBL_OM

10 APPLICANT_LC Character(15) VARCHAR2(15) NOT NULL Treasury Letter of Credit Application

Prompt Table: LC_TR_CPTY_VW

11 APPLICANT_LC_BANK Character(5) VARCHAR2(5) NOT NULL A bank that the Treasury has applied to for a letter of credit.

Prompt Table: BANK_TR_CPTY_VW

12 LC_NUMBER Character(20) VARCHAR2(20) NOT NULL Treasury Letter of Credit Number Assigned by the Issuing Bank
13 LC_AMEND_NBR Character(10) VARCHAR2(10) NOT NULL Letter of Credit amendment number from the bank.
14 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

Prompt Table: FCLTY_DFN

15 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
17 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
18 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
19 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_TR_CPTY_VW

20 ISSUE_DT Date(10) DATE NOT NULL Issue Dt

Default Value: %date

21 LC_AMEND_DT Date(10) DATE L/C Amendment Date is used to identify the date a critical contractural item is changed.
22 EXPIRATION_DT Date(10) DATE NOT NULL Expiration Date
23 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.
24 AIRSHIPMENT Character(1) VARCHAR2(1) NOT NULL Air Shipment Permitted, Not Permitted, or Required
N=Not Permitted
R=Required
Y=Permitted

Default Value: N

25 CONTAINER_SHIPMENT Character(1) VARCHAR2(1) NOT NULL Container Whipment Permitted / Not Permitted / Required
N=Not Permitted
R=Required
Y=Permitted

Default Value: N

26 CREDIT_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Credit Confirmed Flag

Y/N Table Edit

27 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

Prompt Table: ORD_HEADER

28 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
29 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
30 EXTENDABLE Character(1) VARCHAR2(1) NOT NULL Extendable Contract
N=Not Extendable
Y=Extandable

Y/N Table Edit

31 TRANSHIPMENT Character(1) VARCHAR2(1) NOT NULL Transhipment Permitted / Not Permitted
N=Not Permitted
Y=Permitted

Default Value: N

32 REVOKABLE_IND Character(1) VARCHAR2(1) NOT NULL tIndicator showing if the letter of credit cffan be revoked.
N=No
Y=Yes
33 LC_ADVISE_BY Character(1) VARCHAR2(1) NOT NULL L/C Advise By
A=Airmail
B=Airmail With Cable
C=Cable
F=Facsimile
T=Telex
W=Wires
34 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

Prompt Table: ORD_HEADER

35 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PO_HDR

36 PARTIAL_SHIPMENT Character(1) VARCHAR2(1) NOT NULL Partial Shipment Flag
N=Not Permitted
Y=Permitted

Default Value: N

37 PCT_GOODS Number(6,2) DECIMAL(5,2) NOT NULL Goods May Deviate By
38 PCT_LC Number(6,2) DECIMAL(5,2) NOT NULL LC Amount %
39 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

Prompt Table: OPRID_VW

40 ORIG_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the original creation and saving of a given transaction.
41 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
42 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
43 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)
44 TRANSACTION_DTTM DateTime(26) TIMESTAMP Transaction Date-Time