BUSINESS_UNIT_OMSOLD_TO_CUST_IDORDER_NO_TOCA_ORDER_NO_VW(SQL View) |
Index Back |
|---|
| SELECT HDR.BUSINESS_UNIT ,HDR.SOLD_TO_CUST_ID , HDR.ORDER_NO , HDR.CNTRCT_ID FROM PS_ORD_HEADER HDR WHERE HDR.SOURCE_CD IN ('CA', 'RCA') AND HDR.ORDER_STATUS = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_OM |
Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 2 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 3 | ORDER_NO_TO |
Character(10) | VARCHAR2(10) NOT NULL | To Order No |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |