KK_APPR_LBL_VW

(SQL View)
Index Back

KK Journal Approval Line Label

This is used in Page Composer to compose labels for budget journal lines.

SELECT L.BUSINESS_UNIT , L.JOURNAL_ID , L.JOURNAL_DATE , L.JOURNAL_LINE , L.MONETARY_AMOUNT , L.CURRENCY_CD , L.LINE_DESCR , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , L.LEDGER , L.BUDGET_PERIOD , L.FOREIGN_AMOUNT , L.FOREIGN_CURRENCY , L.FUND_SOURCE , L.JRNL_LINE_SOURCE , L.BUDGET_DT , L.BUDGET_LINE_STATUS , L.BD_LINE_STATUS FROM PS_KK_BUDGET_LN L WHERE UNPOST_SEQ = 0

# 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 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
5 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
8 CF_DESCRIPTION1 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
9 CF_DESCRIPTION2 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
10 CF_DESCRIPTION3 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
11 CF_DESCRIPTION4 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
12 CF_DESCRIPTION5 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
13 CF_DESCRIPTION6 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
14 CF_DESCRIPTION7 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
15 CF_DESCRIPTION8 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
16 CF_DESCRIPTION9 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
17 CF_DESCRIPTION10 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
18 CF_DESCRIPTION11 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
19 CF_DESCRIPTION12 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
20 CF_DESCRIPTION13 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
21 CF_DESCRIPTION14 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
22 CF_DESCRIPTION15 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
23 CF_DESCRIPTION16 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
24 CF_DESCRIPTION17 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
25 CF_DESCRIPTION18 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
26 CF_DESCRIPTION19 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
27 CF_DESCRIPTION20 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
28 CF_DESCRIPTION21 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
29 CF_DESCRIPTION22 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
30 CF_DESCRIPTION23 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
31 CF_DESCRIPTION24 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
32 CF_DESCRIPTION25 Character(70) VARCHAR2(70) NOT NULL Combination of ChartField label, value and description
33 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
34 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
35 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
36 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
37 FUND_SOURCE Character(6) VARCHAR2(6) NOT NULL Funding Source
38 JRNL_LINE_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal line and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
39 BUDGET_DT Date(10) DATE Budget Date
40 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
41 BD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Line Status - Used to track Combo-Edit error at the budget journal line level
E=Error
N=None
V=Valid