CSH_OFF_POST_VW

(SQL View)
 Index Back

Cashier Office Receipts


SELECT DISTINCT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.RECEIPT_NBR ,A.CURRENT_BUS_DT ,A.CASHIER ,A.SF_REGISTER ,A.EMPLID ,A.CO_TRANS_TYPE ,A.TOTAL_AMOUNT_SF ,A.TRANS_DT ,A.TRANS_TIME ,A.EXT_ORG_ID ,A.RECEIPT_NBR_BD ,A.SSF_APPR_STATUS ,A.REF1_DESCR ,A.CONTRACT_NUM ,A.CONTRACT_EMPLID ,A.CURRENCY_CD FROM PS_CSH_OFF_RECEIPT A , PS_CSH_OFF_RCPT_L B , PS_TARGET_KEY_TBL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CASHIER_OFFICE = B.CASHIER_OFFICE AND A.RECEIPT_NBR = B.RECEIPT_NBR AND B.TAX_ROW <> 'Y' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.TARGET_KEY = C.TARGET_KEY AND C.POST_TARGET = 'Y' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_TARGET_KEY_TBL C1 WHERE C.BUSINESS_UNIT = C1.BUSINESS_UNIT AND C.TARGET_KEY = C1.TARGET_KEY AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Parent record: CSH_OFF_TBL

    • # 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 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office

    Default Value: OPR_DEF_TBL_CS.CASHIER_OFFICE

    Prompt Table: SP_CSHOFF_NONVW

    3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number

    Default Value: 999999999999

    4 CURRENT_BUS_DT Date(10) DATE Current Business Date
    5 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
    6 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    8 CO_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL Cashier Office Trans Type
    01=Open Register
    02=Student Payment
    03=Departmental Receipt
    04=Cash Check
    05=Cash Withdrawl
    06=Close Register
    07=Interim Deposit
    08=Corporate Payment
    09=Cash Replenishment
    9 TOTAL_AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Amount
    10 TRANS_DT Date(10) DATE Transaction Date
    11 TRANS_TIME Time(15) TIMESTAMP Transaction Time
    12 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    13 RECEIPT_NBR_BD Number(12,0) DECIMAL(12) NOT NULL Business Date Sequence Nbr

    Default Value: 999999999999

    14 SSF_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag .
    A=Approved
    C=Cancelled
    D=Denied
    G=Group Post
    N=Not Posted
    P=Pending
    T=Posted
    U=Unprocessed
    V=Voided
    X=Delayed Post
    Z=Processed
    15 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    16 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    17 CONTRACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contract ID
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code