SF1219_DTL_VW (SQL View)	Index Back
SF 1219 Lines View This view displays the valid choices for the SF1219 Transaction Detail update component.

SF1219_DTL_VW

(SQL View)

SF 1219 Lines View

This view displays the valid choices for the SF1219 Transaction Detail update component.

SELECT DISTINCT BUSINESS_UNIT_1 , JOURNAL_ID FROM PS_SF1219_DTL_TBL WHERE SF1219_SOURCE = 'GL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
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.