QUICK_POST_VW

(SQL View)
 Index Back

Quick Post Activity VW


SELECT BUSINESS_UNIT ,OPRID ,GRP_TIMESTAMP ,LINE_SEQ_NBR ,ACCOUNT_TYPE_SF ,ITEM_TYPE ,ITEM_EFFECTIVE_DT ,DESCR ,EMPLID ,EXT_ORG_ID ,DUE_DT ,REF1_DESCR ,ACAD_YEAR ,ITEM_AMT ,POST_DT ,POST_FLAG ,SSF_ERROR_WARN ,ACCOUNT_NBR ,ACCOUNT_TERM ,ITEM_NBR ,STRM ,ADM_APPL_NBR ,PAYMENT_ID_NBR ,PAYMENT_METHOD ,LINE_ACTION ,BILLING_DT ,INVOICE_ID FROM PS_QUICK_POST_TBL

  • Related Language Record: QUICK_POSTVWLNG

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    Prompt Table: OPR_DEF_TBL_CS

    3 GRP_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Group Line Time Stamp
    4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

    Prompt Table: ACCT_TYP_TBL_SF

    6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: SP_ITACC_NONVW

    7 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date

    Default Value: %DATE

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    10 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    11 DUE_DT Date(10) DATE Due Date
    12 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    13 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    14 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    15 POST_DT Date(10) DATE The Date a transaction was Posted.
    16 POST_FLAG Character(1) VARCHAR2(1) NOT NULL Line Post Flag
    D=Deleted
    N=Not Posted
    Y=Posted

    Y/N Table Edit

    Default Value: N

    17 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning
    18 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    19 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    20 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    21 STRM Character(4) VARCHAR2(4) NOT NULL Term
    22 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    23 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

    Prompt Table: PAYMENT_TBL_VW

    24 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DB=Debit Card
    EC=Electronic Check
    EFT=Electronic Funds Transfer
    LBX=Lockbox
    TPC=Third Party Check
    WIR=Wire Transfer
    25 LINE_ACTION Character(3) VARCHAR2(3) NOT NULL Line Action
    APP=Application Generated
    BCK=Backing Out Term Fees
    CCP=Credit Card Payment
    CRV=Charge Reversal
    CSH=Cashiering
    GRP=Group Posting
    INT=Multi Year Interest Calc
    LAT=Late Fee Processing
    NRA=Tax Calculations
    PAY=Payment Posted
    PMT=Excess Payment
    QBK=Quick Post Back Up
    QCK=Posting Page
    REF=Refund Processing
    SSP=Self service payment
    SYS=System Generated
    TAX=Tax Adjustment Page
    TPA=Third Party - Online
    TUI=Tuition Calculation
    WRO=Writeoff Processing
    26 BILLING_DT Date(10) DATE Billing Date
    27 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number