SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
INV_ITEM_IDPrompt Table: INV_ITEMS
SETID_REGIONDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
REGION_CDPrompt Table: REGION_CD_PO
ITM_REGION(SQL Table) |
Index Back |
|---|---|
Item Sourcing Region SuppliersIdentifies the priority suppliers for items within a Sourcing Region |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: INV_ITEMS |
| 3 | SETID_REGION |
Character(5) | VARCHAR2(5) NOT NULL |
Region SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 4 | 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: REGION_CD_PO |