GLRN_SETGLRN_RULEBUSINESS_UNITAS_OF_DATESEQUENCE_NBR_9COMMENT_NBRGLRN_AF_CMMT_VW(SQL View) |
Index Back |
|---|---|
Account Recon CommentAccount Reconciliation table - Comments |
| SELECT R.GLRN_SET , R.GLRN_RULE , R.BUSINESS_UNIT , R.AS_OF_DATE , R.SEQUENCE_NBR_9 , R.COMMENT_NBR , OP.OPRDEFNDESC , %DatePart(R.DTTM_STAMP) , R.DESCR2000 , R.DTTM_STAMP FROM PS_GLRN_RECON_CMMT R , PSOPRDEFN OP WHERE OP.OPRID = R.USERID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GLRN_SET |
Character(20) | VARCHAR2(20) NOT NULL | Account Reconciliation Set |
| 2 | GLRN_RULE |
Character(20) | VARCHAR2(20) NOT NULL | Account Reconciliation Rule ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | AS_OF_DATE |
Date(10) | DATE | As of Date |
| 5 | SEQUENCE_NBR_9 |
Number(9,0) | DECIMAL(9) NOT NULL | Sequence |
| 6 | COMMENT_NBR |
Number(3,0) | SMALLINT NOT NULL | Comment Number |
| 7 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
| 8 | ENTERED_DT | Date(10) | DATE | Entered on |
| 9 | DESCR2000 | Long Character(2000) | VARCHAR2(2000) | Description whose maximum length is 2000 characters. |
| 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. |