SETIDFRT_SRVC_DEFNIN_FRT_SRV_VW6(SQL View) |
Index Back |
|---|---|
Service Defn ViewUsed as a prompt table on the Manage Delivery page when carrier id is a key but ship type id is not. |
| SELECT DISTINCT SETID , FRT_SRVC_DEFN , CARRIER_ID , SHIP_TYPE_ID FROM PS_IN_FRT_SRV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | FRT_SRVC_DEFN |
Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |
| 3 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 4 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |