PYFRCST_CYCLE

(SQL Table)
 Index Back

AP Payment Forcast Definition

  • Parent Record Of AP_AGING_AGE AP_AGING_AGE_LG AP_AGING_TAO PYFRCST_AGE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PYFRCST_CYCLE_ID Character(5) VARCHAR2(5) NOT NULL Payment Forecast Cycle ID
    2 PAY_FROM_DT Date(10) DATE NOT NULL Pay From Date

    Default Value: %date

    3 PAY_THRU_DT Date(10) DATE NOT NULL Pay Through Date
    4 CREATION_DT Date(10) DATE Creation Date
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 PROCESS_CYCLE Character(1) VARCHAR2(1) NOT NULL Allow Automatic Processing

    Y/N Table Edit

    Default Value: N

    7 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SP_SETBNK_NONVW

    8 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_VW2

    9 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

    Prompt Table: BANK_ACCT_VW