BI_LC_SPNSR_VW

(SQL View)
 Index Back

LOC Prompt View Run Control

Letter Of Credit Prompt View for Run Control page

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.