AR_CWB_CDFLD_WS(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELD_CAT_TYPE1 | Character(1) | VARCHAR2(1) NOT NULL |
Field Category
A=Activity B=Balances G=General M=Metrics U=User |
2 | FIELD_NUM1 | Number(3,0) | SMALLINT NOT NULL | Field Num |
3 | FIELD_VALUE1 | Character(50) | VARCHAR2(50) NOT NULL | Field Value |
4 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
5 | LINK1 | Character(1) | VARCHAR2(1) NOT NULL | Additional Info |
6 | ACTION_L_NBR1 | Number(3,0) | SMALLINT NOT NULL | Action Number |
7 | MORE_BUTTON1 | Character(1) | VARCHAR2(1) NOT NULL | More Button |
8 | ACTION_B_NBR1 | Number(3,0) | SMALLINT NOT NULL | Action Number |
9 | FIELD_CAT_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL |
Field Category
A=Activity B=Balances G=General M=Metrics U=User |
10 | FIELD_NUM2 | Number(3,0) | SMALLINT NOT NULL | Field Num |
11 | FIELD_VALUE2 | Character(50) | VARCHAR2(50) NOT NULL | Field Value |
12 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
13 | LINK2 | Character(1) | VARCHAR2(1) NOT NULL | Additional Info |
14 | ACTION_L_NBR2 | Number(3,0) | SMALLINT NOT NULL | Action Number |
15 | MORE_BUTTON2 | Character(1) | VARCHAR2(1) NOT NULL | More Button |
16 | ACTION_B_NBR2 | Number(3,0) | SMALLINT NOT NULL | Action Number |
17 | FIELD_CAT_TYPE3 | Character(1) | VARCHAR2(1) NOT NULL |
Field Category
A=Activity B=Balances G=General M=Metrics U=User |
18 | FIELD_NUM3 | Number(3,0) | SMALLINT NOT NULL | Field Num |
19 | FIELD_VALUE3 | Character(50) | VARCHAR2(50) NOT NULL | Field Value |
20 | CURRENCY_CD3 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
21 | LINK3 | Character(1) | VARCHAR2(1) NOT NULL | Additional Info |
22 | ACTION_L_NBR3 | Number(3,0) | SMALLINT NOT NULL | Action Number |
23 | MORE_BUTTON3 | Character(1) | VARCHAR2(1) NOT NULL | More Button |
24 | ACTION_B_NBR3 | Number(3,0) | SMALLINT NOT NULL | Action Number |