GLRN_CMMT_H

(SQL Table)
Index Back

Account Recon Comment Hist

History table for Account Reconciliation table - Comments

  • Parent record: GLRN_RECON_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
    4 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 AS_OF_DATE Date(10) DATE As of Date
    7 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence
    8 COMMENT_NBR Number(3,0) SMALLINT NOT NULL Comment Number
    9 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    10 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 DESCR2000 Long Character(2000) VARCHAR2(2000) Description whose maximum length is 2000 characters.