| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPR_DEF_TBL_FS
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 5 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
%EDITTABLE
|
| 6 |
PV_CP_FILE_NAME |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP File Name
|
| 7 |
PV_CP_XCBL_FILE |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP File Name
|
| 8 |
PV_CP_IN_CLAUSE |
Character(30) |
VARCHAR2(30) NOT NULL |
CUP IN Clause
|
| 9 |
PV_CP_PROD_FILE |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP Product Input File
|
| 10 |
PV_CP_PRICE_FILE |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP Price Input File
|
| 11 |
PV_CP_ATTACH_FILE |
Character(100) |
VARCHAR2(100) NOT NULL |
CUP Attach Input File
|
| 12 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
Prompt Table:
SP_SETID_NONVW
|
| 13 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
SP_SETID_NONVW
|
| 14 |
PV_CP_APPROVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Build as Approved
A=Approve MarketSite Item
P=Pending Approval
Default Value: A
|
| 15 |
PV_CP_RERUN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Process Errors
Y/N Table Edit
Default Value: N
|
| 16 |
PV_MS_RUN_STS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Order Status Check
Y/N Table Edit
Default Value: Y
|
| 17 |
PV_MS_REPROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Process Errors
Y/N Table Edit
Default Value: Y
|
| 18 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PV_CP_TREE_VW
|
| 19 |
PV_CP_LOAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Item Load Process
Y/N Table Edit
Default Value: Y
|
| 20 |
PV_CP_INBD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Inbound Items Process
Y/N Table Edit
Default Value: Y
|
| 21 |
PV_CP_IMAGE_LOC |
Character(40) |
VARCHAR2(40) NOT NULL |
Item Image Sub Folder
|
| 22 |
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
Default Value: 1
|
| 23 |
PV_INACTIVE_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Inactive level
P=Item Supplier Price
V=Item Supplier
Default Value: P
|
| 24 |
PV_MS_REDISPATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Re-Dispatch
Y/N Table Edit
Default Value: N
|
| 25 |
PV_CO_SCHEMA_NAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Cohera Catalog Name
Prompt Table:
PV_CO_SCHEMAS
|
| 26 |
PV_CM_CATALOG_ID |
Character(32) |
VARCHAR2(32) NOT NULL |
Catalog ID
Prompt Table:
PV_CM_CAT_SRC
|
| 27 |
PV_CM_RUN_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Import categories only
Y/N Table Edit
Default Value: N
|
| 28 |
PV_CM_CAT_HIER_ID |
Character(32) |
VARCHAR2(32) NOT NULL |
Category Hierarchy ID
Prompt Table:
PV_CM_CAT_SRC1
|
| 29 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
PO_ACCT_SET_VW
|
| 30 |
PV_CO_AUTO_ITMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Item Load
Y/N Table Edit
Default Value: Y
|
| 31 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE3
|
| 32 |
PV_CO_BY_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process by date/time
Y/N Table Edit
Default Value: N
|
| 33 |
PV_CO_BY_PROD |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Product Categories only
Y/N Table Edit
Default Value: Y
|
| 34 |
PV_CO_SEG1 |
Character(2) |
VARCHAR2(2) NOT NULL |
UN/SPSC Segment From
|
| 35 |
PV_CO_SEG2 |
Character(2) |
VARCHAR2(2) NOT NULL |
UN/SPSC Segment To
|
| 36 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 37 |
PRICE_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Standard Price
Y/N Table Edit
Default Value: N
|
| 38 |
BU_UPD_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Update Price
Y/N Table Edit
Default Value: N
|
| 39 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
%EDITTABLE2
|
| 40 |
PV_CM_HIER_ID_NODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Hierarchy ID as Node
Y/N Table Edit
Default Value: Y
|
| 41 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
PV_CAT_DEST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Destination for the Catalog Items being loaded e.g. Master Items
1=Master
2=Express
Default Value: 1
|
| 43 |
ALL_MFG_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
All Manufacturers
Y/N Table Edit
Default Value: Y
|
| 44 |
ALL_SETID |
Character(1) |
VARCHAR2(1) NOT NULL |
All Item SetIDs
Y/N Table Edit
Default Value: Y
|
| 45 |
ALL_VENDORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Suppliers
Y/N Table Edit
Default Value: Y
|
| 46 |
DELETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Loaded Items
Y/N Table Edit
Default Value: Y
|
| 47 |
INSERT_NEW_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create New Items
N=Replace Rows Only
O=Create New Only
Y=New Items and Replace Rows
Y/N Table Edit
Default Value: Y
|
| 48 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
ITMLD_MFG_ID_VW
|
| 49 |
NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Assign ID
N=For All New Items
Y=When Item ID is not specified
Default Value: Y
|
| 50 |
UPDATE_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Create New Categories
Y/N Table Edit
Default Value: Y
|
| 51 |
UPDATE_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Inventory Item
Y/N Table Edit
Default Value: Y
|
| 52 |
UPDATE_ITM_VNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Item Supplier Tables
Y/N Table Edit
Default Value: Y
|
| 53 |
UPDATE_VNDR_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Item Supplier Price
Y/N Table Edit
Default Value: Y
|
| 54 |
USE_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing Dflts From Category
Y/N Table Edit
Default Value: Y
|
| 55 |
VNDR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VENDOR SETID
Prompt Table:
SP_SETID_NONVW
|
| 56 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
Default Value: ENG
|
| 57 |
PV_CP_INDEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Items to Search Index
|
| 58 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
%EDITTABLE4
|
| 59 |
PV_NONDYNAMICRANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Dynamic Range
|
| 60 |
PV_OVERWRTE_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Overwrite Existing Categories
|