RO_ORD_QUOBU_VW(SQL View) |
Index Back |
|---|---|
Order Header for BUView on Order Header Info for single Business Unit for ACE Order Metrics Report |
| SELECT A.PROBINST , A.CAPTURE_ID , C.REGION_ID , A.RO_MONTHS , A.CAPTURE_TYPE_CD , A.BUSINESS_UNIT , A.SOURCE_CD , A.CURRENCY_CD , %NumToChar(A.STATUS_CODE) , A.SETID_STATUS , A.SETID_SOURCE , A.SETID_CAPTURE_TYPE , A.TOTAL_PRICE , B.CHARGE_AMT , B.CHARGE_PERCENT , B.CHARGE_TYPE , 1 FROM PS_RO_ORD_MBUHR_VW A , PS_RO_ORD_MBUCG_VW B , PS_RO_SOLD2RGNB_VW C WHERE A.PROBINST = B.PROBINST(+) AND A.CAPTURE_ID=B.CAPTURE_ID(+) AND A.PROBINST = C.PROBINST(+) AND A.CAPTURE_ID=C.CAPTURE_ID(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 3 | REGION_ID |
Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 4 | RO_MONTHS |
Character(10) | VARCHAR2(10) NOT NULL | View on Months Calendar for ACE Order Metrics Reports |
| 5 | CAPTURE_TYPE_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order Prompt Table: RO_TYPE |
| 6 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RO_NONVW |
| 7 | SOURCE_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Source Code
Prompt Table: RO_DEFN_SOURCE |
| 8 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 9 | STATUS_CD_STR |
Character(5) | VARCHAR2(5) NOT NULL | Status Code |
| 10 | SETID_STATUS |
Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 11 | SETID_SOURCE |
Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 12 | SETID_CAPTURE_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 13 | TOTAL_PRICE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Total Price |
| 14 | CHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 15 | CHARGE_PERCENT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Charge Percent |
| 16 | CHARGE_TYPE | Character(4) | VARCHAR2(4) NOT NULL | This field is used as edit box to show the charge type used in Total subpage and other places |
| 17 | RO_NUM_ORD_QUOTE | Signed Number(8,0) | DECIMAL(7) NOT NULL | Number of Orders and Quotes |