KK_APPR_LBL_VW(SQL View) |
Index Back |
---|---|
KK Journal Approval Line LabelThis 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 |