GLRCN_REQUEST

(SQL Table)
 Index Back

GL Recon Request Table

  • Parent Record Of GLRCN_REQ_BU GLRCN_REQ_SS YTP_RUN_BU

    • # 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_FS_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: A

    5 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    6 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On
    7 CF_SET Character(18) VARCHAR2(18) NOT NULL Chartfield Set
    8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    9 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    10 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period
    11 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
    12 GLRCN_REQ_TYPE Character(1) VARCHAR2(1) NOT NULL Request type
    C=Create
    I=Increment

    Default Value: C

    13 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
    N=Specific Business Unit
    Y=All Business Units

    Y/N Table Edit

    Default Value: N

    14 ALL_SOURCE Character(1) VARCHAR2(1) NOT NULL All Source Flag

    Default Value: N