CUST_CRSPD

#	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
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_AR_BR_VW
6	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank Prompt Table: BANK_AR_R_VW
7	CRSPD_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Address C=Contact Address D=Override I=Item Address P=Primary Address Default Value: P
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: CUST_ADDR_CR_VW
9	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: CUST_CNCT_EF_VW
10	ONE_DOCUMENT_PER	Character(1)	VARCHAR2(1) NOT NULL	One Document Per B=Business Unit S=SETID Default Value: S
11	DUN_ID	Character(5)	VARCHAR2(5) NOT NULL	Dunning ID Prompt Table: DUNNING_TBL
12	DUN_GROUP	Character(2)	VARCHAR2(2) NOT NULL	Dunning Group %=All Groups A=Group A B=Group B C=Group C D=Group D
13	DUN_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Dunning Hold Y/N Table Edit Default Value: N
14	DUN_HOLD_DT	Date(10)	DATE	Dunning Hold Date
15	ST_ID	Character(5)	VARCHAR2(5) NOT NULL	Statement ID Prompt Table: STATEMENT_TBL
16	ST_GROUP	Character(2)	VARCHAR2(2) NOT NULL	Statement Group %=All Statement Groups A=Group A B=Group B C=Group C D=Group D
17	ST_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Statement Hold Y/N Table Edit Default Value: N
18	ST_HOLD_DT	Date(10)	DATE	Statement Hold Date
19	CRSPD_CNTCT	Character(1)	VARCHAR2(1) NOT NULL	Contact D=Override P=Primary Contact S=Suppress Contact Default Value: S
20	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code Default Value: PSOPTIONS.LANGUAGE_CD
21	OC_GROUP	Character(2)	VARCHAR2(2) NOT NULL	Overdue Charge Group %=All Overdue Charge Groups A=Group A B=Group B C=Group C D=Group D
22	OC_ADMIN_ID	Character(5)	VARCHAR2(5) NOT NULL	Overdue Charge Admin ID Prompt Table: OC_ADMIN_VW
23	OC_ADMIN_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Overdue Charge Admin Hold Y/N Table Edit Default Value: N
24	OC_ADMIN_HOLD_DT	Date(10)	DATE	Overdue Charge Admin Hold Date
25	OC_FIN_ID	Character(5)	VARCHAR2(5) NOT NULL	Overdue Charge Finance ID Prompt Table: OC_FIN_VW
26	OC_FIN_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Overdue Charge Finance Hold Y/N Table Edit Default Value: N
27	OC_FIN_HOLD_DT	Date(10)	DATE	Overdue Charge Fin Hold Date
28	OC_PNLTY_ID	Character(5)	VARCHAR2(5) NOT NULL	Overdue Charge Penalty ID Prompt Table: OC_PNLTY_VW
29	OC_PNLTY_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Overdue Charge Penalty Hold Y/N Table Edit Default Value: N
30	OC_PNLTY_HOLD_DT	Date(10)	DATE	Overdue Charge Pen Hold Date
31	ASSESS_OC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Assess Overdue Charges Y/N Table Edit Default Value: Y
32	VIEW_STMT_IMAG_CWB	Character(1)	VARCHAR2(1) NOT NULL	Field used to determine if Statment Images will be generated to be displayed as attachment at Collection Workbench in Receivables N=No Y=Yes
33	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
34	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
35	VIEW_DUN_IMAG_CWB	Character(1)	VARCHAR2(1) NOT NULL	View Dunning Image N=No Y=Yes