CC_FINPOS_VW3 (SQL View)	Index Back
ProCard Expense Date List of billing dates that have been paid for all business units. (Inclusive) Bank statement combines the purchase amount and the tax amount in one field (merchandise_amt). Total billing amount is actually the same as the merchandise amount.

CC_FINPOS_VW3

(SQL View)

ProCard Expense Date

List of billing dates that have been paid for all business units. (Inclusive) Bank statement combines the purchase amount and the tax amount in one field (merchandise_amt). Total billing amount is actually the same as the merchandise amount.

SELECT DISTINCT A.BUSINESS_UNIT , A.CREDIT_CARD_VENDOR , A.BILLING_DATE , SUM(B.MERCHANDISE_AMT) , A.CURRENCY_CD FROM PS_CC_TRANS_LINE A , PS_CC_TRANS_DIST B WHERE A.INCLUDE_TAX = 'Y' AND A.CC_STATUS <> '4' AND A.EMPLID = B.EMPLID AND A.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND A.CRDMEM_ACCT_NBR = B.CRDMEM_ACCT_NBR AND A.TRANS_NBR = B.TRANS_NBR AND A.TRANS_DT = B.TRANS_DT AND A.DTTM_STAMP = B.DTTM_STAMP AND B.CC_POST_STATUS = '3' GROUP BY A.BUSINESS_UNIT, A.CREDIT_CARD_VENDOR, A.BILLING_DATE, A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor

3 BILLING_DATE Date(10) DATE Billing Date

4 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
3	BILLING_DATE	Date(10)	DATE	Billing Date
4	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code