SETIDCARRIER_IDPrompt Table:
IN_CARRIER_VW
Set Control Field: SETID
SHIP_TYPE_IDFRT_TYPE_CODEPrompt Table: IN_FRT_DFLT
FRT_SRVC_DEFNIN_FRT_SRV_VW2(SQL View) |
Index Back |
|---|---|
Service Defn ViewUsed as a prompt table on the Manage Delivery page when carrier, ship via and frt type are delivery keys. |
| SELECT DISTINCT SETID , CARRIER_ID , SHIP_TYPE_ID , FRT_TYPE_CODE , 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
Prompt Table:
IN_CARRIER_VW
|
| 3 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 4 | FRT_TYPE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table: IN_FRT_DFLT |
| 5 | FRT_SRVC_DEFN |
Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |