GLRN_SET_LINE

(SQL Table)
 Index Back

Account Recon Set

Account Reconciliation Set that links Business Units, Recon Rules, and Unit of Recon.

  • Parent record: GLRN_SET_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From

    Prompt Table: SP_BU_GL_NONVW

    4 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    5 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID

    Prompt Table: GLRN_NOADHOC_VW
    Set Control Field: BUSINESS_UNIT_FROM

    6 GLRN_UNIT_OF_RECON Character(2) VARCHAR2(2) NOT NULL 2-Char Unit of Reconciliation

    Prompt Table: GLRN_UOR_VW

    7 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

    Y/N Table Edit

    Default Value: Y