ARFO_PRPSCUS_VW

(SQL View)
Index Back

Past Due Item User Cust List

AR Financial Operation Past Due Item User Preference - Customer List

SELECT OPRID , CUSTOMER_SETID , CUST_ID , CUST_PARENT_FLG FROM %Table(ARFO_PRFPST_CUS) WHERE CUST_PARENT_FLG = 'Y'

  • Parent record: ARFO_PRF_PSTDUE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: ARFO_PRF_PSTDUE.OPRID

    2 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Prompt Table: SP_SETCU_NONVW

    3 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: AR_CUSTSCHC_VW

    4 CUST_PARENT_FLG Character(1) VARCHAR2(1) NOT NULL Customer Parent Flag

    Y/N Table Edit

    Default Value: Y