SETIDPrompt Table: SETID_TBL
REGION_CDPrompt Table:
SPB_REGIONCD_VW
Set Control Field: SETID
LOCATIONPrompt Table:
SPB_LOC_TBL_VW
Set Control Field: SETID
SPB_REGIONLOCAT(SQL Table) |
Index Back |
|---|---|
Locations by region |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
SPB_REGIONCD_VW
|
| 3 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SPB_LOC_TBL_VW
|