LCD_OPEN_PER_VW(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT , B.LEDGER_GROUP , A.LEDGER_CODE , B.GL_ADJUST_TYPE , B.TRANSACTION_TYPE , A.BOOK_CODE , B.OPEN_PERIOD_FROM , B.OPEN_YEAR_FROM , B.OPEN_PERIOD_TO , B.OPEN_YEAR_TO FROM PS_LEDGER_CODE_DTL A , PS_FIN_OPEN_PERIOD B ,PS_SET_CNTRL_REC E WHERE A.LEDGER_CODE=B.LEDGER_CODE AND B.TRANSACTION_TYPE IN ('DEF', 'UNP') AND E.SETID=A.SETID AND E.RECNAME='LEDGER_CODE_TBL' AND E.SETCNTRLVALUE=B.BUSINESS_UNIT |
| # | 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 | LEDGER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Code |
| 4 | GL_ADJUST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Adjustment Type |
| 5 | TRANSACTION_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Transaction Type |
| 6 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 7 | OPEN_PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | Open Period From |
| 8 | OPEN_YEAR_FROM | Number(4,0) | SMALLINT NOT NULL | Open Year From |
| 9 | OPEN_PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | Open Period To |
| 10 | OPEN_YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Open Year To |