AP_WC_HD_SUM_VW (SQL View)	Index Back
AP WorkCenter Amount Total by Currency for AP WorkCenter My Work Links

AP_WC_HD_SUM_VW

(SQL View)

AP WorkCenter

Amount Total by Currency for AP WorkCenter My Work Links

SELECT TXN_CURRENCY_CD , SUM(GROSS_AMT) FROM PS_AP_WC_HDR GROUP BY TXN_CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

2 AP_WC_GROSS_AMT Signed Number(33,3) DECIMAL(31,3) NOT NULL Gross Invoice Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
2	AP_WC_GROSS_AMT	Signed Number(33,3)	DECIMAL(31,3) NOT NULL	Gross Invoice Amount