SETIDMFG_IDPrompt Table: UPN_TYPE_FS
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
PV_MANU_MFG_VW(SQL View) |
Index Back |
|---|---|
Manufacturer view. |
| SELECT A.SETID , A.MFG_ID , A.DESCRSHORT , A.DESCR60 , A.UPN_TYPE_CD , A.LOCALLY_OWNED_FLG , A.GS1_GLN , A.DIRECT_PUR_FLG , A.VENDOR_SETID , A.VENDOR_ID FROM PS_MANUFACTURER A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Prompt Table: UPN_TYPE_FS |
| 6 | LOCALLY_OWNED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Locally Owned
Y/N Table Edit Default Value: N |
| 7 | GS1_GLN | Character(13) | VARCHAR2(13) NOT NULL | Manufacturer GLN |
| 8 | DIRECT_PUR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit Default Value: N |
| 9 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 10 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |