BI_LOC_FLTR_VW

(SQL View)
Index Back

Billing WC filter

Billing WC filter for Letter of Credit

SELECT BUSINESS_UNIT , LC_ID , BILL_TO_CUST_ID FROM PS_BI_WC_LOC2_VW

# 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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer