CC_FINPOS_VW3X (SQL View)	Index Back
ProCard Expense Date - X List of billing dates that have been paid for all business units (exclusive tax). (Exclusive) Bank statement tracks the purchase amount and the tax amount in separate fields. Total billing amount is the sum of the purchase amount and tax amount.

CC_FINPOS_VW3X

(SQL View)

ProCard Expense Date - X

List of billing dates that have been paid for all business units (exclusive tax). (Exclusive) Bank statement tracks the purchase amount and the tax amount in separate fields. Total billing amount is the sum of the purchase amount and tax amount.

select DISTINCT A.CREDIT_CARD_VENDOR, A.BILLING_DATE, SUM(B.MERCHANDISE_AMT+ B.USETAX_PAID + B.SALETX_PAID ) from PS_CC_TRANS_LINE A, PS_CC_TRANS_DIST B where A.INCLUDE_TAX = 'N' 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 < '4' group by A.CREDIT_CARD_VENDOR, A.BILLING_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BILLING_DATE Date(10) DATE Billing Date

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

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