BI_LOC_SRCH_VW (SQL View)	Index Back
LOC Summary Search View Letter of Credit Summary Search View

BI_LOC_SRCH_VW

(SQL View)

LOC Summary Search View

Letter of Credit Summary Search View

SELECT DISTINCT LC_ID , BILL_TO_CUST_ID , BUSINESS_UNIT , MIN(BI_CURRENCY_CD) FROM PS_BI_HDR WHERE BILL_STATUS IN ('TMP', 'TMR', 'NEW', 'PND', 'RDY', 'HLD', 'INV', 'FNL') AND PC_DISTRIB_STATUS <> 'I' AND LOC_DOC_ID <> ' ' AND LC_ID <> ' ' AND CONSOL_HDR = 'N' GROUP BY LC_ID, BILL_TO_CUST_ID, BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
2	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code