NET_STG_HDR_VW2

(SQL View)
 Index Back

Netting Stage Header VW2


SELECT NET_REF_ID , NET_HDR_STATUS , DESCR FROM PS_NET_STG_HDR WHERE NET_HDR_STATUS = 'A'

  • Related Language Record: NET_STG_VW2_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NET_REF_ID Character(12) VARCHAR2(12) NOT NULL A reference identifier associated with a cash transaction subject to netting with a given bank/count

    Prompt Table: NET_STG_HDR

    2 NET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the status of a given Netting Run: Open Approve Cancel Close
    A=Approved
    C=Closed
    O=Open
    X=Cancelled
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description