CRCHK_CORP_VW

(SQL View)
Index Back

SELECT CST.CORPORATE_SETID , CST.CORPORATE_CUST_ID , CST.SETID , CST.CUST_ID , CST.NAME1 , CRD.CREDIT_CHECK , CRD.COLLECTION_STATUS , CRD.DISPUTE_STATUS , CRD.AGING_ID , CRD.AGING_CATEGORY FROM PS_CUSTOMER CST , PS_CUST_CREDIT CRD WHERE %Join(COMMON_KEYS, CUSTOMER CST, CUST_CREDIT CRD) AND CST.CUST_STATUS IN ('A','I') AND CST.BILL_TO_FLG = 'Y' AND %EffdtCheck(CUST_CREDIT CRD2, CRD, %CurrentDateIn) AND CRD.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 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.
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
N=Credit Check No
Y=Credit Check Yes
7 COLLECTION_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
8 DISPUTE_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
9 AGING_ID Character(5) VARCHAR2(5) NOT NULL Aging ID
10 AGING_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category