CORP_CREDIT_AR2 (SQL Table)	Index Back
AR Corporate Cust Credit

CORP_CREDIT_AR2

(SQL Table)

AR Corporate Cust Credit

# 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 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
Default Value: CORP_NODE_AR.TREE_NODE

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

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

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

7 CR_LIMIT_DT Date(10) DATE NOT NULL Credit Limit Date

8 CR_LIMIT_REV_DT Date(10) DATE Credit Limit Review Date

9 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

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

11 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.

12 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

13 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.

14 RISK_CODE Character(2) VARCHAR2(2) NOT NULL Risk Code
H=High
L=Low
M=Medium
Default Value: M

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

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

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

18 DATE_LAST_MAINT Date(10) DATE Date Last Maintained

#	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	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name Default Value: CORP_NODE_AR.TREE_NODE
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	CR_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Limit
6	CR_LIMIT_RANGE	Number(3,0)	SMALLINT NOT NULL	Limit Range %
7	CR_LIMIT_DT	Date(10)	DATE NOT NULL	Credit Limit Date
8	CR_LIMIT_REV_DT	Date(10)	DATE	Credit Limit Review Date
9	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
10	DISPUTE_DT	Date(10)	DATE	Specifies the date that an item was placed in dispute status.
11	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.
12	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
13	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.
14	RISK_CODE	Character(2)	VARCHAR2(2) NOT NULL	Risk Code H=High L=Low M=Medium Default Value: M
15	CREDIT_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Credit Class A=Class A B=Class B C=Class C Default Value: A
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CUSTOMER.CURRENCY_CD
17	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
18	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained