GLRN_CMMT_H(SQL Table) |
Index Back |
---|---|
Account Recon Comment HistHistory table for Account Reconciliation table - Comments |
# | 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. |