BUSINESS_UNIT_ROCAPTURE_IDCA_TXN_CRM_5_VW(SQL View) |
Index Back |
|---|---|
view upon CA_TXN_CRMview upon CA_TXN_CRM - for service order id |
| SELECT BUSINESS_UNIT_RO , CAPTURE_ID FROM PS_CA_TXN_CRM WHERE CAPTURE_ID <> ' ' GROUP BY BUSINESS_UNIT_RO, CAPTURE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RO |
Character(5) | VARCHAR2(5) NOT NULL | Order Capture Business Unit |
| 2 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Order Capture ID |