SETIDCARRIER_IDFRT_SRVC_DEFNIN_FRT_SRV_VW5(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 , CARRIER_ID , FRT_SRVC_DEFN 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 | CARRIER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 3 | FRT_SRVC_DEFN |
Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |