NET_STG_AR_VW

(SQL View)
 Index Back

Netting Stage AR View

Thsi view is used in the function Is_Item_Tageed_in_another_Group.

SELECT D.NET_REF_ID , D.NETTING_SEQ_NO , D.BUSINESS_UNIT , D.CUST_ID , D.ITEM , D.ITEM_LINE , H.NET_HDR_STATUS FROM PS_NET_STG_AR D , PS_NET_STG_HDR H WHERE D.NET_REF_ID = H.NET_REF_ID

  • Parent record: NET_STG_HDR

    • # 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
    2 NETTING_SEQ_NO Number(10,0) DECIMAL(10) NOT NULL Netting Sequence Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: NET_AR_BU_VW

    4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: NET_ITM_CUST_VW

    5 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

    Prompt Table: NET_ITEM_VW

    6 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

    Prompt Table: NET_ITEM_LN_VW

    7 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