AR_ACV_FLDBL_VW(SQL View) |
Index Back |
|---|
| SELECT FIELD_CAT_TYPE1 , FIELD_NUM1 , FIELD_VALUE1 , CURRENCY_CD1 , LINK1 , ACTION_L_NBR1 , MORE_BUTTON1 , ACTION_B_NBR1 , FIELD_CAT_TYPE2 , FIELD_NUM2 , FIELD_VALUE2 , CURRENCY_CD2 , LINK2 , ACTION_L_NBR2 , MORE_BUTTON2 , ACTION_B_NBR2 FROM PS_AR_CWB_CDFLD_WS |
| # | 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 |