SETIDPrompt Table: SP_SETID_NONVW
INV_ITEM_IDMFG_IDPrompt Table: MANUFACTURER
MFG_ITM_IDY/N Table Edit
Default Value: N
ITEM_MFG(SQL Table) |
Index Back |
|---|---|
Item Manufacturer TableManufacturer Item IDs for goods that you purchase or manufacture. When tracking EAN/UCC numbers, manufacturer ID represents the EAN/UCC Company Prefix. |
| # | 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 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
| 4 | MFG_ITM_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 5 | PREFERRED_MFG | Character(1) | VARCHAR2(1) NOT NULL |
Item's Preferred Manufacturer
Y/N Table Edit Default Value: N |