HYP_KK_BD_LN(SQL Table) |
Index Back |
---|---|
KK Budget Journal LineCommitment Control - Budget Journal lines. |
# | 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 | HYP_TRAN_ID | Character(44) | VARCHAR2(44) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
3 | HYP_LINE_NBR | 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. |
4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Default Value: KK_LEDGER_BD.LEDGER |
5 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
6 | BUDGET_DT | Date(10) | DATE | Budget Date |
7 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: %EDIT_ACCOUNT |
8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: %EDIT_DEPT |
9 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: %EDIT_OPER_UNIT |
10 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: %EDIT_PRODUCT |
11 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: %EDIT_FUND_CODE |
12 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: %EDIT_CLASS_FLD |
13 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: %EDIT_PROG_CODE |
14 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: %EDIT_BUD_REF |
15 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
16 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
17 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
18 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: %EDIT_CHARTFLD1 |
19 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: %EDIT_CHARTFLD2 |
20 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: %EDIT_CHARTFLD3 |
21 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: PC_BU_GL_VW |
22 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
23 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_FVW |
24 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RESTYPE_FS |
25 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL |
Budget Period
Prompt Table: KK_TMP_BP_DVW |
26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
27 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table: STAT_TBL |
28 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
29 | JOURNAL_CLASS | Character(10) | VARCHAR2(10) NOT NULL |
Journal Class
Prompt Table:
KK_JRNL_CLASS_V
|
30 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Foreign Currency Code
Prompt Table: FRGN_CURR_VW |
31 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
32 | 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. |
33 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
34 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
35 | 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. |
36 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_BUD_CODES_VW
|
37 | EE_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Entry Event Line Status
Default Value: N |
38 | BD_APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on hyperion Budget transaction records
A=Approved D=Denied P=Pending |
39 | FUND_SOURCE | Character(6) | VARCHAR2(6) NOT NULL |
Funding Source
Prompt Table: KK_BLN_FS_DVW |
40 | 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.
Default Value: PNL |
41 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
42 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged Default Value: N |
43 | 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 Default Value: N |
44 | CF_EDIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not accounting entries have been edited for valid ChartField combinations. If an edit has taken place the status indicates whether or not it was successful. The ChartField Combination Edit program populates the field as Complete Errors or Not Edited.
C=Complete E=Errors N=Not Edited |
45 | KSEC_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Line Status - KK Security
E=Security Error N=No Checked V=Valid Default Value: N |