CUST_CREDIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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. Prompt Table: CUSTOMER
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	Credit Limit Date
8	CR_LIMIT_CORP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Corporate Credit Limit
9	CR_LIM_CORP_RANGE	Number(3,0)	SMALLINT NOT NULL	Limit Range %
10	CR_LIMIT_CORP_DT	Date(10)	DATE	Corporate Credit Limit Date
11	CR_LIMIT_REV_DT	Date(10)	DATE	Credit Limit Review Date
12	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
13	DISPUTE_DT	Date(10)	DATE	Specifies the date that an item was placed in dispute status.
14	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.
15	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
16	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.
17	RISK_CODE	Character(2)	VARCHAR2(2) NOT NULL	Risk Code H=High L=Low M=Medium Default Value: M
18	RISK_SCORE	Number(3,0)	SMALLINT NOT NULL	Risk Score used in Receivables Collections Workbench
19	CREDIT_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Credit Class A=Class A B=Class B C=Class C
20	CREDIT_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Credit Check N=Credit Check No Y=Credit Check Yes Y/N Table Edit Default Value: N
21	CR_CHK_ALG_PROFILE	Character(1)	VARCHAR2(1) NOT NULL	Corporate Cr. Check Algorithm A=Advanced B=Basic I=Installation Default
22	CR_SUM_PROFILE	Character(1)	VARCHAR2(1) NOT NULL	Use Corporate Summary Table I=Installation Default N=No Y=Yes
23	MAX_ORDER_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Maximum Order Amount
24	CUSTCR_PCT_OVR	Number(3,0)	SMALLINT NOT NULL	% Over Limit
25	CORPCR_PCT_OVR	Number(3,0)	SMALLINT NOT NULL	% Over Limit
26	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
27	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
28	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
29	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
30	AGING_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Aging Category Prompt Table: AGING_CATEG_TBL
31	AGING_ID	Character(5)	VARCHAR2(5) NOT NULL	Aging ID Prompt Table: AGING_TBL
32	BACKLOG_DAYS	Number(4,0)	SMALLINT NOT NULL	Backlog Days
33	AR_1099C	Character(1)	VARCHAR2(1) NOT NULL	1099-c Reporting Default Value: N
34	BANKRUPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bankrupt Default Value: N
35	MARKET_VALUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Market Value
36	AR_1099C_BU	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit - ICE 2013730000 Prompt Table: SP_BUARDS_NONVW
37	PERSONALLY_LIABLE	Character(1)	VARCHAR2(1) NOT NULL	ICE 2013730000 Y/N Table Edit Default Value: N
38	DESCRLONG	Long Character	CLOB	Long Description