GL_JLN_DRILL

(SQL View)
Index Back

SELECT B.BUSINESS_UNIT , B.JOURNAL_ID , B.JOURNAL_DATE , B.UNPOST_SEQ , A.SOURCE ,A.JRNL_HDR_STATUS ,A.POSTED_DATE ,A.DESCR ,A.BUSINESS_UNIT_IU ,A.ADJUSTING_ENTRY ,A.LEDGER_GROUP , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , B.JOURNAL_LINE , B.SPEEDCHART_KEY , B.SPEEDTYPE_KEY , B.LEDGER , B.ACCOUNT , B.ALTACCT , B.DEPTID , %subrec(CFS14_AN_SBR, B) , B.BOOK_CODE , B.GL_ADJUST_TYPE , B.BUDGET_PERIOD , B.SCENARIO , B.CURRENCY_CD , %subrec(PC_CF1_N_SBR, B) , B.STATISTICS_CODE , B.MONETARY_AMOUNT , B.MOVEMENT_FLAG , B.STATISTIC_AMOUNT , B.JRNL_LN_REF , B.SUSPENDED_LINE , B.LINE_DESCR , B.JRNL_LINE_STATUS , B.JOURNAL_LINE_DATE , B.FOREIGN_CURRENCY , B.RT_TYPE , B.FOREIGN_AMOUNT , B.RATE_DIV , B.RATE_MULT , B.PROCESS_INSTANCE , B.DOC_TYPE , B.DOC_SEQ_NBR , B.DOC_SEQ_DATE , B.DOC_SEQ_STATUS , B.JRNL_LINE_SOURCE , B.BUDGET_DT , B.BUDGET_LINE_STATUS , B.SETTLEMENT_DT , B.DATE_CODE , B.CLOSING_STATUS , B.ENTRY_EVENT , B.EE_PROC_STATUS , B.JOURNAL_LINE_GFEE , B.IU_TRAN_GRP_NBR , B.IU_ANCHOR_FLG , B.PC_DISTRIB_STATUS , A.SYSTEM_SOURCE FROM PS_JRNL_HEADER A , PS_JRNL_LN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.JOURNAL_ID = B.JOURNAL_ID AND A.JOURNAL_DATE = B.JOURNAL_DATE AND A.UNPOST_SEQ = B.UNPOST_SEQ

# 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_GL_NONVW

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.

Default Value: JRNL_HEADER.JOURNAL_ID

3 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.

Default Value: JRNL_HEADER.JOURNAL_DATE

4 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry 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.

Prompt Table: SOURCE_TBL

6 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost

Default Value: N

7 POSTED_DATE Date(10) DATE Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.

Default Value: JRNL_HEADER.BUSINESS_UNIT

10 ADJUSTING_ENTRY Character(1) VARCHAR2(1) NOT NULL Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry

Default Value: N

11 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_BULGRP_NONVW

12 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
13 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
14 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.
15 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key
16 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
17 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Prompt Table: LED_GRP_LED_TBL

18 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

19 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %EDIT_DEPT

21 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

22 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: %EDIT_PRODUCT

23 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

24 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

25 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

26 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

27 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

28 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

29 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

30 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: %EDIT_CHARTFLD1

31 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: %EDIT_CHARTFLD2

32 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: %EDIT_CHARTFLD3

33 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code

Prompt Table: BOOK_CODE_TBL

34 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
35 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

Prompt Table: CAL_BP_ALL_VW

36 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca

Prompt Table: BD_SCENARIO_TBL

37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

38 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

39 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

40 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

41 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

42 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

43 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

44 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

45 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

Prompt Table: STAT_TBL

46 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.
47 MOVEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal

Default Value: N

48 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.
49 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
50 SUSPENDED_LINE Number(9,0) DECIMAL(9) NOT NULL Identifies the line number of the journal line containing an edit error in a suspense journal. It is used as a reference for entering journal suspense corrections.
51 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.

Default Value: GL_ACCOUNT_TBL.DESCR

52 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a journal entry.
0=OK - No Errors
1=Uncorrected Error(s)

Default Value: 0

53 JOURNAL_LINE_DATE Date(10) DATE Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.

Default Value: JRNL_HEADER.TRANSACTION_DATE

54 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

Prompt Table: FRGN_CURR_VW

55 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

56 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.
57 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
58 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
59 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
60 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
61 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
62 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.
63 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
64 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.
65 BUDGET_DT Date(10) DATE Budget Date

Default Value: JRNL_HEADER.JOURNAL_DATE

66 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

67 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.

Default Value: JRNL_HEADER.JOURNAL_DATE

68 DATE_CODE Character(1) VARCHAR2(1) NOT NULL This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.

Default Value: 0

Prompt Table: DATE_CD_VW

69 CLOSING_STATUS Character(1) VARCHAR2(1) NOT NULL A status to show whether the status of the entries in the closing process.
C=Entry is closed
U=Entry is Unclosed
70 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

Prompt Table: %EDIT_EE_EVENT

71 EE_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL Entry Event Line Status

Default Value: Y

72 JOURNAL_LINE_GFEE Number(9,0) DECIMAL(9) NOT NULL Entry Event Journal Line
73 IU_TRAN_GRP_NBR Number(4,0) SMALLINT NOT NULL To support multiple InterUnit or IntraUnit groups in a single journal.
74 IU_ANCHOR_FLG Character(1) VARCHAR2(1) NOT NULL Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).

Y/N Table Edit

Default Value: N

75 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

76 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.