OC_LAST_VW (SQL View)	Index Back
Last Customer Overdue Charge

OC_LAST_VW

(SQL View)

Last Customer Overdue Charge

SELECT crspd_setid , crspd_cust_id , MAX(oc_id_num) , business_unit , cust_id FROM PS_OC_CUST_DTL GROUP BY crspd_setid , crspd_cust_id , business_unit , cust_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETCS_NONVW

2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer
Prompt Table: CRSPD_CUST_D_VW

3 OC_ID_NUM Number(8,0) INTEGER NOT NULL Overdue Charge Number

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW
Set Control Field: BUSINESS_UNIT

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETCS_NONVW
2	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer Prompt Table: CRSPD_CUST_D_VW
3	OC_ID_NUM	Number(8,0)	INTEGER NOT NULL	Overdue Charge Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW Set Control Field: BUSINESS_UNIT
5	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.