BUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
LEDGERPROCESSINSTANCEFSAH_AP_ABM_MVW(SQL View) |
Index Back |
|---|---|
FSAHFSAH |
| SELECT A.BUSINESS_UNIT , A.LEDGER , B.PROCESS_INSTANCE , A.OPEN_FROM_DATE , A.OPEN_TO_DATE FROM PS_FSAH_AP_ABM_VW A , %Table(FSAH_AP_TMP) B WHERE A.LEDGER_GROUP = B.LEDGER_GROUP AND A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | 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 |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | PROCESSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | OPEN_FROM_DATE | Date(10) | DATE | First Open Day |
| 5 | OPEN_TO_DATE | Date(10) | DATE | Last Open Day |