FCST_HR_BK_VW (SQL View)	Index Back
Forecast Payroll amount Forecast Payroll amount from HR_ACCTG_LINE

FCST_HR_BK_VW

(SQL View)

Forecast Payroll amount

Forecast Payroll amount from HR_ACCTG_LINE

SELECT LN.BUSINESS_UNIT_GL , LN.JOURNAL_ID , LN.JOURNAL_DATE , %DateAdd((LN.JOURNAL_DATE) , (%DateDiff(CAL.BEGIN_DT, CAL.END_DT) + 1)) , LN.MONETARY_AMOUNT , LN.CURRENCY_CD , LN.FOREIGN_AMOUNT , LN.FOREIGN_CURRENCY , LN.JRNL_LN_REF , LN.ACCOUNTING_PERIOD , LN.FISCAL_YEAR , CAL.BEGIN_DT , CAL.END_DT , D.CALENDAR_DATE , ' ' , ' ' , ' ' FROM PS_HR_ACCTG_LINE LN , PS_CAL_DETP_TBL CAL , PS_BU_LED_GRP_TBL LED , PS_POS_DAYS_TBL D WHERE LN.FISCAL_YEAR = CAL.FISCAL_YEAR AND LN.ACCOUNTING_PERIOD = CAL.ACCOUNTING_PERIOD AND LN.BUSINESS_UNIT_GL = LED.BUSINESS_UNIT AND LN.LEDGER_GROUP = LED.LEDGER_GROUP AND CAL.CALENDAR_ID = LED.CALENDAR_ID AND D.CALENDAR_DATE = %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL 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 FORECAST_DATE Date(10) DATE Forecast Date

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

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

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

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

11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

12 BEGIN_DT Date(10) DATE Begin Date

13 END_DT Date(10) DATE End Date

14 CALENDAR_DATE Date(10) DATE An internal work field utilized to store calendar dates for a given calendar year. The dates are displa

15 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

16 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

17 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL 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	FORECAST_DATE	Date(10)	DATE	Forecast Date
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	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.
8	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
9	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.
10	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.
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	BEGIN_DT	Date(10)	DATE	Begin Date
13	END_DT	Date(10)	DATE	End Date
14	CALENDAR_DATE	Date(10)	DATE	An internal work field utilized to store calendar dates for a given calendar year. The dates are displa
15	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
16	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
17	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank