GLRN_ATTA_H

(SQL Table)
Index Back

Account Recon Attachments Hist

History table for Account Reconciliation table - Attachments

# 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 ATTACHMENT_NUM Number(5,0) INTEGER NOT NULL Attachment Number
9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
11 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
12 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
13 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.