CSH_CLR_RQ_HDR

(SQL Table)
Index Back

AP Cash Clrg Request Header

  • Related Language Record: CSH_CLR_RQ_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_FS

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    4 REQUEST_DT Date(10) DATE Request Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: N

    7 CSH_CLR_PAYDT_OPT Character(1) VARCHAR2(1) NOT NULL Cash Clear Payment Date Option
    A=All Reconciled Payments
    C=Clearing Date Range
    P=Payment Date Range

    Default Value: A

    8 FROM_DATE Date(10) DATE From Date
    9 TO_DATE Date(10) DATE To Date
    10 CSH_CLR_ACCDT_OPT Character(1) VARCHAR2(1) NOT NULL Cash Clear Acctg Date Option
    C=Use Clearing Date
    P=Use Payment Date
    S=Use Specific Date

    Default Value: C

    11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    12 GFEE_RUN_EEG Character(1) VARCHAR2(1) NOT NULL Checkbox to determine whether to run Entry Event during a batch process.

    Y/N Table Edit

    Default Value: N