BO_REQUEST_IDBO_REQ_DTL_NOA=Approved
C=Canceled
D=Denied
E=Error
F=Completed
P=Pending Approval
R=In Review
A=Add
B=Add + Tree
T=Tree Only
U=Update
V=Update + Tree
BO_REQ_DTL_VW(SQL View) |
Index Back |
|---|---|
FSR Detail ViewFinancial Structure Request Detail View. |
| SELECT BO_REQUEST_ID , BO_REQ_DTL_NO , BO_REQ_DTL_STATUS , SETID , FIELDNAME1 , BO_REQ_FLD_ACT , BUSINESS_UNIT_BO FROM PS_BO_REQUEST_DTL |
| # | 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 | BO_REQ_DTL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Financial Structure Request Detail Status
A=Approved C=Canceled D=Denied E=Error F=Completed P=Pending Approval R=In Review |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 6 | 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 |
| 7 | BUSINESS_UNIT_BO | Character(5) | VARCHAR2(5) NOT NULL | Financial Structure Request Business Unit |