BUSINESS_UNITJOURNAL_IDJOURNAL_DATEBUSINESS_UNIT_LND=Default
E=Denied
G=Pending Approval
N=None
P=Approved to Post
Q=Pending for Unpost Approval
R=Replace
S=Security Denied
T=Terminated
U=Pending Request to Unpost
W=Approved to Post
X=Delete
JRNL_AF_HDR_VW(SQL View) |
Index Back |
|---|---|
Journal Header For AFJournal header view used by AF (Approval Framework). The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE. |
| SELECT H.BUSINESS_UNIT_IU , H.JOURNAL_ID , H.JOURNAL_DATE , H.BUSINESS_UNIT , H.JRNL_PROCESS_REQST FROM PS_JRNL_HEADER H WHERE ((H.JRNL_HDR_STATUS IN ('V', 'P','N') AND H.BUDGET_HDR_STATUS = 'V' ) OR (H.JRNL_HDR_STATUS IN ('D') AND H.BUDGET_HDR_STATUS = 'N')) AND EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER H1 WHERE H1.BUSINESS_UNIT_IU=H.BUSINESS_UNIT_IU AND H1.BUSINESS_UNIT=H.BUSINESS_UNIT_IU AND H1.JOURNAL_ID=H.JOURNAL_ID AND H1.JOURNAL_DATE=H.JOURNAL_DATE AND H1.UNPOST_SEQ=H.UNPOST_SEQ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | JOURNAL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 3 | JOURNAL_DATE |
Date(10) | DATE | Specifies the date the journal was created. |
| 4 | BUSINESS_UNIT_LN |
Character(5) | VARCHAR2(5) NOT NULL | Line Business Unit |
| 5 | JRNL_PROCESS_REQST | Character(1) | VARCHAR2(1) NOT NULL |
A flag that determines when a journal is ready for posting. Some examples of the request flag are Approved to Post, Denied, and Pending Approval.
D=Default E=Denied G=Pending Approval N=None P=Approved to Post Q=Pending for Unpost Approval R=Replace S=Security Denied T=Terminated U=Pending Request to Unpost W=Approved to Post X=Delete |