BO_REQUEST_IDBO_REQ_DTL_NOA=Add
B=Add + Tree
T=Tree Only
U=Update
V=Update + Tree
Default Value: %date
BO_REQ_CF_VW(SQL View) |
Index Back |
|---|---|
FSR ChartField RequestFinancial Structure Request Completed ChartField Request View |
| SELECT BO_REQUEST_ID , BO_REQ_DTL_NO , SETID , FIELDNAME1 , BO_REQ_FLD_ACT , FIELDVALUE1 , EFFDT , DESCR FROM PS_BO_REQUEST_DTL WHERE BO_REQ_TMPLT_TYPE = 'C' AND BO_REQ_DTL_STATUS = 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Financial Structure Request ID |
| 2 | BO_REQ_DTL_NO |
Number(3,0) | SMALLINT NOT NULL | Financial Structure Request Detail ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 5 | BO_REQ_FLD_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Financial Structure Request Type
A=Add B=Add + Tree T=Tree Only U=Update V=Update + Tree |
| 6 | FIELDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 7 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |