BUSINESS_UNITJOURNAL_IDJOURNAL_DATED=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
KK_AF_HDR_VW(SQL View) |
Index Back |
|---|---|
KK Budget Header For AFKK Budget Header view used by AF (Approval Framework). |
| SELECT H.BUSINESS_UNIT , H.JOURNAL_ID , H.JOURNAL_DATE , H.JRNL_PROCESS_REQST FROM PS_KK_BUDGET_HDR H |
| # | 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 | 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 |