GLRN_SETGLRN_RULEGLRN_SETRUL_VW(SQL View) |
Index Back |
|---|---|
Recon Set Rule ViewView to fetch all the reconciliations within a recon set. |
| SELECT A.GLRN_SET , A.GLRN_RULE FROM PS_GLRN_SET_LINE A WHERE A.EFFDT = (SELECT MAX(X.EFFDT)FROM PS_GLRN_SET_LINE X WHERE A.GLRN_SET = X.GLRN_SET AND X.EFFDT <= %currentdatein) |
| # | 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 |