CRCHK_CORP_VW

(SQL View)

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

#	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