CORP_CREDIT_VW (SQL View)	Index Back
AR Corporate Cust Credit

CORP_CREDIT_VW

(SQL View)

AR Corporate Cust Credit

SELECT A.SETID , A.TREE_NODE , A.CR_LIMIT , A.CR_LIMIT_RANGE , A.CORPCR_PCT_OVR , A.CR_LIMIT_DT , A.CR_LIMIT_REV_DT , A.DISPUTE_STATUS , A.DISPUTE_DT , A.DISPUTE_AMOUNT , A.COLLECTION_STATUS , A.COLLECTION_DT , A.RISK_CODE , A.CURRENCY_CD , A.CREDIT_CLASS , A.LAST_MAINT_OPRID FROM PS_CORP_CREDIT_AR A WHERE A.effdt = ( SELECT MAX(effdt) FROM PS_CORP_CREDIT_AR WHERE setid = A.setid AND tree_node = A.tree_node AND effdt <= %CurrentDateIn AND eff_status = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: CORP_NODE_AR.SETID

2 CORP_CUST Character(20) VARCHAR2(20) NOT NULL Corporate Customer

3 CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit

4 CR_LIMIT_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %

5 CORPCR_PCT_OVR Number(3,0) SMALLINT NOT NULL % Over Limit

6 CR_LIMIT_DT Date(10) DATE Credit Limit Date

7 CR_LIMIT_REV_DT Date(10) DATE Credit Limit Review Date

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.
Prompt Table: DISPUTE_TBL

9 DISPUTE_DT Date(10) DATE Specifies the date that an item was placed in dispute status.

10 DISPUTE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.

11 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.
Prompt Table: COLLECTION_TBL

12 COLLECTION_DT Date(10) DATE Specifies the date that a customer or invoice was put in collection status. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.

13 RISK_CODE Character(2) VARCHAR2(2) NOT NULL Risk Code
H=High
L=Low
M=Medium

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CUSTOMER.CURRENCY_CD

15 CREDIT_CLASS Character(2) VARCHAR2(2) NOT NULL Credit Class
A=Class A
B=Class B
C=Class C

16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: CORP_NODE_AR.SETID
2	CORP_CUST	Character(20)	VARCHAR2(20) NOT NULL	Corporate Customer
3	CR_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Limit
4	CR_LIMIT_RANGE	Number(3,0)	SMALLINT NOT NULL	Limit Range %
5	CORPCR_PCT_OVR	Number(3,0)	SMALLINT NOT NULL	% Over Limit
6	CR_LIMIT_DT	Date(10)	DATE	Credit Limit Date
7	CR_LIMIT_REV_DT	Date(10)	DATE	Credit Limit Review Date
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. Prompt Table: DISPUTE_TBL
9	DISPUTE_DT	Date(10)	DATE	Specifies the date that an item was placed in dispute status.
10	DISPUTE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.
11	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. Prompt Table: COLLECTION_TBL
12	COLLECTION_DT	Date(10)	DATE	Specifies the date that a customer or invoice was put in collection status. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
13	RISK_CODE	Character(2)	VARCHAR2(2) NOT NULL	Risk Code H=High L=Low M=Medium
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CUSTOMER.CURRENCY_CD
15	CREDIT_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Credit Class A=Class A B=Class B C=Class C
16	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID