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 |