EX_MRCH_VW2

(SQL View)
Index Back

Preferred vs Non-pref.Merchant

Preferred vs Non-pref.Merchant spending

SELECT H.SETID , H.BUSINESS_UNIT_GL , L.TRANS_DT , L.EXPENSE_TYPE , T.DESCR , L.MERCHANT_CD , L.MERCHANT , L.MONETARY_AMOUNT , L.CURRENCY_CD FROM PS_EX_SHEET_HDR H , PS_EX_SHEET_LINE L , PS_EX_TYPES_TBL T WHERE H.SHEET_ID = L.SHEET_ID AND H.SHEET_STATUS NOT IN ('CLS','ESC','DEN','DNA','DNU','PND') AND L.EXPENSE_TYPE = T.EXPENSE_TYPE AND T.SETID = H.SETID AND %EffdtCheck(EX_TYPES_TBL, T, %CurrentDateIn) AND T.EFF_STATUS = 'A' AND T.MERCHANT_REQD_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 TRANS_DT Date(10) DATE Transaction Date
4 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

Prompt Table: EX_TYPES_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant

Prompt Table: EX_MERCHANT_VW1

7 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
8 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL