BUSINESS_UNITLEDGER_GROUPFIN_OPEN_MIN_VW(SQL View) |
Index Back |
|---|---|
Min open period start date vw |
| SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , A.OPEN_YEAR_FROM , A.OPEN_PERIOD_FROM , A.OPEN_FROM_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_FROM_DATE = ( SELECT MIN(C.OPEN_FROM_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_FROM | Number(4,0) | SMALLINT NOT NULL | Open Year From |
| 6 | OPEN_PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | Open Period From |
| 7 | OPEN_FROM_DATE | Date(10) | DATE | First Open Day |