ARFO_PRF_PSTDUE

(SQL Table)
 Index Back

Past Due Items User Preference

AR Financial Operation Past Due Items User Preference

  • Parent Record Of ARFO_PFON_CSTGR ARFO_PRFDBT_CUG ARFO_PRFDBT_CUS ARFO_PRFDBT_CVW ARFO_PRFDBT_RSP ARFO_PRFDISP_BU ARFO_PRFDIS_CUS ARFO_PRFDIS_RSP ARFO_PRFONAC_BU ARFO_PRFONA_RSP ARFO_PRFPSTD_BU ARFO_PRFPST_CGR ARFO_PRFPST_CUS ARFO_PRFPST_RSP ARFO_PRF_DBT_BU ARFO_PRPSCUS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BU_SELECT_FLG Character(1) VARCHAR2(1) NOT NULL Business Units
    A=All
    S=Specific

    Default Value: S

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETCU_NONVW

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

    5 CUST_LEVEL_QRY Character(1) VARCHAR2(1) NOT NULL Customer Level
    C=Corporate
    N=No Relationship
    P=Correspondence
    R=Remit From
    6 RESP_PART_OPT Character(1) VARCHAR2(1) NOT NULL RESP_PART_OPT
    A=AR Specialist
    B=Broker
    C=Collector
    R=Credit Analyst
    S=Sales Person

    Default Value: C

    7 RESP_TOP5_FLG Character(1) VARCHAR2(1) NOT NULL RESP_TOP5_FLG
    A=All
    S=Specific
    T=Top Five

    Default Value: T

    8 CUST_SELECT_FLG Character(1) VARCHAR2(1) NOT NULL Customer Select Flag
    A=All
    G=Customer Groups
    S=Specific

    Default Value: A

    9 BLK_CUST_GRP Character(1) VARCHAR2(1) NOT NULL Include Blank Customer Group
    N=NO
    Y=YES

    Y/N Table Edit

    Default Value: N

    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW