GLRN_SETGLRN_RULEBUSINESS_UNITAS_OF_DATESEQUENCE_NBR_9GLRN_AF_HDR_VW(SQL View) |
Index Back |
|---|---|
Journal Header For AFJournal header view used by AF (Approval Framework). The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE. |
| SELECT A.GLRN_SET , A.GLRN_RULE , A.BUSINESS_UNIT , A.AS_OF_DATE , A.SEQUENCE_NBR_9 , A.GLRN_RECON_STATUS , A.GLRN_REASON_CD FROM PS_GLRN_RECON_TBL A |
| # | 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 | GLRN_RECON_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Status |
| 7 | GLRN_REASON_CD | Character(2) | VARCHAR2(2) NOT NULL | Status Change reason code |