SETIDCARRIER_IDPrompt Table:
IN_CARRIEREX_VW
Set Control Field: SETID
SHIP_TYPE_IDPrompt Table:
SHIP_METHOD
Set Control Field: SETID
FRT_TYPE_CODEPrompt Table: IN_FRT_DFLT
FRT_SRVC_DEFNB=Both
N=No
Y=Yes
Default Value: N
IN_FRT_SRV(SQL Table) |
Index Back |
|---|---|
Freight Services |
| # | 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_CARRIEREX_VW
|
| 3 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 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 |
| 6 | CANCEL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cancel PO
B=Both N=No Y=Yes Default Value: N |