PC_PRJANL_TMP1

(SQL Table)
Index Back

Project Valuation Temp Table 1

Project Valuation Temp Table 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 AMT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount1
7 AMT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount2
8 AMT_3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount3
9 AMT_4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount4
10 AMT_5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount5
11 AMT_6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount6
12 AMT_7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount7
13 AMT_8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount8
14 AMT_9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount9
15 AMT_10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount10
16 AMT_11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount11
17 AMT_12 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount12
18 AMT_13 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount13
19 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1
20 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2
21 FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag3