DR_CUST_VW

(SQL View)
Index Back

Draft Customer VW


SELECT DISTINCT D.DRAFT_BU, D.CUST_ID FROM PS_DRAFT_CONTROL D, PS_DR_ACTIVITY_VW A WHERE D.DRAFT_STATUS='A' AND D.DRAFT_BU = A.DRAFT_BU AND D.DRAFT_ID = A.DRAFT_ID AND A.DRAFT_BUSN_EVENT = 'B0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REMIT_BU Character(5) VARCHAR2(5) NOT NULL Remittance Business Unit
2 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.