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 |