ITM_REGION_VNDR(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
Default Value: ITM_VENDOR.INV_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 |
| 5 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: ITM_VENDOR_VW2 |
| 7 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VNLOC_VNDRSETVW |
| 8 | ITM_VNDR_PRIORITY | Number(3,0) | SMALLINT NOT NULL |
Item Vendor Priority
Default Value: 1 |
| 9 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 10 | LEAD_TIME_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Lead Time Option
0=Default 1=Use Default Value: 0 |
| 11 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Include in Planning
Y/N Table Edit Default Value: Y |