CREDIT_CARD_VENDORBILLING_DATECURRENCY_CDCURRENCY_CD_BASECC_FINPOS_VW2X(SQL View) |
Index Back |
|---|---|
ProCard All BU Expense Amt - XTotal expense amount 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 A.CREDIT_CARD_VENDOR, A.BILLING_DATE, B.CURRENCY_CD, B.CURRENCY_CD_BASE, SUM(B.MERCHANDISE_AMT+ B.USETAX_PAID + B.SALETX_PAID ), SUM(B.MERCH_AMT_BSE + B.USETAX_PAID_BSE + B.SALETX_PAID_BSE) 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, B.CURRENCY_CD, B.CURRENCY_CD_BASE |
| # | 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 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | CURRENCY_CD_BASE |
Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 5 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 6 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |