GM_BUD_JRNL_WRK (SQL Table)	Index Back
Work scroll for Bud Journal

GM_BUD_JRNL_WRK

(SQL Table)

Work scroll for Bud Journal

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PD_INDEX Character(3) VARCHAR2(3) NOT NULL GM_PRJ_BUD_PD Index

2 CF_INDEX Character(3) VARCHAR2(3) NOT NULL GM_PRJ_BUD_CF Index

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PD_INDEX	Character(3)	VARCHAR2(3) NOT NULL	GM_PRJ_BUD_PD Index
2	CF_INDEX	Character(3)	VARCHAR2(3) NOT NULL	GM_PRJ_BUD_CF Index
3	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.
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
5	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.