| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
OM_PARM_SEL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Type
A=All Customers
C=Specific Customer
G=Specific Customer Group
Default Value: A
|
| 6 |
OM_PARM_SEL_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Selection Options
CAT=Catalog Number
IBU=Inventory Business Unit
NON=None
PRG=Product Group
PRL=Price List
Default Value: NON
|
| 7 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_OM_NONVW
|
| 9 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUST_SLD_VW
|
| 10 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
CUSTGP_PRC_VW
Set Control Field: BUSINESS_UNIT
|
| 11 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 12 |
PRICE_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price List ID
Prompt Table:
EOEP_PRLSTID_VW
|
| 13 |
CATALOG_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Catalog Number
Prompt Table:
PRODCTLG_TBL
|
| 14 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
Prompt Table:
PRODGP_PRC_VW
Set Control Field: BUSINESS_UNIT
|