SETIDPrompt Table: SP_SETID_NONVW
CARRIER_IDPrompt Table:
CARRIER_ID
Set Control Field: SETID
SHIP_TYPE_IDPrompt Table:
SHIP_METHOD
Set Control Field: SETID
COUNTRYPrompt Table: COUNTRY_TBL
STATEPrompt Table: STATE_TBL
WS_CARR_CNTRY(SQL Table) |
Index Back |
|---|---|
Carrier Ship Type CountryThis is used as a eStore setup table to specify ther Carrier and country/state combinations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CARRIER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 3 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 4 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 5 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |