| # |
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:
OPERATOR_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 |
LANGUAGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language
R=Recipient's Language
Default Value: O
|
| 5 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 7 |
CP_AREA |
Character(1) |
VARCHAR2(1) NOT NULL |
Functional Area Field
0=Distribution
1=Production
Default Value: 0
|
| 8 |
CP_TREE |
Character(18) |
VARCHAR2(18) NOT NULL |
Model Field
Prompt Table:
CP_TREE_HDR
|
| 9 |
RULE_NUMBER |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule
Prompt Table:
CP_RULE_HDR
|
| 10 |
REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
CP Report Type Field
D=Detail Report
S=Summary Report
Default Value: D
|
| 11 |
ACTION_INTL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
CP Action International Code Field
01=Condition
02=Secondary Variable
03=Global Variable
04=Option Variable
05=Internal Variable Override
06=Create External Parameter
07=Configuration Detail
08=Start Trace
09=End Trace
20=Page Generation
21=Page Validation
22=Configured Component
23=Purchase Item
24=Finalized Price
25=Finalized Cost
26=Finalized Date
27=Availability Date
28=Workflow
29=Kit Component
30=Component List
31=Operation Sequence
32=Generate Comment
33=Product Selector
34=Kit Generation
35=Finalized Weight
36=Finalized Volume
|
| 12 |
RULE_SRCH |
Character(18) |
VARCHAR2(18) NOT NULL |
Keyword Search
|
| 13 |
SHOW_RULE_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Inactive Rules
Y/N Table Edit
Default Value: Y
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
%EDITTABLE
|
| 15 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Prompt Table:
CP_PRDN_CMP_VW
|
| 16 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 17 |
MATRIX_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
CP Matrix ID Field
Prompt Table:
CP_MATRIX_HDR
|
| 18 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 19 |
CP_EFFDT |
Date(10) |
DATE |
Effective Date Field
Prompt Table:
CP_MTXLOADDT_VW
|
| 20 |
CP_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Matrix Detail file delimiter
,=Comma
/=Slash
:=Colon
;=Semicolon
\=Backslash
|=Bar
Default Value: ,
|
| 21 |
CP_MTXLOAD_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Matrix Detail Load Action
0=Upload from file
1=Download to file
Default Value: 1
|