POS_GEN_ENT_VW (SQL View)	Index Back
Main position entry Main position entry

POS_GEN_ENT_VW

(SQL View)

Main position entry

SELECT SETID , BUSINESS_UNIT , POS_CATEGORY , SOURCE_SET , VALUE_DT , REFERENCE , CURRENCY_CD , AMOUNT FROM PS_POS_GEN_ENT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 POS_CATEGORY Character(30) VARCHAR2(30) NOT NULL Position Category

4 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

5 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

6 REFERENCE Character(30) VARCHAR2(30) NOT NULL Field to show when a variable is a reference variable.

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	POS_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Position Category
4	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
5	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
6	REFERENCE	Character(30)	VARCHAR2(30) NOT NULL	Field to show when a variable is a reference variable.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
8	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount