BUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
LEDGER_GROUPLEDGERFSAH_AP_ABM_VW(SQL View) |
Index Back |
|---|---|
FSAHFSAH |
| SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.LEDGER , MIN(OPEN_FROM_DATE) , MAX(OPEN_TO_DATE) FROM PS_FSAH_OPN_PRD_VW A , PS_LED_GRP_LED_TBL B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'LED_GRP_LED_TBL' AND C.SETID = B.SETID AND A.LEDGER_GROUP = B.LEDGER_GROUP AND A.PSFT_PRODUCT = 'GL' AND A.TRANSACTION_TYPE = 'DEF' AND B.PRIMARY_LEDGER = 'Y' GROUP BY A.BUSINESS_UNIT, A.LEDGER_GROUP, B.LEDGER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 4 | OPEN_FROM_DATE | Date(10) | DATE | First Open Day |
| 5 | OPEN_TO_DATE | Date(10) | DATE | Last Open Day |