| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
SCON_HDR
|
| 6 |
CNTRCT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Option
A=All Contracts
S=Single Contract
Default Value: A
|
| 7 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
CUSTGP_SCON_VW
|
| 8 |
CUST_GRP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Group Option
A=All Customer Groups
S=Single Customer Group
Default Value: A
|
| 9 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SLD1_VW
|
| 10 |
SOLD_TO_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sold To Customer Option
A=All Sold To Customers
S=Single Sold To Customer
Default Value: A
|
| 11 |
CONTRACT_TYPE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Buying Agreement Type
Prompt Table:
CONTRACT_TYPE
|
| 12 |
CNTRCT_TYPE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Type Option
A=All Contract Types
S=Single Contract Type
Default Value: A
|
| 13 |
PRINT_ORD_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Order Details
Y/N Table Edit
Default Value: Y
|
| 14 |
ORDER_TYPE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote
SO=Sales Order
Default Value: SO
|
| 15 |
SORT_OPTION_SCON |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Option
1=Sold To Customer ID
2=Customer Group
3=Buying Agreement ID
4=Buying Agreement Type
Default Value: 3
|
| 16 |
SUMMARY_PAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Page Only
Y/N Table Edit
Default Value: N
|