POS_SOURCE_SQL (SQL Table)	Index Back
Source Selection SQL Cash Forecast Source Selection SQL.

POS_SOURCE_SQL

(SQL Table)

Source Selection SQL

Cash Forecast Source Selection SQL.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

3 SEL_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Cash Forecast Selection SQL statement.

4 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

6 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym
Prompt Table: POS_SOURCE_VW

7 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du
Prompt Table: %EDITTABLE

8 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a

9 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b

10 DATE_INCREMENT Signed Number(5,0) DECIMAL(4) NOT NULL An internal work field utilized for storing the number of adjustment days to be applied to a given node date during

11 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days
Y/N Table Edit
Default Value: N

12 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With

13 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=(
02=((
03=(((
04=((((

14 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=)
02=))
03=)))
04=))))

15 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR

16 NODE_SQL Character(254) VARCHAR2(254) NOT NULL Represents the field in which a user can enter specific SQL criteria in order to select and display position data.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
3	SEL_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Cash Forecast Selection SQL statement.
4	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym Prompt Table: POS_SOURCE_VW
7	FIELD_VALUE_STR	Character(30)	VARCHAR2(30) NOT NULL	An accounting template field designated to support the substitution of desired character field values du Prompt Table: %EDITTABLE
8	FIELD_VALUE_NBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An accounting template field designated to support the substitution of desired monetary amounts during a
9	FIELD_VALUE_DATE	Date(10)	DATE	An accounting template field designated to support the substitution of desired dates during accounting b
10	DATE_INCREMENT	Signed Number(5,0)	DECIMAL(4) NOT NULL	An internal work field utilized for storing the number of adjustment days to be applied to a given node date during
11	RELATIVE_DATE	Character(1)	VARCHAR2(1) NOT NULL	"Represents the number of days Y/N Table Edit Default Value: N
12	COMP_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL field comparison syntax when the user is creating node specific data selection criteria <=< <==<= <>=<> === >=> >==>= B=Begins With C=Contains E=Ends With NB=Doesn't Begins With NC=Doesn't Contains NE=Doesn't Ends With
13	OPEN_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data 01=( 02=(( 03=((( 04=((((
14	CLOSE_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat 01=) 02=)) 03=))) 04=))))
15	AND_OR_TXT	Character(3)	VARCHAR2(3) NOT NULL	Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi AND=AND OR=OR
16	NODE_SQL	Character(254)	VARCHAR2(254) NOT NULL	Represents the field in which a user can enter specific SQL criteria in order to select and display position data.