BUSINESS_UNITLEDGER_GROUPFIN_OPEN_MAX_VW(SQL View) |
Index Back |
|---|---|
Max open period end date view |
| SELECT DISTINCT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , A.OPEN_YEAR_TO , A.OPEN_PERIOD_TO , A.OPEN_TO_DATE FROM PS_FIN_OPEN_PERIOD A , PS_FIN_OPEN_ADJ B WHERE A.PSFT_PRODUCT = 'GL' AND A.TRANSACTION_TYPE = 'DEF' AND B.PSFT_PRODUCT = A.PSFT_PRODUCT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.LEDGER_GROUP = A.LEDGER_GROUP AND B.DEFAULT_FLAG = 'Y' AND A.OPEN_TO_DATE = ( SELECT MAX(C.OPEN_TO_DATE) FROM PS_FIN_OPEN_PERIOD C WHERE C.PSFT_PRODUCT = 'GL' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.LEDGER_GROUP = A.LEDGER_GROUP AND C.TRANSACTION_TYPE = A.TRANSACTION_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | OPEN_CLOSING_YEAR | Number(4,0) | SMALLINT NOT NULL | Adjustment Year |
| 4 | ADJUSTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Adjustment Period |
| 5 | OPEN_YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Open Year To |
| 6 | OPEN_PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | Open Period To |
| 7 | OPEN_TO_DATE | Date(10) | DATE | Last Open Day |