CUST_LSTSTDT_VW (SQL View)	Index Back
Last Statement Date View

CUST_LSTSTDT_VW

(SQL View)

Last Statement Date View

SELECT A.CRSPD_SETID , A.CRSPD_CUST_ID , A.ST_ID_NUM , A.ST_DT FROM %Table(stmt_cust) A WHERE ST_ID_NUM = ( SELECT MAX(ST_ID_NUM) FROM %Table(STMT_CUST) Z WHERE A.CRSPD_SETID = Z.CRSPD_SETID AND A.CRSPD_CUST_ID = Z.CRSPD_CUST_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL 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.

3 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number
Prompt Table: STMT_CUST

4 ST_DT Date(10) DATE Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	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.
3	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number Prompt Table: STMT_CUST
4	ST_DT	Date(10)	DATE	Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.