SETIDFRT_TYPE_CODEPrompt Table: IN_FRT_DFLT
FRT_SRVC_DEFNIN_FRT_SRV_VW3(SQL View) |
Index Back |
|---|---|
Service Defn ViewUsed as a prompt table on the Manage Delivery page when carrier and ship type are both not keys. |
| SELECT DISTINCT SETID , 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 | FRT_TYPE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table: IN_FRT_DFLT |
| 3 | FRT_SRVC_DEFN |
Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |