STMT_BFWD_VW

(SQL View)
 Index Back

SELECT C.CRSPD_SETID , C.CRSPD_CUST_ID , B.ST_ID_NUM , B.BUSINESS_UNIT , B.CUST_ID , X.BALFWD_BAL_CUR , X.BALFWD_BAL_AMT FROM PS_STMT_CUST C , PS_STMT_CUST_BFWD B , PS_STMT_CUST_BFWD X WHERE C.CRSPD_SETID = B.CRSPD_SETID AND C.CRSPD_CUST_ID = B.CRSPD_CUST_ID AND C.ST_ID_NUM = B.ST_ID_NUM AND X.CRSPD_SETID = B.CRSPD_SETID AND X.CRSPD_CUST_ID = B.CRSPD_CUST_ID AND X.ST_ID_NUM = ( SELECT MAX(Y.ST_ID_NUM) FROM PS_STMT_CUST Y , PS_STMT_CUST_BFWD Z WHERE Y.CRSPD_SETID = C.CRSPD_SETID AND Y.CRSPD_CUST_ID = C.CRSPD_CUST_ID AND Y.CRSPD_SETID = Z.CRSPD_SETID AND Y.CRSPD_CUST_ID = Z.CRSPD_CUST_ID AND Y.ST_ID_NUM = Z.ST_ID_NUM AND B.BUSINESS_UNIT = Z.BUSINESS_UNIT AND Y.ST_DT < C.ST_DT AND Y.ST_STATUS = 'A' AND C.ST_ID_TYPE = 'B')

# 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_SETID_NONVW

2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

Prompt Table: CRSPD_CUST_D_VW

3 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number

Prompt Table: STMT_CUST

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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.
6 BALFWD_BAL_CUR Character(3) VARCHAR2(3) NOT NULL Currency Code - BalFwd Amount
7 BALFWD_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance Forward