| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PV_CP_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
CUP Sequence ID
|
| 3 |
PV_CP_CREATE_DATE |
Date(10) |
DATE |
CUP Create Date
|
| 4 |
PV_CP_ACTION |
Character(5) |
VARCHAR2(5) NOT NULL |
CUP Action
|
| 5 |
PV_CP_SUPPLIER_ID |
Number(3,0) |
SMALLINT NOT NULL |
CUP Supplier ID
|
| 6 |
PV_CP_TP_NAME |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP Partner Name
|
| 7 |
PV_MS_SUP_MPID |
Character(50) |
VARCHAR2(50) NOT NULL |
e
|
| 8 |
PV_CP_SPN |
Character(50) |
VARCHAR2(50) NOT NULL |
Supplier Part Number
|
| 9 |
PV_CP_PART_EXT |
Character(50) |
VARCHAR2(50) NOT NULL |
CUP Part Extension
|
| 10 |
PV_CP_UOM |
Character(12) |
VARCHAR2(12) NOT NULL |
CUP Unit of Measure
|
| 11 |
PV_CP_LIST_PRICE |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
CUP List Price
|
| 12 |
PV_CP_MPN |
Character(50) |
VARCHAR2(50) NOT NULL |
CUP Manufacturers Part Number
|
| 13 |
PV_CP_MFR_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Date Initials Issues Description
07/30/07 DH F-AHAYT-L64E0 increase length to 60 chars
|
| 14 |
PV_CP_CAT_LEVEL1 |
Character(120) |
VARCHAR2(120) NOT NULL |
Level 1 Description
|
| 15 |
PV_CP_CAT_LEVEL2 |
Character(120) |
VARCHAR2(120) NOT NULL |
Level 2 Description
|
| 16 |
PV_CP_CAT_LEVEL3 |
Character(120) |
VARCHAR2(120) NOT NULL |
Level 3 Description
|
| 17 |
PV_CP_CAT_LEVEL4 |
Character(120) |
VARCHAR2(120) NOT NULL |
Level 4 Description
|
| 18 |
PV_CP_ACCT_LEVEL1 |
Character(2) |
VARCHAR2(2) NOT NULL |
CUP Account Level 1
|
| 19 |
PV_CP_ACCT_LEVEL2 |
Character(2) |
VARCHAR2(2) NOT NULL |
CUP Account Level 2
|
| 20 |
PV_CP_ACCT_LEVEL3 |
Character(2) |
VARCHAR2(2) NOT NULL |
CUP Account Level 3
|
| 21 |
PV_CP_ACCT_LEVEL4 |
Character(2) |
VARCHAR2(2) NOT NULL |
CUP Account Level 4
|
| 22 |
PV_CP_LEAD_TIME |
Number(11,0) |
DECIMAL(11) NOT NULL |
CUP Lead Time
|
| 23 |
PV_CP_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
CUP Currency Code
|
| 24 |
PV_CP_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 25 |
PV_CP_QTY_MIN |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Minimum Quantity
|
| 26 |
PV_CP_SHORT_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Short Description
|
| 27 |
PV_CP_PURPOSE |
Character(50) |
VARCHAR2(50) NOT NULL |
Image Purpose
|
| 28 |
PV_CP_LOCATION |
Character(254) |
VARCHAR2(254) NOT NULL |
Image Location
|
| 29 |
PV_CP_DESC1 |
Long Character |
CLOB |
CUP Short Description
|
| 30 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 31 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 32 |
PV_CP_ITM_KEY |
Number(10,0) |
DECIMAL(10) NOT NULL |
MarketSite to Peoplesoft Item
|
| 33 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
|
| 34 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 35 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
|
| 36 |
PV_CP_PROCESS_DT |
DateTime(26) |
TIMESTAMP |
CUP Process Date
|
| 37 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 38 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 39 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 40 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 41 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
PO_ACCT_SET_VW
|
| 42 |
PV_CP_APPROVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Build as Approved
A=Approve MarketSite Item
P=Pending Approval
|
| 43 |
PV_CP_ITM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
MarketSite Item Status
1=Ready to Build Items
2=Invalid or Missing Supplier
3=Invalid or Missing Category
4=Item Already Exists
5=Invalid Unit of Measure
6=Processing Complete
7=Item to be inactivated
8=Price to be updated
9=Item to be updated
A=Item Doesn't Exist
B=Item Load Error
C=Exists in other catalog
D=Duplicate Items in catalog
|
| 44 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 45 |
PRICE_LIST |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Standard Price
|
| 46 |
PV_CO_CATEGORY_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
Cohera Category Id
|
| 47 |
PV_CO_CAT_PARENT |
Character(64) |
VARCHAR2(64) NOT NULL |
Cohera Category Parent
|
| 48 |
PV_CO_SCHEMA_NAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Cohera Catalog Name
|
| 49 |
PV_CP_EXPIRE_DT |
Date(10) |
DATE |
Expire Date
|
| 50 |
DFLT_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Default UOM
|
| 51 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 52 |
FILE_EXTENSION |
Character(4) |
VARCHAR2(4) NOT NULL |
File Extension
|
| 53 |
FILEPATH |
Character(30) |
VARCHAR2(30) NOT NULL |
File Information
|
| 54 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 55 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 56 |
PV_MS_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Input Source Type
1=CUP File (Access Database)
2=xCBL 3.0 XML File
3=Cohera
4=Catalog Management
5=Express Catalog
6=Item PriceList
|
| 57 |
PV_INACTIVE_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Inactive level
P=Item Supplier Price
V=Item Supplier
|
| 58 |
VNDR_CATALOG_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Vendor's Catalog Number
|
| 59 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 60 |
PV_NEWCAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Category flag
Y/N Table Edit
Default Value: N
|