BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_OM
QUOTE_NBRC=Cancelled
E=Expired
L=Lost
O=Open
V=Converted to Sales Order
QUOTE_HDR_VW2(SQL View) |
Index Back |
|---|---|
Sales Quote Report View111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL |
| SELECT h.business_unit , h.order_no , h.order_date , h.order_status , h.quote_requestor , k.datetime_added , k.lastupddttm , k.last_maint_oprid FROM PS_ORD_HEADER h , PS_ORD_HEADER_lock k WHERE h.order_type_cd = 'QUO' AND %Join(COMMON_KEYS, ord_header h, ord_header_lock k) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_OM |
| 2 | QUOTE_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Quotation Number |
| 3 | QUOTE_DATE | Date(10) | DATE | Quotation Date |
| 4 | QUOTE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Quote Status
C=Cancelled E=Expired L=Lost O=Open V=Converted to Sales Order |
| 5 | QUOTE_REQUESTOR | Character(15) | VARCHAR2(15) NOT NULL | Quote Requester |
| 6 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 7 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 8 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |