| # |
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 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 1
|
| 5 |
BUPRJACT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Selected BU / Proj / Activity
B=Selected Business Unit
E=All
P=Selected BU / Project
|
| 6 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
Default Value: E
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 8 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 9 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_VW
|
| 10 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 11 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 12 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 13 |
BUSINESS_UNIT_AWD |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_CA_NONVW
|
| 14 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_HDR_RQST_VW
|
| 15 |
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
Set Control Field: BUSINESS_UNIT_AWD
|
| 16 |
GM_ACCTG_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date Option
S=System Date
U=Specify Date
|
| 17 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 18 |
GM_FA_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Retroactive F&A Approval
A=Approved
N=No
Y=Yes
|
| 19 |
PURGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge History without Archive
|
| 20 |
RUN_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Program Run Code
1=Load ASSETGEN.ASC File
2=Load BOOKDATA.ASC File
3=Load LABLINFO.ASC File
4=Load PROPTMGR.ASC File
N=None
PRE=Preview Process
PRO=Procedural
RUN=Run Process
SET=Set Process
|
| 21 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|