PMT_ITEMCSH_VW

(SQL View)
 Index Back

Payment Item VW


SELECT A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.SF_DEPOSIT_ID ,C.CASHIER_OFFICE ,C.CURRENT_BUS_DT ,A.EMPLID ,A.EXT_ORG_ID ,C.SF_REGISTER ,C.CASHIER ,C.TRANS_DT ,C.TRANS_TIME ,A.POSTED_DATE ,A.SF_REVERSAL_IND ,SUM(A.PAYMENT_AMT) FROM PS_PAYMENT_TBL A ,PS_ITEM_SF B ,PS_CSH_OFF_RECEIPT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.PAYMENT_ID_NBR = B.PAYMENT_ID_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RECEIPT_NBR = C.RECEIPT_NBR GROUP BY A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.SF_DEPOSIT_ID ,C.CASHIER_OFFICE ,C.CURRENT_BUS_DT ,A.EMPLID ,A.EXT_ORG_ID ,C.SF_REGISTER ,C.CASHIER ,C.TRANS_DT ,C.TRANS_TIME ,A.POSTED_DATE ,A.SF_REVERSAL_IND

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID
5 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
6 BUSINESS_DATE Date(10) DATE Business Date
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
9 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
10 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
11 TRANS_DT Date(10) DATE Transaction Date
12 TRANS_TIME Time(15) TIMESTAMP Transaction Time
13 POSTED_DATE Date(10) DATE Date Posted
14 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
15 TOT_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount Total