JRNL_AF_LFLD_VW (SQL View)	Index Back
Journal Line Fields For AF This View contains GL actuals/standard budget journal line fields by selecting data from JRNL_HEADER and JRNL_LN tables. User can pick up the fields in this view to set up the rules on journal line fields to be used by GL Journal Approval process. The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE.

JRNL_AF_LFLD_VW

(SQL View)

Journal Line Fields For AF

This View contains GL actuals/standard budget journal line fields by selecting data from JRNL_HEADER and JRNL_LN tables. User can pick up the fields in this view to set up the rules on journal line fields to be used by GL Journal Approval process. The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE.

SELECT DISTINCT H.BUSINESS_UNIT_IU , H.JOURNAL_ID , H.JOURNAL_DATE , H.BUSINESS_UNIT , L.LEDGER , L.SPEEDCHART_KEY , L.SPEEDTYPE_KEY , L.ACCOUNT , L.ALTACCT , L.DEPTID , %subrec(CF12_AN_SBR,L) , L.BOOK_CODE , L.BUDGET_PERIOD , L.SCENARIO , L.SETTLEMENT_DT , L.DATE_CODE , L.CURRENCY_CD , %subrec(PC_CF1_N_SBR,L) , L.STATISTICS_CODE , L.MONETARY_AMOUNT , L.STATISTIC_AMOUNT , L.FOREIGN_CURRENCY , L.FOREIGN_AMOUNT FROM PS_JRNL_HEADER H , PS_JRNL_LN L WHERE H.JRNL_HDR_STATUS='V' AND H.BUDGET_HDR_STATUS='V' AND H.JRNL_PROCESS_REQST NOT IN ('P','W') AND EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER H1 WHERE H1.BUSINESS_UNIT_IU=H.BUSINESS_UNIT_IU AND H1.BUSINESS_UNIT=H.BUSINESS_UNIT_IU AND H1.JOURNAL_ID=H.JOURNAL_ID AND H1.JOURNAL_DATE=H.JOURNAL_DATE AND H1.UNPOST_SEQ=H.UNPOST_SEQ) AND H.BUSINESS_UNIT=L.BUSINESS_UNIT AND H.JOURNAL_ID=L.JOURNAL_ID AND H.JOURNAL_DATE=L.JOURNAL_DATE AND H.UNPOST_SEQ=L.UNPOST_SEQ

# 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 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit

5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

6 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key

7 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

24 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

25 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

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

27 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.

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

29 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

30 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

31 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

32 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

33 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

34 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

35 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

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

37 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.

38 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.

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

40 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.

#	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	BUSINESS_UNIT_LN	Character(5)	VARCHAR2(5) NOT NULL	Line Business Unit
5	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
6	SPEEDCHART_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedChart Key
7	SPEEDTYPE_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedType Key
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
23	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
24	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
25	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
26	SETTLEMENT_DT	Date(10)	DATE	The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
27	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.
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
30	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
31	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
32	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
33	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
34	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
35	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
36	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
37	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.
38	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.
39	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
40	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.