AR_ACV_FLDD1_VW(SQL View) |
Index Back |
|---|---|
Cust Detail 1 fields |
| SELECT FIELD_CAT_TYPE1 , FIELD_NUM1 , ' ' , FIELD_VALUE1 , CURRENCY_CD1 , LINK1 , ACTION_L_NBR1 , FIELD_CAT_TYPE2 , FIELD_NUM2 , ' ' , FIELD_VALUE2 , CURRENCY_CD2 , LINK2 , ACTION_L_NBR2 , FIELD_CAT_TYPE3 , FIELD_NUM3 , ' ' , FIELD_VALUE3 , CURRENCY_CD3 , LINK3 , ACTION_L_NBR3 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 | ACV_DTFLD_ID_1 | Character(8) | VARCHAR2(8) NOT NULL | Data Field ID |
| 4 | FIELD_VALUE1 | Character(50) | VARCHAR2(50) NOT NULL | Field Value |
| 5 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | LINK1 | Character(1) | VARCHAR2(1) NOT NULL | Additional Info |
| 7 | ACTION_L_NBR1 | Number(3,0) | SMALLINT NOT NULL | Action Number |
| 8 | FIELD_CAT_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL |
Field Category
A=Activity B=Balances G=General M=Metrics U=User |
| 9 | FIELD_NUM2 | Number(3,0) | SMALLINT NOT NULL | Field Num |
| 10 | ACV_DTFLD_ID_2 | Character(8) | VARCHAR2(8) NOT NULL | Data Field ID |
| 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 | FIELD_CAT_TYPE3 | Character(1) | VARCHAR2(1) NOT NULL |
Field Category
A=Activity B=Balances G=General M=Metrics U=User |
| 16 | FIELD_NUM3 | Number(3,0) | SMALLINT NOT NULL | Field Num |
| 17 | ACV_DTFLD_ID_3 | Character(8) | VARCHAR2(8) NOT NULL | Data Field ID |
| 18 | FIELD_VALUE3 | Character(50) | VARCHAR2(50) NOT NULL | Field Value |
| 19 | CURRENCY_CD3 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 20 | LINK3 | Character(1) | VARCHAR2(1) NOT NULL | link3 |
| 21 | ACTION_L_NBR3 | Number(3,0) | SMALLINT NOT NULL | Action Number |